When I do:
MariaDB [db_webqtl]> SELECT StrainId,Strain.Name FROM Strain, StrainXRef WHERE StrainXRef.StrainId = Strain.Id AND StrainXRef.InbredSetId = 1;
I get a list of BXDs (good), but also
| 333 | BXH2 | | 334 | BXH3 | | 336 | BXH5 | | 342 | BXH11 | | 343 | BXH12 | | 43879 | BXH12a | | 43880 | BXH13 | | 43881 | HXB1 | | 43882 | HXB2 | | 43883 | HXB3 | | 43884 | HXB4 |
This is probably wrong?
MariaDB [db_webqtl]> select * from InbredSet where InbredSetId=1 limit 3;
+----+-------------+---------------+------+-----------+------------+--------+-----------------+-------------+---------------------------------
-----------------+-------------+-------------+---------------+
| Id | InbredSetId | InbredSetName | Name | SpeciesId | FullName | public | MappingMethodId | GeneticType | Family
| FamilyOrder | MenuOrderId | InbredSetCode |
+----+-------------+---------------+------+-----------+------------+--------+-----------------+-------------+---------------------------------
-----------------+-------------+-------------+---------------+
| 1 | 1 | BXD | BXD | 1 | BXD Family | 2 | 1 | riset | Reference Populations (replicate
average, SE, N) | 1 | 0 | BXD |
+----+-------------+---------------+------+-----------+------------+--------+-----------------+-------------+---------------------------------
-----------------+-------------+-------------+---------------+
MariaDB [db_webqtl]> select * from StrainXRef where InbredSetId=1 and StrainID=43889 limit 3;
+-------------+----------+---------+------------------+----------------+
| InbredSetId | StrainId | OrderId | Used_for_mapping | PedigreeStatus |
+-------------+----------+---------+------------------+----------------+
| 1 | 43889 | 1247 | N | NULL |
+-------------+----------+---------+------------------+----------------+
Not a BXD. Not even a mouse.