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

14 rows where analysis = "diamond", bioproject = "PRJEB56027" 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_species
17974216	17974216	PRJEB56027_P_NODE_125415_length_245_cov_0.895349_g122606_i0	PRJEB56027	125415	245	0.895349	2.19360505	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	156	5.82e-44	NR	HVE57426.1	2283092	g122606	i0	93.8	1.98367346938776	81	5	99.2	0	3	245	53	133	HVE57426.1 bifunctional phosphopantothenoylcysteine decarboxylase/phosphopantothenate--cysteine ligase CoaBC [Pyrinomonadaceae bacterium]	diamond	486	156	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
26685263	26685263	PRJEB56027_P_NODE_111161_length_254_cov_1.701657_g108352_i0	PRJEB56027	111161	254	1.701657	4.32220878	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	120	6.49e-30	NR	HKH70572.1	2910147	g108352	i0	95.2	0.74409448818897606	63	3	74.4	0	66	254	1	63	HKH70572.1 aldehyde dehydrogenase family protein [Vicinamibacterales bacterium]	diamond	189	120	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
27033542	27033542	PRJEB56027_P_NODE_88362_length_285_cov_1.448113_g85553_i0	PRJEB56027	88362	285	1.448113	4.12712205	Terriglobia bacterium	2081523	Bacteria	Bacteria	154	5.51e-44	NR	MBZ5615086.1	2081523	g85553	i0	84.2	7.06315789473684	95	15	100	0	1	285	103	197	MBZ5615086.1 sigma-70 family RNA polymerase sigma factor [Terriglobia bacterium]	diamond	2013	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia			Terriglobia bacterium
27254750	27254750	PRJEB56027_P_NODE_103363_length_264_cov_1.612565_g100554_i0	PRJEB56027	103363	264	1.612565	4.2571716	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	166	1.7599999999999999e-47	NR	NOT47394.1	1978231	g100554	i0	90.7	1.97727272727273	86	8	97.7	0	264	7	271	356	NOT47394.1 TonB-dependent receptor [Acidobacteriota bacterium]	diamond	522	166	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
27381413	27381413	PRJEB56027_P_NODE_88883_length_284_cov_1.549763_g86074_i0	PRJEB56027	88883	284	1.549763	4.40132692	Bryobacterales bacterium	2026791	Bacteria	Bacteria	154	7.23e-44	NR	MCC6539412.1	2026791	g86074	i0	75.3	0.982394366197183	93	22	97.2	1	3	278	126	218	MCC6539412.1 thioredoxin domain-containing protein [Bryobacterales bacterium]	diamond	279	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales		Bryobacterales bacterium
28296787	28296787	PRJEB56027_P_NODE_85086_length_290_cov_1.419355_g82277_i0	PRJEB56027	85086	290	1.419355	4.1161295	Terriglobales bacterium	2282142	Bacteria	Bacteria	127	2.89e-33	NR	HEX6879058.1	2282142	g82277	i0	62.5	0.993103448275862	96	36	99.3	0	3	290	194	289	HEX6879058.1 DUF481 domain-containing protein [Terriglobales bacterium]	diamond	288	127	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales		Terriglobales bacterium
29118050	29118050	PRJEB56027_P_NODE_104709_length_262_cov_1.968254_g101900_i0	PRJEB56027	104709	262	1.968254	5.15682548	Vicinamibacteraceae bacterium	2590576	Bacteria	Bacteria	161	1.7699999999999996e-47	NR	MEO5822048.1	2590576	g101900	i0	93	0.984732824427481	86	6	98.5	0	260	3	93	178	MEO5822048.1 type I methionyl aminopeptidase [Vicinamibacteraceae bacterium]	diamond	258	161	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Vicinamibacteraceae bacterium
29275553	29275553	PRJEB56027_P_NODE_93669_length_277_cov_2.122549_g90860_i0	PRJEB56027	93669	277	2.122549	5.87946073	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	106	8.410000000000001e-27	NR	HYP07694.1	2212468	g90860	i0	56.8	1.87364620938628	88	36	93.1	1	17	274	44	131	HYP07694.1 response regulator [Bryobacteraceae bacterium]	diamond	519	106	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
29401998	29401998	PRJEB56027_P_NODE_115629_length_250_cov_1.451977_g112820_i0	PRJEB56027	115629	250	1.451977	3.6299425	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	63.2	1.81e-9	NR	MCX6596128.1	1978231	g112820	i0	52.5	1.464	61	28	73.2	1	64	246	1	60	MCX6596128.1 metallophosphoesterase [Acidobacteriota bacterium]	diamond	366	63.2	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
30507554	30507554	PRJEB56027_P_NODE_90193_length_282_cov_2.009569_g87384_i0	PRJEB56027	90193	282	2.009569	5.66698458	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	102	8.24e-23	NR	HXJ39246.1	2212468	g87384	i0	53.2	1	94	44	100	0	1	282	353	446	HXJ39246.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	282	102	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
30696984	30696984	PRJEB56027_P_NODE_136494_length_231_cov_2.398734_g133685_i0	PRJEB56027	136494	231	2.398734	5.54107554	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	91.7	1.99e-19	NR	HJR60949.1	2910147	g133685	i0	95.9	0.636363636363636	49	2	63.6	0	85	231	1	49	HJR60949.1 excinuclease ABC subunit UvrA [Vicinamibacterales bacterium]	diamond	147	91.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
31202147	31202147	PRJEB56027_P_NODE_104075_length_263_cov_1.621053_g101266_i0	PRJEB56027	104075	263	1.621053	4.26336939	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	158	1.02e-45	NR	HKO97704.1	2283092	g101266	i0	92	0.992395437262357	87	7	99.2	0	3	263	81	167	HKO97704.1 YihY/virulence factor BrkB family protein [Pyrinomonadaceae bacterium]	diamond	261	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
32499874	32499874	PRJEB56027_P_NODE_83939_length_292_cov_1.858447_g81130_i0	PRJEB56027	83939	292	1.858447	5.42666524	Blastocatellia bacterium	2052146	Bacteria	Bacteria	143	3.4e-37	NR	HEY9436346.1	2052146	g81130	i0	74	0.986301369863014	96	25	98.6	0	3	290	399	494	HEY9436346.1 ABC transporter permease [Blastocatellia bacterium]	diamond	288	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia			Blastocatellia bacterium
32814818	32814818	PRJEB56027_P_NODE_131340_length_242_cov_0.911243_g128531_i0	PRJEB56027	131340	242	0.911243	2.20520806	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	42.4	0.0485	NR	HEX9730413.1	2651171	g128531	i0	44.4	0.669421487603306	54	20	66.9	1	12	173	150	193	HEX9730413.1 NAD(P)/FAD-dependent oxidoreductase [Thermoanaerobaculia bacterium]	diamond	162	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia			Thermoanaerobaculia 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);;