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

8 rows where bioproject = "PRJNA1095825", 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
27004249	27004249	PRJNA1095825_P_NODE_294122_length_241_cov_0.916667_g291059_i0	PRJNA1095825	294122	241	0.916667	2.20916747	Vampirovibrio sp.	2717857	Bacteria	Bacteria	128	3.41e-35	NR	WP_373531651.1	2717857	g291059	i0	86.3	1.81742738589212	73	10	90.9	0	239	21	129	201	WP_373531651.1 LemA family protein [Vampirovibrio sp.]	diamond	438	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales	Vampirovibrio	Vampirovibrio sp.
27248625	27248625	PRJNA1095825_P_NODE_181563_length_290_cov_1.064516_g178500_i0	PRJNA1095825	181563	290	1.064516	3.0870964	Candidatus Obscuribacter	1906156	Bacteria	Bacteria	85.1	7.48e-19	NR	MBX3137675.1	2364082	g178500	i0	72.5	1.56206896551724	51	14	52.8	0	288	136	74	124	MBX3137675.1 response regulator [Candidatus Obscuribacterales bacterium]	diamond	453	85.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
28678409	28678409	PRJNA1095825_P_NODE_253647_length_248_cov_0.880000_g250584_i0	PRJNA1095825	253647	248	0.88	2.1824	Candidatus Caenarcanales bacterium	2729995	Bacteria	Bacteria	67.4	6.66e-11	NR	MCH2226318.1	2729995	g250584	i0	55.8	2.43145161290323	52	23	62.9	0	156	1	19	70	MCH2226318.1 serine/threonine dehydratase [Candidatus Caenarcanales bacterium]	diamond	603	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales		Candidatus Caenarcanales bacterium
28867642	28867642	PRJNA1095825_P_NODE_206408_length_272_cov_1.226131_g203345_i0	PRJNA1095825	206408	272	1.226131	3.33507632	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	159	6.089999999999998e-43	NR	MBY0546982.1	2364082	g203345	i0	96.7	0.992647058823529	90	3	99.3	0	270	1	5265	5354	MBY0546982.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	270	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
29025864	29025864	PRJNA1095825_P_NODE_222688_length_260_cov_1.647059_g219625_i0	PRJNA1095825	222688	260	1.647059	4.2823534	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	159	1.53e-43	NR	MBX9568351.1	2364082	g219625	i0	100	0.946153846153846	82	0	94.6	0	14	259	1	82	MBX9568351.1 malto-oligosyltrehalose synthase [Candidatus Obscuribacterales bacterium]	diamond	246	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
29309669	29309669	PRJNA1095825_P_NODE_284769_length_243_cov_0.905882_g281706_i0	PRJNA1095825	284769	243	0.905882	2.20129326	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	130	6.32e-36	NR	MBN9397433.1	2052166	g281706	i0	98.5	0.827160493827161	67	1	82.7	0	201	1	1	67	MBN9397433.1 recombinase family protein [Candidatus Melainabacteria bacterium]	diamond	201	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
31110075	31110075	PRJNA1095825_P_NODE_176195_length_294_cov_1.393665_g173132_i0	PRJNA1095825	176195	294	1.393665	4.0973751	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	43.1	0.0465	NR	MBY0356569.1	2364082	g173132	i0	33.8	0.663265306122449	65	34	57.1	1	169	2	289	353	MBY0356569.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Candidatus Obscuribacterales bacterium]	diamond	195	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
32090814	32090814	PRJNA1095825_P_NODE_222938_length_260_cov_1.427807_g219875_i0	PRJNA1095825	222938	260	1.427807	3.7122982	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	46.2	0.00263	NR	MDZ4836472.1	2052166	g219875	i0	56.5	0.530769230769231	46	18	50.8	1	51	182	1	46	MDZ4836472.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium]	diamond	138	46.2	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);;