RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA849172" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA849172 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
4665743 4665743 PRJNA849172_P_NODE_75664_length_264_cov_1.408377_g75304_i0 PRJNA849172 75664 264 1.408377 3.71811528 Halococcus qingdaonensis 224402 Archaea Archaea 333 7.689999999999999e-87   NTclustered gi|2281256326|gb|CP101943.1| 224402 g75304 i0 89.961 3.89772727272727 259 24 98 2 1 258 1828025 1828282 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 1029 333 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
5937480 5937480 PRJNA849172_P_NODE_108725_length_242_cov_0.923077_g108365_i0 PRJNA849172 108725 242 0.923077 2.23384634 Halococcus qingdaonensis 224402 Archaea Archaea 268 1.99e-67   NTclustered gi|2281256326|gb|CP101943.1| 224402 g108365 i0 86.831 1.83057851239669 243 29 100 3 1 242 2664898 2665138 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 443 268 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
6336673 6336673 PRJNA849172_P_NODE_49085_length_299_cov_1.685841_g48725_i0 PRJNA849172 49085 299 1.685841 5.0406645899999996 Halococcus 2249 Archaea Archaea 436 6.57e-118   NTclustered gi|2221489803|gb|CP095005.1| 179637 g48725 i0 92.977 10.4916387959866 299 21 100 0 1 299 396318 396616 Halococcus dombrowskii strain H4 chromosome, complete genome blastn 3137 436 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
7215512 7215512 PRJNA849172_P_NODE_78826_length_261_cov_1.388298_g78466_i0 PRJNA849172 78826 261 1.388298 3.62345778 Halococcus dombrowskii 179637 Archaea Archaea 305 1.65e-78   NTclustered gi|2221489803|gb|CP095005.1| 179637 g78466 i0 87.984 1.94252873563218 258 31 99 0 1 258 548752 549009 Halococcus dombrowskii strain H4 chromosome, complete genome blastn 507 305 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
8490672 8490672 PRJNA849172_P_NODE_94447_length_249_cov_1.994318_g94087_i0 PRJNA849172 94447 249 1.994318 4.96585182 Salinibaculum rarum 3058903 Archaea Archaea 52.8 0.023   NTclustered gi|2548167091|gb|CP129992.1| 3058903 g94087 i0 100 0.112449799196787 28 0 11 0 94 121 2867748 2867721 Salinibaculum rarum strain KK48 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Salinibaculum Salinibaculum rarum
10161241 10161241 PRJNA849172_P_NODE_56708_length_285_cov_2.943396_g56348_i0 PRJNA849172 56708 285 2.943396 8.3886786 Halococcus 2249 Archaea Archaea 350 8.34e-92   NTclustered gi|2221489803|gb|CP095005.1| 179637 g56348 i0 88.772 96.8140350877193 285 32 100 0 1 285 1116060 1115776 Halococcus dombrowskii strain H4 chromosome, complete genome blastn 27592 350 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
14862230 14862230 PRJNA849172_P_NODE_108592_length_242_cov_0.923077_g108232_i0 PRJNA849172 108592 242 0.923077 2.23384634 Halomarina pelagica 2961599 Archaea Archaea 274 4.27e-69   NTclustered gi|2270305251|gb|CP100455.1| 2961599 g108232 i0 87.712 5.78099173553719 236 27 97 2 1 235 261276 261510 Halomarina pelagica strain BND7 plasmid unnamed1, complete sequence blastn 1399 274 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina pelagica
14864560 14864560 PRJNA849172_P_NODE_52292_length_291_cov_3.733945_g51932_i0 PRJNA849172 52292 291 3.733945 10.86577995 Halorussus vallis 2953749 Archaea Archaea 52.8 0.027   NTclustered gi|2263966384|gb|CP100000.1| 2953749 g51932 i0 100 0.0962199312714777 28 0 10 0 227 254 3508578 3508605 Halorussus vallis strain XZYJT10 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Halorussus Halorussus vallis
14865523 14865523 PRJNA849172_P_NODE_83532_length_256_cov_4.956284_g83172_i0 PRJNA849172 83532 256 4.956284 12.68808704 Haloarcula sp. CBA1115 1592728 Archaea Archaea 451 1.96e-122   NTclustered gi|749699433|gb|CP010529.1| 1592728 g83172 i0 98.438 110.87890625 256 4 100 0 1 256 1463 1208 Haloarcula sp. CBA1115, complete genome blastn 28385 451 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Haloarcula Haloarcula sp. CBA1115
18685750 18685750 PRJNA849172_P_NODE_113775_length_237_cov_3.804878_g113415_i0 PRJNA849172 113775 237 3.804878 9.01756086 Halococcus dombrowskii 179637 Archaea Archaea 383 6.64e-102   NTclustered gi|2221489803|gb|CP095005.1| 179637 g113415 i0 95.781 1.9915611814346 237 10 100 0 1 237 282091 282327 Halococcus dombrowskii strain H4 chromosome, complete genome blastn 472 383 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
18686314 18686314 PRJNA849172_P_NODE_134875_length_214_cov_5.085106_g134515_i0 PRJNA849172 134875 214 5.085106 10.88212684 Natronomonas moolapensis 416273 Archaea Archaea 56.5 0.001   NTclustered gi|452081962|emb|HF582854.1| 268739 g134515 i0 100 0.14018691588785 30 0 14 0 14 43 79064 79035 Natronomonas moolapensis 8.8.11 complete genome blastn 30 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas moolapensis
19963957 19963957 PRJNA849172_P_NODE_82576_length_257_cov_3.603261_g82216_i0 PRJNA849172 82576 257 3.603261 9.26038077 Halococcus qingdaonensis 224402 Archaea Archaea 387 5.64e-103   NTclustered gi|2281256326|gb|CP101943.1| 224402 g82216 i0 93.774 47.6614785992218 257 16 100 0 1 257 1737460 1737204 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 12249 387 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
22511510 22511510 PRJNA849172_P_NODE_122458_length_230_cov_2.528662_g122098_i0 PRJNA849172 122458 230 2.528662 5.8159226 Halomarina litorea 2961595 Archaea Archaea 198 2.49e-46   NTclustered gi|2270268912|gb|CP100448.1| 2961595 g122098 i0 83.105 4.91739130434783 219 35 95 2 13 230 3008566 3008349 Halomarina litorea strain BCD28 chromosome, complete genome blastn 1131 198 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina litorea
23786510 23786510 PRJNA849172_P_NODE_104519_length_244_cov_0.912281_g104159_i0 PRJNA849172 104519 244 0.912281 2.22596564 Halococcus dombrowskii 179637 Archaea Archaea 303 5.5e-78   NTclustered gi|2221489803|gb|CP095005.1| 179637 g104159 i0 89.831 0.967213114754098 236 24 97 0 1 236 2703563 2703798 Halococcus dombrowskii strain H4 chromosome, complete genome blastn 236 303 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);;