RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA1218816" 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

  • PRJNA1218816 · 21 ✖

analysis 1

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
1046236 1046236 PRJNA1218816_P_NODE_49121_length_267_cov_1.340206_g48688_i0 PRJNA1218816 49121 267 1.340206 3.57835002 Mesomycoplasma 2923352 Bacteria Bacteria 494 3.38e-135   NTclustered gi|1720621726|gb|CP035041.1| 2100 g48688 i0 100 79.5355805243446 267 0 100 0 1 267 528724 528990 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 21236 494 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
3596774 3596774 PRJNA1218816_P_NODE_42943_length_292_cov_1.223744_g42510_i0 PRJNA1218816 42943 292 1.223744 3.57333248 Mesomycoplasma 2923352 Bacteria Bacteria 507 4.81e-139   NTclustered gi|1720621726|gb|CP035041.1| 2100 g42510 i0 97.945 15 292 6 100 0 1 292 152086 152377 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 4380 507 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
3596808 3596808 PRJNA1218816_P_NODE_59003_length_245_cov_1.139535_g58570_i0 PRJNA1218816 59003 245 1.139535 2.79186075 Mesomycoplasma 2923352 Bacteria Bacteria 440 4.0399999999999986e-119   NTclustered gi|1720621726|gb|CP035041.1| 2100 g58570 i0 99.184 15 245 1 100 1 1 245 331318 331561 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3675 440 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
4874427 4874427 PRJNA1218816_P_NODE_62784_length_241_cov_0.916667_g62351_i0 PRJNA1218816 62784 241 0.916667 2.20916747 Mesomycoplasma 2923352 Bacteria Bacteria 407 4.0199999999999995e-109   NTclustered gi|1720621726|gb|CP035041.1| 2100 g62351 i0 97.095 14.701244813278 241 7 100 0 1 241 336026 335786 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3543 407 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
8699253 8699253 PRJNA1218816_P_NODE_24387_length_426_cov_2.073654_g23954_i0 PRJNA1218816 24387 426 2.073654 8.83376604 Mesomycoplasma 2923352 Bacteria Bacteria 771 0   NTclustered gi|1052538474|gb|CP016817.1| 2100 g23954 i0 99.296 110.298122065728 426 3 100 0 1 426 19988 19563 Mesomycoplasma hyorhinis strain MDBK-IPV, complete genome blastn 46987 771 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
9974346 9974346 PRJNA1218816_P_NODE_43308_length_290_cov_1.880184_g42875_i0 PRJNA1218816 43308 290 1.880184 5.4525336 Mesomycoplasma 2923352 Bacteria Bacteria 536 6.079999999999999e-148   NTclustered gi|1720621726|gb|CP035041.1| 2100 g42875 i0 100 28.9793103448276 290 0 100 0 1 290 270578 270289 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 8404 536 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
9974400 9974400 PRJNA1218816_P_NODE_63668_length_233_cov_3.368750_g63235_i0 PRJNA1218816 63668 233 3.36875 7.8491875 Mesomycoplasma 2923352 Bacteria Bacteria 350 6.6e-92   NTclustered gi|1450419971|emb|LS991950.1| 2100 g63235 i0 100 15.2703862660944 189 0 99 0 45 233 643226 643038 Mycoplasma hyorhinis strain NCTC10130 genome assembly, chromosome: 1 blastn 3558 350 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
11249635 11249635 PRJNA1218816_P_NODE_58489_length_246_cov_0.890173_g58056_i0 PRJNA1218816 58489 246 0.890173 2.18982558 Mesomycoplasma 2923352 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|1720621726|gb|CP035041.1| 2100 g58056 i0 100 15.0081300813008 246 0 100 0 1 246 76854 76609 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3692 455 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
15073836 15073836 PRJNA1218816_P_NODE_32452_length_350_cov_1.003610_g32019_i0 PRJNA1218816 32452 350 1.00361 3.512635 Mesomycoplasma 2923352 Bacteria Bacteria 630 3.3399999999999984e-176   NTclustered gi|2713084492|gb|CP150431.1| 2100 g32019 i0 99.143 65.76 350 3 100 0 1 350 557169 556820 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 23016 630 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
15073847 15073847 PRJNA1218816_P_NODE_4452_length_1384_cov_3.412662_g4216_i0 PRJNA1218816 4452 1384 3.412662 47.23124208 Mesomycoplasma 2923352 Bacteria Bacteria 2556 0   NTclustered gi|1563681465|emb|LR214949.1| 2100 g4216 i0 100 21.7420520231214 1384 0 100 0 1 1384 646488 647871 Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3 blastn 30091 2556 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
15073865 15073865 PRJNA1218816_P_NODE_56492_length_248_cov_0.880000_g56059_i0 PRJNA1218816 56492 248 0.88 2.1824 Mesomycoplasma 2923352 Bacteria Bacteria 459 1.13e-124   NTclustered gi|1720621726|gb|CP035041.1| 2100 g56059 i0 100 15 248 0 100 0 1 248 667739 667492 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3720 459 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
16348771 16348771 PRJNA1218816_P_NODE_49573_length_265_cov_1.604167_g49140_i0 PRJNA1218816 49573 265 1.604167 4.25104255 Mesomycoplasma 2923352 Bacteria Bacteria 490 4.3299999999999986e-134   NTclustered gi|2713084492|gb|CP150431.1| 2100 g49140 i0 100 15 265 0 100 0 1 265 813989 813725 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 3975 490 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
17624021 17624021 PRJNA1218816_P_NODE_52094_length_256_cov_1.863388_g51661_i0 PRJNA1218816 52094 256 1.863388 4.77027328 Mesomycoplasma 2923352 Bacteria Bacteria 473 4.189999999999999e-129   NTclustered gi|1720621726|gb|CP035041.1| 2100 g51661 i0 100 15 256 0 100 0 1 256 798399 798654 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3840 473 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
18897763 18897763 PRJNA1218816_P_NODE_38455_length_313_cov_1.283333_g38022_i0 PRJNA1218816 38455 313 1.283333 4.01683229 Mesomycoplasma 2923352 Bacteria Bacteria 575 1.3999999999999999e-159   NTclustered gi|1720621726|gb|CP035041.1| 2100 g38022 i0 100 71.0638977635783 311 0 99 0 3 313 790000 789690 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 22243 575 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
18897765 18897765 PRJNA1218816_P_NODE_40475_length_303_cov_1.452174_g40042_i0 PRJNA1218816 40475 303 1.452174 4.40008722 Mesomycoplasma 2923352 Bacteria Bacteria 549 8.209999999999997e-152   NTclustered gi|1720621726|gb|CP035041.1| 2100 g40042 i0 99.667 65.5049504950495 300 1 99 0 4 303 789462 789163 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 19848 549 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
18897800 18897800 PRJNA1218816_P_NODE_56535_length_248_cov_0.880000_g56102_i0 PRJNA1218816 56535 248 0.88 2.1824 Mesomycoplasma 2923352 Bacteria Bacteria 453 5.2600000000000005e-123   NTclustered gi|2713084492|gb|CP150431.1| 2100 g56102 i0 99.597 15.3588709677419 248 1 100 0 1 248 363957 364204 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 3809 453 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
20172550 20172550 PRJNA1218816_P_NODE_22676_length_450_cov_1.225464_g22243_i0 PRJNA1218816 22676 450 1.225464 5.514588 Mesomycoplasma 2923352 Bacteria Bacteria 832 0   NTclustered gi|1720621726|gb|CP035041.1| 2100 g22243 i0 100 55.7866666666667 450 0 100 0 1 450 528013 528462 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 25104 832 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
20172598 20172598 PRJNA1218816_P_NODE_51276_length_259_cov_1.704301_g50843_i0 PRJNA1218816 51276 259 1.704301 4.41413959 Mesomycoplasma 2923352 Bacteria Bacteria 472 1.53e-128   NTclustered gi|1563681457|emb|LR214948.1| 2100 g50843 i0 99.614 17 259 0 100 1 1 259 1396 1653 Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 2 blastn 4403 472 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
21448117 21448117 PRJNA1218816_P_NODE_22057_length_459_cov_0.797927_g21624_i0 PRJNA1218816 22057 459 0.797927 3.66248493 Mesomycoplasma 2923352 Bacteria Bacteria 848 0   NTclustered gi|1720621726|gb|CP035041.1| 2100 g21624 i0 100 62.9651416122004 459 0 100 0 1 459 614079 614537 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 28901 848 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
21448137 21448137 PRJNA1218816_P_NODE_39897_length_306_cov_1.145923_g39464_i0 PRJNA1218816 39897 306 1.145923 3.50652438 Mesomycoplasma 2923352 Bacteria Bacteria 560 3.84e-155   NTclustered gi|1720621726|gb|CP035041.1| 2100 g39464 i0 99.673 53.2352941176471 306 1 100 0 1 306 681332 681637 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 16290 560 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
25272482 25272482 PRJNA1218816_P_NODE_60780_length_243_cov_1.211765_g60347_i0 PRJNA1218816 60780 243 1.211765 2.94458895 Mesomycoplasma 2923352 Bacteria Bacteria 449 6.65e-122   NTclustered gi|1720621726|gb|CP035041.1| 2100 g60347 i0 100 15 243 0 100 0 1 243 759594 759352 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3645 449 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis

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