metadata: contig_metadata: 10 rows where bioproject = "PRJNA1245487", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA1245487", 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
11254500	11254500	PRJNA1245487_P_NODE_11589_length_344_cov_3.542435_g11251_i0	PRJNA1245487	11589	344	3.542435	12.1859764	Adineta	104781	Rotifera	other_Eukaryota	627	4.2499999999999997e-175	NTclustered	gi\|1005055512\|gb\|KU860655.1\|	1813164	g11251	i0	99.708	52.1424418604651	342	1	99	0	1	342	1748	2089	Adineta vaga complex sp. A JFF-2016 isolate H001 28S ribosomal RNA gene, partial sequence	blastn	17937	627	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. A JFF-2016
15078744	15078744	PRJNA1245487_P_NODE_10112_length_374_cov_8.677741_g9774_i0	PRJNA1245487	10112	374	8.677741	32.45475134	Eurotatoria	2816136	Rotifera	other_Eukaryota	680	0	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g9774	i0	99.465	48.7112299465241	374	2	100	0	1	374	1513	1886	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	18218	686	0.991253644314869	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
16928279	16928279	PRJNA1245487_P_NODE_16034_length_280_cov_7.342995_g15696_i0	PRJNA1245487	16034	280	7.342995	20.560386	Adineta vaga	104782	Rotifera	other_Eukaryota	457	4.6799999999999996e-124	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g15696	i0	96.085	83.0892857142857	281	10	100	1	1	280	6706	6986	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	23265	457	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
21453082	21453082	PRJNA1245487_P_NODE_14597_length_296_cov_5.484305_g14259_i0	PRJNA1245487	14597	296	5.484305	16.2335428	Eurotatoria	2816136	Rotifera	other_Eukaryota	508	1.36e-139	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g14259	i0	97.635	78.7162162162162	296	7	100	0	1	296	2854	3149	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	23300	508	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
22027759	22027759	PRJNA1245487_P_NODE_11478_length_346_cov_6.611722_g11140_i0	PRJNA1245487	11478	346	6.611722	22.87655812	Adineta vaga	104782	Rotifera	other_Eukaryota	614	3.329999999999999e-171	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g11140	i0	99.408	4.27456647398844	338	2	98	0	1	338	10061	10398	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	1479	614	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
23303488	23303488	PRJNA1245487_P_NODE_19239_length_252_cov_2.100559_g18901_i0	PRJNA1245487	19239	252	2.100559	5.29340868	Adineta vaga complex sp. C JFF-2016	1813166	Rotifera	other_Eukaryota	385	1.98e-102	NTclustered	gi\|1005055594\|gb\|KU860737.1\|	1813166	g18901	i0	95.102	66.4206349206349	245	10	97	2	1	245	243	1	Adineta vaga complex sp. C JFF-2016 isolate A110a 28S ribosomal RNA gene, partial sequence	blastn	16738	385	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. C JFF-2016
27168192	27168192	PRJNA1245487_P_NODE_4162_length_615_cov_1.990775_g3832_i0	PRJNA1245487	4162	615	1.990775	12.24326625	Adineta ricciae	249248	Rotifera	other_Eukaryota	111	3.42e-27	NR	CAF0829117.1	249248	g3832	i0	36	1.4780487804878	150	91	72.7	3	572	126	6	151	CAF0829117.1 unnamed protein product [Adineta ricciae]	diamond	909	111	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
31640242	31640242	PRJNA1245487_P_NODE_18236_length_260_cov_1.663102_g17898_i0	PRJNA1245487	18236	260	1.663102	4.3240652	Eurotatoria	2816136	Rotifera	other_Eukaryota	128	3.6899999999999996e-32	NR	CAF0976413.1	433720	g17898	i0	80.2	2.97692307692308	86	11	99.2	3	2	259	416	495	CAF0976413.1 unnamed protein product [Adineta steineri]	diamond	774	129	0.992248062015504	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
31970106	31970106	PRJNA1245487_P_NODE_19398_length_252_cov_0.871508_g19060_i0	PRJNA1245487	19398	252	0.871508	2.19620016	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	61.6	9.04e-9	NR	CAF1036413.1	1234261	g19060	i0	50	3.47619047619048	58	29	69	0	3	176	186	243	CAF1036413.1 unnamed protein product, partial [Didymodactylos carnosus]	diamond	876	61.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
32728791	32728791	PRJNA1245487_P_NODE_9180_length_399_cov_1.797546_g8842_i0	PRJNA1245487	9180	399	1.797546	7.17220854	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	104	5.67e-26	NR	CAF3440507.1	2762512	g8842	i0	73.5	0.511278195488722	68	18	51.1	0	33	236	1	68	CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	204	104	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2

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