RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1046144" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1046144 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
12925882 12925882 PRJNA1046144_P_NODE_32991_length_294_cov_5.093333_g32696_i0 PRJNA1046144 32991 294 5.093333 14.97439902 Mycoplasma sp. HU2 2108 Bacteria Bacteria 179 2.5099999999999996e-55   NR WP_235443306.1 1664275 g32696 i0 95.8 0.969387755102041 95 4 96.9 0 293 9 42 136 WP_235443306.1 EGFR-like transmembrane domain-containing protein, partial [Mycoplasma sp. HU2014] diamond 285 179 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
15475274 15475274 PRJNA1046144_P_NODE_48333_length_251_cov_1.840659_g48038_i0 PRJNA1046144 48333 251 1.840659 4.62005409 Mycoplasma sp. HU2 2108 Bacteria Bacteria 157 1.4099999999999999e-42   NR WP_050517626.1 1664275 g48038 i0 98.8 0.99203187250996006 83 1 99.2 0 249 1 636 718 WP_050517626.1 MAG6410 family transglutaminase-related lipoprotein [Mycoplasma sp. HU2014] diamond 249 157 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
29782547 29782547 PRJNA1046144_P_NODE_44211_length_261_cov_1.406250_g43916_i0 PRJNA1046144 44211 261 1.40625 3.6703125 Mycoplasma sp. HU2 2108 Bacteria Bacteria 161 4.76e-44   NR WP_050517626.1 1664275 g43916 i0 100 0.954022988505747 83 0 95.4 0 260 12 134 216 WP_050517626.1 MAG6410 family transglutaminase-related lipoprotein [Mycoplasma sp. HU2014] diamond 249 161 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
31963347 31963347 PRJNA1046144_P_NODE_63398_length_230_cov_0.894410_g63103_i0 PRJNA1046144 63398 230 0.89441 2.057143 Candidatus Izemoplasmataceae bacterium 3107147 Bacteria Bacteria 65.9 1.88e-10   NR MFP4077772.1 3107147 g63103 i0 52.2 0.9 69 33 90 0 229 23 271 339 MFP4077772.1 M48 family metallopeptidase [Candidatus Izemoplasmataceae bacterium] diamond 207 65.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae   Candidatus Izemoplasmataceae bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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