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

20 rows where bioproject = "PRJNA745553", 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
724046	724046	PRJNA745553_S_NODE_141_length_1342_cov_32.395587_g55_i3	PRJNA745553	141	1342	32.395587	434.74877754	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1496	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g55	i3	87.037	186.256333830104	1350	145	99	28	7	1340	3682282	3680947	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	249956	1496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
724199	724199	PRJNA745553_S_NODE_23361_length_256_cov_1.207650_g23166_i0	PRJNA745553	23361	256	1.20765	3.091584	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	241	4.630000000000001e-59	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g23166	i0	86.547	6.9140625	223	25	86	5	36	255	512805	512585	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	1770	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
2000062	2000062	PRJNA745553_S_NODE_122_length_1399_cov_53.438160_g55_i1	PRJNA745553	122	1399	53.43816	747.5998584	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1515	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g55	i1	86.595	145.075053609721	1395	159	98	25	1	1378	3681296	3682679	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	202960	1515	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
3750326	3750326	PRJNA745553_S_NODE_14663_length_321_cov_7.524194_g14468_i0	PRJNA745553	14663	321	7.524194	24.15266274	Bacteria	2	Bacteria	Bacteria	455	1.96e-123	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g14468	i0	94.295	233.626168224299	298	15	93	2	23	319	596965	596669	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	74994	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
4552553	4552553	PRJNA745553_S_NODE_124_length_1393_cov_47.379545_g55_i2	PRJNA745553	124	1393	47.379545	659.99706185	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1511	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g55	i2	86.633	166.102656137832	1384	164	98	19	23	1393	3682671	3681296	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	231381	1511	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
4552934	4552934	PRJNA745553_S_NODE_6824_length_451_cov_2.515873_g6630_i0	PRJNA745553	6824	451	2.515873	11.34658723	Bacillati	1783272	Bacteria	Bacteria	57.8	4.52e-8	NR	MDR3613109.1	2364082	g6630	i0	93.3	0.991130820399113	30	2	20	0	418	329	1	30	MDR3613109.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	447	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
6302722	6302722	PRJNA745553_S_NODE_29245_length_222_cov_4.442953_g29050_i0	PRJNA745553	29245	222	4.442953	9.86335566	Bacteria	2	Bacteria	Bacteria	220	5.099999999999999e-53	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g29050	i0	91.358	28.6351351351351	162	13	73	1	26	186	1478227	1478388	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	6357	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium MEL.A1
7103026	7103026	PRJNA745553_S_NODE_30126_length_207_cov_4.425373_g29931_i0	PRJNA745553	30126	207	4.425373	9.16052211	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	307	3.5e-79	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g29931	i0	100	3.39130434782609	166	0	80	0	23	188	1224175	1224010	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	702	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
9652686	9652686	PRJNA745553_S_NODE_24228_length_251_cov_2.623596_g24033_i0	PRJNA745553	24228	251	2.623596	6.58522596	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	95.3	3.73e-15	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g24033	i0	93.651	7.43426294820717	63	4	25	0	166	228	4710049	4709987	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	1866	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
14752900	14752900	PRJNA745553_S_NODE_1052_length_761_cov_10.792151_g932_i0	PRJNA745553	1052	761	10.792151	82.12826911	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	833	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g932	i0	87.397	153.49408672798901	730	86	95	6	23	747	3682381	3681653	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	116809	833	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
14753072	14753072	PRJNA745553_S_NODE_20772_length_271_cov_5.176768_g20577_i0	PRJNA745553	20772	271	5.176768	14.02904128	uncultured Gastranaerophilales bacterium	3076055	Bacteria	Bacteria	359	1.31e-94	NTclustered	gi\|2591539818\|gb\|OR657768.1\|	3076055	g20577	i0	98.522	74.1734317343173	203	3	75	0	11	213	99	301	Uncultured Gastranaerophilales bacterium clone CH2 PE 734 16S ribosomal RNA gene, partial sequence	blastn	20101	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales			uncultured Gastranaerophilales bacterium
17302106	17302106	PRJNA745553_S_NODE_11934_length_355_cov_2.024823_g11739_i0	PRJNA745553	11934	355	2.024823	7.18812165	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	424	6.18e-114	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g11739	i0	88.352	124.571830985915	352	41	99	0	1	352	3680598	3680247	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	44223	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
20325102	20325102	PRJNA745553_S_NODE_20176_length_275_cov_3.643564_g19981_i0	PRJNA745553	20176	275	3.643564	10.019801	Bacteria	2	Bacteria	Bacteria	209	1.42e-49	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g19981	i0	84.163	129.516363636364	221	30	79	4	24	241	598758	598540	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	35617	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
23677321	23677321	PRJNA745553_S_NODE_28719_length_227_cov_7.967532_g28524_i0	PRJNA745553	28719	227	7.967532	18.08629764	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	111	1.02e-28	NR	HEY9840994.1	2364082	g28524	i0	96.7	0.79295154185022	60	2	79.3	0	17	196	132	191	HEY9840994.1 sigma-70 family RNA polymerase sigma factor [Candidatus Obscuribacterales bacterium]	diamond	180	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27653154	27653154	PRJNA745553_S_NODE_26104_length_243_cov_5.741176_g25909_i0	PRJNA745553	26104	243	5.741176	13.95105768	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	149	2.5399999999999993e-43	NR	MBN9397140.1	2052166	g25909	i0	98.6	0.901234567901235	73	1	90.1	0	24	242	84	156	MBN9397140.1 hydrogenase nickel incorporation protein HypB [Candidatus Melainabacteria bacterium]	diamond	219	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
27716550	27716550	PRJNA745553_S_NODE_8704_length_408_cov_2.856716_g8509_i0	PRJNA745553	8704	408	2.856716	11.65540128	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	256	1.8e-83	NR	MBK9279865.1	2711154	g8509	i0	84.2	5.81617647058824	133	21	97.8	0	6	404	145	277	MBK9279865.1 c-type cytochrome [Candidatus Obscuribacter sp.]	diamond	2373	256	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28095041	28095041	PRJNA745553_S_NODE_18585_length_286_cov_5.774648_g18390_i0	PRJNA745553	18585	286	5.774648	16.51549328	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	76.3	1.74e-14	NR	MFA7341398.1	2364082	g18390	i0	55.1	0.818181818181818	78	33	79.7	1	271	44	38	115	MFA7341398.1 DUF502 domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	234	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30021322	30021322	PRJNA745553_S_NODE_21691_length_265_cov_8.557292_g21496_i0	PRJNA745553	21691	265	8.557292	22.6768238	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	120	5.11e-33	NR	HMX44475.1	2711154	g21496	i0	90.2	1.3811320754717	61	6	69.1	0	261	79	53	113	HMX44475.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	366	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30874216	30874216	PRJNA745553_S_NODE_4014_length_541_cov_2.801282_g3826_i0	PRJNA745553	4014	541	2.801282	15.15493562	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	251	4.38e-83	NR	MBI5171366.1	2052166	g3826	i0	93.8	0.715341959334566	129	8	71.5	0	435	49	1	129	MBI5171366.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	387	251	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
32770868	32770868	PRJNA745553_S_NODE_29320_length_221_cov_4.418919_g29125_i0	PRJNA745553	29320	221	4.418919	9.76581099	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	82.4	2.97e-16	NR	MBK8219603.1	2711154	g29125	i0	78.4	2.07692307692308	51	11	69.2	0	203	51	837	887	MBK8219603.1 AAA family ATPase [Candidatus Obscuribacter sp.]	diamond	459	82.4	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);;