metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1115053" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1115053" 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
224635	224635	PRJNA1115053_S_NODE_197281_length_195_cov_1.578947_g195464_i0	PRJNA1115053	197281	195	1.578947	3.07894665	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	250	5.57e-62	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g195464	i0	89.744	2.10769230769231	195	20	100	0	1	195	4955579	4955773	Planctomyces sp. SH-PL14, complete genome	blastn	411	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
225291	225291	PRJNA1115053_S_NODE_223541_length_184_cov_4.000000_g221724_i0	PRJNA1115053	223541	184	4	7.36	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	161	2.5e-35	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g221724	i0	82.703	252.451086956522	185	28	99	4	1	183	2190484	2190302	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	46451	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
6607202	6607202	PRJNA1115053_S_NODE_66926_length_302_cov_4.532819_g65109_i0	PRJNA1115053	66926	302	4.532819	13.68911338	Humisphaera borealis	2807512	Bacteria	Bacteria	220	7.28e-53	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g65109	i0	82.8	141.778145695364	250	39	82	4	5	252	5063090	5062843	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	42817	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
7402101	7402101	PRJNA1115053_S_NODE_163426_length_211_cov_3.232143_g161609_i0	PRJNA1115053	163426	211	3.232143	6.81982173	Gemmata	113	Bacteria	Bacteria	374	3.4799999999999995e-99	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g161609	i0	98.578	161.199052132701	211	3	100	0	1	211	2437	2647	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	34013	374	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
7876648	7876648	PRJNA1115053_S_NODE_159267_length_214_cov_1.397661_g157450_i0	PRJNA1115053	159267	214	1.397661	2.99099454	Planctomycetales bacterium 10988	2603660	Bacteria	Bacteria	265	2.22e-66	NTclustered	gi\|1775855904\|gb\|CP043547.1\|	2603660	g157450	i0	89.904	258.327102803738	208	18	97	3	1	207	2223143	2223348	Planctomycetales bacterium 10988 chromosome, complete genome	blastn	55282	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 10988
7878618	7878618	PRJNA1115053_S_NODE_240667_length_179_cov_0.889706_g238850_i0	PRJNA1115053	240667	179	0.889706	1.59257374	Humisphaera borealis	2807512	Bacteria	Bacteria	156	1.12e-33	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g238850	i0	87.879	10.7486033519553	132	16	77	0	10	141	5062814	5062683	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	1924	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
10432443	10432443	PRJNA1115053_S_NODE_59989_length_315_cov_2.275735_g58172_i0	PRJNA1115053	59989	315	2.275735	7.16856525	Urbifossiella limnaea	2528023	Bacteria	Bacteria	346	1.21e-90	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g58172	i0	86.667	127.101587301587	315	39	100	3	1	315	2017982	2018293	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	40037	346	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11227686	11227686	PRJNA1115053_S_NODE_185749_length_200_cov_1.834395_g183932_i0	PRJNA1115053	185749	200	1.834395	3.66879	Akkermansia	239934	Bacteria	Bacteria	364	1.96e-96	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g183932	i0	99.5	296.005	200	1	100	0	1	200	138270	138469	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	59201	364	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
11228055	11228055	PRJNA1115053_S_NODE_56729_length_321_cov_8.705036_g54912_i0	PRJNA1115053	56729	321	8.705036	27.94316556	Gemmata	113	Bacteria	Bacteria	505	1.9199999999999995e-138	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g54912	i0	95.046	160.545171339564	323	12	100	4	1	321	559490	559170	Gemmata sp. SH-PL17, complete genome	blastn	51535	505	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
12503642	12503642	PRJNA1115053_S_NODE_990_length_1687_cov_17.725061_g585_i0	PRJNA1115053	990	1687	17.725061	299.02177907	Frigoriglobus	2774146	Bacteria	Bacteria	2488	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g585	i0	93.668	182.708358032009	1674	88	99	17	26	1687	2001625	2003292	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	308229	2505	0.993213572854291	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15528659	15528659	PRJNA1115053_S_NODE_256873_length_173_cov_2.307692_g255056_i0	PRJNA1115053	256873	173	2.307692	3.99230716	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	204	3.789999999999999e-48	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g255056	i0	88.136	86.7109826589595	177	13	100	7	1	173	3894028	3894200	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	15001	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19349947	19349947	PRJNA1115053_S_NODE_1676_length_1224_cov_7.557155_g809_i1	PRJNA1115053	1676	1224	7.557155	92.4995772	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	1184	0	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g809	i1	85.714	148.976307189542	1148	135	92	24	94	1224	2503715	2502580	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	182347	1184	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
19351217	19351217	PRJNA1115053_S_NODE_222036_length_185_cov_1.633803_g220219_i0	PRJNA1115053	222036	185	1.633803	3.02253555	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	169	1.5e-37	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g220219	i0	85.455	34.2	165	20	89	3	22	185	1831291	1831452	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	6327	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
23175496	23175496	PRJNA1115053_S_NODE_1319_length_1398_cov_7.240590_g809_i0	PRJNA1115053	1319	1398	7.24059	101.22344820000001	Humisphaera borealis	2807512	Bacteria	Bacteria	1373	0	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g809	i0	86.113	334.152360515021	1289	162	92	16	24	1305	5064120	5062842	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	467145	1373	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis

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);;