metadata: contig_metadata: 15 rows where bioproject = "PRJNA488043" and tax

15 rows where bioproject = "PRJNA488043" 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_family	tax_genus	tax_species
14478443	14478443	PRJNA488043_P_NODE_20112_length_170_cov_4.638298_g17870_i0	PRJNA488043	20112	170	4.638298	7.8851066	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	254	3.63e-63	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17870	i0	93.567	1.00588235294118	171	9	100	2	1	170	197652	197483	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	171	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
17027153	17027153	PRJNA488043_P_NODE_20114_length_170_cov_4.361702_g17872_i0	PRJNA488043	20114	170	4.361702	7.4148934	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	254	3.63e-63	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17872	i0	93.567	1.00588235294118	171	9	100	2	1	170	197652	197483	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	171	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26791597	26791597	PRJNA488043_P_NODE_21541_length_158_cov_2.038760_g19299_i0	PRJNA488043	21541	158	2.03876	3.2212408	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	105	2.1e-26	NR	MBK9774680.1	2711154	g19299	i0	96.2	0.987341772151899	52	2	98.7	0	158	3	11	62	MBK9774680.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	156	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27139181	27139181	PRJNA488043_P_NODE_8622_length_388_cov_2.437326_g6408_i0	PRJNA488043	8622	388	2.437326	9.45682488	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	182	1.37e-56	NR	MBK9774683.1	2711154	g6408	i0	98.9	0.672680412371134	87	1	67.3	0	1	261	17	103	MBK9774683.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	261	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27803025	27803025	PRJNA488043_P_NODE_22044_length_154_cov_1.888000_g19802_i0	PRJNA488043	22044	154	1.888	2.90752	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	98.6	9.4e-24	NR	MBK9774680.1	2711154	g19802	i0	98	0.974025974025974	50	1	97.4	0	3	152	120	169	MBK9774680.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	150	98.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28402795	28402795	PRJNA488043_P_NODE_15066_length_227_cov_1.727273_g12824_i0	PRJNA488043	15066	227	1.727273	3.92090971	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	58.5	8.12e-8	NR	HEY9885974.1	2692181	g12824	i0	43.8	1.95594713656388	73	38	96.5	2	227	9	645	714	HEY9885974.1 VapE domain-containing protein [Vampirovibrionales bacterium]	diamond	444	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
28766051	28766051	PRJNA488043_P_NODE_12687_length_267_cov_3.016807_g10446_i0	PRJNA488043	12687	267	3.016807	8.05487469	Bacteria	2	Bacteria	Bacteria	49.3	8.42e-5	NR	MFA6213535.1	2364082	g10446	i0	49.1	0.966292134831461	55	22	55.1	1	267	121	24	78	MFA6213535.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	258	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28876331	28876331	PRJNA488043_P_NODE_19368_length_178_cov_4.798658_g17126_i0	PRJNA488043	19368	178	4.798658	8.54161124	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	57.8	7.81e-9	NR	PZM84364.1	2052166	g17126	i0	67.5	0.674157303370786	40	13	67.4	0	46	165	77	116	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	120	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29823381	29823381	PRJNA488043_P_NODE_20651_length_165_cov_2.566176_g18409_i0	PRJNA488043	20651	165	2.566176	4.2341904	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	103	2.15e-27	NR	MBK9774685.1	2711154	g18409	i0	96.1	0.927272727272727	51	2	92.7	0	13	165	1	51	MBK9774685.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	153	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30044616	30044616	PRJNA488043_P_NODE_20091_length_171_cov_1.598592_g17849_i0	PRJNA488043	20091	171	1.598592	2.73359232	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	100	3.99e-25	NR	MBK9774682.1	2711154	g17849	i0	96.4	0.964912280701754	55	2	96.5	0	166	2	67	121	MBK9774682.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	165	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30518665	30518665	PRJNA488043_P_NODE_19213_length_179_cov_6.346667_g16971_i0	PRJNA488043	19213	179	6.346667	11.36053393	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	47.8	1.91e-5	NR	MBX9722867.1	2364082	g16971	i0	62.5	0.670391061452514	40	15	67	0	36	155	11	50	MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	120	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31466977	31466977	PRJNA488043_P_NODE_16696_length_206_cov_1.977401_g14454_i0	PRJNA488043	16696	206	1.977401	4.07344606	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	129	2.86e-35	NR	MBK9774680.1	2711154	g14454	i0	98.5	0.975728155339806	67	1	97.6	0	1	201	172	238	MBK9774680.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	201	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31767479	31767479	PRJNA488043_P_NODE_20737_length_164_cov_6.074074_g18495_i0	PRJNA488043	20737	164	6.074074	9.96148136	Bacteria	2	Bacteria	Bacteria	42	0.00887	NR	PZM84364.1	2052166	g18495	i0	73.1	1.15243902439024	26	7	47.6	0	3	80	67	92	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	189	42.4	0.990566037735849	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32542681	32542681	PRJNA488043_P_NODE_15379_length_222_cov_2.455959_g13137_i0	PRJNA488043	15379	222	2.455959	5.45222898	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	46.6	0.00123	NR	MDD3437621.1	2137880	g13137	i0	56.1	0.554054054054054	41	18	55.4	0	126	4	1	41	MDD3437621.1 hypothetical protein [Candidatus Gastranaerophilales bacterium]	diamond	123	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
32731594	32731594	PRJNA488043_P_NODE_7900_length_420_cov_2.132992_g5716_i0	PRJNA488043	7900	420	2.1329920000000002	8.9585664	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	128	5.529999999999998e-35	NR	MBK9774683.1	2711154	g5716	i0	92.2	0.457142857142857	64	5	45.7	0	3	194	31	94	MBK9774683.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	192	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter 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);;