metadata: contig_metadata: 28 rows where bioproject = "PRJNA1008049" and tax

28 rows where bioproject = "PRJNA1008049" and tax_phylum = "Chordata"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2703994	2703994	PRJNA1008049_S_NODE_3603_length_162_cov_6.894737_g3585_i0	PRJNA1008049	3603	162	6.894737	11.16947394	Mus musculus	10090	Chordata	Chordata	283	4.39e-72	NTclustered	gi\|81778322\|gb\|AC145556.4\|	10090	g3585	i0	99.359	0.962962962962963	156	1	96	0	1	156	118084	117929	Mus musculus BAC clone RP23-308E7 from chromosome 8, complete sequence	blastn	156	283	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
3980216	3980216	PRJNA1008049_S_NODE_2864_length_170_cov_6.475177_g2846_i0	PRJNA1008049	2864	170	6.475177	11.0078009	Mus musculus	10090	Chordata	Chordata	315	1.64e-81	NTclustered	gi\|354784839\|gb\|JN949340.1\|	10090	g2846	i0	100	4.65294117647059	170	0	100	0	1	170	31542	31711	Mus musculus targeted non-conditional, lacZ-tagged mutant allele Opn3:tm1e(EUCOMM)Wtsi; transgenic	blastn	791	315	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
3980233	3980233	PRJNA1008049_S_NODE_4564_length_154_cov_6.824000_g4546_i0	PRJNA1008049	4564	154	6.824	10.50896	Ovis aries	9940	Chordata	Chordata	200	4.27e-47	NTclustered	gi\|2607057724\|ref\|XM_060411022.1\|	9940	g4546	i0	92.857	404.019480519481	140	7	90	3	3	141	10772	10635	PREDICTED: Ovis aries large ribosomal subunit protein uL6-like (LOC101110567), transcript variant X3, mRNA	blastn	62219	200	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
6104446	6104446	PRJNA1008049_S_NODE_1685_length_187_cov_14.120253_g1667_i0	PRJNA1008049	1685	187	14.120253	26.40487311	Mus	10088	Chordata	Chordata	344	2.36e-90	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g1667	i0	100	99.4652406417112	186	0	99	0	2	187	2344	2529	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	18600	344	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6104457	6104457	PRJNA1008049_S_NODE_4985_length_151_cov_9.491803_g4967_i0	PRJNA1008049	4985	151	9.491803	14.33262253	Mus	10088	Chordata	Chordata	276	6.72e-70	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g4967	i0	100	98.6754966887417	149	0	99	0	2	150	2141	1993	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	14900	276	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6531950	6531950	PRJNA1008049_S_NODE_2966_length_169_cov_4.100000_g2948_i0	PRJNA1008049	2966	169	4.1	6.929	Mus musculus	10090	Chordata	Chordata	313	5.859999999999999e-81	NTclustered	gi\|73912772\|gb\|AC163219.3\|	10090	g2948	i0	100	2	169	0	100	0	1	169	127203	127035	Mus musculus chromosome 5, clone RP24-155K17, complete sequence	blastn	338	313	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6531966	6531966	PRJNA1008049_S_NODE_4206_length_157_cov_3.945312_g4188_i0	PRJNA1008049	4206	157	3.945312	6.19413984	Mus musculus	10090	Chordata	Chordata	287	3.26e-73	NTclustered	gi\|52353862\|gb\|AC116875.10\|	10090	g4188	i0	100	77.9235668789809	155	0	99	0	1	155	50804	50650	Mus musculus chromosome 8, clone RP24-426B21, complete sequence	blastn	12234	287	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7806322	7806322	PRJNA1008049_S_NODE_1327_length_197_cov_3.059524_g1309_i0	PRJNA1008049	1327	197	3.059524	6.02726228	Bos taurus	9913	Chordata	Chordata	213	7.39e-51	NTclustered	gi\|163333\|gb\|M95099.1\|BOVLYSOZMC	9913	g1309	i0	86.07	1.02030456852792	201	24	100	2	1	197	1368	1568	Bos taurus lysozyme gene (cow 3), complete cds	blastn	201	213	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
7806340	7806340	PRJNA1008049_S_NODE_3347_length_165_cov_3.132353_g3329_i0	PRJNA1008049	3347	165	3.132353	5.16838245	Mus musculus	10090	Chordata	Chordata	305	9.59e-79	NTclustered	gi\|50811792\|gb\|AC141869.5\|	10090	g3329	i0	100	1	165	0	100	0	1	165	106662	106826	Mus musculus BAC clone RP24-424D1 from 8, complete sequence	blastn	165	305	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9081282	9081282	PRJNA1008049_S_NODE_3428_length_164_cov_4.859259_g3410_i0	PRJNA1008049	3428	164	4.859259	7.96918476	Mus musculus	10090	Chordata	Chordata	303	3.42e-78	NTclustered	gi\|67846286\|gb\|AC124526.6\|	10090	g3410	i0	100	3	164	0	100	0	1	164	195857	196020	Mus musculus BAC clone RP23-406P13 from chromosome 18, complete sequence	blastn	492	303	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10356936	10356936	PRJNA1008049_S_NODE_2669_length_173_cov_4.625000_g2651_i0	PRJNA1008049	2669	173	4.625	8.00125	Mus musculus	10090	Chordata	Chordata	318	1.3e-82	NTclustered	gi\|20428844\|emb\|AL603924.18\|	10090	g2651	i0	100	0.994219653179191	172	0	99	0	2	173	172206	172035	Mouse DNA sequence from clone RP23-188C13 on chromosome 11, complete sequence	blastn	172	318	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10356959	10356959	PRJNA1008049_S_NODE_4689_length_153_cov_9.895161_g4671_i0	PRJNA1008049	4689	153	9.895161	15.13959633	Mus musculus	10090	Chordata	Chordata	283	4.0799999999999995e-72	NTclustered	gi\|23497891\|emb\|AL627425.15\|	10090	g4671	i0	100	1	153	0	100	0	1	153	97896	97744	Mouse DNA sequence from clone RP23-283L16 on chromosome 4, complete sequence	blastn	153	283	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11632405	11632405	PRJNA1008049_S_NODE_4930_length_152_cov_2.577236_g4912_i0	PRJNA1008049	4930	152	2.577236	3.91739872	Mus musculus	10090	Chordata	Chordata	276	6.770000000000001e-70	NTclustered	gi\|24158593\|gb\|AC116597.3\|	10090	g4912	i0	99.342	2	152	1	100	0	1	152	48838	48989	Mus musculus BAC clone RP24-409C23 from chromosome 18, complete sequence	blastn	304	276	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
12907499	12907499	PRJNA1008049_S_NODE_3331_length_165_cov_5.404412_g3313_i0	PRJNA1008049	3331	165	5.404412	8.9172798	Mus musculus	10090	Chordata	Chordata	305	9.59e-79	NTclustered	gi\|564112222\|ref\|NG_033854.1\|	10090	g3313	i0	100	3	165	0	100	0	1	165	1551	1715	Mus musculus predicted gene 6185 (Gm6185) pseudogene on chromosome 1	blastn	495	305	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
12907512	12907512	PRJNA1008049_S_NODE_4571_length_154_cov_6.376000_g4553_i0	PRJNA1008049	4571	154	6.376	9.81904	Mus musculus	10090	Chordata	Chordata	281	1.48e-71	NTclustered	gi\|46309678\|gb\|AC127339.3\|	10090	g4553	i0	100	38.3506493506493	152	0	99	0	3	154	126062	125911	Mus musculus BAC clone RP23-180G16 from chromosome 5, complete sequence	blastn	5906	281	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15029045	15029045	PRJNA1008049_S_NODE_2432_length_176_cov_28.020408_g2414_i0	PRJNA1008049	2432	176	28.020408	49.31591808	Suidae	9821	Chordata	Chordata	89.8	1.13e-13	NTclustered	gi\|1191809798\|ref\|XM_021063278.1\|	9823	g2414	i0	100	2.74431818181818	48	0	27	0	2	49	1810	1763	PREDICTED: Sus scrofa centlein (CNTLN), transcript variant X2, mRNA	blastn	483	89.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
15456412	15456412	PRJNA1008049_S_NODE_2213_length_178_cov_3.530201_g2195_i0	PRJNA1008049	2213	178	3.530201	6.28375778	Mus musculus	10090	Chordata	Chordata	329	6.21e-86	NTclustered	gi\|19572419\|emb\|AL591843.14\|	10090	g2195	i0	100	88.0730337078652	178	0	100	0	1	178	41895	42072	Mouse DNA sequence from clone RP23-351I6 on chromosome 13, complete sequence	blastn	15677	329	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16730683	16730683	PRJNA1008049_S_NODE_3694_length_161_cov_7.492424_g3676_i0	PRJNA1008049	3694	161	7.492424	12.06280264	Mus musculus	10090	Chordata	Chordata	291	2.6e-74	NTclustered	gi\|354794602\|gb\|JN959103.1\|	10090	g3676	i0	99.375	15.832298136646	160	1	99	0	2	161	8604	8763	Mus musculus targeted non-conditional, lacZ-tagged mutant allele Gm15319:tm1e(KOMP)Wtsi; transgenic	blastn	2549	291	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16730687	16730687	PRJNA1008049_S_NODE_3834_length_160_cov_4.160305_g3816_i0	PRJNA1008049	3834	160	4.160305	6.656488	Bos taurus	9913	Chordata	Chordata	244	2.04e-60	NTclustered	gi\|2587629758\|ref\|XM_059892185.1\|	9913	g3816	i0	94.34	447.85625	159	9	99	0	2	160	18009	17851	PREDICTED: Bos taurus kelch repeat and BTB domain containing 7 (KBTBD7), mRNA	blastn	71657	244	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
16730690	16730690	PRJNA1008049_S_NODE_4274_length_156_cov_11.259843_g4256_i0	PRJNA1008049	4274	156	11.259843	17.56535508	Canis lupus	9612	Chordata	Chordata	206	9.32e-49	NTclustered	gi\|2272704403\|ref\|XR_007411874.1\|	286419	g4256	i0	94.737	268.461538461538	133	5	84	1	3	133	1145	1013	PREDICTED: Canis lupus dingo uncharacterized LOC125755402 (LOC125755402), ncRNA	blastn	41880	206	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
19279358	19279358	PRJNA1008049_S_NODE_5176_length_150_cov_7.603306_g5158_i0	PRJNA1008049	5176	150	7.603306	11.404959	Sus scrofa	9823	Chordata	Chordata	278	1.85e-70	NTclustered	gi\|121410603\|emb\|CT737281.12\|	9823	g5158	i0	100	160.413333333333	150	0	100	0	1	150	167939	167790	Pig DNA sequence from clone CH242-102G9 on chromosome 7, complete sequence	blastn	24062	278	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
20554982	20554982	PRJNA1008049_S_NODE_3037_length_168_cov_6.230216_g3019_i0	PRJNA1008049	3037	168	6.230216	10.46676288	Mus musculus	10090	Chordata	Chordata	311	2.11e-80	NTclustered	gi\|226693487\|gb\|AC226122.3\|	10090	g3019	i0	100	2	168	0	100	0	1	168	200164	200331	Mus musculus BAC clone RP23-111I13 from chromosome 16, complete sequence	blastn	336	311	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22678111	22678111	PRJNA1008049_S_NODE_3918_length_159_cov_6.346154_g3900_i0	PRJNA1008049	3918	159	6.346154	10.09038486	Bovidae	9895	Chordata	Chordata	206	9.55e-49	NTclustered	gi\|2633725485\|ref\|XM_061438761.1\|	9906	g3900	i0	96.032	750.88679245283	126	5	79	0	1	126	2507	2632	PREDICTED: Bos javanicus regulator of G protein signaling 20 (RGS20), transcript variant X1, mRNA	blastn	119391	206	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
23106060	23106060	PRJNA1008049_S_NODE_4019_length_158_cov_11.240310_g4001_i0	PRJNA1008049	4019	158	11.24031	17.7596898	Mus musculus	10090	Chordata	Chordata	289	9.14e-74	NTclustered	gi\|21537445\|emb\|AL606976.25\|	10090	g4001	i0	100	18.5886075949367	156	0	99	0	3	158	51598	51443	Mouse DNA sequence from clone RP23-113P22 on chromosome 4, complete sequence	blastn	2937	289	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
30216476	30216476	PRJNA1008049_S_NODE_3012_length_168_cov_10.345324_g2994_i0	PRJNA1008049	3012	168	10.345324	17.38014432	root	1	Root_unresolved	Root_unresolved	120	7.43e-30	NR	XP_030109804.2	10090	g2994	i0	100	10.8035714285714	55	0	98.2	0	167	3	89	143	XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus]	diamond	1815	120	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
30343511	30343511	PRJNA1008049_S_NODE_1252_length_199_cov_8.994118_g1234_i0	PRJNA1008049	1252	199	8.994118	17.89829482	root	1	Root_unresolved	Root_unresolved	133	9.439999999999999e-35	NR	XP_030110853.2	10090	g1234	i0	100	14.6984924623116	65	0	98	0	3	197	122	186	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	2925	133	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
30406535	30406535	PRJNA1008049_S_NODE_213_length_311_cov_4.234043_g195_i0	PRJNA1008049	213	311	4.234043	13.16787373	root	1	Root_unresolved	Root_unresolved	152	2.51e-42	NR	XP_036010302.1	10090	g195	i0	97.3	9.27974276527331	74	2	71.4	0	3	224	40	113	XP_036010302.1 uncharacterized protein Gm53410 [Mus musculus]	diamond	2886	152	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
31195670	31195670	PRJNA1008049_S_NODE_395_length_262_cov_6.669528_g377_i0	PRJNA1008049	395	262	6.669528	17.47416336	root	1	Root_unresolved	Root_unresolved	183	6.25e-53	NR	XP_030110853.2	10090	g377	i0	100	14.8969465648855	87	0	99.6	0	1	261	236	322	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	3903	183	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;