metadata: contig_metadata: 9 rows where bioproject = "PRJNA1002570", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA1002570", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Eiseniibacteriota"

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
28574416	28574416	PRJNA1002570_P_NODE_12027_length_343_cov_2.462963_g11832_i0	PRJNA1002570	12027	343	2.462963	8.44796309	Bacillati	1783272	Bacteria	Bacteria	58.9	2.2e-7	NR	HKA23727.1	2212470	g11832	i0	52.6	0.979591836734694	57	23	46.4	1	343	185	291	347	HKA23727.1 HupE/UreJ family protein [Candidatus Eiseniibacteriota bacterium]	diamond	336	58.9	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
29339796	29339796	PRJNA1002570_P_NODE_27529_length_273_cov_2.470000_g27334_i0	PRJNA1002570	27529	273	2.47	6.7431	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	132	5.57e-37	NR	MCC6653503.1	2212470	g27334	i0	76.3	1.75824175824176	80	19	87.9	0	272	33	79	158	MCC6653503.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium]	diamond	480	132	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
30280199	30280199	PRJNA1002570_P_NODE_35732_length_251_cov_1.730337_g35537_i0	PRJNA1002570	35732	251	1.730337	4.34314587	Pseudomonadati	3379134	Bacteria	Bacteria	103	8.32e-26	NR	MCU0610401.1	2212470	g35537	i0	58.1	8.90438247011952	86	33	99.2	1	1	249	81	166	MCU0610401.1 GNAT family N-acetyltransferase [Candidatus Eiseniibacteriota bacterium]	diamond	2235	104	0.990384615384615	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
30287542	30287542	PRJNA1002570_P_NODE_10172_length_366_cov_1.225256_g9977_i0	PRJNA1002570	10172	366	1.225256	4.48443696	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	129	5.85e-36	NR	HET7226681.1	2212470	g9977	i0	65.3	0.827868852459016	101	35	82.8	0	366	64	25	125	HET7226681.1 BlaI/MecI/CopY family transcriptional regulator [Candidatus Eiseniibacteriota bacterium]	diamond	303	129	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
30350905	30350905	PRJNA1002570_P_NODE_34632_length_254_cov_2.287293_g34437_i0	PRJNA1002570	34632	254	2.287293	5.80972422	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	44.3	0.0121	NR	MEZ4651544.1	2212470	g34437	i0	47.7	1.21653543307087	44	23	52	0	244	113	389	432	MEZ4651544.1 M14 family zinc carboxypeptidase [Candidatus Eiseniibacteriota bacterium]	diamond	309	44.3	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
31045817	31045817	PRJNA1002570_P_NODE_6235_length_442_cov_2.994580_g6041_i0	PRJNA1002570	6235	442	2.99458	13.2360436	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	53.1	8.13e-6	NR	MCU0613257.1	2212470	g6041	i0	40	0.475113122171946	70	37	47.5	1	258	49	3	67	MCU0613257.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium]	diamond	210	53.1	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
31551636	31551636	PRJNA1002570_P_NODE_37896_length_249_cov_0.875000_g37701_i0	PRJNA1002570	37896	249	0.875	2.17875	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	60.1	3.15e-8	NR	MFB3907681.1	2212470	g37701	i0	39.8	1	83	50	100	0	249	1	433	515	MFB3907681.1 tetratricopeptide repeat protein [Candidatus Eiseniibacteriota bacterium]	diamond	249	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
31646076	31646076	PRJNA1002570_P_NODE_13637_length_326_cov_1.146245_g13442_i0	PRJNA1002570	13637	326	1.146245	3.7367587	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	156	9.57e-43	NR	HEY6865838.1	2212470	g13442	i0	69.2	3.95705521472393	107	33	98.5	0	5	325	364	470	HEY6865838.1 peptide MFS transporter [Candidatus Eiseniibacteriota bacterium]	diamond	1290	156	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
32752730	32752730	PRJNA1002570_P_NODE_33280_length_258_cov_2.221622_g33085_i0	PRJNA1002570	33280	258	2.221622	5.73178476	Candidatus Eisenbacteria bacterium	2212470	Bacteria	Bacteria	106	2e-24	NR	TMQ49454.1	2212470	g33085	i0	54.1	0.988372093023256	85	39	98.8	0	257	3	570	654	TMQ49454.1 MAG: hypothetical protein E6K73_10020 [Candidatus Eiseniibacteriota bacterium]	diamond	255	106	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota 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);;