metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1120586" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1120586" 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
1028457	1028457	PRJNA1120586_P_NODE_42921_length_233_cov_0.878049_g42730_i0	PRJNA1120586	42921	233	0.878049	2.04585417	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	55.8	7.89e-7	NR	HMH52650.1	3069120	g42730	i0	40.3	0.927038626609442	72	41	91.4	2	215	3	774	844	HMH52650.1 patatin-like phospholipase family protein [Candidatus Acidiferrum sp.]	diamond	216	55.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
13030131	13030131	PRJNA1120586_P_NODE_52311_length_226_cov_0.917197_g52120_i0	PRJNA1120586	52311	226	0.917197	2.07286522	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	68.6	3.79e-12	NR	HKH44688.1	2651171	g52120	i0	57.6	2.41592920353982	59	25	78.3	0	180	4	124	182	HKH44688.1 serine O-acetyltransferase [Thermoanaerobaculia bacterium]	diamond	546	68.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
19402116	19402116	PRJNA1120586_P_NODE_42676_length_233_cov_0.878049_g42485_i0	PRJNA1120586	42676	233	0.878049	2.04585417	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	132	4.24e-36	NR	HEX8265960.1	2283092	g42485	i0	91.4	1.80257510729614	70	6	90.1	0	23	232	58	127	HEX8265960.1 glucose-1-phosphate thymidylyltransferase RfbA [Pyrinomonadaceae bacterium]	diamond	420	132	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
20154833	20154833	PRJNA1120586_P_NODE_47416_length_229_cov_2.225000_g47225_i0	PRJNA1120586	47416	229	2.225	5.09525	Bacteria	2	Bacteria	Bacteria	99.8	2.77e-22	NR	ODS52930.1	1660160	g47225	i0	62	26.2270742358079	79	27	99.6	2	1	228	766	844	ODS52930.1 MAG: hypothetical protein ABS36_15875 [Acidobacteria bacterium SCN 69-37]	diamond	6006	100	0.998	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium SCN 69-37
27291407	27291407	PRJNA1120586_P_NODE_19163_length_304_cov_1.089362_g18972_i0	PRJNA1120586	19163	304	1.089362	3.31166048	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	43.5	0.0386	NR	MEO7793186.1	2651171	g18972	i0	30.5	0.809210526315789	82	50	75	2	30	257	119	199	MEO7793186.1 apolipoprotein N-acyltransferase [Thermoanaerobaculia bacterium]	diamond	246	43.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
28144159	28144159	PRJNA1120586_P_NODE_46605_length_230_cov_0.894410_g46414_i0	PRJNA1120586	46605	230	0.89441	2.057143	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	91.7	1.1e-19	NR	HEX8398983.1	2283092	g46414	i0	71.1	1.81304347826087	76	17	96.5	4	230	9	132	204	HEX8398983.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	417	91.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28206903	28206903	PRJNA1120586_P_NODE_34986_length_246_cov_2.322034_g34795_i0	PRJNA1120586	34986	246	2.322034	5.71220364	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	143	2.2e-39	NR	HQU85942.1	2283092	g34795	i0	84	0.98780487804878	81	13	98.8	0	3	245	46	126	HQU85942.1 peptidoglycan-binding protein [Pyrinomonadaceae bacterium]	diamond	243	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29186102	29186102	PRJNA1120586_P_NODE_49269_length_228_cov_0.905660_g49078_i0	PRJNA1120586	49269	228	0.90566	2.0649048	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	63.2	1.89e-9	NR	HYO63840.1	2283092	g49078	i0	63	0.710526315789474	54	20	71.1	0	163	2	386	439	HYO63840.1 response regulator [Pyrinomonadaceae bacterium]	diamond	162	63.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
31555695	31555695	PRJNA1120586_P_NODE_41296_length_234_cov_0.872727_g41105_i0	PRJNA1120586	41296	234	0.872727	2.04218118	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	102	1.29e-25	NR	MDQ3041983.1	1978231	g41105	i0	91.8	0.628205128205128	49	4	62.8	0	174	28	120	168	MDQ3041983.1 hypothetical protein [Acidobacteriota bacterium]	diamond	147	102	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32777427	32777427	PRJNA1120586_P_NODE_25400_length_276_cov_1.043478_g25209_i0	PRJNA1120586	25400	276	1.043478	2.87999928	Pseudomonadati	3379134	Bacteria	Bacteria	104	8.67e-24	NR	MDY7094683.1	1978231	g25209	i0	59.1	1.92391304347826	88	36	95.7	0	273	10	421	508	MDY7094683.1 type I polyketide synthase [Acidobacteriota bacterium]	diamond	531	105	0.990476190476191	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota 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);;