metadata: contig_metadata: 4 rows where bioproject = "PRJNA890871", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA890871", 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
4693677	4693677	PRJNA890871_P_NODE_82784_length_242_cov_1.721893_g82649_i0	PRJNA890871	82784	242	1.721893	4.16698106	Rotaria	231623	Rotifera	other_Eukaryota	80.9	2.12e-16	NR	CAF3781409.1	392033	g82649	i0	93.3	4.46280991735537	45	3	55.8	0	240	106	47	91	CAF3781409.1 unnamed protein product [Rotaria sordida]	diamond	1080	80.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
27498015	27498015	PRJNA890871_P_NODE_23983_length_339_cov_2.740602_g23848_i0	PRJNA890871	23983	339	2.740602	9.29064078	Rotaria sordida	392033	Rotifera	other_Eukaryota	42	0.025	NR	CAF1091781.1	392033	g23848	i0	30	0.530973451327434	60	41	53.1	1	102	281	8	66	CAF1091781.1 unnamed protein product [Rotaria sordida]	diamond	180	42	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
31256217	31256217	PRJNA890871_P_NODE_46975_length_271_cov_1.343434_g46840_i0	PRJNA890871	46975	271	1.343434	3.64070614	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	58.9	9.12e-9	NR	CAF2752482.1	2762512	g46840	i0	51.9	1.74907749077491	54	26	59.8	0	5	166	63	116	CAF2752482.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	474	58.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
32458523	32458523	PRJNA890871_P_NODE_53739_length_261_cov_3.074468_g53604_i0	PRJNA890871	53739	261	3.074468	8.02436148	Adineta steineri	433720	Rotifera	other_Eukaryota	82.8	1.46e-17	NR	CAF4411069.1	433720	g53604	i0	51.7	3	87	40	97.7	1	1	255	70	156	CAF4411069.1 unnamed protein product, partial [Adineta steineri]	diamond	783	82.8	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);;