metadata: contig_metadata: 10 rows where bioproject = "PRJNA681822" and tax

10 rows where bioproject = "PRJNA681822" 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
27536195	27536195	PRJNA681822_P_NODE_281483_length_279_cov_1.174757_g279994_i0	PRJNA681822	281483	279	1.174757	3.27757203	Opisthokonta	33154	Rotifera	other_Eukaryota	133	1.4899999999999998e-37	NR	RNA15975.1	10195	g279994	i0	68.1	29.3978494623656	91	29	97.8	0	274	2	6	96	RNA15975.1 60S ribosomal L21 [Brachionus plicatilis]	diamond	8202	133	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
27745650	27745650	PRJNA681822_P_NODE_466244_length_242_cov_2.449704_g464754_i0	PRJNA681822	466244	242	2.449704	5.92828368	Adineta steineri	433720	Rotifera	other_Eukaryota	51.2	3.72e-5	NR	CAF1189828.1	433720	g464754	i0	40	1.78512396694215	75	41	88	1	227	15	180	254	CAF1189828.1 unnamed protein product [Adineta steineri]	diamond	432	51.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
27998158	27998158	PRJNA681822_P_NODE_424885_length_247_cov_0.885057_g423396_i0	PRJNA681822	424885	247	0.885057	2.18609079	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	108	5.93e-26	NR	CAF0963342.1	1234261	g423396	i0	60.2	1.0080971659919	83	32	99.6	1	1	246	251	333	CAF0963342.1 unnamed protein product [Didymodactylos carnosus]	diamond	249	108	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
28881962	28881962	PRJNA681822_P_NODE_433908_length_246_cov_0.890173_g432419_i0	PRJNA681822	433908	246	0.890173	2.18982558	Adineta vaga	104782	Rotifera	other_Eukaryota	82.8	2.26e-16	NR	UJR10967.1	104782	g432419	i0	51.2	2.01219512195122	82	40	100	0	246	1	232	313	UJR10967.1 hypothetical protein I4U23_015152 [Adineta vaga]	diamond	495	82.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
29229568	29229568	PRJNA681822_P_NODE_173329_length_325_cov_1.218254_g171841_i0	PRJNA681822	173329	325	1.218254	3.9593255	Adineta vaga	104782	Rotifera	other_Eukaryota	43.5	0.0489	NR	UJR24397.1	104782	g171841	i0	26.9	0.72	78	51	66.5	2	6	221	134	211	UJR24397.1 hypothetical protein I4U23_005774 [Adineta vaga]	diamond	234	43.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
29999109	29999109	PRJNA681822_P_NODE_482411_length_241_cov_0.916667_g480921_i0	PRJNA681822	482411	241	0.916667	2.20916747	Opisthokonta	33154	Rotifera	other_Eukaryota	98.2	2.06e-23	NR	CAF1062117.1	392033	g480921	i0	56.3	3.97095435684647	80	33	97.1	2	3	236	19	98	CAF1062117.1 unnamed protein product [Rotaria sordida]	diamond	957	98.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
30050244	30050244	PRJNA681822_P_NODE_357371_length_258_cov_1.664865_g355882_i0	PRJNA681822	357371	258	1.664865	4.2953517	Adineta vaga	104782	Rotifera	other_Eukaryota	48.1	5.54e-4	NR	UJR28287.1	104782	g355882	i0	77.3	0.255813953488372	22	5	25.6	0	257	192	601	622	UJR28287.1 hypothetical protein I4U23_009535 [Adineta vaga]	diamond	66	48.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
30240004	30240004	PRJNA681822_P_NODE_170832_length_326_cov_2.924901_g169344_i0	PRJNA681822	170832	326	2.924901	9.53517726	Adineta vaga	104782	Rotifera	other_Eukaryota	44.3	0.0249	NR	UJR28598.1	104782	g169344	i0	45.5	1.11349693251534	55	29	50.6	1	251	87	8	61	UJR28598.1 hypothetical protein I4U23_009831 [Adineta vaga]	diamond	363	44.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
30240034	30240034	PRJNA681822_P_NODE_398532_length_250_cov_0.870056_g397043_i0	PRJNA681822	398532	250	0.870056	2.17514	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	62	2.37e-10	NR	CAF4421943.1	392030	g397043	i0	48.6	1.776	74	38	88.8	0	248	27	2	75	CAF4421943.1 unnamed protein product, partial [Rotaria magnacalcarata]	diamond	444	62	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
31472648	31472648	PRJNA681822_P_NODE_367156_length_255_cov_2.098901_g365667_i0	PRJNA681822	367156	255	2.098901	5.35219755	Adineta steineri	433720	Rotifera	other_Eukaryota	134	3.87e-38	NR	CAF1156327.1	433720	g365667	i0	74.1	6	85	21	100	1	255	1	46	129	CAF1156327.1 unnamed protein product [Adineta steineri]	diamond	1530	134	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);;