RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB673", tax_kingdom = "Bacillati" 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

  • Bacillati · 4 ✖

bioproject 1

  • PRJEB673 · 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
1409476 1409476 PRJEB673_P_NODE_2762_length_596_cov_5.007130_g2459_i0 PRJEB673 2762 596 5.00713 29.8424948 Malacoplasma microti 38746 Bacteria Bacteria 577 7.869999999999998e-160   NTclustered gi|299851939|gb|HM135466.1| 38746 g2459 i0 87.824 123.164429530201 501 50 83 9 4 500 1642 1149 Mycoplasma microti strain IL371 23S ribosomal RNA gene, partial sequence blastn 73406 577 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma microti
7372840 7372840 PRJEB673_P_NODE_12166_length_155_cov_2.191667_g11817_i0 PRJEB673 12166 155 2.191667 3.39708385 Mycoplasmoidaceae 2790998 Bacteria Bacteria 198 1.5499999999999999e-46   NTclustered gi|119369652|gb|EF061769.1| 2097 g11817 i0 90.604 110.367741935484 149 14 96 0 1 149 208 60 Mycoplasma genitalium strain ATCC 33530 23S ribosomal RNA gene, partial sequence blastn 17107 198 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides Mycoplasmoides genitalium
9062132 9062132 PRJEB673_P_NODE_10588_length_171_cov_2.080882_g10239_i0 PRJEB673 10588 171 2.080882 3.55830822 Mycoplasma insons 386460 Bacteria Bacteria 252 1.32e-62   NTclustered gi|299851941|gb|HM135467.1| 386460 g10239 i0 92.982 245 171 12 100 0 1 171 2063 2233 Mycoplasma insons strain I17P1 23S ribosomal RNA gene, partial sequence blastn 41895 252 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma insons
19260522 19260522 PRJEB673_P_NODE_4756_length_423_cov_1.603093_g4408_i0 PRJEB673 4756 423 1.603093 6.78108339 uncultured Mycoplasma sp. 167967 Bacteria Bacteria 754 0   NTclustered gi|84873335|gb|DQ340193.1| 167967 g4408 i0 98.818 99.8605200945626 423 5 100 0 1 423 888 466 Uncultured Mycoplasma sp. clone TP-2 16S ribosomal RNA gene, partial sequence blastn 42241 754 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma uncultured Mycoplasma 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);;