RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA385073", tax_kingdom = "Thermotogati" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 21 ✖

tax_kingdom 1

  • Thermotogati · 21 ✖

bioproject 1

  • PRJNA385073 · 21 ✖

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
406526 406526 PRJNA385073_P_NODE_62361_length_228_cov_2.812903_g62199_i0 PRJNA385073 62361 228 2.812903 6.41341884 Thermus sp. NEB1569 2918899 Bacteria Bacteria 159 1.1599999999999999e-34   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g62199 i0 87.143 1.2280701754386 140 18 61 0 1 140 767902 767763 Thermus sp. NEB1569 chromosome, complete genome blastn 280 159 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
406535 406535 PRJNA385073_P_NODE_62741_length_226_cov_4.078431_g62579_i0 PRJNA385073 62741 226 4.078431 9.21725406 Allomeiothermus silvanus 52022 Bacteria Bacteria 412 8.01e-111   NTclustered gi|296848933|gb|CP002042.1| 526227 g62579 i0 99.558 1 226 1 100 0 1 226 2973730 2973505 Meiothermus silvanus DSM 9946, complete genome blastn 226 412 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
1681343 1681343 PRJNA385073_P_NODE_62162_length_229_cov_2.294872_g62000_i0 PRJNA385073 62162 229 2.294872 5.25525688 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 401 1.7599999999999995e-107   NTclustered gi|821341785|gb|CP011389.1| 1309411 g62000 i0 98.253 323.17903930131 229 4 100 0 1 229 1637572 1637800 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 74008 401 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
2351790 2351790 PRJNA385073_P_NODE_56842_length_242_cov_0.911243_g56680_i0 PRJNA385073 56842 242 0.911243 2.20520806 FCB group 1783270 Bacteria Bacteria 122 1.6399999999999998e-23   NTclustered gi|313151615|gb|CP002361.1| 670487 g56680 i0 96 31.904958677686 75 3 31 0 75 149 174882 174956 Oceanithermus profundus DSM 14977, complete genome blastn 7721 122 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Oceanithermus Oceanithermus profundus
7454489 7454489 PRJNA385073_P_NODE_65406_length_198_cov_5.480000_g65244_i0 PRJNA385073 65406 198 5.48 10.8504 Thermus 270 Bacteria Bacteria 366 5.4e-97   NTclustered gi|1519238714|emb|LR027517.1| 274 g65244 i0 100 6.00505050505051 198 0 100 0 1 198 554869 555066 Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1 blastn 1189 366 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
8059060 8059060 PRJNA385073_P_NODE_28727_length_282_cov_2.674641_g28565_i0 PRJNA385073 28727 282 2.674641 7.54248762 Deinococcus aquaticus 328692 Bacteria Bacteria 355 1.7699999999999997e-93   NTclustered gi|2444120906|gb|CP115165.1| 328692 g28565 i0 89.437 2.49290780141844 284 26 100 4 1 282 2601906 2601625 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 703 355 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
9334438 9334438 PRJNA385073_P_NODE_53968_length_244_cov_0.900585_g53806_i0 PRJNA385073 53968 244 0.900585 2.1974274 Deinococcus grandis 57498 Bacteria Bacteria 351 1.9399999999999998e-92   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g53806 i0 92.623 4.98770491803279 244 18 100 0 1 244 2984626 2984383 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 1217 351 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
9334651 9334651 PRJNA385073_P_NODE_63328_length_221_cov_4.432432_g63166_i0 PRJNA385073 63328 221 4.432432 9.79567472 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 381 2.2e-101   NTclustered gi|1819261009|gb|CP049357.1| 1288484 g63166 i0 97.738 4.85972850678733 221 5 100 0 1 221 1275139 1274919 Deinococcus wulumuqiensis R12 chromosome, complete genome blastn 1074 381 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
11279491 11279491 PRJNA385073_P_NODE_44449_length_249_cov_1.750000_g44287_i0 PRJNA385073 44449 249 1.75 4.3575 Deinococcus 1298 Bacteria Bacteria 455 1.47e-123   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g44287 i0 99.598 29.9598393574297 249 1 100 0 1 249 200312 200064 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 7460 455 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
13159673 13159673 PRJNA385073_P_NODE_34711_length_266_cov_2.046632_g34549_i0 PRJNA385073 34711 266 2.046632 5.44404112 Deinococcus aquaticus 328692 Bacteria Bacteria 459 1.2299999999999998e-124   NTclustered gi|2444120906|gb|CP115165.1| 328692 g34549 i0 97.744 126.725563909774 266 6 100 0 1 266 915455 915190 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 33709 459 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
15709344 15709344 PRJNA385073_P_NODE_65633_length_196_cov_5.081301_g65471_i0 PRJNA385073 65633 196 5.081301 9.95934996 Thermus brockianus 56956 Bacteria Bacteria 279 7.14e-71   NTclustered gi|1102955210|gb|CP016312.1| 56956 g65471 i0 92.386 48 197 13 100 2 1 196 1968288 1968483 Thermus brockianus strain GE-1 chromosome, complete genome blastn 9408 279 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brockianus
16983026 16983026 PRJNA385073_P_NODE_21494_length_310_cov_5.122363_g21332_i0 PRJNA385073 21494 310 5.122363 15.8793253 Thermus aquaticus 271 Bacteria Bacteria 267 9.5e-67   NTclustered gi|939575972|gb|CP010822.1| 498848 g21332 i0 83.113 38.6258064516129 302 38 97 5 10 310 602670 602381 Thermus aquaticus Y51MC23, complete genome blastn 11974 267 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
16983769 16983769 PRJNA385073_P_NODE_55154_length_243_cov_0.905882_g54992_i0 PRJNA385073 55154 243 0.905882 2.20129326 Deinococcus grandis 57498 Bacteria Bacteria 431 2.4099999999999995e-116   NTclustered gi|1751874559|dbj|AP021851.1| 57498 g54992 i0 98.76 62.9876543209877 242 3 99 0 1 242 32271 32512 Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome blastn 15306 431 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
18927975 18927975 PRJNA385073_P_NODE_63535_length_218_cov_5.400000_g63373_i0 PRJNA385073 63535 218 5.4 11.772 Thermus 270 Bacteria Bacteria 403 4.62e-108   NTclustered gi|2049910225|gb|CP076325.1| 88190 g63373 i0 100 297.394495412844 218 0 100 0 1 218 1856968 1856751 MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome blastn 64832 403 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus antranikianii
20807342 20807342 PRJNA385073_P_NODE_27077_length_287_cov_2.233645_g26915_i0 PRJNA385073 27077 287 2.233645 6.41056115 Deinococcus aetherius 200252 Bacteria Bacteria 204 6.919999999999999e-48   NTclustered gi|2281898193|dbj|AP026561.1| 200252 g26915 i0 89.441 29.0871080139373 161 17 56 0 3 163 706481 706641 Deinococcus aetherius ST0316 plasmid pDAETH-1 DNA, complete genome blastn 8348 204 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aetherius
20807751 20807751 PRJNA385073_P_NODE_44837_length_249_cov_0.875000_g44675_i0 PRJNA385073 44837 249 0.875 2.17875 Deinococcales bacterium 2478479 Bacteria Bacteria 142 1.15e-40   NR HLR47222.1 2478479 g44675 i0 81.7 0.987951807228916 82 15 98.8 0 248 3 97 178 HLR47222.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex transferase subunit TsaD [Deinococcales bacterium] diamond 246 142 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales     Deinococcales bacterium
21477938 21477938 PRJNA385073_P_NODE_40017_length_253_cov_3.577778_g39855_i0 PRJNA385073 40017 253 3.577778 9.05177834 Deinococcus 1298 Bacteria Bacteria 446 9.01e-121   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g39855 i0 98.419 2.12648221343874 253 4 100 0 1 253 2481506 2481758 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 538 446 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
23357951 23357951 PRJNA385073_P_NODE_33139_length_270_cov_2.157360_g32977_i0 PRJNA385073 33139 270 2.15736 5.824872 Thermus antranikianii 88190 Bacteria Bacteria 488 1.5899999999999995e-133   NTclustered gi|2049910225|gb|CP076325.1| 88190 g32977 i0 99.259 2 270 2 100 0 1 270 1556434 1556165 MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome blastn 540 488 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus antranikianii
26853933 26853933 PRJNA385073_P_NODE_41681_length_251_cov_0.865169_g41519_i0 PRJNA385073 41681 251 0.865169 2.17157419 Deinococcus antarcticus 1298767 Bacteria Bacteria 169 3.1099999999999995e-48   NR WP_380079479.1 1298767 g41519 i0 100 0.99203187250996006 83 0 99.2 0 250 2 103 185 WP_380079479.1 phytoene desaturase family protein [Deinococcus antarcticus] diamond 249 169 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
28275231 28275231 PRJNA385073_P_NODE_60406_length_236_cov_5.233129_g60244_i0 PRJNA385073 60406 236 5.233129 12.35018444 Deinococcus ficus 317577 Bacteria Bacteria 71.6 7.26e-13   NR WP_027464402.1 317577 g60244 i0 56 0.953389830508475 75 33 95.3 0 226 2 7 81 WP_027464402.1 hypothetical protein [Deinococcus ficus] diamond 225 71.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
30738611 30738611 PRJNA385073_P_NODE_37134_length_260_cov_2.497326_g36972_i0 PRJNA385073 37134 260 2.497326 6.4930476 Deinococcus ficus 317577 Bacteria Bacteria 66.6 1.56e-10   NR WP_027463859.1 317577 g36972 i0 51.3 0.923076923076923 80 22 72.7 1 68 256 243 322 WP_027463859.1 sensor domain-containing diguanylate cyclase [Deinococcus ficus] diamond 240 66.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus

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