RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Bacillati · 20 ✖

bioproject 1

  • PRJNA1118794 · 20 ✖

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
1025004 1025004 PRJNA1118794_P_NODE_75581_length_228_cov_3.470968_g74831_i0 PRJNA1118794 75581 228 3.470968 7.91380704 Mesomycoplasma 2923352 Bacteria Bacteria 420 4.84e-113   NTclustered gi|2713084492|gb|CP150431.1| 2100 g74831 i0 100 15.9166666666667 227 0 99 0 2 228 373105 372879 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 3629 420 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
3575516 3575516 PRJNA1118794_P_NODE_34903_length_280_cov_1.333333_g34153_i0 PRJNA1118794 34903 280 1.333333 3.7333324 Mesomycoplasma 2923352 Bacteria Bacteria 518 2.12e-142   NTclustered gi|1720621726|gb|CP035041.1| 2100 g34153 i0 100 16.0178571428571 280 0 100 0 1 280 175209 175488 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 4485 518 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
3575544 3575544 PRJNA1118794_P_NODE_44223_length_259_cov_7.612903_g43473_i0 PRJNA1118794 44223 259 7.612903 19.71741877 Mollicutes 31969 Bacteria Bacteria 470 5.5e-128   NTclustered gi|281186802|gb|GU227407.1| 2099 g43473 i0 99.611 99.2355212355212 257 1 99 0 1 257 746 490 Mycoplasma hyopneumoniae strain USP14P 16S ribosomal RNA gene, partial sequence blastn 25702 470 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyopneumoniae
4057344 4057344 PRJNA1118794_P_NODE_25644_length_310_cov_3.308017_g24894_i0 PRJNA1118794 25644 310 3.308017 10.2548527 Mycoplasma yeatsii 51365 Bacteria Bacteria 261 4.42e-65   NTclustered gi|756767228|gb|CP007520.1| 743967 g24894 i0 98 26.041935483871 150 3 96 0 161 310 25827 25976 Mycoplasma yeatsii GM274B blastn 8073 261 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
4057556 4057556 PRJNA1118794_P_NODE_42424_length_263_cov_1.926316_g41674_i0 PRJNA1118794 42424 263 1.926316 5.06621108 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 486 5.5499999999999986e-133   NTclustered gi|1563796921|emb|LR215008.1| 2107 g41674 i0 100 2 263 0 100 0 1 263 254976 254714 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 526 486 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
4057850 4057850 PRJNA1118794_P_NODE_68204_length_243_cov_0.905882_g67454_i0 PRJNA1118794 68204 243 0.905882 2.20129326 Mycoplasma cottewii 51364 Bacteria Bacteria 350 6.94e-92   NTclustered gi|2294785939|gb|CP103424.1| 51364 g67454 i0 92.593 1 243 18 100 0 1 243 850178 850420 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 243 350 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
6127867 6127867 PRJNA1118794_P_NODE_34725_length_280_cov_2.173913_g33975_i0 PRJNA1118794 34725 280 2.173913 6.0869564 Mesomycoplasma 2923352 Bacteria Bacteria 507 4.58e-139   NTclustered gi|1720621726|gb|CP035041.1| 2100 g33975 i0 99.286 29.9607142857143 280 2 100 0 1 280 325473 325752 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 8389 507 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
6608829 6608829 PRJNA1118794_P_NODE_46406_length_255_cov_1.527473_g45656_i0 PRJNA1118794 46406 255 1.527473 3.89505615 Metamycoplasma orale 2121 Bacteria Bacteria 470 5.4e-128   NTclustered gi|1563679895|emb|LR214940.1| 2121 g45656 i0 100 156.180392156863 254 0 99 0 1 254 699037 699290 Mycoplasma orale strain NCTC10112 genome assembly, chromosome: 1 blastn 39826 470 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma orale
7402853 7402853 PRJNA1118794_P_NODE_55846_length_248_cov_0.880000_g55096_i0 PRJNA1118794 55846 248 0.88 2.1824 Metamycoplasma 2895509 Bacteria Bacteria 54.7 0.006   NTclustered gi|1495885541|gb|CP033021.1| 2098 g55096 i0 100 0.80241935483871 29 0 12 0 8 36 338460 338488 Metamycoplasma hominis strain TO0613 chromosome, complete genome blastn 199 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma hominis
7883738 7883738 PRJNA1118794_P_NODE_48107_length_251_cov_4.943820_g47357_i0 PRJNA1118794 48107 251 4.94382 12.4089882 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 464 2.47e-126   NTclustered gi|1563796921|emb|LR215008.1| 2107 g47357 i0 100 155.681274900398 251 0 100 0 1 251 798204 798454 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 39076 464 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
11228276 11228276 PRJNA1118794_P_NODE_25629_length_310_cov_4.299578_g24879_i0 PRJNA1118794 25629 310 4.299578 13.3286918 Mesomycoplasma 2923352 Bacteria Bacteria 278 4.39e-70   NTclustered gi|1720621726|gb|CP035041.1| 2100 g24879 i0 100 14.5161290322581 150 0 97 0 161 310 768296 768147 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 4500 278 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
11709292 11709292 PRJNA1118794_P_NODE_29210_length_295_cov_6.360360_g28460_i0 PRJNA1118794 29210 295 6.36036 18.763062 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 278 4.15e-70   NTclustered gi|14089695|emb|AL445564.1| 2107 g28460 i0 100 3.74915254237288 150 0 100 0 1 150 24257 24108 Mycoplasma pulmonis (strain UAB CTIP) complete genome; segment 2/3 blastn 1106 278 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
12503873 12503873 PRJNA1118794_P_NODE_52010_length_250_cov_0.870056_g51260_i0 PRJNA1118794 52010 250 0.870056 2.17514 Acholeplasma 2147 Bacteria Bacteria 462 8.83e-126   NTclustered gi|1403529253|emb|LS483439.1| 2148 g51260 i0 100 4 250 0 100 0 1 250 404129 404378 Acholeplasma laidlawii strain NCTC10116 genome assembly, chromosome: 1 blastn 1000 462 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma laidlawii
12503924 12503924 PRJNA1118794_P_NODE_73530_length_241_cov_0.916667_g72780_i0 PRJNA1118794 73530 241 0.916667 2.20916747 Mesomycoplasma 2923352 Bacteria Bacteria 440 3.959999999999999e-119   NTclustered gi|1720621726|gb|CP035041.1| 2100 g72780 i0 99.585 15 241 1 100 0 1 241 578459 578699 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3615 440 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
18082224 18082224 PRJNA1118794_P_NODE_28955_length_296_cov_4.713004_g28205_i0 PRJNA1118794 28955 296 4.713004 13.95049184 Mycoplasma cottewii 51364 Bacteria Bacteria 250 9.08e-62   NTclustered gi|2294785939|gb|CP103424.1| 51364 g28205 i0 95.513 26.3885135135135 156 7 100 0 1 156 871141 870986 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 7811 250 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
19356496 19356496 PRJNA1118794_P_NODE_30096_length_292_cov_1.406393_g29346_i0 PRJNA1118794 30096 292 1.406393 4.10666756 endosymbiont DhMRE of Dentiscutata heterogama 1609546 Bacteria Bacteria 387 6.53e-103   NTclustered gi|820946451|emb|LN828718.1| 1609546 g29346 i0 90.785 205.962328767123 293 22 100 5 1 292 615403 615691 endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1 blastn 60141 387 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     endosymbiont DhMRE of Dentiscutata heterogama
20151425 20151425 PRJNA1118794_P_NODE_48316_length_251_cov_1.702247_g47566_i0 PRJNA1118794 48316 251 1.702247 4.27263997 Mesomycoplasma 2923352 Bacteria Bacteria 464 2.47e-126   NTclustered gi|2713084492|gb|CP150431.1| 2100 g47566 i0 100 14.9880478087649 251 0 100 0 1 251 65888 65638 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 3762 464 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
21426988 21426988 PRJNA1118794_P_NODE_52937_length_249_cov_1.448864_g52187_i0 PRJNA1118794 52937 249 1.448864 3.60767136 Mesomycoplasma 2923352 Bacteria Bacteria 449 6.840000000000001e-122   NTclustered gi|1720621726|gb|CP035041.1| 2100 g52187 i0 99.197 11 249 2 100 0 1 249 230345 230097 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 2739 449 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
23183182 23183182 PRJNA1118794_P_NODE_61559_length_246_cov_0.890173_g60809_i0 PRJNA1118794 61559 246 0.890173 2.18982558 Mycoplasma cottewii 51364 Bacteria Bacteria 433 6.79e-117   NTclustered gi|2294785939|gb|CP103424.1| 51364 g60809 i0 98.374 81.0487804878049 246 4 100 0 1 246 763697 763452 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 19938 433 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
32471131 32471131 PRJNA1118794_P_NODE_50559_length_250_cov_1.666667_g49809_i0 PRJNA1118794 50559 250 1.666667 4.1666675 Mycoplasma sp. HU2 2108 Bacteria Bacteria 149 3.6699999999999996e-42   NR WP_050517614.1 1664275 g49809 i0 100 0.888 74 0 88.8 0 27 248 1 74 WP_050517614.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 222 149 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014

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