metadata: contig_metadata: 17 rows where bioproject = "PRJNA814235" and tax

17 rows where bioproject = "PRJNA814235" 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
1226471	1226471	PRJNA814235_P_NODE_184481_length_151_cov_4.114035_g183086_i0	PRJNA814235	184481	151	4.114035	6.21219285	Bacillota	1239	Bacteria	Bacteria	111	2e-20	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g183086	i0	81.579	184.523178807947	152	13	91	4	4	141	1541568	1541718	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	27863	111	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
2093689	2093689	PRJNA814235_P_NODE_58302_length_249_cov_2.632075_g56908_i0	PRJNA814235	58302	249	2.632075	6.55386675	Persicimonas caeni	2292766	Bacteria	Bacteria	169	2.1399999999999996e-37	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g56908	i0	79.253	3.92369477911647	241	38	95	9	1	237	7928360	7928592	Persicimonas caeni strain YN101 chromosome	blastn	977	169	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
3367003	3367003	PRJNA814235_P_NODE_15303_length_487_cov_40.164444_g14001_i0	PRJNA814235	15303	487	40.164444	195.60084228	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	414	5.26e-111	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g14001	i0	82.258	139.989733059548	496	72	100	13	1	487	14390	14878	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	68175	414	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
3367954	3367954	PRJNA814235_P_NODE_195843_length_151_cov_1.000000_g194448_i0	PRJNA814235	195843	151	1	1.51	uncultured delta proteobacterium	34034	Bacteria	Bacteria	237	3.17e-58	NTclustered	gi\|927353694\|gb\|KT322228.1\|	34034	g194448	i0	94.805	73.6225165562914	154	5	100	1	1	151	178	25	Uncultured delta proteobacterium clone TGR_WLFZ-48 16S ribosomal RNA gene, partial sequence	blastn	11117	237	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
9745499	9745499	PRJNA814235_P_NODE_33648_length_329_cov_4.452055_g32260_i0	PRJNA814235	33648	329	4.452055	14.64726095	uncultured delta proteobacterium	34034	Bacteria	Bacteria	544	4.1899999999999996e-150	NTclustered	gi\|339646456\|gb\|JN038845.1\|	34034	g32260	i0	96.636	99.0182370820669	327	11	99	0	1	327	1	327	Uncultured delta proteobacterium clone P-R58 16S ribosomal RNA gene, partial sequence	blastn	32577	544	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
23769653	23769653	PRJNA814235_P_NODE_202319_length_150_cov_1.716814_g200924_i0	PRJNA814235	202319	150	1.716814	2.575221	Bradymonas sediminis	1548548	Bacteria	Bacteria	132	1.53e-26	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g200924	i0	90.099	3.62	101	10	67	0	1	101	3700264	3700364	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	543	132	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
26990827	26990827	PRJNA814235_P_NODE_109962_length_203_cov_2.072289_g108567_i0	PRJNA814235	109962	203	2.072289	4.20674667	Deltaproteobacteria bacterium Smac51	2946587	Bacteria	Bacteria	56.2	3.77e-7	NR	UQZ91181.1	2946587	g108567	i0	88	0.369458128078818	25	3	36.9	0	128	202	416	440	UQZ91181.1 CoA-disulfide reductase [Deltaproteobacteria bacterium Smac51]	diamond	75	56.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium Smac51
27220855	27220855	PRJNA814235_P_NODE_100902_length_203_cov_2.403614_g99507_i0	PRJNA814235	100902	203	2.403614	4.87933642	Myxococcota	2818505	Bacteria	Bacteria	46.6	9.63e-4	NR	OQB11796.1	1852869	g99507	i0	83.3	2.82266009852217	24	4	35.5	0	130	201	322	345	OQB11796.1 MAG: Outer membrane porin F precursor [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	573	46.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin207
27906932	27906932	PRJNA814235_P_NODE_112525_length_203_cov_2.006024_g111130_i0	PRJNA814235	112525	203	2.006024	4.07222872	Deltaproteobacteria bacterium RBG_16_71_12	1797848	Bacteria	Bacteria	42	0.0423	NR	OGQ24223.1	1797848	g111130	i0	76	0.369458128078818	25	6	36.9	0	203	129	793	817	OGQ24223.1 MAG: hypothetical protein A2138_08225 [Deltaproteobacteria bacterium RBG_16_71_12]	diamond	75	42	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RBG_16_71_12
28380842	28380842	PRJNA814235_P_NODE_196406_length_150_cov_5.008850_g195011_i0	PRJNA814235	196406	150	5.00885	7.513275	Microvenator marinus	2600177	Bacteria	Bacteria	50.8	1.48e-5	NR	WP_146961089.1	2600177	g195011	i0	74.1	0.54	27	7	54	0	67	147	193	219	WP_146961089.1 MXAN_2562 family outer membrane beta-barrel protein [Microvenator marinus]	diamond	81	50.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
28421346	28421346	PRJNA814235_P_NODE_201106_length_150_cov_2.734513_g199711_i0	PRJNA814235	201106	150	2.734513	4.1017695	Myxococcota	2818505	Bacteria	Bacteria	45.4	0.0012	NR	PKN58301.1	2013741	g199711	i0	69.2	1.04	26	8	52	0	150	73	525	550	PKN58301.1 MAG: hypothetical protein CVU56_06570 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	156	45.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
28515922	28515922	PRJNA814235_P_NODE_117887_length_203_cov_1.843373_g116492_i0	PRJNA814235	117887	203	1.843373	3.74204719	Bacteria	2	Bacteria	Bacteria	46.6	9.67e-4	NR	OPL07327.1	1775671	g116492	i0	79.2	1.07881773399015	24	5	35.5	0	5	76	418	441	OPL07327.1 MAG: hypothetical protein AVO33_06050, partial [delta proteobacterium ML8_F1]	diamond	219	46.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				delta proteobacterium ML8_F1
28799774	28799774	PRJNA814235_P_NODE_106287_length_203_cov_2.180723_g104892_i0	PRJNA814235	106287	203	2.180723	4.42686769	Chloroflexota	200795	Bacteria	Bacteria	48.9	1.46e-4	NR	OGP62842.1	1797826	g104892	i0	91.7	4.25615763546798	24	2	35.5	0	74	3	392	415	OGP62842.1 MAG: potassium-transporting ATPase subunit KdpA [Deltaproteobacteria bacterium RBG_13_47_9]	diamond	864	48.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RBG_13_47_9
29936816	29936816	PRJNA814235_P_NODE_96231_length_203_cov_2.668675_g94836_i0	PRJNA814235	96231	203	2.668675	5.41741025	Myxococcota	2818505	Bacteria	Bacteria	48.5	1.97e-4	NR	SBW09278.1	34034	g94836	i0	92	0.738916256157635	25	2	36.9	0	202	128	180	204	SBW09278.1 exported hypothetical protein [uncultured delta proteobacterium]	diamond	150	48.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
31128301	31128301	PRJNA814235_P_NODE_197155_length_150_cov_4.132743_g195760_i0	PRJNA814235	197155	150	4.132743	6.1991145	Microvenator marinus	2600177	Bacteria	Bacteria	50.8	1.41e-5	NR	WP_249756198.1	2600177	g195760	i0	84	0.5	25	4	50	0	77	3	100	124	WP_249756198.1 pyridoxal phosphate-dependent aminotransferase [Microvenator marinus]	diamond	75	50.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
32457433	32457433	PRJNA814235_P_NODE_90659_length_203_cov_3.283133_g89264_i0	PRJNA814235	90659	203	3.283133	6.66475999	Microvenator marinus	2600177	Bacteria	Bacteria	52.4	8.69e-6	NR	WP_146958609.1	2600177	g89264	i0	95.8	0.354679802955665	24	1	35.5	0	201	130	159	182	WP_146958609.1 serine/threonine protein kinase [Microvenator marinus]	diamond	72	52.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
32615172	32615172	PRJNA814235_P_NODE_114920_length_203_cov_1.939759_g113525_i0	PRJNA814235	114920	203	1.939759	3.93771077	Deltaproteobacteria bacterium ADurb.Bin2	2026735	Bacteria	Bacteria	46.2	0.0013	NR	OQB15032.1	1852869	g113525	i0	80	0.369458128078818	25	5	36.9	0	2	76	31	55	OQB15032.1 MAG: Sodium/hydrogen exchanger family protein [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	75	46.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin207

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