metadata: contig_metadata: 24 rows where bioproject = "PRJNA492363" and tax

24 rows where bioproject = "PRJNA492363" 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
25565706	25565706	PRJNA492363_S_NODE_11841_length_283_cov_1.153153_g11020_i0	PRJNA492363	11841	283	1.153153	3.26342299	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	518	2.14e-142	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g11020	i0	99.647	1	283	1	100	0	1	283	4116664	4116382	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	283	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25566850	25566850	PRJNA492363_S_NODE_75857_length_219_cov_1.620253_g75036_i0	PRJNA492363	75857	219	1.620253	3.54835407	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g75036	i0	100	1	219	0	100	0	1	219	4663557	4663339	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	219	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25701964	25701964	PRJNA492363_S_NODE_13802_length_267_cov_0.907767_g12981_i0	PRJNA492363	13802	267	0.907767	2.42373789	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	483	7.31e-132	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g12981	i0	99.251	1	267	2	100	0	1	267	48345	48611	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	267	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25703101	25703101	PRJNA492363_S_NODE_80642_length_213_cov_1.263158_g79821_i0	PRJNA492363	80642	213	1.263158	2.69052654	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	137	9.2e-37	NR	HIA52582.1	2052166	g79821	i0	100	1.97183098591549	70	0	98.6	0	3	212	307	376	HIA52582.1 type II/IV secretion system protein [Candidatus Melainabacteria bacterium]	diamond	420	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25837755	25837755	PRJNA492363_S_NODE_100947_length_201_cov_0.914286_g100126_i0	PRJNA492363	100947	201	0.914286	1.83771486	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g100126	i0	100	1	201	0	100	0	1	201	307500	307700	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	201	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26111362	26111362	PRJNA492363_S_NODE_77941_length_217_cov_1.205128_g77120_i0	PRJNA492363	77941	217	1.205128	2.61512776	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	381	2.1499999999999995e-101	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g77120	i0	98.605	0.990783410138249	215	3	99	0	1	215	851126	850912	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	215	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26111624	26111624	PRJNA492363_S_NODE_89621_length_207_cov_1.315068_g88800_i0	PRJNA492363	89621	207	1.315068	2.72219076	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	377	2.63e-100	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g88800	i0	99.517	1	207	1	100	0	1	207	3710543	3710749	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	207	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26111638	26111638	PRJNA492363_S_NODE_89877_length_207_cov_0.876712_g89056_i0	PRJNA492363	89877	207	0.876712	1.81479384	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g89056	i0	100	1	207	0	100	0	1	207	3596452	3596658	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	207	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26111657	26111657	PRJNA492363_S_NODE_91237_length_206_cov_1.937931_g90416_i0	PRJNA492363	91237	206	1.937931	3.99213786	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	298	2.09e-76	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g90416	i0	98.802	212.854368932039	167	2	81	0	1	167	1501162	1501328	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	43848	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26111808	26111808	PRJNA492363_S_NODE_96933_length_203_cov_1.352113_g96112_i0	PRJNA492363	96933	203	1.352113	2.74478939	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g96112	i0	100	1	203	0	100	0	1	203	4055764	4055562	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	203	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26246599	26246599	PRJNA492363_S_NODE_15774_length_256_cov_0.984615_g14953_i0	PRJNA492363	15774	256	0.984615	2.5206144	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	468	1.95e-127	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g14953	i0	99.609	1	256	1	100	0	1	256	4985748	4985493	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	256	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26247640	26247640	PRJNA492363_S_NODE_81390_length_212_cov_1.701987_g80569_i0	PRJNA492363	81390	212	1.701987	3.60821244	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	387	4.5e-103	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g80569	i0	99.528	1	212	1	100	0	1	212	4264090	4263879	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	212	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26247965	26247965	PRJNA492363_S_NODE_94902_length_204_cov_1.790210_g94081_i0	PRJNA492363	94902	204	1.79021	3.6520284	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	372	1.2e-98	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g94081	i0	99.51	1.1421568627451	204	1	100	0	1	204	4021604	4021401	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	233	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26441373	26441373	PRJNA492363_S_NODE_1455_length_993_cov_2.683476_g708_i0	PRJNA492363	1455	993	2.683476	26.64691668	Candidatus Caenarcanales bacterium	2729995	Bacteria	Bacteria	243	4.36e-75	NR	HEY9846051.1	2729995	g708	i0	45.9	8.36555891238671	279	130	83.7	3	838	8	1	260	HEY9846051.1 IS630 family transposase [Candidatus Caenarcanales bacterium]	diamond	8307	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
26519771	26519771	PRJNA492363_S_NODE_86136_length_209_cov_0.864865_g85315_i0	PRJNA492363	86136	209	0.864865	1.80756785	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	387	4.42e-103	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g85315	i0	100	1	209	0	100	0	1	209	2673041	2673249	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	209	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26520104	26520104	PRJNA492363_S_NODE_99032_length_202_cov_0.907801_g98211_i0	PRJNA492363	99032	202	0.907801	1.83375802	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	329	7.25e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g98211	i0	96.04	1	202	8	100	0	1	202	1496001	1495800	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	202	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32941428	32941428	PRJNA492363_S_NODE_89665_length_207_cov_1.315068_g88844_i0	PRJNA492363	89665	207	1.315068	2.72219076	Bacteria	2	Bacteria	Bacteria	135	9.71e-39	NR	HNB23978.1	2052166	g88844	i0	95.7	2	69	3	100	0	1	207	10	78	HNB23978.1 GDP-mannose 4,6-dehydratase [Candidatus Melainabacteria bacterium]	diamond	414	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32969547	32969547	PRJNA492363_S_NODE_100794_length_201_cov_1.371429_g99973_i0	PRJNA492363	100794	201	1.371429	2.75657229	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	115	4.72e-30	NR	MCC7531366.1	2052166	g99973	i0	95.1	0.91044776119403	61	3	91	0	1	183	161	221	MCC7531366.1 HAMP domain-containing histidine kinase [Candidatus Melainabacteria bacterium]	diamond	183	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32992695	32992695	PRJNA492363_S_NODE_95283_length_204_cov_0.895105_g94462_i0	PRJNA492363	95283	204	0.895105	1.8260142	Bacillati	1783272	Bacteria	Bacteria	52.8	6.06e-6	NR	HEY9845660.1	2729995	g94462	i0	93.5	0.911764705882353	31	2	45.6	0	3	95	290	320	HEY9845660.1 carbohydrate kinase [Candidatus Caenarcanales bacterium]	diamond	186	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
33003497	33003497	PRJNA492363_S_NODE_101171_length_201_cov_0.914286_g100350_i0	PRJNA492363	101171	201	0.914286	1.83771486	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	92.4	5.110000000000001e-21	NR	MFA7339893.1	2364082	g100350	i0	85.5	0.82089552238806	55	8	82.1	0	199	35	191	245	MFA7339893.1 nucleoside monophosphate kinase [Candidatus Obscuribacterales bacterium]	diamond	165	92.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33026858	33026858	PRJNA492363_S_NODE_95228_length_204_cov_0.895105_g94407_i0	PRJNA492363	95228	204	0.895105	1.8260142	Bacillati	1783272	Bacteria	Bacteria	77	1.23e-14	NR	MBX3073290.1	2364082	g94407	i0	53.7	3.83823529411765	67	31	98.5	0	202	2	102	168	MBX3073290.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	783	77.4	0.994832041343669	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33089039	33089039	PRJNA492363_S_NODE_82462_length_211_cov_1.706667_g81641_i0	PRJNA492363	82462	211	1.706667	3.60106737	Candidatus Caenarcanales bacterium	2729995	Bacteria	Bacteria	122	2.95e-33	NR	NQY81459.1	2729995	g81641	i0	82.6	0.981042654028436	69	12	98.1	0	209	3	125	193	NQY81459.1 transposase [Candidatus Caenarcanales bacterium]	diamond	207	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
33157072	33157072	PRJNA492363_S_NODE_63496_length_227_cov_0.993976_g62675_i0	PRJNA492363	63496	227	0.993976	2.25632552	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	128	1.96e-32	NR	MBK7841819.1	2711154	g62675	i0	89.3	0.991189427312775	75	8	99.1	0	225	1	539	613	MBK7841819.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	225	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
33174489	33174489	PRJNA492363_S_NODE_97248_length_203_cov_0.901408_g96427_i0	PRJNA492363	97248	203	0.901408	1.82985824	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	125	1.34e-33	NR	PZM78327.1	2052166	g96427	i0	89.6	0.990147783251232	67	7	99	0	203	3	166	232	PZM78327.1 MAG: hypothetical protein DKT66_24160 [Candidatus Melainabacteria bacterium]	diamond	201	125	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);;