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

11 rows where bioproject = "PRJEB66218", 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
1408208	1408208	PRJEB66218_P_NODE_50942_length_473_cov_3.342233_g48525_i0	PRJEB66218	50942	473	3.342233	15.80876209	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	455	2.9999999999999995e-123	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g48525	i0	84.134	62.8266384778013	479	67	100	9	1	473	3681380	3680905	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	29717	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
2684888	2684888	PRJEB66218_P_NODE_97163_length_312_cov_1.553785_g94735_i0	PRJEB66218	97163	312	1.553785	4.8478092	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	479	1.1299999999999996e-130	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g94735	i0	94.788	32.0096153846154	307	16	98	0	6	312	3682540	3682234	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	9987	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
12886298	12886298	PRJEB66218_P_NODE_228851_length_204_cov_1.811189_g226421_i0	PRJEB66218	228851	204	1.811189	3.69482556	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	246	7.609999999999999e-61	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g226421	i0	88.67	67.1813725490196	203	22	99	1	2	204	3679933	3679732	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13705	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
14162550	14162550	PRJEB66218_P_NODE_6912_length_1728_cov_5.381524_g5841_i0	PRJEB66218	6912	1728	5.381524	92.99273472	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1400	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5841	i0	84.621	129.710069444444	1437	189	89	26	310	1728	3681231	3682653	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	224139	1400	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
15436134	15436134	PRJEB66218_P_NODE_50493_length_476_cov_2.033735_g48076_i0	PRJEB66218	50493	476	2.033735	9.6805786	Vampirovibrio sp.	2717857	Bacteria	Bacteria	142	2.38e-36	NR	MBX2859775.1	2717857	g48076	i0	57.1	0.838235294117647	133	47	83.8	1	409	11	167	289	MBX2859775.1 amino acid permease [Vampirovibrio sp.]	diamond	399	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales	Vampirovibrio	Vampirovibrio sp.
21807716	21807716	PRJEB66218_P_NODE_130318_length_261_cov_3.545000_g127889_i0	PRJEB66218	130318	261	3.545	9.25245	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	427	3.38e-115	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g127889	i0	96.169	191.091954022989	261	10	100	0	1	261	3679768	3680028	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	49875	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
24359711	24359711	PRJEB66218_P_NODE_60020_length_425_cov_1.793956_g57599_i0	PRJEB66218	60020	425	1.793956	7.624313	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	429	1.62e-115	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g57599	i0	85.012	56.9388235294118	427	59	100	4	1	425	3681380	3680957	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	24199	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
27697785	27697785	PRJEB66218_P_NODE_117644_length_278_cov_1.589862_g115215_i0	PRJEB66218	117644	278	1.589862	4.4198163600000004	Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11	1801609	Bacteria	Bacteria	50.4	9.95e-5	NR	OGI09100.1	1801609	g115215	i0	52.4	0.453237410071942	42	20	45.3	0	56	181	122	163	OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11]	diamond	126	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11
28076172	28076172	PRJEB66218_P_NODE_117025_length_279_cov_1.192661_g114596_i0	PRJEB66218	117025	279	1.192661	3.32752419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	56.2	1.06e-6	NR	MBX3137205.1	2364082	g114596	i0	35.4	1.6989247311828	79	50	83.9	1	24	257	2128	2206	MBX3137205.1 zeta toxin family protein [Candidatus Obscuribacterales bacterium]	diamond	474	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
29339382	29339382	PRJEB66218_P_NODE_173529_length_225_cov_1.554878_g171099_i0	PRJEB66218	173529	225	1.554878	3.4984755	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	99	1.19e-23	NR	MBK8190284.1	2692181	g171099	i0	67.6	2.93333333333333	71	22	94.7	1	214	2	119	188	MBK8190284.1 MBL fold metallo-hydrolase [Vampirovibrionales bacterium]	diamond	660	99	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales		Vampirovibrionales bacterium
32752311	32752311	PRJEB66218_P_NODE_168520_length_228_cov_1.856287_g166090_i0	PRJEB66218	168520	228	1.856287	4.23233436	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	147	1.0899999999999999e-43	NR	MBX9722669.1	2364082	g166090	i0	86.8	2	76	10	100	0	1	228	5	80	MBX9722669.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	456	147	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);;