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

5 rows where bioproject = "PRJEB12982", 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
3847159	3847159	PRJEB12982_P_NODE_17884_length_166_cov_0.871795_g17721_i0	PRJEB12982	17884	166	0.871795	1.4471797	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	200	4.69e-47	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g17721	i0	88.554	4.85542168674699	166	18	100	1	1	166	3991817	3991981	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	806	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
7673144	7673144	PRJEB12982_P_NODE_17427_length_166_cov_1.299145_g17264_i0	PRJEB12982	17427	166	1.299145	2.1565807	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	165	1.7100000000000002e-36	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g17264	i0	87.413	199.759036144578	143	18	86	0	5	147	3046308	3046450	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	33160	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
10223775	10223775	PRJEB12982_P_NODE_3949_length_383_cov_2.571856_g3786_i0	PRJEB12982	3949	383	2.571856	9.85020848	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	357	6.91e-94	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g3786	i0	83.721	226.480417754569	387	54	100	9	1	383	2163060	2163441	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	86742	357	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
26843372	26843372	PRJEB12982_P_NODE_7101_length_273_cov_0.906250_g6938_i0	PRJEB12982	7101	273	0.90625	2.4740625	Cerasicoccus arenae	424488	Bacteria	Bacteria	82	1.4e-16	NR	WP_189512798.1	424488	g6938	i0	43.2	0.967032967032967	88	50	96.7	0	5	268	76	163	WP_189512798.1 putative 4-mercaptohistidine N1-methyltransferase [Cerasicoccus arenae]	diamond	264	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Cerasicoccus	Cerasicoccus arenae
28517482	28517482	PRJEB12982_P_NODE_16767_length_167_cov_1.296610_g16604_i0	PRJEB12982	16767	167	1.29661	2.1653387	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	79.7	8.17e-16	NR	RYD71398.1	2026800	g16604	i0	64.8	0.970059880239521	54	19	97	0	3	164	236	289	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	162	79.7	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);;