metadata: contig_metadata: 5 rows where bioproject = "PRJNA520845", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

5 rows where bioproject = "PRJNA520845", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

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_kingdom	tax_phylum	tax_order	tax_species
28056235	28056235	PRJNA520845_P_NODE_145885_length_309_cov_1.631356_g144386_i0	PRJNA520845	145885	309	1.631356	5.04089004	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	49.3	3.23e-4	NR	MBI3591571.1	2052166	g144386	i0	51.1	0.436893203883495	45	17	43.7	1	265	131	216	255	MBI3591571.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	135	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
29066956	29066956	PRJNA520845_P_NODE_89728_length_392_cov_1.304075_g88229_i0	PRJNA520845	89728	392	1.304075	5.111974	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	130	2.5e-34	NR	HEY9791192.1	2364082	g88229	i0	44.5	2.96938775510204	128	71	98	0	389	6	147	274	HEY9791192.1 urate oxidase [Candidatus Obscuribacterales bacterium]	diamond	1164	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
29303067	29303067	PRJNA520845_P_NODE_219129_length_250_cov_0.870056_g217630_i0	PRJNA520845	219129	250	0.870056	2.17514	Candidatus Obscuribacter	1906156	Bacteria	Bacteria	101	6.359999999999999e-23	NR	MBC7999351.1	2052166	g217630	i0	57.8	1.992	83	35	99.6	0	1	249	315	397	MBC7999351.1 putrescine aminotransferase [Candidatus Melainabacteria bacterium]	diamond	498	102	0.990196078431373	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
32132269	32132269	PRJNA520845_P_NODE_258618_length_242_cov_1.473373_g257119_i0	PRJNA520845	258618	242	1.473373	3.56556266	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	161	5.92e-48	NR	MCC6976717.1	2052166	g257119	i0	100	0.991735537190083	80	0	99.2	0	2	241	144	223	MCC6976717.1 tyrosine-type recombinase/integrase [Candidatus Melainabacteria bacterium]	diamond	240	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
32400686	32400686	PRJNA520845_P_NODE_177559_length_280_cov_1.024155_g176060_i0	PRJNA520845	177559	280	1.024155	2.867634	Bacillati	1783272	Bacteria	Bacteria	85.1	7.42e-17	NR	OGI00057.1	1801606	g176060	i0	52.2	2.79642857142857	92	44	98.6	0	2	277	57	148	OGI00057.1 MAG: sodium-translocating pyrophosphatase [Candidatus Melainabacteria bacterium GWF2_37_15]	diamond	783	85.9	0.990686845168801	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium GWF2_37_15

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