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

10 rows where analysis = "diamond" and tax_phylum = "Candidatus Stahliibacteriota"

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_phylum	tax_species
27270064	27270064	PRJNA615351_P_NODE_43523_length_834_cov_9.137672_g32527_i0	PRJNA615351	43523	834	9.137672	76.20818448	Candidatus Stahliibacteriota bacterium	2528828	Bacteria	Bacteria	140	3.5199999999999997e-37	NR	HIE06365.1	2528828	g32527	i0	40	0.629496402877698	175	96	62.9	3	114	638	2	167	HIE06365.1 aminoacyl-tRNA hydrolase [Candidatus Stahlbacteria bacterium]	diamond	525	140	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota bacterium
28076499	28076499	PRJEB81463_P_NODE_17225_length_266_cov_1.145078_g16953_i0	PRJEB81463	17225	266	1.145078	3.04590748	Candidatus Stahliibacteriota bacterium	2528828	Bacteria	Bacteria	94.7	2.07e-20	NR	MBI4721486.1	2528828	g16953	i0	60.9	0.981203007518797	87	32	95.9	1	257	3	294	380	MBI4721486.1 HEAT repeat domain-containing protein [Candidatus Stahlbacteria bacterium]	diamond	261	94.7	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota bacterium
28832822	28832822	PRJEB11748_P_NODE_161648_length_321_cov_7.000000_g159465_i0	PRJEB11748	161648	321	7	22.47	Candidatus Stahliibacteriota bacterium	2528828	Bacteria	Bacteria	183	1.4599999999999995e-55	NR	MBI4722244.1	2528828	g159465	i0	93.9	0.925233644859813	99	6	92.5	0	298	2	108	206	MBI4722244.1 site-specific DNA-methyltransferase [Candidatus Stahlbacteria bacterium]	diamond	297	183	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota bacterium
29836370	29836370	PRJNA971676_P_NODE_17651_length_247_cov_0.885057_g17562_i0	PRJNA971676	17651	247	0.885057	2.18609079	bacterium (Candidatus Stahlbacteria) CG23_combo_of_CG	2014296	Bacteria	Bacteria	52.8	7.93e-6	NR	PIP13388.1	2014296	g17562	i0	49.3	2.42914979757085	67	25	81.4	2	46	246	21	78	PIP13388.1 MAG: hypothetical protein COX49_02230 [bacterium (Candidatus Stahlbacteria) CG23_combo_of_CG06-09_8_20_14_all_40_9]	diamond	600	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota bacterium CG23_combo_of_CG06-09_8_20_14_all_40_9
30776784	30776784	PRJNA666695_S_NODE_96354_length_223_cov_4.549451_g95260_i0	PRJNA666695	96354	223	4.549451	10.14527573	Candidatus Stahliibacteriota bacterium	2528828	Bacteria	Bacteria	68.6	2.31e-11	NR	HID93748.1	2528828	g95260	i0	50	3.30941704035874	64	31	86.1	1	198	7	643	705	HID93748.1 DNA polymerase I [Candidatus Stahlbacteria bacterium]	diamond	738	68.6	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota bacterium
31207700	31207700	PRJNA1148190_P_NODE_165895_length_409_cov_1.425595_g154727_i0	PRJNA1148190	165895	409	1.425595	5.83068355	Candidatus Stahlbacteria bacterium	2528828	Bacteria	Bacteria	75.9	2.07e-14	NR	TET59642.1	2528828	g154727	i0	64.9	0.418092909535452	57	20	41.8	0	112	282	89	145	TET59642.1 MAG: hypothetical protein E3J47_08140 [Candidatus Stahlbacteria bacterium]	diamond	171	75.9	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota bacterium
31354113	31354113	PRJEB64798_P_NODE_83716_length_213_cov_5.993902_g81950_i0	PRJEB64798	83716	213	5.993902	12.76701126	Pseudomonadati	3379134	Bacteria	Bacteria	45.4	0.00284	NR	HID93656.1	2528828	g81950	i0	46.8	3.8169014084507	62	21	87.3	2	7	192	240	289	HID93656.1 exodeoxyribonuclease VII large subunit [Candidatus Stahlbacteria bacterium]	diamond	813	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota bacterium
32328715	32328715	PRJNA724011_P_NODE_17239_length_721_cov_2.754630_g16252_i0	PRJNA724011	17239	721	2.75463	19.8608823	Candidatus Stahliibacteriota bacterium	2528828	Bacteria	Bacteria	134	2.96e-35	NR	HIE06365.1	2528828	g16252	i0	40.5	0.719833564493759	173	94	72	3	5	523	2	165	HIE06365.1 aminoacyl-tRNA hydrolase [Candidatus Stahlbacteria bacterium]	diamond	519	134	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota bacterium
32437355	32437355	PRJEB81463_P_NODE_17519_length_264_cov_2.387435_g17247_i0	PRJEB81463	17519	264	2.387435	6.3028284	Candidatus Stahliibacteriota bacterium	2528828	Bacteria	Bacteria	150	2.12e-40	NR	MBI4722999.1	2528828	g17247	i0	79.3	0.988636363636364	87	18	98.9	0	262	2	294	380	MBI4722999.1 CoB--CoM heterodisulfide reductase iron-sulfur subunit A family protein [Candidatus Stahlbacteria bacterium]	diamond	261	150	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota bacterium
33031860	33031860	PRJEB6584o_S_NODE_18492_length_209_cov_2.155172_g18384_i0	PRJEB6584	18492	209	2.155172	4.50430948	Candidatus Stahlbacteria bacterium	2528828	Bacteria	Bacteria	47.8	4.01e-4	NR	TEU00595.1	2528828	g18384	i0	55.9	0.947368421052632	34	15	48.8	0	198	97	404	437	TEU00595.1 MAG: saccharopine dehydrogenase [Candidatus Stahlbacteria bacterium]	diamond	198	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Stahliibacteriota	Candidatus Stahliibacteriota 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);;