metadata: contig_metadata: 15 rows where bioproject = "PRJNA799842" and tax

15 rows where bioproject = "PRJNA799842" 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_species
10997984	10997984	PRJNA799842_P_NODE_174309_length_244_cov_0.900585_g172736_i0	PRJNA799842	174309	244	0.900585	2.1974274	uncultured delta proteobacterium	34034	Bacteria	Bacteria	115	2.77e-21	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g172736	i0	84.746	35.6803278688525	118	14	48	4	86	201	83812	83927	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	8706	115	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
23745435	23745435	PRJNA799842_P_NODE_101039_length_289_cov_2.129630_g99466_i0	PRJNA799842	101039	289	2.12963	6.1546307	uncultured delta proteobacterium	34034	Bacteria	Bacteria	158	5.51e-34	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g99466	i0	81.407	60.6124567474048	199	31	68	6	92	287	1501706	1501901	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	17517	158	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
26746114	26746114	PRJNA799842_P_NODE_164341_length_246_cov_0.890173_g162768_i0	PRJNA799842	164341	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	133	1.4e-34	NR	OGP54572.1	1797830	g162768	i0	81.5	2.95121951219512	81	15	98.8	0	2	244	405	485	OGP54572.1 MAG: hypothetical protein A2162_10340 [Deltaproteobacteria bacterium RBG_13_52_11b]	diamond	726	134	0.992537313432836	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium RBG_13_52_11b
26800756	26800756	PRJNA799842_P_NODE_143261_length_250_cov_0.870056_g141688_i0	PRJNA799842	143261	250	0.870056	2.17514	Deltaproteobacteria bacterium RBG_16_64_85	1797846	Bacteria	Bacteria	137	4.35e-36	NR	OGP80128.1	1797846	g141688	i0	78.3	4.98	83	18	99.6	0	249	1	55	137	OGP80128.1 MAG: hypothetical protein A2Z13_10750 [Deltaproteobacteria bacterium RBG_16_64_85]	diamond	1245	137	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium RBG_16_64_85
27686201	27686201	PRJNA799842_P_NODE_176184_length_243_cov_0.905882_g174611_i0	PRJNA799842	176184	243	0.905882	2.20129326	Deltaproteobacteria bacterium RBG_16_48_1	2026735	Bacteria	Bacteria	122	1.33e-30	NR	OGP89704.1	1797839	g174611	i0	72.5	0.987654320987654	80	22	98.8	0	241	2	161	240	OGP89704.1 MAG: transporter [Deltaproteobacteria bacterium RBG_16_48_10]	diamond	240	122	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium RBG_16_48_10
28254100	28254100	PRJNA799842_P_NODE_126506_length_260_cov_1.224599_g124933_i0	PRJNA799842	126506	260	1.224599	3.1839574	Bradymonadales bacterium	2099667	Bacteria	Bacteria	46.2	0.00279	NR	MBN1944503.1	2099667	g124933	i0	31.6	1.85769230769231	79	39	91.2	3	8	244	147	210	MBN1944503.1 glycogen-binding domain-containing protein [Bradymonadales bacterium]	diamond	483	46.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadales bacterium
28475229	28475229	PRJNA799842_P_NODE_163446_length_246_cov_0.890173_g161873_i0	PRJNA799842	163446	246	0.890173	2.18982558	delta proteobacterium ML8_D	1775672	Bacteria	Bacteria	146	5.2499999999999997e-39	NR	OPL10825.1	1775672	g161873	i0	82.9	7	82	14	100	0	246	1	54	135	OPL10825.1 MAG: propionate--CoA ligase [delta proteobacterium ML8_D]	diamond	1722	146	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		delta proteobacterium ML8_D
29390968	29390968	PRJNA799842_P_NODE_135629_length_251_cov_0.865169_g134056_i0	PRJNA799842	135629	251	0.865169	2.17157419	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4	2013754	Bacteria	Bacteria	134	6.5899999999999994e-37	NR	PKN13786.1	2013754	g134056	i0	91.8	0.872509960159363	73	6	87.3	0	33	251	171	243	PKN13786.1 MAG: acyl-[acyl-carrier-protein]--UDP-N-acetylglucosamine O-acyltransferase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4]	diamond	219	134	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4
29801177	29801177	PRJNA799842_P_NODE_178931_length_243_cov_0.905882_g177358_i0	PRJNA799842	178931	243	0.905882	2.20129326	Deltaproteobacteria bacterium RBG_16_48_1	2026735	Bacteria	Bacteria	60.5	2.01e-8	NR	OGP92881.1	1797839	g177358	i0	66.7	0.518518518518518	42	14	51.9	0	5	130	158	199	OGP92881.1 MAG: hypothetical protein A2156_09980 [Deltaproteobacteria bacterium RBG_16_48_10]	diamond	126	60.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium RBG_16_48_10
29810160	29810160	PRJNA799842_P_NODE_140431_length_250_cov_0.870056_g138858_i0	PRJNA799842	140431	250	0.870056	2.17514	Pseudomonadati	3379134	Bacteria	Bacteria	71.6	1.13e-12	NR	OGP39698.1	1797821	g138858	i0	91.7	5.208	36	3	43.2	0	108	1	90	125	OGP39698.1 MAG: hypothetical protein A2X98_09850 [Deltaproteobacteria bacterium GWC2_66_88]	diamond	1302	71.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium GWC2_66_88
30125992	30125992	PRJNA799842_P_NODE_180132_length_243_cov_0.905882_g178559_i0	PRJNA799842	180132	243	0.905882	2.20129326	Actinomycetota	201174	Bacteria	Bacteria	73.9	3.77e-13	NR	OLC74527.1	1805121	g178559	i0	53.6	3.66666666666667	69	31	85.2	1	208	2	429	496	OLC74527.1 MAG: hypothetical protein AUH83_09655 [Deltaproteobacteria bacterium 13_1_40CM_4_68_19]	diamond	891	73.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium 13_1_40CM_4_68_19
30243724	30243724	PRJNA799842_P_NODE_182092_length_242_cov_0.911243_g180519_i0	PRJNA799842	182092	242	0.911243	2.20520806	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4	2013754	Bacteria	Bacteria	55.8	4.53e-7	NR	PKN11468.1	2013754	g180519	i0	69.4	0.446280991735537	36	11	44.6	0	108	1	1	36	PKN11468.1 MAG: ribonuclease HII [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4]	diamond	108	55.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4
31096557	31096557	PRJNA799842_P_NODE_146575_length_249_cov_0.875000_g145002_i0	PRJNA799842	146575	249	0.875	2.17875	Deltaproteobacteria bacterium CG	2026735	Bacteria	Bacteria	128	8.88e-35	NR	PIV20162.1	1973969	g145002	i0	67.1	0.987951807228916	82	27	98.8	0	248	3	33	114	PIV20162.1 MAG: hypothetical protein COS40_14010 [Deltaproteobacteria bacterium CG03_land_8_20_14_0_80_45_14]	diamond	246	128	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium CG03_land_8_20_14_0_80_45_14
31950497	31950497	PRJNA799842_P_NODE_177717_length_243_cov_0.905882_g176144_i0	PRJNA799842	177717	243	0.905882	2.20129326	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4	2013754	Bacteria	Bacteria	130	2.8999999999999997e-35	NR	PKN12723.1	2013754	g176144	i0	93.9	0.814814814814815	66	4	81.5	0	241	44	195	260	PKN12723.1 MAG: IclR family transcriptional regulator [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4]	diamond	198	130	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4
32212801	32212801	PRJNA799842_P_NODE_147038_length_249_cov_0.875000_g145465_i0	PRJNA799842	147038	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	64.3	8.11e-10	NR	KRT71726.1	1640514	g145465	i0	76.2	4.95180722891566	42	10	50.6	0	124	249	3	44	KRT71726.1 MAG: ABC transporter-like protein, antibiotic transport system ATP-binding protein [Deltaproteobacteria bacterium CSP1-8]	diamond	1233	64.7	0.993817619783617	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium CSP1-8

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