contig_metadata
21 rows where bioproject = "PRJEB14803" and tax_kingdom = "Thermotogati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2261102 | 2261102 | PRJEB14803_P_NODE_38562_length_169_cov_1.746269_g38096_i0 | PRJEB14803 | 38562 | 169 | 1.746269 | 2.95119461 | Deinococcus | 1298 | Bacteria | Bacteria | 302 | 1.27e-77 | NTclustered | gi|730601855|gb|CP010028.1| | 57497 | g38096 | i0 | 98.817 | 201.532544378698 | 169 | 2 | 100 | 0 | 1 | 169 | 70989 | 70821 | Deinococcus swuensis strain DY59, complete genome | blastn | 34059 | 302 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiopugnans | ||
| 3847673 | 3847673 | PRJEB14803_P_NODE_34904_length_180_cov_1.496552_g34438_i0 | PRJEB14803 | 34904 | 180 | 1.496552 | 2.6937936 | Deinococcus gobiensis | 502394 | Bacteria | Bacteria | 307 | 2.9500000000000003e-79 | NTclustered | gi|379998737|gb|CP002191.1| | 745776 | g34438 | i0 | 97.753 | 92.5666666666667 | 178 | 4 | 99 | 0 | 3 | 180 | 803305 | 803128 | Deinococcus gobiensis I-0, complete genome | blastn | 16662 | 307 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus gobiensis | ||
| 5123765 | 5123765 | PRJEB14803_P_NODE_13625_length_333_cov_2.258389_g13160_i0 | PRJEB14803 | 13625 | 333 | 2.258389 | 7.52043537 | Deinococcus actinosclerus | 1768108 | Bacteria | Bacteria | 566 | 9.06e-157 | NTclustered | gi|972944657|gb|CP013910.1| | 1768108 | g13160 | i0 | 97.305 | 243.597597597598 | 334 | 8 | 100 | 1 | 1 | 333 | 75034 | 74701 | Deinococcus actinosclerus strain BM2 chromosome, complete genome | blastn | 81118 | 566 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus actinosclerus | ||
| 15013644 | 15013644 | PRJEB14803_P_NODE_19872_length_260_cov_1.804444_g19406_i0 | PRJEB14803 | 19872 | 260 | 1.804444 | 4.6915544 | Deinococcus | 1298 | Bacteria | Bacteria | 219 | 2.21e-52 | NTclustered | gi|485099143|ref|NR_102538.1| | 432329 | g19406 | i0 | 82.51 | 457.657692307692 | 263 | 32 | 97 | 10 | 8 | 260 | 284 | 26 | Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence | blastn | 118991 | 219 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus peraridilitoris | ||
| 16288502 | 16288502 | PRJEB14803_P_NODE_40013_length_165_cov_1.915385_g39547_i0 | PRJEB14803 | 40013 | 165 | 1.915385 | 3.16038525 | Deinococcus | 1298 | Bacteria | Bacteria | 305 | 9.59e-79 | NTclustered | gi|1751871007|dbj|AP021849.1| | 57498 | g39547 | i0 | 100 | 206.684848484848 | 165 | 0 | 100 | 0 | 1 | 165 | 73081 | 72917 | Deinococcus grandis ATCC 43672 DNA, complete genome | blastn | 34103 | 305 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus grandis | ||
| 18837619 | 18837619 | PRJEB14803_P_NODE_41175_length_162_cov_3.070866_g40709_i0 | PRJEB14803 | 41175 | 162 | 3.070866 | 4.97480292 | Petrotoga | 28236 | Bacteria | Bacteria | 84.2 | 4.78e-12 | NTclustered | gi|470482695|ref|NR_076547.1| | 69499 | g40709 | i0 | 88.406 | 2.65432098765432 | 69 | 8 | 43 | 0 | 1 | 69 | 48 | 116 | Petrotoga mobilis strain SJ95 23S ribosomal RNA gene, complete sequence | blastn | 430 | 84.2 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Petrotoga | Petrotoga mobilis | ||
| 23938156 | 23938156 | PRJEB14803_P_NODE_16979_length_288_cov_35.027668_g16513_i0 | PRJEB14803 | 16979 | 288 | 35.027668 | 100.87968384 | Deinococcus | 1298 | Bacteria | Bacteria | 472 | 1.73e-128 | NTclustered | gi|2113031129|gb|OK500351.1| | 47478 | g16513 | i0 | 96.181 | 106.006944444444 | 288 | 11 | 100 | 0 | 1 | 288 | 850 | 563 | Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence | blastn | 30530 | 472 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 25211865 | 25211865 | PRJEB14803_P_NODE_12320_length_356_cov_1.601246_g11855_i0 | PRJEB14803 | 12320 | 356 | 1.601246 | 5.70043576 | Deinococcus | 1298 | Bacteria | Bacteria | 555 | 2.1099999999999994e-153 | NTclustered | gi|470486828|ref|NR_076782.1| | 502394 | g11855 | i0 | 95.665 | 172.587078651685 | 346 | 13 | 97 | 2 | 12 | 356 | 1476 | 1132 | Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence | blastn | 61441 | 555 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus gobiensis | ||
| 26621550 | 26621550 | PRJEB14803_P_NODE_39121_length_168_cov_1.165414_g38655_i0 | PRJEB14803 | 39121 | 168 | 1.165414 | 1.95789552 | Thermus thalpophilus | 2908147 | Bacteria | Bacteria | 41.6 | 0.0343 | NR | GAA6756877.1 | 2908147 | g38655 | i0 | 41.5 | 0.946428571428571 | 53 | 30 | 94.6 | 1 | 5 | 163 | 225 | 276 | GAA6756877.1 hypothetical protein Thermus77420_23530 [Thermus thalpophilus] | diamond | 159 | 41.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus thalpophilus | ||
| 27570182 | 27570182 | PRJEB14803_P_NODE_29944_length_198_cov_1.472393_g29478_i0 | PRJEB14803 | 29944 | 198 | 1.472393 | 2.91533814 | Deinococcota bacterium | 1913990 | Bacteria | Bacteria | 42.7 | 0.0209 | NR | MDQ3460049.1 | 1913990 | g29478 | i0 | 41.4 | 0.878787878787879 | 58 | 31 | 87.9 | 1 | 174 | 1 | 242 | 296 | MDQ3460049.1 1-deoxy-D-xylulose-5-phosphate reductoisomerase [Deinococcota bacterium] | diamond | 174 | 42.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 27942840 | 27942840 | PRJEB14803_P_NODE_36585_length_175_cov_1.421429_g36119_i0 | PRJEB14803 | 36585 | 175 | 1.421429 | 2.48750075 | root | 1 | Root_unresolved | Root_unresolved | 85.5 | 1.3e-17 | NR | WP_038066611.1 | 2337 | g36119 | i0 | 75.9 | 19.1828571428571 | 58 | 14 | 99.4 | 0 | 2 | 175 | 61 | 118 | WP_038066611.1 pyruvate, phosphate dikinase [Thermotoga neapolitana] | diamond | 3357 | 85.9 | 0.9953434225844 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | Thermotoga neapolitana | ||
| 28170165 | 28170165 | PRJEB14803_P_NODE_35046_length_180_cov_1.096552_g34580_i0 | PRJEB14803 | 35046 | 180 | 1.096552 | 1.9737936 | Deinococcus roseus | 392414 | Bacteria | Bacteria | 41.6 | 0.0398 | NR | WP_189002135.1 | 392414 | g34580 | i0 | 42.2 | 1.06666666666667 | 64 | 24 | 85 | 2 | 175 | 23 | 220 | 283 | WP_189002135.1 complex I NDUFA9 subunit family protein [Deinococcus roseus] | diamond | 192 | 41.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus roseus | ||
| 28454533 | 28454533 | PRJEB14803_P_NODE_4106_length_693_cov_1.851064_g3732_i0 | PRJEB14803 | 4106 | 693 | 1.851064 | 12.82787352 | Thermotogaceae bacterium | 2268206 | Bacteria | Bacteria | 53.5 | 3.04e-4 | NR | MCD6102495.1 | 2268206 | g3732 | i0 | 26.4 | 4.00865800865801 | 201 | 101 | 86.6 | 9 | 641 | 42 | 147 | 301 | MCD6102495.1 hypothetical protein [Thermotogaceae bacterium] | diamond | 2778 | 53.5 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotogaceae bacterium | |||
| 29243745 | 29243745 | PRJEB14803_P_NODE_47689_length_150_cov_1.026087_g47223_i0 | PRJEB14803 | 47689 | 150 | 1.026087 | 1.5391305 | Deinococcus aetherius | 200252 | Bacteria | Bacteria | 43.5 | 0.00555 | NR | WP_264778174.1 | 200252 | g47223 | i0 | 47.7 | 0.88 | 44 | 23 | 88 | 0 | 140 | 9 | 476 | 519 | WP_264778174.1 BTAD domain-containing putative transcriptional regulator [Deinococcus aetherius] | diamond | 132 | 43.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aetherius | ||
| 29338487 | 29338487 | PRJEB14803_P_NODE_41529_length_162_cov_1.212598_g41063_i0 | PRJEB14803 | 41529 | 162 | 1.212598 | 1.96440876 | Calidithermus terrae | 1408545 | Bacteria | Bacteria | 41.2 | 0.0434 | NR | WP_119315375.1 | 1408545 | g41063 | i0 | 55.6 | 0.5 | 27 | 12 | 50 | 0 | 160 | 80 | 55 | 81 | WP_119315375.1 M14 family metallopeptidase [Calidithermus terrae] | diamond | 81 | 41.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Calidithermus | Calidithermus terrae | ||
| 29685401 | 29685401 | PRJEB14803_P_NODE_7270_length_496_cov_3.136659_g6817_i0 | PRJEB14803 | 7270 | 496 | 3.136659 | 15.55782864 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 45.8 | 0.0364 | NR | MBQ7543635.1 | 2053624 | g6817 | i0 | 34.1 | 0.834677419354839 | 138 | 80 | 81.7 | 5 | 408 | 4 | 572 | 701 | MBQ7543635.1 putative Ig domain-containing protein [Synergistaceae bacterium] | diamond | 414 | 45.8 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 30475553 | 30475553 | PRJEB14803_P_NODE_31633_length_191_cov_2.051282_g31167_i0 | PRJEB14803 | 31633 | 191 | 2.051282 | 3.91794862 | Deinococcus taeanensis | 2737050 | Bacteria | Bacteria | 78.2 | 6.01e-15 | NR | WP_225476513.1 | 2737050 | g31167 | i0 | 57.1 | 0.989528795811518 | 63 | 26 | 97.4 | 1 | 191 | 6 | 385 | 447 | WP_225476513.1 G8 domain-containing protein [Deinococcus taeanensis] | diamond | 189 | 78.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taeanensis | ||
| 30601726 | 30601726 | PRJEB14803_P_NODE_39893_length_166_cov_1.083969_g39427_i0 | PRJEB14803 | 39893 | 166 | 1.083969 | 1.79938854 | Marinitoga | 160798 | Bacteria | Bacteria | 44.3 | 0.00361 | NR | WP_014296263.1 | 160798 | g39427 | i0 | 43.5 | 1.66265060240964 | 46 | 26 | 83.1 | 0 | 21 | 158 | 231 | 276 | WP_014296263.1 MULTISPECIES: asparaginase [Marinitoga] | diamond | 276 | 44.3 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Marinitoga | |||
| 31132252 | 31132252 | PRJEB14803_P_NODE_36155_length_176_cov_1.624113_g35689_i0 | PRJEB14803 | 36155 | 176 | 1.624113 | 2.85843888 | PVC group | 1783257 | Bacteria | Bacteria | 79.7 | 7.43e-16 | NR | WP_029475990.1 | 249403 | g35689 | i0 | 66.7 | 13.2784090909091 | 54 | 18 | 92 | 0 | 14 | 175 | 1 | 54 | WP_029475990.1 malate dehydrogenase [Deinococcus frigens] | diamond | 2337 | 79.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus frigens | ||
| 31828148 | 31828148 | PRJEB14803_P_NODE_33457_length_185_cov_1.066667_g32991_i0 | PRJEB14803 | 33457 | 185 | 1.066667 | 1.97333395 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 1.75e-5 | NR | WP_033191765.1 | 2423 | g32991 | i0 | 33.9 | 6.42162162162162 | 59 | 39 | 95.7 | 0 | 5 | 181 | 634 | 692 | WP_033191765.1 WD40 repeat domain-containing protein [Fervidobacterium islandicum] | diamond | 1188 | 51.2 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium islandicum | ||
| 32461255 | 32461255 | PRJEB14803_P_NODE_42339_length_160_cov_1.280000_g41873_i0 | PRJEB14803 | 42339 | 160 | 1.28 | 2.048 | Bacteria | 2 | Bacteria | Bacteria | 69.3 | 2.93e-12 | NR | WP_337961599.1 | 328692 | g41873 | i0 | 72.3 | 6.15 | 47 | 13 | 88.1 | 0 | 1 | 141 | 72 | 118 | WP_337961599.1 shikimate dehydrogenase [Deinococcus aquaticus] | diamond | 984 | 69.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquaticus |
Advanced export
JSON shape: default, array, newline-delimited
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);;