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

32 rows where bioproject = "PRJNA556992", 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
529938	529938	PRJNA556992_P_NODE_53861_length_498_cov_10.720000_g51698_i0	PRJNA556992	53861	498	10.72	53.3856	uncultured delta proteobacterium	34034	Bacteria	Bacteria	749	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g51698	i0	93.8	172.654618473896	500	27	100	4	1	498	14177	14674	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	85982	749	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
3085769	3085769	PRJNA556992_P_NODE_927083_length_238_cov_2.696970_g924893_i0	PRJNA556992	927083	238	2.69697	6.4187886	uncultured delta proteobacterium	34034	Bacteria	Bacteria	346	8.76e-91	NTclustered	gi\|451917299\|gb\|KC451163.1\|	34034	g924893	i0	93.22	78.1050420168067	236	15	99	1	1	236	294	60	Uncultured delta proteobacterium clone RLBp1714 16S ribosomal RNA gene, partial sequence	blastn	18589	346	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
3678117	3678117	PRJNA556992_P_NODE_60223_length_478_cov_4.822222_g58055_i0	PRJNA556992	60223	478	4.822222	23.05022116	Bacteria	2	Bacteria	Bacteria	701	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g58055	i0	93.096	144.962343096234	478	33	100	0	1	478	14674	14197	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	69292	701	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
4359531	4359531	PRJNA556992_P_NODE_724904_length_250_cov_0.870056_g722715_i0	PRJNA556992	724904	250	0.870056	2.17514	Deltaproteobacteria bacterium Smac51	2946587	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2242725236\|gb\|CP026657.1\|	2946587	g722715	i0	92.308	0.156	39	2	15	1	118	155	2579772	2579810	Deltaproteobacteria bacterium Smac51 chromosome, complete genome	blastn	39	54.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium Smac51
5634666	5634666	PRJNA556992_P_NODE_60265_length_478_cov_3.488889_g58097_i0	PRJNA556992	60265	478	3.488889	16.67688942	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	507	8.26e-139	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g58097	i0	86.042	157.617154811715	480	58	99	7	2	478	14395	14868	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	75341	507	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
5637360	5637360	PRJNA556992_P_NODE_823145_length_245_cov_0.895349_g820955_i0	PRJNA556992	823145	245	0.895349	2.19360505	uncultured delta proteobacterium	34034	Bacteria	Bacteria	296	9.249999999999999e-76	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g820955	i0	88.618	171.044897959184	246	25	100	3	1	245	82318	82561	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	41906	296	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
6902235	6902235	PRJNA556992_P_NODE_133726_length_371_cov_1.718121_g131539_i0	PRJNA556992	133726	371	1.718121	6.37422891	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	459	1.7799999999999998e-124	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g131539	i0	88.947	210.948787061995	380	30	99	5	1	369	4446	4068	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	78262	459	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
6905289	6905289	PRJNA556992_P_NODE_3326_length_1700_cov_4.314690_g2691_i0	PRJNA556992	3326	1700	4.31469	73.34973	uncultured delta proteobacterium	34034	Bacteria	Bacteria	1897	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g2691	i0	86.934	135.452941176471	1722	185	100	35	1	1700	13852	12149	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	230270	1897	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
6905647	6905647	PRJNA556992_P_NODE_358126_length_281_cov_1.908654_g355937_i0	PRJNA556992	358126	281	1.908654	5.36331774	uncultured delta proteobacterium	34034	Bacteria	Bacteria	351	2.28e-92	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g355937	i0	89.855	145.562277580071	276	24	97	3	1	273	13351	13625	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	40903	351	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
9463844	9463844	PRJNA556992_P_NODE_966288_length_234_cov_2.602484_g964098_i0	PRJNA556992	966288	234	2.602484	6.08981256	uncultured delta proteobacterium	34034	Bacteria	Bacteria	129	3.83e-34	NR	BAL56290.1	34034	g964098	i0	82.1	1	78	14	100	0	234	1	19	96	BAL56290.1 glycosyl transferase family protein [uncultured delta proteobacterium]	diamond	234	129	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
10738950	10738950	PRJNA556992_P_NODE_927529_length_238_cov_2.581818_g925339_i0	PRJNA556992	927529	238	2.581818	6.14472684	Bradymonas sediminis	1548548	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g925339	i0	100	0.117647058823529	28	0	12	0	3	30	3927131	3927104	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	28	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
12006539	12006539	PRJNA556992_P_NODE_354950_length_281_cov_3.812500_g352761_i0	PRJNA556992	354950	281	3.8125	10.713125	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	326	1.38e-84	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g352761	i0	87.544	218.056939501779	281	35	100	0	1	281	12617	12897	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	61274	326	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
12007717	12007717	PRJNA556992_P_NODE_44570_length_536_cov_1.948164_g42415_i0	PRJNA556992	44570	536	1.948164	10.44215904	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	686	0	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g42415	i0	89.944	166.011194029851	537	47	99	6	2	536	13854	14385	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	88982	686	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
15830956	15830956	PRJNA556992_P_NODE_391653_length_277_cov_2.995098_g389464_i0	PRJNA556992	391653	277	2.995098	8.29642146	uncultured delta proteobacterium	34034	Bacteria	Bacteria	60.2	1.52e-4	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g389464	i0	97.143	7.09025270758123	35	1	13	0	85	119	1519823	1519857	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	1964	60.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
15833362	15833362	PRJNA556992_P_NODE_58873_length_482_cov_3.841076_g56705_i0	PRJNA556992	58873	482	3.841076	18.51398632	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	654	0	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g56705	i0	91.268	216.348547717842	481	41	99	1	3	482	13774	14254	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	104280	654	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
15836468	15836468	PRJNA556992_P_NODE_837853_length_244_cov_0.900585_g835663_i0	PRJNA556992	837853	244	0.900585	2.1974274	uncultured delta proteobacterium	34034	Bacteria	Bacteria	309	1.1800000000000002e-79	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g835663	i0	89.474	147.745901639344	247	22	100	3	1	244	83034	83279	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	36050	309	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
18381985	18381985	PRJNA556992_P_NODE_5535_length_1375_cov_4.344854_g2691_i1	PRJNA556992	5535	1375	4.344854	59.7417425	uncultured delta proteobacterium	34034	Bacteria	Bacteria	1642	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g2691	i1	88.295	139.901090909091	1384	144	100	15	1	1375	12149	13523	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	192364	1642	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26793853	26793853	PRJNA556992_P_NODE_603121_length_258_cov_4.756757_g600932_i0	PRJNA556992	603121	258	4.756757	12.27243306	Persicimonas sp.	2766932	Bacteria	Bacteria	89.4	1.66e-18	NR	MFP4597940.1	2766932	g600932	i0	67.5	0.965116279069767	83	27	96.5	0	6	254	199	281	MFP4597940.1 putative metal-binding motif-containing protein [Persicimonas sp.]	diamond	249	89.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas sp.
27552160	27552160	PRJNA556992_P_NODE_298684_length_289_cov_1.425926_g296495_i0	PRJNA556992	298684	289	1.425926	4.12092614	Deltaproteobacteria bacterium SG8_13	1703398	Bacteria	Bacteria	97.1	5.72e-21	NR	KPJ75957.1	1703398	g296495	i0	51	2.96885813148789	96	47	99.7	0	2	289	532	627	KPJ75957.1 MAG: hypothetical protein AMJ54_13385, partial [Deltaproteobacteria bacterium SG8_13]	diamond	858	97.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium SG8_13
27630118	27630118	PRJNA556992_P_NODE_384884_length_278_cov_1.975610_g382695_i0	PRJNA556992	384884	278	1.97561	5.4921958	Myxococcota	2818505	Bacteria	Bacteria	81.6	1.18e-15	NR	OGQ17351.1	1797848	g382695	i0	46.7	6.99280575539568	92	45	99.3	3	1	276	592	679	OGQ17351.1 MAG: hypothetical protein A2138_25550 [Deltaproteobacteria bacterium RBG_16_71_12]	diamond	1944	82.4	0.990291262135922	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RBG_16_71_12
27882558	27882558	PRJNA556992_P_NODE_880045_length_242_cov_0.911243_g877855_i0	PRJNA556992	880045	242	0.911243	2.20520806	Lujinxingia	2653226	Bacteria	Bacteria	54.3	2.96e-6	NR	WP_111727865.1	2211119	g877855	i0	61.5	1.42561983471074	39	15	48.3	0	111	227	1	39	WP_111727865.1 bifunctional diaminohydroxyphosphoribosylaminopyrimidine deaminase/5-amino-6-(5-phosphoribosylamino)uracil reductase RibD [Lujinxingia litoralis]	diamond	345	54.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae	Lujinxingia	Lujinxingia litoralis
28215186	28215186	PRJNA556992_P_NODE_328486_length_285_cov_1.259434_g326297_i0	PRJNA556992	328486	285	1.259434	3.5893869	Deltaproteobacteria bacterium RIFCSPHIGHO2_	2026735	Bacteria	Bacteria	51.6	4.86e-5	NR	OGQ14870.1	1797858	g326297	i0	37.8	0.778947368421053	74	46	77.9	0	279	58	694	767	OGQ14870.1 MAG: hypothetical protein A3B70_08410 [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_11]	diamond	222	51.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_11
28577154	28577154	PRJNA556992_P_NODE_423547_length_274_cov_2.194030_g421358_i0	PRJNA556992	423547	274	2.19403	6.0116422	Bacteria	2	Bacteria	Bacteria	122	4.639999999999999e-32	NR	OGQ80199.1	1797895	g421358	i0	61.1	14.6277372262774	90	35	98.5	0	4	273	115	204	OGQ80199.1 MAG: mechanosensitive ion channel protein [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	4008	123	0.991869918699187	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
28721051	28721051	PRJNA556992_P_NODE_937987_length_237_cov_2.426829_g935797_i0	PRJNA556992	937987	237	2.426829	5.75158473	Persicimonas caeni	2292766	Bacteria	Bacteria	84.7	5.64e-17	NR	WP_141197512.1	2292766	g935797	i0	54.5	0.974683544303797	77	35	97.5	0	236	6	109	185	WP_141197512.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Persicimonas caeni]	diamond	231	84.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
29099411	29099411	PRJNA556992_P_NODE_1007188_length_229_cov_16.461538_g1004998_i0	PRJNA556992	1007188	229	16.461538	37.69692202	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	79	8.92e-16	NR	MCH2286936.1	2024889	g1004998	i0	56.1	4.31004366812227	66	29	86.5	0	1	198	155	220	MCH2286936.1 leucyl/phenylalanyl-tRNA--protein transferase [SAR324 cluster bacterium]	diamond	987	79	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
30300119	30300119	PRJNA556992_P_NODE_404352_length_276_cov_1.926108_g402163_i0	PRJNA556992	404352	276	1.926108	5.31605808	Persicimonas caeni	2292766	Bacteria	Bacteria	55.1	1.83e-6	NR	WP_141199512.1	2292766	g402163	i0	59	0.423913043478261	39	16	42.4	0	2	118	222	260	WP_141199512.1 carbonic anhydrase family protein [Persicimonas caeni]	diamond	117	55.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
30346158	30346158	PRJNA556992_P_NODE_419092_length_274_cov_8.935323_g416903_i0	PRJNA556992	419092	274	8.935323	24.48278502	root	1	Root_unresolved	Root_unresolved	96.7	1.94e-22	NR	PCI29252.1	2024889	g416903	i0	54	6.72262773722628	87	31	95.3	1	266	6	77	154	PCI29252.1 MAG: 7-cyano-7-deazaguanine synthase QueC [SAR324 cluster bacterium]	diamond	1842	96.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
30615378	30615378	PRJNA556992_P_NODE_140513_length_365_cov_3.219178_g138325_i0	PRJNA556992	140513	365	3.219178	11.7499997	Deltaproteobacteria bacterium RIFOXYA12_FULL_61_11	1797896	Bacteria	Bacteria	138	3.76e-35	NR	OGR01519.1	1797896	g138325	i0	55.4	0.994520547945206	121	53	99.5	1	365	3	351	470	OGR01519.1 MAG: hypothetical protein A2284_05785 [Deltaproteobacteria bacterium RIFOXYA12_FULL_61_11]	diamond	363	138	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_61_11
31215446	31215446	PRJNA556992_P_NODE_24675_length_687_cov_2.959283_g22655_i0	PRJNA556992	24675	687	2.959283	20.33027421	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	112	1.6e-26	NR	PCI29252.1	2024889	g22655	i0	72.7	0.2882096069869	66	18	28.8	0	4	201	154	219	PCI29252.1 MAG: 7-cyano-7-deazaguanine synthase QueC [SAR324 cluster bacterium]	diamond	198	112	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
31451922	31451922	PRJNA556992_P_NODE_782276_length_247_cov_0.885057_g780086_i0	PRJNA556992	782276	247	0.885057	2.18609079	Myxococcota	2818505	Bacteria	Bacteria	42.7	0.0379	NR	NMC63309.1	2024889	g780086	i0	38.5	1.1417004048583	65	39	77.7	1	245	54	470	534	NMC63309.1 glycosyltransferase [SAR324 cluster bacterium]	diamond	282	42.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
32355272	32355272	PRJNA556992_P_NODE_86539_length_424_cov_1.128205_g84358_i0	PRJNA556992	86539	424	1.128205	4.7835892	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	71.6	2.12e-11	NR	MDP7139559.1	2024889	g84358	i0	36.8	2.65330188679245	144	67	96.9	6	421	11	433	559	MDP7139559.1 SBBP repeat-containing protein [SAR324 cluster bacterium]	diamond	1125	71.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
32432608	32432608	PRJNA556992_P_NODE_432499_length_273_cov_2.710000_g430310_i0	PRJNA556992	432499	273	2.71	7.3983	Thermodesulfobacteriota	200940	Bacteria	Bacteria	50.8	5.37e-5	NR	OPZ54396.1	1852871	g430310	i0	35	1.75824175824176	80	51	87.9	1	273	34	149	227	OPZ54396.1 MAG: hypothetical protein BWY90_00088 [Deltaproteobacteria bacterium ADurb.BinA014]	diamond	480	50.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.BinA014

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