RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 3 ✖

bioproject 1

  • PRJNA1120203 · 3 ✖

analysis 1

  • blastn · 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
275266 275266 PRJNA1120203_P_NODE_69981_length_268_cov_1.492308_g68965_i0 PRJNA1120203 69981 268 1.492308 3.99938544 Haloferax volcanii 2246 Archaea Archaea 490 4.39e-134   NTclustered gi|291370026|gb|CP001956.1| 309800 g68965 i0 99.627 5.23880597014925 268 1 100 0 1 268 719642 719909 Haloferax volcanii DS2, complete sequence blastn 1404 490 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloferax Haloferax volcanii
16330575 16330575 PRJNA1120203_P_NODE_78913_length_251_cov_0.865169_g77897_i0 PRJNA1120203 78913 251 0.865169 2.17157419 Haloarcula 2237 Archaea Archaea 202 2.13e-47   NTclustered gi|2461916621|gb|CP119559.1| 3032584 g77897 i0 81.6 3.80876494023904 250 40 98 6 1 247 2699501 2699747 Haloarcula halophila strain DFY41 chromosome, complete genome blastn 956 202 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Haloarcula Haloarcula halophila
16852727 16852727 PRJNA1120203_P_NODE_84594_length_249_cov_0.875000_g83578_i0 PRJNA1120203 84594 249 0.875 2.17875 Methanosarcina horonobensis 418008 Archaea Archaea 285 2.0399999999999997e-72   NTclustered gi|805380606|gb|CP009516.1| 1434110 g83578 i0 92.079 0.811244979919679 202 16 81 0 1 202 3978663 3978462 Methanosarcina horonobensis HB-1, complete genome blastn 202 285 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina horonobensis

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