RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Bacillati · 15 ✖

bioproject 1

  • PRJNA688352 · 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
1942848 1942848 PRJNA688352_P_NODE_12782_length_228_cov_2.767742_g12679_i0 PRJNA688352 12782 228 2.767742 6.31045176 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 422 1.34e-113   NTclustered gi|1563796921|emb|LR215008.1| 2107 g12679 i0 100 123.635964912281 228 0 100 0 1 228 797506 797279 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 28189 422 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
5770525 5770525 PRJNA688352_P_NODE_6545_length_259_cov_3.086022_g6442_i0 PRJNA688352 6545 259 3.086022 7.99279698 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 473 4.25e-129   NTclustered gi|1563796921|emb|LR215008.1| 2107 g6442 i0 99.614 124.586872586873 259 1 100 0 1 259 800034 800292 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 32268 473 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
15969562 15969562 PRJNA688352_P_NODE_12813_length_226_cov_2.013072_g12710_i0 PRJNA688352 12813 226 2.013072 4.54954272 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 412 8.01e-111   NTclustered gi|1563796921|emb|LR215008.1| 2107 g12710 i0 99.558 99.0619469026549 226 1 100 0 1 226 799805 800030 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 22388 412 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
17244809 17244809 PRJNA688352_P_NODE_12294_length_241_cov_0.916667_g12191_i0 PRJNA688352 12294 241 0.916667 2.20916747 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 435 1.84e-117   NTclustered gi|1563796921|emb|LR215008.1| 2107 g12191 i0 99.17 100.174273858921 241 2 100 0 1 241 800501 800741 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 24142 435 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
26998756 26998756 PRJNA688352_P_NODE_7282_length_251_cov_0.865169_g7179_i0 PRJNA688352 7282 251 0.865169 2.17157419 Bacillati 1783272 Bacteria Bacteria 165 9.709999999999999e-47   NR NLZ84200.1 1898209 g7179 i0 100 1.9840637450199201 83 0 99.2 0 251 3 344 426 NLZ84200.1 cardiolipin synthase [Acholeplasmataceae bacterium] diamond 498 165 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
27050703 27050703 PRJNA688352_P_NODE_8762_length_248_cov_0.880000_g8659_i0 PRJNA688352 8762 248 0.88 2.1824 Tenericutes bacterium MZ-XQ 1911683 Bacteria Bacteria 80.9 1.01e-15   NR AUD66187.1 1911683 g8659 i0 62.9 2.83064516129032 62 23 75 0 62 247 1 62 AUD66187.1 anaerobic sulfatase maturase [Tenericutes bacterium MZ-XQ] diamond 702 80.9 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium MZ-XQ
27366990 27366990 PRJNA688352_P_NODE_5983_length_270_cov_1.563452_g5880_i0 PRJNA688352 5983 270 1.563452 4.2213204 Tenericutes bacterium ADurb.Bin14 2231116 Bacteria Bacteria 169 6.5999999999999986e-49   NR OQB61991.1 1852919 g5880 i0 97.7 0.966666666666667 87 2 96.7 0 3 263 309 395 OQB61991.1 MAG: Trehalose import ATP-binding protein SugC [Tenericutes bacterium ADurb.Bin140] diamond 261 169 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.Bin140
27998382 27998382 PRJNA688352_P_NODE_11325_length_243_cov_0.905882_g11222_i0 PRJNA688352 11325 243 0.905882 2.20129326 Mollicutes bacterium 37628 Bacteria Bacteria 86.3 1.82e-17   NR NLL01482.1 37628 g11222 i0 44.9 0.962962962962963 78 43 96.3 0 10 243 522 599 NLL01482.1 ABC transporter ATP-binding protein [Mollicutes bacterium] diamond 234 86.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
28566501 28566501 PRJNA688352_P_NODE_2267_length_399_cov_0.944785_g2164_i0 PRJNA688352 2267 399 0.944785 3.76969215 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 268 2.889999999999999e-87   NR NLZ85360.1 1898209 g2164 i0 100 1 133 0 100 0 1 399 21 153 NLZ85360.1 diguanylate cyclase [Acholeplasmataceae bacterium] diamond 399 268 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
29083383 29083383 PRJNA688352_P_NODE_4828_length_295_cov_1.040541_g4725_i0 PRJNA688352 4828 295 1.040541 3.06959595 Bacillati 1783272 Bacteria Bacteria 191 1.3e-59   NR OQB66072.1 1852919 g4725 i0 99 1.99322033898305 98 1 99.7 0 2 295 50 147 OQB66072.1 MAG: hypothetical protein BWX94_00260 [Tenericutes bacterium ADurb.Bin140] diamond 588 191 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.Bin140
29450370 29450370 PRJNA688352_P_NODE_7830_length_250_cov_0.870056_g7727_i0 PRJNA688352 7830 250 0.870056 2.17514 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 165 5.3799999999999997e-48   NR NLZ85004.1 1898209 g7727 i0 100 0.996 83 0 99.6 0 249 1 102 184 NLZ85004.1 NAD(P)-dependent glycerol-3-phosphate dehydrogenase [Acholeplasmataceae bacterium] diamond 249 165 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
29545212 29545212 PRJNA688352_P_NODE_8610_length_248_cov_0.880000_g8507_i0 PRJNA688352 8610 248 0.88 2.1824 Tenericutes bacterium ADurb.Bin14 2231116 Bacteria Bacteria 171 2.6999999999999998e-48   NR OQB62811.1 1852919 g8507 i0 100 0.979838709677419 81 0 98 0 247 5 138 218 OQB62811.1 MAG: Transposase DDE domain protein [Tenericutes bacterium ADurb.Bin140] diamond 243 171 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.Bin140
29892897 29892897 PRJNA688352_P_NODE_9291_length_247_cov_0.885057_g9188_i0 PRJNA688352 9291 247 0.885057 2.18609079 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 85.5 5.92e-18   NR NLZ85185.1 1898209 g9188 i0 100 0.510121457489879 42 0 51 0 1 126 221 262 NLZ85185.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 126 85.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
29999176 29999176 PRJNA688352_P_NODE_8051_length_249_cov_0.875000_g7948_i0 PRJNA688352 8051 249 0.875 2.17875 Bacillati 1783272 Bacteria Bacteria 145 4.5e-39   NR NLZ84537.1 1898209 g7948 i0 100 2 83 0 100 0 1 249 407 489 NLZ84537.1 spore germination protein [Acholeplasmataceae bacterium] diamond 498 145 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31010047 31010047 PRJNA688352_P_NODE_11134_length_243_cov_0.905882_g11031_i0 PRJNA688352 11134 243 0.905882 2.20129326 Bacillati 1783272 Bacteria Bacteria 155 9.51e-45   NR OQB66289.1 1852919 g11031 i0 100 2 81 0 100 0 243 1 155 235 OQB66289.1 MAG: Ribosomal large subunit pseudouridine synthase D [Tenericutes bacterium ADurb.Bin140] diamond 486 155 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.Bin140

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