metadata: contig_metadata: 6 rows where bioproject = "PRJNA529241" and tax

6 rows where bioproject = "PRJNA529241" 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
29634944	29634944	PRJNA529241_P_NODE_407570_length_172_cov_1.155556_g405248_i0	PRJNA529241	407570	172	1.155556	1.98755632	Adineta ricciae	249248	Rotifera	other_Eukaryota	41.6	0.0373	NR	CAF0741843.1	249248	g405248	i0	47.6	0.732558139534884	42	20	69.8	1	10	129	370	411	CAF0741843.1 unnamed protein product [Adineta ricciae]	diamond	126	41.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30456951	30456951	PRJNA529241_P_NODE_151893_length_185_cov_1.054054_g149571_i0	PRJNA529241	151893	185	1.054054	1.9499999	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	40.8	0.0438	NR	RNA02241.1	10195	g149571	i0	40.8	0.794594594594595	49	29	79.5	0	184	38	65	113	RNA02241.1 hypothetical protein BpHYR1_049873 [Brachionus plicatilis]	diamond	147	40.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
30582845	30582845	PRJNA529241_P_NODE_518853_length_151_cov_4.008772_g516531_i0	PRJNA529241	518853	151	4.008772	6.05324572	Adineta vaga	104782	Rotifera	other_Eukaryota	64.7	1.82e-10	NR	UJR19776.1	104782	g516531	i0	50.9	2.22516556291391	57	20	97.4	1	3	149	311	367	UJR19776.1 hypothetical protein I4U23_022910 [Adineta vaga]	diamond	336	64.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
30962181	30962181	PRJNA529241_P_NODE_160994_length_180_cov_5.916084_g158672_i0	PRJNA529241	160994	180	5.916084	10.6489512	Brachionus rotundiformis	96890	Rotifera	other_Eukaryota	41.6	0.0409	NR	QEV83794.1	96890	g158672	i0	35.3	0.85	51	27	85	1	170	18	190	234	QEV83794.1 cytochrome P450 [Brachionus rotundiformis]	diamond	153	41.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rotundiformis
31847397	31847397	PRJNA529241_P_NODE_312917_length_173_cov_3.345588_g310595_i0	PRJNA529241	312917	173	3.345588	5.78786724	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	47	4.63e-4	NR	CAF0792513.1	2762511	g310595	i0	80	0.867052023121387	25	5	43.4	0	2	76	283	307	CAF0792513.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	150	47	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
32700955	32700955	PRJNA529241_P_NODE_162500_length_180_cov_1.160839_g160178_i0	PRJNA529241	162500	180	1.160839	2.0895102	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	40.8	0.0425	NR	CAF1509856.1	1234261	g160178	i0	36.6	0.683333333333333	41	25	68.3	1	45	167	97	136	CAF1509856.1 unnamed protein product [Didymodactylos carnosus]	diamond	123	40.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus

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