metadata: contig_metadata: 10 rows where analysis = "diamond", tax_phylum = "Candidatus Spechtiibacteriota" and tax

10 rows where analysis = "diamond", tax_phylum = "Candidatus Spechtiibacteriota" and tax_superkingdom = "Bacteria"

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
27168840	27168840	PRJNA309466_P_NODE_15142_length_170_cov_2.867769_g15085_i0	PRJNA309466	15142	170	2.867769	4.8752073	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_	2750079	Bacteria	Bacteria	55.5	4.48e-7	NR	OGZ57538.1	1802157	g15085	i0	47.1	0.9	51	27	90	0	154	2	357	407	OGZ57538.1 MAG: hypothetical protein A2728_00385 [Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_01_FULL_38_11]	diamond	153	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_01_FULL_38_11
27875434	27875434	PRJNA811237_S_NODE_35125_length_161_cov_0.910714_g34885_i0	PRJNA811237	35125	161	0.910714	1.46624954	Candidatus Spechtbacteria bacterium	2750079	Bacteria	Bacteria	65.1	8.72e-11	NR	MBI2463034.1	2750079	g34885	i0	64.6	0.894409937888199	48	17	89.4	0	18	161	122	169	MBI2463034.1 NUDIX domain-containing protein [Candidatus Spechtbacteria bacterium]	diamond	144	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium
28101809	28101809	PRJNA1148190_P_NODE_725765_length_244_cov_0.900585_g714592_i0	PRJNA1148190	725765	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	116	3.61e-32	NR	OGZ57613.1	1802158	g714592	i0	74.3	4.30327868852459	70	18	86.1	0	242	33	8	77	OGZ57613.1 MAG: NrdH-redoxin [Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_01_FULL_43_30]	diamond	1050	116	1	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_01_FULL_43_30
28600283	28600283	PRJNA744060_P_NODE_27867_length_309_cov_1.322034_g27538_i0	PRJNA744060	27867	309	1.322034	4.08508506	Candidatus Spechtbacteria bacterium	2750079	Bacteria	Bacteria	127	5.6199999999999996e-34	NR	MBI2463034.1	2750079	g27538	i0	63.4	0.980582524271845	101	35	98.1	1	3	305	72	170	MBI2463034.1 NUDIX domain-containing protein [Candidatus Spechtbacteria bacterium]	diamond	303	127	1	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium
28622325	28622325	PRJNA340009_P_NODE_66707_length_165_cov_0.879310_g66400_i0	PRJNA340009	66707	165	0.87931	1.4508615	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_	2750079	Bacteria	Bacteria	89	3.15e-19	NR	OGZ58447.1	1802158	g66400	i0	84.9	0.963636363636364	53	8	96.4	0	160	2	100	152	OGZ58447.1 MAG: redox-regulated ATPase YchF [Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_01_FULL_43_30]	diamond	159	89	1	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_01_FULL_43_30
29368180	29368180	PRJNA773247_P_NODE_29889_length_252_cov_4.111732_g29805_i0	PRJNA773247	29889	252	4.111732	10.36156464	Bacteria	2	Bacteria	Bacteria	139	8.08e-40	NR	OGZ60121.1	1802159	g29805	i0	84.5	3	84	13	100	0	252	1	34	117	OGZ60121.1 MAG: hypothetical protein A3B96_01815 [Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_02_FULL_43_15b]	diamond	756	140	0.992857142857143	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_02_FULL_43_15b
29475091	29475091	PRJNA404067_P_NODE_33910_length_206_cov_0.882759_g33523_i0	PRJNA404067	33910	206	0.882759	1.81848354	Candidatus Spechtbacteria bacterium	2750079	Bacteria	Bacteria	102	1.6299999999999994e-23	NR	MBI1888767.1	2750079	g33523	i0	67.6	0.990291262135922	68	22	99	0	205	2	227	294	MBI1888767.1 ATP-grasp domain-containing protein [Candidatus Spechtbacteria bacterium]	diamond	204	102	1	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium
31180205	31180205	PRJNA340009_P_NODE_29435_length_229_cov_1.133333_g29128_i0	PRJNA340009	29435	229	1.133333	2.59533257	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_	2750079	Bacteria	Bacteria	106	1.32e-25	NR	OGZ59181.1	1802159	g29128	i0	78.3	0.903930131004367	69	15	90.4	0	211	5	1	69	OGZ59181.1 MAG: hypothetical protein A3B96_00280 [Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_02_FULL_43_15b]	diamond	207	106	1	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_02_FULL_43_15b
32714583	32714583	PRJNA1136505_P_NODE_25640_length_840_cov_1.671447_g19144_i0	PRJNA1136505	25640	840	1.671447	14.0401548	Bacteria	2	Bacteria	Bacteria	71.6	3.22e-11	NR	OGZ60670.1	1802162	g19144	i0	57.6	0.621428571428571	59	19	21.1	1	185	361	106	158	OGZ60670.1 MAG: hypothetical protein A2919_02110 [Candidatus Spechtbacteria bacterium RIFCSPLOWO2_01_FULL_43_12]	diamond	522	71.6	1	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium RIFCSPLOWO2_01_FULL_43_12
32788561	32788561	PRJNA1145997_P_NODE_24360_length_539_cov_7.289700_g21747_i0	PRJNA1145997	24360	539	7.2897	39.291483	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_	2750079	Bacteria	Bacteria	112	5.89e-25	NR	OGZ58826.1	1802157	g21747	i0	39.1	2.85528756957328	169	92	94.1	2	12	518	384	541	OGZ58826.1 MAG: hypothetical protein A2728_00135 [Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_01_FULL_38_11]	diamond	1539	112	1	Bacteria	Bacteria candidate phyla	Candidatus Spechtiibacteriota	Candidatus Spechtbacteria bacterium RIFCSPHIGHO2_01_FULL_38_11

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