RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1022392 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
28361372 28361372 PRJNA1022392_P_NODE_64866_length_171_cov_1.637097_g64197_i0 PRJNA1022392 64866 171 1.637097 2.79943587 Halobium salinum 1364940 Archaea Archaea 65.5 1.3099999999999999e-10   NR WP_267620269.1 1364940 g64197 i0 59.3 3.66666666666667 54 22 94.7 0 162 1 311 364 WP_267620269.1 MBL fold metallo-hydrolase [Halobium salinum] diamond 627 65.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halobium Halobium salinum
28519469 28519469 PRJNA1022392_P_NODE_64787_length_171_cov_1.911290_g64118_i0 PRJNA1022392 64787 171 1.91129 3.2683059 Halanaeroarchaeum sp. HSR-CO 2866382 Archaea Archaea 115 4.13e-29   NR WP_259518335.1 2866382 g64118 i0 98.2 0.982456140350877 56 1 98.2 0 170 3 209 264 WP_259518335.1 aspartate kinase [Halanaeroarchaeum sp. HSR-CO] diamond 168 115 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halanaeroarchaeum Halanaeroarchaeum sp. HSR-CO
28708954 28708954 PRJNA1022392_P_NODE_64967_length_171_cov_1.395161_g64298_i0 PRJNA1022392 64967 171 1.395161 2.38572531 Natronomonas sp. LN261 2750669 Archaea Archaea 99.8 3.4299999999999995e-24   NR WP_181692800.1 2750669 g64298 i0 96.1 0.894736842105263 51 2 89.5 0 18 170 1 51 WP_181692800.1 SCO family protein [Natronomonas sp. LN261] diamond 153 99.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
29237802 29237802 PRJNA1022392_P_NODE_72049_length_163_cov_2.362069_g71380_i0 PRJNA1022392 72049 163 2.362069 3.85017247 Halobacteriales 2235 Archaea Archaea 92.4 2.33e-20   NR WP_006088434.1 63128 g71380 i0 87 6.93865030674847 54 7 99.4 0 2 163 73 126 WP_006088434.1 CBS domain-containing protein [Natronorubrum tibetense] diamond 1131 92.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronorubrum Natronorubrum tibetense
29623930 29623930 PRJNA1022392_P_NODE_58630_length_179_cov_1.522727_g57961_i0 PRJNA1022392 58630 179 1.522727 2.72568133 Halorubrum sp. 48-1-W 2249761 Archaea Archaea 94.7 4.8e-22   NR WP_157964892.1 2249761 g57961 i0 67.8 0.988826815642458 59 19 98.9 0 179 3 148 206 WP_157964892.1 hypothetical protein [Halorubrum sp. 48-1-W] diamond 177 94.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. 48-1-W
29687261 29687261 PRJNA1022392_P_NODE_77850_length_159_cov_0.910714_g77181_i0 PRJNA1022392 77850 159 0.910714 1.44803526 Halorussus 1070314 Archaea Archaea 67 3.3e-11   NR WP_253520236.1 1070314 g77181 i0 65.4 3.92452830188679 52 18 98.1 0 4 159 150 201 WP_253520236.1 MULTISPECIES: ABC transporter substrate-binding protein [Halorussus] diamond 624 67 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Halorussus  
30003540 30003540 PRJNA1022392_P_NODE_73431_length_162_cov_2.086957_g72762_i0 PRJNA1022392 73431 162 2.086957 3.38087034 Halodesulfurarchaeum sp. 1980530 Archaea Archaea 91.3 2.7600000000000002e-22   NR MBS3759946.1 1980530 g72762 i0 82 0.925925925925926 50 9 92.6 0 10 159 32 81 MBS3759946.1 hypothetical protein [Halodesulfurarchaeum sp.] diamond 150 91.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halodesulfurarchaeum Halodesulfurarchaeum sp.
30951458 30951458 PRJNA1022392_P_NODE_33714_length_206_cov_2.679245_g33045_i0 PRJNA1022392 33714 206 2.679245 5.5192447 Natronomonas sp. LN261 2750669 Archaea Archaea 70.5 1.16e-12   NR WP_181691448.1 2750669 g33045 i0 96.9 0.466019417475728 32 1 46.6 0 109 204 22 53 WP_181691448.1 HNH endonuclease [Natronomonas sp. LN261] diamond 96 70.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
31140433 31140433 PRJNA1022392_P_NODE_60335_length_177_cov_1.223077_g59666_i0 PRJNA1022392 60335 177 1.223077 2.16484629 Haloarculaceae archaeon H-GB1-1 3037652 Archaea Archaea 73.2 2.87e-13   NR MDG5777504.1 3037652 g59666 i0 76.6 1.59322033898305 47 11 79.7 0 4 144 433 479 MDG5777504.1 APC family permease [Haloarculaceae archaeon H-GB1-1] diamond 282 73.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae   Haloarculaceae archaeon H-GB1-1
31710122 31710122 PRJNA1022392_P_NODE_59257_length_178_cov_2.022901_g58588_i0 PRJNA1022392 59257 178 2.022901 3.60076378 Natronococcus jeotgali 413812 Archaea Archaea 47 5.76e-5   NR WP_008419468.1 413812 g58588 i0 52.6 1.28089887640449 38 18 64 0 65 178 1 38 WP_008419468.1 hypothetical protein [Natronococcus jeotgali] diamond 228 47 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus jeotgali
31765416 31765416 PRJNA1022392_P_NODE_56097_length_182_cov_2.540741_g55428_i0 PRJNA1022392 56097 182 2.540741 4.62414862 root 1 Root_unresolved Root_unresolved 102 3.61e-24   NR WP_255332133.1 106207 g55428 i0 80.7 14.0934065934066 57 11 94 0 171 1 64 120 WP_255332133.1 UDP-N-acetylglucosamine 4,6-dehydratase (inverting) [Methanocalculus taiwanensis] diamond 2565 103 0.990291262135922 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanocalculaceae Methanocalculus Methanocalculus taiwanensis

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