metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
1013200	1013200	PRJNA1067370_P_NODE_114881_length_241_cov_0.916667_g114332_i0	PRJNA1067370	114881	241	0.916667	2.20916747	Gemmata	113	Bacteria	Bacteria	316	6.97e-82	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g114332	i0	90.417	10.1120331950207	240	23	99	0	1	240	7659293	7659054	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	2437	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
1013258	1013258	PRJNA1067370_P_NODE_3741_length_897_cov_2.245146_g3298_i0	PRJNA1067370	3741	897	2.245146	20.13895962	Opitutaceae	134623	Bacteria	Bacteria	1127	0	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g3298	i0	89.369	133.289855072464	903	87	100	8	1	897	2833490	2834389	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	119561	1127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
1013384	1013384	PRJNA1067370_P_NODE_99321_length_245_cov_1.343023_g98772_i0	PRJNA1067370	99321	245	1.343023	3.29040635	root	1	Root_unresolved	Root_unresolved	344	3.26e-90	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g98772	i0	91.935	68.2897959183673	248	16	100	4	1	245	7051196	7050950	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	16731	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1455231	1455231	PRJNA1067370_P_NODE_106862_length_243_cov_0.905882_g106313_i0	PRJNA1067370	106862	243	0.905882	2.20129326	Gemmataceae bacterium	2052164	Bacteria	Bacteria	307	4.23e-79	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g106313	i0	89.516	2.4320987654321	248	18	100	6	1	243	1991410	1991654	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	591	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
1455489	1455489	PRJNA1067370_P_NODE_3162_length_964_cov_2.450056_g2744_i0	PRJNA1067370	3162	964	2.450056	23.61853984	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	987	0	NTclustered	gi\|1966854496\|gb\|CP068475.1\|	1903058	g2744	i0	87.035	140.215767634855	887	99	91	14	86	958	915855	914971	MAG: Candidatus Xiphinematobacter sp. isolate P21 chromosome, complete genome	blastn	135168	987	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
1455732	1455732	PRJNA1067370_P_NODE_71502_length_262_cov_1.629630_g70953_i0	PRJNA1067370	71502	262	1.62963	4.2696306	uncultured Planctomyces sp.	179110	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|459463901\|gb\|KC502949.1\|	179110	g70953	i0	99.618	99.7137404580153	262	1	100	0	1	262	1367	1106	Uncultured Planctomyces sp. clone AHy34 16S ribosomal RNA gene, partial sequence	blastn	26125	479	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	uncultured Planctomyces sp.
1455742	1455742	PRJNA1067370_P_NODE_72682_length_260_cov_3.203209_g72133_i0	PRJNA1067370	72682	260	3.203209	8.3283434	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2107742610\|gb\|CP070837.1\|	2035772	g72133	i0	100	0.115384615384615	30	0	12	0	159	188	548348	548319	MAG: Candidatus Omnitrophota bacterium isolate bin103 chromosome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
1455885	1455885	PRJNA1067370_P_NODE_92702_length_247_cov_1.149425_g92153_i0	PRJNA1067370	92702	247	1.149425	2.83907975	Pedosphaera parvula	1032527	Bacteria	Bacteria	167	7.64e-37	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g92153	i0	88.489	103.068825910931	139	14	55	2	111	247	305	167	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	25458	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
2731222	2731222	PRJNA1067370_P_NODE_20543_length_415_cov_1.216374_g19995_i0	PRJNA1067370	20543	415	1.216374	5.0479521	Pedosphaera parvula	1032527	Bacteria	Bacteria	348	4.54e-91	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g19995	i0	84.115	133.698795180723	384	36	92	14	35	415	1491	1852	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	55485	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
2731445	2731445	PRJNA1067370_P_NODE_51603_length_293_cov_1.218182_g51054_i0	PRJNA1067370	51603	293	1.218182	3.56927326	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	405	1.81e-108	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g51054	i0	91.554	126.211604095563	296	22	100	3	1	293	5085903	5086198	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	36980	405	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
4007474	4007474	PRJNA1067370_P_NODE_64464_length_273_cov_1.295000_g63915_i0	PRJNA1067370	64464	273	1.295	3.53535	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	191	5.09e-44	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g63915	i0	85.106	2.73260073260073	188	27	68	1	1	187	1742117	1742304	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	746	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10383819	10383819	PRJNA1067370_P_NODE_107609_length_243_cov_0.905882_g107060_i0	PRJNA1067370	107609	243	0.905882	2.20129326	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	202	2.0599999999999995e-47	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g107060	i0	82.008	20.4855967078189	239	41	98	2	1	238	3599604	3599367	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	4978	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
11659218	11659218	PRJNA1067370_P_NODE_115490_length_241_cov_0.875000_g114941_i0	PRJNA1067370	115490	241	0.875	2.10875	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	388	1.46e-103	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g114941	i0	96.203	246.551867219917	237	9	98	0	2	238	3992084	3991848	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	59419	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
11659539	11659539	PRJNA1067370_P_NODE_51010_length_294_cov_1.687783_g50461_i0	PRJNA1067370	51010	294	1.687783	4.96208202	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	298	3.17e-76	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g50461	i0	85.567	127.741496598639	291	34	98	8	8	294	5085933	5085647	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	37556	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
11659730	11659730	PRJNA1067370_P_NODE_80990_length_251_cov_0.865169_g80441_i0	PRJNA1067370	80990	251	0.865169	2.17157419	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	398	2.5399999999999994e-106	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g80441	i0	95.238	125.693227091633	252	11	100	1	1	251	1632	1381	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	31549	398	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
15483992	15483992	PRJNA1067370_P_NODE_97693_length_246_cov_0.890173_g97144_i0	PRJNA1067370	97693	246	0.890173	2.18982558	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	316	7.14e-82	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g97144	i0	89.837	4.16666666666667	246	25	100	0	1	246	6734174	6733929	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1025	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16757526	16757526	PRJNA1067370_P_NODE_115274_length_241_cov_0.916667_g114725_i0	PRJNA1067370	115274	241	0.916667	2.20916747	Luteolibacter sp.	1962973	Bacteria	Bacteria	147	9.67e-31	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g114725	i0	79.621	9.10373443983402	211	38	86	5	31	238	2693584	2693376	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	2194	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
18032498	18032498	PRJNA1067370_P_NODE_30475_length_353_cov_1.653571_g29927_i0	PRJNA1067370	30475	353	1.653571	5.83710563	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	448	3.639999999999999e-121	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g29927	i0	89.518	114.178470254958	353	37	100	0	1	353	1902348	1901996	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	40305	448	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
18032764	18032764	PRJNA1067370_P_NODE_6755_length_685_cov_2.094771_g6243_i0	PRJNA1067370	6755	685	2.094771	14.34918135	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	989	0	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g6243	i0	92.701	236.211678832117	685	50	100	0	1	685	2749133	2748449	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	161805	989	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20581644	20581644	PRJNA1067370_P_NODE_10617_length_559_cov_1.222222_g10077_i0	PRJNA1067370	10617	559	1.222222	6.83222098	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	640	9.24e-179	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g10077	i0	87.544	116.468694096601	562	59	100	10	1	559	1844905	1844352	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	65106	640	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
21857910	21857910	PRJNA1067370_P_NODE_79798_length_251_cov_0.865169_g79249_i0	PRJNA1067370	79798	251	0.865169	2.17157419	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	302	2.0500000000000002e-77	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g79249	i0	89.3	41.6653386454183	243	22	96	4	1	241	2910896	2910656	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	10458	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
23132864	23132864	PRJNA1067370_P_NODE_108079_length_243_cov_0.905882_g107530_i0	PRJNA1067370	108079	243	0.905882	2.20129326	Gemmataceae bacterium	2052164	Bacteria	Bacteria	307	4.23e-79	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g107530	i0	89.958	2.92592592592593	239	23	98	1	1	238	2296568	2296806	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	711	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23132980	23132980	PRJNA1067370_P_NODE_17199_length_449_cov_1.630319_g16651_i0	PRJNA1067370	17199	449	1.630319	7.32013231	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	220	1.1299999999999999e-52	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g16651	i0	86.207	261.552338530067	203	28	45	0	1	203	2834372	2834574	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	117437	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
23133344	23133344	PRJNA1067370_P_NODE_70339_length_264_cov_1.345550_g69790_i0	PRJNA1067370	70339	264	1.34555	3.552252	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	329	9.95e-86	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g69790	i0	89.098	159.162878787879	266	27	100	2	1	264	2002050	2002315	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	42019	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23133508	23133508	PRJNA1067370_P_NODE_93579_length_247_cov_0.885057_g93030_i0	PRJNA1067370	93579	247	0.885057	2.18609079	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	265	2.63e-66	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g93030	i0	86.29	163.522267206478	248	28	100	4	1	247	1600297	1600539	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	40390	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
24406695	24406695	PRJNA1067370_P_NODE_28120_length_364_cov_3.611684_g27572_i0	PRJNA1067370	28120	364	3.611684	13.14652976	Chthoniobacter flavus	191863	Bacteria	Bacteria	372	2.3299999999999995e-98	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g27572	i0	86.04	89.3791208791209	351	43	96	6	13	361	153	499	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	32534	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
24406835	24406835	PRJNA1067370_P_NODE_50580_length_295_cov_1.846847_g50032_i0	PRJNA1067370	50580	295	1.846847	5.44819865	Humisphaera borealis	2807512	Bacteria	Bacteria	313	1.14e-80	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g50032	i0	85.859	229.213559322034	297	39	100	3	1	295	5062933	5063228	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	67618	313	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);;