RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 9 ✖

bioproject 1

  • PRJNA690592 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
671285 671285 PRJNA690592_S_NODE_185221_length_251_cov_1.707865_g184207_i0 PRJNA690592 185221 251 1.707865 4.28674115 Haloferacaceae archaeon 50 3384156 Archaea Archaea 80.5 1.04e-10   NTclustered gi|2869714876|gb|CP175567.1| 3384156 g184207 i0 83.333 0.621513944223108 90 12 40 3 70 158 294056 294143 Haloferacaceae archaeon 50 chromosome, complete genome blastn 156 80.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae   Haloferacaceae archaeon 50
671500 671500 PRJNA690592_S_NODE_210221_length_243_cov_0.905882_g209207_i0 PRJNA690592 210221 243 0.905882 2.20129326 Halobellus limi 699433 Archaea Archaea 54.7 0.006   NTclustered gi|1621075116|gb|CP031311.1| 699433 g209207 i0 100 0.119341563786008 29 0 12 0 86 114 2657109 2657137 Halobellus limi strain CGMCC 1.10331 chromosome, complete genome blastn 29 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halobellus Halobellus limi
672132 672132 PRJNA690592_S_NODE_93201_length_337_cov_1.242424_g92187_i0 PRJNA690592 93201 337 1.242424 4.18696888 Methanobacterium sp. BRmetb2 2025350 Archaea Archaea 54.7 0.009   NTclustered gi|1473087786|gb|CP022705.1| 2025350 g92187 i0 100 0.086053412462908 29 0 9 0 224 252 194685 194657 MAG: Methanobacterium sp. BRmetb2 chromosome, complete genome blastn 29 54.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp. BRmetb2
1948102 1948102 PRJNA690592_S_NODE_90902_length_340_cov_2.074906_g89888_i0 PRJNA690592 90902 340 2.074906 7.0546804 Methanosarcinales archaeon Met12 1914862 Archaea Archaea 58.4 6.9e-4   NTclustered gi|2647574341|gb|CP017966.2| 1914862 g89888 i0 81.944 0.952941176470588 72 10 21 3 58 127 620810 620740 MAG: Methanosarcinales archaeon Met12 chromosome, complete genome blastn 324 58.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon Met12
3221756 3221756 PRJNA690592_S_NODE_133863_length_291_cov_1.059633_g132849_i0 PRJNA690592 133863 291 1.059633 3.08353203 Methanosarcina lacustris 170861 Archaea Archaea 58.4 5.79e-4   NTclustered gi|805377189|gb|CP009515.1| 1434111 g132849 i0 94.595 0.127147766323024 37 2 13 0 52 88 1659170 1659134 Methanosarcina lacustris Z-7289, complete genome blastn 37 58.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina lacustris
8325020 8325020 PRJNA690592_S_NODE_61167_length_403_cov_1.215152_g60153_i0 PRJNA690592 61167 403 1.215152 4.89706256 Archaeoglobus profundus 84156 Archaea Archaea 52.8 0.039   NTclustered gi|284011125|gb|CP001857.1| 572546 g60153 i0 96.875 0.0794044665012407 32 0 8 1 145 175 615993 616024 Archaeoglobus profundus DSM 5631, complete genome blastn 32 52.8 1 Archaea   Methanobacteriati Methanobacteriota Archaeoglobi Archaeoglobales Archaeoglobaceae Archaeoglobus Archaeoglobus profundus
8325228 8325228 PRJNA690592_S_NODE_93387_length_337_cov_0.871212_g92373_i0 PRJNA690592 93387 337 0.871212 2.93598444 Methanothermobacter sp. EMTCatA1 2017966 Archaea Archaea 56.5 0.002   NTclustered gi|1214917725|dbj|AP018336.1| 2017966 g92373 i0 97.059 0.100890207715134 34 0 10 1 22 55 437476 437508 Methanothermobacter sp. EMTCatA1 DNA, complete genome blastn 34 56.5 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanothermobacter Methanothermobacter sp. EMTCatA1
10874892 10874892 PRJNA690592_S_NODE_121269_length_303_cov_1.317391_g120255_i0 PRJNA690592 121269 303 1.317391 3.99169473 Haloprofundus salinisoli 2876193 Archaea Archaea 56.5 0.002   NTclustered gi|2099489100|gb|CP083663.1| 2876193 g120255 i0 96.97 0.108910891089109 33 1 11 0 2 34 2766829 2766861 Haloprofundus salinisoli strain SQT7-1 chromosome, complete genome blastn 33 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloprofundus Haloprofundus salinisoli
18523957 18523957 PRJNA690592_S_NODE_71155_length_377_cov_2.368421_g70141_i0 PRJNA690592 71155 377 2.368421 8.92894717 halophilic archaeon DL31 756883 Archaea Archaea 52.8 0.036   NTclustered gi|344322453|gb|CP002989.1| 756883 g70141 i0 100 0.0742705570291777 28 0 7 0 165 192 171086 171059 Halophilic archaeon DL31 plasmid phalar01, complete sequence blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     halophilic archaeon DL31

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