metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA312615" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA312615" 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
2339161	2339161	PRJNA312615_P_NODE_34882_length_208_cov_0.867925_g34731_i0	PRJNA312615	34882	208	0.867925	1.8052840000000001	Mesomycoplasma	2923352	Bacteria	Bacteria	359	9.59e-95	NTclustered	gi\|1450419971\|emb\|LS991950.1\|	2100	g34731	i0	97.63	419.600961538462	211	2	100	2	1	208	159455	159245	Mycoplasma hyorhinis strain NCTC10130 genome assembly, chromosome: 1	blastn	87277	359	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
2928783	2928783	PRJNA312615_P_NODE_28843_length_228_cov_1.139665_g28692_i0	PRJNA312615	28843	228	1.139665	2.5984362	Mycoplasma capricolum	2095	Bacteria	Bacteria	178	3.21e-40	NTclustered	gi\|1822115773\|gb\|CP041701.1\|	40480	g28692	i0	82.915	7.85526315789474	199	33	87	1	31	228	334369	334567	Mycoplasma capricolum subsp. capripneumoniae strain 8991 chromosome, complete genome	blastn	1791	178	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma capricolum
3614741	3614741	PRJNA312615_P_NODE_55483_length_164_cov_0.886957_g55332_i0	PRJNA312615	55483	164	0.886957	1.45460948	Mycoplasmopsis	2767358	Bacteria	Bacteria	193	7.73e-45	NTclustered	gi\|1874468068\|gb\|CP058969.1\|	28903	g55332	i0	87.805	52.280487804878	164	20	100	0	1	164	575316	575479	Mycoplasmopsis bovis strain 1982-M6152 chromosome	blastn	8574	193	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
6755656	6755656	PRJNA312615_P_NODE_23106_length_254_cov_0.839024_g22955_i0	PRJNA312615	23106	254	0.839024	2.13112096	Mycoplasma cottewii	51364	Bacteria	Bacteria	359	1.21e-94	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g22955	i0	94.068	0.929133858267717	236	14	93	0	2	237	524074	524309	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	236	359	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
7441606	7441606	PRJNA312615_P_NODE_11466_length_365_cov_1.212025_g11316_i0	PRJNA312615	11466	365	1.212025	4.42389125	Mycoplasma	2093	Bacteria	Bacteria	263	1.47e-65	NTclustered	gi\|1450425804\|emb\|LS991954.1\|	2123	g11316	i0	80.347	3.83835616438356	346	68	95	0	15	360	642209	642554	Mycoplasma putrefaciens strain NCTC10155 genome assembly, chromosome: 1	blastn	1401	263	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma putrefaciens
9992121	9992121	PRJNA312615_P_NODE_38848_length_197_cov_1.054054_g38697_i0	PRJNA312615	38848	197	1.054054	2.07648638	Mesomycoplasma	2923352	Bacteria	Bacteria	329	7.04e-86	NTclustered	gi\|1450419971\|emb\|LS991950.1\|	2100	g38697	i0	98.913	16.507614213198	184	2	93	0	14	197	643303	643486	Mycoplasma hyorhinis strain NCTC10130 genome assembly, chromosome: 1	blastn	3252	329	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
10582015	10582015	PRJNA312615_P_NODE_26009_length_240_cov_1.010471_g25858_i0	PRJNA312615	26009	240	1.010471	2.4251304	Mycoplasma cottewii	51364	Bacteria	Bacteria	276	1.1799999999999998e-69	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g25858	i0	87.983	0.970833333333333	233	28	97	0	3	235	391009	391241	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	233	276	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
14407165	14407165	PRJNA312615_P_NODE_33892_length_210_cov_2.260870_g33741_i0	PRJNA312615	33892	210	2.26087	4.747827	Mesomycoplasma hyorhinis	2100	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|1052538474\|gb\|CP016817.1\|	2100	g33741	i0	100	96.4095238095238	210	0	100	0	1	210	22427	22218	Mesomycoplasma hyorhinis strain MDBK-IPV, complete genome	blastn	20246	388	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
15091606	15091606	PRJNA312615_P_NODE_312_length_1480_cov_3.231307_g267_i0	PRJNA312615	312	1480	3.231307	47.8233436	Mesomycoplasma	2923352	Bacteria	Bacteria	2721	0	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g267	i0	99.865	21.4175675675676	1480	1	100	1	1	1480	646499	647977	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	31698	2721	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
15091818	15091818	PRJNA312615_P_NODE_48272_length_173_cov_1.233871_g48121_i0	PRJNA312615	48272	173	1.233871	2.13459683	Mycoplasma	2093	Bacteria	Bacteria	196	6.339999999999999e-46	NTclustered	gi\|1851159111\|gb\|CP054256.1\|	2102	g48121	i0	87.574	97.6242774566474	169	21	98	0	1	169	1139822	1139990	Mycoplasma mycoides strain T1/44 GP chromosome, complete genome	blastn	16889	196	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma mycoides

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