metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB41113" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB41113" 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
2609062	2609062	PRJEB41113_S_NODE_8003_length_168_cov_5.244275_g7994_i0	PRJEB41113	8003	168	5.244275	8.810382	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	207	2.85e-49	NTclustered	gi\|402761773\|gb\|JX184018.1\|	104786	g7994	i0	89.157	12.6845238095238	166	18	99	0	3	168	492	327	Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	2131	207	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
3885236	3885236	PRJEB41113_S_NODE_384_length_322_cov_11.491228_g375_i0	PRJEB41113	384	322	11.491228	37.00175416	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	305	2.1e-78	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g375	i0	86.477	44.2670807453416	281	34	87	4	43	321	11129	10851	Rotaria rotatoria mitochondrion, complete genome	blastn	14254	305	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
6437299	6437299	PRJEB41113_S_NODE_3386_length_202_cov_3.787879_g3377_i0	PRJEB41113	3386	202	3.787879	7.65151558	Adineta vaga	104782	Rotifera	other_Eukaryota	248	2.09e-61	NTclustered	gi\|402761787\|gb\|JX184025.1\|	104782	g3377	i0	89.691	1.93069306930693	194	20	96	0	5	198	151	344	Adineta vaga cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	390	248	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
8986233	8986233	PRJEB41113_S_NODE_188_length_377_cov_27.526471_g179_i0	PRJEB41113	188	377	27.526471	103.77479567	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	379	1.45e-100	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g179	i0	86.895	2.29708222811671	351	30	91	12	32	374	2081	2423	Rotaria rotatoria mitochondrion, complete genome	blastn	866	379	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
10261972	10261972	PRJEB41113_S_NODE_6209_length_179_cov_6.422535_g6200_i0	PRJEB41113	6209	179	6.422535	11.49633765	Philodina citrina	468664	Rotifera	other_Eukaryota	211	2.36e-50	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g6200	i0	89.286	51.9608938547486	168	18	94	0	10	177	5120	5287	Philodina citrina complete mitochondrial genome	blastn	9301	211	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
12812657	12812657	PRJEB41113_S_NODE_731_length_280_cov_4.283951_g722_i0	PRJEB41113	731	280	4.283951	11.9950628	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	292	1.4e-74	NTclustered	gi\|402761761\|gb\|JX184012.1\|	104788	g722	i0	87.649	7.03214285714286	251	31	90	0	1	251	398	648	Macrotrachela quadricornifera isolate CR cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	1969	292	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
21391949	21391949	PRJEB41113_S_NODE_3477_length_201_cov_3.439024_g3468_i0	PRJEB41113	3477	201	3.439024	6.91243824	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	315	2.0199999999999998e-81	NTclustered	gi\|281323397\|gb\|GQ922302.1\|	317506	g3468	i0	98.864	87.5422885572139	176	2	88	0	1	176	813	988	Uncultured bdelloid rotifer clone Rot_C_12C 18S ribosomal RNA gene, partial sequence	blastn	17596	315	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria				Bdelloidea environmental sample
21735880	21735880	PRJEB41113_S_NODE_6818_length_175_cov_5.347826_g6809_i0	PRJEB41113	6818	175	5.347826	9.3586955	Philodina citrina	468664	Rotifera	other_Eukaryota	261	2.25e-65	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g6809	i0	93.714	62.8971428571429	175	10	100	1	1	175	2053	1880	Philodina citrina complete mitochondrial genome	blastn	11007	261	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
23011089	23011089	PRJEB41113_S_NODE_2199_length_222_cov_4.345946_g2190_i0	PRJEB41113	2199	222	4.345946	9.64800012	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	272	1.3899999999999999e-68	NTclustered	gi\|402761789\|gb\|JX184026.1\|	104786	g2190	i0	88.789	48.6126126126126	223	23	100	2	1	222	679	900	Habrotrocha constricta cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	10792	272	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta

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