RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", tax_kingdom = "Methanobacteriati" and tax_phylum = "Halobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Halobacteriota · 9 ✖

tax_kingdom 1

  • Methanobacteriati · 9 ✖

analysis 1

  • diamond · 9 ✖

tax_clade 0

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
27341803 27341803 PRJNA950981_P_NODE_13003_length_285_cov_1.839623_g12827_i0 PRJNA950981 13003 285 1.839623 5.24292555 Halobacteriota archaeon 3100168 Archaea Archaea 44.3 0.0172   NR MDY6966908.1 3100168 g12827 i0 50 0.378947368421053 36 18 37.9 0 215 108 490 525 MDY6966908.1 hypothetical protein [Halobacteriota archaeon] diamond 108 44.3 1 Archaea   Methanobacteriati Halobacteriota         Halobacteriota archaeon
27382208 27382208 PRJNA1002570_P_NODE_3723_length_558_cov_1.352577_g3531_i0 PRJNA1002570 3723 558 1.352577 7.54737966 Halobacteriota archaeon 3100168 Archaea Archaea 75.9 2.25e-14   NR MDY6958323.1 3100168 g3531 i0 50 0.951612903225806 90 40 48.4 3 335 66 1 85 MDY6958323.1 hypothetical protein [Halobacteriota archaeon] diamond 531 75.9 1 Archaea   Methanobacteriati Halobacteriota         Halobacteriota archaeon
28303240 28303240 PRJNA1148190_P_NODE_62786_length_718_cov_1.691473_g51765_i0 PRJNA1148190 62786 718 1.691473 12.14477614 Halobacteriota archaeon 3100168 Archaea Archaea 127 7.57e-33   NR MDY6957996.1 3100168 g51765 i0 60.2 0.852367688022284 103 41 43 0 716 408 48 150 MDY6957996.1 hypothetical protein [Halobacteriota archaeon] diamond 612 127 1 Archaea   Methanobacteriati Halobacteriota         Halobacteriota archaeon
28699942 28699942 PRJNA971676_P_NODE_23347_length_241_cov_0.916667_g23258_i0 PRJNA971676 23347 241 0.916667 2.20916747 Halobacteriota archaeon 3100168 Archaea Archaea 59.7 3.59e-8   NR MDY6959722.1 3100168 g23258 i0 76.3 1.41908713692946 38 9 47.3 0 114 1 254 291 MDY6959722.1 ACR3 family arsenite efflux transporter [Halobacteriota archaeon] diamond 342 59.7 1 Archaea   Methanobacteriati Halobacteriota         Halobacteriota archaeon
28992133 28992133 PRJEB64798_P_NODE_51688_length_272_cov_5.600897_g49923_i0 PRJEB64798 51688 272 5.600897 15.23443984 Halobacteriota archaeon 3100168 Archaea Archaea 42.4 0.0205   NR MDY6966903.1 3100168 g49923 i0 76 0.275735294117647 25 6 27.6 0 140 66 1 25 MDY6966903.1 hypothetical protein [Halobacteriota archaeon] diamond 75 42.4 1 Archaea   Methanobacteriati Halobacteriota         Halobacteriota archaeon
29132276 29132276 PRJNA565778_S_NODE_12069_length_315_cov_14.205036_g11773_i0 PRJNA565778 12069 315 14.205036 44.7458634 Halobacteriota archaeon 3100168 Archaea Archaea 63.5 1.46e-9   NR MDY6960110.1 3100168 g11773 i0 34.7 1.7047619047619 95 61 90.5 1 304 20 65 158 MDY6960110.1 hypothetical protein [Halobacteriota archaeon] diamond 537 63.5 1 Archaea   Methanobacteriati Halobacteriota         Halobacteriota archaeon
29404885 29404885 PRJNA1118794_P_NODE_40809_length_267_cov_1.335052_g40059_i0 PRJNA1118794 40809 267 1.335052 3.56458884 Halobacteriota archaeon 3100168 Archaea Archaea 78.6 1.22e-14   NR MDY6866055.1 3100168 g40059 i0 50 1.93258426966292 86 40 93.3 1 3 251 210 295 MDY6866055.1 PEP/pyruvate-binding domain-containing protein [Halobacteriota archaeon] diamond 516 78.6 1 Archaea   Methanobacteriati Halobacteriota         Halobacteriota archaeon
32204406 32204406 PRJNA841653_P_NODE_14558_length_431_cov_1.899441_g13887_i0 PRJNA841653 14558 431 1.899441 8.18659071 Halobacteriota archaeon 3100168 Archaea Archaea 55.8 7.81e-6   NR MDY6957599.1 3100168 g13887 i0 37.9 0.605568445475638 87 42 59.2 2 171 425 1046 1122 MDY6957599.1 hypothetical protein [Halobacteriota archaeon] diamond 261 55.8 1 Archaea   Methanobacteriati Halobacteriota         Halobacteriota archaeon
32681546 32681546 PRJNA993416_P_NODE_3920_length_426_cov_2.022663_g3815_i0 PRJNA993416 3920 426 2.022663 8.61654438 Halobacteriota archaeon 3100168 Archaea Archaea 74.7 1.9e-14   NR MDY6958323.1 3100168 g3815 i0 54.2 0.507042253521127 72 32 50.7 1 219 4 1 71 MDY6958323.1 hypothetical protein [Halobacteriota archaeon] diamond 216 74.7 1 Archaea   Methanobacteriati Halobacteriota         Halobacteriota archaeon

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