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

14 rows where bioproject = "PRJNA560932", 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
1820182	1820182	PRJNA560932_P_NODE_16282_length_435_cov_1.629834_g15926_i0	PRJNA560932	16282	435	1.629834	7.0897779	Bradymonas sediminis	1548548	Bacteria	Bacteria	52.8	0.042	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g15926	i0	100	0.064367816091954	28	0	6	0	316	343	2923192	2923165	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	28	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
26966414	26966414	PRJNA560932_P_NODE_63562_length_243_cov_0.905882_g63206_i0	PRJNA560932	63562	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	50.8	5.29e-5	NR	OGQ89419.1	1797895	g63206	i0	41.2	1.25925925925926	51	26	63	2	242	90	1129	1175	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	306	50.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
28103532	28103532	PRJNA560932_P_NODE_34745_length_308_cov_1.374468_g34389_i0	PRJNA560932	34745	308	1.374468	4.23336144	Bacteria	2	Bacteria	Bacteria	88.2	9.17e-18	NR	OGQ89419.1	1797895	g34389	i0	43.2	1.85064935064935	95	50	92.5	2	292	8	1130	1220	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	570	88.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
28261385	28261385	PRJNA560932_P_NODE_56146_length_248_cov_1.480000_g55790_i0	PRJNA560932	56146	248	1.48	3.6704	Bradymonas	1779136	Bacteria	Bacteria	89.7	9.51e-20	NR	WP_204355067.1	1548548	g55790	i0	61.2	4.16129032258065	67	25	81	1	48	248	35	100	WP_204355067.1 CDP-alcohol phosphatidyltransferase family protein [Bradymonas sediminis]	diamond	1032	89.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
28608899	28608899	PRJNA560932_P_NODE_38567_length_293_cov_0.895455_g38211_i0	PRJNA560932	38567	293	0.895455	2.62368315	root	1	Root_unresolved	Root_unresolved	68.2	8.1e-11	NR	OGQ89419.1	1797895	g38211	i0	35.8	3.35836177474403	81	51	82.9	1	29	271	1185	1264	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	984	68.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
28672172	28672172	PRJNA560932_P_NODE_54267_length_250_cov_0.870056_g53911_i0	PRJNA560932	54267	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	65.1	5.45e-10	NR	OGQ89419.1	1797895	g53911	i0	38	1.896	79	46	94.8	1	248	12	1190	1265	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	474	65.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
29177409	29177409	PRJNA560932_P_NODE_45609_length_271_cov_0.944444_g45253_i0	PRJNA560932	45609	271	0.944444	2.55944324	Bacteria	2	Bacteria	Bacteria	48.1	6.47e-4	NR	OIP32185.1	1805126	g45253	i0	37	2.39114391143911	81	41	78.6	4	48	260	498	578	OIP32185.1 MAG: hypothetical protein AUK47_20995, partial [Deltaproteobacteria bacterium CG2_30_63_29]	diamond	648	48.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG2_30_63_29
29587355	29587355	PRJNA560932_P_NODE_27050_length_344_cov_2.225092_g26694_i0	PRJNA560932	27050	344	2.225092	7.65431648	Bacteria	2	Bacteria	Bacteria	77.4	8.77e-14	NR	OGQ89419.1	1797895	g26694	i0	39.4	1.72674418604651	99	55	84.6	3	31	321	1187	1282	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	594	77.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
30472271	30472271	PRJNA560932_P_NODE_60713_length_245_cov_0.895349_g60357_i0	PRJNA560932	60713	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	66.2	2.05e-10	NR	OGQ89419.1	1797895	g60357	i0	41	1.91020408163265	78	44	94.3	2	231	1	1155	1231	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	468	66.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
31072529	31072529	PRJNA560932_P_NODE_27055_length_344_cov_2.114391_g26699_i0	PRJNA560932	27055	344	2.114391	7.27350504	Myxococcota	2818505	Bacteria	Bacteria	48.5	0.00111	NR	OIP32185.1	1805126	g26699	i0	63.6	3.43604651162791	33	12	28.8	0	343	245	280	312	OIP32185.1 MAG: hypothetical protein AUK47_20995, partial [Deltaproteobacteria bacterium CG2_30_63_29]	diamond	1182	48.9	0.991820040899796	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG2_30_63_29
32021251	32021251	PRJNA560932_P_NODE_17718_length_418_cov_1.115942_g17362_i0	PRJNA560932	17718	418	1.115942	4.66463756	Bacteria	2	Bacteria	Bacteria	101	7.07e-22	NR	OGQ89419.1	1797895	g17362	i0	38.7	1.96650717703349	137	74	96.9	4	418	14	1148	1276	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	822	101	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
32260665	32260665	PRJNA560932_P_NODE_23838_length_364_cov_0.955326_g23482_i0	PRJNA560932	23838	364	0.955326	3.47738664	Bradymonadaceae bacterium	2740543	Bacteria	Bacteria	79.7	1.68e-14	NR	MFB6372782.1	2740543	g23482	i0	43.9	0.807692307692308	98	51	80.8	2	3	296	1367	1460	MFB6372782.1 alpha-2-macroglobulin family protein [Bradymonadaceae bacterium]	diamond	294	79.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae		Bradymonadaceae bacterium
32496014	32496014	PRJNA560932_P_NODE_33239_length_314_cov_2.506224_g32883_i0	PRJNA560932	33239	314	2.506224	7.86954336	Myxococcota	2818505	Bacteria	Bacteria	112	6.3200000000000006e-27	NR	OGQ90744.1	1797895	g32883	i0	56.8	2.72292993630573	95	41	90.8	0	28	312	1	95	OGQ90744.1 MAG: hypothetical protein A2289_26095 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	855	112	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
32545386	32545386	PRJNA560932_P_NODE_28299_length_337_cov_4.814394_g27943_i0	PRJNA560932	28299	337	4.814394	16.22450778	Deltaproteobacteria bacterium CG2_3	2026735	Bacteria	Bacteria	121	4.66e-32	NR	OIP38195.1	1805126	g27943	i0	65.1	1.65578635014837	86	30	76.6	0	260	3	7	92	OIP38195.1 MAG: hypothetical protein AUK47_12410 [Deltaproteobacteria bacterium CG2_30_63_29]	diamond	558	121	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG2_30_63_29

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