metadata: contig_metadata: 6 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Schekmaniibacteriota"

6 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Schekmaniibacteriota"

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
27450776	27450776	PRJNA1148190_P_NODE_521883_length_262_cov_1.629630_g510710_i0	PRJNA1148190	521883	262	1.62963	4.2696306	Candidatus Schekmanbacteria bacterium	2419984	Bacteria	Bacteria	97.8	1.73e-23	NR	MBI2566041.1	2419984	g510710	i0	58.3	0.961832061068702	84	32	96.2	1	260	9	58	138	MBI2566041.1 phosphohydrolase [Candidatus Schekmanbacteria bacterium]	diamond	252	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Schekmaniibacteriota	Candidatus Schekmanbacteria bacterium
28165007	28165007	PRJNA1148190_P_NODE_201465_length_375_cov_1.748344_g190295_i0	PRJNA1148190	201465	375	1.748344	6.55629	Pseudomonadati	3379134	Bacteria	Bacteria	70.9	1.77e-13	NR	OGL46993.1	1817878	g190295	i0	51.9	1.288	54	26	43.2	0	164	3	1	54	OGL46993.1 MAG: hypothetical protein A2161_13740 [Candidatus Schekmanbacteria bacterium RBG_13_48_7]	diamond	483	71.6	0.990223463687151	Bacteria	Bacteria candidate phyla	Candidatus Schekmaniibacteriota	Candidatus Schekmanbacteria bacterium RBG_13_48_7
29470588	29470588	PRJNA1148190_P_NODE_28690_length_1339_cov_3.507109_g19228_i0	PRJNA1148190	28690	1339	3.507109	46.96018951	Candidatus Schekmanbacteria bacterium RBG_16_38_1	2419984	Bacteria	Bacteria	85.1	6.86e-14	NR	OGL46465.1	1817879	g19228	i0	30.9	0.405526512322629	181	114	40.3	4	472	1011	121	291	OGL46465.1 MAG: hypothetical protein A2W05_07110 [Candidatus Schekmanbacteria bacterium RBG_16_38_10]	diamond	543	85.1	1	Bacteria	Bacteria candidate phyla	Candidatus Schekmaniibacteriota	Candidatus Schekmanbacteria bacterium RBG_16_38_10
29850155	29850155	PRJNA1148190_P_NODE_43751_length_942_cov_3.906789_g33178_i0	PRJNA1148190	43751	942	3.906789	36.80195238	Candidatus Schekmanbacteria bacterium	2419984	Bacteria	Bacteria	83.6	1.66e-14	NR	MBI2566872.1	2419984	g33178	i0	38.5	0.388535031847134	122	73	38.5	2	609	247	151	271	MBI2566872.1 zinc ribbon domain-containing protein [Candidatus Schekmanbacteria bacterium]	diamond	366	83.6	1	Bacteria	Bacteria candidate phyla	Candidatus Schekmaniibacteriota	Candidatus Schekmanbacteria bacterium
31366611	31366611	PRJNA1148190_P_NODE_233336_length_353_cov_1.100000_g222166_i0	PRJNA1148190	233336	353	1.1	3.883	Candidatus Schekmanbacteria bacterium	2419984	Bacteria	Bacteria	88.6	1.01e-17	NR	MBI5374207.1	2419984	g222166	i0	40	0.977337110481586	115	69	97.7	0	1	345	133	247	MBI5374207.1 hypothetical protein [Candidatus Schekmanbacteria bacterium]	diamond	345	88.6	1	Bacteria	Bacteria candidate phyla	Candidatus Schekmaniibacteriota	Candidatus Schekmanbacteria bacterium
31903963	31903963	PRJNA1148190_P_NODE_165537_length_409_cov_2.211310_g154369_i0	PRJNA1148190	165537	409	2.21131	9.0442579	Candidatus Schekmanbacteria bacterium	2419984	Bacteria	Bacteria	94.4	1.86e-19	NR	MBI5374526.1	2419984	g154369	i0	38.5	1.08557457212714	148	78	99	4	407	3	295	442	MBI5374526.1 hypothetical protein [Candidatus Schekmanbacteria bacterium]	diamond	444	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Schekmaniibacteriota	Candidatus Schekmanbacteria 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);;