metadata: contig_metadata: 4 rows where bioproject = "PRJNA1089179", tax_clade = "PVC group" and tax

4 rows where bioproject = "PRJNA1089179", tax_clade = "PVC group" 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
18046550	18046550	PRJNA1089179_P_NODE_915_length_690_cov_2.659643_g898_i0	PRJNA1089179	915	690	2.659643	18.3515367	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	573	1.1899999999999998e-158	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g898	i0	85.159	166.578260869565	566	77	81	7	90	651	1727682	1728244	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	114939	573	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23146999	23146999	PRJNA1089179_P_NODE_6499_length_346_cov_1.472527_g6481_i0	PRJNA1089179	6499	346	1.472527	5.09494342	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	99	8.49e-24	NR	MBS0647324.1	2026799	g6481	i0	72.5	0.598265895953757	69	19	59.8	0	329	123	14	82	MBS0647324.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	207	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29656536	29656536	PRJNA1089179_P_NODE_7890_length_321_cov_1.241935_g7872_i0	PRJNA1089179	7890	321	1.241935	3.98661135	Coraliomargarita parva	3014050	Bacteria	Bacteria	53.5	1.49e-5	NR	WP_269525260.1	3014050	g7872	i0	38.6	0.94392523364486	101	55	93.5	3	5	304	177	271	WP_269525260.1 right-handed parallel beta-helix repeat-containing protein [Coraliomargarita parva]	diamond	303	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita parva
31204527	31204527	PRJNA1089179_P_NODE_10795_length_283_cov_26.533333_g10777_i0	PRJNA1089179	10795	283	26.533333	75.08933239	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	60.5	1.33e-8	NR	HSH37172.1	2201154	g10777	i0	83.9	0.657243816254417	31	5	32.9	0	271	179	179	209	HSH37172.1 pyridoxamine 5'-phosphate oxidase [Chthoniobacterales bacterium]	diamond	186	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales 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);;