RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJEB10140" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJEB10140 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
11490892 11490892 PRJEB10140_P_NODE_284690_length_163_cov_0.903509_g267381_i0 PRJEB10140 284690 163 0.903509 1.47271967 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 103 1.19e-26   NR HHX78174.1 1898209 g267381 i0 100 0.975460122699387 53 0 97.5 0 161 3 59 111 HHX78174.1 MarR family transcriptional regulator [Acholeplasmataceae bacterium] diamond 159 103 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
27632989 27632989 PRJEB10140_P_NODE_213244_length_187_cov_0.891304_g195935_i0 PRJEB10140 213244 187 0.891304 1.66673848 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 57.8 8.84e-8   NR NQX84229.1 2685873 g195935 i0 49.2 0.946524064171123 59 30 94.7 0 181 5 2 60 NQX84229.1 reverse transcriptase family protein [Mycoplasmataceae bacterium] diamond 177 57.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
28643419 28643419 PRJEB10140_P_NODE_209047_length_189_cov_1.464286_g191738_i0 PRJEB10140 209047 189 1.464286 2.76750054 Mollicutes bacterium 37628 Bacteria Bacteria 66.2 9.13e-11   NR NLL02367.1 37628 g191738 i0 56.9 0.80952380952381 51 22 81 0 157 5 523 573 NLL02367.1 DNA mismatch repair protein MutS [Mollicutes bacterium] diamond 153 66.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
29457886 29457886 PRJEB10140_P_NODE_265630_length_166_cov_0.880342_g248321_i0 PRJEB10140 265630 166 0.880342 1.46136772 Mycoplasma 2093 Bacteria Bacteria 73.9 1.26e-13   NR CCY89368.1 1262908 g248321 i0 66.7 2.78313253012048 51 17 92.2 0 161 9 538 588 CCY89368.1 chaperone protein HtpG [Mycoplasma sp. CAG:956] diamond 462 73.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. CAG:956
29969330 29969330 PRJEB10140_P_NODE_113051_length_323_cov_1.474453_g95745_i0 PRJEB10140 113051 323 1.474453 4.76248319 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 45.1 0.0121   NR MBQ9448929.1 2053494 g95745 i0 40.6 0.640866873065015 69 36 60.4 2 126 320 41 108 MBQ9448929.1 amino acid ABC transporter ATP-binding protein [Acholeplasmatales bacterium] diamond 207 45.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
30222082 30222082 PRJEB10140_P_NODE_147132_length_251_cov_4.752475_g129824_i0 PRJEB10140 147132 251 4.752475 11.92871225 Spiroplasma endosymbiont of Lariophagus distinguendus 2935082 Bacteria Bacteria 41.6 0.0118   NR WP_252321053.1 2935082 g129824 i0 38.3 0.561752988047809 47 29 56.2 0 232 92 1 47 WP_252321053.1 hypothetical protein, partial [Spiroplasma endosymbiont of Lariophagus distinguendus] diamond 141 41.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Lariophagus distinguendus
30285711 30285711 PRJEB10140_P_NODE_101152_length_362_cov_1.303514_g83854_i0 PRJEB10140 101152 362 1.303514 4.71872068 Mycoplasmopsis arginini 2094 Bacteria Bacteria 158 3.83e-48   NR WP_282460239.1 2094 g83854 i0 100 0.604972375690608 73 0 60.5 0 352 134 1 73 WP_282460239.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 219 158 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30506650 30506650 PRJEB10140_P_NODE_277493_length_164_cov_0.904348_g260184_i0 PRJEB10140 277493 164 0.904348 1.48313072 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 65.1 1.46e-10   NR MBQ9520801.1 2053494 g260184 i0 83.8 2.03048780487805 37 6 67.7 0 54 164 1 37 MBQ9520801.1 sugar ABC transporter permease [Acholeplasmatales bacterium] diamond 333 65.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
30538190 30538190 PRJEB10140_P_NODE_70373_length_522_cov_2.076110_g53257_i0 PRJEB10140 70373 522 2.07611 10.8372942 Mycoplasmopsis cricetuli 171283 Bacteria Bacteria 48.5 0.00448   NR WP_025755338.1 171283 g53257 i0 29.8 1.04022988505747 181 94 99.4 7 3 521 132 287 WP_025755338.1 hypothetical protein [Mycoplasmopsis cricetuli] diamond 543 48.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis cricetuli
31044069 31044069 PRJEB10140_P_NODE_292395_length_162_cov_0.893805_g275086_i0 PRJEB10140 292395 162 0.893805 1.4479641 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 103 4.03e-25   NR HHW79441.1 1898209 g275086 i0 100 0.981481481481482 53 0 98.1 0 160 2 206 258 HHW79441.1 GTPase Era [Acholeplasmataceae bacterium] diamond 159 103 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31233035 31233035 PRJEB10140_P_NODE_149275_length_248_cov_1.994975_g131967_i0 PRJEB10140 149275 248 1.994975 4.947538 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 43.5 0.00674   NR MDR2653796.1 2685873 g131967 i0 27.5 0.967741935483871 80 56 94.4 1 14 247 1 80 MDR2653796.1 hypothetical protein [Mycoplasmataceae bacterium] diamond 240 43.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
31296508 31296508 PRJEB10140_P_NODE_265395_length_166_cov_0.880342_g248086_i0 PRJEB10140 265395 166 0.880342 1.46136772 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 45.8 0.00109   NR NLB85419.1 1898209 g248086 i0 42 0.903614457831325 50 29 90.4 0 151 2 294 343 NLB85419.1 ABC transporter permease subunit [Acholeplasmataceae bacterium] diamond 150 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32150783 32150783 PRJEB10140_P_NODE_56078_length_654_cov_7.814876_g39690_i0 PRJEB10140 56078 654 7.814876 51.10928904 Mycoplasmopsis arginini 2094 Bacteria Bacteria 319 8.489999999999999e-109   NR WP_282460019.1 2094 g39690 i0 98.2 0.761467889908257 166 3 76.1 0 654 157 5 170 WP_282460019.1 antA/AntB antirepressor family protein, partial [Mycoplasmopsis arginini] diamond 498 319 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32498878 32498878 PRJEB10140_P_NODE_152919_length_243_cov_1.778351_g135611_i0 PRJEB10140 152919 243 1.778351 4.32139293 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 49.3 1.86e-4   NR HXN54441.1 2023991 g135611 i0 52.6 0.469135802469136 38 18 46.9 0 123 10 352 389 HXN54441.1 reverse transcriptase family protein [Mycoplasmatales bacterium] diamond 114 49.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
32498898 32498898 PRJEB10140_P_NODE_180799_length_212_cov_0.950920_g163490_i0 PRJEB10140 180799 212 0.95092 2.0159504 Mycoplasmopsis arginini 2094 Bacteria Bacteria 100 1.51e-25   NR WP_369124529.1 2094 g163490 i0 80.7 0.806603773584906 57 11 80.7 0 171 1 1 57 WP_369124529.1 helix-turn-helix domain-containing protein [Mycoplasmopsis arginini] diamond 171 100 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini

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