metadata: contig_metadata: 27 rows where bioproject = "PRJNA630162" and tax

27 rows where bioproject = "PRJNA630162" and tax_phylum = "Elusimicrobiota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1878443	1878443	PRJNA630162_P_NODE_43082_length_270_cov_2.194570_g41559_i0	PRJNA630162	43082	270	2.19457	5.925339	Elusimicrobiales bacterium	2478488	Bacteria	Bacteria	80.1	5.91e-16	NR	MBO4556632.1	2478488	g41559	i0	43.7	2.96666666666667	87	49	96.7	0	9	269	39	125	MBO4556632.1 UMP kinase [Elusimicrobiales bacterium]	diamond	801	80.1	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales			Elusimicrobiales bacterium
1878599	1878599	PRJNA630162_P_NODE_56382_length_235_cov_1.096774_g54859_i0	PRJNA630162	56382	235	1.096774	2.5774189	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	390	3.93e-104	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g54859	i0	98.214	56.6212765957447	224	3	95	1	5	227	522854	522631	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	13306	390	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
3152330	3152330	PRJNA630162_P_NODE_109563_length_180_cov_1.396947_g108040_i0	PRJNA630162	109563	180	1.396947	2.5145046	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	233	5.08e-57	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g108040	i0	95.89	13.3388888888889	146	2	97	4	36	179	3536944	3536801	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	2401	233	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
3152771	3152771	PRJNA630162_P_NODE_158123_length_162_cov_3.203540_g156600_i0	PRJNA630162	158123	162	3.20354	5.1897348	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	178	2.13e-40	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g156600	i0	91.045	321.308641975309	134	9	82	2	6	138	581980	582111	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	52052	178	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
4979785	4979785	PRJNA630162_P_NODE_75284_length_207_cov_2.398734_g73761_i0	PRJNA630162	75284	207	2.398734	4.96537938	Elusimicrobium	423604	Bacteria	Bacteria	202	1.6999999999999996e-47	NTclustered	gi\|470483159\|ref\|NR_076577.1\|	423605	g73761	i0	89.375	70.1111111111111	160	17	77	0	43	202	2261	2102	Elusimicrobium minutum strain Pei191 23S ribosomal RNA gene, complete sequence	blastn	14513	202	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Elusimicrobium	Elusimicrobium minutum
8255940	8255940	PRJNA630162_P_NODE_8947_length_642_cov_2.657673_g7584_i0	PRJNA630162	8947	642	2.657673	17.06226066	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	555	3.989999999999999e-153	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g7584	i0	83.802	214.006230529595	605	76	92	19	14	603	581952	582549	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	137392	555	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
8256042	8256042	PRJNA630162_P_NODE_98667_length_186_cov_2.394161_g97144_i0	PRJNA630162	98667	186	2.394161	4.45313946	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	300	5.1400000000000004e-77	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g97144	i0	96.175	28.2795698924731	183	7	98	0	4	186	3537651	3537469	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	5260	300	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
9530553	9530553	PRJNA630162_P_NODE_21688_length_395_cov_3.395954_g20170_i0	PRJNA630162	21688	395	3.395954	13.4140183	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	374	7.1e-99	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g20170	i0	83.92	166.313924050633	398	57	99	6	1	394	522833	523227	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	65694	374	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
12082124	12082124	PRJNA630162_P_NODE_82890_length_198_cov_2.624161_g81367_i0	PRJNA630162	82890	198	2.624161	5.19583878	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	283	5.589999999999999e-72	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g81367	i0	93.229	143.333333333333	192	13	97	0	1	192	129032	129223	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	28380	283	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae		Endomicrobiaceae bacterium
13357052	13357052	PRJNA630162_P_NODE_96751_length_187_cov_3.231884_g95228_i0	PRJNA630162	96751	187	3.231884	6.04362308	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	106	1.21e-18	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g95228	i0	79.874	73.2245989304813	159	21	81	7	35	186	3537794	3537640	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	13693	106	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
14630910	14630910	PRJNA630162_P_NODE_172192_length_152_cov_2.747573_g170669_i0	PRJNA630162	172192	152	2.747573	4.17631096	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	89.8	9.47e-14	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g170669	i0	96.364	61.6447368421053	55	0	36	1	93	147	523894	523946	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	9370	89.8	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
14631610	14631610	PRJNA630162_P_NODE_79532_length_202_cov_1.143791_g78009_i0	PRJNA630162	79532	202	1.143791	2.31045782	Candidatus Endomicrobium sp. MdMp-027	1837116	Bacteria	Bacteria	80.5	8.07e-11	NTclustered	gi\|1069559510\|dbj\|LC153126.1\|	1837116	g78009	i0	87.013	16.0594059405941	77	3	38	6	17	92	1421	1491	Candidatus Endomicrobium sp. MdMp-027 gene for 23S rRNA, partial sequence	blastn	3244	80.5	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobium	Candidatus Endomicrobium sp. MdMp-027
15179905	15179905	PRJNA630162_P_NODE_55772_length_236_cov_1.914439_g54249_i0	PRJNA630162	55772	236	1.914439	4.51807604	Elusimicrobium	423604	Bacteria	Bacteria	215	2.55e-51	NTclustered	gi\|470483159\|ref\|NR_076577.1\|	423605	g54249	i0	83.682	116.029661016949	239	28	99	9	1	233	273	40	Elusimicrobium minutum strain Pei191 23S ribosomal RNA gene, complete sequence	blastn	27383	215	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Elusimicrobium	Elusimicrobium minutum
18453406	18453406	PRJNA630162_P_NODE_10995_length_576_cov_2.891841_g9556_i0	PRJNA630162	10995	576	2.891841	16.65700416	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	568	4.5699999999999985e-157	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g9556	i0	85.714	113.303819444444	560	54	96	16	25	576	523836	523295	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	65263	568	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
18453565	18453565	PRJNA630162_P_NODE_127455_length_170_cov_4.132231_g125932_i0	PRJNA630162	127455	170	4.132231	7.0247927	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	141	2.95e-29	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g125932	i0	93.617	108.323529411765	94	6	55	0	31	124	523893	523986	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	18415	141	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
18454423	18454423	PRJNA630162_P_NODE_50975_length_247_cov_1.398990_g49452_i0	PRJNA630162	50975	247	1.39899	3.4555053	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	411	3.199999999999999e-110	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g49452	i0	97.89	345.894736842105	237	5	96	0	3	239	3536234	3536470	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	85436	411	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
22279669	22279669	PRJNA630162_P_NODE_67098_length_216_cov_1.664671_g65575_i0	PRJNA630162	67098	216	1.664671	3.59568936	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	294	2.87e-75	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g65575	i0	91.628	72.4814814814815	215	14	99	4	1	213	3537305	3537517	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	15656	294	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
24103201	24103201	PRJNA630162_P_NODE_170879_length_153_cov_3.432692_g169356_i0	PRJNA630162	170879	153	3.432692	5.25201876	Elusimicrobium	423604	Bacteria	Bacteria	156	9.29e-34	NTclustered	gi\|470483159\|ref\|NR_076577.1\|	423605	g169356	i0	86.806	31.5816993464052	144	14	93	5	9	151	1581	1442	Elusimicrobium minutum strain Pei191 23S ribosomal RNA gene, complete sequence	blastn	4832	156	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Elusimicrobium	Elusimicrobium minutum
27206819	27206819	PRJNA630162_P_NODE_108022_length_181_cov_1.250000_g106499_i0	PRJNA630162	108022	181	1.25	2.2625	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	59.7	1.1e-8	NR	TPW19817.1	2030800	g106499	i0	51.7	1.92265193370166	58	18	96.1	1	175	2	10	57	TPW19817.1 MAG: glucosylceramidase [Elusimicrobiota bacterium]	diamond	348	59.7	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
28975705	28975705	PRJNA630162_P_NODE_83828_length_197_cov_2.668919_g82305_i0	PRJNA630162	83828	197	2.668919	5.25777043	Elusimicrobia bacterium GWA2_51_34	1797921	Bacteria	Bacteria	78.6	4.76e-15	NR	OGR50143.1	1797921	g82305	i0	92.1	0.578680203045685	38	3	57.9	0	79	192	1	38	OGR50143.1 MAG: succinate dehydrogenase flavoprotein subunit [Elusimicrobia bacterium GWA2_51_34]	diamond	114	78.6	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobia bacterium GWA2_51_34
30870508	30870508	PRJNA630162_P_NODE_123614_length_172_cov_2.772358_g122091_i0	PRJNA630162	123614	172	2.772358	4.76845576	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	102	3.72e-24	NR	MEI8218835.1	2030800	g122091	i0	90.9	1.91860465116279	55	5	95.9	0	167	3	7	61	MEI8218835.1 IS256 family transposase [Elusimicrobiota bacterium]	diamond	330	102	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
31503134	31503134	PRJNA630162_P_NODE_94736_length_189_cov_1.185714_g93213_i0	PRJNA630162	94736	189	1.185714	2.24099946	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	108	1.19e-25	NR	MCX5784412.1	2030800	g93213	i0	85.2	1.93650793650794	61	9	96.8	0	3	185	737	797	MCX5784412.1 tetratricopeptide repeat protein [Elusimicrobiota bacterium]	diamond	366	108	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
31660789	31660789	PRJNA630162_P_NODE_155357_length_163_cov_1.438596_g153834_i0	PRJNA630162	155357	163	1.438596	2.34491148	Elusimicrobia bacterium GWA2_51_34	1797921	Bacteria	Bacteria	105	1.0999999999999998e-24	NR	OGR48815.1	1797921	g153834	i0	86.3	0.938650306748466	51	7	93.9	0	153	1	160	210	OGR48815.1 MAG: hypothetical protein A2X33_10305 [Elusimicrobia bacterium GWA2_51_34]	diamond	153	105	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobia bacterium GWA2_51_34
31724243	31724243	PRJNA630162_P_NODE_80957_length_200_cov_2.331126_g79434_i0	PRJNA630162	80957	200	2.331126	4.662252	Elusimicrobia bacterium GWA2_62_23	1797924	Bacteria	Bacteria	122	1.4e-30	NR	OGR50874.1	1797924	g79434	i0	83.1	0.975	65	11	97.5	0	198	4	142	206	OGR50874.1 MAG: DNA gyrase subunit B, partial [Elusimicrobia bacterium GWA2_62_23]	diamond	195	122	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobia bacterium GWA2_62_23
31787219	31787219	PRJNA630162_P_NODE_100857_length_185_cov_1.610294_g99334_i0	PRJNA630162	100857	185	1.610294	2.9790439	Elusimicrobiaceae bacterium	2735568	Bacteria	Bacteria	87.8	7.360000000000001e-21	NR	MBQ7908474.1	2735568	g99334	i0	83.6	0.891891891891892	55	9	89.2	0	185	21	9	63	MBQ7908474.1 helix-turn-helix domain-containing protein [Elusimicrobiaceae bacterium]	diamond	165	87.8	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae		Elusimicrobiaceae bacterium
32008993	32008993	PRJNA630162_P_NODE_171798_length_152_cov_4.145631_g170275_i0	PRJNA630162	171798	152	4.145631	6.30135912	Endomicrobiales bacterium	2813026	Bacteria	Bacteria	42.7	0.0109	NR	MBN1622424.1	2813026	g170275	i0	55.1	1.63815789473684	49	17	92.8	3	142	2	18	63	MBN1622424.1 caspase family protein [Endomicrobiales bacterium]	diamond	249	42.7	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales			Endomicrobiales bacterium
32180026	32180026	PRJNA630162_P_NODE_46938_length_258_cov_1.330144_g45415_i0	PRJNA630162	46938	258	1.330144	3.43177152	Pseudomonadati	3379134	Bacteria	Bacteria	41.6	0.015	NR	OGR88714.1	1797947	g45415	i0	75	5.73255813953488	20	5	23.3	0	67	8	2	21	OGR88714.1 MAG: cold-shock protein [Elusimicrobia bacterium RIFCSPLOWO2_01_FULL_60_11]	diamond	1479	41.6	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobia bacterium RIFCSPLOWO2_01_FULL_60_11

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