metadata: contig_metadata: 4 rows where bioproject = "PRJNA1111077" and tax

4 rows where bioproject = "PRJNA1111077" 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_species
28141854	28141854	PRJNA1111077_P_NODE_32885_length_247_cov_0.885057_g32664_i0	PRJNA1111077	32885	247	0.885057	2.18609079	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	160	5.66e-47	NR	HIA52869.1	2052166	g32664	i0	100	0.983805668016194	81	0	98.4	0	3	245	79	159	HIA52869.1 enoyl-CoA hydratase [Candidatus Melainabacteria bacterium]	diamond	243	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
29562318	29562318	PRJNA1111077_P_NODE_20590_length_285_cov_1.283019_g20369_i0	PRJNA1111077	20590	285	1.283019	3.65660415	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	180	3.07e-53	NR	MDZ4837510.1	2052166	g20369	i0	95.7	0.989473684210526	94	4	98.9	0	3	284	130	223	MDZ4837510.1 helix-turn-helix domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	282	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
30794365	30794365	PRJNA1111077_P_NODE_35654_length_243_cov_0.905882_g35433_i0	PRJNA1111077	35654	243	0.905882	2.20129326	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	106	5.06e-25	NR	MDD9898282.1	2052166	g35433	i0	62	1.96296296296296	79	29	96.3	1	242	9	277	355	MDD9898282.1 HAMP domain-containing sensor histidine kinase [Candidatus Melainabacteria bacterium]	diamond	477	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
31015631	31015631	PRJNA1111077_P_NODE_29995_length_251_cov_1.589888_g29774_i0	PRJNA1111077	29995	251	1.589888	3.99061888	Candidatus Melainabacteria bacterium RIFOXYA12_FULL_32_12	1801610	Bacteria	Bacteria	43.9	0.0153	NR	OGI24496.1	1801610	g29774	i0	37.7	1.41035856573705	69	39	77.7	2	56	250	5	73	OGI24496.1 MAG: hypothetical protein A2287_03385 [Candidatus Melainabacteria bacterium RIFOXYA12_FULL_32_12]	diamond	354	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium RIFOXYA12_FULL_32_12

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