RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1196438 · 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
1598085 1598085 PRJNA1196438_P_NODE_66742_length_250_cov_2.146893_g66315_i0 PRJNA1196438 66742 250 2.146893 5.3672325 Halobacterium noricense 223182 Archaea Archaea 435 1.92e-117   NTclustered gi|2168248316|gb|CP089469.1| 223182 g66315 i0 98.77 44.364 244 3 98 0 7 250 187536 187779 Halobacterium noricense strain JCM 15102 plasmid unnamed1, complete sequence blastn 11091 435 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium noricense
3593667 3593667 PRJNA1196438_P_NODE_20343_length_312_cov_2.979079_g19917_i0 PRJNA1196438 20343 312 2.979079 9.29472648 Methanobrevibacter 2172 Archaea Archaea 115 3.6700000000000006e-21   NTclustered gi|2791693311|gb|CP144200.1| 2173 g19917 i0 86.538 2 104 14 33 0 170 273 948944 949047 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 624 115 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
6146141 6146141 PRJNA1196438_P_NODE_37305_length_293_cov_2.054545_g36879_i0 PRJNA1196438 37305 293 2.054545 6.01981685 Methanobrevibacter 2172 Archaea Archaea 82.4 3.47e-11   NTclustered gi|2791693311|gb|CP144200.1| 2173 g36879 i0 83.721 1.92150170648464 86 14 29 0 205 290 1482544 1482629 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 563 82.4 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
6700990 6700990 PRJNA1196438_P_NODE_42946_length_284_cov_2.516588_g42519_i0 PRJNA1196438 42946 284 2.516588 7.14710992 Methanobrevibacter millerae 230361 Archaea Archaea 171 6.94e-38   NTclustered gi|968564921|gb|CP011266.1| 230361 g42519 i0 86.842 1.06338028169014 152 20 54 0 130 281 1557574 1557725 Methanobrevibacter millerae strain SM9, complete genome blastn 302 171 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter millerae
10527332 10527332 PRJNA1196438_P_NODE_75829_length_242_cov_1.840237_g75402_i0 PRJNA1196438 75829 242 1.840237 4.45337354 Natronomonas marina 2961939 Archaea Archaea 187 5.73e-43   NTclustered gi|2273574514|gb|CP101154.1| 2961939 g75402 i0 80.738 1.00826446280992 244 43 100 2 1 242 2182591 2182350 Natronomonas marina strain ZY43 chromosome, complete genome blastn 244 187 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas marina
13077015 13077015 PRJNA1196438_P_NODE_64731_length_252_cov_1.737430_g64304_i0 PRJNA1196438 64731 252 1.73743 4.3783236 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 243 1.2600000000000001e-59   NTclustered gi|985614202|gb|CP010834.1| 1609968 g64304 i0 85.903 1.54761904761905 227 32 90 0 6 232 1914934 1914708 Methanobrevibacter sp. YE315, complete genome blastn 390 243 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
14352120 14352120 PRJNA1196438_P_NODE_41432_length_286_cov_9.807512_g41005_i0 PRJNA1196438 41432 286 9.807512 28.04948432 Natronorubrum daqingense 588898 Archaea Archaea 457 4.79e-124   NTclustered gi|1134979927|gb|CP019327.1| 588898 g41005 i0 95.76 0.989510489510489 283 12 99 0 1 283 3008856 3009138 Natronorubrum daqingense strain JX313, complete sequence blastn 283 457 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronorubrum Natronorubrum daqingense
15626091 15626091 PRJNA1196438_P_NODE_56633_length_263_cov_2.100000_g56206_i0 PRJNA1196438 56633 263 2.1 5.523 Halosimplex rarum 3396619 Archaea Archaea 65.8 3.08e-6   NTclustered gi|2908454640|gb|CP180412.1| 3396619 g56206 i0 100 1.63878326996198 35 0 13 0 1 35 3605602 3605568 Halosimplex sp. TS25 chromosome, complete genome blastn 431 65.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halosimplex Halosimplex rarum
18174817 18174817 PRJNA1196438_P_NODE_49135_length_274_cov_3.094527_g48708_i0 PRJNA1196438 49135 274 3.094527 8.47900398 Methanobrevibacter acididurans 120963 Archaea Archaea 209 1.41e-49   NTclustered gi|2871247231|gb|CP166991.1| 120963 g48708 i0 81.369 3.26277372262774 263 43 95 5 1 260 1449879 1450138 Methanobrevibacter acididurans strain DSM 15163 chromosome, complete genome blastn 894 209 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter acididurans
19449713 19449713 PRJNA1196438_P_NODE_84276_length_222_cov_4.261745_g83849_i0 PRJNA1196438 84276 222 4.261745 9.4610739 Natronomonas moolapensis 416273 Archaea Archaea 241 3.9200000000000003e-59   NTclustered gi|452081962|emb|HF582854.1| 268739 g83849 i0 86.758 4.6981981981982 219 26 98 3 6 222 508284 508067 Natronomonas moolapensis 8.8.11 complete genome blastn 1043 241 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas moolapensis
20724747 20724747 PRJNA1196438_P_NODE_63917_length_253_cov_0.866667_g63490_i0 PRJNA1196438 63917 253 0.866667 2.19266751 Halolamina sp. CBA1230 1853690 Archaea Archaea 52.8 0.023   NTclustered gi|1861362334|gb|CP054587.1| 1853690 g63490 i0 100 0.110671936758893 28 0 11 0 207 234 1048371 1048398 Halolamina sp. CBA1230 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halolamina Halolamina sp. CBA1230

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