metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA1180292" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA1180292" and tax_clade = "delta/epsilon subdivisions"

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
13071450	13071450	PRJNA1180292_P_NODE_10591_length_247_cov_0.896552_g10459_i0	PRJNA1180292	10591	247	0.896552	2.21448344	Olavius algarvensis Delta 4 endosymbiont	260707	Bacteria	Bacteria	139	8.58e-39	NR	CAD7844884.1	260707	g10459	i0	76.3	2.93927125506073	80	19	97.2	0	243	4	117	196	CAD7844884.1 MAG: Aliphatic amidase AmiE (EC 3.5.1.4) [Olavius algarvensis Delta 4 endosymbiont]	diamond	726	139	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Olavius algarvensis Delta 4 endosymbiont
27735945	27735945	PRJNA1180292_P_NODE_8764_length_251_cov_0.876404_g8632_i0	PRJNA1180292	8764	251	0.876404	2.19977404	Deltaproteobacteria bacterium RBG_13_61_14	1797834	Bacteria	Bacteria	87.8	4.51e-19	NR	OGP60028.1	1797834	g8632	i0	51.8	0.99203187250996006	83	39	98	1	247	2	106	188	OGP60028.1 MAG: hypothetical protein A2V67_08720 [Deltaproteobacteria bacterium RBG_13_61_14]	diamond	249	87.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RBG_13_61_14
28196632	28196632	PRJNA1180292_P_NODE_9026_length_251_cov_0.876404_g8894_i0	PRJNA1180292	9026	251	0.876404	2.19977404	Pseudomonadati	3379134	Bacteria	Bacteria	52	7.91e-6	NR	EFK06921.1	88274	g8894	i0	38.2	5.62948207171315	76	39	82.5	3	244	38	88	162	EFK06921.1 conserved hypothetical protein [delta proteobacterium NaphS2]	diamond	1413	52	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	delta proteobacterium NaphS2
28259732	28259732	PRJNA1180292_P_NODE_12546_length_243_cov_0.917647_g12414_i0	PRJNA1180292	12546	243	0.917647	2.22988221	Myxococcota	2818505	Bacteria	Bacteria	100	1.31e-22	NR	PIU52434.1	1973972	g12414	i0	89.1	2.71604938271605	55	6	67.9	0	165	1	1	55	PIU52434.1 MAG: ABC transporter permease, partial [Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_60_11]	diamond	660	100	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium CG07_land_8_20_14_0_80_60_11
28903625	28903625	PRJNA1180292_P_NODE_8488_length_252_cov_0.871508_g8356_i0	PRJNA1180292	8488	252	0.871508	2.19620016	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12	2013739	Bacteria	Bacteria	166	2.0599999999999994e-48	NR	PKN68465.1	2013739	g8356	i0	97.6	0.988095238095238	83	2	98.8	0	250	2	76	158	PKN68465.1 MAG: hypothetical protein CVU54_14855 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12]	diamond	249	166	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12
28967124	28967124	PRJNA1180292_P_NODE_10668_length_247_cov_0.896552_g10536_i0	PRJNA1180292	10668	247	0.896552	2.21448344	Deltaproteobacteria bacterium RBG_13_53_1	2026735	Bacteria	Bacteria	101	2.9399999999999998e-24	NR	OGP64406.1	1797831	g10536	i0	59.3	1.96761133603239	81	33	98.4	0	3	245	91	171	OGP64406.1 MAG: hypothetical protein A2170_03735 [Deltaproteobacteria bacterium RBG_13_53_10]	diamond	486	101	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RBG_13_53_10
29554265	29554265	PRJNA1180292_P_NODE_10750_length_247_cov_0.896552_g10618_i0	PRJNA1180292	10750	247	0.896552	2.21448344	Pseudomonadati	3379134	Bacteria	Bacteria	60.8	1.58e-8	NR	PKN52403.1	2013740	g10618	i0	77.8	3.03643724696356	36	8	43.7	0	3	110	736	771	PKN52403.1 MAG: hypothetical protein CVU55_07700 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-13]	diamond	750	61.2	0.993464052287582	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-13
30103656	30103656	PRJNA1180292_P_NODE_10972_length_246_cov_0.901734_g10840_i0	PRJNA1180292	10972	246	0.901734	2.21826564	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21	2013749	Bacteria	Bacteria	148	1.4200000000000001e-44	NR	PKN29410.1	2013749	g10840	i0	88.8	1.96341463414634	80	9	97.6	0	6	245	1	80	PKN29410.1 MAG: hypothetical protein CVU64_08295 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21]	diamond	483	148	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21
30388583	30388583	PRJNA1180292_P_NODE_8173_length_253_cov_0.866667_g8041_i0	PRJNA1180292	8173	253	0.866667	2.19266751	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15	1797895	Bacteria	Bacteria	140	2.4999999999999997e-36	NR	OGQ89023.1	1797895	g8041	i0	85.2	0.960474308300395	81	12	96	0	6	248	1178	1258	OGQ89023.1 MAG: hypothetical protein A2289_18585 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	243	140	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
31102264	31102264	PRJNA1180292_P_NODE_11195_length_246_cov_0.901734_g11063_i0	PRJNA1180292	11195	246	0.901734	2.21826564	Thermodesulfobacteriota	200940	Bacteria	Bacteria	151	1.89e-40	NR	PKN62654.1	2013742	g11063	i0	95.1	2	82	4	100	0	1	246	269	350	PKN62654.1 MAG: ATP-dependent RecD-like DNA helicase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-15]	diamond	492	151	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-15
32526188	32526188	PRJNA1180292_P_NODE_13039_length_242_cov_0.923077_g12907_i0	PRJNA1180292	13039	242	0.923077	2.23384634	Pseudomonadati	3379134	Bacteria	Bacteria	104	1.05e-25	NR	PKN51404.1	2013740	g12907	i0	61.3	5.93801652892562	80	31	99.2	0	3	242	129	208	PKN51404.1 MAG: hypothetical protein CVU55_12275 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-13]	diamond	1437	105	0.990476190476191	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-13
32758886	32758886	PRJNA1180292_P_NODE_9520_length_250_cov_0.881356_g9388_i0	PRJNA1180292	9520	250	0.881356	2.20339	Deltaproteobacteria bacterium SM23_61	1703399	Bacteria	Bacteria	117	6.49e-30	NR	KPK86405.1	1703399	g9388	i0	87.5	0.768	64	8	76.8	0	2	193	252	315	KPK86405.1 MAG: hypothetical protein AMJ94_18045 [Deltaproteobacteria bacterium SM23_61]	diamond	192	117	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium SM23_61
32821832	32821832	PRJNA1180292_P_NODE_12100_length_244_cov_0.912281_g11968_i0	PRJNA1180292	12100	244	0.912281	2.22596564	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12	2013739	Bacteria	Bacteria	167	1.3099999999999998e-47	NR	PKN70994.1	2013739	g11968	i0	97.5	0.995901639344262	81	2	99.6	0	2	244	101	181	PKN70994.1 MAG: flavocytochrome c [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12]	diamond	243	167	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12

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