metadata: contig_metadata: 22 rows where bioproject = "PRJNA939370" and tax

22 rows where bioproject = "PRJNA939370" 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
914611	914611	PRJNA939370_S_NODE_1281_length_245_cov_1.127551_g1229_i0	PRJNA939370	1281	245	1.127551	2.76249995	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	331	2.5400000000000002e-86	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g1229	i0	91.322	15.6081632653061	242	21	99	0	1	242	3453945	3453704	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	3824	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
914625	914625	PRJNA939370_S_NODE_2361_length_178_cov_1.759690_g2309_i0	PRJNA939370	2361	178	1.75969	3.1322482	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	224	3.0199999999999996e-54	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g2309	i0	96.377	171.960674157303	138	1	76	4	1	136	3454726	3454591	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	30609	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
2190046	2190046	PRJNA939370_S_NODE_1702_length_209_cov_1.843750_g1650_i0	PRJNA939370	1702	209	1.84375	3.8534375	Paludisphaera borealis	1387353	Bacteria	Bacteria	296	7.67e-76	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g1650	i0	92.754	134.521531100478	207	11	98	4	1	205	121314	121518	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	28115	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
3808189	3808189	PRJNA939370_S_NODE_3063_length_163_cov_1.964912_g3011_i0	PRJNA939370	3063	163	1.964912	3.20280656	Aquisphaera	1511635	Bacteria	Bacteria	215	1.64e-51	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g3011	i0	91.72	122.539877300613	157	10	96	3	8	163	5178492	5178338	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	19974	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
7292800	7292800	PRJNA939370_S_NODE_2826_length_167_cov_0.864407_g2774_i0	PRJNA939370	2826	167	0.864407	1.44355969	Humisphaera borealis	2807512	Bacteria	Bacteria	228	2.1699999999999995e-55	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g2774	i0	92.994	14.7724550898204	157	10	96	1	11	167	5063297	5063142	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	2467	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
8567613	8567613	PRJNA939370_S_NODE_2287_length_181_cov_2.037879_g2235_i0	PRJNA939370	2287	181	2.037879	3.68856099	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	268	1.3999999999999999e-67	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g2235	i0	93.37	143.911602209945	181	12	100	0	1	181	2690	2510	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	26048	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
9842671	9842671	PRJNA939370_S_NODE_2548_length_173_cov_0.862903_g2496_i0	PRJNA939370	2548	173	0.862903	1.49282219	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	285	1.32e-72	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g2496	i0	97.041	77.1156069364162	169	5	98	0	5	173	5153560	5153392	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	13341	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11118321	11118321	PRJNA939370_S_NODE_2249_length_183_cov_1.022388_g2197_i0	PRJNA939370	2249	183	1.022388	1.87097004	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	292	8.44e-75	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g2197	i0	96.089	66.6284153005465	179	7	98	0	1	179	4420184	4420006	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	12193	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11118334	11118334	PRJNA939370_S_NODE_889_length_307_cov_1.360465_g837_i0	PRJNA939370	889	307	1.360465	4.17662755	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	385	2.49e-102	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g837	i0	89.508	74.2052117263844	305	30	99	2	4	307	1315949	1316252	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	22781	385	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14942568	14942568	PRJNA939370_S_NODE_1472_length_226_cov_1.435028_g1420_i0	PRJNA939370	1472	226	1.435028	3.24316328	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	346	8.24e-91	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g1420	i0	94.248	118.809734513274	226	13	100	0	1	226	2621598	2621373	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	26851	346	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14942573	14942573	PRJNA939370_S_NODE_1732_length_208_cov_0.949686_g1680_i0	PRJNA939370	1732	208	0.949686	1.97534688	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	329	7.52e-86	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g1680	i0	95.192	88.6538461538462	208	10	100	0	1	208	1404229	1404436	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	18440	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
14942587	14942587	PRJNA939370_S_NODE_2912_length_165_cov_1.775862_g2860_i0	PRJNA939370	2912	165	1.775862	2.9301723	Paludisphaera borealis	1387353	Bacteria	Bacteria	200	4.659999999999998e-47	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g2860	i0	88.623	13.2	167	15	100	4	1	165	121636	121472	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	2178	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
16217623	16217623	PRJNA939370_S_NODE_1553_length_220_cov_1.023392_g1501_i0	PRJNA939370	1553	220	1.023392	2.2514624	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	276	1.06e-69	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g1501	i0	89.45	94.4409090909091	218	23	99	0	3	220	3454785	3455002	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	20777	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
16217624	16217624	PRJNA939370_S_NODE_1673_length_212_cov_1.128834_g1621_i0	PRJNA939370	1673	212	1.128834	2.39312808	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	279	7.850000000000001e-71	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g1621	i0	90.61	117.353773584906	213	17	100	3	1	212	4422611	4422401	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	24879	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
16558697	16558697	PRJNA939370_S_NODE_973_length_289_cov_1.358333_g921_i0	PRJNA939370	973	289	1.358333	3.92558237	Planctomycetia	203683	Bacteria	Bacteria	407	4.959999999999999e-109	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g921	i0	92.069	111.318339100346	290	22	100	1	1	289	5936619	5936908	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	32171	407	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17833633	17833633	PRJNA939370_S_NODE_1594_length_217_cov_1.273810_g1542_i0	PRJNA939370	1594	217	1.27381	2.7641677	Singulisphaera	466152	Bacteria	Bacteria	329	7.91e-86	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g1542	i0	94.009	249.967741935484	217	13	100	0	1	217	1526	1742	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	54243	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
19107547	19107547	PRJNA939370_S_NODE_3275_length_161_cov_0.991071_g3223_i0	PRJNA939370	3275	161	0.991071	1.59562431	Verrucomicrobiota	74201	Bacteria	Bacteria	202	1.26e-47	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g3223	i0	89.873	31.1366459627329	158	14	98	2	3	160	3646	3801	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	5013	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
21316745	21316745	PRJNA939370_S_NODE_2397_length_177_cov_0.960938_g2345_i0	PRJNA939370	2397	177	0.960938	1.70086026	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	294	2.25e-75	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g2345	i0	96.61	14.5310734463277	177	6	100	0	1	177	2497126	2497302	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	2572	294	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
21658436	21658436	PRJNA939370_S_NODE_357_length_482_cov_1.503464_g305_i0	PRJNA939370	357	482	1.503464	7.24669648	Planctomycetia	203683	Bacteria	Bacteria	534	3.82e-147	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g305	i0	87.852	62.8817427385892	461	48	95	8	23	482	1476	1023	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	30309	536	0.996268656716418	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
22591719	22591719	PRJNA939370_S_NODE_2338_length_179_cov_1.546154_g2286_i0	PRJNA939370	2338	179	1.546154	2.76761566	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	279	6.39e-71	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g2286	i0	95.429	490.050279329609	175	8	98	0	5	179	3455397	3455223	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	87719	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
25140825	25140825	PRJNA939370_S_NODE_640_length_363_cov_1.891720_g588_i0	PRJNA939370	640	363	1.89172	6.8669436	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	486	7.959999999999998e-133	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g588	i0	90.959	127.845730027548	365	27	99	4	4	363	1599427	1599790	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	46408	486	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
32680100	32680100	PRJNA939370_S_NODE_540_length_394_cov_0.910145_g488_i0	PRJNA939370	540	394	0.910145	3.5859713	Limisphaerales bacterium	2052186	Bacteria	Bacteria	48.1	0.00161	NR	MFN3407990.1	2052186	g488	i0	43.6	0.418781725888325	55	28	41.1	2	225	386	90	142	MFN3407990.1 carotenoid biosynthesis protein [Limisphaerales bacterium]	diamond	165	48.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales 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);;