metadata: contig_metadata: 14 rows where bioproject = "PRJNA939369", tax_clade = "PVC group" and tax

14 rows where bioproject = "PRJNA939369", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
3465253	3465253	PRJNA939369_S_NODE_5383_length_528_cov_4.575824_g4967_i0	PRJNA939369	5383	528	4.575824	24.16035072	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	795	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4967	i0	93.785	77.907196969697	531	30	100	3	1	528	2002824	2003354	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	41135	795	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8908881	8908881	PRJNA939369_S_NODE_22207_length_327_cov_2.791339_g21790_i0	PRJNA939369	22207	327	2.791339	9.12767853	Gemmataceae	1914233	Bacteria	Bacteria	453	7.210000000000001e-123	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g21790	i0	91.743	130.834862385321	327	25	100	2	1	327	1034777	1035101	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	42783	455	0.995604395604396	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
16217244	16217244	PRJNA939369_S_NODE_2833_length_674_cov_5.935108_g2437_i0	PRJNA939369	2833	674	5.935108	40.00262792	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	1201	0	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g2437	i0	98.813	119.197329376855	674	8	100	0	1	674	1092265	1092938	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	80339	1201	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
18766313	18766313	PRJNA939369_S_NODE_68755_length_244_cov_1.426901_g68338_i0	PRJNA939369	68755	244	1.426901	3.48163844	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	200	7.4299999999999985e-47	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g68338	i0	81.855	89.0081967213115	248	36	100	6	1	244	1866433	1866675	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	21718	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21316265	21316265	PRJNA939369_S_NODE_16157_length_361_cov_1.479167_g15740_i0	PRJNA939369	16157	361	1.479167	5.33979287	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	623	5.779999999999999e-174	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g15740	i0	97.784	137.02216066482	361	8	100	0	1	361	2003835	2003475	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	49465	623	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21658318	21658318	PRJNA939369_S_NODE_2057_length_769_cov_4.298851_g1685_i0	PRJNA939369	2057	769	4.298851	33.05816419	Gemmataceae	1914233	Bacteria	Bacteria	1254	0	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g1685	i0	96.224	174.561768530559	768	25	99	3	1	766	3634444	3633679	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	134238	1260	0.995238095238095	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
26835258	26835258	PRJNA939369_S_NODE_44641_length_267_cov_1.582474_g44224_i0	PRJNA939369	44641	267	1.582474	4.22520558	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	94.4	7.4e-22	NR	MBO5437458.1	2691551	g44224	i0	81.5	0.606741573033708	54	10	60.7	0	2	163	140	193	MBO5437458.1 HK97 family phage prohead protease [Thermoguttaceae bacterium]	diamond	162	94.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
27095191	27095191	PRJNA939369_S_NODE_67602_length_245_cov_0.895349_g67185_i0	PRJNA939369	67602	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	70.1	5.84e-12	NR	MBI68501.1	2026778	g67185	i0	66	1.1265306122449	47	16	57.6	0	1	141	260	306	MBI68501.1 hypothetical protein [Phycisphaerae bacterium]	diamond	276	70.5	0.994326241134752	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27530536	27530536	PRJNA939369_S_NODE_24963_length_317_cov_0.946721_g24546_i0	PRJNA939369	24963	317	0.946721	3.00110557	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	98.2	4.0799999999999996e-23	NR	MBQ2850058.1	2691551	g24546	i0	58.7	2.12933753943218	75	31	71	0	309	85	115	189	MBQ2850058.1 hypothetical protein [Thermoguttaceae bacterium]	diamond	675	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
28667367	28667367	PRJNA939369_S_NODE_32827_length_293_cov_1.222727_g32410_i0	PRJNA939369	32827	293	1.222727	3.58259011	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	44.3	0.0133	NR	MBR0225112.1	2691551	g32410	i0	48.6	0.747440273037543	37	19	37.9	0	178	288	6	42	MBR0225112.1 hypothetical protein [Thermoguttaceae bacterium]	diamond	219	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
29014857	29014857	PRJNA939369_S_NODE_72588_length_243_cov_0.888235_g72171_i0	PRJNA939369	72588	243	0.888235	2.15841105	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	43.5	0.0197	NR	MCC6321303.1	2052180	g72171	i0	38.2	0.839506172839506	68	41	82.7	1	220	20	96	163	MCC6321303.1 S8 family serine peptidase [Phycisphaerales bacterium]	diamond	204	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29898761	29898761	PRJNA939369_S_NODE_68831_length_244_cov_1.350877_g68414_i0	PRJNA939369	68831	244	1.350877	3.29613988	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	65.5	3.8e-10	NR	MBQ9372152.1	2691551	g68414	i0	45.8	1.02049180327869	83	41	99.6	3	243	1	481	561	MBQ9372152.1 fibronectin type III domain-containing protein [Thermoguttaceae bacterium]	diamond	249	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
30885089	30885089	PRJNA939369_S_NODE_73714_length_242_cov_0.911243_g73297_i0	PRJNA939369	73714	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	80.1	2.55e-15	NR	MDP7254702.1	2026780	g73297	i0	50.6	7.5495867768595	87	35	97.9	2	237	1	559	645	MDP7254702.1 Mu-like prophage major head subunit gpT family protein [Planctomycetota bacterium]	diamond	1827	80.9	0.990111248454882	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31036347	31036347	PRJNA939369_S_NODE_27055_length_310_cov_0.869198_g26638_i0	PRJNA939369	27055	310	0.869198	2.6945138	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	43.5	0.0103	NR	MAO23689.1	2026778	g26638	i0	38.7	0.725806451612903	75	35	64.8	3	208	8	1	72	MAO23689.1 hypothetical protein [Phycisphaerae bacterium]	diamond	225	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae 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);;