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

14 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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
1558270	1558270	PRJNA1132896_P_NODE_9462_length_243_cov_0.905882_g9371_i0	PRJNA1132896	9462	243	0.905882	2.20129326	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g9371	i0	100	258.172839506173	234	0	96	0	10	243	5624923	5625156	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	62736	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
5386840	5386840	PRJNA1132896_P_NODE_5525_length_267_cov_1.530928_g5434_i0	PRJNA1132896	5525	267	1.530928	4.08757776	Rhodopirellula baltica	265606	Bacteria	Bacteria	154	6.51e-33	NTclustered	gi\|32443466\|emb\|BX294138.1\|	243090	g5434	i0	87.313	2.22846441947566	134	17	50	0	102	235	270530	270663	Rhodopirellula baltica SH 1 complete genome; segment 6/24	blastn	595	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
6661551	6661551	PRJNA1132896_P_NODE_9266_length_244_cov_0.900585_g9175_i0	PRJNA1132896	9266	244	0.900585	2.1974274	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	244	3.3799999999999997e-60	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g9175	i0	85.185	86.2131147540984	243	31	99	3	1	242	1577571	1577809	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	21036	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11762245	11762245	PRJNA1132896_P_NODE_5570_length_266_cov_3.119171_g5479_i0	PRJNA1132896	5570	266	3.119171	8.29699486	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	370	5.91e-98	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5479	i0	92.045	192.751879699248	264	19	99	2	1	263	2002586	2002848	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	51272	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13037382	13037382	PRJNA1132896_P_NODE_8311_length_247_cov_0.885057_g8220_i0	PRJNA1132896	8311	247	0.885057	2.18609079	Humisphaera borealis	2807512	Bacteria	Bacteria	219	2.08e-52	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g8220	i0	82.625	39.6558704453441	259	33	100	3	1	247	5063400	5063142	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	9795	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13037388	13037388	PRJNA1132896_P_NODE_871_length_552_cov_1.697286_g780_i0	PRJNA1132896	871	552	1.697286	9.36901872	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	760	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g780	i0	91.697	76.7355072463768	554	36	100	5	1	552	2003293	2002748	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	42358	760	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15586556	15586556	PRJNA1132896_P_NODE_6873_length_251_cov_0.865169_g6782_i0	PRJNA1132896	6873	251	0.865169	2.17157419	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	161	3.62e-35	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g6782	i0	78.656	1.00796812749004	253	46	99	7	3	251	2179513	2179265	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	253	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20685047	20685047	PRJNA1132896_P_NODE_8357_length_246_cov_1.780347_g8266_i0	PRJNA1132896	8357	246	1.780347	4.37965362	Humisphaera borealis	2807512	Bacteria	Bacteria	300	7.19e-77	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g8266	i0	91.743	82.1056910569106	218	14	89	4	31	246	5064120	5063905	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	20198	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
21433660	21433660	PRJNA1132896_P_NODE_4677_length_279_cov_3.907767_g4586_i0	PRJNA1132896	4677	279	3.907767	10.90266993	Gemmata	113	Bacteria	Bacteria	433	7.85e-117	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g4586	i0	94.624	41.1756272401434	279	15	100	0	1	279	2944243	2944521	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	11488	435	0.995402298850575	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
21960379	21960379	PRJNA1132896_P_NODE_10718_length_203_cov_5.307692_g10627_i0	PRJNA1132896	10718	203	5.307692	10.77461476	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	307	3.42e-79	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g10627	i0	94.059	151.177339901478	202	12	99	0	2	203	557570	557369	Gemmata sp. SH-PL17, complete genome	blastn	30689	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
23984092	23984092	PRJNA1132896_P_NODE_6499_length_253_cov_2.500000_g6408_i0	PRJNA1132896	6499	253	2.5	6.325	Gemmata	113	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g6408	i0	98.419	114.861660079051	253	4	100	0	1	253	1038313	1038061	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	29060	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
23984096	23984096	PRJNA1132896_P_NODE_7119_length_250_cov_0.870056_g7028_i0	PRJNA1132896	7119	250	0.870056	2.17514	Akkermansia	239934	Bacteria	Bacteria	455	1.48e-123	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g7028	i0	99.598	98.472	249	1	99	0	2	250	1475791	1476039	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	24618	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
24509592	24509592	PRJNA1132896_P_NODE_6840_length_251_cov_0.865169_g6749_i0	PRJNA1132896	6840	251	0.865169	2.17157419	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	279	9.58e-71	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g6749	i0	86.853	30.2430278884462	251	32	100	1	1	251	2191197	2191446	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	7591	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
25258082	25258082	PRJNA1132896_P_NODE_500_length_740_cov_8.568216_g413_i0	PRJNA1132896	500	740	8.568216	63.4047984	Gemmata	113	Bacteria	Bacteria	1177	0	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g413	i0	95.412	151.643243243243	741	30	99	4	1	738	2022090	2021351	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	112216	1177	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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