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

13 rows where analysis = "diamond", bioproject = "PRJNA561138" 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
6234182	6234182	PRJNA561138_P_NODE_10585_length_395_cov_1.512422_g10390_i0	PRJNA561138	10585	395	1.512422	5.9740669	Terriglobia bacterium	2081523	Bacteria	Bacteria	143	1.4e-36	NR	MBZ5723309.1	2081523	g10390	i0	59.7	4.0253164556962	134	51	99.5	2	395	3	458	591	MBZ5723309.1 amino acid adenylation domain-containing protein [Terriglobia bacterium]	diamond	1590	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
9473535	9473535	PRJNA561138_P_NODE_13888_length_351_cov_1.107914_g13693_i0	PRJNA561138	13888	351	1.107914	3.88877814	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	182	8.349999999999999e-56	NR	HSR49902.1	1978231	g13693	i0	74.8	12.7948717948718	115	29	98.3	0	345	1	28	142	HSR49902.1 peptidylprolyl isomerase [Acidobacteriota bacterium]	diamond	4491	182	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
11333778	11333778	PRJNA561138_P_NODE_23929_length_255_cov_1.439560_g23734_i0	PRJNA561138	23929	255	1.43956	3.670878	Holophaga sp.	2582906	Bacteria	Bacteria	121	5.07e-31	NR	HNX31324.1	2582906	g23734	i0	67.9	3.88235294117647	84	27	98.8	0	255	4	207	290	HNX31324.1 AmmeMemoRadiSam system radical SAM enzyme [Holophaga sp.]	diamond	990	121	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	Holophaga sp.
26857950	26857950	PRJNA561138_P_NODE_27441_length_246_cov_0.890173_g27246_i0	PRJNA561138	27441	246	0.890173	2.18982558	Terriglobales bacterium	2282142	Bacteria	Bacteria	61.6	2.55e-9	NR	HEV2021009.1	2282142	g27246	i0	42	0.98780487804878	81	44	98.8	2	2	244	42	119	HEV2021009.1 hypothetical protein [Terriglobales bacterium]	diamond	243	61.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
27693537	27693537	PRJNA561138_P_NODE_19684_length_292_cov_1.054795_g19489_i0	PRJNA561138	19684	292	1.054795	3.0800014	Pseudomonadati	3379134	Bacteria	Bacteria	92.8	8.75e-21	NR	HJO04986.1	1978231	g19489	i0	68.2	1.37671232876712	66	21	67.8	0	199	2	1	66	HJO04986.1 class II aldolase/adducin family protein [Acidobacteriota bacterium]	diamond	402	92.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27742773	27742773	PRJNA561138_P_NODE_6804_length_476_cov_0.955335_g6610_i0	PRJNA561138	6804	476	0.955335	4.5473946	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	112	3.8599999999999998e-28	NR	TNF75821.1	1978231	g6610	i0	43.2	1.37394957983193	111	61	70	1	476	144	56	164	TNF75821.1 MAG: hypothetical protein EP299_05880 [Acidobacteriota bacterium]	diamond	654	112	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28815681	28815681	PRJNA561138_P_NODE_19228_length_296_cov_1.269058_g19033_i0	PRJNA561138	19228	296	1.269058	3.75641168	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	167	1.02e-46	NR	MCB1055391.1	1978231	g19033	i0	75.5	8.85810810810811	98	24	99.3	0	296	3	65	162	MCB1055391.1 hydroxylamine oxidoreductase [Acidobacteriota bacterium]	diamond	2622	167	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29195035	29195035	PRJNA561138_P_NODE_10149_length_402_cov_1.170213_g9954_i0	PRJNA561138	10149	402	1.170213	4.70425626	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	45.8	0.00471	NR	MCJ7440672.1	2699758	g9954	i0	29.2	0.664179104477612	89	63	66.4	0	6	272	29	117	MCJ7440672.1 hypothetical protein [Thermoanaerobaculaceae bacterium]	diamond	267	45.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
29429573	29429573	PRJNA561138_P_NODE_9289_length_415_cov_1.350877_g9094_i0	PRJNA561138	9289	415	1.350877	5.60613955	Pseudomonadati	3379134	Bacteria	Bacteria	129	8.509999999999999e-34	NR	MEM7349892.1	1978231	g9094	i0	69.2	1.98795180722892	91	28	65.8	0	413	141	170	260	MEM7349892.1 SDR family NAD(P)-dependent oxidoreductase [Acidobacteriota bacterium]	diamond	825	130	0.992307692307692	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29826229	29826229	PRJNA561138_P_NODE_6231_length_496_cov_1.274232_g6037_i0	PRJNA561138	6231	496	1.274232	6.32019072	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	105	1.2199999999999999e-23	NR	MEO7972193.1	2651171	g6037	i0	71	2.52822580645161	69	20	41.7	0	56	262	257	325	MEO7972193.1 HNH endonuclease [Thermoanaerobaculia bacterium]	diamond	1254	105	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
30647533	30647533	PRJNA561138_P_NODE_29873_length_241_cov_0.916667_g29678_i0	PRJNA561138	29873	241	0.916667	2.20916747	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	63.5	1.52e-9	NR	MCU0250277.1	2910147	g29678	i0	50	1.19502074688797	50	25	62.2	0	4	153	307	356	MCU0250277.1 DUF481 domain-containing protein [Vicinamibacterales bacterium]	diamond	288	63.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31090124	31090124	PRJNA561138_P_NODE_28875_length_243_cov_0.905882_g28680_i0	PRJNA561138	28875	243	0.905882	2.20129326	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	43.1	0.0258	NR	HEX8776066.1	2283092	g28680	i0	37.9	0.814814814814815	66	39	79	1	196	5	105	170	HEX8776066.1 lipopolysaccharide heptosyltransferase I [Pyrinomonadaceae bacterium]	diamond	198	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32622123	32622123	PRJNA561138_P_NODE_13420_length_357_cov_1.084507_g13225_i0	PRJNA561138	13420	357	1.084507	3.87168999	Acidobacteriota	57723	Bacteria	Bacteria	115	1.31e-28	NR	MEX2300041.1	2026791	g13225	i0	46.2	2.95798319327731	119	64	100	0	357	1	74	192	MEX2300041.1 alpha/beta hydrolase [Bryobacterales bacterium]	diamond	1056	115	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium

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