metadata: contig_metadata: 11 rows where bioproject = "PRJEB7799", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJEB7799", 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
25528779	25528779	PRJEB7799p_S_NODE_1465_length_353_cov_4.122642_g1442_i0	PRJEB7799	1465	353	4.122642	14.55292626	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	525	1.6399999999999993e-144	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g1442	i0	96.53	47.5552407932011	317	11	90	0	27	343	3557730	3558046	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	16787	525	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25798168	25798168	PRJEB7799a_S_NODE_2107_length_299_cov_1.579545_g2072_i0	PRJEB7799	2107	299	1.579545	4.72283955	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	520	6.34e-143	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g2072	i0	97.993	92.2140468227425	299	6	100	0	1	299	3557748	3558046	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	27572	520	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25801273	25801273	PRJEB7799p_S_NODE_4003_length_253_cov_1.678899_g3980_i0	PRJEB7799	4003	253	1.678899	4.24761447	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	220	5.95e-53	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g3980	i0	84.483	46.0237154150198	232	26	90	8	27	253	3832266	3832492	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	11644	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25934801	25934801	PRJEB7799c_S_NODE_1068_length_319_cov_4.623239_g1045_i0	PRJEB7799	1068	319	4.623239	14.74813241	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	527	4.079999999999998e-145	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g1045	i0	98.653	52.9655172413793	297	4	93	0	1	297	3557750	3558046	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	16896	527	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25936552	25936552	PRJEB7799m_S_NODE_1820_length_166_cov_4.396947_g1815_i0	PRJEB7799	1820	166	4.396947	7.29893202	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	128	2.25e-25	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g1815	i0	82.993	10.921686746988	147	19	87	6	10	153	58139	57996	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	1813	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
25936690	25936690	PRJEB7799n_S_NODE_2572_length_271_cov_2.411017_g2535_i0	PRJEB7799	2572	271	2.411017	6.53385607	Fontisphaera persica	2974023	Bacteria	Bacteria	272	1.7499999999999999e-68	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g2535	i0	88.085	133.671586715867	235	21	85	6	41	270	3861308	3861076	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	36225	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
26073239	26073239	PRJEB7799p_S_NODE_19685_length_165_cov_1.676923_g19662_i0	PRJEB7799	19685	165	1.676923	2.76692295	Opitutia bacterium KCR 482	3034326	Bacteria	Bacteria	207	2.7800000000000002e-49	NTclustered	gi\|2707273910\|gb\|CP149973.1\|	3034326	g19662	i0	89.222	10.9454545454545	167	16	100	2	1	165	1391887	1392053	Opitutia bacterium KCR 482 chromosome, complete genome	blastn	1806	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium KCR 482
26345383	26345383	PRJEB7799p_S_NODE_21815_length_160_cov_2.280000_g21792_i0	PRJEB7799	21815	160	2.28	3.648	Opitutales bacterium ASA1	3081749	Bacteria	Bacteria	58.4	2.85e-4	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g21792	i0	97.059	0.2125	34	1	21	0	23	56	2118225	2118192	Opitutales bacterium ASA1 DNA, complete genome	blastn	34	58.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
26479217	26479217	PRJEB7799c_S_NODE_2240_length_249_cov_2.130841_g2217_i0	PRJEB7799	2240	249	2.130841	5.30579409	Fontisphaera persica	2974023	Bacteria	Bacteria	272	1.5899999999999998e-68	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g2217	i0	88.085	230.799196787149	235	21	92	6	19	248	3861308	3861076	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	57469	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
32913352	32913352	PRJEB7799l_S_NODE_7745_length_185_cov_1.626667_g7716_i0	PRJEB7799	7745	185	1.626667	3.00933395	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	62.4	3.59e-10	NR	MEY2493788.1	2026799	g7716	i0	50.8	1.88108108108108	59	29	95.7	0	185	9	62	120	MEY2493788.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	348	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
33050166	33050166	PRJEB7799n_S_NODE_3637_length_237_cov_2.440594_g3600_i0	PRJEB7799	3637	237	2.440594	5.78420778	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	99.8	4.939999999999999e-23	NR	MBI5770155.1	2026799	g3600	i0	69.1	1.72151898734177	68	21	86.1	0	235	32	168	235	MBI5770155.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	408	99.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);;