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

5 rows where bioproject = "PRJNA492280", 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
27013074	27013074	PRJNA492280_P_NODE_29742_length_151_cov_5.982456_g29635_i0	PRJNA492280	29742	151	5.982456	9.03350856	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	57.8	5.29e-8	NR	PZM78484.1	2052166	g29635	i0	100	0.47682119205298	24	0	47.7	0	147	76	3	26	PZM78484.1 MAG: glycogen debranching enzyme GlgX [Candidatus Melainabacteria bacterium]	diamond	72	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
27044793	27044793	PRJNA492280_P_NODE_16262_length_164_cov_4.149606_g16155_i0	PRJNA492280	16262	164	4.149606	6.80535384	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	48.9	8.5e-5	NR	RTL36781.1	2052166	g16155	i0	50.8	1.07926829268293	59	23	97	1	162	4	154	212	RTL36781.1 MAG: ATP-dependent zinc metalloprotease FtsH [Candidatus Melainabacteria bacterium]	diamond	177	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
28529328	28529328	PRJNA492280_P_NODE_22827_length_164_cov_2.889764_g22720_i0	PRJNA492280	22827	164	2.889764	4.73921296	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	82.8	1.62e-18	NR	MBX3137683.1	2364082	g22720	i0	77.4	1.13414634146341	62	5	97	1	2	160	49	110	MBX3137683.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	186	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
30518721	30518721	PRJNA492280_P_NODE_19813_length_164_cov_3.362205_g19706_i0	PRJNA492280	19813	164	3.362205	5.5140162	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	44.3	0.00354	NR	PKL77801.1	2013813	g19706	i0	65.7	1.97560975609756	35	12	64	0	109	5	19	53	PKL77801.1 MAG: bifunctional methylenetetrahydrofolate dehydrogenase/methenyltetrahydrofolate cyclohydrolase FolD [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	324	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
32763023	32763023	PRJNA492280_P_NODE_22480_length_164_cov_2.937008_g22373_i0	PRJNA492280	22480	164	2.937008	4.81669312	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	48.9	6.21e-5	NR	RTL35552.1	2052166	g22373	i0	70.8	0.439024390243902	24	7	43.9	0	75	4	100	123	RTL35552.1 MAG: hypothetical protein EKK48_28065 [Candidatus Melainabacteria bacterium]	diamond	72	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria 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);;