metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1139127" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1139127" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2307590	2307590	PRJNA1139127_P_NODE_28582_length_331_cov_1.472868_g28090_i0	PRJNA1139127	28582	331	1.472868	4.87519308	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	127	1.3399999999999998e-32	NR	HXD72674.1	2910147	g28090	i0	63.9	0.978851963746224	108	38	97.9	1	1	324	240	346	HXD72674.1 response regulator [Vicinamibacterales bacterium]	diamond	324	127	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
26943732	26943732	PRJNA1139127_P_NODE_29042_length_327_cov_2.098425_g28550_i0	PRJNA1139127	29042	327	2.098425	6.86184975	Candidatus Sulfopaludibacter sp. SbA4	2043165	Bacteria	Bacteria	58.5	2.89e-7	NR	SPF53868.1	2043165	g28550	i0	43.2	0.807339449541284	88	44	79.8	2	55	315	500	582	SPF53868.1 exported hypothetical protein [Candidatus Sulfopaludibacter sp. SbA4]	diamond	264	58.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Sulfopaludibacter	Candidatus Sulfopaludibacter sp. SbA4
27670822	27670822	PRJNA1139127_P_NODE_13524_length_558_cov_2.051546_g13045_i0	PRJNA1139127	13524	558	2.051546	11.44762668	Terriglobales bacterium	2282142	Bacteria	Bacteria	103	2.63e-22	NR	HEY7616644.1	2282142	g13045	i0	80	0.32258064516129	60	12	32.3	0	181	2	20	79	HEY7616644.1 IS5 family transposase [Terriglobales bacterium]	diamond	180	103	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
27670823	27670823	PRJNA1139127_P_NODE_28844_length_329_cov_1.218750_g28352_i0	PRJNA1139127	28844	329	1.21875	4.0096875	Blastocatellia bacterium	2052146	Bacteria	Bacteria	59.3	5.68e-8	NR	HEU0173011.1	2052146	g28352	i0	32.4	1.6322188449848	105	65	90.3	2	27	323	31	135	HEU0173011.1 tetratricopeptide repeat protein [Blastocatellia bacterium]	diamond	537	59.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
27986395	27986395	PRJNA1139127_P_NODE_46925_length_245_cov_0.906977_g46432_i0	PRJNA1139127	46925	245	0.906977	2.22209365	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	128	1.51e-35	NR	HJX27901.1	2651171	g46432	i0	79	0.991836734693878	81	16	99.2	1	243	1	70	149	HJX27901.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	243	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
28175644	28175644	PRJNA1139127_P_NODE_13846_length_550_cov_1.184486_g13366_i0	PRJNA1139127	13846	550	1.184486	6.514673	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	99.4	5.21e-21	NR	HWV95309.1	2910147	g13366	i0	72.1	1.11818181818182	68	19	37.1	0	22	225	301	368	HWV95309.1 FAD-dependent monooxygenase [Vicinamibacterales bacterium]	diamond	615	99.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
28396825	28396825	PRJNA1139127_P_NODE_43086_length_251_cov_0.870787_g42593_i0	PRJNA1139127	43086	251	0.870787	2.18567537	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	49.3	1.93e-4	NR	HXM67397.1	3069120	g42593	i0	39.2	0.884462151394422	74	40	82.5	2	209	3	135	208	HXM67397.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	222	49.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
29049056	29049056	PRJNA1139127_P_NODE_45488_length_247_cov_0.896552_g44995_i0	PRJNA1139127	45488	247	0.896552	2.21448344	Bacteria	2	Bacteria	Bacteria	110	5.38e-26	NR	PYU34715.1	1978231	g44995	i0	65.4	2.89068825910931	78	27	94.7	0	3	236	321	398	PYU34715.1 MAG: hypothetical protein DMG28_05005 [Acidobacteriota bacterium]	diamond	714	110	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30564623	30564623	PRJNA1139127_P_NODE_29233_length_326_cov_1.229249_g28741_i0	PRJNA1139127	29233	326	1.229249	4.00735174	Candidatus Acidiferrum	2817524	Bacteria	Bacteria	186	7.479999999999998e-56	NR	HXP44031.1	2952895	g28741	i0	88	2.76073619631902	100	12	92	0	324	25	49	148	HXP44031.1 zinc-binding alcohol dehydrogenase family protein [Candidatus Acidiferrales bacterium]	diamond	900	187	0.994652406417112	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
31112847	31112847	PRJNA1139127_P_NODE_10655_length_652_cov_1.307427_g10193_i0	PRJNA1139127	10655	652	1.307427	8.52442404	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	242	1.4e-74	NR	MBP7588269.1	2651171	g10193	i0	98.4	0.575153374233129	125	2	57.5	0	650	276	333	457	MBP7588269.1 amino acid permease [Thermoanaerobaculia bacterium]	diamond	375	242	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
31323283	31323283	PRJNA1139127_P_NODE_37355_length_275_cov_0.970297_g36862_i0	PRJNA1139127	37355	275	0.970297	2.66831675	Bacteria	2	Bacteria	Bacteria	114	3.6499999999999997e-31	NR	MSO56666.1	1978231	g36862	i0	79.2	3.15272727272727	72	15	78.5	0	38	253	1	72	MSO56666.1 hypothetical protein [Acidobacteriota bacterium]	diamond	867	114	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32188548	32188548	PRJNA1139127_P_NODE_29658_length_323_cov_1.240000_g29166_i0	PRJNA1139127	29658	323	1.24	4.0052	Terriglobales bacterium	2282142	Bacteria	Bacteria	154	4.8399999999999984e-43	NR	HUK23527.1	2282142	g29166	i0	69.8	8.82352941176471	106	32	98.5	0	4	321	129	234	HUK23527.1 glycosyltransferase family 1 protein [Terriglobales bacterium]	diamond	2850	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
32536716	32536716	PRJNA1139127_P_NODE_27579_length_339_cov_1.695489_g27087_i0	PRJNA1139127	27579	339	1.695489	5.74770771	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	68.2	1.27e-10	NR	MDQ3321205.1	1978231	g27087	i0	63.9	0.539823008849557	61	21	54	1	183	1	1	60	MDQ3321205.1 VWA domain-containing protein [Acidobacteriota bacterium]	diamond	183	68.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32568398	32568398	PRJNA1139127_P_NODE_44979_length_248_cov_0.891429_g44486_i0	PRJNA1139127	44979	248	0.891429	2.21074392	Chloracidobacterium sp.	2099375	Bacteria	Bacteria	45.1	0.00593	NR	MBO0858457.1	2099375	g44486	i0	31.7	0.725806451612903	60	38	69	1	13	183	87	146	MBO0858457.1 hypothetical protein [Chloracidobacterium sp.]	diamond	180	45.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium sp.

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