contig_metadata
15 rows where bioproject = "PRJNA792582", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9705226 | 9705226 | PRJNA792582_P_NODE_35308_length_290_cov_1.419355_g34494_i0 | PRJNA792582 | 35308 | 290 | 1.419355 | 4.1161295 | uncultured Thermomicrobiales bacterium | 1645740 | Bacteria | Bacteria | 154 | 3.29e-44 | NR | CAA9551317.1 | 1645740 | g34494 | i0 | 81.3 | 0.993103448275862 | 96 | 18 | 99.3 | 0 | 3 | 290 | 12 | 107 | CAA9551317.1 MAG: Heme ABC transporter, ATPase component HmuV [uncultured Thermomicrobiales bacterium] | diamond | 288 | 154 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | uncultured Thermomicrobiales bacterium | ||||
| 12256775 | 12256775 | PRJNA792582_P_NODE_58270_length_242_cov_0.911243_g57456_i0 | PRJNA792582 | 58270 | 242 | 0.911243 | 2.20520806 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 125 | 3.51e-33 | NR | HEU5329995.1 | 2482790 | g57456 | i0 | 91.1 | 1.94628099173554 | 79 | 7 | 97.9 | 0 | 238 | 2 | 56 | 134 | HEU5329995.1 bifunctional hydroxymethylpyrimidine kinase/phosphomethylpyrimidine kinase [Thermomicrobiales bacterium] | diamond | 471 | 125 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 22454057 | 22454057 | PRJNA792582_P_NODE_16598_length_423_cov_2.494286_g15784_i0 | PRJNA792582 | 16598 | 423 | 2.494286 | 10.55082978 | uncultured Thermomicrobia bacterium | 384764 | Bacteria | Bacteria | 431 | 4.48e-116 | NTclustered | gi|389546717|gb|JQ401645.1| | 384764 | g15784 | i0 | 91.883 | 68.4231678486998 | 308 | 25 | 73 | 0 | 116 | 423 | 2 | 309 | Uncultured Thermomicrobia bacterium clone CNY_01808 16S ribosomal RNA gene, partial sequence | blastn | 28943 | 431 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | uncultured Thermomicrobia bacterium | |||||
| 25003490 | 25003490 | PRJNA792582_P_NODE_42500_length_271_cov_1.525253_g41686_i0 | PRJNA792582 | 42500 | 271 | 1.525253 | 4.13343563 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 112 | 1.44e-29 | NR | HET8632170.1 | 2482790 | g41686 | i0 | 74.1 | 0.940959409594096 | 85 | 22 | 94.1 | 0 | 255 | 1 | 7 | 91 | HET8632170.1 hypothetical protein [Thermomicrobiales bacterium] | diamond | 255 | 112 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 27654194 | 27654194 | PRJNA792582_P_NODE_49184_length_252_cov_1.513966_g48370_i0 | PRJNA792582 | 49184 | 252 | 1.513966 | 3.81519432 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 47 | 0.0013 | NR | HEY8598550.1 | 2482790 | g48370 | i0 | 100 | 0.25 | 21 | 0 | 25 | 0 | 63 | 1 | 1 | 21 | HEY8598550.1 3-phosphoserine/phosphohydroxythreonine transaminase [Thermomicrobiales bacterium] | diamond | 63 | 47 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 27969733 | 27969733 | PRJNA792582_P_NODE_38765_length_281_cov_1.365385_g37951_i0 | PRJNA792582 | 38765 | 281 | 1.365385 | 3.83673185 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 70.5 | 9.19e-12 | NR | MCO5215899.1 | 2482790 | g37951 | i0 | 47.8 | 0.96085409252669 | 90 | 44 | 92.9 | 2 | 1 | 261 | 290 | 379 | MCO5215899.1 site-specific DNA-methyltransferase [Thermomicrobiales bacterium] | diamond | 270 | 70.5 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 28064460 | 28064460 | PRJNA792582_P_NODE_45945_length_261_cov_2.308511_g45131_i0 | PRJNA792582 | 45945 | 261 | 2.308511 | 6.02521371 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 48.5 | 3.29e-4 | NR | HEY8602110.1 | 2482790 | g45131 | i0 | 52.1 | 0.551724137931034 | 48 | 23 | 55.2 | 0 | 109 | 252 | 11 | 58 | HEY8602110.1 SMI1/KNR4 family protein [Thermomicrobiales bacterium] | diamond | 144 | 48.5 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 29642857 | 29642857 | PRJNA792582_P_NODE_52970_length_248_cov_0.880000_g52156_i0 | PRJNA792582 | 52970 | 248 | 0.88 | 2.1824 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 43.1 | 0.0285 | NR | MCD6032462.1 | 2482790 | g52156 | i0 | 35.6 | 0.544354838709677 | 45 | 29 | 54.4 | 0 | 161 | 27 | 437 | 481 | MCD6032462.1 Dolichyl-phosphate-mannose-protein mannosyltransferase [Thermomicrobiales bacterium] | diamond | 135 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 30148349 | 30148349 | PRJNA792582_P_NODE_35932_length_288_cov_2.069767_g35118_i0 | PRJNA792582 | 35932 | 288 | 2.069767 | 5.96092896 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 127 | 7.34e-33 | NR | HMM41945.1 | 2482790 | g35118 | i0 | 68.4 | 0.989583333333333 | 95 | 30 | 99 | 0 | 287 | 3 | 102 | 196 | HMM41945.1 potassium channel family protein [Thermomicrobiales bacterium] | diamond | 285 | 127 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 30685544 | 30685544 | PRJNA792582_P_NODE_52233_length_248_cov_2.548571_g51419_i0 | PRJNA792582 | 52233 | 248 | 2.548571 | 6.32045608 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 121 | 1.15e-31 | NR | HEY8599151.1 | 2482790 | g51419 | i0 | 74.4 | 0.991935483870968 | 82 | 21 | 99.2 | 0 | 246 | 1 | 21 | 102 | HEY8599151.1 MOSC N-terminal beta barrel domain-containing protein [Thermomicrobiales bacterium] | diamond | 246 | 121 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 31127637 | 31127637 | PRJNA792582_P_NODE_36815_length_286_cov_1.446009_g36001_i0 | PRJNA792582 | 36815 | 286 | 1.446009 | 4.13558574 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 86.3 | 1.57e-17 | NR | MCA9878165.1 | 2482790 | g36001 | i0 | 80.9 | 3 | 47 | 9 | 49.3 | 0 | 281 | 141 | 316 | 362 | MCA9878165.1 hypothetical protein [Thermomicrobiales bacterium] | diamond | 858 | 86.3 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 31222606 | 31222606 | PRJNA792582_P_NODE_35595_length_289_cov_1.907407_g34781_i0 | PRJNA792582 | 35595 | 289 | 1.907407 | 5.51240623 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 153 | 4.7099999999999996e-42 | NR | HEY8600229.1 | 2482790 | g34781 | i0 | 76.8 | 0.986159169550173 | 95 | 22 | 98.6 | 0 | 3 | 287 | 283 | 377 | HEY8600229.1 esterase-like activity of phytase family protein [Thermomicrobiales bacterium] | diamond | 285 | 153 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 31570931 | 31570931 | PRJNA792582_P_NODE_34356_length_293_cov_3.209091_g33542_i0 | PRJNA792582 | 34356 | 293 | 3.209091 | 9.40263663 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 148 | 4.89e-42 | NR | HEY8598654.1 | 2482790 | g33542 | i0 | 65.5 | 1.12627986348123 | 110 | 21 | 95.2 | 1 | 282 | 4 | 1 | 110 | HEY8598654.1 transglutaminase family protein [Thermomicrobiales bacterium] | diamond | 330 | 148 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 32013646 | 32013646 | PRJNA792582_P_NODE_57118_length_243_cov_1.811765_g56304_i0 | PRJNA792582 | 57118 | 243 | 1.811765 | 4.40258895 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 149 | 2.04e-40 | NR | HEY8598890.1 | 2482790 | g56304 | i0 | 83.8 | 0.987654320987654 | 80 | 13 | 98.8 | 0 | 241 | 2 | 312 | 391 | HEY8598890.1 M14 family metallopeptidase [Thermomicrobiales bacterium] | diamond | 240 | 149 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 32172044 | 32172044 | PRJNA792582_P_NODE_55238_length_245_cov_1.755814_g54424_i0 | PRJNA792582 | 55238 | 245 | 1.755814 | 4.3017443 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 123 | 3.0999999999999996e-32 | NR | HET8626673.1 | 2482790 | g54424 | i0 | 75.3 | 0.991836734693878 | 81 | 20 | 99.2 | 0 | 245 | 3 | 121 | 201 | HET8626673.1 geranylgeranyl reductase family protein [Thermomicrobiales bacterium] | diamond | 243 | 123 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales 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);;