RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA356682 · 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
398029 398029 PRJNA356682_P_NODE_47341_length_209_cov_6.338235_g46650_i0 PRJNA356682 47341 209 6.338235 13.24691115 Methanosalsum zhilinae 39669 Archaea Archaea 56.5 0.001   NTclustered gi|335929340|gb|CP002101.1| 679901 g46650 i0 100 0.143540669856459 30 0 14 0 59 88 1665167 1665138 Methanosalsum zhilinae DSM 4017, complete genome blastn 30 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosalsum Methanosalsum zhilinae
6775569 6775569 PRJNA356682_P_NODE_45046_length_241_cov_0.916667_g44355_i0 PRJNA356682 45046 241 0.916667 2.20916747 Haloferax gibbonsii 35746 Archaea Archaea 174 4.4399999999999997e-39   NTclustered gi|1919476744|gb|CP063205.1| 35746 g44355 i0 83.871 3.0746887966805 186 26 76 4 25 208 2789980 2789797 Haloferax gibbonsii strain LR2-5 chromosome, complete genome blastn 741 174 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloferax Haloferax gibbonsii
10601677 10601677 PRJNA356682_P_NODE_44829_length_241_cov_0.916667_g44138_i0 PRJNA356682 44829 241 0.916667 2.20916747 Natronomonas halophila 2747817 Archaea Archaea 243 1.2e-59   NTclustered gi|1865516082|gb|CP058334.1| 2747817 g44138 i0 89.529 1.26970954356846 191 20 79 0 1 191 2869383 2869193 Natronomonas halophila strain C90 chromosome, complete genome blastn 306 243 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas halophila
18249571 18249571 PRJNA356682_P_NODE_44635_length_241_cov_0.916667_g43944_i0 PRJNA356682 44635 241 0.916667 2.20916747 Natronomonas halophila 2747817 Archaea Archaea 368 1.9e-97   NTclustered gi|1865516082|gb|CP058334.1| 2747817 g43944 i0 94.191 1.54771784232365 241 14 100 0 1 241 156285 156045 Natronomonas halophila strain C90 chromosome, complete genome blastn 373 368 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas halophila
18923880 18923880 PRJNA356682_P_NODE_38855_length_248_cov_0.880000_g38164_i0 PRJNA356682 38855 248 0.88 2.1824 Halorubrum 56688 Archaea Archaea 298 2.61e-76   NTclustered gi|1848526000|gb|CP053941.1| 2739057 g38164 i0 88.4 60.9516129032258 250 25 100 4 1 248 622039 622286 Halorubrum salinarum strain RHB-C chromosome, complete genome blastn 15116 298 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum salinarum
24624021 24624021 PRJNA356682_P_NODE_40140_length_246_cov_0.890173_g39449_i0 PRJNA356682 40140 246 0.890173 2.18982558 Natronorubrum bangense 61858 Archaea Archaea 132 2.77e-26   NTclustered gi|1621081954|gb|CP031305.1| 61858 g39449 i0 87.179 1.90650406504065 117 13 47 2 67 182 309078 309193 Natronorubrum bangense strain JCM 10635 chromosome, complete genome blastn 469 132 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronorubrum Natronorubrum bangense

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