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

6 rows where bioproject = "PRJNA917598", 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_family	tax_genus	tax_species
896428	896428	PRJNA917598_P_NODE_59501_length_292_cov_2.146119_g58557_i0	PRJNA917598	59501	292	2.146119	6.26666748	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	235	2.5e-57	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g58557	i0	81.605	20.7397260273973	299	42	100	11	1	292	3680992	3681284	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	6056	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
26929779	26929779	PRJNA917598_P_NODE_91182_length_244_cov_0.900585_g90238_i0	PRJNA917598	91182	244	0.900585	2.1974274	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	163	1.08e-48	NR	MBI2810967.1	2052166	g90238	i0	93.8	0.995901639344262	81	5	99.6	0	1	243	123	203	MBI2810967.1 aminotransferase class IV [Candidatus Melainabacteria bacterium]	diamond	243	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
28919242	28919242	PRJNA917598_P_NODE_27428_length_441_cov_1.190217_g26484_i0	PRJNA917598	27428	441	1.190217	5.24885697	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	49.3	5.84e-5	NR	MDR3616706.1	2364082	g26484	i0	44.4	0.306122448979592	45	25	30.6	0	242	376	6	50	MDR3616706.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	135	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29266576	29266576	PRJNA917598_P_NODE_77249_length_256_cov_1.409836_g76305_i0	PRJNA917598	77249	256	1.409836	3.60918016	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	87.8	1.9e-19	NR	MBL8086383.1	2711154	g76305	i0	76.9	0.609375	52	12	60.9	0	256	101	93	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	156	87.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
29582142	29582142	PRJNA917598_P_NODE_35330_length_386_cov_3.715655_g34386_i0	PRJNA917598	35330	386	3.715655	14.3424283	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	95.5	8.12e-22	NR	HEY9875686.1	2364082	g34386	i0	72.6	4.35233160621762	62	17	48.2	0	384	199	97	158	HEY9875686.1 group I intron-associated PD-(D/E)XK endonuclease [Candidatus Obscuribacterales bacterium]	diamond	1680	95.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31074660	31074660	PRJNA917598_P_NODE_84595_length_248_cov_0.880000_g83651_i0	PRJNA917598	84595	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	122	2.31e-32	NR	HEY9843677.1	2364082	g83651	i0	82.1	1.88709677419355	78	14	94.4	0	13	246	1	78	HEY9843677.1 NusA N-terminal domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	468	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;