RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA473799", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 8 ✖

tax_kingdom 1

  • Bacillati · 8 ✖

bioproject 1

  • PRJNA473799 · 8 ✖

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
1095491 1095491 PRJNA473799_P_NODE_11481_length_311_cov_1.285714_g11207_i0 PRJNA473799 11481 311 1.285714 3.99857054 Mesomycoplasma 2923352 Bacteria Bacteria 569 6.489999999999998e-158   NTclustered gi|1720621726|gb|CP035041.1| 2100 g11207 i0 99.678 18.2700964630225 311 1 100 0 1 311 100167 100477 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 5682 569 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
1095695 1095695 PRJNA473799_P_NODE_30661_length_258_cov_0.962162_g30387_i0 PRJNA473799 30661 258 0.962162 2.48237796 Mesomycoplasma 2923352 Bacteria Bacteria 363 9.55e-96   NTclustered gi|1720621726|gb|CP035041.1| 2100 g30387 i0 99.015 33.0503875968992 203 0 78 2 58 258 191630 191832 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 8527 363 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
1095769 1095769 PRJNA473799_P_NODE_39841_length_248_cov_1.588571_g39567_i0 PRJNA473799 39841 248 1.588571 3.93965608 Mesomycoplasma 2923352 Bacteria Bacteria 459 1.13e-124   NTclustered gi|1720621726|gb|CP035041.1| 2100 g39567 i0 100 40.9435483870968 248 0 100 0 1 248 356978 357225 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 10154 459 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
3646697 3646697 PRJNA473799_P_NODE_13963_length_293_cov_1.050000_g13689_i0 PRJNA473799 13963 293 1.05 3.0765 Mesomycoplasma 2923352 Bacteria Bacteria 536 6.149999999999998e-148   NTclustered gi|2290922541|gb|CP102738.1| 2100 g13689 i0 99.659 416.081911262799 293 1 100 0 1 293 149175 149467 Mesomycoplasma hyorhinis strain N36N21c chromosome, complete genome blastn 121912 536 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
7473585 7473585 PRJNA473799_P_NODE_18806_length_281_cov_1.173077_g18532_i0 PRJNA473799 18806 281 1.173077 3.29634637 Mesomycoplasma 2923352 Bacteria Bacteria 366 8.15e-97   NTclustered gi|1720621726|gb|CP035041.1| 2100 g18532 i0 100 198.434163701068 198 0 70 0 84 281 723963 723766 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 55760 366 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
18947333 18947333 PRJNA473799_P_NODE_46295_length_245_cov_0.895349_g46021_i0 PRJNA473799 46295 245 0.895349 2.19360505 Mesomycoplasma 2923352 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2713084492|gb|CP150431.1| 2100 g46021 i0 100 15.9877551020408 245 0 100 0 1 245 509159 508915 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 3917 453 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
21497325 21497325 PRJNA473799_P_NODE_10017_length_334_cov_0.885057_g9743_i0 PRJNA473799 10017 334 0.885057 2.95609038 Mesomycoplasma 2923352 Bacteria Bacteria 612 1.15e-170   NTclustered gi|2713084492|gb|CP150431.1| 2100 g9743 i0 99.701 14.9820359281437 334 1 100 0 1 334 784648 784315 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 5004 612 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
25321772 25321772 PRJNA473799_P_NODE_13840_length_294_cov_0.923077_g13566_i0 PRJNA473799 13840 294 0.923077 2.71384638 Mesomycoplasma 2923352 Bacteria Bacteria 544 3.69e-150   NTclustered gi|2713084492|gb|CP150431.1| 2100 g13566 i0 100 58.7448979591837 294 0 100 0 1 294 696685 696392 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 17271 544 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);;