RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA316313 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
19513059 19513059 PRJNA316313_P_NODE_309656_length_187_cov_2.366667_g308270_i0 PRJNA316313 309656 187 2.366667 4.42566729 Halococcus sp. IIIV-5B 2321230 Archaea Archaea 81.6 3.44e-16   NR WP_147464870.1 2321230 g308270 i0 65.7 1.07486631016043 67 18 99.5 1 187 2 20 86 WP_147464870.1 metal-dependent hydrolase [Halococcus sp. IIIV-5B] diamond 201 81.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus sp. IIIV-5B
27408200 27408200 PRJNA316313_P_NODE_448503_length_151_cov_3.657895_g447117_i0 PRJNA316313 448503 151 3.657895 5.52342145 Halobacteriaceae 2236 Archaea Archaea 41.6 0.0278   NR MFB6124676.1 1963275 g447117 i0 75 1.43046357615894 28 7 55.6 0 1 84 580 607 MFB6124676.1 flippase-like domain-containing protein [Halanaeroarchaeum sp.] diamond 216 41.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halanaeroarchaeum Halanaeroarchaeum sp.
27580015 27580015 PRJNA316313_P_NODE_471684_length_151_cov_3.026316_g470298_i0 PRJNA316313 471684 151 3.026316 4.56973716 Halopenitus sp. 1979403 Archaea Archaea 50.8 1.28e-5   NR MFB6235750.1 1979403 g470298 i0 85.7 0.556291390728477 28 4 55.6 0 150 67 225 252 MFB6235750.1 AAA family ATPase [Halopenitus sp.] diamond 84 50.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halopenitus Halopenitus sp.
27832559 27832559 PRJNA316313_P_NODE_257504_length_187_cov_2.766667_g256118_i0 PRJNA316313 257504 187 2.766667 5.17366729 Halococcus salsus 2162894 Archaea Archaea 83.2 6.73e-17   NR WP_160134355.1 2162894 g256118 i0 73.8 0.978609625668449 61 14 97.9 1 185 3 18 76 WP_160134355.1 pyridoxal-phosphate-dependent aminotransferase family protein [Halococcus salsus] diamond 183 83.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus salsus
27881531 27881531 PRJNA316313_P_NODE_462065_length_151_cov_3.271930_g460679_i0 PRJNA316313 462065 151 3.27193 4.9406143 Halobacteriales 2235 Archaea Archaea 47.8 1.72e-4   NR WP_008525115.1 430914 g460679 i0 100 1.05298013245033 24 0 47.7 0 78 149 105 128 WP_008525115.1 phosphonate ABC transporter, permease protein PhnE [Halorhabdus tiamatea] diamond 159 48.1 0.993762993762994 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halorhabdus Halorhabdus tiamatea
28197173 28197173 PRJNA316313_P_NODE_455406_length_151_cov_3.412281_g454020_i0 PRJNA316313 455406 151 3.412281 5.15254431 Halococcus 2249 Archaea Archaea 45.8 8.41e-4   NR WP_010612146.1 332168 g454020 i0 91.3 0.933774834437086 23 2 45.7 0 81 149 803 825 WP_010612146.1 GAF domain-containing protein, partial [Halococcus hamelinensis] diamond 141 45.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus hamelinensis
28702616 28702616 PRJNA316313_P_NODE_440907_length_151_cov_3.921053_g439521_i0 PRJNA316313 440907 151 3.921053 5.92079003 Halobacteriales 2235 Archaea Archaea 54.7 4.9e-7   NR WP_247420641.1 1872699 g439521 i0 42 3.23841059602649 81 9 85.4 1 9 137 57 137 WP_247420641.1 SDR family NAD(P)-dependent oxidoreductase [Halomarina salina] diamond 489 55.1 0.992740471869329 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina salina
29505985 29505985 PRJNA316313_P_NODE_409970_length_151_cov_5.938596_g408584_i0 PRJNA316313 409970 151 5.938596 8.96727996 Haloprofundus halophilus 2283527 Archaea Archaea 78.2 2.03e-15   NR WP_157972750.1 2283527 g408584 i0 71.4 0.973509933774834 49 14 97.4 0 5 151 125 173 WP_157972750.1 hypothetical protein [Haloprofundus halophilus] diamond 147 78.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloprofundus Haloprofundus halophilus
29554806 29554806 PRJNA316313_P_NODE_184090_length_187_cov_3.686667_g182704_i0 PRJNA316313 184090 187 3.686667 6.89406729 Halorubrum 56688 Archaea Archaea 52.4 7.06e-6   NR WP_008443081.1 416585 g182704 i0 96 0.802139037433155 25 1 40.1 0 76 2 119 143 WP_008443081.1 aldehyde dehydrogenase family protein [Halorubrum californiense] diamond 150 52.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum californiense
29663544 29663544 PRJNA316313_P_NODE_211170_length_187_cov_3.280000_g209784_i0 PRJNA316313 211170 187 3.28 6.1336 Haloplanus rallus 1816183 Archaea Archaea 46.6 7.62e-4   NR WP_157687604.1 1816183 g209784 i0 83.3 0.770053475935829 24 4 38.5 0 114 185 344 367 WP_157687604.1 conjugal transfer protein [Haloplanus rallus] diamond 144 46.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus rallus
29853467 29853467 PRJNA316313_P_NODE_34331_length_298_cov_4.149425_g32950_i0 PRJNA316313 34331 298 4.149425 12.3652865 Halobacteria archaeon 2670410 Archaea Archaea 43.1 0.0496   NR MEM3085639.1 2670410 g32950 i0 36.5 0.855704697986577 85 37 85.6 5 29 283 271 338 MEM3085639.1 mandelate racemase/muconate lactonizing enzyme family protein [Halobacteria archaeon] diamond 255 43.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria       Halobacteria archaeon
30011495 30011495 PRJNA316313_P_NODE_474171_length_151_cov_2.885965_g472785_i0 PRJNA316313 474171 151 2.885965 4.35780715 Halococcus thailandensis 335952 Archaea Archaea 41.2 0.0372   NR WP_080503445.1 335952 g472785 i0 92 0.496688741721854 25 2 49.7 0 76 2 16 40 WP_080503445.1 ParA family protein [Halococcus thailandensis] diamond 75 41.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus thailandensis
30137312 30137312 PRJNA316313_P_NODE_300532_length_187_cov_2.426667_g299146_i0 PRJNA316313 300532 187 2.426667 4.53786729 Halococcus dombrowskii 179637 Archaea Archaea 50.4 1.86e-5   NR WP_244701436.1 179637 g299146 i0 91.7 0.385026737967914 24 2 38.5 0 74 3 7 30 WP_244701436.1 VIT1/CCC1 transporter family protein [Halococcus dombrowskii] diamond 72 50.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
30706371 30706371 PRJNA316313_P_NODE_456714_length_151_cov_3.385965_g455328_i0 PRJNA316313 456714 151 3.385965 5.11280715 Halopenitus sp. 1979403 Archaea Archaea 82.4 3.24e-19   NR MFB6235879.1 1979403 g455328 i0 64.8 1.41059602649007 71 2 95.4 1 146 3 1 71 MFB6235879.1 hypothetical protein [Halopenitus sp.] diamond 213 82.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halopenitus Halopenitus sp.
31261008 31261008 PRJNA316313_P_NODE_472115_length_151_cov_3.008772_g470729_i0 PRJNA316313 472115 151 3.008772 4.54324572 Halobacteriales 2235 Archaea Archaea 70.5 1.51e-12   NR MFB6312096.1 2036002 g470729 i0 43.6 6.01986754966887 101 6 99.3 1 151 2 93 193 MFB6312096.1 tyrosine-type recombinase/integrase [Salinirussus sp.] diamond 909 70.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Salinirussus Salinirussus sp.
32305188 32305188 PRJNA316313_P_NODE_163359_length_187_cov_4.193333_g161973_i0 PRJNA316313 163359 187 4.193333 7.84153271 Halobacteriales 2235 Archaea Archaea 49.7 3.73e-5   NR WP_160134516.1 2162894 g161973 i0 95.5 2.31016042780749 22 1 35.3 0 69 4 45 66 WP_160134516.1 biotin transporter BioY [Halococcus salsus] diamond 432 50.1 0.992015968063872 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus salsus
32698074 32698074 PRJNA316313_P_NODE_217520_length_187_cov_3.160000_g216134_i0 PRJNA316313 217520 187 3.16 5.9092 Halopenitus sp. 1979403 Archaea Archaea 45.8 0.00144   NR MFB6236112.1 1979403 g216134 i0 60.5 0.689839572192513 43 8 69 1 186 58 335 368 MFB6236112.1 pyruvate dehydrogenase (acetyl-transferring) E1 component subunit alpha [Halopenitus sp.] diamond 129 45.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halopenitus Halopenitus 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);;