RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120203 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
3578784 3578784 PRJNA1120203_P_NODE_88883_length_247_cov_0.885057_g87867_i0 PRJNA1120203 88883 247 0.885057 2.18609079 Archaea 2157 Archaea Archaea 56.5 0.002   NTclustered gi|663506435|gb|KF900500.1| 1457827 g87867 i0 100 0.242914979757085 30 0 12 0 218 247 14818 14847 Uncultured marine group II/III euryarchaeote AD1000_95_H05 genomic sequence blastn 60 56.5 1 Archaea   Methanobacteriati Methanobacteriota         uncultured marine group II/III euryarchaeote AD1000_95_H05
6131101 6131101 PRJNA1120203_P_NODE_94585_length_245_cov_0.895349_g93569_i0 PRJNA1120203 94585 245 0.895349 2.19360505 Methanobrevibacter 2172 Archaea Archaea 453 5.1900000000000006e-123   NTclustered gi|2791693311|gb|CP144200.1| 2173 g93569 i0 100 7 245 0 100 0 1 245 463916 464160 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 1715 453 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
7405380 7405380 PRJNA1120203_P_NODE_103026_length_242_cov_0.911243_g102010_i0 PRJNA1120203 103026 242 0.911243 2.20520806 Methanobrevibacter 2172 Archaea Archaea 442 1.1099999999999995e-119   NTclustered gi|2791693311|gb|CP144200.1| 2173 g102010 i0 99.587 7.00826446280992 242 1 100 0 1 242 1052194 1052435 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 1696 442 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
8681403 8681403 PRJNA1120203_P_NODE_89827_length_247_cov_0.885057_g88811_i0 PRJNA1120203 89827 247 0.885057 2.18609079 Methanobrevibacter 2172 Archaea Archaea 451 1.88e-122   NTclustered gi|2791693311|gb|CP144200.1| 2173 g88811 i0 99.595 7.0080971659919 247 1 100 0 1 247 799130 799376 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 1731 451 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
10479014 10479014 PRJNA1120203_P_NODE_78209_length_251_cov_0.865169_g77193_i0 PRJNA1120203 78209 251 0.865169 2.17157419 Methanobrevibacter smithii 2173 Archaea Archaea 459 1.1499999999999996e-124   NTclustered gi|1294447101|gb|CP017803.1| 2173 g77193 i0 99.602 7 251 1 100 0 1 251 494346 494096 Methanobrevibacter smithii strain KB11 chromosome, complete genome blastn 1757 459 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
13028389 13028389 PRJNA1120203_P_NODE_22891_length_522_cov_2.024499_g21880_i0 PRJNA1120203 22891 522 2.024499 10.56788478 Thermococcus eurythermalis 1505907 Archaea Archaea 948 0   NTclustered gi|700302025|gb|CP008887.1| 1505907 g21880 i0 99.426 105.323754789272 523 2 100 1 1 522 174229 173707 Thermococcus eurythermalis strain A501, complete genome blastn 54979 948 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus eurythermalis
14304015 14304015 PRJNA1120203_P_NODE_63672_length_282_cov_1.430622_g62656_i0 PRJNA1120203 63672 282 1.430622 4.03435404 Methanobrevibacter smithii 2173 Archaea Archaea 505 1.6599999999999995e-138   NTclustered gi|2188913606|dbj|AP025587.1| 2173 g62656 i0 98.936 7.79787234042553 282 3 100 0 1 282 1166962 1167243 Methanobrevibacter smithii CE91-St68 DNA, complete genome blastn 2199 505 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
14304238 14304238 PRJNA1120203_P_NODE_79292_length_251_cov_0.865169_g78276_i0 PRJNA1120203 79292 251 0.865169 2.17157419 Methanobrevibacter smithii 2173 Archaea Archaea 453 5.34e-123   NTclustered gi|1294447101|gb|CP017803.1| 2173 g78276 i0 99.203 7 251 2 100 0 1 251 603627 603877 Methanobrevibacter smithii strain KB11 chromosome, complete genome blastn 1757 453 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
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);;