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

14 rows where bioproject = "PRJNA1120060", 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
26784801	26784801	PRJNA1120060_P_NODE_3078881_length_237_cov_2.573171_g3060780_i0	PRJNA1120060	3078881	237	2.573171	6.09841527	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	40.8	0.0466	NR	MEC8684835.1	2024889	g3060780	i0	34.9	0.544303797468354	43	28	54.4	0	185	57	43	85	MEC8684835.1 EamA family transporter [SAR324 cluster bacterium]	diamond	129	40.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
26784877	26784877	PRJNA1120060_P_NODE_3198001_length_231_cov_4.398734_g3179894_i0	PRJNA1120060	3198001	231	4.398734	10.16107554	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	55.8	7.64e-7	NR	MBA2662192.1	2946527	g3179894	i0	36.8	0.987012987012987	76	48	98.7	0	3	230	477	552	MBA2662192.1 transglycosylase domain-containing protein [Lujinxingiaceae bacterium]	diamond	228	55.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae		Lujinxingiaceae bacterium
27100083	27100083	PRJNA1120060_P_NODE_1713442_length_284_cov_3.127962_g1695436_i0	PRJNA1120060	1713442	284	3.127962	8.88341208	Olavius algarvensis Delta 1 endosymbiont	334747	Bacteria	Bacteria	41.6	0.0102	NR	CAB1079782.1	334747	g1695436	i0	45.2	0.327464788732394	31	17	32.7	0	185	93	1	31	CAB1079782.1 hypothetical protein D1AOALGA4SA_7487, partial [Olavius algarvensis Delta 1 endosymbiont]	diamond	93	41.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Olavius algarvensis Delta 1 endosymbiont
27195629	27195629	PRJNA1120060_P_NODE_2875062_length_244_cov_2.011696_g2856973_i0	PRJNA1120060	2875062	244	2.011696	4.90853824	Bradymonas sediminis	1548548	Bacteria	Bacteria	91.3	3.08e-19	NR	WP_111331749.1	1548548	g2856973	i0	46.3	1.00819672131148	82	43	99.6	1	1	243	184	265	WP_111331749.1 membrane protein insertase YidC [Bradymonas sediminis]	diamond	246	91.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
27691474	27691474	PRJNA1120060_P_NODE_3490704_length_207_cov_8.731343_g3472578_i0	PRJNA1120060	3490704	207	8.731343	18.07388001	Bacteria	2	Bacteria	Bacteria	42	0.0433	NR	OGQ58517.1	1797881	g3472578	i0	36.2	1.68115942028985	58	37	84.1	0	175	2	156	213	OGQ58517.1 MAG: ATP-dependent DNA helicase RecG, partial [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_50_16]	diamond	348	42	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_50_16
27796029	27796029	PRJNA1120060_P_NODE_279124_length_427_cov_5.621469_g262117_i0	PRJNA1120060	279124	427	5.621469	24.00367263	Deltaproteobacteria bacterium RBG_16_47_11	1797838	Bacteria	Bacteria	65.5	2.44e-10	NR	OGP94167.1	1797838	g262117	i0	57.6	0.414519906323185	59	25	41.5	0	202	26	18	76	OGP94167.1 MAG: hypothetical protein A2157_16100, partial [Deltaproteobacteria bacterium RBG_16_47_11]	diamond	177	65.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RBG_16_47_11
28964568	28964568	PRJNA1120060_P_NODE_3378208_length_218_cov_6.186207_g3360089_i0	PRJNA1120060	3378208	218	6.186207	13.48593126	Persicimonas caeni	2292766	Bacteria	Bacteria	81.3	1.72e-16	NR	WP_141200429.1	2292766	g3360089	i0	70.2	1.56880733944954	57	17	78.4	0	216	46	207	263	WP_141200429.1 alpha/beta fold hydrolase [Persicimonas caeni]	diamond	342	81.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
30196012	30196012	PRJNA1120060_P_NODE_539192_length_359_cov_2.500000_g521534_i0	PRJNA1120060	539192	359	2.5	8.975	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	43.9	0.0495	NR	NMC62855.1	2024889	g521534	i0	44.7	0.392757660167131	47	24	37.6	1	27	161	271	317	NMC62855.1 hypothetical protein [SAR324 cluster bacterium]	diamond	141	43.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
30480526	30480526	PRJNA1120060_P_NODE_3470893_length_209_cov_6.102941_g3452767_i0	PRJNA1120060	3470893	209	6.102941	12.75514669	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-15	2013742	Bacteria	Bacteria	42	0.0454	NR	PKN62238.1	2013742	g3452767	i0	40.4	0.746411483253589	52	27	74.6	1	187	32	79	126	PKN62238.1 MAG: hypothetical protein CVU57_25155 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-15]	diamond	156	42	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-15
30574504	30574504	PRJNA1120060_P_NODE_2741553_length_247_cov_2.977011_g2723469_i0	PRJNA1120060	2741553	247	2.977011	7.35321717	Deltaproteobacteria bacterium RIFCSPHIGHO2_	2026735	Bacteria	Bacteria	43.9	0.0129	NR	OGQ22542.1	1797862	g2723469	i0	43.8	0.777327935222672	64	31	75.3	4	230	45	31	91	OGQ22542.1 MAG: hypothetical protein A3C46_07075 [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_44_16]	diamond	192	43.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_44_16
31427310	31427310	PRJNA1120060_P_NODE_1718756_length_284_cov_2.189573_g1700750_i0	PRJNA1120060	1718756	284	2.189573	6.21838732	Bradymonadaceae bacterium	2740543	Bacteria	Bacteria	59.3	3.65e-8	NR	MFU8804581.1	2740543	g1700750	i0	90	0.950704225352113	30	3	31.7	0	1	90	181	210	MFU8804581.1 penicillin-binding protein activator LpoB [Bradymonadaceae bacterium]	diamond	270	59.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae		Bradymonadaceae bacterium
31554998	31554998	PRJNA1120060_P_NODE_2998896_length_241_cov_2.333333_g2980799_i0	PRJNA1120060	2998896	241	2.333333	5.62333253	Bradymonas sediminis	1548548	Bacteria	Bacteria	92.8	1.7e-21	NR	WP_111333560.1	1548548	g2980799	i0	51.3	0.995850622406639	80	39	99.6	0	2	241	96	175	WP_111333560.1 GNAT family N-acetyltransferase [Bradymonas sediminis]	diamond	240	92.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
31933378	31933378	PRJNA1120060_P_NODE_1730837_length_284_cov_0.848341_g1712831_i0	PRJNA1120060	1730837	284	0.848341	2.40928844	Candidatus Zymogenaceae bacterium	2844909	Bacteria	Bacteria	53.1	6.31e-6	NR	MBN1881542.1	2844909	g1712831	i0	40.3	2.31338028169014	62	37	65.5	0	200	15	67	128	MBN1881542.1 reverse transcriptase-like protein [Candidatus Zymogenaceae bacterium]	diamond	657	53.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Candidatus Zymogeniales	Candidatus Zymogenaceae		Candidatus Zymogenaceae bacterium
31965604	31965604	PRJNA1120060_P_NODE_2658278_length_249_cov_3.215909_g2640197_i0	PRJNA1120060	2658278	249	3.215909	8.00761341	Deltaproteobacteria bacterium CG2_3	2026735	Bacteria	Bacteria	43.1	0.029	NR	OIP33881.1	1805127	g2640197	i0	43.6	1.12048192771084	39	22	47	0	213	97	355	393	OIP33881.1 MAG: hypothetical protein AUK27_09165 [Deltaproteobacteria bacterium CG2_30_66_27]	diamond	279	43.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG2_30_66_27

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