metadata: contig_metadata: 35 rows where bioproject = "PRJNA168635" and tax

35 rows where bioproject = "PRJNA168635" 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_species
364235	364235	PRJNA168635_P_NODE_12281_length_232_cov_16.054645_g11865_i0	PRJNA168635	12281	232	16.054645	37.2467764	uncultured delta proteobacterium	34034	Bacteria	Bacteria	379	8.379999999999998e-101	NTclustered	gi\|60266294\|gb\|AY921748.1\|	34034	g11865	i0	96.121	99.7413793103448	232	9	100	0	1	232	100	331	Uncultured delta proteobacterium clone AKYH800 16S ribosomal RNA gene, partial sequence	blastn	23140	379	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
2915454	2915454	PRJNA168635_P_NODE_9383_length_272_cov_12.062780_g8968_i0	PRJNA168635	9383	272	12.06278	32.8107616	uncultured delta proteobacterium HF0070_10I02	710824	Bacteria	Bacteria	276	1.36e-69	NTclustered	gi\|297181000\|gb\|GU474857.1\|	710824	g8968	i0	85.145	171.621323529412	276	33	99	7	1	271	8051	7779	Uncultured delta proteobacterium HF0070_10I02 genomic sequence	blastn	46681	276	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium HF0070_10I02
3604573	3604573	PRJNA168635_P_NODE_11883_length_237_cov_6.398936_g11467_i0	PRJNA168635	11883	237	6.398936	15.16547832	Thermodesulfobacteriota	200940	Bacteria	Bacteria	154	5.67e-33	NTclustered	gi\|2874253888\|emb\|OY970063.1\|	34034	g11467	i0	80.09	98.1223628691983	221	32	91	10	18	232	629349	629563	MAG: uncultured delta proteobacterium isolate MFD10007.bin.1.119 genome assembly, chromosome: 1	blastn	23255	154	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
3604678	3604678	PRJNA168635_P_NODE_2223_length_545_cov_35.318548_g1847_i0	PRJNA168635	2223	545	35.318548	192.4860866	Bacteria	2	Bacteria	Bacteria	710	0	NTclustered	gi\|202950679\|emb\|FM206051.1\|	34034	g1847	i0	99.488	70.9155963302752	391	0	71	2	157	545	1	391	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_46	blastn	38649	710	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
5467586	5467586	PRJNA168635_P_NODE_12785_length_227_cov_3.730337_g12369_i0	PRJNA168635	12785	227	3.730337	8.46786499	uncultured delta proteobacterium	34034	Bacteria	Bacteria	156	1.4999999999999999e-33	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g12369	i0	79.654	22.3436123348018	231	35	99	10	1	224	13512	13737	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	5072	156	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
5467663	5467663	PRJNA168635_P_NODE_1645_length_623_cov_22.926829_g1293_i0	PRJNA168635	1645	623	22.926829	142.83414467	uncultured delta proteobacterium	34034	Bacteria	Bacteria	656	0	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g1293	i0	85.94	172.60834670947	633	68	99	20	2	623	81924	82546	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	107535	656	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
5467757	5467757	PRJNA168635_P_NODE_21625_length_177_cov_2.398438_g21209_i0	PRJNA168635	21625	177	2.398438	4.24523526	uncultured delta proteobacterium	34034	Bacteria	Bacteria	226	8.329999999999998e-55	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g21209	i0	92.903	267.209039548023	155	11	88	0	3	157	82459	82613	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	47296	226	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
5468040	5468040	PRJNA168635_P_NODE_6725_length_326_cov_405.184116_g6314_i0	PRJNA168635	6725	326	405.184116	1320.90021816	uncultured delta proteobacterium	34034	Bacteria	Bacteria	553	6.889999999999998e-153	NTclustered	gi\|2042798616\|gb\|MZ246172.1\|	34034	g6314	i0	97.248	100.236196319018	327	7	100	2	1	326	376	51	Uncultured delta proteobacterium clone RE_566 16S ribosomal RNA gene, partial sequence	blastn	32677	553	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
6742036	6742036	PRJNA168635_P_NODE_13446_length_221_cov_1.720930_g13030_i0	PRJNA168635	13446	221	1.72093	3.8032553	uncultured delta proteobacterium	34034	Bacteria	Bacteria	119	1.9e-22	NTclustered	gi\|2874254016\|emb\|OY970341.1\|	34034	g13030	i0	78.889	5.35746606334842	180	34	81	4	35	212	593819	593996	MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1	blastn	1184	119	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
6742240	6742240	PRJNA168635_P_NODE_27546_length_166_cov_15.752137_g27130_i0	PRJNA168635	27546	166	15.752137	26.14854742	uncultured delta proteobacterium	34034	Bacteria	Bacteria	169	1.32e-37	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g27130	i0	85.294	156.89156626506	170	18	99	3	2	166	13826	13993	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	26044	169	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
8017827	8017827	PRJNA168635_P_NODE_2287_length_538_cov_19.065440_g1909_i0	PRJNA168635	2287	538	19.06544	102.5720672	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	220	1.37e-52	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g1909	i0	82.996	62.6914498141264	247	38	57	4	294	537	4638	4883	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	33728	220	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium DeepAnt-1F12
8706943	8706943	PRJNA168635_P_NODE_15867_length_201_cov_2.032895_g15451_i0	PRJNA168635	15867	201	2.032895	4.08611895	Bacteria	2	Bacteria	Bacteria	215	2.11e-51	NTclustered	gi\|2874254016\|emb\|OY970341.1\|	34034	g15451	i0	89.881	497.885572139303	168	16	84	1	9	176	592819	592985	MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1	blastn	100075	215	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
8707002	8707002	PRJNA168635_P_NODE_22667_length_174_cov_16.072000_g22251_i0	PRJNA168635	22667	174	16.072	27.96528	root	1	Root_unresolved	Root_unresolved	305	1.02e-78	NTclustered	gi\|258598210\|gb\|GQ453029.1\|	34034	g22251	i0	98.286	100.5	175	2	100	1	1	174	24	198	Uncultured delta proteobacterium clone I-GAC-72 16S ribosomal RNA gene, partial sequence	blastn	17487	305	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
8707085	8707085	PRJNA168635_P_NODE_3487_length_446_cov_90.239295_g3087_i0	PRJNA168635	3487	446	90.239295	402.4672557	Bacteria	2	Bacteria	Bacteria	496	1.6599999999999998e-135	NTclustered	gi\|254797361\|gb\|GQ302547.1\|	34034	g3087	i0	87.185	74.2399103139013	437	54	98	2	11	446	74	509	Uncultured delta proteobacterium clone sw-xj158 16S ribosomal RNA gene, partial sequence	blastn	33111	496	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
10568564	10568564	PRJNA168635_P_NODE_24109_length_171_cov_2.098361_g23693_i0	PRJNA168635	24109	171	2.098361	3.58819731	uncultured delta proteobacterium	34034	Bacteria	Bacteria	159	8.199999999999998e-35	NTclustered	gi\|2874253888\|emb\|OY970063.1\|	34034	g23693	i0	87.943	169.245614035088	141	10	80	6	18	154	628713	628850	MAG: uncultured delta proteobacterium isolate MFD10007.bin.1.119 genome assembly, chromosome: 1	blastn	28941	159	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
11257505	11257505	PRJNA168635_P_NODE_22289_length_175_cov_5.492063_g21873_i0	PRJNA168635	22289	175	5.492063	9.61111025	root	1	Root_unresolved	Root_unresolved	324	2.83e-84	NTclustered	gi\|219693367\|gb\|FJ516890.1\|	34034	g21873	i0	100	99.9257142857143	175	0	100	0	1	175	563	737	Uncultured delta proteobacterium clone TDNP_USbc97_138_1_18 16S ribosomal RNA gene, partial sequence	blastn	17487	324	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
11843226	11843226	PRJNA168635_P_NODE_32710_length_160_cov_5.846847_g32294_i0	PRJNA168635	32710	160	5.846847	9.3549552	uncultured delta proteobacterium	34034	Bacteria	Bacteria	139	9.9e-29	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g32294	i0	84.028	73.9625	144	23	90	0	12	155	81105	80962	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	11834	139	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
13118268	13118268	PRJNA168635_P_NODE_21891_length_176_cov_6.952756_g21475_i0	PRJNA168635	21891	176	6.952756	12.23685056	uncultured delta proteobacterium	34034	Bacteria	Bacteria	254	3.79e-63	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g21475	i0	92.614	137.301136363636	176	13	100	0	1	176	13335	13160	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	24165	254	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
14393395	14393395	PRJNA168635_P_NODE_11132_length_246_cov_1.477157_g10717_i0	PRJNA168635	11132	246	1.477157	3.63380622	Deltaproteobacteria bacterium Smac51	2946587	Bacteria	Bacteria	156	1.65e-33	NTclustered	gi\|2242725236\|gb\|CP026657.1\|	2946587	g10717	i0	79.911	59.9552845528455	224	35	89	9	1	218	2066636	2066855	Deltaproteobacteria bacterium Smac51 chromosome, complete genome	blastn	14749	156	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium Smac51
15081900	15081900	PRJNA168635_P_NODE_3972_length_420_cov_38.504043_g3571_i0	PRJNA168635	3972	420	38.504043	161.7169806	root	1	Root_unresolved	Root_unresolved	455	2.64e-123	NTclustered	gi\|76152274\|gb\|DQ195155.1\|	34034	g3571	i0	86.256	99.7619047619048	422	54	100	4	1	420	396	815	Uncultured delta proteobacterium clone CD204C10 16S ribosomal RNA gene, partial sequence	blastn	41900	457	0.99562363238512	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
15667086	15667086	PRJNA168635_P_NODE_10973_length_248_cov_3.819095_g10558_i0	PRJNA168635	10973	248	3.819095	9.4713556	uncultured delta proteobacterium	34034	Bacteria	Bacteria	167	7.679999999999999e-37	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g10558	i0	81.517	9.4758064516129	211	31	83	6	44	248	13725	13517	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	2350	167	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
16941766	16941766	PRJNA168635_P_NODE_25754_length_168_cov_4.714286_g25338_i0	PRJNA168635	25754	168	4.714286	7.92000048	uncultured delta proteobacterium	34034	Bacteria	Bacteria	239	1.01e-58	NTclustered	gi\|151350002\|gb\|EF662711.1\|	34034	g25338	i0	92.262	95.5238095238095	168	13	100	0	1	168	108	275	Uncultured delta proteobacterium clone GASP-MA1W2_F10 16S ribosomal RNA gene, partial sequence	blastn	16048	239	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
16941946	16941946	PRJNA168635_P_NODE_4594_length_393_cov_23.325581_g4190_i0	PRJNA168635	4594	393	23.325581	91.66953333	uncultured delta proteobacterium	34034	Bacteria	Bacteria	370	9.14e-98	NTclustered	gi\|40362888\|gb\|AY494619.1\|	34034	g4190	i0	95.671	93.3129770992366	231	9	94	1	1	231	230	1	Uncultured delta proteobacterium clone DELTA2 16S ribosomal RNA gene, partial sequence	blastn	36672	370	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
16941984	16941984	PRJNA168635_P_NODE_6554_length_330_cov_395.651246_g6143_i0	PRJNA168635	6554	330	395.651246	1305.6491118	uncultured delta proteobacterium	34034	Bacteria	Bacteria	503	7.14e-138	NTclustered	gi\|2042798616\|gb\|MZ246172.1\|	34034	g6143	i0	94.26	99.9818181818182	331	15	99	4	1	329	376	48	Uncultured delta proteobacterium clone RE_566 16S ribosomal RNA gene, partial sequence	blastn	32994	503	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
16942057	16942057	PRJNA168635_P_NODE_9794_length_265_cov_69.666667_g9379_i0	PRJNA168635	9794	265	69.666667	184.61666755	uncultured delta proteobacterium 305ev	117285	Bacteria	Bacteria	405	1.61e-108	NTclustered	gi\|7414835\|emb\|AJ287630.1\|	117285	g9379	i0	97.468	92.1584905660377	237	6	89	0	1	237	237	1	uncultured delta proteobacterium 305ev partial 16S rRNA gene	blastn	24422	405	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium 305ev
18216068	18216068	PRJNA168635_P_NODE_15175_length_206_cov_3.210191_g14759_i0	PRJNA168635	15175	206	3.210191	6.61299346	uncultured delta proteobacterium DeepAnt-32C6	357895	Bacteria	Bacteria	187	4.7299999999999984e-43	NTclustered	gi\|82617838\|gb\|DQ267496.1\|	357895	g14759	i0	83.415	649.116504854369	205	31	99	2	2	206	3675	3474	Uncultured delta proteobacterium DeepAnt-32C6 fosmid, complete sequence	blastn	133718	187	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium DeepAnt-32C6
22731118	22731118	PRJNA168635_P_NODE_34238_length_155_cov_3.716981_g33822_i0	PRJNA168635	34238	155	3.716981	5.76132055	Bacteria	2	Bacteria	Bacteria	270	3.23e-68	NTclustered	gi\|219693507\|gb\|FJ517030.1\|	34034	g33822	i0	98.065	99.7354838709677	155	3	100	0	1	155	651	497	Uncultured delta proteobacterium clone TDNP_Wbc97_172_1_63 16S ribosomal RNA gene, partial sequence	blastn	15459	270	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
23316474	23316474	PRJNA168635_P_NODE_15139_length_206_cov_7.012739_g14723_i0	PRJNA168635	15139	206	7.012739	14.44624234	uncultured delta proteobacterium	34034	Bacteria	Bacteria	137	4.83e-28	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g14723	i0	86.992	222.558252427184	123	14	59	2	85	206	82411	82532	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	45847	137	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
23316500	23316500	PRJNA168635_P_NODE_16779_length_195_cov_2.712329_g16363_i0	PRJNA168635	16779	195	2.712329	5.28904155	uncultured delta proteobacterium	34034	Bacteria	Bacteria	281	1.9700000000000002e-71	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g16363	i0	92.784	159.369230769231	194	14	99	0	2	195	13027	13220	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	31077	281	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
24006157	24006157	PRJNA168635_P_NODE_19319_length_184_cov_16.214815_g18903_i0	PRJNA168635	19319	184	16.214815	29.8352596	Pseudomonadati	3379134	Bacteria	Bacteria	324	3.01e-84	NTclustered	gi\|2264046149\|gb\|ON921937.1\|	34034	g18903	i0	98.37	99.6195652173913	184	3	100	0	1	184	191	8	Uncultured delta proteobacterium clone S156 16S ribosomal RNA gene, partial sequence	blastn	18330	324	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
24006291	24006291	PRJNA168635_P_NODE_33539_length_157_cov_5.435185_g33123_i0	PRJNA168635	33539	157	5.435185	8.53324045	Thermodesulfobacteriota	200940	Bacteria	Bacteria	206	9.4e-49	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g33123	i0	90.446	363.152866242038	157	14	99	1	1	156	82900	82744	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	57015	206	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
26838810	26838810	PRJNA168635_P_NODE_25901_length_168_cov_1.957983_g25485_i0	PRJNA168635	25901	168	1.957983	3.28941144	Bacteria	2	Bacteria	Bacteria	88.6	6.37e-19	NR	MEY8217458.1	2024889	g25485	i0	78.2	1.96428571428571	55	12	98.2	0	3	167	6	60	MEY8217458.1 DUF5309 family protein [SAR324 cluster bacterium]	diamond	330	88.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	SAR324 cluster bacterium
30927196	30927196	PRJNA168635_P_NODE_19874_length_183_cov_1.261194_g19458_i0	PRJNA168635	19874	183	1.261194	2.30798502	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	48.9	1.1e-4	NR	MDX2469221.1	2024889	g19458	i0	50	0.721311475409836	44	22	72.1	0	48	179	344	387	MDX2469221.1 YfhO family protein [SAR324 cluster bacterium]	diamond	132	48.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	SAR324 cluster bacterium
31179436	31179436	PRJNA168635_P_NODE_33015_length_159_cov_3.827273_g32599_i0	PRJNA168635	33015	159	3.827273	6.08536407	uncultured delta proteobacterium HF	34034	Bacteria	Bacteria	55.5	1.39e-7	NR	ADI17622.1	710828	g32599	i0	70.6	0.641509433962264	34	10	64.2	0	147	46	84	117	ADI17622.1 hypothetical protein [uncultured delta proteobacterium HF0130_19C20]	diamond	102	55.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium HF0130_19C20
32634345	32634345	PRJNA168635_P_NODE_19640_length_183_cov_4.917910_g19224_i0	PRJNA168635	19640	183	4.91791	8.9997753	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	60.5	9.16e-9	NR	MEY8217461.1	2024889	g19224	i0	49.1	0.934426229508197	57	29	93.4	0	6	176	33	89	MEY8217461.1 hypothetical protein [SAR324 cluster bacterium]	diamond	171	60.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	SAR324 cluster 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);;