metadata: contig_metadata: 12 rows where bioproject = "PRJNA1253698", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJNA1253698", 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
1052810	1052810	PRJNA1253698_S_NODE_22261_length_163_cov_1.359649_g21895_i0	PRJNA1253698	22261	163	1.359649	2.21622787	Planctomycetia	203683	Bacteria	Bacteria	235	1.26e-57	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g21895	i0	93.21	42.8773006134969	162	8	99	2	3	163	122582	122741	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	6989	237	0.991561181434599	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
5462970	5462970	PRJNA1253698_S_NODE_12545_length_197_cov_0.871622_g12179_i0	PRJNA1253698	12545	197	0.871622	1.71709534	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	246	7.29e-61	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g12179	i0	96.622	190.060913705584	148	5	75	0	2	149	2002707	2002560	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	37442	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8013109	8013109	PRJNA1253698_S_NODE_21227_length_165_cov_0.887931_g20861_i0	PRJNA1253698	21227	165	0.887931	1.46508615	Bremerella volcania	2527984	Bacteria	Bacteria	154	3.68e-33	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g20861	i0	87.313	154.357575757576	134	17	85	0	4	137	2674515	2674648	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	25469	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
8013121	8013121	PRJNA1253698_S_NODE_2707_length_433_cov_2.403646_g2343_i0	PRJNA1253698	2707	433	2.403646	10.40778718	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	418	3.5799999999999995e-112	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g2343	i0	84.439	162.15935334873	437	55	98	10	8	432	7050836	7050401	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	70215	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9980877	9980877	PRJNA1253698_S_NODE_4188_length_340_cov_3.302405_g3822_i0	PRJNA1253698	4188	340	3.302405	11.228177	Isosphaeraceae	1763524	Bacteria	Bacteria	484	2.6699999999999994e-132	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g3822	i0	92.353	173.144117647059	340	26	100	0	1	340	5180272	5180611	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	58869	488	0.991803278688525	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
10563762	10563762	PRJNA1253698_S_NODE_21109_length_165_cov_0.896552_g20743_i0	PRJNA1253698	21109	165	0.896552	1.4793108	Rosistilla ulvae	1930277	Bacteria	Bacteria	169	1.31e-37	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g20743	i0	90.625	65.1757575757576	128	10	77	2	1	127	975932	976058	Rosistilla ulvae strain EC9 chromosome	blastn	10754	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
13113531	13113531	PRJNA1253698_S_NODE_20751_length_165_cov_1.163793_g20385_i0	PRJNA1253698	20751	165	1.163793	1.92025845	Symmachiella dynata	2527995	Bacteria	Bacteria	150	4.76e-32	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g20385	i0	85.034	60.5212121212121	147	22	89	0	4	150	1041607	1041461	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	9986	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
14388814	14388814	PRJNA1253698_S_NODE_6692_length_266_cov_0.875576_g6326_i0	PRJNA1253698	6692	266	0.875576	2.32903216	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	344	3.58e-90	NTclustered	gi\|576901465\|gb\|KF827058.1\|	120965	g6326	i0	90.299	39.6127819548872	268	19	99	7	2	266	306	43	Uncultured planctomycete clone B-30-43 16S ribosomal RNA gene, partial sequence	blastn	10537	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
20761266	20761266	PRJNA1253698_S_NODE_6717_length_265_cov_1.703704_g6351_i0	PRJNA1253698	6717	265	1.703704	4.5148156	Aquisphaera giovannonii	406548	Bacteria	Bacteria	433	7.399999999999998e-117	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g6351	i0	96.212	179.301886792453	264	10	99	0	2	265	5181004	5180741	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	47515	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
22036321	22036321	PRJNA1253698_S_NODE_19938_length_166_cov_1.307692_g19572_i0	PRJNA1253698	19938	166	1.307692	2.17076872	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	202	1.2999999999999998e-47	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g19572	i0	88.69	37.2289156626506	168	15	100	4	1	166	7050404	7050239	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	6180	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24585978	24585978	PRJNA1253698_S_NODE_4480_length_328_cov_2.369176_g4114_i0	PRJNA1253698	4480	328	2.369176	7.77089728	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	370	7.5e-98	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g4114	i0	87.311	95.3993902439024	331	33	98	8	6	328	7051687	7051358	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	31291	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
29095009	29095009	PRJNA1253698_S_NODE_5128_length_305_cov_4.546875_g4762_i0	PRJNA1253698	5128	305	4.546875	13.86796875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.0393	NR	MBN8643811.1	2026780	g4762	i0	40	0.540983606557377	55	31	54.1	1	303	139	289	341	MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium]	diamond	165	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;