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

6 rows where bioproject = "PRJEB75227" 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_genus	tax_species
6513759	6513759	PRJEB75227_P_NODE_4506_length_335_cov_0.893130_g4335_i0	PRJEB75227	4506	335	0.89313	2.9919855	Candidatus Xiphinematobacter sp. Idaho Grape	1704307	Bacteria	Bacteria	446	1.24e-120	NTclustered	gi\|939198278\|gb\|CP012665.1\|	1704307	g4335	i0	91.212	114.388059701493	330	26	98	3	8	335	15771	15443	Candidatus Xiphinematobacter sp. Idaho Grape, complete genome	blastn	38320	446	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp. Idaho Grape
26781109	26781109	PRJEB75227_P_NODE_10801_length_245_cov_0.906977_g10630_i0	PRJEB75227	10801	245	0.906977	2.22209365	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	125	3.22e-32	NR	HZO83750.1	2499141	g10630	i0	100	0.783673469387755	64	0	78.4	0	245	54	321	384	HZO83750.1 tetratricopeptide repeat protein [Verrucomicrobiia bacterium]	diamond	192	125	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27287037	27287037	PRJEB75227_P_NODE_8303_length_253_cov_0.866667_g8132_i0	PRJEB75227	8303	253	0.866667	2.19266751	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	135	1.27e-36	NR	NBR86461.1	2026799	g8132	i0	97.1	0.806324110671937	68	2	80.6	0	206	3	12	79	NBR86461.1 ketoacyl-ACP synthase III [Verrucomicrobiota bacterium]	diamond	204	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28581847	28581847	PRJEB75227_P_NODE_6147_length_285_cov_1.193396_g5976_i0	PRJEB75227	6147	285	1.193396	3.4011786	Opitutia bacterium	2026771	Bacteria	Bacteria	53.1	1.29e-5	NR	MBI2518388.1	2026771	g5976	i0	57.7	0.547368421052632	52	19	53.7	2	133	285	6	55	MBI2518388.1 hypothetical protein [Opitutia bacterium]	diamond	156	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
30887290	30887290	PRJEB75227_P_NODE_8294_length_253_cov_0.866667_g8123_i0	PRJEB75227	8294	253	0.866667	2.19266751	Opitutaceae bacterium	2006848	Bacteria	Bacteria	120	7.989999999999999e-30	NR	MBL9187044.1	2006848	g8123	i0	66.3	3.93675889328063	83	28	98.4	0	251	3	169	251	MBL9187044.1 sulfatase-like hydrolase/transferase [Opitutaceae bacterium]	diamond	996	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30950651	30950651	PRJEB75227_P_NODE_10314_length_246_cov_0.901734_g10143_i0	PRJEB75227	10314	246	0.901734	2.21826564	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	94.4	3.410000000000001e-21	NR	RYD69104.1	2026800	g10143	i0	60	0.975609756097561	80	30	97.6	1	6	245	1	78	RYD69104.1 MAG: MFS transporter, partial [Verrucomicrobiaceae bacterium]	diamond	240	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;