metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA356682" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA356682" and tax_phylum = "Verrucomicrobiota"

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
1671967	1671967	PRJNA356682_P_NODE_15422_length_361_cov_1.708333_g14732_i0	PRJNA356682	15422	361	1.708333	6.16708213	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	464	3.71e-126	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g14732	i0	89.972	110.850415512465	359	36	99	0	3	361	5153984	5153626	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	40017	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2948286	2948286	PRJNA356682_P_NODE_3343_length_792_cov_3.051460_g2716_i0	PRJNA356682	3343	792	3.05146	24.1675632	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	822	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g2716	i0	85.75	119.380050505051	793	96	99	14	6	792	1728442	1729223	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	94549	822	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2948402	2948402	PRJNA356682_P_NODE_3843_length_729_cov_3.684451_g3196_i0	PRJNA356682	3843	729	3.684451	26.85964779	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1086	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3196	i0	93.553	96.3799725651577	729	47	100	0	1	729	5152309	5153037	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	70261	1086	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6775002	6775002	PRJNA356682_P_NODE_2186_length_1025_cov_4.386555_g1639_i0	PRJNA356682	2186	1025	4.386555	44.96218875	Pedosphaera parvula	1032527	Bacteria	Bacteria	998	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g1639	i0	84.378	88.9707317073171	1037	141	100	21	1	1025	1744	717	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	91195	998	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
8050643	8050643	PRJNA356682_P_NODE_20667_length_318_cov_1.755102_g19976_i0	PRJNA356682	20667	318	1.755102	5.58122436	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	399	9.239999999999998e-107	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g19976	i0	92.226	81.0534591194968	283	20	89	2	1	282	1315854	1316135	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	25775	399	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10000357	10000357	PRJNA356682_P_NODE_20588_length_318_cov_5.714286_g19897_i0	PRJNA356682	20588	318	5.714286	18.17142948	Opitutaceae	134623	Bacteria	Bacteria	501	2.46e-137	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g19897	i0	95	91.3962264150943	320	14	100	2	1	318	1005	1324	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	29064	501	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
10000446	10000446	PRJNA356682_P_NODE_25988_length_288_cov_2.441860_g25297_i0	PRJNA356682	25988	288	2.44186	7.0325568	Prosthecobacter	48463	Bacteria	Bacteria	420	6.34e-113	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g25297	i0	93.031	17.8854166666667	287	20	99	0	2	288	189	475	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	5151	420	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
11275772	11275772	PRJNA356682_P_NODE_47169_length_216_cov_4.111888_g46478_i0	PRJNA356682	47169	216	4.111888	8.88167808	Methylacidiphilum (ex Ratnadevi et al. 2023)	511745	Bacteria	Bacteria	207	3.84e-49	NTclustered	gi\|189184875\|gb\|CP000975.1\|	481448	g46478	i0	87.432	167.49537037037	183	20	84	3	2	182	895211	895392	Methylacidiphilum infernorum V4, complete genome	blastn	36179	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Candidatus Methylacidiphilum infernorum
13151638	13151638	PRJNA356682_P_NODE_44611_length_241_cov_0.916667_g43920_i0	PRJNA356682	44611	241	0.916667	2.20916747	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	122	1.6299999999999994e-23	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g43920	i0	78.537	0.850622406639004	205	31	82	11	1	197	2495404	2495205	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	205	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
14426088	14426088	PRJNA356682_P_NODE_16532_length_351_cov_1.571942_g15841_i0	PRJNA356682	16532	351	1.571942	5.51751642	Opitutus terrae	107709	Bacteria	Bacteria	446	1.2999999999999995e-120	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g15841	i0	89.773	6.01424501424501	352	30	100	6	1	351	4393735	4393389	Opitutus terrae PB90-1, complete genome	blastn	2111	446	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
14426225	14426225	PRJNA356682_P_NODE_23252_length_302_cov_2.227074_g22561_i0	PRJNA356682	23252	302	2.227074	6.72576348	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	536	6.369999999999999e-148	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g22561	i0	98.675	94.5728476821192	302	4	100	0	1	302	601	902	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	28561	536	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
14426293	14426293	PRJNA356682_P_NODE_26192_length_287_cov_2.514019_g25501_i0	PRJNA356682	26192	287	2.514019	7.21523453	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	324	5.09e-84	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g25501	i0	87.456	1.90940766550523	287	28	98	4	7	286	2924741	2924456	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	548	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14426440	14426440	PRJNA356682_P_NODE_32352_length_262_cov_2.158730_g31661_i0	PRJNA356682	32352	262	2.15873	5.6558726	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	418	2.0499999999999995e-112	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g31661	i0	95.42	148.400763358779	262	12	100	0	1	262	5152571	5152310	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	38881	418	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14426683	14426683	PRJNA356682_P_NODE_43612_length_242_cov_0.911243_g42921_i0	PRJNA356682	43612	242	0.911243	2.20520806	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	333	6.949999999999999e-87	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g42921	i0	91.667	92.4586776859504	240	20	99	0	3	242	1183049	1183288	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	22375	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
14426696	14426696	PRJNA356682_P_NODE_44232_length_241_cov_2.482143_g43541_i0	PRJNA356682	44232	241	2.482143	5.98196463	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	363	8.819999999999997e-96	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g43541	i0	93.776	56.7634854771784	241	15	100	0	1	241	1165	1405	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	13680	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
15700111	15700111	PRJNA356682_P_NODE_2373_length_973_cov_3.976667_g1811_i0	PRJNA356682	2373	973	3.976667	38.69296991	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	998	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g1811	i0	85.479	173.713257965057	971	125	99	16	8	973	1727312	1728271	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	169023	998	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15700640	15700640	PRJNA356682_P_NODE_47453_length_206_cov_4.616541_g46762_i0	PRJNA356682	47453	206	4.616541	9.51007446	Pedosphaera parvula	1032527	Bacteria	Bacteria	243	9.96e-60	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g46762	i0	87.923	94.1941747572816	207	23	100	2	1	206	938	1143	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	19404	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
16975279	16975279	PRJNA356682_P_NODE_42694_length_243_cov_0.905882_g42003_i0	PRJNA356682	42694	243	0.905882	2.20129326	Luteolibacter luteus	2728835	Bacteria	Bacteria	292	1.19e-74	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g42003	i0	91.163	4.09465020576132	215	19	88	0	1	215	2314108	2313894	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	995	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
19523524	19523524	PRJNA356682_P_NODE_34956_length_254_cov_1.193370_g34265_i0	PRJNA356682	34956	254	1.19337	3.0311598	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	357	4.36e-94	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g34265	i0	93.776	262.724409448819	241	9	94	4	17	254	5626529	5626766	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	66732	357	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
20799318	20799318	PRJNA356682_P_NODE_3997_length_715_cov_7.084112_g3347_i0	PRJNA356682	3997	715	7.084112	50.6514008	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	634	5.58e-177	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3347	i0	82.853	129.615384615385	729	103	99	18	1	713	1315667	1314945	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	92675	634	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20799350	20799350	PRJNA356682_P_NODE_41237_length_245_cov_0.895349_g40546_i0	PRJNA356682	41237	245	0.895349	2.19360505	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	315	2.55e-81	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g40546	i0	90.083	2.89387755102041	242	24	99	0	4	245	4388073	4388314	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	709	315	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
22073733	22073733	PRJNA356682_P_NODE_11498_length_413_cov_10.261765_g10808_i0	PRJNA356682	11498	413	10.261765	42.38108945	Pedosphaera parvula	1032527	Bacteria	Bacteria	388	2.66e-103	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g10808	i0	83.816	184.474576271186	414	61	99	6	4	413	1457	1868	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	76188	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
24624257	24624257	PRJNA356682_P_NODE_8400_length_482_cov_3.603912_g7711_i0	PRJNA356682	8400	482	3.603912	17.37085584	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	641	2.1899999999999994e-179	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g7711	i0	91.139	232.831950207469	474	41	98	1	6	479	3992089	3991617	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	112225	641	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;