RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA1112809" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 21 ✖

bioproject 1

  • PRJNA1112809 · 21 ✖

analysis 1

  • blastn · 21 ✖
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
2299000 2299000 PRJNA1112809_P_NODE_68762_length_425_cov_9.605114_g65488_i0 PRJNA1112809 68762 425 9.605114 40.8217345 Ferroplasmaceae 90142 Archaea Archaea 765 0   NTclustered gi|1035428263|dbj|LC158422.1| 115547 g65488 i0 99.291 99.4847058823529 423 3 99 0 2 424 316 738 Uncultured archaeon gene for 16S rRNA, partial sequence, clone: NasMA65 blastn 42281 765 1 Archaea               uncultured archaeon
3574179 3574179 PRJNA1112809_P_NODE_88663_length_357_cov_3.820423_g85388_i0 PRJNA1112809 88663 357 3.820423 13.63891011 Methanobacterium 2160 Archaea Archaea 566 9.759999999999997e-157   NTclustered gi|584298061|gb|KF882000.1| 483896 g85388 i0 95.238 145.725490196078 357 17 100 0 1 357 2099 2455 Methanobacterium kanagiense strain 169 23S ribosomal RNA gene, partial sequence blastn 52024 566 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium kanagiense
4047148 4047148 PRJNA1112809_P_NODE_195404_length_237_cov_5.128049_g192129_i0 PRJNA1112809 195404 237 5.128049 12.15347613 Methanobacterium kanagiense 483896 Archaea Archaea 361 3.1099999999999996e-95   NTclustered gi|584298061|gb|KF882000.1| 483896 g192129 i0 94.093 132.46835443038 237 14 100 0 1 237 1786 1550 Methanobacterium kanagiense strain 169 23S ribosomal RNA gene, partial sequence blastn 31395 361 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium kanagiense
5322850 5322850 PRJNA1112809_P_NODE_178125_length_246_cov_0.890173_g174850_i0 PRJNA1112809 178125 246 0.890173 2.18982558 Halorubrum sp. CBA1229 1853699 Archaea Archaea 411 3.1799999999999995e-110   NTclustered gi|1861358827|gb|CP054585.1| 1853699 g174850 i0 96.748 11.8455284552846 246 8 100 0 1 246 1436703 1436948 Halorubrum sp. CBA1229 chromosome, complete genome blastn 2914 411 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. CBA1229
5323631 5323631 PRJNA1112809_P_NODE_41725_length_624_cov_4.513612_g38511_i0 PRJNA1112809 41725 624 4.513612 28.16493888 Methanobacterium aridiramus 2584467 Archaea Archaea 459 3.12e-124   NTclustered gi|2523005876|gb|CP040735.1| 2584467 g38511 i0 96.403 68.3509615384615 278 10 84 0 347 624 1376296 1376019 Methanobacterium aridiramus strain CWC-01 chromosome, complete genome blastn 42651 459 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium aridiramus
6126032 6126032 PRJNA1112809_P_NODE_111205_length_310_cov_2.603376_g107930_i0 PRJNA1112809 111205 310 2.603376 8.0704656 Natronomonadaceae 3402413 Archaea Archaea 268 2.64e-67   NTclustered gi|2273560680|gb|CP101167.1| 2962672 g107930 i0 99.324 10.8967741935484 148 1 48 0 1 148 80017 79870 Haloglomus halophilum strain ZY41 plasmid unnamed1, complete sequence blastn 3378 268 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Haloglomus Haloglomus halophilum
7872618 7872618 PRJNA1112809_P_NODE_165647_length_250_cov_3.022599_g162372_i0 PRJNA1112809 165647 250 3.022599 7.5564975 Natronomonas pharaonis 2257 Archaea Archaea 128 3.66e-25   NTclustered gi|76556520|emb|CR936257.1| 348780 g162372 i0 85.714 0.504 126 13 50 4 127 250 46188 46310 Natronomonas pharaonis DSM 2160 complete genome blastn 126 128 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas pharaonis
7872738 7872738 PRJNA1112809_P_NODE_172727_length_248_cov_0.880000_g169452_i0 PRJNA1112809 172727 248 0.88 2.1824 Halorubrum sp. CBA1229 1853699 Archaea Archaea 375 1.1699999999999999e-99   NTclustered gi|1861358827|gb|CP054585.1| 1853699 g169452 i0 93.952 25.8225806451613 248 15 100 0 1 248 460905 460658 Halorubrum sp. CBA1229 chromosome, complete genome blastn 6404 375 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. CBA1229
9147311 9147311 PRJNA1112809_P_NODE_156788_length_257_cov_1.673913_g153513_i0 PRJNA1112809 156788 257 1.673913 4.30195641 Natronococcus occultus 29288 Archaea Archaea 86.1 2.3e-12   NTclustered gi|433671692|gb|CP003929.1| 694430 g153513 i0 86.076 8.42023346303502 79 11 33 0 162 240 2571361 2571283 Natronococcus occultus SP4, complete genome blastn 2164 86.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus occultus
9147630 9147630 PRJNA1112809_P_NODE_176388_length_247_cov_0.885057_g173113_i0 PRJNA1112809 176388 247 0.885057 2.18609079 Natronomonas moolapensis 416273 Archaea Archaea 363 9.079999999999999e-96   NTclustered gi|452081962|emb|HF582854.1| 268739 g173113 i0 93.117 53.7246963562753 247 17 100 0 1 247 2642295 2642541 Natronomonas moolapensis 8.8.11 complete genome blastn 13270 363 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas moolapensis
11698947 11698947 PRJNA1112809_P_NODE_192850_length_241_cov_0.916667_g189575_i0 PRJNA1112809 192850 241 0.916667 2.20916747 Natronomonas moolapensis 416273 Archaea Archaea 289 1.52e-73   NTclustered gi|452081962|emb|HF582854.1| 268739 g189575 i0 88.608 1.79253112033195 237 27 98 0 5 241 185926 185690 Natronomonas moolapensis 8.8.11 complete genome blastn 432 289 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas moolapensis
11699061 11699061 PRJNA1112809_P_NODE_199050_length_228_cov_3.283871_g195775_i0 PRJNA1112809 199050 228 3.283871 7.4872258799999996 Natrinema halophilum 1699371 Archaea Archaea 52.8 0.02   NTclustered gi|1868913181|gb|CP058601.1| 1699371 g195775 i0 100 0.12280701754386 28 0 12 0 42 69 2724209 2724236 Natrinema halophilum strain YPL8 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrinema Natrinema halophilum
12502201 12502201 PRJNA1112809_P_NODE_17870_length_1331_cov_3.517488_g15494_i0 PRJNA1112809 17870 1331 3.517488 46.81776528 Methanobacterium 2160 Archaea Archaea 1936 0   NTclustered gi|584298061|gb|KF882000.1| 483896 g15494 i0 93.798 152.585274229902 1290 76 97 4 18 1306 1488 202 Methanobacterium kanagiense strain 169 23S ribosomal RNA gene, partial sequence blastn 203091 1940 0.997938144329897 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium kanagiense
12973690 12973690 PRJNA1112809_P_NODE_169291_length_249_cov_1.318182_g166016_i0 PRJNA1112809 169291 249 1.318182 3.28227318 Haloplanus salilacus 2949994 Archaea Archaea 372 1.52e-98   NTclustered gi|2699359002|gb|CP147505.1| 2949994 g166016 i0 93.574 13.8273092369478 249 16 100 0 1 249 1502821 1502573 Haloplanus sp. CK5-1 chromosome, complete genome blastn 3443 372 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus salilacus
12974206 12974206 PRJNA1112809_P_NODE_201211_length_204_cov_6.015267_g197936_i0 PRJNA1112809 201211 204 6.015267 12.27114468 Natronomonas moolapensis 416273 Archaea Archaea 252 1.63e-62   NTclustered gi|452081962|emb|HF582854.1| 268739 g197936 i0 89.109 84.5441176470588 202 22 99 0 1 202 2527759 2527558 Natronomonas moolapensis 8.8.11 complete genome blastn 17247 252 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas moolapensis
16796578 16796578 PRJNA1112809_P_NODE_148494_length_265_cov_1.359375_g145219_i0 PRJNA1112809 148494 265 1.359375 3.60234375 Methanobacterium sp. MZ-A1 1911685 Archaea Archaea 368 2.12e-97   NTclustered gi|1297871367|gb|CP017767.1| 1911685 g145219 i0 92.015 1.99622641509434 263 19 99 2 4 265 2293687 2293426 Methanobacterium sp. MZ-A1 chromosome, complete genome blastn 529 368 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp. MZ-A1
16798799 16798799 PRJNA1112809_P_NODE_90254_length_353_cov_2.382143_g86979_i0 PRJNA1112809 90254 353 2.382143 8.40896479 Halalkalicoccus salilacus 3117459 Archaea Archaea 56.5 0.003   NTclustered gi|2674869203|gb|CP144461.1| 3117459 g86979 i0 97.059 0.0963172804532578 34 0 10 1 271 304 1253642 1253610 Halalkalicoccus salilacus strain FCH27 chromosome, complete genome blastn 34 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus salilacus
20149836 20149836 PRJNA1112809_P_NODE_199756_length_227_cov_2.077922_g196481_i0 PRJNA1112809 199756 227 2.077922 4.71688294 root 1 Root_unresolved Root_unresolved 420 4.81e-113   NTclustered gi|4335668|gb|U81775.2|UAU81775 13776 g196481 i0 100 100.013215859031 227 0 100 0 1 227 1138 912 Unidentified archaeon clone vadinDC06 16S ribosomal RNA gene, partial sequence blastn 22703 420 1 Archaea               unidentified archaeon
21425609 21425609 PRJNA1112809_P_NODE_68117_length_428_cov_3.650704_g64843_i0 PRJNA1112809 68117 428 3.650704 15.62501312 Archaea 2157 Archaea Archaea 791 0   NTclustered gi|88656475|gb|DQ386717.1| 115547 g64843 i0 100 99.9929906542056 428 0 100 0 1 428 128 555 Uncultured archaeon clone Mix Arch 4 16S ribosomal RNA gene, partial sequence blastn 42797 791 1 Archaea               uncultured archaeon
24445989 24445989 PRJNA1112809_P_NODE_173600_length_248_cov_0.880000_g170325_i0 PRJNA1112809 173600 248 0.88 2.1824 Haloglomus halophilum 2962672 Archaea Archaea 250 7.41e-62   NTclustered gi|2273560679|gb|CP101166.1| 2962672 g170325 i0 85.425 18.8064516129032 247 28 98 8 6 248 2182246 2182488 Haloglomus halophilum strain ZY41 chromosome, complete genome blastn 4664 250 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Haloglomus Haloglomus halophilum
25249897 25249897 PRJNA1112809_P_NODE_72160_length_411_cov_4.026627_g68885_i0 PRJNA1112809 72160 411 4.026627 16.54943697 Sulfolobaceae 118883 Archaea Archaea 732 0   NTclustered gi|169525791|gb|EU419200.1| 47303 g68885 i0 99.02 99.367396593674 408 4 99 0 4 411 290 697 Sulfolobus metallicus strain DK-I15/60 16S ribosomal RNA gene, partial sequence blastn 40840 732 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfuracidifex Sulfuracidifex metallicus

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