RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA704949 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
693632 693632 PRJNA704949_P_NODE_1962301_length_168_cov_1.075630_g1946962_i0 PRJNA704949 1962301 168 1.07563 1.8070584 Metamycoplasma orale 2121 Bacteria Bacteria 254 3.6e-63   NTclustered gi|1563679895|emb|LR214940.1| 2121 g1946962 i0 96.732 0.910714285714286 153 4 90 1 1 152 496881 497033 Mycoplasma orale strain NCTC10112 genome assembly, chromosome: 1 blastn 153 254 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma orale
7077906 7077906 PRJNA704949_P_NODE_612206_length_346_cov_6.542088_g596882_i0 PRJNA704949 612206 346 6.542088 22.63562448 Spiroplasma endosymbiont of 'Nebria riversi' 2792084 Bacteria Bacteria 119 3.18e-22   NTclustered gi|2050639153|gb|CP065193.1| 2792084 g596882 i0 91.765 63.3554913294798 85 7 25 0 243 327 213184 213268 Spiroplasma endosymbiont of 'Nebria riversi' isolate Nriv7 chromosome, complete genome blastn 21921 119 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of 'Nebria riversi'
12180089 12180089 PRJNA704949_P_NODE_782010_length_302_cov_1.557312_g766678_i0 PRJNA704949 782010 302 1.557312 4.70308224 Malacoplasma iowae 2116 Bacteria Bacteria 52.8 0.028   NTclustered gi|2624202576|gb|CP129195.1| 2116 g766678 i0 100 0.185430463576159 28 0 9 0 266 293 623831 623804 Malacoplasma iowae strain M821 chromosome, complete genome blastn 56 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma iowae
17273237 17273237 PRJNA704949_P_NODE_2175734_length_162_cov_0.920354_g2160395_i0 PRJNA704949 2175734 162 0.920354 1.49097348 Metamycoplasma faucium 56142 Bacteria Bacteria 283 4.39e-72   NTclustered gi|2921905358|gb|CP182786.1| 56142 g2160395 i0 98.148 2 162 3 100 0 1 162 582694 582855 Metamycoplasma faucium strain DC-333 chromosome, complete genome blastn 324 283 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
19826097 19826097 PRJNA704949_P_NODE_596416_length_351_cov_2.920530_g581093_i0 PRJNA704949 596416 351 2.92053 10.2510603 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 137 8.9e-28   NTclustered gi|2626246590|emb|OY830043.1| 2023991 g581093 i0 92.632 69.5840455840456 95 7 27 0 48 142 605381 605475 MAG: Mycoplasmatales bacterium isolate 250c9514-7736-4d95-b141-2db6cdbdfc3c genome assembly, chromosome: 1 blastn 24424 137 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
22372074 22372074 PRJNA704949_P_NODE_2088798_length_164_cov_1.356522_g2073459_i0 PRJNA704949 2088798 164 1.356522 2.22469608 Mycoplasmopsis glycophila 171285 Bacteria Bacteria 63.9 6.33e-6   NTclustered gi|1563800497|emb|LR215024.1| 171285 g2073459 i0 97.297 1.14024390243902 37 1 23 0 1 37 707193 707157 Mycoplasma glycophilum strain NCTC10194 genome assembly, chromosome: 1 blastn 187 63.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis glycophila

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