contig_metadata
19 rows where bioproject = "PRJEB11748" and tax_phylum = "Thermotogota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2567397 | 2567397 | PRJEB11748_P_NODE_284083_length_227_cov_6.897590_g281900_i0 | PRJEB11748 | 284083 | 227 | 6.89759 | 15.6575293 | Fervidobacterium gondwanense | 44754 | Bacteria | Bacteria | 344 | 2.98e-90 | NTclustered | gi|2793121053|gb|CP126498.1| | 44754 | g281900 | i0 | 96.635 | 77.8854625550661 | 208 | 5 | 91 | 2 | 3 | 208 | 973823 | 974030 | Fervidobacterium gondwanense strain 13770 chromosome, complete genome | blastn | 17680 | 344 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium gondwanense | ||
| 2567445 | 2567445 | PRJEB11748_P_NODE_286423_length_226_cov_3.242424_g284240_i0 | PRJEB11748 | 286423 | 226 | 3.242424 | 7.32787824 | Tepiditoga spiralis | 2108365 | Bacteria | Bacteria | 95.3 | 3.3e-15 | NTclustered | gi|1898704378|dbj|AP018712.1| | 2108365 | g284240 | i0 | 81.739 | 1.52654867256637 | 115 | 20 | 50 | 1 | 19 | 132 | 860901 | 861015 | Tepiditoga spiralis sy52 DNA, complete genome | blastn | 345 | 95.3 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Tepiditoga | Tepiditoga spiralis | ||
| 4813027 | 4813027 | PRJEB11748_P_NODE_63804_length_530_cov_13.991471_g61664_i0 | PRJEB11748 | 63804 | 530 | 13.991471 | 74.1547963 | Fervidobacterium | 2422 | Bacteria | Bacteria | 924 | 0 | NTclustered | gi|2793121053|gb|CP126498.1| | 44754 | g61664 | i0 | 99.411 | 12.4716981132075 | 509 | 3 | 96 | 0 | 17 | 525 | 340202 | 340710 | Fervidobacterium gondwanense strain 13770 chromosome, complete genome | blastn | 6610 | 924 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium gondwanense | ||
| 8944231 | 8944231 | PRJEB11748_P_NODE_274628_length_232_cov_6.777778_g272445_i0 | PRJEB11748 | 274628 | 232 | 6.777778 | 15.72444496 | Fervidobacterium ngatamarikiense | 3389972 | Bacteria | Bacteria | 174 | 4.24e-39 | NTclustered | gi|1028457653|gb|CP011393.1| | 3389972 | g272445 | i0 | 80.508 | 35.6336206896552 | 236 | 39 | 99 | 6 | 2 | 232 | 199712 | 199479 | Fervidobacterium pennivorans strain DYC, complete genome | blastn | 8267 | 174 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium ngatamarikiense | ||
| 14044956 | 14044956 | PRJEB11748_P_NODE_252772_length_245_cov_2.793478_g250589_i0 | PRJEB11748 | 252772 | 245 | 2.793478 | 6.8440211 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 104 | 6.87e-26 | NR | MDM7321178.1 | 1871331 | g250589 | i0 | 85.2 | 0.661224489795918 | 54 | 8 | 66.1 | 0 | 54 | 215 | 154 | 207 | MDM7321178.1 hypothetical protein [Fervidobacterium sp.] | diamond | 162 | 104 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 17562497 | 17562497 | PRJEB11748_P_NODE_364214_length_190_cov_7.992248_g362031_i0 | PRJEB11748 | 364214 | 190 | 7.992248 | 15.1852712 | Thermotoga | 2335 | Bacteria | Bacteria | 137 | 4.38e-28 | NTclustered | gi|811641277|gb|CP011108.1| | 2336 | g362031 | i0 | 81.564 | 63.8368421052632 | 179 | 22 | 89 | 9 | 1 | 169 | 190967 | 190790 | Thermotoga maritima strain Tma100, complete genome | blastn | 12129 | 137 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | Thermotoga maritima | ||
| 24241132 | 24241132 | PRJEB11748_P_NODE_166980_length_315_cov_8.059055_g164797_i0 | PRJEB11748 | 166980 | 315 | 8.059055 | 25.38602325 | Fervidobacterium gondwanense | 44754 | Bacteria | Bacteria | 553 | 6.629999999999998e-153 | NTclustered | gi|2793121053|gb|CP126498.1| | 44754 | g164797 | i0 | 100 | 1.8984126984127 | 299 | 0 | 95 | 0 | 17 | 315 | 1625600 | 1625898 | Fervidobacterium gondwanense strain 13770 chromosome, complete genome | blastn | 598 | 553 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium gondwanense | ||
| 26779776 | 26779776 | PRJEB11748_P_NODE_304161_length_217_cov_9.025641_g301978_i0 | PRJEB11748 | 304161 | 217 | 9.025641 | 19.58564097 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 59.7 | 2.66e-8 | NR | HUM41557.1 | 1871331 | g301978 | i0 | 36.8 | 0.940092165898618 | 68 | 39 | 88.5 | 1 | 195 | 4 | 95 | 162 | HUM41557.1 hypothetical protein [Fervidobacterium sp.] | diamond | 204 | 59.7 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 26900171 | 26900171 | PRJEB11748_P_NODE_259021_length_241_cov_5.511111_g256838_i0 | PRJEB11748 | 259021 | 241 | 5.511111 | 13.28177751 | Bacteria | 2 | Bacteria | Bacteria | 64.3 | 9.17e-10 | NR | HOJ89182.1 | 2033661 | g256838 | i0 | 63.6 | 3.47302904564315 | 44 | 16 | 54.8 | 0 | 154 | 23 | 72 | 115 | HOJ89182.1 ATP-binding protein [Pseudothermotoga sp.] | diamond | 837 | 64.3 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Pseudothermotoga | Pseudothermotoga sp. | ||
| 28106717 | 28106717 | PRJEB11748_P_NODE_35285_length_739_cov_26.361357_g33355_i0 | PRJEB11748 | 35285 | 739 | 26.361357 | 194.81042823 | Thermotogota bacterium | 2053689 | Bacteria | Bacteria | 78.6 | 4.44e-13 | NR | HPM21465.1 | 2053689 | g33355 | i0 | 35.6 | 0.81190798376184 | 101 | 62 | 41 | 2 | 516 | 214 | 1 | 98 | HPM21465.1 hypothetical protein [Thermotogota bacterium] | diamond | 600 | 78.6 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogota bacterium | ||||||
| 28169783 | 28169783 | PRJEB11748_P_NODE_103866_length_409_cov_11.281609_g101694_i0 | PRJEB11748 | 103866 | 409 | 11.281609 | 46.14178081 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 96.7 | 3.42e-20 | NR | HUM44121.1 | 1871331 | g101694 | i0 | 61.4 | 0.60880195599022 | 83 | 31 | 60.1 | 1 | 142 | 387 | 136 | 218 | HUM44121.1 N-6 DNA methylase [Fervidobacterium sp.] | diamond | 249 | 96.7 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 28517399 | 28517399 | PRJEB11748_P_NODE_44327_length_649_cov_10.685374_g42252_i0 | PRJEB11748 | 44327 | 649 | 10.685374 | 69.34807726 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 154 | 2.8199999999999992e-43 | NR | MDM7321176.1 | 1871331 | g42252 | i0 | 86 | 0.397534668721109 | 86 | 12 | 39.8 | 0 | 6 | 263 | 42 | 127 | MDM7321176.1 hypothetical protein [Fervidobacterium sp.] | diamond | 258 | 154 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 28643646 | 28643646 | PRJEB11748_P_NODE_202727_length_281_cov_7.027273_g200544_i0 | PRJEB11748 | 202727 | 281 | 7.027273 | 19.74663713 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 83.6 | 1.45e-17 | NR | HUM43789.1 | 1871331 | g200544 | i0 | 54.5 | 0.939501779359431 | 88 | 34 | 92.9 | 3 | 269 | 9 | 32 | 114 | HUM43789.1 DUF6011 domain-containing protein [Fervidobacterium sp.] | diamond | 264 | 83.6 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 28801297 | 28801297 | PRJEB11748_P_NODE_374808_length_183_cov_13.090164_g372625_i0 | PRJEB11748 | 374808 | 183 | 13.090164 | 23.95500012 | Thermosipho africanus | 2421 | Bacteria | Bacteria | 74.3 | 8.53e-14 | NR | WP_004101232.1 | 2421 | g372625 | i0 | 69.6 | 2.32786885245902 | 46 | 14 | 75.4 | 0 | 46 | 183 | 113 | 158 | WP_004101232.1 pyridoxal-phosphate-dependent aminotransferase family protein [Thermosipho africanus] | diamond | 426 | 74.3 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Thermosipho | Thermosipho africanus | ||
| 30248058 | 30248058 | PRJEB11748_P_NODE_244492_length_250_cov_6.089947_g242309_i0 | PRJEB11748 | 244492 | 250 | 6.0899470000000004 | 15.2248675 | Bacteria | 2 | Bacteria | Bacteria | 57.4 | 2.69e-7 | NR | HUM44606.1 | 1871331 | g242309 | i0 | 83.9 | 1.86 | 31 | 5 | 37.2 | 0 | 135 | 227 | 468 | 498 | HUM44606.1 DEAD/DEAH box helicase [Fervidobacterium sp.] | diamond | 465 | 57.8 | 0.993079584775087 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 30917703 | 30917703 | PRJEB11748_P_NODE_232874_length_258_cov_3.350254_g230691_i0 | PRJEB11748 | 232874 | 258 | 3.350254 | 8.64365532 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 93.6 | 1.66e-20 | NR | HQE49614.1 | 1871331 | g230691 | i0 | 66.7 | 0.767441860465116 | 66 | 20 | 74.4 | 1 | 213 | 22 | 3 | 68 | HQE49614.1 Mu-like prophage major head subunit gpT family protein [Fervidobacterium sp.] | diamond | 198 | 93.6 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 31670057 | 31670057 | PRJEB11748_P_NODE_167657_length_314_cov_19.134387_g165474_i0 | PRJEB11748 | 167657 | 314 | 19.134387 | 60.08197518 | Defluviitoga | 1511648 | Bacteria | Bacteria | 135 | 4.5e-36 | NR | MDY0379706.1 | 1006576 | g165474 | i0 | 70.8 | 5.09235668789809 | 89 | 26 | 85 | 0 | 25 | 291 | 124 | 212 | MDY0379706.1 tryptophanase [Defluviitoga tunisiensis] | diamond | 1599 | 135 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 32087689 | 32087689 | PRJEB11748_P_NODE_365898_length_189_cov_12.617188_g363715_i0 | PRJEB11748 | 365898 | 189 | 12.617188 | 23.84648532 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 81.3 | 1.16e-16 | NR | MDM7321175.1 | 1871331 | g363715 | i0 | 87 | 0.73015873015873 | 46 | 6 | 73 | 0 | 170 | 33 | 112 | 157 | MDM7321175.1 hypothetical protein [Fervidobacterium sp.] | diamond | 138 | 81.3 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 32845615 | 32845615 | PRJEB11748_P_NODE_281120_length_229_cov_1.857143_g278937_i0 | PRJEB11748 | 281120 | 229 | 1.857143 | 4.25285747 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 58.5 | 8.02e-8 | NR | HPC25222.1 | 1871331 | g278937 | i0 | 45.9 | 3.14410480349345 | 61 | 33 | 79.9 | 0 | 206 | 24 | 421 | 481 | HPC25222.1 DEAD/DEAH box helicase [Fervidobacterium sp.] | diamond | 720 | 58.5 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. |
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);;