metadata: contig_metadata: 20 rows where bioproject = "PRJNA951810", tax_clade = "delta/epsilon subdivisions" and tax

20 rows where bioproject = "PRJNA951810", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

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_class	tax_order	tax_family	tax_genus	tax_species
2212008	2212008	PRJNA951810_P_NODE_185022_length_226_cov_2.816993_g184677_i0	PRJNA951810	185022	226	2.816993	6.36640418	Persicimonas caeni	2292766	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g184677	i0	96.875	0.283185840707965	32	0	14	1	124	155	2713122	2713092	Persicimonas caeni strain YN101 chromosome	blastn	64	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
13690752	13690752	PRJNA951810_P_NODE_27291_length_385_cov_4.217949_g26949_i0	PRJNA951810	27291	385	4.217949	16.23910365	uncultured delta proteobacterium	34034	Bacteria	Bacteria	163	1.6299999999999998e-35	NTclustered	gi\|2874254016\|emb\|OY970341.1\|	34034	g26949	i0	77.739	0.735064935064935	283	51	71	8	8	280	3170501	3170781	MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1	blastn	283	163	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
13691343	13691343	PRJNA951810_P_NODE_59551_length_310_cov_3.637131_g59208_i0	PRJNA951810	59551	310	3.637131	11.2751061	Bradymonas sediminis	1548548	Bacteria	Bacteria	121	7.83e-23	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g59208	i0	84.553	0.525806451612903	123	18	39	1	16	137	4434837	4434959	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	163	121	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
17514174	17514174	PRJNA951810_P_NODE_145414_length_261_cov_6.765957_g145069_i0	PRJNA951810	145414	261	6.765957	17.65914777	uncultured delta proteobacterium Rifle_16ft_4_minimus_1997	1665176	Bacteria	Bacteria	154	6.34e-33	NTclustered	gi\|874574400\|gb\|KT006970.1\|	1665176	g145069	i0	81.967	3.24137931034483	183	31	70	2	59	240	53040	52859	Uncultured delta proteobacterium Rifle_16ft_4_minimus_1997 genomic sequence	blastn	846	154	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium Rifle_16ft_4_minimus_1997
18787168	18787168	PRJNA951810_P_NODE_105475_length_289_cov_8.791667_g105131_i0	PRJNA951810	105475	289	8.791667	25.40791763	Thermodesulfobacteriota	200940	Bacteria	Bacteria	73.9	4.54e-13	NR	OIN94809.1	1805124	g105131	i0	82.1	1.21453287197232	39	7	40.5	0	288	172	296	334	OIN94809.1 MAG: hypothetical protein AUJ48_04430 [Deltaproteobacteria bacterium CG1_02_45_11]	diamond	351	73.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG1_02_45_11
22612751	22612751	PRJNA951810_P_NODE_123418_length_277_cov_9.176471_g123073_i0	PRJNA951810	123418	277	9.176471	25.41882467	Persicimonas caeni	2292766	Bacteria	Bacteria	126	1.48e-24	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g123073	i0	83.582	13.7870036101083	134	22	48	0	143	276	6381799	6381666	Persicimonas caeni strain YN101 chromosome	blastn	3819	126	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
26620577	26620577	PRJNA951810_P_NODE_137241_length_267_cov_19.850515_g136896_i0	PRJNA951810	137241	267	19.850515	53.00087505	root	1	Root_unresolved	Root_unresolved	80.1	7.85e-17	NR	OGQ22850.1	1797862	g136896	i0	44.3	1.9438202247191	88	49	98.9	0	265	2	30	117	OGQ22850.1 MAG: hypothetical protein A3C46_05215 [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_44_16]	diamond	519	80.9	0.990111248454882	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_44_16
26740435	26740435	PRJNA951810_P_NODE_68001_length_309_cov_7.080508_g67657_i0	PRJNA951810	68001	309	7.080508	21.87876972	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	58.9	1.61e-7	NR	MBA2663522.1	2946527	g67657	i0	65.1	1.36893203883495	43	15	41.7	0	2	130	8	50	MBA2663522.1 serine/threonine protein kinase [Lujinxingiaceae bacterium]	diamond	423	58.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae		Lujinxingiaceae bacterium
26772554	26772554	PRJNA951810_P_NODE_69341_length_308_cov_3.459574_g68997_i0	PRJNA951810	69341	308	3.459574	10.65548792	Deltaproteobacteria bacterium GWA2_43_19	1797804	Bacteria	Bacteria	63.2	5.49e-9	NR	OGP12186.1	1797804	g68997	i0	32.6	0.925324675324675	95	58	92.5	1	23	307	813	901	OGP12186.1 MAG: hypothetical protein A2Z89_09080 [Deltaproteobacteria bacterium GWA2_43_19]	diamond	285	63.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium GWA2_43_19
27190088	27190088	PRJNA951810_P_NODE_40762_length_310_cov_12.392405_g40419_i0	PRJNA951810	40762	310	12.392405	38.4164555	Myxococcota	2818505	Bacteria	Bacteria	46.2	0.00468	NR	OLC78306.1	1805121	g40419	i0	53.8	1.16129032258065	39	18	37.7	0	306	190	351	389	OLC78306.1 MAG: hypothetical protein AUH83_02555 [Deltaproteobacteria bacterium 13_1_40CM_4_68_19]	diamond	360	46.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium 13_1_40CM_4_68_19
27443317	27443317	PRJNA951810_P_NODE_135143_length_269_cov_4.321429_g134798_i0	PRJNA951810	135143	269	4.321429	11.62464401	Bacteria	2	Bacteria	Bacteria	59.7	5.58e-8	NR	OGP12186.1	1797804	g134798	i0	37	4.49442379182156	81	51	90.3	0	24	266	189	269	OGP12186.1 MAG: hypothetical protein A2Z89_09080 [Deltaproteobacteria bacterium GWA2_43_19]	diamond	1209	59.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium GWA2_43_19
28131330	28131330	PRJNA951810_P_NODE_26285_length_392_cov_4.319749_g25943_i0	PRJNA951810	26285	392	4.319749	16.93341608	Bradymonadales bacterium	2099667	Bacteria	Bacteria	72	3.65e-13	NR	TVQ80944.1	2099667	g25943	i0	38.1	0.964285714285714	126	72	91.8	1	31	390	1	126	TVQ80944.1 MAG: hypothetical protein EA369_01235 [Bradymonadales bacterium]	diamond	378	72	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales			Bradymonadales bacterium
28888811	28888811	PRJNA951810_P_NODE_146788_length_260_cov_6.096257_g146443_i0	PRJNA951810	146788	260	6.096257	15.8502682	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2	2013747	Bacteria	Bacteria	74.7	2.48e-13	NR	PKN39734.1	2013748	g146443	i0	51.6	0.715384615384615	62	30	71.5	0	2	187	117	178	PKN39734.1 MAG: hypothetical protein CVU63_14490, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20]	diamond	186	74.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
29173335	29173335	PRJNA951810_P_NODE_78569_length_299_cov_4.765487_g78225_i0	PRJNA951810	78569	299	4.765487	14.24880613	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2	2013747	Bacteria	Bacteria	58.5	1.96e-7	NR	PKN33844.1	2013748	g78225	i0	47.5	0.612040133779264	61	21	50.2	1	209	60	23	83	PKN33844.1 MAG: hypothetical protein CVU63_18140, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20]	diamond	183	58.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
29204790	29204790	PRJNA951810_P_NODE_115529_length_283_cov_2.752381_g115185_i0	PRJNA951810	115529	283	2.752381	7.78923823	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	134	1.5e-35	NR	MDP7317134.1	2024889	g115185	i0	68.1	9.9434628975265	94	30	99.6	0	2	283	77	170	MDP7317134.1 aminotransferase [SAR324 cluster bacterium]	diamond	2814	134	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
30411661	30411661	PRJNA951810_P_NODE_161413_length_249_cov_1.375000_g161068_i0	PRJNA951810	161413	249	1.375	3.42375	Bacteria	2	Bacteria	Bacteria	67.8	4.51e-11	NR	OQB09973.1	1852869	g161068	i0	41	2	83	48	100	1	1	249	141	222	OQB09973.1 MAG: hypothetical protein BWY17_04432 [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	498	67.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin207
31005101	31005101	PRJNA951810_P_NODE_102074_length_292_cov_1.867580_g101730_i0	PRJNA951810	102074	292	1.86758	5.4533336	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2	2013747	Bacteria	Bacteria	68.9	4.05e-11	NR	PKN39734.1	2013748	g101730	i0	57.1	0.503424657534247	49	21	50.3	0	14	160	130	178	PKN39734.1 MAG: hypothetical protein CVU63_14490, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20]	diamond	147	68.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
31416099	31416099	PRJNA951810_P_NODE_166236_length_245_cov_4.104651_g165891_i0	PRJNA951810	166236	245	4.104651	10.05639495	Microvenator marinus	2600177	Bacteria	Bacteria	55.5	1.24e-6	NR	WP_146962556.1	2600177	g165891	i0	56.3	0.587755102040816	48	19	58.8	1	25	168	356	401	WP_146962556.1 hypothetical protein [Microvenator marinus]	diamond	144	55.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
31675534	31675534	PRJNA951810_P_NODE_47017_length_310_cov_6.476793_g46674_i0	PRJNA951810	47017	310	6.476793	20.0780583	Bdellovibrionota	3018035	Bacteria	Bacteria	58.5	1.85e-7	NR	OGQ93451.1	1797896	g46674	i0	56.5	1.21935483870968	46	20	44.5	0	172	309	1	46	OGQ93451.1 MAG: hypothetical protein A2284_17825 [Deltaproteobacteria bacterium RIFOXYA12_FULL_61_11]	diamond	378	58.9	0.99320882852292	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_61_11
32649264	32649264	PRJNA951810_P_NODE_53440_length_310_cov_4.742616_g53097_i0	PRJNA951810	53440	310	4.742616	14.7021096	Deltaproteobacteria bacterium CG	2026735	Bacteria	Bacteria	48.1	8.48e-4	NR	PIU53429.1	1973972	g53097	i0	34.5	0.561290322580645	58	37	56.1	1	310	137	174	230	PIU53429.1 MAG: hypothetical protein COS90_06140 [Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_60_11]	diamond	174	48.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_60_11

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