metadata: contig_metadata: 32 rows where bioproject = "PRJNA928559" and tax

32 rows where bioproject = "PRJNA928559" and tax_clade = "delta/epsilon subdivisions"

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
2177517	2177517	PRJNA928559_P_NODE_120162_length_325_cov_1.238095_g118593_i0	PRJNA928559	120162	325	1.238095	4.02380875	uncultured delta proteobacterium	34034	Bacteria	Bacteria	315	3.5299999999999993e-81	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g118593	i0	84.639	136.750769230769	319	46	98	3	9	325	82677	82360	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	44444	315	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
5081497	5081497	PRJNA928559_P_NODE_68804_length_423_cov_139764.431429_g67235_i0	PRJNA928559	68804	423	139764.431429	591203.54494467	Pseudomonadota	1224	Bacteria	Bacteria	398	4.539999999999998e-106	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g67235	i0	100	52.9929078014184	215	0	51	0	209	423	230	16	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	22416	398	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
6357276	6357276	PRJNA928559_P_NODE_94985_length_365_cov_98461.352740_g93416_i0	PRJNA928559	94985	365	98461.35274	359383.937501	Pseudomonadota	1224	Bacteria	Bacteria	399	1.07e-106	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g93416	i0	100	60.3616438356164	216	0	59	0	150	365	231	16	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	22032	399	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
7281059	7281059	PRJNA928559_P_NODE_178666_length_260_cov_1.860963_g177097_i0	PRJNA928559	178666	260	1.860963	4.8385038	uncultured delta proteobacterium	34034	Bacteria	Bacteria	307	4.58e-79	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g177097	i0	88.327	249.25	257	29	98	1	2	257	1544115	1543859	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	64805	307	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
7631285	7631285	PRJNA928559_P_NODE_68806_length_423_cov_75028.211429_g67237_i0	PRJNA928559	68806	423	75028.211429	317369.33434467	Pseudomonadota	1224	Bacteria	Bacteria	385	3.54e-102	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g67237	i0	100	50.6808510638298	208	0	49	0	1	208	16	223	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	21438	385	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
8905802	8905802	PRJNA928559_P_NODE_218447_length_236_cov_234.981595_g216878_i0	PRJNA928559	218447	236	234.981595	554.5565642	Bacteria	2	Bacteria	Bacteria	69.4	2.1e-7	NTclustered	gi\|407911330\|gb\|JQ772010.1\|	34034	g216878	i0	100	14.6228813559322	37	0	16	0	2	38	663	627	Uncultured delta proteobacterium clone CS54 16S ribosomal RNA gene, partial sequence	blastn	3451	69.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
10181823	10181823	PRJNA928559_P_NODE_75148_length_407_cov_108226.101796_g73579_i0	PRJNA928559	75148	407	108226.101796	440480.23430972	Pseudomonadota	1224	Bacteria	Bacteria	335	3.459999999999999e-87	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g73579	i0	100	50.2506142506142	181	0	44	0	227	407	7	187	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	20452	335	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
11456470	11456470	PRJNA928559_P_NODE_137829_length_301_cov_46.885965_g136260_i0	PRJNA928559	137829	301	46.885965	141.12675465	Bacteria	2	Bacteria	Bacteria	484	2.3299999999999996e-132	NTclustered	gi\|315177282\|gb\|HQ532522.1\|	34034	g136260	i0	95.681	104.654485049834	301	13	100	0	1	301	470	170	Uncultured delta proteobacterium clone CR011E8 16S ribosomal RNA gene, partial sequence	blastn	31501	484	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
12382181	12382181	PRJNA928559_P_NODE_179870_length_259_cov_1.784946_g178301_i0	PRJNA928559	179870	259	1.784946	4.62301014	Bradymonas sediminis	1548548	Bacteria	Bacteria	89.8	1.8e-13	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g178301	i0	87.179	0.301158301158301	78	10	30	0	172	249	167761	167684	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	78	89.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
12732254	12732254	PRJNA928559_P_NODE_172650_length_265_cov_3.958333_g171081_i0	PRJNA928559	172650	265	3.958333	10.48958245	Bacteria	2	Bacteria	Bacteria	411	3.47e-110	NTclustered	gi\|523452747\|gb\|KF183167.1\|	34034	g171081	i0	95.686	89.3433962264151	255	11	96	0	1	255	255	1	Uncultured delta proteobacterium clone S3-039 16S ribosomal RNA gene, partial sequence	blastn	23676	411	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
12732530	12732530	PRJNA928559_P_NODE_52790_length_473_cov_7.902500_g51224_i0	PRJNA928559	52790	473	7.9025	37.378825	Bacteria	2	Bacteria	Bacteria	65.8	5.91e-6	NTclustered	gi\|618731234\|emb\|HE803860.1\|	34034	g51224	i0	91.489	0.198731501057082	47	4	10	0	221	267	1346	1300	Uncultured delta proteobacterium partial 16S rRNA gene, isolate 1.2, clone 2	blastn	94	65.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
13656954	13656954	PRJNA928559_P_NODE_195531_length_250_cov_0.881356_g193962_i0	PRJNA928559	195531	250	0.881356	2.20339	Bradymonadaceae bacterium	2740543	Bacteria	Bacteria	68.6	3.11e-11	NR	MFU8805234.1	2740543	g193962	i0	51.3	0.936	78	38	93.6	0	9	242	11	88	MFU8805234.1 two-component system sensor histidine kinase NtrB [Bradymonadaceae bacterium]	diamond	234	68.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae		Bradymonadaceae bacterium
16555159	16555159	PRJNA928559_P_NODE_129513_length_312_cov_1.644351_g127944_i0	PRJNA928559	129513	312	1.644351	5.13037512	root	1	Root_unresolved	Root_unresolved	111	4.74e-20	NTclustered	gi\|18077335\|emb\|AJ347755.1\|	34034	g127944	i0	90.588	27.2532051282051	85	7	27	1	199	283	1152	1069	Uncultured delta proteobacterium 16S rRNA gene, clone ST-12K6	blastn	8503	111	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
17481533	17481533	PRJNA928559_P_NODE_204954_length_246_cov_0.901734_g203385_i0	PRJNA928559	204954	246	0.901734	2.21826564	Bradymonadales	1779134	Bacteria	Bacteria	122	6.38e-31	NR	WP_146958764.1	2600177	g203385	i0	81.2	3.3780487804878	69	13	84.1	0	208	2	1	69	WP_146958764.1 UDP-N-acetylglucosamine 1-carboxyvinyltransferase [Microvenator marinus]	diamond	831	122	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
17482914	17482914	PRJNA928559_P_NODE_9954_length_971_cov_5.164811_g8765_i0	PRJNA928559	9954	971	5.164811	50.15031481	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	946	0	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g8765	i0	84.67	187.880535530381	985	112	99	24	1	961	3929	2960	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	182432	946	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
17482918	17482918	PRJNA928559_P_NODE_99854_length_357_cov_1.665493_g98285_i0	PRJNA928559	99854	357	1.665493	5.94581001	Bacteria	2	Bacteria	Bacteria	114	5.15e-30	NR	OGQ03968.1	1797856	g98285	i0	59.3	11.327731092437	113	40	95	2	341	3	1	107	OGQ03968.1 MAG: 50S ribosomal protein L7/L12 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	4044	115	0.991304347826087	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
17830270	17830270	PRJNA928559_P_NODE_152974_length_284_cov_85405.753555_g151405_i0	PRJNA928559	152974	284	85405.753555	242552.3400962	Pseudomonadota	1224	Bacteria	Bacteria	305	1.82e-78	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g151405	i0	100	58.1021126760563	165	0	58	0	120	284	180	16	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	16501	307	0.993485342019544	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
18756059	18756059	PRJNA928559_P_NODE_83995_length_387_cov_5.063694_g82426_i0	PRJNA928559	83995	387	5.063694	19.59649578	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	394	5.33e-105	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g82426	i0	85.176	138.498708010336	398	43	99	9	1	384	4183	4578	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	53599	394	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
20379294	20379294	PRJNA928559_P_NODE_210256_length_244_cov_0.912281_g208687_i0	PRJNA928559	210256	244	0.912281	2.22596564	Thermodesulfobacteriota	200940	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|68161332\|gb\|DQ069214.1\|	34034	g208687	i0	99.59	99.983606557377	244	1	100	0	1	244	871	628	Uncultured delta proteobacterium clone MAB1 16S ribosomal RNA gene, partial sequence	blastn	24396	446	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
20379573	20379573	PRJNA928559_P_NODE_94376_length_367_cov_1.326531_g92807_i0	PRJNA928559	94376	367	1.326531	4.86836877	Lujinxingia	2653226	Bacteria	Bacteria	178	3.9e-54	NR	WP_146981624.1	2600176	g92807	i0	69.2	4.89645776566757	120	37	98.1	0	362	3	77	196	WP_146981624.1 30S ribosomal protein S4 [Lujinxingia vulgaris]	diamond	1797	178	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae	Lujinxingia	Lujinxingia vulgaris
21304970	21304970	PRJNA928559_P_NODE_173197_length_265_cov_1.625000_g171628_i0	PRJNA928559	173197	265	1.625	4.30625	Bradymonas sediminis	1548548	Bacteria	Bacteria	135	2.3400000000000003e-27	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g171628	i0	78.774	0.8	212	37	78	8	13	220	3664427	3664220	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	212	135	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
21305516	21305516	PRJNA928559_P_NODE_210857_length_243_cov_2.305882_g209288_i0	PRJNA928559	210857	243	2.305882	5.60329326	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	303	5.48e-78	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g209288	i0	92.453	145.279835390946	212	16	87	0	31	242	4225	4014	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	35303	303	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
22930517	22930517	PRJNA928559_P_NODE_149998_length_287_cov_101368.130841_g148429_i0	PRJNA928559	149998	287	101368.130841	290926.53551367	Pseudomonadota	1224	Bacteria	Bacteria	329	1.09e-85	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g148429	i0	100	62.0209059233449	178	0	62	0	1	178	16	193	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	17800	329	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
24204208	24204208	PRJNA928559_P_NODE_126779_length_315_cov_105289.454545_g125210_i0	PRJNA928559	126779	315	105289.454545	331661.78181675	Pseudomonadota	1224	Bacteria	Bacteria	366	9.27e-97	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g125210	i0	100	64.1142857142857	198	0	63	0	118	315	213	16	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	20196	366	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
25479645	25479645	PRJNA928559_P_NODE_3580_length_1548_cov_3.755932_g2941_i0	PRJNA928559	3580	1548	3.755932	58.14182736	Thermodesulfobacteriota	200940	Bacteria	Bacteria	305	1.46e-93	NR	MBF0351506.1	2024889	g2941	i0	60.3	3.83720930232558	272	106	52.3	2	836	27	26	297	MBF0351506.1 PfaD family polyunsaturated fatty acid/polyketide biosynthesis protein [SAR324 cluster bacterium]	diamond	5940	308	0.99025974025974	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
28130420	28130420	PRJNA928559_P_NODE_214145_length_242_cov_1.384615_g212576_i0	PRJNA928559	214145	242	1.384615	3.3507683	Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12	1973967	Bacteria	Bacteria	42.4	0.0499	NR	PJB48263.1	1973967	g212576	i0	37.9	0.71900826446281	58	33	68.2	1	63	227	447	504	PJB48263.1 MAG: hypothetical protein CO108_02650 [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12]	diamond	174	42.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12
28382816	28382816	PRJNA928559_P_NODE_153786_length_284_cov_1.279621_g152217_i0	PRJNA928559	153786	284	1.279621	3.63412364	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	67.8	1.73e-12	NR	MBA2660823.1	2946527	g152217	i0	42	0.855633802816901	81	46	85.6	1	276	34	8	87	MBA2660823.1 KH domain-containing protein [Lujinxingiaceae bacterium]	diamond	243	67.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae		Lujinxingiaceae bacterium
28737390	28737390	PRJNA928559_P_NODE_194387_length_250_cov_1.389831_g192818_i0	PRJNA928559	194387	250	1.389831	3.4745775	Bacteria	2	Bacteria	Bacteria	53.9	4.3e-6	NR	OGQ06361.1	1797856	g192818	i0	40.5	1.896	79	47	94.8	0	248	12	203	281	OGQ06361.1 MAG: hypothetical protein A2712_05585 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	474	53.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
30182756	30182756	PRJNA928559_P_NODE_179052_length_260_cov_1.331551_g177483_i0	PRJNA928559	179052	260	1.331551	3.4620326	Microvenator marinus	2600177	Bacteria	Bacteria	79	1.91e-15	NR	WP_146957651.1	2600177	g177483	i0	52.3	3.09230769230769	86	41	99.2	0	2	259	170	255	WP_146957651.1 PspA/IM30 family protein [Microvenator marinus]	diamond	804	79	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
31763182	31763182	PRJNA928559_P_NODE_47097_length_496_cov_2.482270_g45535_i0	PRJNA928559	47097	496	2.48227	12.3120592	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	97.4	5.02e-20	NR	PKN53796.1	2013741	g45535	i0	43	0.647177419354839	107	54	63.5	3	324	10	751	852	PKN53796.1 MAG: hypothetical protein CVU56_29970 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	321	97.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
32142896	32142896	PRJNA928559_P_NODE_197318_length_249_cov_0.886364_g195749_i0	PRJNA928559	197318	249	0.886364	2.20704636	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	107	1.85e-25	NR	MBA2662702.1	2946527	g195749	i0	61	0.987951807228916	82	32	98.8	0	248	3	76	157	MBA2662702.1 hypothetical protein [Lujinxingiaceae bacterium]	diamond	246	107	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae		Lujinxingiaceae bacterium
32522833	32522833	PRJNA928559_P_NODE_214819_length_242_cov_0.923077_g213250_i0	PRJNA928559	214819	242	0.923077	2.23384634	Bradymonadaceae bacterium	2740543	Bacteria	Bacteria	89.7	2.97e-20	NR	MFU8805295.1	2740543	g213250	i0	48.6	0.892561983471074	72	37	89.3	0	217	2	91	162	MFU8805295.1 hypothetical protein [Bradymonadaceae bacterium]	diamond	216	89.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae		Bradymonadaceae 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);;