RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA763718" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA763718 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27053265 27053265 PRJNA763718_S_NODE_7862_length_157_cov_1.916667_g7654_i0 PRJNA763718 7862 157 1.916667 3.00916719 Mycoplasma sp. 2108 Bacteria Bacteria 82 1.83e-18   NR MBD5445970.1 2108 g7654 i0 82.7 0.993630573248408 52 9 99.4 0 156 1 33 84 MBD5445970.1 50S ribosomal protein L18 [Mycoplasma sp.] diamond 156 82 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
27685331 27685331 PRJNA763718_S_NODE_7064_length_165_cov_1.492188_g6856_i0 PRJNA763718 7064 165 1.492188 2.4621102 Malacoplasma iowae 2116 Bacteria Bacteria 84 1.83e-17   NR WP_004024699.1 2116 g6856 i0 75.9 0.981818181818182 54 13 98.2 0 163 2 43 96 WP_004024699.1 50S ribosomal protein L22 [Malacoplasma iowae] diamond 162 84 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma iowae
29494368 29494368 PRJNA763718_S_NODE_6810_length_168_cov_1.396947_g6602_i0 PRJNA763718 6810 168 1.396947 2.34687096 Mollicutes 31969 Bacteria Bacteria 65.5 6.26e-11   NR MBD5445965.1 2108 g6602 i0 68.3 2.96428571428571 41 13 73.2 0 1 123 176 216 MBD5445965.1 type I methionyl aminopeptidase [Mycoplasma sp.] diamond 498 65.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
31001148 31001148 PRJNA763718_S_NODE_5694_length_183_cov_1.849315_g5486_i0 PRJNA763718 5694 183 1.849315 3.38424645 Candidatus Ureaplasma intestinipullorum 2838770 Bacteria Bacteria 53.1 3.15e-7   NR MBU3830742.1 2838770 g5486 i0 46 2.42622950819672 50 27 82 0 150 1 36 85 MBU3830742.1 DUF2188 domain-containing protein [Candidatus Ureaplasma intestinipullorum] diamond 444 53.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Candidatus Ureaplasma intestinipullorum
31127052 31127052 PRJNA763718_S_NODE_6795_length_168_cov_1.763359_g6587_i0 PRJNA763718 6795 168 1.763359 2.96244312 Malacoplasma sp. 2791014 Bacteria Bacteria 69.7 2.69e-13   NR MDE6645948.1 2791014 g6587 i0 61.1 1.94642857142857 54 21 96.4 0 162 1 20 73 MDE6645948.1 50S ribosomal protein L10 [Malacoplasma sp.] diamond 327 69.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
31317123 31317123 PRJNA763718_S_NODE_2115_length_319_cov_5.815603_g1907_i0 PRJNA763718 2115 319 5.815603 18.55177357 Spiroplasma culicicola 216935 Bacteria Bacteria 149 7.45e-42   NR WP_025362677.1 216935 g1907 i0 67.9 2.99059561128527 106 34 99.7 0 318 1 42 147 WP_025362677.1 L-lactate dehydrogenase [Spiroplasma culicicola] diamond 954 149 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma culicicola
31959324 31959324 PRJNA763718_S_NODE_5357_length_189_cov_2.263158_g5149_i0 PRJNA763718 5357 189 2.263158 4.27736862 Mollicutes 31969 Bacteria Bacteria 70.1 3.72e-12   NR MFA7422770.1 1898209 g5149 i0 78.6 3.33333333333333 42 9 66.7 0 2 127 356 397 MFA7422770.1 phosphoglycerate kinase [Acholeplasmataceae bacterium] diamond 630 70.5 0.994326241134752 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae 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);;