metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax_clade = "Bacteria candidate phyla"

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
26070877	26070877	PRJEB7799c_S_NODE_29613_length_155_cov_1.791667_g29590_i0	PRJEB7799	29613	155	1.791667	2.77708385	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	74.7	5.82e-14	NR	TXG76615.1	2052139	g29590	i0	78	0.967741935483871	50	11	96.8	0	5	154	127	176	TXG76615.1 MAG: mannose-1-phosphate guanylyltransferase/mannose-6-phosphate isomerase [Patescibacteria group bacterium]	diamond	150	74.7	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
33050288	33050288	PRJEB7799o_S_NODE_2101_length_187_cov_2.421053_g2093_i0	PRJEB7799	2101	187	2.421053	4.52736911	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	46.2	0.00108	NR	RTL04733.1	2030827	g2093	i0	45.3	0.850267379679144	53	26	81.8	2	157	5	743	794	RTL04733.1 MAG: hypothetical protein EKK58_09785 [Candidatus Dependentiae bacterium]	diamond	159	46.2	1	Bacteria	Bacteria candidate phyla		Candidatus Babelota bacterium
33100622	33100622	PRJEB7799a_S_NODE_918_length_384_cov_4.922636_g883_i0	PRJEB7799	918	384	4.922636	18.90292224	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	129	1.92e-35	NR	TXG78926.1	2099670	g883	i0	82.3	0.6171875	79	14	61.7	0	382	146	51	129	TXG78926.1 MAG: XRE family transcriptional regulator [Candidatus Dojkabacteria bacterium]	diamond	237	129	1	Bacteria	Bacteria candidate phyla		Candidatus Dojkabacteria bacterium
33134682	33134682	PRJEB7799a_S_NODE_12791_length_172_cov_1.992701_g12756_i0	PRJEB7799	12791	172	1.992701	3.42744572	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	41.6	0.0377	NR	MCC6350294.1	2212470	g12756	i0	56.8	0.645348837209302	37	14	64.5	1	13	123	454	488	MCC6350294.1 GWxTD domain-containing protein [Candidatus Eiseniibacteriota bacterium]	diamond	111	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
33162151	33162151	PRJEB7799e_S_NODE_25176_length_150_cov_1.043478_g25099_i0	PRJEB7799	25176	150	1.043478	1.565217	Bacteria	2	Bacteria	Bacteria	62	1.62e-9	NR	MEZ0286299.1	2053589	g25099	i0	66	1.88	47	16	94	0	2	142	517	563	MEZ0286299.1 ABC transporter transmembrane domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	282	62	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota 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);;