metadata: contig_metadata: 27 rows where bioproject = "PRJEB11748" and tax

27 rows where bioproject = "PRJEB11748" 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
17235	17235	PRJEB11748_P_NODE_270441_length_235_cov_1.350575_g268258_i0	PRJEB11748	270441	235	1.350575	3.17385125	Persicimonas caeni	2292766	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g268258	i0	100	0.246808510638298	29	0	12	0	36	64	1785079	1785107	Persicimonas caeni strain YN101 chromosome	blastn	58	54.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
1291046	1291046	PRJEB11748_P_NODE_245282_length_250_cov_1.534392_g243099_i0	PRJEB11748	245282	250	1.534392	3.83598	uncultured delta proteobacterium	34034	Bacteria	Bacteria	73.1	1.74e-8	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g243099	i0	79.13	2.06	115	17	45	6	33	144	3125296	3125186	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	515	73.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
4811604	4811604	PRJEB11748_P_NODE_227464_length_262_cov_2.223881_g225281_i0	PRJEB11748	227464	262	2.223881	5.82656822	root	1	Root_unresolved	Root_unresolved	409	1.23e-109	NTclustered	gi\|281324647\|gb\|GU236012.1\|	34034	g225281	i0	97.119	92.7519083969466	243	5	92	2	22	262	534	776	Uncultured delta proteobacterium clone RLT34_02 16S ribosomal RNA gene, partial sequence	blastn	24301	411	0.995133819951338	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
15317786	15317786	PRJEB11748_P_NODE_181453_length_300_cov_10.246862_g179270_i0	PRJEB11748	181453	300	10.246862	30.740586	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	285	2.5299999999999996e-72	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g179270	i0	87.705	135.316666666667	244	30	81	0	23	266	12899	12656	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	40595	285	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
17870980	17870980	PRJEB11748_P_NODE_42075_length_669_cov_16.847039_g40024_i0	PRJEB11748	42075	669	16.847039	112.70669091	Bacteria	2	Bacteria	Bacteria	145	2.8e-36	NR	OQB08498.1	1852869	g40024	i0	44.9	1.49775784753363	167	89	74.9	3	637	137	176	339	OQB08498.1 MAG: Serine/threonine-protein kinase pkn1 [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	1002	145	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin207
20110619	20110619	PRJEB11748_P_NODE_280516_length_229_cov_3.672619_g278333_i0	PRJEB11748	280516	229	3.672619	8.41029751	Bacteria	2	Bacteria	Bacteria	407	3.7799999999999995e-109	NTclustered	gi\|430803027\|gb\|KC011136.1\|	34034	g278333	i0	98.69	100.275109170306	229	3	100	0	1	229	91	319	Uncultured delta proteobacterium clone bsc37 16S ribosomal RNA gene, partial sequence	blastn	22963	407	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
21386497	21386497	PRJEB11748_P_NODE_322597_length_209_cov_3.560811_g320414_i0	PRJEB11748	322597	209	3.560811	7.44209499	root	1	Root_unresolved	Root_unresolved	73.1	1.41e-8	NTclustered	gi\|58045904\|gb\|AY868169.1\|	34034	g320414	i0	100	18.6267942583732	39	0	19	0	150	188	313	275	Uncultured delta proteobacterium clone I3K-0064 16S ribosomal RNA gene, partial sequence	blastn	3893	73.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
24243850	24243850	PRJEB11748_P_NODE_314140_length_213_cov_1.684211_g311957_i0	PRJEB11748	314140	213	1.684211	3.58736943	Bradymonas sediminis	1548548	Bacteria	Bacteria	93.5	1.1e-14	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g311957	i0	82.569	0.7981220657277	109	15	50	4	63	169	1769039	1769145	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	170	93.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
27627126	27627126	PRJEB11748_P_NODE_307544_length_216_cov_1.761290_g305361_i0	PRJEB11748	307544	216	1.76129	3.8043864	Bacteria	2	Bacteria	Bacteria	70.1	5.92e-12	NR	OGP20082.1	1797812	g305361	i0	50.8	2.76388888888889	65	32	90.3	0	211	17	117	181	OGP20082.1 MAG: hypothetical protein A2X90_03970 [Deltaproteobacteria bacterium GWA2_65_63]	diamond	597	70.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium GWA2_65_63
27722099	27722099	PRJEB11748_P_NODE_260604_length_240_cov_7.642458_g258421_i0	PRJEB11748	260604	240	7.642458	18.3418992	Bacillota	1239	Bacteria	Bacteria	86.3	1.63e-17	NR	OGP14608.1	1797809	g258421	i0	53.6	2.5125	69	32	86.3	0	22	228	394	462	OGP14608.1 MAG: phosphoglycerate mutase (2,3-diphosphoglycerate-independent) [Deltaproteobacteria bacterium GWA2_55_10]	diamond	603	86.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium GWA2_55_10
27948979	27948979	PRJEB11748_P_NODE_37505_length_715_cov_6.259939_g35527_i0	PRJEB11748	37505	715	6.259939	44.75856385	Deltaproteobacteria bacterium RIFCSPHIGHO2_	2026735	Bacteria	Bacteria	136	2.1799999999999996e-37	NR	OGQ07090.1	1797859	g35527	i0	68.8	0.805594405594406	96	30	40.3	0	124	411	1	96	OGQ07090.1 MAG: hypothetical protein A3C45_05745 [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_28]	diamond	576	136	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_28
28321517	28321517	PRJEB11748_P_NODE_280106_length_229_cov_7.898810_g277923_i0	PRJEB11748	280106	229	7.89881	18.0882749	Pseudomonadota	1224	Bacteria	Bacteria	116	2.99e-29	NR	CAD7845223.1	260707	g277923	i0	76.8	3.49781659388646	69	16	90.4	0	215	9	256	324	CAD7845223.1 MAG: hypothetical protein [Olavius algarvensis Delta 4 endosymbiont]	diamond	801	116	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Olavius algarvensis Delta 4 endosymbiont
28700553	28700553	PRJEB11748_P_NODE_234307_length_257_cov_3.224490_g232124_i0	PRJEB11748	234307	257	3.22449	8.2869393	Myxococcota	2818505	Bacteria	Bacteria	42.4	0.0387	NR	PKN35946.1	2013746	g232124	i0	59.4	0.723735408560311	32	13	37.4	0	254	159	143	174	PKN35946.1 MAG: hypothetical protein CVU61_00125 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-19]	diamond	186	42.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-19
28801137	28801137	PRJEB11748_P_NODE_150928_length_334_cov_2.827839_g148747_i0	PRJEB11748	150928	334	2.827839	9.44498226	Olavius algarvensis Delta 1 endosymbiont	334747	Bacteria	Bacteria	57.8	6.15e-7	NR	CAB1083110.1	334747	g148747	i0	36.2	0.844311377245509	94	57	83.5	2	35	313	3721	3812	CAB1083110.1 hypothetical protein D1AOALGA4SA_10694 [Olavius algarvensis Delta 1 endosymbiont]	diamond	282	57.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Olavius algarvensis Delta 1 endosymbiont
29111054	29111054	PRJEB11748_P_NODE_360648_length_192_cov_5.190840_g358465_i0	PRJEB11748	360648	192	5.19084	9.9664128	Bacillati	1783272	Bacteria	Bacteria	45.4	0.00217	NR	OGQ84716.1	1797894	g358465	i0	56.3	2.21875	48	21	75	0	156	13	139	186	OGQ84716.1 MAG: hypothetical protein A3F90_12375 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19]	diamond	426	45.8	0.991266375545852	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19
29212055	29212055	PRJEB11748_P_NODE_313569_length_213_cov_3.026316_g311386_i0	PRJEB11748	313569	213	3.026316	6.44605308	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	43.5	0.0135	NR	PKN57776.1	2013741	g311386	i0	42.6	0.661971830985915	47	25	63.4	1	79	213	260	306	PKN57776.1 MAG: hypothetical protein CVU56_09260 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	141	43.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
29495977	29495977	PRJEB11748_P_NODE_236350_length_256_cov_1.205128_g234167_i0	PRJEB11748	236350	256	1.205128	3.08512768	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	59.3	6.38e-8	NR	NQU64489.1	2024889	g234167	i0	46.8	1.8046875	79	35	87.9	4	2	226	283	358	NQU64489.1 DNA primase [SAR324 cluster bacterium]	diamond	462	59.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
30032964	30032964	PRJEB11748_P_NODE_256491_length_243_cov_1.785714_g254308_i0	PRJEB11748	256491	243	1.785714	4.33928502	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4	2013754	Bacteria	Bacteria	57.4	2.61e-7	NR	PKN12702.1	2013754	g254308	i0	44.8	0.827160493827161	67	35	81.5	2	198	1	309	374	PKN12702.1 MAG: NAD-dependent DNA ligase LigA [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4]	diamond	201	57.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4
30184577	30184577	PRJEB11748_P_NODE_211732_length_274_cov_2.441315_g209549_i0	PRJEB11748	211732	274	2.441315	6.6892031	Bacteria	2	Bacteria	Bacteria	52.4	1.98e-5	NR	OGQ87365.1	1797905	g209549	i0	62.5	2.93430656934307	40	15	43.8	0	272	153	289	328	OGQ87365.1 MAG: hypothetical protein A2512_08430 [Deltaproteobacteria bacterium RIFOXYD12_FULL_56_24]	diamond	804	52.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYD12_FULL_56_24
30374671	30374671	PRJEB11748_P_NODE_343312_length_201_cov_3.000000_g341129_i0	PRJEB11748	343312	201	3	6.03	Bacteria	2	Bacteria	Bacteria	123	2.49e-31	NR	NMC61765.1	2024889	g341129	i0	92.1	1.88059701492537	63	5	94	0	11	199	344	406	NMC61765.1 BREX system Lon protease-like protein BrxL [SAR324 cluster bacterium]	diamond	378	124	0.991935483870968	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
30475230	30475230	PRJEB11748_P_NODE_115593_length_386_cov_8.101538_g113419_i0	PRJEB11748	115593	386	8.101538	31.27193668	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15	1797895	Bacteria	Bacteria	77.4	7.78e-15	NR	OGQ90181.1	1797895	g113419	i0	48.3	0.691709844559586	89	46	69.2	0	91	357	7	95	OGQ90181.1 MAG: hypothetical protein A2289_19790 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	267	77.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
30949401	30949401	PRJEB11748_P_NODE_48274_length_619_cov_2.026882_g46178_i0	PRJEB11748	48274	619	2.026882	12.54639958	Lujinxingia vulgaris	2600176	Bacteria	Bacteria	182	2.73e-53	NR	WP_146983494.1	2600176	g46178	i0	77.8	0.567043618739903	117	26	56.7	0	268	618	1	117	WP_146983494.1 replication initiation protein, partial [Lujinxingia vulgaris]	diamond	351	182	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae	Lujinxingia	Lujinxingia vulgaris
31233308	31233308	PRJEB11748_P_NODE_239735_length_253_cov_8.406250_g237552_i0	PRJEB11748	239735	253	8.40625	21.2678125	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12	2013739	Bacteria	Bacteria	43.1	0.0303	NR	PKN70103.1	2013739	g237552	i0	31.5	0.865612648221344	73	50	86.6	0	236	18	176	248	PKN70103.1 MAG: hypothetical protein CVU54_06840 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12]	diamond	219	43.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12
31796446	31796446	PRJEB11748_P_NODE_240617_length_253_cov_1.812500_g238434_i0	PRJEB11748	240617	253	1.8125	4.585625	Bacteria	2	Bacteria	Bacteria	101	8.339999999999999e-23	NR	CAB1055663.1	698986	g238434	i0	59.3	1.92094861660079	81	33	96	0	247	5	2712	2792	CAB1055663.1 hypothetical protein D1BOALGB6SA_396 [Olavius sp. associated proteobacterium Delta 1]	diamond	486	101	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Olavius sp. associated proteobacterium Delta 1
31802627	31802627	PRJEB11748_P_NODE_186757_length_295_cov_9.670940_g184574_i0	PRJEB11748	186757	295	9.67094	28.529273	Deltaproteobacteria bacterium RIFCSPHIGHO2_	2026735	Bacteria	Bacteria	114	4.16e-29	NR	OGQ06260.1	1797856	g184574	i0	91.4	0.589830508474576	58	5	59	0	26	199	52	109	OGQ06260.1 MAG: ribulose-phosphate 3-epimerase [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	174	114	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
32113151	32113151	PRJEB11748_P_NODE_360518_length_192_cov_6.106870_g358335_i0	PRJEB11748	360518	192	6.10687	11.7251904	Bacteria	2	Bacteria	Bacteria	82	2.44e-16	NR	OGQ81332.1	1797894	g358335	i0	83.7	3.375	43	7	67.2	0	149	21	217	259	OGQ81332.1 MAG: hypothetical protein A3F90_03455 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19]	diamond	648	82.4	0.995145631067961	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19
32214344	32214344	PRJEB11748_P_NODE_80538_length_468_cov_4.948403_g78373_i0	PRJEB11748	80538	468	4.948403	23.15852604	Lujinxingia vulgaris	2600176	Bacteria	Bacteria	202	1.03e-58	NR	WP_146982960.1	2600176	g78373	i0	72.3	8.16025641025641	141	38	89.7	1	447	28	227	367	WP_146982960.1 DUF262 domain-containing protein [Lujinxingia vulgaris]	diamond	3819	202	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae	Lujinxingia	Lujinxingia vulgaris

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