RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA688655", 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 · 19 ✖

tax_kingdom 1

  • Bacillati · 19 ✖

bioproject 1

  • PRJNA688655 · 19 ✖

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
667125 667125 PRJNA688655_P_NODE_14101_length_244_cov_0.900585_g14036_i0 PRJNA688655 14101 244 0.900585 2.1974274 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 160 3.61e-46   NR NLH44537.1 1898209 g14036 i0 100 0.983606557377049 80 0 98.4 0 242 3 53 132 NLH44537.1 bifunctional diaminohydroxyphosphoribosylaminopyrimidine deaminase/5-amino-6-(5-phosphoribosylamino)uracil reductase RibD [Acholeplasmataceae bacterium] diamond 240 160 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
1943232 1943232 PRJNA688655_P_NODE_8902_length_250_cov_0.870056_g8837_i0 PRJNA688655 8902 250 0.870056 2.17514 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 462 8.83e-126   NTclustered gi|14089413|emb|AL445563.1| 2107 g8837 i0 100 2 250 0 100 0 1 250 282505 282256 Mycoplasma pulmonis (strain UAB CTIP) complete genome; segment 1/3 blastn 500 462 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
4495114 4495114 PRJNA688655_P_NODE_1544_length_442_cov_3.401084_g1479_i0 PRJNA688655 1544 442 3.401084 15.03279128 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 809 0   NTclustered gi|1563796921|emb|LR215008.1| 2107 g1479 i0 99.773 108.201357466063 441 1 99 0 1 441 800294 799854 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 47825 809 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
14696050 14696050 PRJNA688655_P_NODE_13792_length_244_cov_0.900585_g13727_i0 PRJNA688655 13792 244 0.900585 2.1974274 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 172 2.21e-51   NR NLH45677.1 1898209 g13727 i0 98.8 0.995901639344262 81 1 99.6 0 1 243 184 264 NLH45677.1 IS3 family transposase [Acholeplasmataceae bacterium] diamond 243 172 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
24893219 24893219 PRJNA688655_P_NODE_11540_length_247_cov_0.885057_g11475_i0 PRJNA688655 11540 247 0.885057 2.18609079 Mollicutes bacterium 37628 Bacteria Bacteria 73.9 3.62e-13   NR MDD6402518.1 37628 g11475 i0 80 0.546558704453441 45 9 54.7 0 217 83 361 405 MDD6402518.1 leucine-rich repeat protein [Mollicutes bacterium] diamond 135 73.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
27777368 27777368 PRJNA688655_P_NODE_11064_length_247_cov_0.885057_g10999_i0 PRJNA688655 11064 247 0.885057 2.18609079 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 158 2.849999999999999e-43   NR NLH45535.1 1898209 g10999 i0 92.6 1.96761133603239 81 6 98.4 0 245 3 118 198 NLH45535.1 ATP-binding protein [Acholeplasmataceae bacterium] diamond 486 158 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
27809005 27809005 PRJNA688655_P_NODE_13224_length_245_cov_0.895349_g13159_i0 PRJNA688655 13224 245 0.895349 2.19360505 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 156 7.03e-44   NR MDY0339214.1 1898209 g13159 i0 95.1 0.991836734693878 81 4 99.2 0 3 245 193 273 MDY0339214.1 recombinase family protein [Acholeplasmataceae bacterium] diamond 243 156 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28641440 28641440 PRJNA688655_P_NODE_14707_length_243_cov_0.905882_g14642_i0 PRJNA688655 14707 243 0.905882 2.20129326 Bacillati 1783272 Bacteria Bacteria 139 2.17e-36   NR HHU54467.1 37628 g14642 i0 81.3 1.97530864197531 80 15 98.8 0 242 3 153 232 HHU54467.1 DNA primase [Mollicutes bacterium] diamond 480 139 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
28661385 28661385 PRJNA688655_P_NODE_8507_length_250_cov_0.870056_g8442_i0 PRJNA688655 8507 250 0.870056 2.17514 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 111 4.97e-29   NR NLH54667.1 1898209 g8442 i0 68.7 1.992 83 26 99.6 0 249 1 42 124 NLH54667.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 498 111 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28755981 28755981 PRJNA688655_P_NODE_13467_length_244_cov_0.900585_g13402_i0 PRJNA688655 13467 244 0.900585 2.1974274 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 152 9.54e-46   NR NLZ84152.1 1898209 g13402 i0 98.6 0.872950819672131 71 1 87.3 0 213 1 1 71 NLZ84152.1 DUF1540 domain-containing protein [Acholeplasmataceae bacterium] diamond 213 152 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28830573 28830573 PRJNA688655_P_NODE_13688_length_244_cov_0.900585_g13623_i0 PRJNA688655 13688 244 0.900585 2.1974274 Bacillati 1783272 Bacteria Bacteria 149 4.27e-40   NR NLM32827.1 1898209 g13623 i0 98.8 1.99180327868852 81 1 99.6 0 1 243 67 147 NLM32827.1 ABC transporter ATP-binding protein [Acholeplasmataceae bacterium] diamond 486 150 0.993333333333333 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
29671272 29671272 PRJNA688655_P_NODE_10550_length_248_cov_0.880000_g10485_i0 PRJNA688655 10550 248 0.88 2.1824 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 178 1.6299999999999996e-55   NR NLZ85342.1 1898209 g10485 i0 98.8 0.991935483870968 82 1 99.2 0 248 3 3 84 NLZ85342.1 AAA family ATPase [Acholeplasmataceae bacterium] diamond 246 178 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30145141 30145141 PRJNA688655_P_NODE_16472_length_241_cov_0.916667_g16407_i0 PRJNA688655 16472 241 0.916667 2.20916747 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 107 1.3e-26   NR NLZ84614.1 1898209 g16407 i0 100 0.622406639004149 50 0 62.2 0 240 91 177 226 NLZ84614.1 response regulator transcription factor [Acholeplasmataceae bacterium] diamond 150 107 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30208354 30208354 PRJNA688655_P_NODE_3912_length_319_cov_1.252033_g3847_i0 PRJNA688655 3912 319 1.252033 3.99398527 Tenericutes bacterium ADurb.Bin14 2231116 Bacteria Bacteria 201 2.53e-59   NR OQB66297.1 1852919 g3847 i0 100 0.949843260188088 101 0 95 0 305 3 1 101 OQB66297.1 MAG: Peptidase family M3 [Tenericutes bacterium ADurb.Bin140] diamond 303 201 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.Bin140
30619304 30619304 PRJNA688655_P_NODE_8713_length_250_cov_0.870056_g8648_i0 PRJNA688655 8713 250 0.870056 2.17514 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 165 1.24e-50   NR NLM33676.1 1898209 g8648 i0 100 0.984 82 0 98.4 0 249 4 60 141 NLM33676.1 sporulation protein YtfJ [Acholeplasmataceae bacterium] diamond 246 165 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30967065 30967065 PRJNA688655_P_NODE_15994_length_241_cov_1.029762_g15929_i0 PRJNA688655 15994 241 1.029762 2.48172642 Haloplasmataceae bacterium 2862752 Bacteria Bacteria 146 4.9e-39   NR HEY8363941.1 2862752 g15929 i0 90 1.99170124481328 80 8 99.6 0 1 240 153 232 HEY8363941.1 hypothetical protein [Haloplasmataceae bacterium] diamond 480 146 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae   Haloplasmataceae bacterium
31042006 31042006 PRJNA688655_P_NODE_10575_length_248_cov_0.880000_g10510_i0 PRJNA688655 10575 248 0.88 2.1824 Bacillati 1783272 Bacteria Bacteria 166 3.7299999999999997e-48   NR NLZ84627.1 1898209 g10510 i0 100 1.98387096774194 82 0 99.2 0 247 2 4 85 NLZ84627.1 succinylglutamate desuccinylase/aspartoacylase family protein [Acholeplasmataceae bacterium] diamond 492 166 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31326108 31326108 PRJNA688655_P_NODE_14055_length_244_cov_0.900585_g13990_i0 PRJNA688655 14055 244 0.900585 2.1974274 Bacillati 1783272 Bacteria Bacteria 160 7.489999999999998e-47   NR NLZ84786.1 1898209 g13990 i0 100 1.9672131147541 80 0 98.4 0 242 3 162 241 NLZ84786.1 transporter substrate-binding domain-containing protein [Acholeplasmataceae bacterium] diamond 480 160 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31757400 31757400 PRJNA688655_P_NODE_7797_length_251_cov_0.865169_g7732_i0 PRJNA688655 7797 251 0.865169 2.17157419 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 130 2.69e-35   NR NLZ84394.1 1898209 g7732 i0 88 0.99203187250996006 83 0 99.2 1 250 2 116 188 NLZ84394.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 249 130 1 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);;