metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA326068" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA326068" 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
389434	389434	PRJNA326068_P_NODE_17861_length_183_cov_2.259740_g16898_i0	PRJNA326068	17861	183	2.25974	4.1353242	Mus musculus	10090	Chordata	Chordata	339	1.07e-88	NTclustered	gi\|1907194824\|ref\|XM_036154592.1\|	10090	g16898	i0	100	99.9781420765027	183	0	100	0	1	183	734	552	PREDICTED: Mus musculus crystallin, alpha B (Cryab), transcript variant X1, mRNA	blastn	18296	339	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
1664147	1664147	PRJNA326068_P_NODE_2342_length_714_cov_2.937226_g1790_i0	PRJNA326068	2342	714	2.937226	20.97179364	Mus musculus	10090	Chordata	Chordata	1277	0	NTclustered	gi\|111598636\|gb\|BC085170.1\|	10090	g1790	i0	98.459	75.078431372549	714	11	100	0	1	714	1067	354	Mus musculus crystallin, alpha A, mRNA (cDNA clone MGC:115745 IMAGE:30699322), complete cds	blastn	53606	1277	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
2344455	2344455	PRJNA326068_P_NODE_13022_length_251_cov_1.279279_g12059_i0	PRJNA326068	13022	251	1.279279	3.21099029	Mus	10088	Chordata	Chordata	226	1.2699999999999999e-54	NTclustered	gi\|74148625\|dbj\|AK140187.1\|	10090	g12059	i0	100	73.7051792828685	122	0	74	0	130	251	233	112	Mus musculus adult male corpora quadrigemina cDNA, RIKEN full-length enriched library, clone:B230333I23 product:NADH dehydrogenase 4, mitochondrial, full insert sequence	blastn	18500	226	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
2344468	2344468	PRJNA326068_P_NODE_1942_length_774_cov_5.926174_g1451_i0	PRJNA326068	1942	774	5.926174	45.86858676	Mus	10088	Chordata	Chordata	1428	0	NTclustered	gi\|846387786\|dbj\|LC061991.1\|	10090	g1451	i0	100	99.8708010335917	773	0	99	0	2	774	1316	544	Mus musculus mitochondrion DNA, including ATP6, COX3, tRNA-Gly, ND3, tRNA-Arg, ND4L, ND4 genes, complete sequence, sequence_id: (8070..10988)_18	blastn	77300	1428	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
3619866	3619866	PRJNA326068_P_NODE_19943_length_152_cov_1.878049_g18980_i0	PRJNA326068	19943	152	1.878049	2.85463448	Mus	10088	Chordata	Chordata	281	1.46e-71	NTclustered	gi\|1679831893\|ref\|XM_021151482.2\|	10089	g18980	i0	100	98.5460526315789	152	0	100	0	1	152	808	959	PREDICTED: Mus caroli retinal outer segment membrane protein 1 (Rom1), mRNA	blastn	14979	281	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus caroli
4216713	4216713	PRJNA326068_P_NODE_15724_length_212_cov_2.431694_g14761_i0	PRJNA326068	15724	212	2.431694	5.15519128	Mus musculus	10090	Chordata	Chordata	390	3.48e-104	NTclustered	gi\|1566846636\|ref\|NM_010314.3\|	10090	g14761	i0	100	96.9198113207547	211	0	99	0	1	211	308	98	Mus musculus guanine nucleotide binding protein (G protein), gamma transducing activity polypeptide 1 (Gngt1), mRNA	blastn	20547	390	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6172088	6172088	PRJNA326068_P_NODE_4325_length_532_cov_2.250497_g3550_i0	PRJNA326068	4325	532	2.250497	11.97264404	Mus	10088	Chordata	Chordata	983	0	NTclustered	gi\|756142290\|gb\|KP260515.1\|	10090	g3550	i0	100	100	532	0	100	0	1	532	10471	11002	Mus musculus strain ME mitochondrion, complete genome	blastn	53200	983	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6767015	6767015	PRJNA326068_P_NODE_1226_length_949_cov_2.563043_g877_i0	PRJNA326068	1226	949	2.563043	24.32327807	Mus musculus	10090	Chordata	Chordata	1698	0	NTclustered	gi\|74138278\|dbj\|AK149254.1\|	10090	g877	i0	98.531	32.3087460484721	953	10	100	1	1	949	1318	2270	Mus musculus adult retina cDNA, RIKEN full-length enriched library, clone:A930002G18 product:guanine nucleotide binding protein, alpha transducing 1, full insert sequence	blastn	30661	1698	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6767021	6767021	PRJNA326068_P_NODE_13146_length_249_cov_1.904545_g12183_i0	PRJNA326068	13146	249	1.904545	4.74231705	Mus musculus	10090	Chordata	Chordata	455	1.47e-123	NTclustered	gi\|10441737\|gb\|AF190928.1\|AF190928	10090	g12183	i0	99.598	45.5020080321285	249	1	100	0	1	249	194	442	Mus musculus cGMP-phosphodiesterase 6 gamma subunit mRNA, complete cds	blastn	11330	455	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7447066	7447066	PRJNA326068_P_NODE_1666_length_833_cov_5.194030_g1240_i0	PRJNA326068	1666	833	5.19403	43.2662699	Mus	10088	Chordata	Chordata	1539	0	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g1240	i0	100	100	833	0	100	0	1	833	2651	1819	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	83300	1539	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7447090	7447090	PRJNA326068_P_NODE_8326_length_362_cov_2.258258_g7378_i0	PRJNA326068	8326	362	2.258258	8.17489396	Mus	10088	Chordata	Chordata	662	0	NTclustered	gi\|846387457\|dbj\|LC061936.1\|	10090	g7378	i0	99.724	100	362	0	100	1	1	362	502	142	Mus musculus mitochondrion DNA, including ND2, tRNA-Trp, tRNA-Ala, tRNA-Asn, tRNA-Cys, tRNA-Tyr, COX1 genes, complete sequence, sequence_id: (4078..6548)_6	blastn	36200	662	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9317470	9317470	PRJNA326068_P_NODE_5548_length_469_cov_2.018182_g4709_i0	PRJNA326068	5548	469	2.018182	9.46527358	Mus musculus	10090	Chordata	Chordata	867	0	NTclustered	gi\|927354948\|ref\|NM_009965.3\|	10090	g4709	i0	100	98.3070362473348	469	0	100	0	1	469	773	305	Mus musculus crystallin, beta A1 (Cryba1), transcript variant 1, mRNA	blastn	46106	867	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9997329	9997329	PRJNA326068_P_NODE_18828_length_167_cov_2.130435_g17865_i0	PRJNA326068	18828	167	2.130435	3.55782645	Mus	10088	Chordata	Chordata	309	7.53e-80	NTclustered	gi\|756142290\|gb\|KP260515.1\|	10090	g17865	i0	100	100	167	0	100	0	1	167	11342	11176	Mus musculus strain ME mitochondrion, complete genome	blastn	16700	309	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9997334	9997334	PRJNA326068_P_NODE_2648_length_674_cov_7.127132_g2052_i0	PRJNA326068	2648	674	7.127132	48.03686968	Mus	10088	Chordata	Chordata	1245	0	NTclustered	gi\|846387676\|dbj\|LC061971.1\|	10090	g2052	i0	100	100	674	0	100	0	1	674	1744	1071	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_20	blastn	67400	1245	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11272381	11272381	PRJNA326068_P_NODE_18769_length_168_cov_2.359712_g17806_i0	PRJNA326068	18769	168	2.359712	3.96431616	Mus	10088	Chordata	Chordata	311	2.11e-80	NTclustered	gi\|756142290\|gb\|KP260515.1\|	10090	g17806	i0	100	100	168	0	100	0	1	168	13246	13413	Mus musculus strain ME mitochondrion, complete genome	blastn	16800	311	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13822613	13822613	PRJNA326068_P_NODE_12051_length_270_cov_2.153527_g11088_i0	PRJNA326068	12051	270	2.153527	5.8145229	Mus	10088	Chordata	Chordata	497	2.6399999999999998e-136	NTclustered	gi\|846387457\|dbj\|LC061936.1\|	10090	g11088	i0	100	99.6296296296296	269	0	99	0	1	269	592	860	Mus musculus mitochondrion DNA, including ND2, tRNA-Trp, tRNA-Ala, tRNA-Asn, tRNA-Cys, tRNA-Tyr, COX1 genes, complete sequence, sequence_id: (4078..6548)_6	blastn	26900	497	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14418282	14418282	PRJNA326068_P_NODE_2712_length_666_cov_78.116170_g2113_i0	PRJNA326068	2712	666	78.11617	520.2536922	Odocoileus virginianus	9874	Chordata	Chordata	226	3.69e-54	NTclustered	gi\|2871638769\|ref\|XR_011486207.1\|	9874	g2113	i0	82.772	48.1456456456456	267	33	40	7	403	666	2848	3104	PREDICTED: Odocoileus virginianus 28S ribosomal RNA (LOC139033727), rRNA	blastn	32065	226	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Odocoileus	Odocoileus virginianus
15692117	15692117	PRJNA326068_P_NODE_4553_length_518_cov_2.411043_g3767_i0	PRJNA326068	4553	518	2.411043	12.48920274	Mus musculus	10090	Chordata	Chordata	324	9.74e-84	NTclustered	gi\|2904935057\|gb\|PQ737980.1\|	10090	g3767	i0	84.639	7.7007722007722	332	43	64	8	167	495	384	58	Mus musculus lncRNA390 lncRNA, complete sequence	blastn	3989	324	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16966759	16966759	PRJNA326068_P_NODE_12254_length_266_cov_1.459916_g11291_i0	PRJNA326068	12254	266	1.459916	3.88337656	Mus musculus	10090	Chordata	Chordata	207	4.91e-49	NTclustered	gi\|56236246\|gb\|AC142099.3\|	10090	g11291	i0	100	9.56766917293233	112	0	84	0	155	266	14055	14166	Mus musculus BAC clone RP24-350H4 from 6, complete sequence	blastn	2545	207	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
18241057	18241057	PRJNA326068_P_NODE_17875_length_183_cov_1.896104_g16912_i0	PRJNA326068	17875	183	1.896104	3.46987032	Arvicanthis niloticus	61156	Chordata	Chordata	278	2.36e-70	NTclustered	gi\|1842194176\|ref\|XM_034501650.1\|	61156	g16912	i0	94.022	63.5901639344262	184	10	100	1	1	183	203	20	PREDICTED: Arvicanthis niloticus G protein subunit beta 1 (Gnb1), transcript variant X2, mRNA	blastn	11637	278	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Arvicanthis	Arvicanthis niloticus
20195244	20195244	PRJNA326068_P_NODE_14056_length_233_cov_3.073529_g13093_i0	PRJNA326068	14056	233	3.073529	7.16132257	Mus	10088	Chordata	Chordata	431	2.2899999999999996e-116	NTclustered	gi\|2746383733\|gb\|PP914355.1\|	10090	g13093	i0	100	100	233	0	100	0	1	233	145	377	Mus musculus isolate SK2261 cytochrome b (CYTB) gene, partial cds; mitochondrial	blastn	23300	431	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20790914	20790914	PRJNA326068_P_NODE_17917_length_182_cov_2.679739_g16954_i0	PRJNA326068	17917	182	2.679739	4.87712498	Peromyscus californicus	42520	Chordata	Chordata	63.9	7.15e-6	NTclustered	gi\|2414837913\|ref\|XR_008213180.1\|	564181	g16954	i0	93.182	1.23626373626374	44	1	24	2	137	179	2485	2443	PREDICTED: Peromyscus californicus insignis uncharacterized LOC128095182 (LOC128095182), transcript variant X2, ncRNA	blastn	225	63.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Peromyscus	Peromyscus californicus
23341337	23341337	PRJNA326068_P_NODE_19179_length_162_cov_1.864662_g18216_i0	PRJNA326068	19179	162	1.864662	3.02075244	Mus musculus	10090	Chordata	Chordata	298	1.57e-76	NTclustered	gi\|56236246\|gb\|AC142099.3\|	10090	g18216	i0	100	15.9074074074074	161	0	99	0	1	161	15879	15719	Mus musculus BAC clone RP24-350H4 from 6, complete sequence	blastn	2577	298	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24615522	24615522	PRJNA326068_P_NODE_16800_length_201_cov_1.343023_g15837_i0	PRJNA326068	16800	201	1.343023	2.69947623	Mus musculus	10090	Chordata	Chordata	372	1.18e-98	NTclustered	gi\|21595048\|gb\|BC031367.1\|	10090	g15837	i0	100	60.3432835820896	201	0	100	0	1	201	699	499	Mus musculus guanylate cyclase activator 1B, mRNA (cDNA clone MGC:36465 IMAGE:5358667), complete cds	blastn	12129	372	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24615546	24615546	PRJNA326068_P_NODE_4640_length_513_cov_2.402893_g3847_i0	PRJNA326068	4640	513	2.402893	12.32684109	Mus musculus	10090	Chordata	Chordata	939	0	NTclustered	gi\|56236246\|gb\|AC142099.3\|	10090	g3847	i0	99.612	23.906432748538	515	0	100	1	1	513	16529	16015	Mus musculus BAC clone RP24-350H4 from 6, complete sequence	blastn	12264	939	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
25295419	25295419	PRJNA326068_P_NODE_17560_length_189_cov_1.562500_g16597_i0	PRJNA326068	17560	189	1.5625	2.953125	Mus	10088	Chordata	Chordata	350	5.14e-92	NTclustered	gi\|354788355\|gb\|JN952856.1\|	10090	g16597	i0	100	99.8465608465608	189	0	100	0	1	189	6730	6542	Mus musculus targeted non-conditional, lacZ-tagged mutant allele Prph2:tm1e(EUCOMM)Hmgu; transgenic	blastn	18871	350	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);;