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

6 rows where bioproject = "PRJNA867519", 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_class	tax_order	tax_genus	tax_species
19088488	19088488	PRJNA867519_P_NODE_23815_length_258_cov_2.081081_g23661_i0	PRJNA867519	23815	258	2.081081	5.36918898	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	160	3.17e-48	NR	MBX9724270.1	2364082	g23661	i0	88.2	0.988372093023256	85	10	98.8	0	257	3	42	126	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	255	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
28950132	28950132	PRJNA867519_P_NODE_17348_length_287_cov_1.841121_g17194_i0	PRJNA867519	17348	287	1.841121	5.28401727	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	97.8	1.2300000000000002e-21	NR	MBX9669271.1	2364082	g17194	i0	45.7	1.97560975609756	94	51	98.3	0	287	6	176	269	MBX9669271.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	567	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
30118191	30118191	PRJNA867519_P_NODE_16672_length_290_cov_1.829493_g16518_i0	PRJNA867519	16672	290	1.829493	5.3055297	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	70.1	6.24e-12	NR	HEY9814218.1	2364082	g16518	i0	41.7	0.993103448275862	96	51	99.3	2	289	2	97	187	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	288	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
31548879	31548879	PRJNA867519_P_NODE_23856_length_258_cov_1.664865_g23702_i0	PRJNA867519	23856	258	1.664865	4.2953517	Bacteria	2	Bacteria	Bacteria	68.9	2.38e-11	NR	MDZ4837594.1	2052166	g23702	i0	42.4	1.97674418604651	85	49	98.8	0	257	3	79	163	MDZ4837594.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	510	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
31603821	31603821	PRJNA867519_P_NODE_216_length_1586_cov_4.083939_g155_i0	PRJNA867519	216	1586	4.083939	64.77127254	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	68.6	8.21e-9	NR	HEY9814218.1	2364082	g155	i0	26.2	0.484237074401009	256	173	46.9	9	120	863	5	252	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	768	68.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
31611929	31611929	PRJNA867519_P_NODE_13116_length_322_cov_1.232932_g12962_i0	PRJNA867519	13116	322	1.232932	3.97004104	Bacillati	1783272	Bacteria	Bacteria	98.6	1.94e-21	NR	MCE3236285.1	2717857	g12962	i0	62	7.01552795031056	71	27	66.1	0	2	214	439	509	MCE3236285.1 dehydrogenase [Vampirovibrio sp.]	diamond	2259	98.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales	Vampirovibrio	Vampirovibrio sp.

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