RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1028258" 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

bioproject 1

  • PRJNA1028258 · 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
163235 163235 PRJNA1028258_P_NODE_119921_length_244_cov_1.622857_g119358_i0 PRJNA1028258 119921 244 1.622857 3.95977108 Halococcus dombrowskii 179637 Archaea Archaea 351 1.9399999999999998e-92   NTclustered gi|2221492933|gb|CP095007.1| 179637 g119358 i0 92.946 1.97540983606557 241 17 99 0 1 241 244528 244768 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 482 351 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
165347 165347 PRJNA1028258_P_NODE_70981_length_305_cov_1.203390_g70418_i0 PRJNA1028258 70981 305 1.20339 3.6703395 Halobellus limi 699433 Archaea Archaea 54.7 0.008   NTclustered gi|1621075116|gb|CP031311.1| 699433 g70418 i0 100 0.095081967213114807 29 0 10 0 175 203 2176642 2176670 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
1437710 1437710 PRJNA1028258_P_NODE_103782_length_257_cov_2.531915_g103219_i0 PRJNA1028258 103782 257 2.531915 6.50702155 Methanoregula sp. 2052170 Archaea Archaea 62.1 3.88e-5   NTclustered gi|2381065543|gb|CP112999.1| 2052170 g103219 i0 92.857 0.272373540856031 42 3 16 0 117 158 1866984 1866943 MAG: Methanoregula sp. isolate DGG0 chromosome, complete genome blastn 70 62.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
1439187 1439187 PRJNA1028258_P_NODE_24602_length_513_cov_1.763514_g24043_i0 PRJNA1028258 24602 513 1.763514 9.04682682 Methanococcus aeolicus 42879 Archaea Archaea 58.4 0.001   NTclustered gi|150013142|gb|CP000743.1| 419665 g24043 i0 94.595 0.0721247563352826 37 2 7 0 107 143 1298365 1298329 Methanococcus aeolicus Nankai-3, complete genome blastn 37 58.4 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanococcaceae Methanococcus Methanococcus aeolicus
3990391 3990391 PRJNA1028258_P_NODE_152244_length_231_cov_0.864198_g151681_i0 PRJNA1028258 152244 231 0.864198 1.99629738 Haloplanus pelagicus 2949995 Archaea Archaea 56.5 0.002   NTclustered gi|2252468271|gb|CP098518.1| 2949995 g151681 i0 100 0.510822510822511 30 0 13 0 105 134 544641 544670 Haloplanus sp. HW8-1 chromosome, complete genome blastn 118 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus pelagicus
14191889 14191889 PRJNA1028258_P_NODE_119812_length_244_cov_1.691429_g119249_i0 PRJNA1028258 119812 244 1.691429 4.12708676 Halococcus dombrowskii 179637 Archaea Archaea 392 1.14e-104   NTclustered gi|2221489803|gb|CP095005.1| 179637 g119249 i0 95.547 2.01639344262295 247 7 100 4 1 244 2511421 2511176 Halococcus dombrowskii strain H4 chromosome, complete genome blastn 492 392 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
16740446 16740446 PRJNA1028258_P_NODE_132294_length_235_cov_0.855422_g131731_i0 PRJNA1028258 132294 235 0.855422 2.0102417 Halobaculum limi 3031916 Archaea Archaea 52.8 0.021   NTclustered gi|2471356524|gb|CP120468.1| 3031916 g131731 i0 100 0.119148936170213 28 0 12 0 176 203 628156 628129 Halobaculum limi strain YSMS11 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halobaculum Halobaculum limi
19291144 19291144 PRJNA1028258_P_NODE_71656_length_304_cov_0.804255_g71093_i0 PRJNA1028258 71656 304 0.804255 2.4449352 Halosolutus halophilus 1552990 Archaea Archaea 63.9 1.31e-5   NTclustered gi|2221357424|gb|CP094974.1| 1552990 g71093 i0 83.099 3.33881578947368 71 10 23 2 1 69 4280236 4280166 Halosolutus halophilus strain LT55 chromosome, complete genome blastn 1015 63.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halosolutus Halosolutus halophilus
21406484 21406484 PRJNA1028258_P_NODE_120437_length_244_cov_1.228571_g119874_i0 PRJNA1028258 120437 244 1.228571 2.99771324 Methanosarcina 2207 Archaea Archaea 56.5 0.002   NTclustered gi|805339246|gb|CP009504.1| 1434102 g119874 i0 87.5 0.35655737704918 48 6 20 0 13 60 2994882 2994929 Methanosarcina sp. WH1, complete genome blastn 87 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp. WH1
21840841 21840841 PRJNA1028258_P_NODE_161378_length_228_cov_1.660377_g160815_i0 PRJNA1028258 161378 228 1.660377 3.78565956 Natronomonas moolapensis 416273 Archaea Archaea 54.7 0.006   NTclustered gi|452081962|emb|HF582854.1| 268739 g160815 i0 100 0.12719298245614 29 0 13 0 109 137 2658382 2658410 Natronomonas moolapensis 8.8.11 complete genome blastn 29 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas moolapensis

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