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

12 rows where bioproject = "PRJNA533114", 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
27867229	27867229	PRJNA533114_P_NODE_47205_length_342_cov_0.925651_g46953_i0	PRJNA533114	47205	342	0.925651	3.16572642	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	51.6	7.99e-5	NR	MDP7438162.1	2024889	g46953	i0	50	0.754385964912281	42	20	36.8	1	181	56	274	314	MDP7438162.1 hypothetical protein [SAR324 cluster bacterium]	diamond	258	51.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
27962111	27962111	PRJNA533114_P_NODE_82305_length_268_cov_0.979487_g82053_i0	PRJNA533114	82305	268	0.979487	2.62502516	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	48.5	4.58e-4	NR	MCZ6472959.1	2024889	g82053	i0	32.1	0.940298507462687	84	53	94	2	257	6	321	400	MCZ6472959.1 diguanylate cyclase [SAR324 cluster bacterium]	diamond	252	48.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
28419274	28419274	PRJNA533114_P_NODE_100306_length_249_cov_0.875000_g100054_i0	PRJNA533114	100306	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	67.8	6.13e-11	NR	OGQ89419.1	1797895	g100054	i0	40.8	1.83132530120482	76	41	91.6	2	230	3	1148	1219	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	456	67.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
28498960	28498960	PRJNA533114_P_NODE_17007_length_548_cov_2.311579_g16758_i0	PRJNA533114	17007	548	2.311579	12.66745292	Deltaproteobacteria bacterium CG2_3	2026735	Bacteria	Bacteria	55.8	2.06e-5	NR	OIP32186.1	1805126	g16758	i0	50.9	0.301094890510949	55	19	25.7	2	8	148	535	589	OIP32186.1 MAG: hypothetical protein AUK47_21000 [Deltaproteobacteria bacterium CG2_30_63_29]	diamond	165	55.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG2_30_63_29
29698235	29698235	PRJNA533114_P_NODE_39230_length_370_cov_1.037037_g38978_i0	PRJNA533114	39230	370	1.037037	3.8370369	Persicimonas caeni	2292766	Bacteria	Bacteria	51.6	1.03e-4	NR	QDG54948.1	2292766	g38978	i0	33	1.32972972972973	103	55	82.7	4	325	20	130	219	QDG54948.1 hypothetical protein FIV42_23140 [Persicimonas caeni]	diamond	492	51.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
29808282	29808282	PRJNA533114_P_NODE_104111_length_247_cov_0.885057_g103859_i0	PRJNA533114	104111	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	63.2	2.6e-9	NR	OGQ89419.1	1797895	g103859	i0	44.4	1.74898785425101	72	38	87.4	2	247	32	1200	1269	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	432	63.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
29871615	29871615	PRJNA533114_P_NODE_23151_length_471_cov_1.957286_g22901_i0	PRJNA533114	23151	471	1.957286	9.21881706	Pseudomonadati	3379134	Bacteria	Bacteria	55.1	2.48e-6	NR	PIR21829.1	1973974	g22901	i0	62.7	3.02547770700637	51	18	32.5	1	8	160	81	130	PIR21829.1 MAG: 30S ribosomal protein S9 [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16]	diamond	1425	55.5	0.992792792792793	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16
30377451	30377451	PRJNA533114_P_NODE_66652_length_292_cov_2.972603_g66400_i0	PRJNA533114	66652	292	2.972603	8.68000076	Myxococcota	2818505	Bacteria	Bacteria	98.6	6.95e-22	NR	OGQ90744.1	1797895	g66400	i0	53.4	2.71232876712329	88	41	90.4	0	265	2	1	88	OGQ90744.1 MAG: hypothetical protein A2289_26095 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	792	98.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
30520008	30520008	PRJNA533114_P_NODE_49313_length_335_cov_1.553435_g49061_i0	PRJNA533114	49313	335	1.553435	5.20400725	Deltaproteobacteria bacterium CG2_3	2026735	Bacteria	Bacteria	57	1.08e-6	NR	OIP32185.1	1805126	g49061	i0	50.8	0.967164179104478	59	21	45.7	2	3	155	285	343	OIP32185.1 MAG: hypothetical protein AUK47_20995, partial [Deltaproteobacteria bacterium CG2_30_63_29]	diamond	324	57	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG2_30_63_29
31040833	31040833	PRJNA533114_P_NODE_44635_length_350_cov_1.111913_g44383_i0	PRJNA533114	44635	350	1.111913	3.8916955	Bacteria	2	Bacteria	Bacteria	141	5.219999999999999e-37	NR	PIU56392.1	1973971	g44383	i0	50	12.9257142857143	116	56	99.4	1	3	350	225	338	PIU56392.1 MAG: diaminopimelate decarboxylase, partial [Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_38_7]	diamond	4524	141	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_38_7
32132636	32132636	PRJNA533114_P_NODE_63018_length_300_cov_2.894273_g62766_i0	PRJNA533114	63018	300	2.894273	8.682819	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	50.4	1.38e-4	NR	PKN54365.1	2013741	g62766	i0	44.9	0.88	49	26	49	1	113	259	343	390	PKN54365.1 MAG: hypothetical protein CVU56_26920 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	264	50.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
32354279	32354279	PRJNA533114_P_NODE_6719_length_857_cov_3.522959_g6528_i0	PRJNA533114	6719	857	3.522959	30.19175863	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	149	4.82e-38	NR	PKN55183.1	2013741	g6528	i0	36.6	1.77479579929988	265	133	83	6	9	719	175	432	PKN55183.1 MAG: hypothetical protein CVU56_22585 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	1521	149	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14

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