RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1166865 · 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
313603 313603 PRJNA1166865_P_NODE_70241_length_262_cov_1.222222_g70000_i0 PRJNA1166865 70241 262 1.222222 3.20222164 Halomarina litorea 2961595 Archaea Archaea 52.8 0.024   NTclustered gi|2270268913|gb|CP100449.1| 2961595 g70000 i0 100 0.106870229007634 28 0 11 0 5 32 322237 322210 Halomarina litorea strain BCD28 plasmid unnamed1, complete sequence blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina litorea
6142488 6142488 PRJNA1166865_P_NODE_66345_length_271_cov_1.555556_g66104_i0 PRJNA1166865 66345 271 1.555556 4.21555676 root 1 Root_unresolved Root_unresolved 54.7 0.007   NTclustered gi|2273673090|gb|CP101323.1| 1046043 g66104 i0 100 0.214022140221402 29 0 11 0 185 213 2046412 2046384 Natronomonas gomsonensis strain KCTC 4088 chromosome, complete genome blastn 58 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas gomsonensis
7417504 7417504 PRJNA1166865_P_NODE_62206_length_280_cov_2.917874_g61965_i0 PRJNA1166865 62206 280 2.917874 8.1700472 root 1 Root_unresolved Root_unresolved 54.7 0.007   NTclustered gi|1526250537|gb|CP034145.1| 660522 g61965 i0 100 0.325 29 0 10 0 247 275 2763493 2763521 Haloplanus aerogenes strain JCM 16430 chromosome, complete genome blastn 91 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus aerogenes
7966396 7966396 PRJNA1166865_P_NODE_51467_length_308_cov_0.982979_g51226_i0 PRJNA1166865 51467 308 0.982979 3.02757532 Halomontanus rarus 3034020 Archaea Archaea 67.6 1.03e-6   NTclustered gi|2463595547|gb|CP119796.1| 3034020 g51226 i0 97.436 1.41883116883117 39 1 13 0 11 49 77399 77361 Halomontanus rarus strain TS33 chromosome, complete genome blastn 437 67.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halomontanus Halomontanus rarus
11791897 11791897 PRJNA1166865_P_NODE_58650_length_289_cov_1.111111_g58409_i0 PRJNA1166865 58650 289 1.111111 3.21111079 Salinigranum marinum 1515595 Archaea Archaea 54.7 0.007   NTclustered gi|2270305257|gb|CP100461.1| 1515595 g58409 i0 100 0.100346020761246 29 0 10 0 192 220 1318993 1319021 Salinigranum marinum strain ZS-10 chromosome, complete genome blastn 29 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Salinigranum Salinigranum marinum
20715385 20715385 PRJNA1166865_P_NODE_91757_length_242_cov_1.822485_g91516_i0 PRJNA1166865 91757 242 1.822485 4.4104137 Halobacterium sp. DL1 751944 Archaea Archaea 52.8 0.022   NTclustered gi|573484043|gb|CP007060.1| 751944 g91516 i0 94.286 0.144628099173554 35 1 14 1 94 128 2119237 2119204 Halobacterium sp. DL1, complete genome blastn 35 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium sp. DL1

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