RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA793147", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Mycoplasmatota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA793147 · 6 ✖

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
8869154 8869154 PRJNA793147_P_NODE_51727_length_234_cov_1.745455_g51461_i0 PRJNA793147 51727 234 1.745455 4.0843647 Mycoplasmopsis 2767358 Bacteria Bacteria 433 6.41e-117   NTclustered gi|1315669398|emb|LT578418.1| 2110 g51461 i0 100 179.995726495727 234 0 100 0 1 234 91430 91197 Mycoplasma agalactiae isolate JF4428 genome assembly, chromosome: I blastn 42119 433 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis agalactiae
13532017 13532017 PRJNA793147_P_NODE_9051_length_582_cov_7.115010_g8790_i0 PRJNA793147 9051 582 7.11501 41.4093582 Mycoplasma corogypsi 2106 Bacteria Bacteria 54.7 0.016   NTclustered gi|2860285583|gb|CP174163.1| 2106 g8790 i0 100 0.0498281786941581 29 0 5 0 512 540 335177 335149 Mycoplasma corogypsi strain BV1 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma corogypsi
14806977 14806977 PRJNA793147_P_NODE_9712_length_559_cov_6.844898_g9450_i0 PRJNA793147 9712 559 6.844898 38.26297982 Mycoplasma corogypsi 2106 Bacteria Bacteria 54.7 0.015   NTclustered gi|2860285583|gb|CP174163.1| 2106 g9450 i0 100 0.0518783542039356 29 0 5 0 519 547 335177 335149 Mycoplasma corogypsi strain BV1 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma corogypsi
17793605 17793605 PRJNA793147_P_NODE_29614_length_307_cov_1.210084_g29348_i0 PRJNA793147 29614 307 1.210084 3.71495788 Mollicutes 31969 Bacteria Bacteria 568 2.3e-157   NTclustered gi|2111402438|gb|CP068733.1| 28903 g29348 i0 100 181.100977198697 307 0 100 0 1 307 727441 727135 Mycoplasmopsis bovis strain J81 chromosome, complete genome blastn 55598 568 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
20342436 20342436 PRJNA793147_P_NODE_55296_length_231_cov_1.777778_g55030_i0 PRJNA793147 55296 231 1.777778 4.10666718 Mycoplasmopsis 2767358 Bacteria Bacteria 427 2.9399999999999998e-115   NTclustered gi|2111402438|gb|CP068733.1| 28903 g55030 i0 100 191.186147186147 231 0 100 0 1 231 722827 723057 Mycoplasmopsis bovis strain J81 chromosome, complete genome blastn 44164 427 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
30243477 30243477 PRJNA793147_P_NODE_27292_length_319_cov_1.148000_g27026_i0 PRJNA793147 27292 319 1.148 3.66212 Mycoplasma sp. Pen4 640330 Bacteria Bacteria 97.8 1.2500000000000001e-22   NR WP_187469762.1 640330 g27026 i0 50 1.90909090909091 98 48 91.2 1 10 300 67 164 WP_187469762.1 uracil-DNA glycosylase [Mycoplasma sp. Pen4] diamond 609 97.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. Pen4

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