metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA1111146" 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
216703	216703	PRJNA1111146_P_NODE_398361_length_179_cov_0.904762_g397223_i0	PRJNA1111146	398361	179	0.904762	1.61952398	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	134	5.2600000000000005e-27	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g397223	i0	84.962	29.2960893854749	133	18	74	2	16	147	7241766	7241897	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	5244	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
217178	217178	PRJNA1111146_P_NODE_96221_length_245_cov_1.895833_g95083_i0	PRJNA1111146	96221	245	1.895833	4.64479085	Urbifossiella limnaea	2528023	Bacteria	Bacteria	268	2.02e-67	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g95083	i0	93.478	100.632653061224	184	7	75	3	18	201	2019218	2019040	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	24655	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
1490631	1490631	PRJNA1111146_P_NODE_224842_length_201_cov_1.540541_g223704_i0	PRJNA1111146	224842	201	1.540541	3.09648741	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	137	4.69e-28	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g223704	i0	84.783	1.43781094527363	138	20	68	1	39	175	4746069	4745932	Luteolibacter sp. LG18 DNA, complete genome	blastn	289	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
1490699	1490699	PRJNA1111146_P_NODE_241302_length_198_cov_1.413793_g240164_i0	PRJNA1111146	241302	198	1.413793	2.79931014	Planctomycetales bacterium	2053591	Bacteria	Bacteria	115	2.16e-21	NTclustered	gi\|2210174292\|gb\|CP060262.1\|	2053591	g240164	i0	94.667	2.16161616161616	75	2	37	2	105	178	3332633	3332706	MAG: Planctomycetales bacterium isolate HK-STAS-UBP7_A-1 chromosome, complete genome	blastn	428	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
1490963	1490963	PRJNA1111146_P_NODE_3002_length_1095_cov_4.047025_g2101_i0	PRJNA1111146	3002	1095	4.047025	44.31492375	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	1482	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2101	i0	91.155	227.85296803653	1108	75	99	22	1	1094	2001997	2003095	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	249499	1482	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2766938	2766938	PRJNA1111146_P_NODE_3003_length_1095_cov_3.027831_g2101_i1	PRJNA1111146	3003	1095	3.027831	33.15474945	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	1258	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2101	i1	89.216	303.968949771689	1020	93	92	16	1	1011	2001997	2003008	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	332846	1258	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2767469	2767469	PRJNA1111146_P_NODE_4143_length_861_cov_7.631188_g3153_i0	PRJNA1111146	4143	861	7.631188	65.70452868	uncultured Planctomycetales bacterium	100371	Bacteria	Bacteria	1184	0	NTclustered	gi\|365928118\|gb\|JN825568.1\|	100371	g3153	i0	91.58	100.749128919861	867	59	99	12	2	861	881	22	Uncultured Planctomycetales bacterium clone Alchichica_AQ2_1_1B_11 small subunit ribosomal RNA gene, partial sequence	blastn	86745	1184	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
4042542	4042542	PRJNA1111146_P_NODE_160544_length_217_cov_1.329268_g159406_i0	PRJNA1111146	160544	217	1.329268	2.88451156	Methylacidimicrobium sp. AP8	2730359	Bacteria	Bacteria	152	1.84e-32	NTclustered	gi\|1934804479\|emb\|LR797830.1\|	2730359	g159406	i0	80	280.456221198157	210	38	96	4	5	213	561270	561476	Methylacidimicrobium sp. AP8 isolate MTHMO1 genome assembly, chromosome: I	blastn	60859	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. AP8
4043467	4043467	PRJNA1111146_P_NODE_382264_length_180_cov_0.897638_g381126_i0	PRJNA1111146	382264	180	0.897638	1.6157484	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	159	8.75e-35	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g381126	i0	83.721	1.9	172	24	94	4	11	180	7662789	7662958	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	342	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
4043866	4043866	PRJNA1111146_P_NODE_6104_length_655_cov_2.006645_g5018_i0	PRJNA1111146	6104	655	2.006645	13.14352475	Urbifossiella limnaea	2528023	Bacteria	Bacteria	641	3.0399999999999993e-179	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g5018	i0	84.545	109.801526717557	660	88	99	12	2	655	2018209	2017558	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	71920	641	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
5319688	5319688	PRJNA1111146_P_NODE_4105_length_867_cov_7.615479_g3117_i0	PRJNA1111146	4105	867	7.615479	66.02620293	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	1277	0	NTclustered	gi\|576901481\|gb\|KF827074.1\|	120965	g3117	i0	93.326	98.7416378316032	869	51	99	6	2	867	876	12	Uncultured planctomycete clone B-30-59 16S ribosomal RNA gene, partial sequence	blastn	85609	1277	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
6593651	6593651	PRJNA1111146_P_NODE_107386_length_239_cov_2.381720_g106248_i0	PRJNA1111146	107386	239	2.38172	5.6923108	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	78.7	3.54e-10	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g106248	i0	85.333	0.313807531380753	75	11	31	0	26	100	5161063	5160989	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	75	78.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
7868683	7868683	PRJNA1111146_P_NODE_206947_length_205_cov_1.230263_g205809_i0	PRJNA1111146	206947	205	1.230263	2.52203915	Gemmata massiliana	1210884	Bacteria	Bacteria	250	5.91e-62	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g205809	i0	88.78	6.77560975609756	205	21	99	2	2	205	1445676	1445879	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	1389	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
7868723	7868723	PRJNA1111146_P_NODE_215767_length_203_cov_1.506667_g214629_i0	PRJNA1111146	215767	203	1.506667	3.05853401	Lacipirellula parvula	2650471	Bacteria	Bacteria	248	2.1e-61	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g214629	i0	88.67	1	203	23	100	0	1	203	6047924	6048126	Lacipirellula parvula PX69 DNA, complete genome	blastn	203	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
7869474	7869474	PRJNA1111146_P_NODE_38707_length_307_cov_3.862205_g37570_i0	PRJNA1111146	38707	307	3.862205	11.85696935	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	455	1.87e-123	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g37570	i0	93.248	168.530944625407	311	17	100	3	1	307	2004083	2004393	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	51739	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7869914	7869914	PRJNA1111146_P_NODE_74947_length_261_cov_0.899038_g73809_i0	PRJNA1111146	74947	261	0.899038	2.34648918	Humisphaera borealis	2807512	Bacteria	Bacteria	375	1.2399999999999995e-99	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g73809	i0	92.748	128.865900383142	262	15	100	4	1	261	5064477	5064219	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	33634	375	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
10419374	10419374	PRJNA1111146_P_NODE_205469_length_205_cov_1.486842_g204331_i0	PRJNA1111146	205469	205	1.486842	3.0480261	Urbifossiella limnaea	2528023	Bacteria	Bacteria	95.3	2.93e-15	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g204331	i0	93.651	14.209756097561	63	4	31	0	1	63	796229	796167	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	2913	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
10419673	10419673	PRJNA1111146_P_NODE_277369_length_191_cov_1.427536_g276231_i0	PRJNA1111146	277369	191	1.427536	2.72659376	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	104	4.47e-18	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g276231	i0	81.89	13.7486910994764	127	19	65	4	1	125	572032	572156	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	2626	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
10419869	10419869	PRJNA1111146_P_NODE_325729_length_184_cov_0.870229_g324591_i0	PRJNA1111146	325729	184	0.870229	1.60122136	Lacipirellula parvula	2650471	Bacteria	Bacteria	226	8.739999999999996e-55	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g324591	i0	89.011	0.989130434782609	182	20	99	0	3	184	6409385	6409204	Lacipirellula parvula PX69 DNA, complete genome	blastn	182	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
10420415	10420415	PRJNA1111146_P_NODE_431729_length_177_cov_0.919355_g430591_i0	PRJNA1111146	431729	177	0.919355	1.62725835	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	148	1.85e-31	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g430591	i0	82.659	10.9491525423729	173	24	96	4	8	177	458896	458727	Luteolibacter sp. LG18 DNA, complete genome	blastn	1938	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
12500726	12500726	PRJNA1111146_P_NODE_303890_length_186_cov_1.684211_g302752_i0	PRJNA1111146	303890	186	1.684211	3.13263246	Akkermansia	239934	Bacteria	Bacteria	193	8.98e-45	NTclustered	gi\|2051350654\|gb\|CP072036.1\|	2927224	g302752	i0	86.034	47.2795698924731	179	25	96	0	1	179	1092879	1093057	Akkermansia massiliensis strain Akk1573 chromosome, complete genome	blastn	8794	193	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia massiliensis
14245629	14245629	PRJNA1111146_P_NODE_393172_length_179_cov_1.809524_g392034_i0	PRJNA1111146	393172	179	1.809524	3.23904796	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	254	3.87e-63	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g392034	i0	93.103	15.1005586592179	174	10	96	2	7	178	8814747	8814920	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2703	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16793738	16793738	PRJNA1111146_P_NODE_369994_length_181_cov_0.882812_g368856_i0	PRJNA1111146	369994	181	0.882812	1.59788972	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	263	6.519999999999999e-66	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g368856	i0	92.818	1	181	13	100	0	1	181	5874654	5874834	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	181	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
16794073	16794073	PRJNA1111146_P_NODE_4414_length_822_cov_3.107932_g2101_i2	PRJNA1111146	4414	822	3.107932	25.54720104	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	990	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2101	i2	88.686	182.077858880779	822	80	99	12	2	816	2001638	2002453	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	149668	990	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19342140	19342140	PRJNA1111146_P_NODE_291716_length_188_cov_1.688889_g290578_i0	PRJNA1111146	291716	188	1.688889	3.17511132	Gemmataceae bacterium	2052164	Bacteria	Bacteria	309	8.66e-80	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g290578	i0	96.277	4.03191489361702	188	7	100	0	1	188	5598788	5598975	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	758	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
19342377	19342377	PRJNA1111146_P_NODE_345496_length_182_cov_1.767442_g344358_i0	PRJNA1111146	345496	182	1.767442	3.21674444	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	222	1.11e-53	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g344358	i0	89.773	4.46703296703297	176	14	96	4	1	174	5869709	5869536	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	813	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20617151	20617151	PRJNA1111146_P_NODE_234717_length_199_cov_1.561644_g233579_i0	PRJNA1111146	234717	199	1.561644	3.10767156	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	246	7.379999999999999e-61	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g233579	i0	89.055	1.01005025125628	201	19	99	1	1	198	3952344	3952144	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	201	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
20618183	20618183	PRJNA1111146_P_NODE_56757_length_279_cov_1.508850_g55620_i0	PRJNA1111146	56757	279	1.50885	4.2096915	Urbifossiella limnaea	2528023	Bacteria	Bacteria	353	6.289999999999999e-93	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g55620	i0	90.253	71.2401433691756	277	18	100	7	1	270	2020027	2020301	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	19876	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
21892917	21892917	PRJNA1111146_P_NODE_264098_length_193_cov_2.428571_g262960_i0	PRJNA1111146	264098	193	2.428571	4.68714203	Botrimarina mediterranea	2528022	Bacteria	Bacteria	252	1.53e-62	NTclustered	gi\|1712762859\|gb\|CP036349.1\|	2528022	g262960	i0	90.155	84.5854922279793	193	19	100	0	1	193	4084532	4084340	Botrimarina mediterranea strain Spa11 chromosome	blastn	16325	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Botrimarina	Botrimarina mediterranea
21893132	21893132	PRJNA1111146_P_NODE_314478_length_185_cov_0.863636_g313340_i0	PRJNA1111146	314478	185	0.863636	1.5977266	Gemmataceae bacterium	2052164	Bacteria	Bacteria	291	3.07e-74	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g313340	i0	95.604	0.983783783783784	182	7	98	1	1	182	6311995	6311815	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	182	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23169104	23169104	PRJNA1111146_P_NODE_401539_length_179_cov_0.904762_g400401_i0	PRJNA1111146	401539	179	0.904762	1.61952398	Urbifossiella limnaea	2528023	Bacteria	Bacteria	207	3.06e-49	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g400401	i0	87.709	1	179	20	99	2	1	178	5920653	5920476	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	179	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea

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