metadata: contig_metadata: 15 rows where bioproject = "PRJNA909412", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJNA909412", 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
1249231	1249231	PRJNA909412_P_NODE_12981_length_161_cov_2.008197_g12840_i0	PRJNA909412	12981	161	2.008197	3.23319717	Rosistilla	2795779	Bacteria	Bacteria	167	4.5799999999999995e-37	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g12840	i0	85.976	115.062111801242	164	14	99	9	3	161	974730	974889	Rosistilla ulvae strain EC9 chromosome	blastn	18525	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
5077425	5077425	PRJNA909412_P_NODE_12184_length_163_cov_1.725806_g12043_i0	PRJNA909412	12184	163	1.725806	2.81306378	Gemmataceae	1914233	Bacteria	Bacteria	209	7.62e-50	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g12043	i0	90.244	356.398773006135	164	10	98	6	1	160	3633834	3633673	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	58093	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
12728684	12728684	PRJNA909412_P_NODE_9410_length_175_cov_1.220588_g9269_i0	PRJNA909412	9410	175	1.220588	2.136029	Gimesia	1649453	Bacteria	Bacteria	95.3	2.42e-15	NTclustered	gi\|1712496122\|gb\|CP036269.1\|	2527973	g9269	i0	77.64	21.5085714285714	161	33	92	3	1	161	2394735	2394892	Gimesia alba strain Pan241w chromosome	blastn	3764	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia alba
16551671	16551671	PRJNA909412_P_NODE_1353_length_474_cov_3.337931_g1214_i0	PRJNA909412	1353	474	3.337931	15.82179294	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	241	1.05e-74	NR	NUQ35036.1	2026779	g1214	i0	64.6	5.6075949367088596	178	41	98.7	1	2	469	97	274	NUQ35036.1 adenosylhomocysteinase [Planctomycetaceae bacterium]	diamond	2658	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
17468980	17468980	PRJNA909412_P_NODE_3274_length_291_cov_1.416667_g3133_i0	PRJNA909412	3274	291	1.416667	4.12250097	Lignipirellula cremea	2528010	Bacteria	Bacteria	315	3.11e-81	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g3133	i0	89.02	96.7457044673539	255	26	87	2	35	288	1144396	1144143	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	28153	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
20375513	20375513	PRJNA909412_P_NODE_17536_length_150_cov_2.846847_g17395_i0	PRJNA909412	17536	150	2.846847	4.2702705	Bacteria	2	Bacteria	Bacteria	207	2.46e-49	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g17395	i0	91.946	10.04	149	10	99	2	2	150	2582829	2582975	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	1506	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23842953	23842953	PRJNA909412_P_NODE_7139_length_197_cov_4.392405_g6998_i0	PRJNA909412	7139	197	4.392405	8.65303785	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.9	7.88e-6	NTclustered	gi\|2907625648\|emb\|OZ223208.1\|	2026780	g6998	i0	95.122	1.11675126903553	41	1	20	1	104	143	1495077	1495117	MAG: Planctomycetota bacterium isolate 604ccff8-4b2f-4b13-82eb-4b7433267518 genome assembly, chromosome: 1	blastn	220	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26897966	26897966	PRJNA909412_P_NODE_13481_length_160_cov_2.851240_g13340_i0	PRJNA909412	13481	160	2.85124	4.561984	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	50.4	2.23e-5	NR	MCE5340208.1	2026779	g13340	i0	47.4	2.1375	57	25	97.5	1	3	158	828	884	MCE5340208.1 translation initiation factor IF-2 [Planctomycetaceae bacterium]	diamond	342	50.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27118987	27118987	PRJNA909412_P_NODE_16222_length_152_cov_2.123894_g16081_i0	PRJNA909412	16222	152	2.123894	3.22831888	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	90.5	9.5e-20	NR	MCI0362746.1	2052180	g16081	i0	85.1	10.1052631578947	47	7	92.8	0	11	151	151	197	MCI0362746.1 MmgE/PrpD family protein [Phycisphaerales bacterium]	diamond	1536	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29203609	29203609	PRJNA909412_P_NODE_12169_length_163_cov_2.016129_g12028_i0	PRJNA909412	12169	163	2.016129	3.28629027	Planctomycetota bacterium	2026780	Bacteria	Bacteria	80.5	5.94e-16	NR	MBM3984144.1	2026780	g12028	i0	73.5	7.38036809815951	49	13	90.2	0	154	8	302	350	MBM3984144.1 M20/M25/M40 family metallo-hydrolase [Planctomycetota bacterium]	diamond	1203	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31478324	31478324	PRJNA909412_P_NODE_3816_length_269_cov_1.073913_g3675_i0	PRJNA909412	3816	269	1.073913	2.88882597	Planctomycetota bacterium	2026780	Bacteria	Bacteria	83.2	4.8e-17	NR	MCB9913063.1	2026780	g3675	i0	55.7	2.63197026022305	79	34	88.1	1	267	31	171	248	MCB9913063.1 SDR family oxidoreductase [Planctomycetota bacterium]	diamond	708	83.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31699578	31699578	PRJNA909412_P_NODE_11217_length_171_cov_1.727273_g11076_i0	PRJNA909412	11217	171	1.727273	2.95363683	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.2	0.0498	NR	HZW05812.1	2052180	g11076	i0	50	0.631578947368421	36	14	56.1	1	52	147	40	75	HZW05812.1 class I SAM-dependent methyltransferase [Phycisphaerales bacterium]	diamond	108	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32015861	32015861	PRJNA909412_P_NODE_4978_length_234_cov_1.487179_g4837_i0	PRJNA909412	4978	234	1.487179	3.47999886	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.2	3.05e-12	NR	PCH78894.1	2026780	g4837	i0	46.7	0.961538461538462	75	40	96.2	0	234	10	545	619	PCH78894.1 MAG: hypothetical protein COB96_04960 [Planctomycetota bacterium]	diamond	225	71.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32079118	32079118	PRJNA909412_P_NODE_9478_length_174_cov_2.681481_g9337_i0	PRJNA909412	9478	174	2.681481	4.66577694	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	49.3	7.01e-5	NR	MCH2162015.1	2052180	g9337	i0	40	1.86206896551724	55	31	91.4	1	8	166	359	413	MCH2162015.1 MmgE/PrpD family protein [Phycisphaerales bacterium]	diamond	324	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32427285	32427285	PRJNA909412_P_NODE_1239_length_502_cov_3.231102_g1100_i0	PRJNA909412	1239	502	3.231102	16.22013204	Planctomycetota bacterium	2026780	Bacteria	Bacteria	171	1.12e-48	NR	MCD6378656.1	2026780	g1100	i0	52.5	1.91235059760956	160	75	95	1	486	10	84	243	MCD6378656.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium]	diamond	960	171	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);;