RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 6 ✖

bioproject 1

  • PRJNA1196438 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
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
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
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);;