metadata: contig_metadata: 5 rows where bioproject = "PRJNA407087" and tax

5 rows where bioproject = "PRJNA407087" and tax_phylum = "Verrucomicrobiota"

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_species
29349185	29349185	PRJNA407087_S_NODE_3009_length_353_cov_2.645062_g2547_i0	PRJNA407087	3009	353	2.645062	9.33706886	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0215	NR	MBV9671622.1	2026799	g2547	i0	37	0.390934844192635	46	29	39.1	0	326	189	8	53	MBV9671622.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	138	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
30201581	30201581	PRJNA407087_S_NODE_7232_length_181_cov_6.006579_g6769_i0	PRJNA407087	7232	181	6.006579	10.87190799	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	56.6	2.08e-7	NR	HYG84357.1	2499141	g6769	i0	61.7	0.779005524861878	47	18	77.9	0	2	142	232	278	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	141	56.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia			Verrucomicrobiia bacterium
30265325	30265325	PRJNA407087_S_NODE_752_length_864_cov_6.673054_g476_i0	PRJNA407087	752	864	6.673054	57.65518656	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	79.7	1.16e-13	NR	MEY2479657.1	2026799	g476	i0	34.6	2.52083333333333	191	112	65.3	7	799	236	7	187	MEY2479657.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	2178	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
30580763	30580763	PRJNA407087_S_NODE_4153_length_270_cov_5.962656_g3690_i0	PRJNA407087	4153	270	5.962656	16.0991712	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	130	2.27e-34	NR	RYD65414.1	2026800	g3690	i0	73	0.988888888888889	89	22	98.9	1	3	269	120	206	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	267	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
32162048	32162048	PRJNA407087_S_NODE_2798_length_371_cov_5.520468_g2336_i0	PRJNA407087	2798	371	5.520468	20.48093628	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	108	1.19e-24	NR	HYG84357.1	2499141	g2336	i0	52.6	0.93800539083558	116	53	92.2	1	20	361	71	186	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	348	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia			Verrucomicrobiia bacterium

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