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

20 rows where bioproject = "PRJNA785164", 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_order	tax_family	tax_genus	tax_species
3317674	3317674	PRJNA785164_P_NODE_47803_length_260_cov_1.406417_g47338_i0	PRJNA785164	47803	260	1.406417	3.6566842	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	171	2.7599999999999996e-47	NR	HIA54889.1	2052166	g47338	i0	90.7	0.992307692307692	86	8	99.2	0	260	3	168	253	HIA54889.1 glucosidase [Candidatus Melainabacteria bacterium]	diamond	258	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
21168791	21168791	PRJNA785164_P_NODE_43417_length_273_cov_2.435000_g42952_i0	PRJNA785164	43417	273	2.435	6.64755	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	140	6.6000000000000005e-37	NR	HEY9793245.1	2364082	g42952	i0	78	1	91	18	97.8	1	4	270	1	91	HEY9793245.1 translational GTPase TypA [Candidatus Obscuribacterales bacterium]	diamond	273	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
22443893	22443893	PRJNA785164_P_NODE_54638_length_248_cov_0.880000_g54173_i0	PRJNA785164	54638	248	0.88	2.1824	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	196	9.79e-46	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g54173	i0	81.148	0.983870967741935	244	46	98	0	5	248	3769411	3769168	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	244	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
26642082	26642082	PRJNA785164_P_NODE_36541_length_299_cov_1.362832_g36076_i0	PRJNA785164	36541	299	1.362832	4.07486768	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	153	1.5e-41	NR	MBX3137679.1	2364082	g36076	i0	100	0.782608695652174	78	0	78.3	0	299	66	460	537	MBX3137679.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	234	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27085332	27085332	PRJNA785164_P_NODE_54322_length_248_cov_0.880000_g53857_i0	PRJNA785164	54322	248	0.88	2.1824	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	97.8	9.95e-23	NR	PZM84038.1	2052166	g53857	i0	100	1.23387096774194	51	0	61.7	0	154	2	1	51	PZM84038.1 MAG: sulfite exporter TauE/SafE family protein [Candidatus Melainabacteria bacterium]	diamond	306	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
27600232	27600232	PRJNA785164_P_NODE_52584_length_250_cov_0.870056_g52119_i0	PRJNA785164	52584	250	0.870056	2.17514	Bacillati	1783272	Bacteria	Bacteria	89.7	1.2e-18	NR	MBK7750232.1	2711154	g52119	i0	64	2.064	86	26	99.6	2	1	249	520	603	MBK7750232.1 DUF3160 domain-containing protein [Candidatus Obscuribacter sp.]	diamond	516	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27938185	27938185	PRJNA785164_P_NODE_54305_length_248_cov_0.880000_g53840_i0	PRJNA785164	54305	248	0.88	2.1824	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	105	8.99e-25	NR	MBX9571860.1	2364082	g53840	i0	65	0.967741935483871	80	28	96.8	0	245	6	265	344	MBX9571860.1 serine protease [Candidatus Obscuribacterales bacterium]	diamond	240	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28474904	28474904	PRJNA785164_P_NODE_61246_length_242_cov_0.911243_g60781_i0	PRJNA785164	61246	242	0.911243	2.20520806	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	126	1.61e-32	NR	MBP6349275.1	2711154	g60781	i0	96.8	0.78099173553719	63	2	78.1	0	1	189	345	407	MBP6349275.1 flavodoxin-dependent (E)-4-hydroxy-3-methylbut-2-enyl-diphosphate synthase [Candidatus Obscuribacter sp.]	diamond	189	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28664372	28664372	PRJNA785164_P_NODE_60187_length_243_cov_0.894118_g59722_i0	PRJNA785164	60187	243	0.894118	2.17270674	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	99.8	2.21e-24	NR	PZM78494.1	2052166	g59722	i0	100	0.62962962962963	51	0	63	0	242	90	117	167	PZM78494.1 MAG: hypothetical protein DKT66_23885 [Candidatus Melainabacteria bacterium]	diamond	153	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
29011938	29011938	PRJNA785164_P_NODE_62188_length_241_cov_0.916667_g61723_i0	PRJNA785164	62188	241	0.916667	2.20916747	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	75.5	9.61e-14	NR	MDZ4835435.1	2052166	g61723	i0	58.8	0.995850622406639	80	29	99.6	1	2	241	333	408	MDZ4835435.1 molecular chaperone DnaJ [Candidatus Melainabacteria bacterium]	diamond	240	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
29043347	29043347	PRJNA785164_P_NODE_55148_length_247_cov_1.327586_g54683_i0	PRJNA785164	55148	247	1.327586	3.27913742	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	115	8.84e-28	NR	MBX9571393.1	2364082	g54683	i0	67.9	0.983805668016194	81	26	98.4	0	245	3	454	534	MBX9571393.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	243	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29074968	29074968	PRJNA785164_P_NODE_53688_length_249_cov_0.875000_g53223_i0	PRJNA785164	53688	249	0.875	2.17875	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	74.7	2.15e-13	NR	HEY9793785.1	2364082	g53223	i0	72.5	0.614457831325301	51	14	61.4	0	1	153	82	132	HEY9793785.1 cytochrome c biogenesis protein ResB [Candidatus Obscuribacterales bacterium]	diamond	153	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30811904	30811904	PRJNA785164_P_NODE_54814_length_248_cov_0.880000_g54349_i0	PRJNA785164	54814	248	0.88	2.1824	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	65.1	5.19e-10	NR	MBX9568515.1	2364082	g54349	i0	51.4	0.895161290322581	74	35	89.5	1	25	246	57	129	MBX9568515.1 matrixin family metalloprotease [Candidatus Obscuribacterales bacterium]	diamond	222	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31064969	31064969	PRJNA785164_P_NODE_38895_length_289_cov_1.416667_g38430_i0	PRJNA785164	38895	289	1.416667	4.09416763	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	161	1.49e-44	NR	MBN9394194.1	2052166	g38430	i0	100	0.8719723183391	84	0	87.2	0	1	252	494	577	MBN9394194.1 DUF4388 domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	252	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
31159136	31159136	PRJNA785164_P_NODE_31535_length_325_cov_0.916667_g31070_i0	PRJNA785164	31535	325	0.916667	2.97916775	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	210	3.31e-67	NR	MBK7837811.1	2711154	g31070	i0	99	1.80923076923077	98	1	90.5	0	295	2	1	98	MBK7837811.1 4Fe-4S dicluster domain-containing protein [Candidatus Obscuribacter sp.]	diamond	588	210	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31349360	31349360	PRJNA785164_P_NODE_45776_length_266_cov_1.248705_g45311_i0	PRJNA785164	45776	266	1.248705	3.3215553	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	163	1.7900000000000001e-44	NR	MBX9569874.1	2364082	g45311	i0	96.5	4.87218045112782	86	3	97	0	7	264	36	121	MBX9569874.1 efflux RND transporter permease subunit [Candidatus Obscuribacterales bacterium]	diamond	1296	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31412517	31412517	PRJNA785164_P_NODE_57556_length_245_cov_0.895349_g57091_i0	PRJNA785164	57556	245	0.895349	2.19360505	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	120	1.13e-32	NR	MBX9568421.1	2364082	g57091	i0	68.8	0.979591836734694	80	25	98	0	241	2	8	87	MBX9568421.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	240	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31507582	31507582	PRJNA785164_P_NODE_59656_length_243_cov_0.905882_g59191_i0	PRJNA785164	59656	243	0.905882	2.20129326	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	114	1.7600000000000003e-27	NR	MBX9572628.1	2364082	g59191	i0	69.1	1	81	25	100	0	243	1	104	184	MBX9572628.1 serine/threonine protein kinase [Candidatus Obscuribacterales bacterium]	diamond	243	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32330247	32330247	PRJNA785164_P_NODE_54279_length_248_cov_0.880000_g53814_i0	PRJNA785164	54279	248	0.88	2.1824	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	108	1.96e-26	NR	MBX9567497.1	2364082	g53814	i0	60.2	1.00403225806452	83	31	98	2	248	6	191	273	MBX9567497.1 c-type cytochrome [Candidatus Obscuribacterales bacterium]	diamond	249	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32465950	32465950	PRJNA785164_P_NODE_60619_length_242_cov_0.988166_g60154_i0	PRJNA785164	60619	242	0.988166	2.39136172	Bacillati	1783272	Bacteria	Bacteria	43.1	0.0194	NR	MBN8661016.1	1906157	g60154	i0	42	3.09917355371901	50	29	62	0	154	5	25	74	MBN8661016.1 hypothetical protein [Candidatus Obscuribacter phosphatis]	diamond	750	43.5	0.990804597701149	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter phosphatis

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