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

6 rows where bioproject = "PRJNA1046144", 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
172948	172948	PRJNA1046144_P_NODE_71281_length_216_cov_2.551020_g70986_i0	PRJNA1046144	71281	216	2.55102	5.5102032	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	202	1.7899999999999995e-47	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g70986	i0	83.636	183.435185185185	220	30	100	4	1	216	3681580	3681797	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	39622	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
11650591	11650591	PRJNA1046144_P_NODE_26690_length_322_cov_1.707510_g26395_i0	PRJNA1046144	26690	322	1.70751	5.4981822	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	331	3.47e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g26395	i0	87.762	20.7639751552795	286	32	88	3	1	284	2594040	2594324	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	6686	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
14201261	14201261	PRJNA1046144_P_NODE_532_length_1753_cov_12.915677_g486_i0	PRJNA1046144	532	1753	12.915677	226.41181781	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1919	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g486	i0	86.505	98.9771819737593	1771	210	100	28	1	1753	3682670	3680911	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	173507	1919	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
28077463	28077463	PRJNA1046144_P_NODE_71745_length_212_cov_2.601399_g71450_i0	PRJNA1046144	71745	212	2.601399	5.51496588	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	63.2	1.36e-9	NR	MBX9674102.1	2364082	g71450	i0	46.9	0.905660377358491	64	34	90.6	0	212	21	273	336	MBX9674102.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	192	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
31868372	31868372	PRJNA1046144_P_NODE_45637_length_257_cov_2.707447_g45342_i0	PRJNA1046144	45637	257	2.707447	6.95813879	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	97.4	1.35e-21	NR	MDR3615585.1	2364082	g45342	i0	48.2	0.992217898832685	85	44	99.2	0	2	256	285	369	MDR3615585.1 HAMP domain-containing sensor histidine kinase [Candidatus Obscuribacterales bacterium]	diamond	255	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
32311793	32311793	PRJNA1046144_P_NODE_51939_length_243_cov_2.258621_g51644_i0	PRJNA1046144	51939	243	2.258621	5.48844903	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	58.2	9.55e-8	NR	MFA6560206.1	2364082	g51644	i0	49.2	1.55555555555556	63	31	77.8	1	234	46	9	70	MFA6560206.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	378	58.2	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);;