metadata: contig_metadata: 14 rows where bioproject = "PRJNA929924" and tax

14 rows where bioproject = "PRJNA929924" 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
3459769	3459769	PRJNA929924_P_NODE_13603_length_183_cov_1.395522_g13440_i0	PRJNA929924	13603	183	1.395522	2.55380526	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	161	2.48e-35	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g13440	i0	83.626	32.1475409836066	171	28	93	0	12	182	7881593	7881423	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	5883	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
4737220	4737220	PRJNA929924_P_NODE_12384_length_197_cov_1.405405_g12221_i0	PRJNA929924	12384	197	1.405405	2.76864785	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	359	8.98e-95	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g12221	i0	99.492	109.157360406091	197	1	100	0	1	197	555271	555075	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	21504	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7632353	7632353	PRJNA929924_P_NODE_18286_length_162_cov_0.920354_g18123_i0	PRJNA929924	18286	162	0.920354	1.49097348	Gemmata	113	Bacteria	Bacteria	191	2.74e-44	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g18123	i0	88.125	24.1666666666667	160	19	99	0	2	161	6455699	6455858	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	3915	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
11112472	11112472	PRJNA929924_P_NODE_10829_length_226_cov_1.468927_g10666_i0	PRJNA929924	10829	226	1.468927	3.31977502	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	407	3.73e-109	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g10666	i0	99.115	89.0619469026549	226	2	100	0	1	226	626	851	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	20128	407	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
11112546	11112546	PRJNA929924_P_NODE_17229_length_164_cov_0.904348_g17066_i0	PRJNA929924	17229	164	0.904348	1.48313072	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	165	1.69e-36	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g17066	i0	88.806	72.1158536585366	134	15	82	0	31	164	305631	305764	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	11827	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
13662479	13662479	PRJNA929924_P_NODE_10651_length_230_cov_1.331492_g10488_i0	PRJNA929924	10651	230	1.331492	3.0624316	Rohdeia mirabilis	2528008	Bacteria	Bacteria	243	1.14e-59	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g10488	i0	85.837	357.586956521739	233	27	100	6	1	230	3893982	3894211	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	82245	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
14936909	14936909	PRJNA929924_P_NODE_3812_length_899_cov_2.590588_g3698_i0	PRJNA929924	3812	899	2.590588	23.28938612	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1310	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g3698	i0	93.008	135.430478309232	901	58	100	4	1	899	1868036	1868933	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	121752	1310	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
17487180	17487180	PRJNA929924_P_NODE_17114_length_164_cov_0.991304_g16951_i0	PRJNA929924	17114	164	0.991304	1.62573856	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	261	2.09e-65	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g16951	i0	95.21	273.420731707317	167	4	100	4	1	164	632	467	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	44841	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
17487319	17487319	PRJNA929924_P_NODE_8054_length_328_cov_2.318996_g7891_i0	PRJNA929924	8054	328	2.318996	7.60630688	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	451	2.6e-122	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g7891	i0	91.463	302.582317073171	328	28	100	0	1	328	1867555	1867228	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	99247	451	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
17831757	17831757	PRJNA929924_P_NODE_16134_length_166_cov_2.410256_g15971_i0	PRJNA929924	16134	166	2.410256	4.00102496	root	1	Root_unresolved	Root_unresolved	207	2.8e-49	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g15971	i0	92.958	123.644578313253	142	10	86	0	24	165	1155520	1155661	Planctomyces sp. SH-PL62, complete genome	blastn	20525	209	0.990430622009569	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
20035670	20035670	PRJNA929924_P_NODE_9976_length_245_cov_3.000000_g9813_i0	PRJNA929924	9976	245	3	7.35	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	263	9.38e-66	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g9813	i0	89.806	7.8734693877551	206	20	84	1	1	206	1866703	1866499	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1929	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
29456176	29456176	PRJNA929924_P_NODE_15670_length_168_cov_0.873950_g15507_i0	PRJNA929924	15670	168	0.87395	1.468236	Gemmataceae bacterium	2052164	Bacteria	Bacteria	94	2.6099999999999994e-23	NR	MSU77609.1	2052164	g15507	i0	74.5	0.982142857142857	55	14	98.2	0	2	166	6	60	MSU77609.1 hypothetical protein [Gemmataceae bacterium]	diamond	165	94	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31257186	31257186	PRJNA929924_P_NODE_12735_length_192_cov_1.342657_g12572_i0	PRJNA929924	12735	192	1.342657	2.57790144	Planctomycetota bacterium	2026780	Bacteria	Bacteria	86.7	6.48e-18	NR	MEK6701863.1	2026780	g12572	i0	68.3	5.046875	63	19	96.9	1	1	186	337	399	MEK6701863.1 HlyD family efflux transporter periplasmic adaptor subunit [Planctomycetota bacterium]	diamond	969	86.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31288740	31288740	PRJNA929924_P_NODE_15395_length_168_cov_0.873950_g15232_i0	PRJNA929924	15395	168	0.87395	1.468236	Planctomycetota bacterium	2026780	Bacteria	Bacteria	88.6	4.17e-20	NR	MEK6702762.1	2026780	g15232	i0	80	0.982142857142857	55	11	98.2	0	166	2	69	123	MEK6702762.1 ATP synthase F1 subunit delta [Planctomycetota bacterium]	diamond	165	88.6	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);;