metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax

20 rows where analysis = "blastn", bioproject = "PRJEB64798" 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
127093	127093	PRJEB64798_P_NODE_151641_length_187_cov_12.840580_g149875_i0	PRJEB64798	151641	187	12.84058	24.0118846	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	189	1.17e-43	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g149875	i0	86.022	301.491978609626	186	14	99	6	3	187	523707	523533	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	56379	189	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
127312	127312	PRJEB64798_P_NODE_168301_length_179_cov_7.669231_g166535_i0	PRJEB64798	168301	179	7.669231	13.72792349	Candidatus Endomicrobium sp. MdDo-005	1837115	Bacteria	Bacteria	135	1.46e-27	NTclustered	gi\|1069559645\|dbj\|LC153660.1\|	1837115	g166535	i0	81.006	79.0111731843575	179	26	97	6	5	177	705	529	Candidatus Endomicrobium sp. MdDo-005 gene for 23S rRNA, partial sequence	blastn	14143	135	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobium	Candidatus Endomicrobium sp. MdDo-005
1402429	1402429	PRJEB64798_P_NODE_203162_length_166_cov_8.974359_g201396_i0	PRJEB64798	203162	166	8.974359	14.89743594	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	132	1.74e-26	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g201396	i0	82.781	0.909638554216867	151	23	90	3	18	166	395913	396062	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	151	132	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
1403030	1403030	PRJEB64798_P_NODE_245142_length_153_cov_6.769231_g243376_i0	PRJEB64798	245142	153	6.7692310000000004	10.35692343	Endomicrobium proavitum	1408281	Bacteria	Bacteria	91.6	2.66e-14	NTclustered	gi\|831251027\|gb\|CP009498.1\|	1408281	g243376	i0	82.407	1.3921568627451	108	16	69	1	5	109	964329	964436	Endomicrobium proavitum strain Rsa215, complete genome	blastn	213	91.6	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobium	Endomicrobium proavitum
2676918	2676918	PRJEB64798_P_NODE_129163_length_198_cov_12.053691_g127397_i0	PRJEB64798	129163	198	12.053691	23.86630818	Endomicrobiaceae bacterium	2775028	Bacteria	Bacteria	128	2.77e-25	NTclustered	gi\|2621703984\|emb\|OY762939.1\|	2775028	g127397	i0	82.55	62.9393939393939	149	23	74	3	17	163	131017	131164	MAG: Endomicrobiaceae bacterium isolate b7fdffbc-12ed-482e-887b-d6703ec4e3ab genome assembly, chromosome: 1	blastn	12462	128	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae		Endomicrobiaceae bacterium
2677766	2677766	PRJEB64798_P_NODE_184843_length_172_cov_5.593496_g183077_i0	PRJEB64798	184843	172	5.593496	9.62081312	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	182	1.76e-41	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g183077	i0	86.391	87.6279069767442	169	20	98	3	1	168	581843	581677	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	15072	182	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
3954244	3954244	PRJEB64798_P_NODE_219284_length_162_cov_4.212389_g217518_i0	PRJEB64798	219284	162	4.212389	6.82407018	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	176	7.67e-40	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g217518	i0	87.742	51.3456790123457	155	13	92	4	9	157	582002	581848	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	8318	176	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
3955527	3955527	PRJEB64798_P_NODE_68244_length_234_cov_11.470270_g66479_i0	PRJEB64798	68244	234	11.47027	26.8404318	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	219	1.9499999999999993e-52	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g66479	i0	84.12	50.5897435897436	233	29	97	5	5	232	582111	581882	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	11838	219	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
4821279	4821279	PRJEB64798_P_NODE_225984_length_160_cov_4.729730_g224218_i0	PRJEB64798	225984	160	4.72973	7.567568	Elusimicrobium	423604	Bacteria	Bacteria	100	4.67e-17	NTclustered	gi\|470483159\|ref\|NR_076577.1\|	423605	g224218	i0	79.605	2.84375	152	21	94	8	2	152	1926	1784	Elusimicrobium minutum strain Pei191 23S ribosomal RNA gene, complete sequence	blastn	455	100	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Elusimicrobium	Elusimicrobium minutum
6506208	6506208	PRJEB64798_P_NODE_208106_length_165_cov_3.206897_g206340_i0	PRJEB64798	208106	165	3.206897	5.29138005	uncultured Endomicrobiales bacterium	3063312	Bacteria	Bacteria	237	3.5500000000000004e-58	NTclustered	gi\|2557661049\|gb\|OR396543.1\|	3063312	g206340	i0	93.21	94.2787878787879	162	9	98	2	5	165	19	179	Uncultured Endomicrobiales bacterium clone Fux382_unbinned&&k119_294643 16S ribosomal RNA gene, partial sequence	blastn	15556	237	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales			uncultured Endomicrobiales bacterium
6506262	6506262	PRJEB64798_P_NODE_211166_length_164_cov_5.704348_g209400_i0	PRJEB64798	211166	164	5.704348	9.35513072	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	128	2.21e-25	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g209400	i0	81.935	78.3719512195122	155	25	93	2	7	159	3536024	3535871	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	12853	128	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
7780956	7780956	PRJEB64798_P_NODE_249207_length_152_cov_3.640777_g247441_i0	PRJEB64798	249207	152	3.640777	5.53398104	Candidatus Endomicrobium sp. MdDo-005	1837115	Bacteria	Bacteria	174	2.54e-39	NTclustered	gi\|1069559645\|dbj\|LC153660.1\|	1837115	g247441	i0	87.838	38	148	18	97	0	3	150	2882	2735	Candidatus Endomicrobium sp. MdDo-005 gene for 23S rRNA, partial sequence	blastn	5776	174	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobium	Candidatus Endomicrobium sp. MdDo-005
7781596	7781596	PRJEB64798_P_NODE_56767_length_259_cov_2.442857_g55002_i0	PRJEB64798	56767	259	2.442857	6.32699963	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	346	9.66e-91	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g55002	i0	91.12	151.814671814672	259	18	99	5	2	258	582019	582274	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	39320	346	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
9056018	9056018	PRJEB64798_P_NODE_33828_length_339_cov_6.648276_g32070_i0	PRJEB64798	33828	339	6.648276	22.53765564	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	429	1.27e-115	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g32070	i0	90.244	109.725663716814	328	32	97	0	2	329	582757	582430	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	37197	429	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
9056079	9056079	PRJEB64798_P_NODE_37508_length_322_cov_18.564103_g35748_i0	PRJEB64798	37508	322	18.564103	59.77641166	Candidatus Avelusimicrobium excrementipullorum	2840689	Bacteria	Bacteria	122	2.2699999999999994e-23	NTclustered	gi\|2729058677\|emb\|OZ006977.1\|	2840689	g35748	i0	84.677	38.8198757763975	124	17	38	2	5	127	521599	521477	MAG: Candidatus Avelusimicrobium excrementipullorum isolate metabat2_pooled_hifiasm.129_sub MAG genome assembly, chromosome: 1	blastn	12500	122	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Candidatus Avelusimicrobium	Candidatus Avelusimicrobium excrementipullorum
16706550	16706550	PRJEB64798_P_NODE_95994_length_212_cov_4.030675_g94228_i0	PRJEB64798	95994	212	4.030675	8.545031	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	237	4.79e-58	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g94228	i0	88.119	72.1603773584906	202	21	95	2	2	202	581844	581645	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	15298	237	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
19254169	19254169	PRJEB64798_P_NODE_252016_length_151_cov_4.460784_g250250_i0	PRJEB64798	252016	151	4.460784	6.73578384	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	147	5.489999999999999e-31	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g250250	i0	84.768	37.2582781456954	151	18	98	4	4	151	582914	583062	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	5626	147	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia bacterium
23078578	23078578	PRJEB64798_P_NODE_115899_length_208_cov_8.144654_g114133_i0	PRJEB64798	115899	208	8.144654	16.94088032	Elusimicrobium minutum	423605	Bacteria	Bacteria	65.8	2.34e-6	NTclustered	gi\|186970583\|gb\|CP001055.1\|	445932	g114133	i0	93.182	0.211538461538462	44	3	21	0	115	158	781414	781457	Elusimicrobium minutum Pei191, complete genome	blastn	44	65.8	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Elusimicrobium	Elusimicrobium minutum
23078705	23078705	PRJEB64798_P_NODE_123959_length_203_cov_4.376623_g122193_i0	PRJEB64798	123959	203	4.376623	8.88454469	Candidatus Endomicrobium sp. MdMp-027	1837116	Bacteria	Bacteria	158	3.6399999999999997e-34	NTclustered	gi\|1069559510\|dbj\|LC153126.1\|	1837116	g122193	i0	81	43.1970443349754	200	36	98	2	1	199	442	640	Candidatus Endomicrobium sp. MdMp-027 gene for 23S rRNA, partial sequence	blastn	8769	158	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobium	Candidatus Endomicrobium sp. MdMp-027
24353287	24353287	PRJEB64798_P_NODE_173560_length_177_cov_3.601562_g171794_i0	PRJEB64798	173560	177	3.601562	6.37476474	uncultured Elusimicrobia bacterium	699876	Bacteria	Bacteria	226	8.329999999999998e-55	NTclustered	gi\|2874253783\|emb\|OY969767.1\|	699876	g171794	i0	91.071	365.214689265537	168	14	95	1	4	171	583672	583838	MAG: uncultured Elusimicrobia bacterium isolate MFD00032.bin.c.1 genome assembly, chromosome: 1	blastn	64643	226	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia				uncultured Elusimicrobia 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);;