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

4 rows where bioproject = "PRJNA1103784", 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
27762930	27762930	PRJNA1103784_P_NODE_7264_length_243_cov_1.635294_g7209_i0	PRJNA1103784	7264	243	1.635294	3.97376442	Chthoniobacter sp.	2510640	Bacteria	Bacteria	72.8	9.17e-13	NR	MDR3405335.1	2510640	g7209	i0	82.9	0.506172839506173	41	7	50.6	0	3	125	424	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	123	72.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
31236641	31236641	PRJNA1103784_P_NODE_5615_length_251_cov_1.297753_g5560_i0	PRJNA1103784	5615	251	1.297753	3.25736003	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	123	5.849999999999999e-32	NR	RYD65414.1	2026800	g5560	i0	73.8	1.00398406374502	84	21	99.2	1	251	3	206	289	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	252	123	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31733925	31733925	PRJNA1103784_P_NODE_4277_length_277_cov_0.950980_g4222_i0	PRJNA1103784	4277	277	0.95098	2.6342146	Bacteria	2	Bacteria	Bacteria	47	0.00184	NR	MFN0126353.1	2026801	g4222	i0	44.7	0.974729241877256	38	21	41.2	0	56	169	692	729	MFN0126353.1 LamG-like jellyroll fold domain-containing protein [Verrucomicrobiales bacterium]	diamond	270	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32027603	32027603	PRJNA1103784_P_NODE_3938_length_284_cov_1.218009_g3883_i0	PRJNA1103784	3938	284	1.218009	3.45914556	Coraliomargarita parva	3014050	Bacteria	Bacteria	80.1	2.83e-15	NR	WP_269524788.1	3014050	g3883	i0	43.8	0.940140845070423	89	50	94	0	8	274	84	172	WP_269524788.1 ADP-ribosylglycohydrolase family protein [Coraliomargarita parva]	diamond	267	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita parva

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