metadata: contig_metadata: 5 rows where bioproject = "PRJNA1148190" and tax

5 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Walliibacteriota"

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
28144963	28144963	PRJNA1148190_P_NODE_266325_length_335_cov_1.282443_g255154_i0	PRJNA1148190	266325	335	1.282443	4.29618405	Candidatus Wallbacteria bacterium	2053640	Bacteria	Bacteria	47.4	0.00241	NR	MBI4869275.1	2053640	g255154	i0	32.9	1.82686567164179	70	47	62.7	0	212	3	62	131	MBI4869275.1 hypothetical protein [Candidatus Wallbacteria bacterium]	diamond	612	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Walliibacteriota	Candidatus Wallbacteria bacterium
28492933	28492933	PRJNA1148190_P_NODE_708927_length_245_cov_0.895349_g697754_i0	PRJNA1148190	708927	245	0.895349	2.19360505	Candidatus Wallbacteria bacterium	2053640	Bacteria	Bacteria	104	8.23e-24	NR	MBI3893979.1	2053640	g697754	i0	66.7	0.991836734693878	81	27	99.2	0	245	3	1170	1250	MBI3893979.1 HYR domain-containing protein [Candidatus Wallbacteria bacterium]	diamond	243	104	1	Bacteria	Bacteria candidate phyla	Candidatus Walliibacteriota	Candidatus Wallbacteria bacterium
30502035	30502035	PRJNA1148190_P_NODE_742573_length_243_cov_0.905882_g731400_i0	PRJNA1148190	742573	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	45.1	0.0058	NR	MBI2942929.1	2053640	g731400	i0	35.3	2.04938271604938	85	44	97.5	4	237	1	75	154	MBI2942929.1 GAF domain-containing protein [Candidatus Wallbacteria bacterium]	diamond	498	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Walliibacteriota	Candidatus Wallbacteria bacterium
31082111	31082111	PRJNA1148190_P_NODE_322995_length_310_cov_2.413502_g311822_i0	PRJNA1148190	322995	310	2.413502	7.4818562	Candidatus Wallbacteria bacterium	2053640	Bacteria	Bacteria	87.4	1.69e-17	NR	MEZ7890387.1	2053640	g311822	i0	83.7	0.474193548387097	49	8	47.4	0	149	3	85	133	MEZ7890387.1 amino acid adenylation domain-containing protein [Candidatus Wallbacteria bacterium]	diamond	147	87.4	1	Bacteria	Bacteria candidate phyla	Candidatus Walliibacteriota	Candidatus Wallbacteria bacterium
31956134	31956134	PRJNA1148190_P_NODE_806757_length_226_cov_2.516340_g795584_i0	PRJNA1148190	806757	226	2.51634	5.6869284	Bacteria	2	Bacteria	Bacteria	77.8	1.32e-14	NR	MBI4865895.1	2053640	g795584	i0	50	4.83185840707965	72	36	95.6	0	221	6	390	461	MBI4865895.1 BREX system serine/threonine kinase PglW [Candidatus Wallbacteria bacterium]	diamond	1092	77.8	1	Bacteria	Bacteria candidate phyla	Candidatus Walliibacteriota	Candidatus Wallbacteria 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);;