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

15 rows where analysis = "blastn", bioproject = "PRJNA534016" 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
1782830	1782830	PRJNA534016_P_NODE_15122_length_248_cov_0.880000_g15032_i0	PRJNA534016	15122	248	0.88	2.1824	Brachionus angularis	396692	Rotifera	other_Eukaryota	243	1.24e-59	NTclustered	gi\|1999716438\|gb\|MT875426.1\|	396692	g15032	i0	84.4	74.7782258064516	250	35	100	3	1	248	904	1151	Brachionus angularis chromosome II mitochondrion, complete sequence	blastn	18545	243	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
3058429	3058429	PRJNA534016_P_NODE_2203_length_551_cov_2.824268_g2114_i0	PRJNA534016	2203	551	2.824268	15.56171668	Adineta vaga	104782	Rotifera	other_Eukaryota	712	0	NTclustered	gi\|134141736\|gb\|EF173232.1\|	104782	g2114	i0	90	98.5009074410163	550	55	99	0	1	550	55	604	Adineta vaga isolate NZ.1.3 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	54274	712	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
3058449	3058449	PRJNA534016_P_NODE_3303_length_448_cov_3.082667_g3213_i0	PRJNA534016	3303	448	3.082667	13.81034816	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	294	6.53e-75	NTclustered	gi\|218117267\|emb\|AM980961.1\|	10195	g3213	i0	81.766	57.4620535714286	351	64	78	0	98	448	10	360	Brachionus plicatilis partial mRNA for 40S ribosomal protein S24, (RPS24 gene)	blastn	25743	294	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
8160340	8160340	PRJNA534016_P_NODE_4407_length_393_cov_3.740625_g4317_i0	PRJNA534016	4407	393	3.740625	14.70065625	Philodina citrina	468664	Rotifera	other_Eukaryota	363	1.53e-95	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g4317	i0	84.197	29.3638676844784	386	47	97	10	13	393	2211	1835	Philodina citrina complete mitochondrial genome	blastn	11540	363	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
9435746	9435746	PRJNA534016_P_NODE_1228_length_744_cov_20.904620_g1144_i0	PRJNA534016	1228	744	20.90462	155.5303728	Proales similis	360698	Rotifera	other_Eukaryota	569	1.6599999999999993e-157	NTclustered	gi\|1859640894\|gb\|MN970216.1\|	360698	g1144	i0	84.524	49.1129032258064	588	78	78	12	15	595	12534	11953	Proales similis mitochondrion, complete genome	blastn	36540	569	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales similis
10711595	10711595	PRJNA534016_P_NODE_2749_length_493_cov_3.161905_g2659_i0	PRJNA534016	2749	493	3.161905	15.58819165	Lecane sp. bulla3	1225230	Rotifera	other_Eukaryota	501	3.9799999999999992e-137	NTclustered	gi\|401880173\|gb\|JX216654.1\|	1225230	g2659	i0	86.304	89.4929006085193	460	63	93	0	34	493	2	461	Lecane sp. bulla3 voucher ECOCHZ-AG0937.1 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial	blastn	44120	501	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane sp. bulla3
11986259	11986259	PRJNA534016_P_NODE_2050_length_571_cov_2.935743_g1962_i0	PRJNA534016	2050	571	2.935743	16.76309253	Brachionus rubens	392764	Rotifera	other_Eukaryota	254	1.44e-62	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g1962	i0	78.066	0.742556917688266	424	77	73	16	131	547	9531	9945	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	424	254	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
15146375	15146375	PRJNA534016_P_NODE_9672_length_281_cov_4.721154_g9582_i0	PRJNA534016	9672	281	4.721154	13.26644274	Ploima	84394	Rotifera	other_Eukaryota	265	3.06e-66	NTclustered	gi\|308052235\|gb\|GU232636.1\|	104777	g9582	i0	85.271	77.3985765124555	258	36	91	2	24	280	1	257	Brachionus calyciflorus isolate NC2 cytochrome c oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	21749	265	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
15810263	15810263	PRJNA534016_P_NODE_1793_length_610_cov_3.502793_g1706_i0	PRJNA534016	1793	610	3.502793	21.3670373	Brachionus rubens	392764	Rotifera	other_Eukaryota	254	1.54e-62	NTclustered	gi\|1802791198\|gb\|MN256531.1\|	392764	g1706	i0	78.827	0.642622950819672	392	71	63	12	67	452	10606	10221	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	392	254	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
19633513	19633513	PRJNA534016_P_NODE_1016_length_818_cov_1.421477_g939_i0	PRJNA534016	1016	818	1.421477	11.62768186	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	771	0	NTclustered	gi\|1143271481\|gb\|KX822781.1\|	104777	g939	i0	83.701	86.7616136919315	816	133	99	0	3	818	26606	27421	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	70971	771	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
20244723	20244723	PRJNA534016_P_NODE_14756_length_249_cov_0.875000_g14666_i0	PRJNA534016	14756	249	0.875	2.17875	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	62.1	3.74e-5	NTclustered	gi\|1104767204\|gb\|KT989538.1\|	10195	g14666	i0	86.207	4.2289156626506	58	6	23	2	37	94	1	56	Brachionus plicatilis homeodomain transcription factor Hox2 (Hox2) mRNA, complete cds	blastn	1053	62.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
20909449	20909449	PRJNA534016_P_NODE_1217_length_747_cov_16.149852_g1135_i0	PRJNA534016	1217	747	16.149852	120.63939444	Brachionus manjavacas	667381	Rotifera	other_Eukaryota	534	6.099999999999998e-147	NTclustered	gi\|2006240385\|gb\|MW559988.1\|	667381	g1135	i0	83.761	48.6291834002677	585	73	77	16	141	717	9935	10505	Brachionus manjavacas isolate DE chromosome I mitochondrion, complete sequence	blastn	36326	534	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus manjavacas
23459768	23459768	PRJNA534016_P_NODE_2719_length_496_cov_4.468085_g2629_i0	PRJNA534016	2719	496	4.468085	22.1617016	Philodina citrina	468664	Rotifera	other_Eukaryota	564	5.03e-156	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2629	i0	87.627	25.1572580645161	493	51	99	10	4	492	1908	2394	Philodina citrina complete mitochondrial genome	blastn	12478	564	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
24733342	24733342	PRJNA534016_P_NODE_10280_length_277_cov_1.245098_g10190_i0	PRJNA534016	10280	277	1.245098	3.44892146	Lecane inermis	1471631	Rotifera	other_Eukaryota	289	1.78e-73	NTclustered	gi\|1957982515\|gb\|MW487867.1\|	1471631	g10190	i0	86.194	97.0974729241877	268	36	97	1	1	268	394	660	Lecane inermis voucher NNIBRIV50291 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	26896	289	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane inermis
24733463	24733463	PRJNA534016_P_NODE_1960_length_583_cov_2.982353_g1873_i0	PRJNA534016	1960	583	2.982353	17.38711799	Brachionus angularis	396692	Rotifera	other_Eukaryota	248	6.84e-61	NTclustered	gi\|1999716438\|gb\|MT875426.1\|	396692	g1873	i0	75.043	1.92967409948542	585	120	98	21	3	574	6202	5631	Brachionus angularis chromosome II mitochondrion, complete sequence	blastn	1125	248	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis

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