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

15 rows where analysis = "blastn", bioproject = "PRJNA685060" 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
4494099	4494099	PRJNA685060_P_NODE_2804_length_590_cov_1.609284_g2714_i0	PRJNA685060	2804	590	1.609284	9.4947756	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	326	3.11e-84	NTclustered	gi\|403082245\|gb\|JX463647.1\|	104777	g2714	i0	77.737	43.4559322033898	548	110	92	11	1	542	518	1059	Brachionus calyciflorus cytochrome b (CYTB) gene, partial cds; mitochondrial	blastn	25639	326	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
6280033	6280033	PRJNA685060_P_NODE_3005_length_571_cov_1.236948_g2915_i0	PRJNA685060	3005	571	1.236948	7.06297308	Philodinidae	44580	Rotifera	other_Eukaryota	531	5.939999999999998e-146	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g2915	i0	83.821	24.292469352014	581	70	99	23	1	570	2402	1835	Rotaria rotatoria mitochondrion, complete genome	blastn	13871	534	0.99438202247191	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
7044770	7044770	PRJNA685060_P_NODE_10566_length_289_cov_2.712963_g10476_i0	PRJNA685060	10566	289	2.712963	7.84046307	Lecane bulla	96446	Rotifera	other_Eukaryota	492	1.33e-134	NTclustered	gi\|61200802\|gb\|AY829083.1\|	96446	g10476	i0	97.895	13.916955017301	285	4	98	2	6	289	155	438	Lecane bulla 28S ribosomal RNA gene, partial sequence	blastn	4022	492	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
7044866	7044866	PRJNA685060_P_NODE_6866_length_363_cov_2.944828_g6776_i0	PRJNA685060	6866	363	2.944828	10.68972564	Philodina citrina	468664	Rotifera	other_Eukaryota	431	3.7899999999999997e-116	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g6776	i0	88.462	25.2617079889807	364	32	99	8	1	360	2033	1676	Philodina citrina complete mitochondrial genome	blastn	9170	431	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
8319296	8319296	PRJNA685060_P_NODE_2767_length_594_cov_0.886756_g2677_i0	PRJNA685060	2767	594	0.886756	5.26733064	Brachionus manjavacas	667381	Rotifera	other_Eukaryota	407	1.09e-108	NTclustered	gi\|2006240376\|gb\|MW559987.1\|	667381	g2677	i0	79.457	77.7003367003367	589	109	98	12	1	583	7084	6502	Brachionus manjavacas isolate AU chromosome II mitochondrion, complete sequence	blastn	46154	407	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus manjavacas
8319342	8319342	PRJNA685060_P_NODE_8887_length_318_cov_1.571429_g8797_i0	PRJNA685060	8887	318	1.571429	4.99714422	Mytilina ventralis	360682	Rotifera	other_Eukaryota	272	2.0999999999999997e-68	NTclustered	gi\|83321193\|gb\|DQ297810.1\|	360682	g8797	i0	87.607	84.7830188679245	234	29	74	0	34	267	234	1	Mytilina ventralis histone H3 gene, partial cds	blastn	26961	272	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Mytilina	Mytilina ventralis
9594782	9594782	PRJNA685060_P_NODE_2748_length_595_cov_1.885057_g2658_i0	PRJNA685060	2748	595	1.885057	11.21608915	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	630	5.939999999999999e-176	NTclustered	gi\|402761773\|gb\|JX184018.1\|	104786	g2658	i0	86.332	3.51260504201681	578	79	97	0	12	589	37	614	Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	2090	630	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
9594808	9594808	PRJNA685060_P_NODE_6608_length_371_cov_1.033557_g6518_i0	PRJNA685060	6608	371	1.033557	3.83449647	Lecane bulla	96446	Rotifera	other_Eukaryota	669	0	NTclustered	gi\|1800242917\|gb\|MN983091.1\|	96446	g6518	i0	99.191	97.8814016172507	371	3	100	0	1	371	199	569	Lecane bulla isolate LbullaURA162 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	36314	669	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
9594822	9594822	PRJNA685060_P_NODE_848_length_1058_cov_10.191878_g790_i0	PRJNA685060	848	1058	10.191878	107.83006924	Brachionus rubens	392764	Rotifera	other_Eukaryota	651	0	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g790	i0	79.328	42.2240075614367	982	161	91	37	101	1058	10176	11139	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	44673	651	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
13420167	13420167	PRJNA685060_P_NODE_6871_length_363_cov_2.148276_g6781_i0	PRJNA685060	6871	363	2.148276	7.79824188	Brachionus sp. Almenara	183145	Rotifera	other_Eukaryota	130	1.55e-25	NTclustered	gi\|110648749\|emb\|AM292538.1\|	183145	g6781	i0	78.829	4.41322314049587	222	26	60	15	1	219	154	357	Brachionus sp. Almenara mitochondrial partial 16S rRNA gene	blastn	1602	130	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus sp. Almenara
14695116	14695116	PRJNA685060_P_NODE_15632_length_246_cov_0.890173_g15542_i0	PRJNA685060	15632	246	0.890173	2.18982558	Philodina citrina	468664	Rotifera	other_Eukaryota	291	4.33e-74	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g15542	i0	88.115	2.99186991869919	244	29	99	0	3	246	4608	4365	Philodina citrina complete mitochondrial genome	blastn	736	291	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
18518283	18518283	PRJNA685060_P_NODE_6095_length_388_cov_1.466667_g6005_i0	PRJNA685060	6095	388	1.466667	5.69066796	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	510	5.0899999999999995e-140	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g6005	i0	90.814	92.2268041237113	381	35	98	0	1	381	820	1200	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	35784	510	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
19793150	19793150	PRJNA685060_P_NODE_6436_length_376_cov_1.689769_g6346_i0	PRJNA685060	6436	376	1.689769	6.35353144	Adineta vaga	104782	Rotifera	other_Eukaryota	416	1.0999999999999998e-111	NTclustered	gi\|402761803\|gb\|JX184033.1\|	104782	g6346	i0	86.667	3.78723404255319	375	50	99	0	2	376	665	291	Adineta vaga NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial	blastn	1424	416	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
22853450	22853450	PRJNA685060_P_NODE_15298_length_246_cov_1.780347_g15208_i0	PRJNA685060	15298	246	1.780347	4.37965362	Brachionus	10194	Rotifera	other_Eukaryota	213	9.63e-51	NTclustered	gi\|1066800225\|gb\|KX364936.1\|	96890	g15208	i0	82.591	66	247	37	99	6	2	246	9726	9484	Brachionus rotundiformis chromosome I mitochondrion, complete sequence	blastn	16236	213	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rotundiformis
24892294	24892294	PRJNA685060_P_NODE_1820_length_734_cov_13.307110_g1738_i0	PRJNA685060	1820	734	13.30711	97.6741874	Philodina citrina	468664	Rotifera	other_Eukaryota	883	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1738	i0	88.514	23.1430517711172	740	72	99	12	1	733	1660	2393	Philodina citrina complete mitochondrial genome	blastn	16987	883	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina

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