RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA849646" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA849646 · 4 ✖

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
3388966 3388966 PRJNA849646_P_NODE_28943_length_251_cov_2.292135_g28825_i0 PRJNA849646 28943 251 2.292135 5.75325885 Mycoplasma cottewii 51364 Bacteria Bacteria 54.7 0.006   NTclustered gi|2294785939|gb|CP103424.1| 51364 g28825 i0 100 0.115537848605578 29 0 12 0 46 74 98256 98284 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
3785287 3785287 PRJNA849646_P_NODE_34243_length_246_cov_0.890173_g34125_i0 PRJNA849646 34243 246 0.890173 2.18982558 Mycoplasmoidales 2790996 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|1337042528|gb|CP026341.1| 2098 g34125 i0 100 4 246 0 100 0 1 246 672471 672716 Metamycoplasma hominis isolate 2539 chromosome, complete genome blastn 984 455 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma hominis
22514937 22514937 PRJNA849646_P_NODE_22478_length_263_cov_3.473684_g22360_i0 PRJNA849646 22478 263 3.473684 9.13578892 Metamycoplasma faucium 56142 Bacteria Bacteria 427 3.41e-115   NTclustered gi|2708452869|gb|CP088155.1| 56142 g22360 i0 95.849 1.00760456273764 265 9 100 1 1 263 803281 803545 Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome blastn 265 427 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
25064190 25064190 PRJNA849646_P_NODE_12220_length_283_cov_2.195238_g12102_i0 PRJNA849646 12220 283 2.195238 6.21252354 Spiroplasma melliferum 2134 Bacteria Bacteria 56.5 0.002   NTclustered gi|1634056650|gb|CP029202.1| 2134 g12102 i0 92.5 0.141342756183746 40 2 14 1 92 130 483269 483308 Spiroplasma melliferum strain AS576 chromosome, complete genome blastn 40 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma melliferum

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