metadata: contig_metadata: 9 rows where bioproject = "PRJNA1097627" and tax

9 rows where bioproject = "PRJNA1097627" and tax_clade = "PVC group"

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
14235251	14235251	PRJNA1097627_P_NODE_191172_length_243_cov_0.905882_g190879_i0	PRJNA1097627	191172	243	0.905882	2.20129326	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	250	7.2399999999999995e-62	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g190879	i0	89.744	0.802469135802469	195	20	80	0	49	243	5290577	5290771	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	195	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
22696689	22696689	PRJNA1097627_P_NODE_160238_length_248_cov_0.880000_g159945_i0	PRJNA1097627	160238	248	0.88	2.1824	Gemmata	113	Bacteria	Bacteria	318	1.9999999999999996e-82	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g159945	i0	89.919	7.95564516129032	248	23	99	2	1	247	604795	604549	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1973	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
26782987	26782987	PRJNA1097627_P_NODE_182181_length_244_cov_0.900585_g181888_i0	PRJNA1097627	182181	244	0.900585	2.1974274	Gemmataceae bacterium	2052164	Bacteria	Bacteria	76.6	1.06e-14	NR	MBX9583031.1	2052164	g181888	i0	61	1.53688524590164	59	23	72.5	0	66	242	8	66	MBX9583031.1 hypothetical protein [Gemmataceae bacterium]	diamond	375	76.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30130484	30130484	PRJNA1097627_P_NODE_156052_length_248_cov_1.594286_g155759_i0	PRJNA1097627	156052	248	1.594286	3.95382928	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	124	1.56e-32	NR	HEX8521286.1	2876886	g155759	i0	75.6	1.98387096774194	82	20	99.2	0	3	248	108	189	HEX8521286.1 3-methyl-2-oxobutanoate hydroxymethyltransferase [Tepidisphaeraceae bacterium]	diamond	492	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30162197	30162197	PRJNA1097627_P_NODE_164432_length_247_cov_0.885057_g164139_i0	PRJNA1097627	164432	247	0.885057	2.18609079	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	44.3	0.0116	NR	MCQ2391274.1	2212473	g164139	i0	35.3	0.619433198380567	51	33	61.9	0	37	189	100	150	MCQ2391274.1 autotransporter-associated beta strand repeat-containing protein [Kiritimatiellia bacterium]	diamond	153	44.3	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31110111	31110111	PRJNA1097627_P_NODE_204495_length_241_cov_0.916667_g204202_i0	PRJNA1097627	204495	241	0.916667	2.20916747	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	76.6	4.24e-14	NR	MEM9400762.1	2026799	g204202	i0	60	0.684647302904564	55	22	68.5	0	172	8	671	725	MEM9400762.1 reverse transcriptase domain-containing protein [Verrucomicrobiota bacterium]	diamond	165	76.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31236591	31236591	PRJNA1097627_P_NODE_143015_length_251_cov_0.865169_g142722_i0	PRJNA1097627	143015	251	0.865169	2.17157419	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	99	6.710000000000001e-22	NR	HLL90464.1	2876886	g142722	i0	58.5	1.94820717131474	82	34	98	0	246	1	220	301	HLL90464.1 DUF6785 family protein [Tepidisphaeraceae bacterium]	diamond	489	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31331540	31331540	PRJNA1097627_P_NODE_181796_length_244_cov_0.900585_g181503_i0	PRJNA1097627	181796	244	0.900585	2.1974274	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	42	0.0314	NR	MBU1906516.1	2035772	g181503	i0	40	0.614754098360656	50	28	61.5	2	222	73	18	65	MBU1906516.1 chemotaxis protein CheW [Candidatus Omnitrophota bacterium]	diamond	150	42	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
31765676	31765676	PRJNA1097627_P_NODE_198317_length_242_cov_0.911243_g198024_i0	PRJNA1097627	198317	242	0.911243	2.20520806	Phycisphaerae	666505	Bacteria	Bacteria	125	1.61e-31	NR	MDB5328606.1	2052180	g198024	i0	72.5	2.97520661157025	80	22	99.2	0	241	2	381	460	MDB5328606.1 UDP-galactopyranose mutase [Phycisphaerales bacterium]	diamond	720	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;