metadata: contig_metadata: 5 rows where bioproject = "PRJNA839281", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA839281", 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
3380697	3380697	PRJNA839281_S_NODE_38743_length_156_cov_5.140187_g38474_i0	PRJNA839281	38743	156	5.140187	8.01869172	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	62.1	2.13e-5	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g38474	i0	91.111	0.288461538461538	45	4	29	0	19	63	1370618	1370662	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	45	62.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
28539250	28539250	PRJNA839281_S_NODE_8747_length_269_cov_1.977273_g8478_i0	PRJNA839281	8747	269	1.977273	5.31886437	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.7	0.0105	NR	NUN94410.1	2499141	g8478	i0	41.8	0.613382899628253	55	29	58	1	164	9	410	464	NUN94410.1 (E)-4-hydroxy-3-methylbut-2-enyl-diphosphate synthase [Verrucomicrobiia bacterium]	diamond	165	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28602256	28602256	PRJNA839281_S_NODE_27407_length_167_cov_0.864407_g27138_i0	PRJNA839281	27407	167	0.864407	1.44355969	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0135	NR	MEY4246360.1	2026799	g27138	i0	44.9	0.880239520958084	49	26	88	1	10	156	619	666	MEY4246360.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	147	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29328274	29328274	PRJNA839281_S_NODE_12509_length_226_cov_1.152542_g12240_i0	PRJNA839281	12509	226	1.152542	2.60474492	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	118	2.86e-29	NR	HUK83902.1	2499141	g12240	i0	72	3.95575221238938	75	21	99.6	0	225	1	304	378	HUK83902.1 putrescine aminotransferase [Verrucomicrobiia bacterium]	diamond	894	118	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29359997	29359997	PRJNA839281_S_NODE_36049_length_162_cov_0.902655_g35780_i0	PRJNA839281	36049	162	0.902655	1.4623011	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	74.3	5.97e-16	NR	MBK7998698.1	2026799	g35780	i0	97.4	0.722222222222222	39	1	72.2	0	119	3	1	39	MBK7998698.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	117	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;