metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax_phylum = "Mycoplasmatota"

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
322928	322928	PRJNA1196438_P_NODE_19221_length_312_cov_3.142259_g18795_i0	PRJNA1196438	19221	312	3.142259	9.80384808	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	219	2.7199999999999992e-52	NTclustered	gi\|2187152065\|emb\|OV788643.1\|	658143	g18795	i0	93.289	0.823717948717949	149	8	47	2	164	311	767218	767071	uncultured Tenericutes bacterium isolate min17_bin32 genome assembly, chromosome: 1	blastn	257	219	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
322932	322932	PRJNA1196438_P_NODE_20121_length_312_cov_3.012552_g19695_i0	PRJNA1196438	20121	312	3.012552	9.39916224	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	135	2.82e-27	NTclustered	gi\|2040452726\|gb\|CP074573.1\|	2231116	g19695	i0	83.108	13.7083333333333	148	25	47	0	165	312	734671	734524	Tenericutes bacterium strain zrk4 chromosome, complete genome	blastn	4277	135	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
323337	323337	PRJNA1196438_P_NODE_56061_length_264_cov_1.633508_g55634_i0	PRJNA1196438	56061	264	1.633508	4.31246112	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	224	4.8299999999999996e-54	NTclustered	gi\|2621784701\|emb\|OY781159.1\|	1898209	g55634	i0	82.692	67.6136363636364	260	37	97	7	1	256	1195510	1195255	MAG: Acholeplasmataceae bacterium isolate b77914f2-8fec-49c8-ab37-f01becaaac15 genome assembly, chromosome: 1	blastn	17850	224	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
4150217	4150217	PRJNA1196438_P_NODE_56684_length_263_cov_1.642105_g56257_i0	PRJNA1196438	56684	263	1.642105	4.31873615	Mariniplasma anaerobium	2735436	Bacteria	Bacteria	169	2.28e-37	NTclustered	gi\|1964073164\|dbj\|AP024412.1\|	2735436	g56257	i0	80.702	1.23574144486692	228	34	85	9	39	261	1244574	1244796	Mariniplasma anaerobium DNA, complete genome	blastn	325	169	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Mariniplasma	Mariniplasma anaerobium
5426613	5426613	PRJNA1196438_P_NODE_64985_length_252_cov_0.871508_g64558_i0	PRJNA1196438	64985	252	0.871508	2.19620016	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1563802930\|emb\|LR215035.1\|	171279	g64558	i0	97.059	0.26984126984127	34	0	13	1	152	185	107364	107332	Mycoplasma anatis strain NCTC10156 genome assembly, chromosome: 1	blastn	68	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
6701142	6701142	PRJNA1196438_P_NODE_53266_length_268_cov_2.287179_g52839_i0	PRJNA1196438	53266	268	2.287179	6.12963972	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	95.3	4.02e-15	NTclustered	gi\|2907625690\|emb\|OZ223250.1\|	1898209	g52839	i0	86.667	4.55970149253731	90	7	32	5	165	251	521213	521126	MAG: Acholeplasmataceae bacterium isolate c289da16-4743-485f-819d-17f5771af8e7 genome assembly, chromosome: 1	blastn	1222	95.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
9251067	9251067	PRJNA1196438_P_NODE_44948_length_281_cov_1.706731_g44521_i0	PRJNA1196438	44948	281	1.706731	4.79591411	Candidatus Xianfuyuplasma coldseepsis	2782163	Bacteria	Bacteria	158	5.34e-34	NTclustered	gi\|1883609011\|gb\|CP048914.1\|	2782163	g44521	i0	89.147	43.8718861209964	129	10	46	4	98	225	126900	126775	Candidatus Xianfuyuplasma coldseepsis strain zrk13 chromosome, complete genome	blastn	12328	158	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae	Candidatus Xianfuyuplasma	Candidatus Xianfuyuplasma coldseepsis
10526875	10526875	PRJNA1196438_P_NODE_42949_length_284_cov_2.492891_g42522_i0	PRJNA1196438	42949	284	2.492891	7.07981044	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	233	8.719999999999999e-57	NTclustered	gi\|2040452726\|gb\|CP074573.1\|	2231116	g42522	i0	89.362	203.44014084507	188	17	70	2	2	189	2610024	2610208	Tenericutes bacterium strain zrk4 chromosome, complete genome	blastn	57777	233	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
11802257	11802257	PRJNA1196438_P_NODE_88850_length_197_cov_4.241935_g88422_i0	PRJNA1196438	88850	197	4.241935	8.35661195	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	124	3.5599999999999995e-24	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g88422	i0	80.117	1.86294416243655	171	30	86	4	9	177	795474	795642	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	367	124	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
13076789	13076789	PRJNA1196438_P_NODE_47971_length_276_cov_2.536946_g47544_i0	PRJNA1196438	47971	276	2.536946	7.00197096	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	58.4	5.45e-4	NTclustered	gi\|2040452726\|gb\|CP074573.1\|	2231116	g47544	i0	92.5	0.144927536231884	40	3	14	0	77	116	104014	103975	Tenericutes bacterium strain zrk4 chromosome, complete genome	blastn	40	58.4	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
15625693	15625693	PRJNA1196438_P_NODE_20053_length_312_cov_3.016736_g19627_i0	PRJNA1196438	20053	312	3.016736	9.41221632	Candidatus Izemoplasma sp. B36	3242468	Bacteria	Bacteria	141	6.05e-29	NTclustered	gi\|2794178705\|gb\|CP168077.1\|	3242468	g19627	i0	84.615	0.458333333333333	143	20	46	2	6	147	922999	922858	Candidatus Izemoplasma sp. B36 chromosome, complete genome	blastn	143	141	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae	Candidatus Izemoplasma	Candidatus Izemoplasma sp. B36
18174591	18174591	PRJNA1196438_P_NODE_28035_length_301_cov_3.820175_g27609_i0	PRJNA1196438	28035	301	3.820175	11.49872675	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	193	1.58e-44	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g27609	i0	90.541	18.6843853820598	148	10	49	3	151	297	1059527	1059671	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	5624	193	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
18175200	18175200	PRJNA1196438_P_NODE_77035_length_240_cov_3.275449_g76608_i0	PRJNA1196438	77035	240	3.275449	7.8610776	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	78.7	3.56e-10	NTclustered	gi\|2621705280\|emb\|OY763415.1\|	1898209	g76608	i0	88.235	7.2125	68	4	28	4	174	240	829263	829199	MAG: Acholeplasmataceae bacterium isolate 742012ca-395f-4069-aabb-f3199e209540 genome assembly, chromosome: 1	blastn	1731	78.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
19449445	19449445	PRJNA1196438_P_NODE_64096_length_253_cov_0.866667_g63669_i0	PRJNA1196438	64096	253	0.866667	2.19266751	uncultured Mollicutes bacterium	220137	Bacteria	Bacteria	254	5.86e-63	NTclustered	gi\|2187163481\|emb\|OV788639.1\|	220137	g63669	i0	85.2	0.988142292490119	250	34	99	3	1	250	735067	735313	uncultured Mollicutes bacterium isolate min17_bin64 genome assembly, chromosome: 1	blastn	250	254	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				uncultured Mollicutes bacterium
20169590	20169590	PRJNA1196438_P_NODE_42336_length_285_cov_2.193396_g41909_i0	PRJNA1196438	42336	285	2.193396	6.2511786	Acholeplasma	2147	Bacteria	Bacteria	182	3.2199999999999987e-41	NTclustered	gi\|1403529253\|emb\|LS483439.1\|	2148	g41909	i0	80.081	1.72631578947368	246	47	86	2	12	256	435310	435554	Acholeplasma laidlawii strain NCTC10116 genome assembly, chromosome: 1	blastn	492	182	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma laidlawii
23275265	23275265	PRJNA1196438_P_NODE_37079_length_293_cov_3.113636_g36653_i0	PRJNA1196438	37079	293	3.113636	9.12295348	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	433	8.3e-117	NTclustered	gi\|2040452726\|gb\|CP074573.1\|	2231116	g36653	i0	93.243	726.41638225256	296	16	100	4	1	293	2236701	2236995	Tenericutes bacterium strain zrk4 chromosome, complete genome	blastn	212840	433	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
24549030	24549030	PRJNA1196438_P_NODE_1660_length_764_cov_6.188133_g1300_i0	PRJNA1196438	1660	764	6.188133	47.27733612	Mycoplasma corogypsi	2106	Bacteria	Bacteria	54.7	0.021	NTclustered	gi\|2860285583\|gb\|CP174163.1\|	2106	g1300	i0	100	0.0379581151832461	29	0	4	0	545	573	335177	335149	Mycoplasma corogypsi strain BV1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma corogypsi

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