metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA421571" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA421571" and tax_phylum = "Rotifera"

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
422255	422255	PRJNA421571_P_NODE_18821_length_831_cov_8.254617_g16626_i0	PRJNA421571	18821	831	8.254617	68.59586727	Philodina citrina	468664	Rotifera	other_Eukaryota	588	5.149999999999999e-163	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g16626	i0	80.566	1.69795427196149	777	139	93	12	62	831	3110	3881	Philodina citrina complete mitochondrial genome	blastn	1411	588	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
1697418	1697418	PRJNA421571_P_NODE_29142_length_603_cov_2.462264_g26625_i0	PRJNA421571	29142	603	2.462264	14.84745192	Adineta ricciae	249248	Rotifera	other_Eukaryota	147	2.66e-30	NTclustered	gi\|156254741\|gb\|EF554866.1\|	249248	g26625	i0	74.566	0.57379767827529	346	82	57	4	2	344	802	1144	Adineta ricciae lea-1A mRNA, complete cds	blastn	346	147	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
1698116	1698116	PRJNA421571_P_NODE_50742_length_385_cov_2.403846_g48194_i0	PRJNA421571	50742	385	2.403846	9.2548071	Adineta vaga	104782	Rotifera	other_Eukaryota	359	1.93e-94	NTclustered	gi\|187233665\|gb\|EU643499.1\|	104782	g48194	i0	84.097	0.963636363636364	371	59	96	0	14	384	1	371	Adineta vaga ribosomal protein L26 mRNA, partial cds	blastn	371	359	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
5526086	5526086	PRJNA421571_P_NODE_23585_length_710_cov_2.640502_g21160_i0	PRJNA421571	23585	710	2.640502	18.7475642	Adineta ricciae	249248	Rotifera	other_Eukaryota	617	5.58e-172	NTclustered	gi\|62362195\|gb\|AY942837.1\|	249248	g21160	i0	83.408	0.942253521126761	669	107	94	4	1	669	19	683	Adineta ricciae ribosomal protein S7-like protein mRNA, complete cds	blastn	669	617	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
5526781	5526781	PRJNA421571_P_NODE_44305_length_429_cov_1.727528_g41757_i0	PRJNA421571	44305	429	1.727528	7.41109512	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	448	4.519999999999999e-121	NTclustered	gi\|402761789\|gb\|JX184026.1\|	104786	g41757	i0	85.986	28.6806526806527	421	55	98	4	1	419	484	902	Habrotrocha constricta cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	12304	448	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
8738424	8738424	PRJNA421571_P_NODE_28907_length_606_cov_5.043152_g26391_i0	PRJNA421571	28907	606	5.043152	30.56150112	Philodinida	104783	Rotifera	other_Eukaryota	656	0	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g26391	i0	86.949	18.0280528052805	590	70	97	5	2	587	49	635	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	10925	660	0.993939393939394	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
9350413	9350413	PRJNA421571_P_NODE_21328_length_762_cov_4.914369_g18980_i0	PRJNA421571	21328	762	4.914369	37.44749178	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	808	0	NTclustered	gi\|402761773\|gb\|JX184018.1\|	104786	g18980	i0	85.958	10.0498687664042	762	99	99	7	4	761	4	761	Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	7658	808	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
9351127	9351127	PRJNA421571_P_NODE_42868_length_441_cov_1.163043_g40320_i0	PRJNA421571	42868	441	1.163043	5.12901963	Adineta ricciae	249248	Rotifera	other_Eukaryota	307	8.240000000000001e-79	NTclustered	gi\|62362193\|gb\|AY942836.1\|	249248	g40320	i0	79.642	1.01360544217687	447	75	99	13	1	438	21	460	Adineta ricciae 60S ribosomal protein L37-like protein mRNA, complete cds	blastn	447	307	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
10626757	10626757	PRJNA421571_P_NODE_37809_length_488_cov_5.303614_g35265_i0	PRJNA421571	37809	488	5.303614	25.88163632	Philodina citrina	468664	Rotifera	other_Eukaryota	497	5.09e-136	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g35265	i0	85.185	22.983606557377	486	71	99	1	3	488	4793	5277	Philodina citrina complete mitochondrial genome	blastn	11216	497	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
10627208	10627208	PRJNA421571_P_NODE_52409_length_376_cov_1.211221_g49860_i0	PRJNA421571	52409	376	1.211221	4.55419096	Plationus patulus	360686	Rotifera	other_Eukaryota	307	6.920000000000001e-79	NTclustered	gi\|83321197\|gb\|DQ297812.1\|	360686	g49860	i0	84.516	86.6515957446808	310	48	82	0	1	310	310	1	Plationus patulus histone H3 gene, partial cds	blastn	32581	307	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Plationus	Plationus patulus
11902156	11902156	PRJNA421571_P_NODE_53770_length_368_cov_4.481356_g51221_i0	PRJNA421571	53770	368	4.481356	16.49139008	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	361	5.11e-95	NTclustered	gi\|402761805\|gb\|JX184034.1\|	104786	g51221	i0	84.741	28.758152173913	367	48	99	7	1	363	366	728	Habrotrocha constricta NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial	blastn	10583	361	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
13176411	13176411	PRJNA421571_P_NODE_31551_length_566_cov_2.135903_g29020_i0	PRJNA421571	31551	566	2.135903	12.08921098	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	442	2.8299999999999985e-119	NTclustered	gi\|402761883\|gb\|JX184073.1\|	104786	g29020	i0	80.844	8.18197879858657	569	103	100	5	1	566	367	932	Habrotrocha constricta NADH dehydrogenase subunit 5 (ND5) gene, partial cds; mitochondrial	blastn	4631	442	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
14453325	14453325	PRJNA421571_P_NODE_94252_length_249_cov_2.187500_g91703_i0	PRJNA421571	94252	249	2.1875	5.446875	Adineta vaga	104782	Rotifera	other_Eukaryota	289	1.58e-73	NTclustered	gi\|187233667\|gb\|EU643500.1\|	104782	g91703	i0	87.805	11.6425702811245	246	30	99	0	3	248	331	576	Adineta vaga ribosomal protein L11 mRNA, partial cds	blastn	2899	289	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
15727102	15727102	PRJNA421571_P_NODE_95633_length_248_cov_3.520000_g93084_i0	PRJNA421571	95633	248	3.52	8.7296	Adineta vaga complex sp. C JFF-2016	1813166	Rotifera	other_Eukaryota	329	9.249999999999998e-86	NTclustered	gi\|1005061344\|gb\|KU861166.1\|	1813166	g93084	i0	90.688	83.1088709677419	247	23	99	0	1	247	202	448	Adineta vaga complex sp. C JFF-2016 isolate H4-28a 82 kDa heat shock protein gene, partial cds	blastn	20611	329	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. C JFF-2016
25311605	25311605	PRJNA421571_P_NODE_21320_length_762_cov_26.560232_g18974_i0	PRJNA421571	21320	762	26.560232	202.38896784	Philodinidae	44580	Rotifera	other_Eukaryota	688	0	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g18974	i0	83.443	21.4619422572178	761	104	98	20	1	750	1674	2423	Rotaria rotatoria mitochondrion, complete genome	blastn	16354	689	0.998548621190131	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria

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);;