metadata: contig_metadata: 7 rows where bioproject = "PRJEB6584", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJEB6584", 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
25888241	25888241	PRJEB6584o_S_NODE_77915_length_153_cov_3.016949_g77807_i0	PRJEB6584	77915	153	3.016949	4.61593197	Verrucomicrobiota	74201	Bacteria	Bacteria	209	7.03e-50	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g77807	i0	91.447	103.333333333333	152	13	99	0	1	152	1179	1028	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	15810	211	0.990521327014218	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
26024399	26024399	PRJEB6584o_S_NODE_22436_length_195_cov_3.293750_g22328_i0	PRJEB6584	22436	195	3.29375	6.4228125	Verrucomicrobiota	74201	Bacteria	Bacteria	217	5.649999999999999e-52	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g22328	i0	87.047	3.96410256410256	193	24	99	1	1	193	2034	2225	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	773	219	0.990867579908676	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
26069010	26069010	PRJEB6584o_S_NODE_25181_length_189_cov_2.493506_g25073_i0	PRJEB6584	25181	189	2.493506	4.71272634	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	148	2.01e-31	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g25073	i0	83.636	3.5978835978836	165	20	85	7	1	161	1316256	1316095	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	680	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26069752	26069752	PRJEB6584o_S_NODE_9229_length_285_cov_2.600000_g9121_i0	PRJEB6584	9229	285	2.6	7.41	Fontisphaera persica	2974023	Bacteria	Bacteria	272	1.86e-68	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g9121	i0	88.085	127.873684210526	235	21	81	6	55	284	3861308	3861076	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	36444	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
32929019	32929019	PRJEB6584a_S_NODE_7641_length_163_cov_1.703125_g7621_i0	PRJEB6584	7641	163	1.703125	2.77609375	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	56.2	1.22e-7	NR	MBC7979552.1	2562705	g7621	i0	60	0.828220858895706	45	18	82.8	0	27	161	130	174	MBC7979552.1 acetyltransferase [Akkermansiaceae bacterium]	diamond	135	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32946837	32946837	PRJEB6584o_S_NODE_77970_length_153_cov_2.525424_g77862_i0	PRJEB6584	77970	153	2.525424	3.86389872	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	6.67e-4	NR	HOY59968.1	2026799	g77862	i0	52.5	2.92156862745098	40	16	72.5	1	132	22	3	42	HOY59968.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	447	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
33134311	33134311	PRJEB6584o_S_NODE_23671_length_192_cov_2.713376_g23563_i0	PRJEB6584	23671	192	2.713376	5.20968192	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.8	2.44e-5	NR	NOS70016.1	2026799	g23563	i0	58.3	0.5625	36	15	56.3	0	190	83	232	267	NOS70016.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	108	50.8	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);;