metadata: contig_metadata: 26 rows where bioproject = "PRJNA721440", tax_clade = "Opisthokonta" and tax

26 rows where bioproject = "PRJNA721440", tax_clade = "Opisthokonta" 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
710131	710131	PRJNA721440_S_NODE_18621_length_165_cov_0.896552_g18495_i0	PRJNA721440	18621	165	0.896552	1.4793108	Adineta steineri	433720	Rotifera	other_Eukaryota	97.8	3.88e-22	NR	CAF0954462.1	433720	g18495	i0	100	1.6	44	0	80	0	3	134	237	280	CAF0954462.1 unnamed protein product [Adineta steineri]	diamond	264	97.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
4538533	4538533	PRJNA721440_S_NODE_17384_length_168_cov_0.873950_g17258_i0	PRJNA721440	17384	168	0.87395	1.468236	Adineta vaga	104782	Rotifera	other_Eukaryota	122	8.22e-31	NR	UJR24316.1	104782	g17258	i0	94.5	1.96428571428571	55	3	98.2	0	167	3	424	478	UJR24316.1 hypothetical protein I4U23_027283 [Adineta vaga]	diamond	330	122	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
7088943	7088943	PRJNA721440_S_NODE_5306_length_260_cov_1.289100_g5180_i0	PRJNA721440	5306	260	1.2891	3.35166	Adineta vaga	104782	Rotifera	other_Eukaryota	455	1.55e-123	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g5180	i0	100	64.8115384615385	246	0	95	0	15	260	4159	4404	Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	16851	455	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
7571453	7571453	PRJNA721440_S_NODE_3246_length_316_cov_0.985019_g3120_i0	PRJNA721440	3246	316	0.985019	3.11266004	Adineta	104781	Rotifera	other_Eukaryota	579	1.0999999999999999e-160	NTclustered	gi\|2537903787\|gb\|KM043252.2\|	104782	g3120	i0	99.684	99.8449367088608	316	1	100	0	1	316	858	543	Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence	blastn	31551	579	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
10122182	10122182	PRJNA721440_S_NODE_10568_length_201_cov_1.125000_g10442_i0	PRJNA721440	10568	201	1.125	2.26125	Metazoa	33208	Rotifera	other_Eukaryota	372	1.18e-98	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g10442	i0	100	66.7213930348259	201	0	100	0	1	201	1810	1610	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	13411	372	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
10914198	10914198	PRJNA721440_S_NODE_8309_length_219_cov_1.258824_g8183_i0	PRJNA721440	8309	219	1.258824	2.75682456	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	217	6.489999999999999e-52	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g8183	i0	84.685	4.91780821917808	222	28	100	5	1	219	219	1	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	1077	217	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
16012670	16012670	PRJNA721440_S_NODE_1853_length_401_cov_6.090909_g1727_i0	PRJNA721440	1853	401	6.090909	24.42454509	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	399	1.1899999999999998e-106	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g1727	i0	85.496	24.0947630922693	393	46	97	10	11	397	2050	1663	Rotaria rotatoria mitochondrion, complete genome	blastn	9662	399	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
16496563	16496563	PRJNA721440_S_NODE_19773_length_162_cov_1.380531_g19647_i0	PRJNA721440	19773	162	1.380531	2.23646022	Adineta ricciae	249248	Rotifera	other_Eukaryota	115	7.039999999999999e-32	NR	CAF1594653.1	249248	g19647	i0	100	1.96296296296296	53	0	98.1	0	3	161	39	91	CAF1594653.1 unnamed protein product, partial [Adineta ricciae]	diamond	318	115	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
16496571	16496571	PRJNA721440_S_NODE_8213_length_220_cov_1.040936_g8087_i0	PRJNA721440	8213	220	1.040936	2.2900592	Eurotatoria	2816136	Rotifera	other_Eukaryota	407	3.61e-109	NTclustered	gi\|1399047\|gb\|U41281.1\|PAU41281	44582	g8087	i0	100	100.136363636364	220	0	100	0	1	220	193	412	Philodina acuticornis 18S rRNA gene	blastn	22030	407	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina acuticornis
27589293	27589293	PRJNA721440_S_NODE_10564_length_201_cov_1.236842_g10438_i0	PRJNA721440	10564	201	1.236842	2.48605242	Adineta ricciae	249248	Rotifera	other_Eukaryota	107	5.53e-27	NR	CAF0807537.1	249248	g10438	i0	81.8	0.985074626865672	66	12	98.5	0	199	2	33	98	CAF0807537.1 unnamed protein product [Adineta ricciae]	diamond	198	107	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
27778787	27778787	PRJNA721440_S_NODE_6564_length_239_cov_2.026316_g6438_i0	PRJNA721440	6564	239	2.026316	4.84289524	Adineta ricciae	249248	Rotifera	other_Eukaryota	69.3	1.34e-11	NR	CAF0760555.1	249248	g6438	i0	43.8	6	80	43	97.9	1	239	6	119	198	CAF0760555.1 unnamed protein product [Adineta ricciae]	diamond	1434	69.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28062702	28062702	PRJNA721440_S_NODE_16105_length_172_cov_1.268293_g15979_i0	PRJNA721440	16105	172	1.268293	2.18146396	Rotaria socialis	392032	Rotifera	other_Eukaryota	47.4	3.36e-4	NR	CAF3416430.1	392032	g15979	i0	47.4	2.98255813953488	57	26	99.4	2	1	171	384	436	CAF3416430.1 unnamed protein product [Rotaria socialis]	diamond	513	47.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria socialis
28694491	28694491	PRJNA721440_S_NODE_19467_length_163_cov_0.912281_g19341_i0	PRJNA721440	19467	163	0.912281	1.48701803	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	58.2	4.6e-8	NR	AFQ97019.1	104786	g19341	i0	57.4	0.993865030674847	54	23	99.4	0	2	163	345	398	AFQ97019.1 NADH dehydrogenase subunit 5, partial [Habrotrocha constricta]	diamond	162	58.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
28767801	28767801	PRJNA721440_S_NODE_18167_length_166_cov_0.888889_g18041_i0	PRJNA721440	18167	166	0.888889	1.47555574	Eurotatoria	2816136	Rotifera	other_Eukaryota	112	2.85e-27	NR	UJR23654.1	104782	g18041	i0	96.4	16.8975903614458	55	2	99.4	0	166	2	558	612	UJR23654.1 hypothetical protein I4U23_026638 [Adineta vaga]	diamond	2805	112	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
29041762	29041762	PRJNA721440_S_NODE_16828_length_169_cov_1.991667_g16702_i0	PRJNA721440	16828	169	1.991667	3.36591723	Adineta steineri	433720	Rotifera	other_Eukaryota	45.1	0.00214	NR	CAF1048957.1	433720	g16702	i0	47.2	0.940828402366864	53	24	87	1	162	16	233	285	CAF1048957.1 unnamed protein product [Adineta steineri]	diamond	159	45.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
29672727	29672727	PRJNA721440_S_NODE_18630_length_165_cov_0.896552_g18504_i0	PRJNA721440	18630	165	0.896552	1.4793108	Adineta ricciae	249248	Rotifera	other_Eukaryota	115	4.41e-28	NR	CAF0788477.1	249248	g18504	i0	100	7	55	0	100	0	1	165	505	559	CAF0788477.1 unnamed protein product [Adineta ricciae]	diamond	1155	115	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
29799238	29799238	PRJNA721440_S_NODE_6711_length_237_cov_4.239362_g6585_i0	PRJNA721440	6711	237	4.239362	10.04728794	Adineta steineri	433720	Rotifera	other_Eukaryota	63.2	2.14e-9	NR	CAF1136869.1	433720	g6585	i0	37.6	4.37974683544304	85	43	100	3	237	1	278	358	CAF1136869.1 unnamed protein product [Adineta steineri]	diamond	1038	63.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
30031000	30031000	PRJNA721440_S_NODE_19931_length_162_cov_0.920354_g19805_i0	PRJNA721440	19931	162	0.920354	1.49097348	Eurotatoria	2816136	Rotifera	other_Eukaryota	104	9.63e-25	NR	CAF0828470.1	249248	g19805	i0	94.3	2.94444444444444	53	3	98.1	0	2	160	142	194	CAF0828470.1 unnamed protein product [Adineta ricciae]	diamond	477	104	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30599497	30599497	PRJNA721440_S_NODE_17353_length_168_cov_1.016807_g17227_i0	PRJNA721440	17353	168	1.016807	1.70823576	Eurotatoria	2816136	Rotifera	other_Eukaryota	118	1.7499999999999998e-30	NR	CAF1219143.1	249248	g17227	i0	98.2	8.83928571428571	55	1	98.2	0	3	167	189	243	CAF1219143.1 unnamed protein product [Adineta ricciae]	diamond	1485	118	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
31231396	31231396	PRJNA721440_S_NODE_13195_length_185_cov_1.102941_g13069_i0	PRJNA721440	13195	185	1.102941	2.04044085	Adineta	104781	Rotifera	other_Eukaryota	52	9.38e-6	NR	UJR26126.1	104782	g13069	i0	90.9	0.697297297297297	22	2	35.7	0	2	67	259	280	UJR26126.1 hypothetical protein I4U23_007472 [Adineta vaga]	diamond	129	52	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
31294798	31294798	PRJNA721440_S_NODE_18215_length_166_cov_0.888889_g18089_i0	PRJNA721440	18215	166	0.888889	1.47555574	Adineta	104781	Rotifera	other_Eukaryota	112	2.3700000000000003e-27	NR	CAF0945440.1	249248	g18089	i0	100	2.98192771084337	55	0	99.4	0	166	2	410	464	CAF0945440.1 unnamed protein product [Adineta ricciae]	diamond	495	112	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
31800697	31800697	PRJNA721440_S_NODE_6277_length_243_cov_2.484536_g6151_i0	PRJNA721440	6277	243	2.484536	6.03742248	Metazoa	33208	Rotifera	other_Eukaryota	76.3	6.15e-14	NR	UJR17604.1	104782	g6151	i0	49.4	3.75308641975309	81	39	100	1	243	1	941	1019	UJR17604.1 hypothetical protein I4U23_004500 [Adineta vaga]	diamond	912	77	0.990909090909091	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
31885242	31885242	PRJNA721440_S_NODE_10037_length_204_cov_7.270968_g9911_i0	PRJNA721440	10037	204	7.270968	14.83277472	Rotaria socialis	392032	Rotifera	other_Eukaryota	47	6.65e-4	NR	CAF3303973.1	392032	g9911	i0	40	1.91176470588235	65	29	95.6	2	3	197	195	249	CAF3303973.1 unnamed protein product [Rotaria socialis]	diamond	390	47	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria socialis
31885260	31885260	PRJNA721440_S_NODE_6357_length_242_cov_1.559585_g6231_i0	PRJNA721440	6357	242	1.559585	3.7741957	Adineta steineri	433720	Rotifera	other_Eukaryota	90.9	4.16e-19	NR	CAF0788659.1	433720	g6231	i0	71.2	2.88842975206612	59	17	73.1	0	197	21	6	64	CAF0788659.1 unnamed protein product [Adineta steineri]	diamond	699	90.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
32644048	32644048	PRJNA721440_S_NODE_12600_length_188_cov_1.122302_g12474_i0	PRJNA721440	12600	188	1.122302	2.10992776	Adineta ricciae	249248	Rotifera	other_Eukaryota	123	3.81e-33	NR	CAF0876125.1	249248	g12474	i0	96.8	0.98936170212766	62	2	98.9	0	2	187	29	90	CAF0876125.1 unnamed protein product [Adineta ricciae]	diamond	186	123	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
32738961	32738961	PRJNA721440_S_NODE_15880_length_173_cov_0.564516_g15754_i0	PRJNA721440	15880	173	0.564516	0.97661268	Adineta ricciae	249248	Rotifera	other_Eukaryota	120	2.07e-30	NR	CAF1006388.1	249248	g15754	i0	93	1.97687861271676	57	4	98.8	0	171	1	316	372	CAF1006388.1 unnamed protein product [Adineta ricciae]	diamond	342	120	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae

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