RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Bacillati · 6 ✖

bioproject 1

  • PRJNA436017 · 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
14459411 14459411 PRJNA436017_P_NODE_1172_length_866_cov_3.822678_g998_i0 PRJNA436017 1172 866 3.822678 33.10439148 uncultured Mycoplasma sp. 167967 Bacteria Bacteria 89.8 6.65e-13   NTclustered gi|2476866025|gb|OQ749685.1| 167967 g998 i0 76.647 5.93879907621247 167 31 19 8 685 847 298 460 Uncultured Mycoplasma sp. clone MM100 16S ribosomal RNA gene, partial sequence blastn 5143 89.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma uncultured Mycoplasma sp.
14459729 14459729 PRJNA436017_P_NODE_3192_length_523_cov_70.619342_g2916_i0 PRJNA436017 3192 523 70.619342 369.33915866 Malacoplasma microti 38746 Bacteria Bacteria 608 2.4299999999999988e-169   NTclustered gi|299851939|gb|HM135466.1| 38746 g2916 i0 87.856 147.751434034417 527 52 100 10 1 523 1178 1696 Mycoplasma microti strain IL371 23S ribosomal RNA gene, partial sequence blastn 77274 608 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma microti
16391638 16391638 PRJNA436017_P_NODE_5593_length_381_cov_8.066860_g5297_i0 PRJNA436017 5593 381 8.06686 30.7347366 root 1 Root_unresolved Root_unresolved 60.2 2.17e-4   NTclustered gi|1851159111|gb|CP054256.1| 2102 g5297 i0 91.111 10.5223097112861 45 3 12 1 2 45 1126130 1126174 Mycoplasma mycoides strain T1/44 GP chromosome, complete genome blastn 4009 60.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
25315240 25315240 PRJNA436017_P_NODE_2720_length_569_cov_30.904135_g2457_i0 PRJNA436017 2720 569 30.904135 175.84452815 Malacoplasma 2791001 Bacteria Bacteria 774 0   NTclustered gi|299851933|gb|HM135461.1| 2119 g2457 i0 91.228 134.764499121265 570 48 100 2 1 569 1705 2273 Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence blastn 76681 774 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
25315262 25315262 PRJNA436017_P_NODE_5300_length_394_cov_3.254902_g5004_i0 PRJNA436017 5300 394 3.254902 12.82431388 Mycoplasmoidales 2790996 Bacteria Bacteria 614 3.8299999999999996e-171   NTclustered gi|1563789200|emb|LR214962.1| 2115 g5004 i0 94.898 127.015228426396 392 20 99 0 3 394 355621 356012 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8 blastn 50044 614 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
31719357 31719357 PRJNA436017_P_NODE_17377_length_197_cov_1.462500_g17079_i0 PRJNA436017 17377 197 1.4625 2.881125 Malacoplasma sp. 2791014 Bacteria Bacteria 57 1.42e-8   NR MDE5766957.1 2791014 g17079 i0 67.6 0.517766497461929 34 11 51.8 0 87 188 28 61 MDE5766957.1 TM2 domain-containing protein [Malacoplasma sp.] diamond 102 57 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.

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