RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA728642" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 10 ✖

tax_phylum 1

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA728642 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
8366174 8366174 PRJNA728642_P_NODE_2687_length_635_cov_1.411032_g2423_i0 PRJNA728642 2687 635 1.411032 8.9600532 Halococcus dombrowskii 179637 Archaea Archaea 924 0   NTclustered gi|2221492933|gb|CP095007.1| 179637 g2423 i0 92.936 146.71811023622 637 42 100 3 1 635 130226 129591 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 93166 924 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
12674552 12674552 PRJNA728642_P_NODE_19690_length_241_cov_0.916667_g19419_i0 PRJNA728642 19690 241 0.916667 2.20916747 Halobacteriales 2235 Archaea Archaea 390 4.05e-104   NTclustered gi|1675273172|gb|MN000365.1| 29284 g19419 i0 95.851 99.253112033195 241 10 100 0 1 241 6 246 Halorubrum trapanicum strain ISD451 16S ribosomal RNA gene, partial sequence blastn 23920 390 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum trapanicum
16498145 16498145 PRJNA728642_P_NODE_9113_length_337_cov_1.166667_g8842_i0 PRJNA728642 9113 337 1.166667 3.93166779 root 1 Root_unresolved Root_unresolved 623 5.369999999999999e-174   NTclustered gi|436492|gb|U00707.1|PSU00707 33866 g8842 i0 100 11.5964391691395 337 0 100 0 1 337 1133 797 Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds blastn 3908 623 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Pyrococcus Pyrococcus sp.
17772659 17772659 PRJNA728642_P_NODE_12594_length_284_cov_1.402844_g12323_i0 PRJNA728642 12594 284 1.402844 3.98407696 Halococcus 2249 Archaea Archaea 479 1.01e-130   NTclustered gi|2221492933|gb|CP095007.1| 179637 g12323 i0 97.183 180.316901408451 284 7 100 1 1 284 129274 129556 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 51210 479 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
19046752 19046752 PRJNA728642_P_NODE_17575_length_246_cov_0.890173_g17304_i0 PRJNA728642 17575 246 0.890173 2.18982558 root 1 Root_unresolved Root_unresolved 455 1.4500000000000002e-123   NTclustered gi|436492|gb|U00707.1|PSU00707 33866 g17304 i0 100 7.97967479674797 246 0 100 0 1 246 362 607 Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds blastn 1963 455 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Pyrococcus Pyrococcus sp.
19839663 19839663 PRJNA728642_P_NODE_11316_length_301_cov_1.276316_g11045_i0 PRJNA728642 11316 301 1.276316 3.84171116 Halococcus qingdaonensis 224402 Archaea Archaea 460 3.9299999999999997e-125   NTclustered gi|2281256326|gb|CP101943.1| 224402 g11045 i0 94.631 164.328903654485 298 14 99 2 5 301 2645385 2645681 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 49463 460 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
20321435 20321435 PRJNA728642_P_NODE_16756_length_248_cov_3.074286_g16485_i0 PRJNA728642 16756 248 3.074286 7.62422928 root 1 Root_unresolved Root_unresolved 459 1.13e-124   NTclustered gi|436492|gb|U00707.1|PSU00707 33866 g16485 i0 100 11.616935483871 248 0 100 0 1 248 1801 1554 Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds blastn 2881 459 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Pyrococcus Pyrococcus sp.
20321662 20321662 PRJNA728642_P_NODE_8796_length_343_cov_1.425926_g8525_i0 PRJNA728642 8796 343 1.425926 4.89092618 Halococcus 2249 Archaea Archaea 617 2.55e-172   NTclustered gi|2746137121|gb|PP939405.1| 29295 g8525 i0 99.125 99.6705539358601 343 3 100 0 1 343 12 354 Halophilic archaeon strain SDF51 16S ribosomal RNA gene, partial sequence blastn 34187 617 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     halophilic archaeon
22390310 22390310 PRJNA728642_P_NODE_18158_length_245_cov_0.895349_g17887_i0 PRJNA728642 18158 245 0.895349 2.19360505 uncultured archaeon 115547 Archaea Archaea 453 5.1900000000000006e-123   NTclustered gi|1879319489|gb|MT797988.1| 115547 g17887 i0 100 103.595918367347 245 0 100 0 1 245 1470 1226 Uncultured archaeon clone PaddyMarine5 16S ribosomal RNA gene, partial sequence blastn 25381 453 1 Archaea               uncultured archaeon
25421527 25421527 PRJNA728642_P_NODE_16760_length_248_cov_2.640000_g16489_i0 PRJNA728642 16760 248 2.64 6.5472 Halococcus 2249 Archaea Archaea 431 2.47e-116   NTclustered gi|2221492933|gb|CP095007.1| 179637 g16489 i0 97.984 161.983870967742 248 5 100 0 1 248 130842 131089 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 40172 431 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii

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