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

9 rows where bioproject = "PRJNA315399", 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_order	tax_family	tax_genus	tax_species
2933382	2933382	PRJNA315399_P_NODE_357463_length_167_cov_36.076923_g357015_i0	PRJNA315399	357463	167	36.076923	60.24846141	Persicimonas caeni	2292766	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g357015	i0	96.875	0.383233532934132	32	0	19	1	63	94	4574589	4574559	Persicimonas caeni strain YN101 chromosome	blastn	64	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
15684101	15684101	PRJNA315399_P_NODE_150793_length_189_cov_2.282895_g150345_i0	PRJNA315399	150793	189	2.282895	4.31467155	Pseudomonadati	3379134	Bacteria	Bacteria	99.4	2.08e-22	NR	WP_163297993.1	1765737	g150345	i0	86.8	14.5238095238095	53	7	84.1	0	188	30	496	548	WP_163297993.1 response regulator [Dissulfurirhabdus thermomarina]	diamond	2745	99.8	0.995991983967936	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Dissulfurirhabdaceae	Dissulfurirhabdus	Dissulfurirhabdus thermomarina
20192682	20192682	PRJNA315399_S_NODE_139856_length_164_cov_1.496063_g139655_i0	PRJNA315399	139856	164	1.496063	2.45354332	delta/epsilon subdivisions	68525	Bacteria	Bacteria	106	1.04e-18	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g139655	i0	80.282	43.8536585365854	142	26	86	2	3	143	1993073	1993213	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	7192	106	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
27028627	27028627	PRJNA315399_P_NODE_45122_length_244_cov_4.961353_g44674_i0	PRJNA315399	45122	244	4.961353	12.10570132	root	1	Root_unresolved	Root_unresolved	80.1	2.16e-15	NR	OQB73568.1	1852867	g44674	i0	81.6	1.69672131147541	49	9	60.2	0	14	160	334	382	OQB73568.1 MAG: hypothetical protein BWX92_03322 [Deltaproteobacteria bacterium ADurb.Bin135]	diamond	414	80.5	0.995031055900621	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin135
29979643	29979643	PRJNA315399_S_NODE_162811_length_157_cov_9.408333_g162610_i0	PRJNA315399	162811	157	9.408333	14.77108281	Deltaproteobacteria bacterium ADurb.Bin135	1852867	Bacteria	Bacteria	69.7	3.4e-12	NR	OQB73565.1	1852867	g162610	i0	68.9	0.859872611464968	45	14	86	0	21	155	155	199	OQB73565.1 MAG: hypothetical protein BWX92_03319 [Deltaproteobacteria bacterium ADurb.Bin135]	diamond	135	69.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin135
31798418	31798418	PRJNA315399_P_NODE_275637_length_180_cov_3.349650_g275189_i0	PRJNA315399	275637	180	3.34965	6.02937	Myxococcota	2818505	Bacteria	Bacteria	53.5	2.29e-6	NR	PKN55803.1	2013741	g275189	i0	92.6	1.8	27	2	45	0	178	98	267	293	PKN55803.1 MAG: fructose-bisphosphate aldolase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	324	53.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
32305164	32305164	PRJNA315399_P_NODE_359059_length_167_cov_6.115385_g358611_i0	PRJNA315399	359059	167	6.115385	10.21269295	Campylobacterota	29547	Bacteria	Bacteria	52.4	2.28e-6	NR	PKN14846.1	2013752	g358611	i0	85.7	1.0059880239521	28	4	50.3	0	89	6	72	99	PKN14846.1 MAG: DedA family protein [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-24]	diamond	168	52.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-24
32382359	32382359	PRJNA315399_P_NODE_428159_length_158_cov_8.173554_g427711_i0	PRJNA315399	428159	158	8.173554	12.91421532	Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_	2026735	Bacteria	Bacteria	60.8	3.32e-10	NR	PIR23197.1	1973974	g427711	i0	57.1	1.06329113924051	56	13	85.4	1	153	19	57	112	PIR23197.1 MAG: sulfurtransferase [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16]	diamond	168	60.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16
32792283	32792283	PRJNA315399_P_NODE_263000_length_181_cov_2.673611_g262552_i0	PRJNA315399	263000	181	2.673611	4.83923591	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15	1797895	Bacteria	Bacteria	63.9	3.3e-11	NR	OGQ81088.1	1797895	g262552	i0	69.4	0.812154696132597	49	15	81.2	0	152	6	1	49	OGQ81088.1 MAG: conjugal transfer protein TraR [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	147	63.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15

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