RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJDB4470" 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 · 7 ✖

bioproject 1

  • PRJDB4470 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
28258140 28258140 PRJDB4470_P_NODE_107786_length_166_cov_0.888889_g106631_i0 PRJDB4470 107786 166 0.888889 1.47555574 Halobacteriales 2235 Archaea Archaea 102 2.08e-24   NR WP_340605028.1 175632 g106631 i0 81.8 8.94578313253012 55 10 99.4 0 166 2 89 143 WP_340605028.1 D-2-hydroxyacid dehydrogenase [Halalkalicoccus tibetensis] diamond 1485 102 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus tibetensis
28485284 28485284 PRJDB4470_P_NODE_114567_length_164_cov_0.904348_g113412_i0 PRJDB4470 114567 164 0.904348 1.48313072 Halalkalicoccus paucihalophilus 1008153 Archaea Archaea 50.8 1.43e-6   NR KYH23987.1 1008153 g113412 i0 48.9 0.859756097560976 47 23 86 1 12 152 16 61 KYH23987.1 hypothetical protein HAPAU_40660 [Halalkalicoccus paucihalophilus] diamond 141 50.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus paucihalophilus
29621425 29621425 PRJDB4470_P_NODE_34250_length_384_cov_1.808955_g33101_i0 PRJDB4470 34250 384 1.808955 6.9463872 Halogranum rubrum 553466 Archaea Archaea 44.3 0.0459   NR WP_009367134.1 553466 g33101 i0 41.9 0.484375 62 30 43.8 2 321 154 226 287 WP_009367134.1 cation:proton antiporter [Halogranum rubrum] diamond 186 44.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halogranum Halogranum rubrum
30980531 30980531 PRJDB4470_P_NODE_123354_length_162_cov_0.902655_g122199_i0 PRJDB4470 123354 162 0.902655 1.4623011 Methanomicrobia archaeon 2268195 Archaea Archaea 47.8 2.16e-4   NR NCA96145.1 2268195 g122199 i0 53.5 0.796296296296296 43 20 79.6 0 162 34 315 357 NCA96145.1 hypothetical protein [Methanomicrobia archaeon] diamond 129 47.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia       Methanomicrobia archaeon
31486383 31486383 PRJDB4470_P_NODE_122876_length_162_cov_0.920354_g121721_i0 PRJDB4470 122876 162 0.920354 1.49097348 Natronococcus sp. A-GB7 3037649 Archaea Archaea 65.1 7.45e-11   NR WP_278305244.1 3037649 g121721 i0 58.5 0.981481481481482 53 22 98.1 0 1 159 63 115 WP_278305244.1 hypothetical protein [Natronococcus sp. A-GB7] diamond 159 65.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus sp. A-GB7
31675811 31675811 PRJDB4470_P_NODE_110737_length_165_cov_0.896552_g109582_i0 PRJDB4470 110737 165 0.896552 1.4793108 Halalkalicoccus sp. 1973143 Archaea Archaea 87 2.92e-18   NR MEM4780006.1 1973143 g109582 i0 71.7 0.963636363636364 53 15 96.4 0 163 5 436 488 MEM4780006.1 alpha-amylase family glycosyl hydrolase [Halalkalicoccus sp.] diamond 159 87 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus sp.
32813682 32813682 PRJDB4470_P_NODE_102860_length_168_cov_0.873950_g101705_i0 PRJDB4470 102860 168 0.87395 1.468236 Halococcus sp. 29286 Archaea Archaea 87 2.58e-19   NR HET7323524.1 29286 g101705 i0 72.2 0.964285714285714 54 15 96.4 0 167 6 29 82 HET7323524.1 hypothetical protein [Halococcus sp.] diamond 162 87 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus sp.

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