RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Bacillati · 3 ✖

bioproject 1

  • PRJNA980585 · 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
25180942 25180942 PRJNA980585_P_NODE_37780_length_258_cov_1.497297_g37526_i0 PRJNA980585 37780 258 1.497297 3.86302626 uncultured Mycoplasma sp. 167967 Bacteria Bacteria 65.8 3.02e-6   NTclustered gi|2288428509|gb|OP271904.1| 167967 g37526 i0 93.333 3.08914728682171 45 1 17 2 204 247 322 279 Uncultured Mycoplasma sp. clone 269 23S ribosomal RNA gene, partial sequence blastn 797 65.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma uncultured Mycoplasma sp.
29148517 29148517 PRJNA980585_P_NODE_14729_length_362_cov_1.847751_g14475_i0 PRJNA980585 14729 362 1.847751 6.68885862 root 1 Root_unresolved Root_unresolved 89 5.4e-18   NR MBP5256822.1 2108 g14475 i0 52.7 10.2596685082873 91 30 67.1 3 361 119 10 97 MBP5256822.1 molecular chaperone DnaJ [Mycoplasma sp.] diamond 3714 89 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
30184136 30184136 PRJNA980585_P_NODE_56172_length_243_cov_0.905882_g55918_i0 PRJNA980585 56172 243 0.905882 2.20129326 Candidatus Moeniiplasma glomeromycotorum 1822367 Bacteria Bacteria 61.6 2.08e-9   NR MCE8162780.1 1822367 g55918 i0 33.9 0.765432098765432 62 41 76.5 0 187 2 82 143 MCE8162780.1 hypothetical protein [Candidatus Moeniiplasma glomeromycotorum] diamond 186 61.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Candidatus Moeniiplasma Candidatus Moeniiplasma glomeromycotorum

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