RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJEB64798 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
8646809 8646809 PRJEB64798_P_NODE_80467_length_214_cov_14.612121_g78701_i0 PRJEB64798 80467 214 14.612121 31.26993894 Deinococcus cavernae 2320857 Bacteria Bacteria 69.3 1.05e-11   NR WP_338014433.1 2320857 g78701 i0 96.8 0.434579439252336 31 1 43.5 0 209 117 1 31 WP_338014433.1 M3 family oligoendopeptidase [Deinococcus cavernae] diamond 93 69.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
16704614 16704614 PRJEB64798_P_NODE_204034_length_166_cov_4.076923_g202268_i0 PRJEB64798 204034 166 4.076923 6.76769218 Deinococcus fonticola 2528713 Bacteria Bacteria 70.5 2.18e-12   NR WP_135227889.1 2528713 g202268 i0 94.7 0.686746987951807 38 2 68.7 0 120 7 33 70 WP_135227889.1 ABC transporter ATP-binding protein [Deinococcus fonticola] diamond 114 70.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus fonticola
20119505 20119505 PRJEB64798_P_NODE_161936_length_182_cov_7.864662_g160170_i0 PRJEB64798 161936 182 7.864662 14.31368484 Deinococcus 1298 Bacteria Bacteria 114 7.06e-28   NR WP_380077892.1 1298767 g160170 i0 85.3 2.24175824175824 68 1 97.3 1 177 1 486 553 WP_380077892.1 AMP-binding protein [Deinococcus antarcticus] diamond 408 115 0.991304347826087 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
20528184 20528184 PRJEB64798_P_NODE_159297_length_184_cov_1.162963_g157531_i0 PRJEB64798 159297 184 1.162963 2.13985192 Deinococcus malanensis 1706855 Bacteria Bacteria 114 5.249999999999999e-28   NR WP_189003738.1 1706855 g157531 i0 91.7 1.95652173913043 60 5 97.8 0 183 4 370 429 WP_189003738.1 phosphoglucomutase (alpha-D-glucose-1,6-bisphosphate-dependent) [Deinococcus malanensis] diamond 360 114 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus malanensis
26622281 26622281 PRJEB64798_P_NODE_89101_length_212_cov_7.907975_g87335_i0 PRJEB64798 89101 212 7.907975 16.764907 Meiothermus sp. 1955249 Bacteria Bacteria 67.4 4.03e-11   NR MER3484169.1 1955249 g87335 i0 41.7 1.18867924528302 84 32 94.8 1 201 1 109 192 MER3484169.1 A/G-specific adenine glycosylase [Meiothermus sp.] diamond 252 67.4 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus sp.
26741532 26741532 PRJEB64798_P_NODE_137461_length_194_cov_20.868966_g135695_i0 PRJEB64798 137461 194 20.868966 40.48579404 Deinococcus 1298 Bacteria Bacteria 71.2 1.67e-13   NR WP_119760421.1 2320857 g135695 i0 100 1.14432989690722 37 0 57.2 0 113 3 1 37 WP_119760421.1 hypothetical protein [Deinococcus cavernae] diamond 222 71.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
26844071 26844071 PRJEB64798_P_NODE_186141_length_172_cov_1.674797_g184375_i0 PRJEB64798 186141 172 1.674797 2.88065084 Deinococcus reticulitermitis 856736 Bacteria Bacteria 104 2.1499999999999998e-24   NR WP_092265518.1 856736 g184375 i0 92.9 0.976744186046512 56 4 97.7 0 4 171 983 1038 WP_092265518.1 S-layer homology domain-containing protein [Deinococcus reticulitermitis] diamond 168 104 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
26963358 26963358 PRJEB64798_P_NODE_129962_length_198_cov_5.248322_g128196_i0 PRJEB64798 129962 198 5.248322 10.39167756 Bacteria 2 Bacteria Bacteria 75.9 1.62e-14   NR MBS3965876.1 2478917 g128196 i0 57.1 1.89393939393939 63 26 93.9 1 8 193 189 251 MBS3965876.1 sulfurtransferase [Truepera sp.] diamond 375 76.6 0.990861618798956 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera sp.
27065419 27065419 PRJEB64798_P_NODE_86742_length_212_cov_17.705521_g84976_i0 PRJEB64798 86742 212 17.705521 37.53570452 Deinococcus fonticola 2528713 Bacteria Bacteria 73.6 2.75e-14   NR WP_135230350.1 2528713 g84976 i0 100 0.466981132075472 33 0 46.7 0 100 2 119 151 WP_135230350.1 hypothetical protein [Deinococcus fonticola] diamond 99 73.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus fonticola
27254945 27254945 PRJEB64798_P_NODE_217203_length_163_cov_0.912281_g215437_i0 PRJEB64798 217203 163 0.912281 1.48701803 Deinococcus reticulitermitis 856736 Bacteria Bacteria 84.3 2.75e-17   NR WP_092264776.1 856736 g215437 i0 81.1 0.975460122699387 53 10 97.5 0 5 163 186 238 WP_092264776.1 polysaccharide biosynthesis tyrosine autokinase [Deinococcus reticulitermitis] diamond 159 84.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
27255049 27255049 PRJEB64798_P_NODE_87443_length_212_cov_12.337423_g85677_i0 PRJEB64798 87443 212 12.337423 26.15533676 Deinococcus aerolatus 522487 Bacteria Bacteria 105 2.5e-25   NR WP_188974190.1 522487 g85677 i0 63.2 1.34433962264151 95 9 97.6 1 207 1 56 150 WP_188974190.1 DUF3103 family protein [Deinococcus aerolatus] diamond 285 105 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aerolatus
27286539 27286539 PRJEB64798_P_NODE_142563_length_192_cov_3.566434_g140797_i0 PRJEB64798 142563 192 3.566434 6.84755328 Deinococcus xinjiangensis 457454 Bacteria Bacteria 108 4.22e-28   NR WP_353542204.1 457454 g140797 i0 68.9 1.40625 90 1 98.4 2 189 1 10 99 WP_353542204.1 hypothetical protein [Deinococcus xinjiangensis] diamond 270 108 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus xinjiangensis
27602722 27602722 PRJEB64798_P_NODE_25684_length_388_cov_9.504425_g23935_i0 PRJEB64798 25684 388 9.504425 36.877169 Deinococcus misasensis 392413 Bacteria Bacteria 50.1 4.76e-4   NR WP_034336163.1 392413 g23935 i0 37.1 0.541237113402062 70 43 53.4 1 209 3 338 407 WP_034336163.1 thiol-activated cytolysin family protein [Deinococcus misasensis] diamond 210 50.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
28006242 28006242 PRJEB64798_P_NODE_201245_length_167_cov_1.991525_g199479_i0 PRJEB64798 201245 167 1.991525 3.32584675 Thermus 270 Bacteria Bacteria 41.2 0.00918   NR BAW01490.1 274 g199479 i0 51.5 1.20359281437126 33 16 59.3 0 123 25 34 66 BAW01490.1 Uncharacterized protein TTMY_1091 [Thermus thermophilus] diamond 201 41.2 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
28013087 28013087 PRJEB64798_P_NODE_175505_length_176_cov_4.692913_g173739_i0 PRJEB64798 175505 176 4.692913 8.25952688 Thermus thermophilus 274 Bacteria Bacteria 40.4 0.0207   NR BAW01490.1 274 g173739 i0 78.3 0.392045454545455 23 5 39.2 0 70 2 49 71 BAW01490.1 Uncharacterized protein TTMY_1091 [Thermus thermophilus] diamond 69 40.4 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
28605942 28605942 PRJEB64798_P_NODE_202907_length_166_cov_13.846154_g201141_i0 PRJEB64798 202907 166 13.846154 22.98461564 PVC group 1783257 Bacteria Bacteria 58.9 2.41e-8   NR MCY4353597.1 2478917 g201141 i0 51.9 1.95180722891566 54 26 97.6 0 164 3 301 354 MCY4353597.1 FAD-binding protein [Truepera sp.] diamond 324 59.3 0.993254637436762 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera sp.
28739138 28739138 PRJEB64798_P_NODE_195067_length_169_cov_0.866667_g193301_i0 PRJEB64798 195067 169 0.866667 1.46466723 Deinococcus xinjiangensis 457454 Bacteria Bacteria 94.7 6.4e-21   NR WP_353543265.1 457454 g193301 i0 94.4 0.958579881656805 54 3 95.9 0 164 3 18 71 WP_353543265.1 DUF937 domain-containing protein [Deinococcus xinjiangensis] diamond 162 94.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus xinjiangensis
29023552 29023552 PRJEB64798_P_NODE_102928_length_212_cov_2.570552_g101162_i0 PRJEB64798 102928 212 2.570552 5.44957024 Deinococcus radiodurans 1299 Bacteria Bacteria 48.1 7.3e-5   NR WP_227085929.1 1299 g101162 i0 81.3 0.452830188679245 32 6 45.3 0 99 4 3 34 WP_227085929.1 DUF1622 domain-containing protein [Deinococcus radiodurans] diamond 96 48.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans
29900656 29900656 PRJEB64798_P_NODE_89311_length_212_cov_7.656442_g87545_i0 PRJEB64798 89311 212 7.656442 16.23165704 Bacteria 2 Bacteria Bacteria 46.2 0.00142   NR WP_016330256.1 56957 g87545 i0 45.9 1.30188679245283 61 31 84.9 2 1 180 49 108 WP_016330256.1 DUF7146 domain-containing protein [Thermus oshimai] diamond 276 46.2 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus oshimai
30033952 30033952 PRJEB64798_P_NODE_68871_length_233_cov_6.570652_g67106_i0 PRJEB64798 68871 233 6.570652 15.30961916 Deinococcus xinjiangensis 457454 Bacteria Bacteria 88.2 3.12e-18   NR WP_353543084.1 457454 g67106 i0 100 0.502145922746781 39 0 50.2 0 122 6 304 342 WP_353543084.1 phage tail sheath family protein [Deinococcus xinjiangensis] diamond 117 88.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus xinjiangensis
30350207 30350207 PRJEB64798_P_NODE_152172_length_187_cov_5.398551_g150406_i0 PRJEB64798 152172 187 5.398551 10.09529037 Deinococcus reticulitermitis 856736 Bacteria Bacteria 66.6 7.35e-12   NR WP_092263445.1 856736 g150406 i0 94.1 0.545454545454545 34 2 54.5 0 182 81 121 154 WP_092263445.1 hypothetical protein [Deinococcus reticulitermitis] diamond 102 66.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
30476300 30476300 PRJEB64798_P_NODE_249533_length_152_cov_3.067961_g247767_i0 PRJEB64798 249533 152 3.067961 4.66330072 Deinococcus sp. Marseille-Q64 47478 Bacteria Bacteria 85.9 5.24e-20   NR WP_261664746.1 2969223 g247767 i0 86.4 0.868421052631579 44 6 86.8 0 20 151 1 44 WP_261664746.1 glycine cleavage system protein GcvH [Deinococcus sp. Marseille-Q6407] diamond 132 85.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. Marseille-Q6407
30918723 30918723 PRJEB64798_P_NODE_70894_length_229_cov_18.838889_g69129_i0 PRJEB64798 70894 229 18.838889000000002 43.14105581 Deinococcus misasensis 392413 Bacteria Bacteria 47 9.62e-4   NR WP_034336163.1 392413 g69129 i0 31.9 0.903930131004367 69 47 90.4 0 218 12 333 401 WP_034336163.1 thiol-activated cytolysin family protein [Deinococcus misasensis] diamond 207 47 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
31424039 31424039 PRJEB64798_P_NODE_103556_length_212_cov_2.460123_g101790_i0 PRJEB64798 103556 212 2.460123 5.21546076 Deinococcus sp. 47478 Bacteria Bacteria 69.3 1.05e-11   NR WP_291423126.1 47478 g101790 i0 61.8 1.68396226415094 55 20 77.8 1 2 166 544 597 WP_291423126.1 phosphomethylpyrimidine synthase ThiC [Deinococcus sp.] diamond 357 69.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
31866818 31866818 PRJEB64798_P_NODE_165297_length_181_cov_1.924242_g163531_i0 PRJEB64798 165297 181 1.924242 3.48287802 Deinococcus antarcticus 1298767 Bacteria Bacteria 72.8 1.72e-13   NR WP_380080540.1 1298767 g163531 i0 80.4 0.76243093922651906 46 9 76.2 0 138 1 181 226 WP_380080540.1 desiccation-associated late embryogenesis abundant protein [Deinococcus antarcticus] diamond 138 72.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
31898691 31898691 PRJEB64798_P_NODE_201457_length_167_cov_1.627119_g199691_i0 PRJEB64798 201457 167 1.627119 2.71728873 Deinococcus antarcticus 1298767 Bacteria Bacteria 76.3 2.03e-14   NR WP_380079907.1 1298767 g199691 i0 81.3 0.862275449101796 48 8 86.2 1 159 16 370 416 WP_380079907.1 S-layer homology domain-containing protein [Deinococcus antarcticus] diamond 144 76.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
32151706 32151706 PRJEB64798_P_NODE_108278_length_210_cov_11.416149_g106512_i0 PRJEB64798 108278 210 11.416149 23.9739129 Deinococcus fonticola 2528713 Bacteria Bacteria 75.5 4.15e-15   NR WP_135230354.1 2528713 g106512 i0 97 0.471428571428571 33 1 47.1 0 101 3 91 123 WP_135230354.1 hypothetical protein [Deinococcus fonticola] diamond 99 75.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus fonticola
32373414 32373414 PRJEB64798_P_NODE_181699_length_173_cov_14.903226_g179933_i0 PRJEB64798 181699 173 14.903226 25.78258098 Deinococcus fonticola 2528713 Bacteria Bacteria 115 4.219999999999999e-31   NR WP_135229301.1 2528713 g179933 i0 96.5 0.988439306358382 57 2 98.8 0 1 171 2 58 WP_135229301.1 DinB family protein [Deinococcus fonticola] diamond 171 115 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus fonticola
32657243 32657243 PRJEB64798_P_NODE_207680_length_165_cov_4.448276_g205914_i0 PRJEB64798 207680 165 4.448276 7.3396554 Deinococcus budaensis 1665626 Bacteria Bacteria 91.7 7.45e-20   NR WP_221269637.1 1665626 g205914 i0 89.8 0.890909090909091 49 5 89.1 0 148 2 445 493 WP_221269637.1 DUF11 domain-containing protein [Deinococcus budaensis] diamond 147 91.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
32720570 32720570 PRJEB64798_P_NODE_165000_length_181_cov_2.712121_g163234_i0 PRJEB64798 165000 181 2.712121 4.90893901 Deinococcota bacterium 1913990 Bacteria Bacteria 113 2.12e-28   NR MEY4529753.1 1913990 g163234 i0 96.4 0.92817679558011 56 2 92.8 0 176 9 283 338 MEY4529753.1 hypothetical protein [Deinococcota bacterium] diamond 168 113 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium

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