metadata: contig_metadata: 9 rows where bioproject = "PRJNA1164198", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA1164198", tax_kingdom = "Metazoa" 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
2862838	2862838	PRJNA1164198_P_NODE_27763_length_247_cov_0.896552_g27494_i0	PRJNA1164198	27763	247	0.896552	2.21448344	Rotaria	231623	Rotifera	other_Eukaryota	122	5.13e-30	NR	CAF3879437.1	392030	g27494	i0	68.3	23.9028340080972	82	25	99.6	1	1	246	335	415	CAF3879437.1 unnamed protein product [Rotaria magnacalcarata]	diamond	5904	122	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
13065524	13065524	PRJNA1164198_P_NODE_14371_length_326_cov_2.300395_g14102_i0	PRJNA1164198	14371	326	2.300395	7.4992877	Metazoa	33208	Rotifera	other_Eukaryota	181	5.49e-56	NR	CAF0934208.1	249248	g14102	i0	78.7	27.4049079754601	108	23	99.4	0	326	3	18	125	CAF0934208.1 unnamed protein product [Adineta ricciae]	diamond	8934	181	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
26913773	26913773	PRJNA1164198_P_NODE_29622_length_244_cov_0.912281_g29353_i0	PRJNA1164198	29622	244	0.912281	2.22596564	Adineta ricciae	249248	Rotifera	other_Eukaryota	155	3.4e-46	NR	CAF1533528.1	249248	g29353	i0	91.4	2.98770491803279	81	7	99.6	0	2	244	65	145	CAF1533528.1 unnamed protein product [Adineta ricciae]	diamond	729	155	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
27324980	27324980	PRJNA1164198_P_NODE_26423_length_249_cov_0.886364_g26154_i0	PRJNA1164198	26423	249	0.886364	2.20704636	Adineta ricciae	249248	Rotifera	other_Eukaryota	155	9.31e-45	NR	CAF1684820.1	249248	g26154	i0	93.9	5.92771084337349	82	5	98.8	0	248	3	64	145	CAF1684820.1 unnamed protein product, partial [Adineta ricciae]	diamond	1476	155	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28165213	28165213	PRJNA1164198_P_NODE_24945_length_252_cov_0.871508_g24676_i0	PRJNA1164198	24945	252	0.871508	2.19620016	Eurotatoria	2816136	Rotifera	other_Eukaryota	157	1.1599999999999999e-42	NR	UJR27423.1	104782	g24676	i0	90.4	5.92857142857143	83	8	98.8	0	3	251	407	489	UJR27423.1 hypothetical protein I4U23_008713 [Adineta vaga]	diamond	1494	158	0.993670886075949	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
29724325	29724325	PRJNA1164198_P_NODE_28390_length_246_cov_0.901734_g28121_i0	PRJNA1164198	28390	246	0.901734	2.21826564	Adineta ricciae	249248	Rotifera	other_Eukaryota	97.1	2.9700000000000003e-21	NR	CAF1633464.1	249248	g28121	i0	64.4	2.19512195121951	90	21	96.3	3	244	8	319	408	CAF1633464.1 unnamed protein product [Adineta ricciae]	diamond	540	97.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30596710	30596710	PRJNA1164198_P_NODE_24833_length_252_cov_0.871508_g24564_i0	PRJNA1164198	24833	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	120	1.96e-29	NR	UJR16273.1	104782	g24564	i0	71.1	9.88095238095238	83	23	98.8	1	252	4	1016	1097	UJR16273.1 hypothetical protein I4U23_003179 [Adineta vaga]	diamond	2490	120	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
30660035	30660035	PRJNA1164198_P_NODE_21633_length_267_cov_1.608247_g21364_i0	PRJNA1164198	21633	267	1.608247	4.29401949	Rotaria	231623	Rotifera	other_Eukaryota	107	5.14e-26	NR	CAF4114877.1	392030	g21364	i0	59.8	4.91011235955056	87	35	97.8	0	267	7	167	253	CAF4114877.1 unnamed protein product, partial [Rotaria magnacalcarata]	diamond	1311	107	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
32114628	32114628	PRJNA1164198_P_NODE_29878_length_243_cov_1.835294_g29609_i0	PRJNA1164198	29878	243	1.835294	4.45976442	root	1	Root_unresolved	Root_unresolved	53.5	2.81e-6	NR	CAF0731708.1	433720	g29609	i0	37.3	4.27160493827161	83	49	98.8	3	242	3	20	102	CAF0731708.1 unnamed protein product [Adineta steineri]	diamond	1038	53.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri

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