RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA1016321", 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

  • PRJNA1016321 · 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
3985813 3985813 PRJNA1016321_P_NODE_20684_length_418_cov_1.623188_g20453_i0 PRJNA1016321 20684 418 1.623188 6.78492584 Mycoplasma yeatsii 51365 Bacteria Bacteria 701 0   NTclustered gi|756767228|gb|CP007520.1| 743967 g20453 i0 96.89 71.7153110047847 418 13 100 0 1 418 530621 531038 Mycoplasma yeatsii GM274B blastn 29977 701 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
6538220 6538220 PRJNA1016321_P_NODE_54946_length_242_cov_1.822485_g54715_i0 PRJNA1016321 54946 242 1.822485 4.4104137 Mycoplasma yeatsii 51365 Bacteria Bacteria 431 2.4e-116   NTclustered gi|756767228|gb|CP007520.1| 743967 g54715 i0 98.76 4.97107438016529 242 3 100 0 1 242 529096 529337 Mycoplasma yeatsii GM274B blastn 1203 431 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
10362367 10362367 PRJNA1016321_P_NODE_12989_length_549_cov_4.197479_g12766_i0 PRJNA1016321 12989 549 4.197479 23.04415971 Mycoplasma yeatsii 51365 Bacteria Bacteria 854 0   NTclustered gi|756767228|gb|CP007520.1| 743967 g12766 i0 94.718 98.5719489981785 549 29 100 0 1 549 532456 531908 Mycoplasma yeatsii GM274B blastn 54116 854 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
13756111 13756111 PRJNA1016321_P_NODE_20431_length_421_cov_4.272989_g20200_i0 PRJNA1016321 20431 421 4.272989 17.98928369 Mesomycoplasma 2923352 Bacteria Bacteria 736 0   NTclustered gi|1720621726|gb|CP035041.1| 2100 g20200 i0 99.751 17.0546318289786 401 1 95 0 21 421 360477 360077 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 7180 736 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
15462297 15462297 PRJNA1016321_P_NODE_35953_length_298_cov_1.368889_g35722_i0 PRJNA1016321 35953 298 1.368889 4.07928922 Mycoplasma yeatsii 51365 Bacteria Bacteria 468 2.32e-127   NTclustered gi|756767228|gb|CP007520.1| 743967 g35722 i0 94.966 2 298 15 100 0 1 298 627627 627330 Mycoplasma yeatsii GM274B blastn 596 468 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
16736798 16736798 PRJNA1016321_P_NODE_4914_length_918_cov_3.835503_g4731_i0 PRJNA1016321 4914 918 3.835503 35.20991754 Mycoplasma yeatsii 51365 Bacteria Bacteria 1458 0   NTclustered gi|756767228|gb|CP007520.1| 743967 g4731 i0 95.316 77.4433551198257 918 43 100 0 1 918 530965 531882 Mycoplasma yeatsii GM274B blastn 71093 1458 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
20129184 20129184 PRJNA1016321_P_NODE_57836_length_214_cov_5.645390_g57605_i0 PRJNA1016321 57836 214 5.64539 12.0811346 Mycoplasma 2093 Bacteria Bacteria 366 5.93e-97   NTclustered gi|54609775|gb|AY765214.1| 51364 g57605 i0 99.502 175.53738317757 201 1 94 0 14 214 377 577 Mycoplasma cottewii strain ATCC 43093 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 37565 366 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
23111439 23111439 PRJNA1016321_P_NODE_12539_length_560_cov_2.550308_g12316_i0 PRJNA1016321 12539 560 2.550308 14.2817248 Mycoplasma yeatsii 51365 Bacteria Bacteria 996 0   NTclustered gi|756767228|gb|CP007520.1| 743967 g12316 i0 98.75 99.8107142857143 560 7 100 0 1 560 529324 529883 Mycoplasma yeatsii GM274B blastn 55894 996 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii

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