RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA763718" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA763718 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
10948326 10948326 PRJNA763718_S_NODE_7589_length_160_cov_0.934959_g7381_i0 PRJNA763718 7589 160 0.934959 1.4959344 Mariniplasma anaerobium 2735436 Bacteria Bacteria 150 4.569999999999999e-32   NTclustered gi|1964073164|dbj|AP024412.1| 2735436 g7381 i0 84.516 84.85625 155 20 96 4 5 157 1311171 1311323 Mariniplasma anaerobium DNA, complete genome blastn 13577 150 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Mariniplasma Mariniplasma anaerobium
12223896 12223896 PRJNA763718_S_NODE_6650_length_170_cov_1.090226_g6442_i0 PRJNA763718 6650 170 1.090226 1.8533842 Malacoplasma muris 2119 Bacteria Bacteria 237 3.6600000000000005e-58   NTclustered gi|299851933|gb|HM135461.1| 2119 g6442 i0 91.813 54.0411764705882 171 12 100 2 1 170 703 872 Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence blastn 9187 237 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
19871000 19871000 PRJNA763718_S_NODE_6036_length_178_cov_1.106383_g5828_i0 PRJNA763718 6036 178 1.106383 1.96936174 Malacoplasma microti 38746 Bacteria Bacteria 283 4.909999999999999e-72   NTclustered gi|299851939|gb|HM135466.1| 38746 g5828 i0 95.506 27.0337078651685 178 7 100 1 1 178 1437 1613 Mycoplasma microti strain IL371 23S ribosomal RNA gene, partial sequence blastn 4812 283 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma microti

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