metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Moraniibacteriota"

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_phylum	tax_species
1877692	1877692	PRJNA630162_P_NODE_125462_length_171_cov_3.442623_g123939_i0	PRJNA630162	125462	171	3.442623	5.88688533	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	80.5	6.57e-11	NTclustered	gi\|2870347126\|gb\|CP175956.1\|	2045217	g123939	i0	89.394	23.046783625731	66	3	37	4	76	139	1081616	1081679	MAG: Candidatus Moraniibacteriota bacterium isolate MKparc2 chromosome, complete genome	blastn	3941	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
1878152	1878152	PRJNA630162_P_NODE_17842_length_441_cov_5.757653_g16336_i0	PRJNA630162	17842	441	5.757653	25.39124973	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	573	7.359999999999999e-159	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g16336	i0	90.531	440.943310657596	433	41	98	0	1	433	203858	203426	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	194456	573	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
3152627	3152627	PRJNA630162_P_NODE_142683_length_166_cov_1.478632_g141160_i0	PRJNA630162	142683	166	1.478632	2.45452912	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	176	7.91e-40	NTclustered	gi\|1958074337\|gb\|CP064994.1\|	2045217	g141160	i0	92.623	72.8915662650602	122	9	73	0	4	125	430670	430791	MAG: Candidatus Moraniibacteriota bacterium isolate Hirt_18-Q3-R61-65_MAXAC.378_cln chromosome, complete genome	blastn	12100	176	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
5705090	5705090	PRJNA630162_P_NODE_117645_length_175_cov_4.214286_g116122_i0	PRJNA630162	117645	175	4.214286	7.3750005	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	230	6.349999999999998e-56	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g116122	i0	90.286	65.5314285714286	175	17	100	0	1	175	203766	203592	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	11468	230	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
5705439	5705439	PRJNA630162_P_NODE_154625_length_163_cov_1.780702_g153102_i0	PRJNA630162	154625	163	1.780702	2.90254426	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	209	7.62e-50	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g153102	i0	90.968	226.251533742331	155	14	95	0	7	161	204975	205129	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	36879	209	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
5706075	5706075	PRJNA630162_P_NODE_55865_length_236_cov_1.433155_g54342_i0	PRJNA630162	55865	236	1.433155	3.3822458	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	246	9.05e-61	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g54342	i0	86.192	303.266949152542	239	20	98	9	6	236	200858	201091	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	71571	246	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
6980392	6980392	PRJNA630162_P_NODE_162786_length_161_cov_2.750000_g161263_i0	PRJNA630162	162786	161	2.75	4.4275	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	89.8	1.02e-13	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g161263	i0	80.672	11.7888198757764	119	19	73	4	5	122	202371	202486	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	1898	89.8	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
6980807	6980807	PRJNA630162_P_NODE_42866_length_271_cov_1.513514_g41343_i0	PRJNA630162	42866	271	1.513514	4.10162294	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	80.5	1.14e-10	NTclustered	gi\|1958074337\|gb\|CP064994.1\|	2045217	g41343	i0	82.292	1.53874538745387	96	13	35	4	54	148	430086	429994	MAG: Candidatus Moraniibacteriota bacterium isolate Hirt_18-Q3-R61-65_MAXAC.378_cln chromosome, complete genome	blastn	417	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
6981310	6981310	PRJNA630162_P_NODE_96646_length_187_cov_4.115942_g95123_i0	PRJNA630162	96646	187	4.115942	7.69681154	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	230	6.8899999999999995e-56	NTclustered	gi\|1958069004\|gb\|CP064989.1\|	2045217	g95123	i0	89.56	70.2299465240642	182	17	97	2	6	187	842249	842428	MAG: Candidatus Moraniibacteriota bacterium isolate Fred_18-Q3-R57-64_MAXAC.421_sub_cln chromosome, complete genome	blastn	13133	230	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
8255316	8255316	PRJNA630162_P_NODE_30987_length_324_cov_3.174545_g29465_i0	PRJNA630162	30987	324	3.174545	10.2855258	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	501	2.51e-137	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g29465	i0	94.984	86.6759259259259	319	16	98	0	6	324	859994	859676	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	28083	501	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
9530209	9530209	PRJNA630162_P_NODE_143228_length_166_cov_1.102564_g141705_i0	PRJNA630162	143228	166	1.102564	1.83025624	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	185	1.3099999999999999e-42	NTclustered	gi\|1958069004\|gb\|CP064989.1\|	2045217	g141705	i0	87.805	118.927710843373	164	13	96	6	6	164	840993	841154	MAG: Candidatus Moraniibacteriota bacterium isolate Fred_18-Q3-R57-64_MAXAC.421_sub_cln chromosome, complete genome	blastn	19742	185	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
12080946	12080946	PRJNA630162_P_NODE_123890_length_172_cov_2.243902_g122367_i0	PRJNA630162	123890	172	2.243902	3.85951144	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	198	1.7499999999999999e-46	NTclustered	gi\|1958029560\|gb\|CP064974.1\|	2045217	g122367	i0	92.701	2.30813953488372	137	10	80	0	31	167	135647	135511	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.267_cln chromosome, complete genome	blastn	397	198	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
13356462	13356462	PRJNA630162_P_NODE_40171_length_280_cov_7.683983_g38648_i0	PRJNA630162	40171	280	7.683983	21.5151524	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	392	1.3399999999999999e-104	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g38648	i0	92.647	190.182142857143	272	20	97	0	2	273	204178	203907	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	53251	392	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
13356546	13356546	PRJNA630162_P_NODE_48031_length_254_cov_4.863415_g46508_i0	PRJNA630162	48031	254	4.863415	12.3530741	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	226	1.2799999999999999e-54	NTclustered	gi\|1958029560\|gb\|CP064974.1\|	2045217	g46508	i0	85.52	257.787401574803	221	27	86	4	3	221	134566	134349	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.267_cln chromosome, complete genome	blastn	65478	226	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
15904905	15904905	PRJNA630162_P_NODE_18593_length_431_cov_4.348168_g17083_i0	PRJNA630162	18593	431	4.348168	18.74060408	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	610	5.469999999999998e-170	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g17083	i0	92.671	128.150812064965	423	31	98	0	9	431	202698	202276	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	55233	610	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
15905473	15905473	PRJNA630162_P_NODE_73053_length_210_cov_2.465839_g71530_i0	PRJNA630162	73053	210	2.465839	5.1782619	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	113	8.33e-21	NTclustered	gi\|1958074337\|gb\|CP064994.1\|	2045217	g71530	i0	79.394	0.785714285714286	165	30	78	4	45	208	429990	430151	MAG: Candidatus Moraniibacteriota bacterium isolate Hirt_18-Q3-R61-65_MAXAC.378_cln chromosome, complete genome	blastn	165	113	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
17179545	17179545	PRJNA630162_P_NODE_126794_length_171_cov_1.450820_g125271_i0	PRJNA630162	126794	171	1.45082	2.4809022	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	130	6.43e-26	NTclustered	gi\|1958074337\|gb\|CP064994.1\|	2045217	g125271	i0	92.308	28.5438596491228	91	7	53	0	6	96	429668	429758	MAG: Candidatus Moraniibacteriota bacterium isolate Hirt_18-Q3-R61-65_MAXAC.378_cln chromosome, complete genome	blastn	4881	130	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
18453854	18453854	PRJNA630162_P_NODE_158975_length_162_cov_1.823009_g157452_i0	PRJNA630162	158975	162	1.823009	2.95327458	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	104	3.67e-18	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g157452	i0	85.185	10.6111111111111	108	9	65	7	26	130	202617	202514	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	1719	104	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
19727953	19727953	PRJNA630162_P_NODE_106636_length_181_cov_3.878788_g105113_i0	PRJNA630162	106636	181	3.878788	7.02060628	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	185	1.4499999999999998e-42	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g105113	i0	89.333	89.9723756906077	150	12	82	3	34	181	200985	201132	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	16285	185	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
22279498	22279498	PRJNA630162_P_NODE_50738_length_247_cov_4.247475_g49215_i0	PRJNA630162	50738	247	4.247475	10.49126325	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	231	2.6699999999999997e-56	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g49215	i0	86.73	26.4089068825911	211	25	84	2	12	219	201969	201759	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	6523	231	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
24828223	24828223	PRJNA630162_P_NODE_172000_length_152_cov_3.145631_g170477_i0	PRJNA630162	172000	152	3.145631	4.78135912	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	174	2.54e-39	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g170477	i0	87.582	110.296052631579	153	16	100	2	1	152	202289	202439	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	16765	174	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
24828453	24828453	PRJNA630162_P_NODE_34660_length_304_cov_3.447059_g33137_i0	PRJNA630162	34660	304	3.447059	10.47905936	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	102	2.77e-17	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g33137	i0	84.112	103.934210526316	107	15	35	2	55	160	202921	202816	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	31596	102	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota 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);;