metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA812715" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA812715" 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
811871	811871	PRJNA812715_P_NODE_107421_length_248_cov_0.880000_g105620_i0	PRJNA812715	107421	248	0.88	2.1824	Fontisphaera persica	2974023	Bacteria	Bacteria	115	2.82e-21	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g105620	i0	98.462	23.7258064516129	65	1	26	0	184	248	1847312	1847376	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	5884	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
2088174	2088174	PRJNA812715_P_NODE_17642_length_840_cov_4.661017_g16105_i0	PRJNA812715	17642	840	4.661017	39.1525428	Fimbriiglobus ruber	1908690	Bacteria	Bacteria	1197	0	NTclustered	gi\|1227086021\|ref\|NR_148575.1\|	1908690	g16105	i0	92.738	98.7916666666667	840	39	99	12	4	840	3	823	Fimbriiglobus ruber strain SP5 16S ribosomal RNA, partial sequence	blastn	82985	1197	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus ruber
2090593	2090593	PRJNA812715_P_NODE_95882_length_259_cov_2.048387_g94081_i0	PRJNA812715	95882	259	2.048387	5.30532233	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	307	4.5600000000000005e-79	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g94081	i0	88.031	17.1698841698842	259	31	100	0	1	259	2869578	2869320	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	4447	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3364376	3364376	PRJNA812715_P_NODE_47623_length_395_cov_2.465839_g45826_i0	PRJNA812715	47623	395	2.465839	9.74006405	Urbifossiella limnaea	2528023	Bacteria	Bacteria	220	9.79e-53	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g45826	i0	87.179	64.8329113924051	195	23	49	2	200	393	2018929	2018736	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	25609	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
4642448	4642448	PRJNA812715_P_NODE_62484_length_330_cov_0.898833_g60685_i0	PRJNA812715	62484	330	0.898833	2.9661489	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	418	2.66e-112	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g60685	i0	89.634	82.0666666666667	328	34	99	0	2	329	3573445	3573118	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	27082	418	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
7190832	7190832	PRJNA812715_P_NODE_22186_length_702_cov_1.944356_g20516_i0	PRJNA812715	22186	702	1.944356	13.64937912	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	545	2.64e-150	NTclustered	gi\|1966850802\|gb\|CP068472.1\|	1903058	g20516	i0	93.048	0.871794871794872	374	24	53	2	271	643	244070	244442	MAG: Candidatus Xiphinematobacter sp. isolate P3-11 chromosome, complete genome	blastn	612	545	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
8465312	8465312	PRJNA812715_P_NODE_125267_length_201_cov_4.359375_g123466_i0	PRJNA812715	125267	201	4.359375	8.76234375	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	206	1.27e-48	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g123466	i0	85.714	488.393034825871	196	26	97	2	7	201	2001910	2001716	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	98167	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8467195	8467195	PRJNA812715_P_NODE_71247_length_303_cov_1.339130_g69447_i0	PRJNA812715	71247	303	1.33913	4.0575639	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	431	3.099999999999999e-116	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g69447	i0	92.208	57.026402640264	308	18	100	5	1	303	1156353	1156659	Planctomyces sp. SH-PL62, complete genome	blastn	17279	431	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
9742294	9742294	PRJNA812715_P_NODE_72008_length_301_cov_1.013158_g70208_i0	PRJNA812715	72008	301	1.013158	3.04960558	Urbifossiella limnaea	2528023	Bacteria	Bacteria	309	1.5100000000000002e-79	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g70208	i0	85.294	159.744186046512	306	37	100	6	1	301	2017966	2018268	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	48083	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9742668	9742668	PRJNA812715_P_NODE_84408_length_277_cov_1.995098_g82608_i0	PRJNA812715	84408	277	1.995098	5.52642146	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	486	5.9e-133	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g82608	i0	98.545	143.942238267148	275	4	99	0	3	277	737014	737288	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	39872	486	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12293734	12293734	PRJNA812715_P_NODE_80190_length_284_cov_1.459716_g78390_i0	PRJNA812715	80190	284	1.459716	4.14559344	Paludisphaera borealis	1387353	Bacteria	Bacteria	466	7.899999999999999e-127	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g78390	i0	96.479	257.785211267606	284	7	99	3	2	284	122615	122334	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	73211	466	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
16527523	16527523	PRJNA812715_P_NODE_120133_length_241_cov_2.470238_g118332_i0	PRJNA812715	120133	241	2.470238	5.95327358	Gimesia	1649453	Bacteria	Bacteria	261	3.31e-65	NTclustered	gi\|1712496122\|gb\|CP036269.1\|	2527973	g118332	i0	87.124	132.551867219917	233	27	96	3	10	241	2395485	2395715	Gimesia alba strain Pan241w chromosome	blastn	31945	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia alba
17391651	17391651	PRJNA812715_P_NODE_41214_length_437_cov_2.700549_g39419_i0	PRJNA812715	41214	437	2.700549	11.80139913	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	466	1.27e-126	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g39419	i0	87.407	4.92677345537757	405	51	93	0	21	425	698721	699125	Planctomyces sp. SH-PL62, complete genome	blastn	2153	466	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19938591	19938591	PRJNA812715_P_NODE_111256_length_246_cov_0.890173_g109455_i0	PRJNA812715	111256	246	0.890173	2.18982558	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	200	7.5e-47	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g109455	i0	85.128	3.8130081300813	195	29	79	0	52	246	532754	532560	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	938	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
21214122	21214122	PRJNA812715_P_NODE_112377_length_246_cov_0.878613_g110576_i0	PRJNA812715	112377	246	0.878613	2.16138798	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	344	3.27e-90	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g110576	i0	91.903	145.117886178862	247	18	100	2	1	246	2002640	2002395	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	35699	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21214290	21214290	PRJNA812715_P_NODE_118557_length_242_cov_1.491124_g116756_i0	PRJNA812715	118557	242	1.491124	3.60852008	Aquisphaera giovannonii	406548	Bacteria	Bacteria	435	1.85e-117	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g116756	i0	99.58	101.595041322314	238	1	98	0	1	238	5176340	5176577	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	24586	435	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
22489064	22489064	PRJNA812715_P_NODE_122958_length_235_cov_2.549383_g121157_i0	PRJNA812715	122958	235	2.549383	5.99105005	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	243	1.16e-59	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g121157	i0	85.654	34.1702127659574	237	27	99	7	3	235	1830793	1830560	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	8030	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
25038683	25038683	PRJNA812715_P_NODE_124800_length_219_cov_4.691781_g122999_i0	PRJNA812715	124800	219	4.691781	10.27500039	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	342	1.03e-89	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g122999	i0	94.977	169.200913242009	219	10	99	1	2	219	7051130	7050912	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	37055	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;