RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA315399" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315399 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
1657842 1657842 PRJNA315399_P_NODE_415662_length_160_cov_2.756098_g415214_i0 PRJNA315399 415662 160 2.756098 4.4097568 Ignisphaera sp. 2268142 Archaea Archaea 57.4 7.94e-8   NR MCI4437587.1 2268142 g415214 i0 54.4 2.00625 57 18 91.9 1 6 152 786 842 MCI4437587.1 hypothetical protein [Ignisphaera sp.] diamond 321 57.4 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
26648507 26648507 PRJNA315399_S_NODE_37881_length_232_cov_2.933333_g37680_i0 PRJNA315399 37881 232 2.933333 6.80533256 Thermoproteati 1783275 Archaea Archaea 103 8.84e-24   NR MDQ6723989.1 2056631 g37680 i0 57.1 2.00431034482759 77 33 99.6 0 232 2 464 540 MDQ6723989.1 FAD-dependent oxidoreductase [Thermoproteota archaeon] diamond 465 103 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
26902212 26902212 PRJNA315399_P_NODE_505241_length_151_cov_1.175439_g504793_i0 PRJNA315399 505241 151 1.175439 1.77491289 Thermoproteati 1783275 Archaea Archaea 82.4 5.79e-17   NR MDP9305593.1 2056631 g504793 i0 100 6.6158940397351 37 0 73.5 0 126 16 203 239 MDP9305593.1 radical SAM protein [Thermoproteota archaeon] diamond 999 82.4 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27105893 27105893 PRJNA315399_S_NODE_105542_length_176_cov_2.467626_g105341_i0 PRJNA315399 105542 176 2.467626 4.34302176 Thermoproteota archaeon 2056631 Archaea Archaea 108 8.150000000000001e-27   NR MDP9489797.1 2056631 g105341 i0 92.7 0.9375 55 4 93.8 0 8 172 14 68 MDP9489797.1 metallophosphoesterase [Thermoproteota archaeon] diamond 165 108 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27976217 27976217 PRJNA315399_S_NODE_197385_length_150_cov_3.300885_g197184_i0 PRJNA315399 197385 150 3.300885 4.9513275 Thermoproteati 1783275 Archaea Archaea 64.7 5.57e-11   NR ACY24515.1 684058 g197184 i0 90.3 4.96 31 3 62 0 141 49 174 204 ACY24515.1 nitroreductase related protein [uncultured crenarchaeote 57a5] diamond 744 64.7 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote 57a5
28337744 28337744 PRJNA315399_P_NODE_362646_length_166_cov_15.767442_g362198_i0 PRJNA315399 362646 166 15.767442 26.17395372 Thermoproteota archaeon 2056631 Archaea Archaea 73.9 6.87e-16   NR MDP9490532.1 2056631 g362198 i0 66.1 1.01204819277108 56 3 72.3 1 149 30 6 61 MDP9490532.1 hypothetical protein [Thermoproteota archaeon] diamond 168 73.9 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28369273 28369273 PRJNA315399_S_NODE_88646_length_184_cov_3.625850_g88445_i0 PRJNA315399 88646 184 3.62585 6.671564 Sulfolobaceae archaeon 2967306 Archaea Archaea 102 1.15e-26   NR MEM0173288.1 2967306 g88445 i0 72.9 0.96195652173913 59 16 96.2 0 7 183 18 76 MEM0173288.1 hypothetical protein [Sulfolobaceae archaeon] diamond 177 102 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
28590436 28590436 PRJNA315399_P_NODE_272427_length_180_cov_4.419580_g271979_i0 PRJNA315399 272427 180 4.41958 7.955244 Ignisphaera sp. 2268142 Archaea Archaea 45.1 0.00246   NR MCI4435492.1 2268142 g271979 i0 87 0.383333333333333 23 3 38.3 0 170 102 613 635 MCI4435492.1 hypothetical protein [Ignisphaera sp.] diamond 69 45.1 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
28842786 28842786 PRJNA315399_S_NODE_38088_length_231_cov_12.201031_g37887_i0 PRJNA315399 38088 231 12.201031 28.18438161 Sulfolobaceae archaeon 2967306 Archaea Archaea 112 3.56e-28   NR MEM0173289.1 2967306 g37887 i0 77.5 0.922077922077922 71 16 92.2 0 16 228 5 75 MEM0173289.1 hypothetical protein [Sulfolobaceae archaeon] diamond 213 112 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
29853407 29853407 PRJNA315399_S_NODE_5791_length_420_cov_10.305483_g5594_i0 PRJNA315399 5791 420 10.305483 43.2830286 Sulfolobaceae archaeon 2967306 Archaea Archaea 72.4 5.5e-14   NR MEM0173286.1 2967306 g5594 i0 63.6 0.392857142857143 55 17 39.3 1 287 123 6 57 MEM0173286.1 hypothetical protein [Sulfolobaceae archaeon] diamond 165 72.4 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
30074286 30074286 PRJNA315399_S_NODE_176732_length_154_cov_5.290598_g176531_i0 PRJNA315399 176732 154 5.290598 8.14752092 Sulfolobus sp. A2 2288 Archaea Archaea 76.3 1.48e-14   NR TRM73985.1 2200880 g176531 i0 78.3 0.896103896103896 46 10 89.6 0 140 3 167 212 TRM73985.1 hypothetical protein DJ532_14000 [Sulfolobus sp. A20-N-F8] diamond 138 76.3 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus sp. A20-N-F8
30643009 30643009 PRJNA315399_P_NODE_465993_length_154_cov_6.264957_g465545_i0 PRJNA315399 465993 154 6.264957 9.64803378 Ignisphaera sp. 2268142 Archaea Archaea 88.2 1.08e-18   NR MCI4435632.1 2268142 g465545 i0 88.6 0.857142857142857 44 5 85.7 0 142 11 506 549 MCI4435632.1 hypothetical protein [Ignisphaera sp.] diamond 132 88.2 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
31433163 31433163 PRJNA315399_P_NODE_226076_length_183_cov_4.595890_g225628_i0 PRJNA315399 226076 183 4.59589 8.4104787 Ignisphaera sp. 2268142 Archaea Archaea 72 7.17e-13   NR MCI4437874.1 2268142 g225628 i0 66 1.72131147540984 53 17 85.2 1 11 166 244 296 MCI4437874.1 hypothetical protein [Ignisphaera sp.] diamond 315 72 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
31433231 31433231 PRJNA315399_S_NODE_132776_length_166_cov_2.217054_g132575_i0 PRJNA315399 132776 166 2.217054 3.68030964 Thermoproteota archaeon 2056631 Archaea Archaea 45.4 4.34e-4   NR MDQ3083908.1 2056631 g132575 i0 87.1 0.560240963855422 31 4 56 0 72 164 1 31 MDQ3083908.1 hypothetical protein [Thermoproteota archaeon] diamond 93 45.4 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32065890 32065890 PRJNA315399_S_NODE_89718_length_183_cov_10.212329_g89517_i0 PRJNA315399 89718 183 10.212329 18.68856207 Sulfolobaceae archaeon 2967306 Archaea Archaea 74.7 6.11e-15   NR MEM0173287.1 2967306 g89517 i0 58.2 0.901639344262295 55 23 90.2 0 182 18 75 129 MEM0173287.1 hypothetical protein [Sulfolobaceae archaeon] diamond 165 74.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
32477434 32477434 PRJNA315399_P_NODE_375539_length_164_cov_9.244094_g375091_i0 PRJNA315399 375539 164 9.244094 15.16031416 Thermoproteota archaeon 2056631 Archaea Archaea 91.7 3.83e-20   NR MDQ2685723.1 2056631 g375091 i0 93.8 0.878048780487805 48 3 87.8 0 17 160 34 81 MDQ2685723.1 hypothetical protein [Thermoproteota archaeon] diamond 144 91.7 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32697939 32697939 PRJNA315399_P_NODE_20460_length_294_cov_6.630350_g20017_i0 PRJNA315399 20460 294 6.63035 19.493229 Ignisphaera sp. 2268142 Archaea Archaea 67 2.17e-10   NR MCI4435493.1 2268142 g20017 i0 53.7 0.683673469387755 67 28 66.3 2 213 19 2317 2382 MCI4435493.1 hypothetical protein [Ignisphaera sp.] diamond 201 67 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera 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);;