RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA322517" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA322517 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
12547673 12547673 PRJNA322517_P_NODE_1490_length_403_cov_2.929379_g1468_i0 PRJNA322517 1490 403 2.929379 11.80539737 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 207 2.64e-60   NR WP_322536745.1 2107 g1468 i0 100 0.789081885856079 106 0 78.9 0 318 1 356 461 WP_322536745.1 bifunctional UDP-sugar hydrolase/5'-nucleotidase [Mycoplasmopsis pulmonis] diamond 318 207 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
26757948 26757948 PRJNA322517_P_NODE_3501_length_218_cov_3.597633_g3479_i0 PRJNA322517 3501 218 3.597633 7.84283994 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 55.8 6.52e-7   NR WP_322536577.1 2107 g3479 i0 83.3 0.990825688073395 72 12 99.1 0 2 217 76 147 WP_322536577.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 216 55.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
27264337 27264337 PRJNA322517_P_NODE_6243_length_161_cov_1.383929_g6221_i0 PRJNA322517 6243 161 1.383929 2.22812569 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 79.7 1.12e-15   NR AAB41036.2 2107 g6221 i0 97.6 1.56521739130435 42 1 78.3 0 127 2 149 190 AAB41036.2 P93delta, partial [Mycoplasmopsis pulmonis] diamond 252 79.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
27295857 27295857 PRJNA322517_P_NODE_3683_length_210_cov_2.521739_g3661_i0 PRJNA322517 3683 210 2.521739 5.2956519 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 62 4.01e-9   NR WP_010925112.1 2107 g3661 i0 90.9 0.471428571428571 33 3 47.1 0 99 1 980 1012 WP_010925112.1 lipoprotein 17-related variable surface protein [Mycoplasmopsis pulmonis] diamond 99 62 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
27454012 27454012 PRJNA322517_P_NODE_2223_length_321_cov_2.371324_g2201_i0 PRJNA322517 2223 321 2.371324 7.61195004 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 178 2.68e-49   NR WP_010925112.1 2107 g2201 i0 86.7 0.981308411214953 105 14 98.1 0 317 3 570 674 WP_010925112.1 lipoprotein 17-related variable surface protein [Mycoplasmopsis pulmonis] diamond 315 178 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
28274616 28274616 PRJNA322517_P_NODE_746_length_624_cov_20.401739_g724_i0 PRJNA322517 746 624 20.401739 127.30685136 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 400 2.42e-127   NR WP_322536577.1 2107 g724 i0 100 0.995192307692308 207 0 99.5 0 623 3 870 1076 WP_322536577.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 621 400 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
28432654 28432654 PRJNA322517_P_NODE_446_length_843_cov_16.434509_g428_i0 PRJNA322517 446 843 16.434509 138.54291087 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 457 1.45e-147   NR WP_322536577.1 2107 g428 i0 86.5 1 281 38 100 0 843 1 1071 1351 WP_322536577.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 843 457 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
29095774 29095774 PRJNA322517_P_NODE_4548_length_183_cov_3.246269_g4526_i0 PRJNA322517 4548 183 3.246269 5.94067227 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 110 2.29e-26   NR WP_010925285.1 2107 g4526 i0 80 1.22950819672131 75 0 98.4 1 181 2 113 187 WP_010925285.1 lysylphosphatidylglycerol synthase transmembrane domain-containing protein [Mycoplasmopsis pulmonis] diamond 225 110 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
30106095 30106095 PRJNA322517_P_NODE_3652_length_210_cov_3.285714_g3630_i0 PRJNA322517 3652 210 3.285714 6.8999994 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 56.2 4.29e-7   NR WP_010924929.1 2107 g3630 i0 61.4 1 70 24 100 1 1 210 205 271 WP_010924929.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 210 56.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
30169204 30169204 PRJNA322517_P_NODE_5012_length_174_cov_1.224000_g4990_i0 PRJNA322517 5012 174 1.224 2.12976 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 99 2.29e-22   NR WP_010925112.1 2107 g4990 i0 87.7 0.982758620689655 57 7 98.3 0 172 2 499 555 WP_010925112.1 lipoprotein 17-related variable surface protein [Mycoplasmopsis pulmonis] diamond 171 99 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
30296208 30296208 PRJNA322517_P_NODE_3352_length_227_cov_3.224719_g3330_i0 PRJNA322517 3352 227 3.224719 7.32011213 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 119 1.89e-32   NR WP_010924954.1 2107 g3330 i0 100 0.898678414096916 68 0 89.9 0 22 225 54 121 WP_010924954.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 204 119 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
30643147 30643147 PRJNA322517_P_NODE_3753_length_207_cov_3.075949_g3731_i0 PRJNA322517 3753 207 3.075949 6.36721443 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 114 1.01e-28   NR WP_010925006.1 2107 g3731 i0 100 0.898550724637681 62 0 89.9 0 187 2 36 97 WP_010925006.1 YihY/virulence factor BrkB family protein [Mycoplasmopsis pulmonis] diamond 186 114 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
30927821 30927821 PRJNA322517_P_NODE_4214_length_191_cov_3.309859_g4192_i0 PRJNA322517 4214 191 3.309859 6.32183069 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 61.6 1.23e-9   NR WP_143756252.1 2107 g4192 i0 96.9 1.00523560209424 32 1 50.3 0 95 190 150 181 WP_143756252.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 192 61.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
31211576 31211576 PRJNA322517_P_NODE_6395_length_158_cov_2.798165_g6373_i0 PRJNA322517 6395 158 2.798165 4.4211007 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 96.3 4.63e-24   NR CAC13484.1 2107 g6373 i0 94.2 0.987341772151899 52 3 98.7 0 157 2 2 53 CAC13484.1 unknown; predicted coding region [Mycoplasmopsis pulmonis] diamond 156 96.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
31528444 31528444 PRJNA322517_P_NODE_3956_length_199_cov_4.346667_g3934_i0 PRJNA322517 3956 199 4.346667 8.64986733 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 67.8 2.99e-11   NR WP_010925249.1 2107 g3934 i0 100 0.482412060301508 32 0 48.2 0 98 3 721 752 WP_010925249.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 96 67.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
31654673 31654673 PRJNA322517_P_NODE_5157_length_171_cov_1.401639_g5135_i0 PRJNA322517 5157 171 1.401639 2.39680269 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 94 6.929999999999999e-23   NR WP_010925084.1 2107 g5135 i0 94.6 0.982456140350877 56 3 98.2 0 169 2 50 105 WP_010925084.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 168 94 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
31781202 31781202 PRJNA322517_P_NODE_1197_length_457_cov_6.928922_g1175_i0 PRJNA322517 1197 457 6.928922 31.66517354 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 272 1.83e-81   NR WP_322536577.1 2107 g1175 i0 97.9 0.925601750547046 141 3 92.6 0 34 456 505 645 WP_322536577.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 423 272 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
31844491 31844491 PRJNA322517_P_NODE_797_length_598_cov_11.679417_g775_i0 PRJNA322517 797 598 11.679417 69.84291366 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 328 8.249999999999999e-101   NR WP_322536577.1 2107 g775 i0 87.4 0.993311036789298 198 25 99.3 0 596 3 296 493 WP_322536577.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 594 328 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
32129576 32129576 PRJNA322517_P_NODE_4098_length_195_cov_3.404110_g4076_i0 PRJNA322517 4098 195 3.40411 6.6380145 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 125 1.4499999999999998e-31   NR WP_322536748.1 2107 g4076 i0 100 0.984615384615385 64 0 98.5 0 193 2 114 177 WP_322536748.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 192 125 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
32224392 32224392 PRJNA322517_P_NODE_5798_length_164_cov_1.921739_g5776_i0 PRJNA322517 5798 164 1.921739 3.15165196 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 73.2 2.35e-13   NR WP_010925505.1 2107 g5776 i0 100 0.823170731707317 45 0 82.3 0 2 136 567 611 WP_010925505.1 ribonuclease J [Mycoplasmopsis pulmonis] diamond 135 73.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
32319547 32319547 PRJNA322517_P_NODE_2679_length_281_cov_3.918103_g2657_i0 PRJNA322517 2679 281 3.918103 11.00986943 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 154 2.81e-41   NR WP_322536577.1 2107 g2657 i0 87.1 0.99288256227758 93 12 99.3 0 3 281 156 248 WP_322536577.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 279 154 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis

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