metadata: contig_metadata: 11 rows where bioproject = "PRJNA340009", tax_clade = "delta/epsilon subdivisions" and tax

11 rows where bioproject = "PRJNA340009", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

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
22068819	22068819	PRJNA340009_P_NODE_54978_length_176_cov_1.566929_g54671_i0	PRJNA340009	54978	176	1.566929	2.75779504	uncultured delta proteobacterium	34034	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2874254016\|emb\|OY970341.1\|	34034	g54671	i0	100	0.159090909090909	28	0	16	0	5	32	3987185	3987158	MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
29113091	29113091	PRJNA340009_P_NODE_20968_length_264_cov_12.023256_g20661_i0	PRJNA340009	20968	264	12.023256	31.74139584	Bacteria	2	Bacteria	Bacteria	68.6	2.71e-11	NR	OGQ18306.1	1797858	g20661	i0	64.6	2.72727272727273	48	17	54.5	0	146	3	3	50	OGQ18306.1 MAG: epimerase [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_11]	diamond	720	68.9	0.995645863570392	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_11
29411454	29411454	PRJNA340009_P_NODE_62589_length_167_cov_0.864407_g62282_i0	PRJNA340009	62589	167	0.864407	1.44355969	Deltaproteobacteria bacterium ADurb.Bin135	1852867	Bacteria	Bacteria	70.1	2.98e-12	NR	OQB75650.1	1852867	g62282	i0	56.4	0.988023952095808	55	24	98.8	0	166	2	524	578	OQB75650.1 MAG: hypothetical protein BWX92_02525 [Deltaproteobacteria bacterium ADurb.Bin135]	diamond	165	70.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium ADurb.Bin135
29649371	29649371	PRJNA340009_P_NODE_65570_length_165_cov_7.482759_g65263_i0	PRJNA340009	65570	165	7.482759	12.34655235	Myxococcota	2818505	Bacteria	Bacteria	112	1.09e-27	NR	OGQ06909.1	1797859	g65263	i0	90.6	18.4363636363636	53	5	96.4	0	4	162	318	370	OGQ06909.1 MAG: crotonyl-CoA carboxylase/reductase [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_28]	diamond	3042	113	0.991150442477876	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_28
30218259	30218259	PRJNA340009_P_NODE_78692_length_157_cov_198.064815_g78385_i0	PRJNA340009	78692	157	198.064815	310.96175955	Myxococcota	2818505	Bacteria	Bacteria	71.2	5.97e-13	NR	PIR24599.1	1973973	g78385	i0	73.5	2.82802547770701	49	13	93.6	0	155	9	144	192	PIR24599.1 MAG: RNA polymerase subunit sigma-70 [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23]	diamond	444	71.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23
30359541	30359541	PRJNA340009_P_NODE_27292_length_236_cov_3.481283_g26985_i0	PRJNA340009	27292	236	3.481283	8.21582788	Deltaproteobacteria bacterium 21-66-5	1970506	Bacteria	Bacteria	63.5	9.64e-11	NR	OYV74892.1	1970506	g26985	i0	66.7	1.14406779661017	48	16	61	0	3	146	70	117	OYV74892.1 MAG: hypothetical protein B7Z74_01665 [Deltaproteobacteria bacterium 21-66-5]	diamond	270	63.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium 21-66-5
31085803	31085803	PRJNA340009_P_NODE_49215_length_184_cov_44.288889_g48908_i0	PRJNA340009	49215	184	44.288889	81.49155576	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21	2013749	Bacteria	Bacteria	72.4	5.88e-13	NR	PKN28324.1	2013749	g48908	i0	66.1	0.91304347826087	56	18	91.3	1	5	172	134	188	PKN28324.1 MAG: biotin carboxylase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21]	diamond	168	72.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21
31102852	31102852	PRJNA340009_P_NODE_27315_length_236_cov_2.796791_g27008_i0	PRJNA340009	27315	236	2.796791	6.60042676	Thermotogota	200918	Bacteria	Bacteria	42.7	0.0213	NR	ADI18416.1	710836	g27008	i0	41.8	1.33474576271186	55	30	67.4	1	4	162	72	126	ADI18416.1 hypothetical protein [uncultured delta proteobacterium HF4000_08N17]	diamond	315	42.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium HF4000_08N17
31117087	31117087	PRJNA340009_P_NODE_49555_length_184_cov_1.814815_g49248_i0	PRJNA340009	49555	184	1.814815	3.3392596	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	43.5	0.0088	NR	MEY8217475.1	2024889	g49248	i0	44.6	1.72826086956522	56	24	81.5	2	3	152	81	135	MEY8217475.1 DUF3987 domain-containing protein [SAR324 cluster bacterium]	diamond	318	43.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	SAR324 cluster bacterium
31148556	31148556	PRJNA340009_P_NODE_76835_length_161_cov_0.910714_g76528_i0	PRJNA340009	76835	161	0.910714	1.46624954	Deltaproteobacteria bacterium RBG_16_55_12	1797844	Bacteria	Bacteria	70.5	1.55e-12	NR	OGP99209.1	1797844	g76528	i0	90	0.745341614906832	40	4	74.5	0	3	122	300	339	OGP99209.1 MAG: hypothetical protein A2W10_09000 [Deltaproteobacteria bacterium RBG_16_55_12]	diamond	120	70.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RBG_16_55_12
32887132	32887132	PRJNA340009_P_NODE_35560_length_211_cov_3.456790_g35253_i0	PRJNA340009	35560	211	3.45679	7.2938269	Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_	2026735	Bacteria	Bacteria	63.2	1.27e-9	NR	PIR23695.1	1973974	g35253	i0	43.8	3.21327014218009	73	30	88.2	2	24	209	116	188	PIR23695.1 MAG: hypothetical protein COV44_01335 [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16]	diamond	678	63.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16

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