RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA986547" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA986547 · 3 ✖
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
974133 974133 PRJNA986547_P_NODE_13841_length_229_cov_4.596154_g13759_i0 PRJNA986547 13841 229 4.596154 10.52519266 Thermococcus thioreducens 277988 Archaea Archaea 56.5 0.002   NTclustered gi|1214555413|gb|CP015105.1| 277988 g13759 i0 100 0.620087336244541 30 0 13 0 129 158 119146 119117 Thermococcus thioreducens strain OGL-20P chromosome, complete genome blastn 142 56.5 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus thioreducens
3524772 3524772 PRJNA986547_P_NODE_5483_length_274_cov_2.208955_g5401_i0 PRJNA986547 5483 274 2.208955 6.0525367 Halomicrobium salinisoli 2878391 Archaea Archaea 172 1.85e-38   NTclustered gi|2110956525|gb|CP084463.1| 2878391 g5401 i0 79.216 62.4160583941606 255 48 92 5 1 252 2251376 2251124 Halomicrobium salinisoli strain LT50 chromosome, complete genome blastn 17102 172 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halomicrobium Halomicrobium salinisoli
28668802 28668802 PRJNA986547_P_NODE_13647_length_231_cov_2.094937_g13565_i0 PRJNA986547 13647 231 2.094937 4.83930447 Methanosphaerula palustris 475088 Archaea Archaea 51.2 3.23e-5   NR WP_012618399.1 475088 g13565 i0 48.2 2.48051948051948 56 29 72.7 0 171 4 201 256 WP_012618399.1 sensor histidine kinase [Methanosphaerula palustris] diamond 573 51.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanosphaerula Methanosphaerula palustris

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