RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA888821", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 17 ✖

tax_kingdom 1

  • Bacillati · 17 ✖

bioproject 1

  • PRJNA888821 · 17 ✖

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
18714292 18714292 PRJNA888821_P_NODE_37575_length_245_cov_0.895349_g37492_i0 PRJNA888821 37575 245 0.895349 2.19360505 Mycoplasma yeatsii 51365 Bacteria Bacteria 394 3.189999999999999e-105   NTclustered gi|756767228|gb|CP007520.1| 743967 g37492 i0 96.624 1.93469387755102 237 8 97 0 9 245 307458 307694 Mycoplasma yeatsii GM274B blastn 474 394 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
18714603 18714603 PRJNA888821_P_NODE_615_length_649_cov_1.519097_g547_i0 PRJNA888821 615 649 1.519097 9.85893953 Mycoplasma sp. HU2 2108 Bacteria Bacteria 108 5.48e-25   NR WP_152908009.1 1664275 g547 i0 50 1.23882896764253 134 67 61.9 0 515 114 1 134 WP_152908009.1 winged helix-turn-helix domain-containing protein, partial [Mycoplasma sp. HU2014] diamond 804 108 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
21264895 21264895 PRJNA888821_P_NODE_37537_length_245_cov_0.895349_g37454_i0 PRJNA888821 37537 245 0.895349 2.19360505 Mycoplasma yeatsii 51365 Bacteria Bacteria 261 3.38e-65   NTclustered gi|756767228|gb|CP007520.1| 743967 g37454 i0 86.008 2.16326530612245 243 34 99 0 3 245 342897 342655 Mycoplasma yeatsii GM274B blastn 530 261 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
21644086 21644086 PRJNA888821_P_NODE_39357_length_241_cov_0.916667_g39274_i0 PRJNA888821 39357 241 0.916667 2.20916747 Mycoplasma 2093 Bacteria Bacteria 268 1.98e-67   NTclustered gi|2294785939|gb|CP103424.1| 51364 g39274 i0 88.053 1.93360995850622 226 27 94 0 14 239 680337 680112 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 466 270 0.992592592592593 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
22539736 22539736 PRJNA888821_P_NODE_37478_length_245_cov_0.895349_g37395_i0 PRJNA888821 37478 245 0.895349 2.19360505 Mycoplasma cottewii 51364 Bacteria Bacteria 364 2.5e-96   NTclustered gi|2294785939|gb|CP103424.1| 51364 g37395 i0 93.469 5.01224489795918 245 16 100 0 1 245 433767 434011 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 1228 364 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
25088988 25088988 PRJNA888821_P_NODE_35680_length_249_cov_0.875000_g35597_i0 PRJNA888821 35680 249 0.875 2.17875 Mycoplasma yeatsii 51365 Bacteria Bacteria 322 1.56e-83   NTclustered gi|756767228|gb|CP007520.1| 743967 g35597 i0 89.96 2 249 25 100 0 1 249 524718 524470 Mycoplasma yeatsii GM274B blastn 498 322 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
25089051 25089051 PRJNA888821_P_NODE_39460_length_241_cov_0.916667_g39377_i0 PRJNA888821 39460 241 0.916667 2.20916747 Mycoplasma cottewii 51364 Bacteria Bacteria 351 1.91e-92   NTclustered gi|2294785939|gb|CP103424.1| 51364 g39377 i0 92.946 1 241 17 100 0 1 241 522226 522466 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 241 351 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
27782167 27782167 PRJNA888821_P_NODE_29804_length_271_cov_1.166667_g29721_i0 PRJNA888821 29804 271 1.166667 3.16166757 Mycoplasma sp. HU2 2108 Bacteria Bacteria 89.7 1.54e-18   NR WP_050517139.1 1664275 g29721 i0 82.5 0.6309963099631 57 10 63.1 0 6 176 624 680 WP_050517139.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 171 89.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
28097710 28097710 PRJNA888821_P_NODE_37545_length_245_cov_0.895349_g37462_i0 PRJNA888821 37545 245 0.895349 2.19360505 Mycoplasma putrefaciens 2123 Bacteria Bacteria 99.4 6.71e-24   NR WP_015587142.1 2123 g37462 i0 68.8 1.88571428571429 77 24 94.3 0 3 233 67 143 WP_015587142.1 recombination mediator RecR [Mycoplasma putrefaciens] diamond 462 99.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma putrefaciens
28161120 28161120 PRJNA888821_P_NODE_38485_length_243_cov_0.905882_g38402_i0 PRJNA888821 38485 243 0.905882 2.20129326 Mycoplasma sp. HU2 2108 Bacteria Bacteria 58.9 1.95e-8   NR WP_050517690.1 1664275 g38402 i0 67.3 0.604938271604938 49 16 60.5 0 46 192 77 125 WP_050517690.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 147 58.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
28287003 28287003 PRJNA888821_P_NODE_29106_length_274_cov_1.532338_g29024_i0 PRJNA888821 29106 274 1.532338 4.19860612 Mycoplasma sp. HU2 2108 Bacteria Bacteria 143 5.41e-40   NR WP_050517125.1 1664275 g29024 i0 86.5 0.974452554744526 89 12 97.4 0 2 268 159 247 WP_050517125.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 267 143 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
28508274 28508274 PRJNA888821_P_NODE_11927_length_310_cov_9.004219_g11845_i0 PRJNA888821 11927 310 9.004219 27.9130789 Candidatus Izemoplasma sp. 2979197 Bacteria Bacteria 48.1 0.00103   NR MFK5882860.1 2979197 g11845 i0 56.8 0.358064516129032 37 16 35.8 0 38 148 410 446 MFK5882860.1 AAA family ATPase [Candidatus Izemoplasma sp.] diamond 111 48.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izemoplasma sp.
29486792 29486792 PRJNA888821_P_NODE_4110_length_354_cov_1.096085_g4029_i0 PRJNA888821 4110 354 1.096085 3.8801409 Mycoplasma sp. HU2 2108 Bacteria Bacteria 132 7.45e-35   NR KNG79577.1 1664275 g4029 i0 86.7 0.703389830508475 83 11 70.3 0 251 3 161 243 KNG79577.1 AAA ATPase [Mycoplasma sp. HU2014] diamond 249 132 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
30181779 30181779 PRJNA888821_P_NODE_34412_length_252_cov_1.301676_g34329_i0 PRJNA888821 34412 252 1.301676 3.28022352 Mycoplasma yeatsii 51365 Bacteria Bacteria 99.8 3.3e-23   NR WP_004427093.1 51365 g34329 i0 75 0.80952380952381 68 17 81 0 246 43 36 103 WP_004427093.1 Cof-type HAD-IIB family hydrolase [Mycoplasma yeatsii] diamond 204 99.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
30213311 30213311 PRJNA888821_P_NODE_35252_length_250_cov_0.870056_g35169_i0 PRJNA888821 35252 250 0.870056 2.17514 Mycoplasma sp. HU2 2108 Bacteria Bacteria 96.7 1.47e-21   NR WP_235443309.1 1664275 g35169 i0 61 0.984 82 32 98.4 0 5 250 62 143 WP_235443309.1 transposase, partial [Mycoplasma sp. HU2014] diamond 246 96.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
30560773 30560773 PRJNA888821_P_NODE_38433_length_243_cov_0.905882_g38350_i0 PRJNA888821 38433 243 0.905882 2.20129326 Mycoplasma cottewii 51364 Bacteria Bacteria 68.2 1.76e-11   NR WP_259430118.1 51364 g38350 i0 58.5 0.654320987654321 53 22 65.4 0 242 84 203 255 WP_259430118.1 alpha/beta fold hydrolase [Mycoplasma cottewii] diamond 159 68.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
32529694 32529694 PRJNA888821_P_NODE_37579_length_245_cov_0.895349_g37496_i0 PRJNA888821 37579 245 0.895349 2.19360505 Mycoplasma 2093 Bacteria Bacteria 58.2 1.37e-7   NR WP_004430318.1 51365 g37496 i0 38.3 4.93469387755102 81 50 99.2 0 245 3 217 297 WP_004430318.1 transposase [Mycoplasma yeatsii] diamond 1209 58.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii

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