contig_metadata
18 rows where bioproject = "PRJNA630162" and tax_phylum = "Rhodothermota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601895 | 601895 | PRJNA630162_P_NODE_164281_length_160_cov_2.099099_g162758_i0 | PRJNA630162 | 164281 | 160 | 2.099099 | 3.3585584 | Rubrivirga sp. IMCC45206 | 3391614 | Bacteria | Bacteria | 215 | 1.6e-51 | NTclustered | gi|2890849321|gb|CP177357.1| | 3391614 | g162758 | i0 | 92.667 | 387.225 | 150 | 9 | 93 | 2 | 1 | 149 | 3831355 | 3831207 | Rubrivirga sp. IMCC45206 chromosome, complete genome | blastn | 61956 | 215 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC45206 | |
| 1151303 | 1151303 | PRJNA630162_P_NODE_165921_length_158_cov_2.651376_g164398_i0 | PRJNA630162 | 165921 | 158 | 2.651376 | 4.18917408 | Rubrivirga | 1434037 | Bacteria | Bacteria | 259 | 7.17e-65 | NTclustered | gi|2890853429|gb|CP177355.1| | 3391575 | g164398 | i0 | 97.368 | 210.537974683544 | 152 | 4 | 96 | 0 | 6 | 157 | 807320 | 807471 | Rubrivirga sp. IMCC43871 chromosome, complete genome | blastn | 33265 | 259 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC43871 | |
| 1151596 | 1151596 | PRJNA630162_P_NODE_72081_length_211_cov_3.641975_g70558_i0 | PRJNA630162 | 72081 | 211 | 3.641975 | 7.68456725 | Rhodothermales | 1853224 | Bacteria | Bacteria | 224 | 3.709999999999999e-54 | NTclustered | gi|1167574847|gb|CP020382.1| | 1779382 | g70558 | i0 | 88.77 | 200.995260663507 | 187 | 16 | 87 | 4 | 29 | 211 | 2906509 | 2906324 | Rhodothermaceae bacterium RA chromosome, complete genome | blastn | 42410 | 224 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermaceae bacterium RA | ||
| 1878602 | 1878602 | PRJNA630162_P_NODE_56562_length_234_cov_3.513514_g55039_i0 | PRJNA630162 | 56562 | 234 | 3.513514 | 8.22162276 | Rubrivirga sp. IMCC43871 | 3391575 | Bacteria | Bacteria | 313 | 8.71e-81 | NTclustered | gi|2890853429|gb|CP177355.1| | 3391575 | g55039 | i0 | 91.342 | 406.478632478633 | 231 | 16 | 98 | 4 | 1 | 229 | 806697 | 806469 | Rubrivirga sp. IMCC43871 chromosome, complete genome | blastn | 95116 | 313 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC43871 | |
| 3152848 | 3152848 | PRJNA630162_P_NODE_165243_length_159_cov_2.209091_g163720_i0 | PRJNA630162 | 165243 | 159 | 2.209091 | 3.51245469 | Rubrivirga sp. IMCC43871 | 3391575 | Bacteria | Bacteria | 202 | 1.2399999999999998e-47 | NTclustered | gi|2890853429|gb|CP177355.1| | 3391575 | g163720 | i0 | 93.478 | 153.037735849057 | 138 | 5 | 86 | 4 | 4 | 139 | 805648 | 805513 | Rubrivirga sp. IMCC43871 chromosome, complete genome | blastn | 24333 | 202 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC43871 | |
| 8804290 | 8804290 | PRJNA630162_P_NODE_22587_length_386_cov_3.089021_g21069_i0 | PRJNA630162 | 22587 | 386 | 3.089021 | 11.92362106 | Rhodothermus | 29548 | Bacteria | Bacteria | 322 | 2.54e-83 | NTclustered | gi|2844596544|gb|CP172416.1| | 29549 | g21069 | i0 | 84.058 | 189.455958549223 | 345 | 44 | 87 | 9 | 28 | 364 | 3095609 | 3095268 | Rhodothermus marinus strain ISCAR-493 chromosome | blastn | 73130 | 322 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermus | Rhodothermus marinus | |
| 9529978 | 9529978 | PRJNA630162_P_NODE_120348_length_174_cov_1.840000_g118825_i0 | PRJNA630162 | 120348 | 174 | 1.84 | 3.2016 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 52.8 | 0.015 | NTclustered | gi|2893358427|emb|OZ220719.1| | 2306054 | g118825 | i0 | 100 | 0.160919540229885 | 28 | 0 | 16 | 0 | 121 | 148 | 39773 | 39746 | MAG: Rhodothermales bacterium isolate dfa80fe1-3418-4a7a-9107-99a60459722b genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 10806016 | 10806016 | PRJNA630162_P_NODE_155389_length_163_cov_1.429825_g153866_i0 | PRJNA630162 | 155389 | 163 | 1.429825 | 2.33061475 | Rubricoccaceae bacterium | 2838334 | Bacteria | Bacteria | 265 | 1.6e-66 | NTclustered | gi|2874254104|emb|OY970187.1| | 2838334 | g153866 | i0 | 96.855 | 218.147239263804 | 159 | 4 | 97 | 1 | 1 | 158 | 1308512 | 1308670 | MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1 | blastn | 35558 | 265 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubricoccaceae bacterium | ||
| 11354527 | 11354527 | PRJNA630162_P_NODE_118989_length_175_cov_1.388889_g117466_i0 | PRJNA630162 | 118989 | 175 | 1.388889 | 2.43055575 | Rhodothermales | 1853224 | Bacteria | Bacteria | 178 | 2.3299999999999993e-40 | NTclustered | gi|1167574847|gb|CP020382.1| | 1779382 | g117466 | i0 | 86.585 | 169.634285714286 | 164 | 18 | 92 | 3 | 8 | 168 | 2906827 | 2906665 | Rhodothermaceae bacterium RA chromosome, complete genome | blastn | 29686 | 178 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermaceae bacterium RA | ||
| 16454134 | 16454134 | PRJNA630162_P_NODE_26213_length_356_cov_4.013029_g24692_i0 | PRJNA630162 | 26213 | 356 | 4.013029 | 14.28638324 | Rubrivirga | 1434037 | Bacteria | Bacteria | 436 | 7.96e-118 | NTclustered | gi|2874254104|emb|OY970187.1| | 2838334 | g24692 | i0 | 89.205 | 144.491573033708 | 352 | 34 | 98 | 4 | 7 | 356 | 1307907 | 1307558 | MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1 | blastn | 51439 | 436 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubricoccaceae bacterium | ||
| 18454396 | 18454396 | PRJNA630162_P_NODE_48595_length_253_cov_1.872549_g47072_i0 | PRJNA630162 | 48595 | 253 | 1.872549 | 4.73754897 | Rubricoccaceae bacterium | 2838334 | Bacteria | Bacteria | 279 | 9.67e-71 | NTclustered | gi|2874254104|emb|OY970187.1| | 2838334 | g47072 | i0 | 87.603 | 485.162055335968 | 242 | 29 | 96 | 1 | 12 | 253 | 1309431 | 1309191 | MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1 | blastn | 122746 | 279 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubricoccaceae bacterium | ||
| 21553353 | 21553353 | PRJNA630162_P_NODE_34357_length_306_cov_1.322957_g32834_i0 | PRJNA630162 | 34357 | 306 | 1.322957 | 4.04824842 | Rubrivirga | 1434037 | Bacteria | Bacteria | 398 | 3.1799999999999993e-106 | NTclustered | gi|2874254104|emb|OY970187.1| | 2838334 | g32834 | i0 | 90.492 | 248.437908496732 | 305 | 23 | 98 | 3 | 4 | 303 | 1308315 | 1308012 | MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1 | blastn | 76022 | 398 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubricoccaceae bacterium | ||
| 21553468 | 21553468 | PRJNA630162_P_NODE_59057_length_229_cov_4.244444_g57534_i0 | PRJNA630162 | 59057 | 229 | 4.244444 | 9.71977676 | Rubrivirga | 1434037 | Bacteria | Bacteria | 278 | 3.1e-70 | NTclustered | gi|2890853429|gb|CP177355.1| | 3391575 | g57534 | i0 | 88.889 | 399.218340611354 | 225 | 25 | 98 | 0 | 1 | 225 | 808182 | 807958 | Rubrivirga sp. IMCC43871 chromosome, complete genome | blastn | 91421 | 278 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC43871 | |
| 23553927 | 23553927 | PRJNA630162_P_NODE_104419_length_183_cov_1.402985_g102896_i0 | PRJNA630162 | 104419 | 183 | 1.402985 | 2.56746255 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 143 | 8.989999999999998e-30 | NTclustered | gi|2893358387|emb|OZ220707.1| | 2306054 | g102896 | i0 | 88.333 | 143.72131147541 | 120 | 12 | 65 | 2 | 29 | 147 | 1911702 | 1911820 | MAG: Rhodothermales bacterium isolate 73463979-71cf-475a-bf3e-fc0c682d52d1 genome assembly, chromosome: 1 | blastn | 26301 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 27270387 | 27270387 | PRJNA630162_P_NODE_65303_length_219_cov_1.182353_g63780_i0 | PRJNA630162 | 65303 | 219 | 1.182353 | 2.58935307 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 85.9 | 1.47e-17 | NR | NNE46316.1 | 2306054 | g63780 | i0 | 79.5 | 0.602739726027397 | 44 | 9 | 60.3 | 0 | 218 | 87 | 351 | 394 | NNE46316.1 hypothetical protein [Rhodothermales bacterium] | diamond | 132 | 85.9 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 27460086 | 27460086 | PRJNA630162_P_NODE_161823_length_162_cov_0.920354_g160300_i0 | PRJNA630162 | 161823 | 162 | 0.920354 | 1.49097348 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 48.9 | 8.16e-5 | NR | HYE59421.1 | 2306054 | g160300 | i0 | 51.9 | 0.962962962962963 | 52 | 25 | 96.3 | 0 | 6 | 161 | 753 | 804 | HYE59421.1 hypothetical protein [Rhodothermales bacterium] | diamond | 156 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 28817223 | 28817223 | PRJNA630162_P_NODE_103488_length_183_cov_2.873134_g101965_i0 | PRJNA630162 | 103488 | 183 | 2.873134 | 5.25783522 | Rhodothermaceae bacterium | 2026787 | Bacteria | Bacteria | 71.6 | 1.11e-12 | NR | MAQ95730.1 | 2026787 | g101965 | i0 | 57.9 | 0.934426229508197 | 57 | 24 | 93.4 | 0 | 1 | 171 | 425 | 481 | MAQ95730.1 hypothetical protein [Rhodothermaceae bacterium] | diamond | 171 | 71.6 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermaceae bacterium | ||
| 31882283 | 31882283 | PRJNA630162_P_NODE_169417_length_155_cov_2.283019_g167894_i0 | PRJNA630162 | 169417 | 155 | 2.283019 | 3.53867945 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 75.1 | 4.33e-14 | NR | HLA64784.1 | 2306054 | g167894 | i0 | 66 | 3.87096774193548 | 50 | 17 | 96.8 | 0 | 4 | 153 | 109 | 158 | HLA64784.1 PAS domain S-box protein [Rhodothermales bacterium] | diamond | 600 | 75.1 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium |
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);;