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

5 rows where analysis = "diamond", bioproject = "PRJNA812001" 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
13564115	13564115	PRJNA812001_P_NODE_2091_length_1039_cov_10.169772_g1905_i0	PRJNA812001	2091	1039	10.169772	105.66393108	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	59.7	7.58e-6	NR	HEB41774.1	2030827	g1905	i0	51.5	0.190567853705486	66	28	18.5	3	235	426	313	376	HEB41774.1 sodium/proline symporter [Candidatus Dependentiae bacterium]	diamond	198	59.7	1	Bacteria	Bacteria candidate phyla		Candidatus Babelota bacterium
27157564	27157564	PRJNA812001_P_NODE_118622_length_244_cov_0.900585_g118376_i0	PRJNA812001	118622	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	155	2.09e-46	NR	MCA9335165.1	2026720	g118376	i0	91.3	11.827868852459	80	7	98.4	0	241	2	27	106	MCA9335165.1 inorganic diphosphatase [Candidatus Saccharibacteria bacterium]	diamond	2886	156	0.993589743589744	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
28579079	28579079	PRJNA812001_P_NODE_109587_length_245_cov_0.895349_g109341_i0	PRJNA812001	109587	245	0.895349	2.19360505	Bacillati	1783272	Bacteria	Bacteria	107	1.82e-25	NR	PYM18684.1	2053607	g109341	i0	88.1	4.33469387755102	59	7	72.2	0	3	179	369	427	PYM18684.1 MAG: hypothetical protein DMD78_27045 [Candidatus Rokuibacteriota bacterium]	diamond	1062	108	0.990740740740741	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
31539760	31539760	PRJNA812001_P_NODE_137336_length_222_cov_4.409396_g137090_i0	PRJNA812001	137336	222	4.409396	9.78885912	Candidatus Kaiserbacteria bacterium GW2	2030810	Bacteria	Bacteria	101	2e-25	NR	KKW47632.1	1618672	g137090	i0	71.8	1.91891891891892	71	20	95.9	0	214	2	64	134	KKW47632.1 MAG: Sensory transduction protein kinase [Candidatus Kaiserbacteria bacterium GW2011_GWA2_58_9]	diamond	426	101	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium GW2011_GWA2_58_9
32244752	32244752	PRJNA812001_P_NODE_121038_length_243_cov_0.905882_g120792_i0	PRJNA812001	121038	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	57	3.31e-7	NR	MDE0427259.1	2026781	g120792	i0	50	4.54320987654321	74	33	90.1	3	232	14	122	192	MDE0427259.1 WD40 repeat domain-containing protein [Candidatus Poribacteria bacterium]	diamond	1104	57	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria 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);;