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

5 rows where analysis = "diamond", bioproject = "PRJNA1011833" 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
27919066	27919066	PRJNA1011833_S_NODE_58865_length_151_cov_2.990741_g58445_i0	PRJNA1011833	58865	151	2.990741	4.51601891	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	60.5	1.82e-9	NR	HEX7041838.1	2052139	g58445	i0	63.3	5.44370860927152	49	17	95.4	1	149	6	107	155	HEX7041838.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Patescibacteria group bacterium]	diamond	822	60.5	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
29813476	29813476	PRJNA1011833_S_NODE_56231_length_153_cov_2.181818_g55811_i0	PRJNA1011833	56231	153	2.181818	3.33818154	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	41.6	0.0289	NR	MCK4232907.1	2052148	g55811	i0	43.5	0.901960784313726	46	24	86.3	1	153	22	146	191	MCK4232907.1 hypothetical protein [candidate division WOR-3 bacterium]	diamond	138	41.6	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium
31069914	31069914	PRJNA1011833_S_NODE_5375_length_456_cov_7.677966_g4963_i0	PRJNA1011833	5375	456	7.677966	35.01152496	Pseudomonadati	3379134	Bacteria	Bacteria	66.6	1.32e-9	NR	KKT71909.1	1619000	g4963	i0	44.4	1.94736842105263	72	40	47.4	0	451	236	290	361	KKT71909.1 MAG: Chaperone protein DnaJ [Candidatus Uhrbacteria bacterium GW2011_GWF2_44_350]	diamond	888	67	0.994029850746269	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium GW2011_GWF2_44_350
32026192	32026192	PRJNA1011833_S_NODE_42678_length_178_cov_1.066667_g42258_i0	PRJNA1011833	42678	178	1.066667	1.89866726	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	41.6	0.0245	NR	MFA7193802.1	2053589	g42258	i0	30.4	0.943820224719101	56	39	94.4	0	170	3	26	81	MFA7193802.1 NUDIX hydrolase [Candidatus Paceibacterota bacterium]	diamond	168	41.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32184460	32184460	PRJNA1011833_S_NODE_49238_length_165_cov_1.180328_g48818_i0	PRJNA1011833	49238	165	1.180328	1.9475412	candidate division WWE3 bacterium RIFCSPLOWO2_12_FULL_36_1	2053526	Bacteria	Bacteria	46.6	2.88e-4	NR	OGC56960.1	1802630	g48818	i0	62.5	0.581818181818182	32	12	58.2	0	47	142	11	42	OGC56960.1 MAG: ATP:cob(I)alamin adenosyltransferase, partial [candidate division WWE3 bacterium RIFCSPLOWO2_12_FULL_36_10]	diamond	96	46.6	1	Bacteria	Bacteria candidate phyla	candidate division WWE3	candidate division WWE3 bacterium RIFCSPLOWO2_12_FULL_36_10

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);;