RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1145997" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1145997 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
7942762 7942762 PRJNA1145997_P_NODE_48307_length_243_cov_0.917647_g45688_i0 PRJNA1145997 48307 243 0.917647 2.22988221 Deinococcus 1298 Bacteria Bacteria 143 3.35e-42   NR WP_345464301.1 1211323 g45688 i0 86.4 3 81 11 100 0 1 243 31 111 WP_345464301.1 MGMT family protein [Deinococcus carri] diamond 729 144 0.993055555555556 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus carri
13043197 13043197 PRJNA1145997_P_NODE_37991_length_281_cov_1.500000_g35372_i0 PRJNA1145997 37991 281 1.5 4.215 Deinococcus 1298 Bacteria Bacteria 162 4.33e-45   NR WP_235204169.1 1489678 g35372 i0 82.8 2.96797153024911 93 16 99.3 0 281 3 129 221 WP_235204169.1 phospholipase D-like domain-containing protein [Deinococcus sp. RL] diamond 834 162 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. RL
20691174 20691174 PRJNA1145997_P_NODE_47777_length_244_cov_0.912281_g45158_i0 PRJNA1145997 47777 244 0.912281 2.22596564 Deinococcus sp. HSC-46F16 2910968 Bacteria Bacteria 160 4.62e-45   NR WP_253582893.1 2910968 g45158 i0 98.8 0.995901639344262 81 1 99.6 0 243 1 260 340 WP_253582893.1 replicative DNA helicase [Deinococcus sp. HSC-46F16] diamond 243 160 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. HSC-46F16
21966471 21966471 PRJNA1145997_P_NODE_45178_length_248_cov_0.891429_g42559_i0 PRJNA1145997 45178 248 0.891429 2.21074392 Deinococcus budaensis 1665626 Bacteria Bacteria 180 4.3e-51   NR WP_184030404.1 1665626 g42559 i0 100 0.991935483870968 82 0 99.2 0 1 246 138 219 WP_184030404.1 hypothetical protein [Deinococcus budaensis] diamond 246 180 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
26658801 26658801 PRJNA1145997_P_NODE_47701_length_244_cov_0.912281_g45082_i0 PRJNA1145997 47701 244 0.912281 2.22596564 Deinococcus planocerae 1737569 Bacteria Bacteria 132 6.06e-34   NR WP_102125925.1 1737569 g45082 i0 85 0.983606557377049 80 12 98.4 0 4 243 377 456 WP_102125925.1 hypothetical protein [Deinococcus planocerae] diamond 240 132 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus planocerae
27133418 27133418 PRJNA1145997_P_NODE_46722_length_246_cov_0.901734_g44103_i0 PRJNA1145997 46722 246 0.901734 2.21826564 Deinococcus terrestris 2651870 Bacteria Bacteria 109 4.23e-27   NR WP_152871843.1 2651870 g44103 i0 67.9 2.96341463414634 81 26 98.8 0 3 245 32 112 WP_152871843.1 MerR family transcriptional regulator [Deinococcus terrestris] diamond 729 109 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus terrestris
27671004 27671004 PRJNA1145997_P_NODE_46924_length_245_cov_1.581395_g44305_i0 PRJNA1145997 46924 245 1.581395 3.87441775 Deinococcus budaensis 1665626 Bacteria Bacteria 151 1.24e-43   NR WP_184024368.1 1665626 g44305 i0 100 0.991836734693878 81 0 99.2 0 243 1 53 133 WP_184024368.1 AAC(3) family N-acetyltransferase [Deinococcus budaensis] diamond 243 151 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
27828711 27828711 PRJNA1145997_P_NODE_24324_length_541_cov_1.688034_g21711_i0 PRJNA1145997 24324 541 1.688034 9.13226394 uncultured Deinococcus sp. 158789 Bacteria Bacteria 209 5.89e-64   NR WP_295818064.1 158789 g21711 i0 81.7 1.3086876155268 120 22 66.5 0 180 539 1 120 WP_295818064.1 tyrosine-type recombinase/integrase [uncultured Deinococcus sp.] diamond 708 209 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus uncultured Deinococcus sp.
28081178 28081178 PRJNA1145997_P_NODE_38245_length_279_cov_1.514563_g35626_i0 PRJNA1145997 38245 279 1.514563 4.22563077 Deinococcus phoenicis 1476583 Bacteria Bacteria 172 1.6999999999999996e-47   NR WP_034357744.1 1476583 g35626 i0 87 0.989247311827957 92 12 98.9 0 2 277 1536 1627 WP_034357744.1 AAA domain-containing protein [Deinococcus phoenicis] diamond 276 172 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus phoenicis
28175803 28175803 PRJNA1145997_P_NODE_46366_length_246_cov_0.901734_g43747_i0 PRJNA1145997 46366 246 0.901734 2.21826564 Deinococcus sp. YIM 134 47478 Bacteria Bacteria 133 4.4199999999999985e-34   NR WP_331823445.1 3118910 g43747 i0 72.8 0.98780487804878 81 22 98.8 0 2 244 812 892 WP_331823445.1 phage/plasmid primase, P4 family [Deinococcus sp. YIM 134068] diamond 243 133 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus lichenicola
28333837 28333837 PRJNA1145997_P_NODE_44066_length_250_cov_0.881356_g41447_i0 PRJNA1145997 44066 250 0.881356 2.20339 Deinococcus petrolearius 1751295 Bacteria Bacteria 159 3.13e-43   NR WP_380050592.1 1751295 g41447 i0 94 0.996 83 5 99.6 0 249 1 749 831 WP_380050592.1 type IV secretory system conjugative DNA transfer family protein [Deinococcus petrolearius] diamond 249 159 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus petrolearius
28365246 28365246 PRJNA1145997_P_NODE_34266_length_318_cov_1.200000_g31647_i0 PRJNA1145997 34266 318 1.2 3.816 uncultured Deinococcus sp. 158789 Bacteria Bacteria 117 1.05e-28   NR WP_295814286.1 158789 g31647 i0 57.7 0.981132075471698 104 44 98.1 0 314 3 209 312 WP_295814286.1 hypothetical protein [uncultured Deinococcus sp.] diamond 312 117 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus uncultured Deinococcus sp.
28428685 28428685 PRJNA1145997_P_NODE_43526_length_251_cov_0.876404_g40907_i0 PRJNA1145997 43526 251 0.876404 2.19977404 Deinococcus reticulitermitis 856736 Bacteria Bacteria 129 1.3e-33   NR WP_092264766.1 856736 g40907 i0 98.3 0.717131474103586 60 1 71.7 0 22 201 374 433 WP_092264766.1 SWIM zinc finger family protein [Deinococcus reticulitermitis] diamond 180 129 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
29155051 29155051 PRJNA1145997_P_NODE_33609_length_326_cov_1.233202_g30990_i0 PRJNA1145997 33609 326 1.233202 4.02023852 Deinococcus sp. YIM 134 47478 Bacteria Bacteria 66.2 5.07e-10   NR WP_331825405.1 3118910 g30990 i0 51.9 0.478527607361963 52 25 47.9 0 158 3 1 52 WP_331825405.1 site-specific DNA-methyltransferase [Deinococcus sp. YIM 134068] diamond 156 66.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus lichenicola
29155053 29155053 PRJNA1145997_P_NODE_41509_length_257_cov_1.271739_g38890_i0 PRJNA1145997 41509 257 1.271739 3.26836923 Deinococcus sp. HSC-46F16 2910968 Bacteria Bacteria 157 3.1e-42   NR WP_253581492.1 2910968 g38890 i0 92.9 0.992217898832685 85 6 99.2 0 255 1 809 893 WP_253581492.1 helicase-related protein [Deinococcus sp. HSC-46F16] diamond 255 157 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. HSC-46F16
29280906 29280906 PRJNA1145997_P_NODE_34609_length_314_cov_1.576763_g31990_i0 PRJNA1145997 34609 314 1.576763 4.95103582 Deinococcus sp. HSC-46F16 2910968 Bacteria Bacteria 207 9.56e-60   NR WP_253581492.1 2910968 g31990 i0 100 0.993630573248408 104 0 99.4 0 312 1 43 146 WP_253581492.1 helicase-related protein [Deinococcus sp. HSC-46F16] diamond 312 207 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. HSC-46F16
29312663 29312663 PRJNA1145997_P_NODE_34629_length_314_cov_0.970954_g32010_i0 PRJNA1145997 34629 314 0.970954 3.04879556 Deinococcus enclensis 1049582 Bacteria Bacteria 188 3.94e-54   NR WP_307469050.1 1049582 g32010 i0 86.5 0.993630573248408 104 14 99.4 0 2 313 482 585 WP_307469050.1 phospholipase D family protein [Deinococcus enclensis] diamond 312 188 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus enclensis
29565205 29565205 PRJNA1145997_P_NODE_47650_length_244_cov_0.912281_g45031_i0 PRJNA1145997 47650 244 0.912281 2.22596564 Deinococcus navajonensis 309884 Bacteria Bacteria 119 2.94e-29   NR WP_380038952.1 309884 g45031 i0 75.6 0.959016393442623 78 19 95.9 0 6 239 87 164 WP_380038952.1 S8 family serine peptidase [Deinococcus navajonensis] diamond 234 119 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus navajonensis
29754538 29754538 PRJNA1145997_P_NODE_32191_length_346_cov_1.142857_g29572_i0 PRJNA1145997 32191 346 1.142857 3.95428522 Deinococcus radiopugnans 57497 Bacteria Bacteria 121 4.26e-30   NR WP_139405014.1 57497 g29572 i0 60.9 2.86127167630058 110 41 95.4 1 331 2 34 141 WP_139405014.1 hypothetical protein [Deinococcus radiopugnans] diamond 990 121 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
30007549 30007549 PRJNA1145997_P_NODE_33151_length_332_cov_1.189189_g30532_i0 PRJNA1145997 33151 332 1.189189 3.94810748 Deinococcus terrestris 2651870 Bacteria Bacteria 152 4.13e-43   NR WP_152870523.1 2651870 g30532 i0 81.5 0.831325301204819 92 15 81.3 1 270 1 2 93 WP_152870523.1 hypothetical protein [Deinococcus terrestris] diamond 276 152 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus terrestris
30481348 30481348 PRJNA1145997_P_NODE_43273_length_251_cov_1.505618_g40654_i0 PRJNA1145997 43273 251 1.505618 3.77910118 uncultured Truepera sp. 543023 Bacteria Bacteria 103 1.6099999999999997e-24   NR CAA9551700.1 543023 g40654 i0 87.7 1.60159362549801 65 8 77.7 0 36 230 1 65 CAA9551700.1 MAG: Ribose operon repressor [uncultured Truepera sp.] diamond 402 103 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
30639144 30639144 PRJNA1145997_P_NODE_42713_length_252_cov_1.519553_g40094_i0 PRJNA1145997 42713 252 1.519553 3.82927356 Deinococcus navajonensis 309884 Bacteria Bacteria 139 1.27e-36   NR WP_380038950.1 309884 g40094 i0 84.3 0.988095238095238 83 13 98.8 0 2 250 215 297 WP_380038950.1 hypothetical protein [Deinococcus navajonensis] diamond 249 139 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus navajonensis
30722867 30722867 PRJNA1145997_P_NODE_42234_length_253_cov_0.866667_g39615_i0 PRJNA1145997 42234 253 0.866667 2.19266751 Deinococcus 1298 Bacteria Bacteria 53.1 2.21e-6   NR WP_126353472.1 32062 g39615 i0 88.9 0.640316205533597 27 3 32 0 173 253 1 27 WP_126353472.1 hypothetical protein [Deinococcus radiophilus] diamond 162 53.5 0.992523364485981 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus
31144364 31144364 PRJNA1145997_P_NODE_35615_length_303_cov_2.539130_g32996_i0 PRJNA1145997 35615 303 2.53913 7.6935639 Deinococcus taklimakanensis 536443 Bacteria Bacteria 97.1 1.02e-21   NR WP_386847138.1 536443 g32996 i0 83.3 0.594059405940594 60 10 59.4 0 120 299 3 62 WP_386847138.1 hypothetical protein [Deinococcus taklimakanensis] diamond 180 97.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taklimakanensis
31239498 31239498 PRJNA1145997_P_NODE_44115_length_250_cov_0.881356_g41496_i0 PRJNA1145997 44115 250 0.881356 2.20339 Deinococcus apachensis 309886 Bacteria Bacteria 129 1.2099999999999999e-32   NR WP_245557806.1 309886 g41496 i0 76.8 1.968 82 19 98.4 0 248 3 99 180 WP_245557806.1 hypothetical protein [Deinococcus apachensis] diamond 492 129 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus apachensis
31492835 31492835 PRJNA1145997_P_NODE_30876_length_368_cov_1.057627_g28257_i0 PRJNA1145997 30876 368 1.057627 3.89206736 Deinococcus phoenicis 1476583 Bacteria Bacteria 228 6.369999999999999e-74   NR WP_051517418.1 1476583 g28257 i0 95 0.986413043478261 121 6 98.6 0 3 365 89 209 WP_051517418.1 hypothetical protein [Deinococcus phoenicis] diamond 363 228 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus phoenicis
32252218 32252218 PRJNA1145997_P_NODE_35878_length_300_cov_1.374449_g33259_i0 PRJNA1145997 35878 300 1.374449 4.123347 Deinococcus terrestris 2651870 Bacteria Bacteria 176 1.36e-48   NR WP_152870516.1 2651870 g33259 i0 86.9 0.99 99 13 99 0 2 298 436 534 WP_152870516.1 carboxypeptidase-like regulatory domain-containing protein [Deinococcus terrestris] diamond 297 176 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus terrestris
32473590 32473590 PRJNA1145997_P_NODE_44799_length_249_cov_0.886364_g42180_i0 PRJNA1145997 44799 249 0.886364 2.20704636 Deinococcus sp. 14RED 47478 Bacteria Bacteria 88.2 4.01e-18   NR WP_230289414.1 2745874 g42180 i0 53.7 0.987951807228916 82 38 98.8 0 247 2 95 176 WP_230289414.1 helicase HerA domain-containing protein [Deinococcus sp. 14RED07] diamond 246 88.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. 14RED07

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