metadata: contig_metadata: 20 rows where bioproject = "PRJEB6584" and tax

20 rows where bioproject = "PRJEB6584" 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
25523785	25523785	PRJEB6584g_S_NODE_14425_length_153_cov_5.677966_g14413_i0	PRJEB6584	14425	153	5.677966	8.68728798	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	171	3.32e-38	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g14413	i0	90.625	69.4248366013072	128	12	84	0	26	153	3680877	3681004	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	10622	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25523826	25523826	PRJEB6584h_S_NODE_345_length_501_cov_12.916309_g295_i0	PRJEB6584	345	501	12.916309	64.71070809	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	503	1.12e-137	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g295	i0	85.892	201.870259481038	482	56	95	11	2	477	3682206	3682681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	101137	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25523862	25523862	PRJEB6584i_S_NODE_2913_length_205_cov_3.329412_g2901_i0	PRJEB6584	2913	205	3.329412	6.8252946	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	202	1.68e-47	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2901	i0	88.554	32.1707317073171	166	19	81	0	1	166	3679886	3679721	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	6595	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25659264	25659264	PRJEB6584a_S_NODE_250_length_604_cov_442.662566_g239_i0	PRJEB6584	250	604	442.662566	2673.68189864	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	603	1.3199999999999999e-167	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g239	i0	86.861	145.78642384106	548	60	90	11	26	567	3682140	3682681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	88055	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25659712	25659712	PRJEB6584g_S_NODE_18_length_811_cov_3.743557_g12_i0	PRJEB6584	18	811	3.743557	30.36024727	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	893	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g12	i0	88.181	114.969173859433	753	83	92	6	56	805	3681191	3681940	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	93240	893	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25660025	25660025	PRJEB6584l_S_NODE_2682_length_322_cov_208.919861_g2530_i0	PRJEB6584	2682	322	208.919861	672.72195242	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	198	3.67e-46	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2530	i0	82.008	62.304347826087	239	37	73	6	1	235	3681372	3681136	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	20062	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25795824	25795824	PRJEB6584i_S_NODE_27_length_726_cov_5.901592_g21_i0	PRJEB6584	27	726	5.901592	42.84555792	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	599	2.0699999999999993e-166	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g21	i0	83.234	74.4173553719008	668	96	91	14	68	726	3680903	3681563	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	54027	599	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25932109	25932109	PRJEB6584i_S_NODE_36_length_645_cov_6.795082_g30_i0	PRJEB6584	36	645	6.795082	43.8282789	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	754	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g30	i0	89.309	239.491472868217	608	55	93	9	41	642	3682389	3681786	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	154472	754	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25932154	25932154	PRJEB6584l_S_NODE_10180_length_205_cov_2.211765_g10028_i0	PRJEB6584	10180	205	2.211765	4.53411825	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	207	3.61e-49	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g10028	i0	91.892	94.9951219512195	148	12	72	0	31	178	3681025	3680878	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	19474	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25932272	25932272	PRJEB6584l_S_NODE_20356_length_162_cov_7.338583_g20204_i0	PRJEB6584	20356	162	7.338583	11.88850446	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	213	5.84e-51	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g20204	i0	90.683	159.08024691358	161	14	99	1	3	162	3682338	3682178	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	25771	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26068004	26068004	PRJEB6584g_S_NODE_29_length_706_cov_740.761550_g22_i0	PRJEB6584	29	706	740.76155	5229.776543	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	726	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g22	i0	86.838	140.70821529745	661	73	93	13	41	694	3682683	3682030	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	99340	726	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26069792	26069792	PRJEB6584p_S_NODE_109_length_522_cov_6.178645_g83_i0	PRJEB6584	109	522	6.178645	32.2525269	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	604	3.129999999999999e-168	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g83	i0	89.091	132.674329501916	495	43	94	10	1	489	3682000	3682489	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	69256	604	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26339683	26339683	PRJEB6584a_S_NODE_303_length_564_cov_10.255198_g292_i0	PRJEB6584	303	564	10.255198	57.83931672	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	521	3.529999999999999e-143	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g292	i0	85.3	328.613475177305	517	63	91	11	15	525	3680711	3681220	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	185338	521	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26340072	26340072	PRJEB6584e_S_NODE_399_length_340_cov_4.062295_g384_i0	PRJEB6584	399	340	4.062295	13.811803	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	344	4.73e-90	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g384	i0	86.378	40.2882352941176	323	35	94	8	17	335	3680903	3681220	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13698	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26341931	26341931	PRJEB6584p_S_NODE_4423_length_208_cov_3.132948_g4392_i0	PRJEB6584	4423	208	3.132948	6.51653184	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	257	3.6e-64	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g4392	i0	89.95	65.0192307692308	199	20	96	0	7	205	3680878	3681076	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13524	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
32911966	32911966	PRJEB6584j_S_NODE_5345_length_200_cov_1.933333_g5316_i0	PRJEB6584	5345	200	1.933333	3.866666	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	63.5	1.72e-10	NR	MBX9724270.1	2364082	g5316	i0	100	0.435	29	0	43.5	0	200	114	142	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	87	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
32929166	32929166	PRJEB6584i_S_NODE_10049_length_155_cov_1.858333_g10037_i0	PRJEB6584	10049	155	1.858333	2.88041615	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	63.9	2.16e-11	NR	PZM84364.1	2052166	g10037	i0	76.3	0.735483870967742	38	9	73.5	0	17	130	78	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	114	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
32929373	32929373	PRJEB6584o_S_NODE_17641_length_213_cov_1.955056_g17533_i0	PRJEB6584	17641	213	1.955056	4.16426928	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	78.6	1.47e-16	NR	MBX9722668.1	2364082	g17533	i0	73.1	0.732394366197183	52	14	73.2	0	1	156	86	137	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	156	78.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
33032287	33032287	PRJEB6584p_S_NODE_52804_length_158_cov_1.626016_g52773_i0	PRJEB6584	52804	158	1.626016	2.56910528	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	63.5	3.18e-11	NR	PZM84364.1	2052166	g52773	i0	76.3	0.721518987341772	38	9	72.2	0	20	133	78	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	114	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
33048421	33048421	PRJEB6584a_S_NODE_7397_length_164_cov_4.720930_g7377_i0	PRJEB6584	7397	164	4.72093	7.7423252	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	48.9	1.82e-5	NR	PZM84364.1	2052166	g7377	i0	64.1	0.713414634146341	39	14	71.3	0	19	135	76	114	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	117	48.9	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);;