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

5 rows where bioproject = "PRJNA1120060" and tax_phylum = "Candidatus Bipolaricaulota"

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
27194967	27194967	PRJNA1120060_P_NODE_1902182_length_276_cov_5.719212_g1884160_i0	PRJNA1120060	1902182	276	5.719212	15.78502512	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	44.3	0.0141	NR	MCD5417166.1	2306012	g1884160	i0	37.5	1.23913043478261	72	31	65.2	3	75	254	56	125	MCD5417166.1 rhomboid family intramembrane serine protease [Candidatus Bipolaricaulota bacterium]	diamond	342	44.3	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota	Candidatus Bipolaricaulota bacterium
27606131	27606131	PRJNA1120060_P_NODE_2169144_length_266_cov_1.948187_g2151095_i0	PRJNA1120060	2169144	266	1.948187	5.18217742	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	42	0.0353	NR	MBU1049490.1	2306012	g2151095	i0	36.8	0.642857142857143	57	34	64.3	1	241	71	31	85	MBU1049490.1 hypothetical protein [Candidatus Bipolaricaulota bacterium]	diamond	171	42	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota	Candidatus Bipolaricaulota bacterium
28426889	28426889	PRJNA1120060_P_NODE_2017826_length_272_cov_1.582915_g1999793_i0	PRJNA1120060	2017826	272	1.582915	4.3055288	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	44.3	0.0144	NR	MCD5407908.1	2306012	g1999793	i0	31.3	0.915441176470588	83	57	91.5	0	263	15	66	148	MCD5407908.1 DMT family transporter [Candidatus Bipolaricaulota bacterium]	diamond	249	44.3	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota	Candidatus Bipolaricaulota bacterium
31680640	31680640	PRJNA1120060_P_NODE_2282197_length_262_cov_1.238095_g2264142_i0	PRJNA1120060	2282197	262	1.238095	3.2438089	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	51.2	1.15e-5	NR	MBS3825991.1	2306012	g2264142	i0	41.8	1.61450381679389	67	39	76.7	0	210	10	44	110	MBS3825991.1 ribonuclease HI family protein [Candidatus Bipolaricaulota bacterium]	diamond	423	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota	Candidatus Bipolaricaulota bacterium
32124185	32124185	PRJNA1120060_P_NODE_2687158_length_249_cov_0.875000_g2669077_i0	PRJNA1120060	2687158	249	0.875	2.17875	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	43.5	0.0196	NR	MCD6128804.1	2306012	g2669077	i0	34.3	0.807228915662651	67	37	73.5	3	193	11	167	232	MCD6128804.1 MBL fold metallo-hydrolase [Candidatus Bipolaricaulota bacterium]	diamond	201	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota	Candidatus Bipolaricaulota 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);;