contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA977246" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3820825 | 3820825 | PRJNA977246_S_NODE_24463_length_266_cov_8045.362869_g23471_i0 | PRJNA977246 | 24463 | 266 | 8045.362869 | 21400.66523154 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 107 | 8.85e-25 | NR | MEM3368600.1 | 2056631 | g23471 | i0 | 96.4 | 0.620300751879699 | 55 | 2 | 62 | 0 | 215 | 51 | 279 | 333 | MEM3368600.1 toprim domain-containing protein [Thermoproteota archaeon] | diamond | 165 | 107 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 7646740 | 7646740 | PRJNA977246_S_NODE_13126_length_411_cov_4986.201571_g12147_i0 | PRJNA977246 | 13126 | 411 | 4986.201571 | 20493.28845681 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 201 | 2.94e-62 | NR | MEM3368592.1 | 2056631 | g12147 | i0 | 80.5 | 0.861313868613139 | 118 | 23 | 86.1 | 0 | 56 | 409 | 13 | 130 | MEM3368592.1 hypothetical protein [Thermoproteota archaeon] | diamond | 354 | 201 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 15296743 | 15296743 | PRJNA977246_S_NODE_22672_length_282_cov_7536.019763_g21680_i0 | PRJNA977246 | 22672 | 282 | 7536.019763 | 21251.57573166 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 113 | 1.2399999999999998e-29 | NR | MDT7864916.1 | 2056631 | g21680 | i0 | 90.3 | 0.659574468085106 | 62 | 6 | 66 | 0 | 237 | 52 | 1 | 62 | MDT7864916.1 dUTP diphosphatase [Thermoproteota archaeon] | diamond | 186 | 113 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 15297033 | 15297033 | PRJNA977246_S_NODE_7552_length_571_cov_3828.418819_g6738_i0 | PRJNA977246 | 7552 | 571 | 3828.418819 | 21860.27145649 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 136 | 3.9899999999999996e-38 | NR | MEM3368791.1 | 2056631 | g6738 | i0 | 84.8 | 0.415061295971979 | 79 | 12 | 41.5 | 0 | 205 | 441 | 1 | 79 | MEM3368791.1 hypothetical protein [Thermoproteota archaeon] | diamond | 237 | 136 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 16571255 | 16571255 | PRJNA977246_S_NODE_17893_length_334_cov_9.488525_g16901_i0 | PRJNA977246 | 17893 | 334 | 9.488525 | 31.6916735 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 117 | 2.7899999999999996e-31 | NR | MDT7864681.1 | 2056631 | g16901 | i0 | 89.1 | 0.574850299401198 | 64 | 7 | 57.5 | 0 | 13 | 204 | 1 | 64 | MDT7864681.1 hypothetical protein [Thermoproteota archaeon] | diamond | 192 | 117 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 25495408 | 25495408 | PRJNA977246_S_NODE_33400_length_208_cov_10575.944134_g32408_i0 | PRJNA977246 | 33400 | 208 | 10575.944134 | 21997.96379872 | Pyrobaculum arsenaticum | 121277 | Archaea | Archaea | 90.1 | 1.05e-21 | NR | WP_345803932.1 | 121277 | g32408 | i0 | 91.4 | 0.836538461538462 | 58 | 5 | 83.7 | 0 | 206 | 33 | 8 | 65 | WP_345803932.1 pH regulation protein F [Pyrobaculum arsenaticum] | diamond | 174 | 90.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 27120661 | 27120661 | PRJNA977246_S_NODE_44222_length_168_cov_3.093525_g43230_i0 | PRJNA977246 | 44222 | 168 | 3.093525 | 5.197122 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 106 | 5.61e-25 | NR | WP_100181730.1 | 1846278 | g43230 | i0 | 83.6 | 4.91071428571429 | 55 | 9 | 98.2 | 0 | 3 | 167 | 6 | 60 | WP_100181730.1 hypothetical protein [Candidatus Nitrosotenuis aquarius] | diamond | 825 | 106 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 27752899 | 27752899 | PRJNA977246_S_NODE_13944_length_396_cov_3.307902_g12960_i0 | PRJNA977246 | 13944 | 396 | 3.307902 | 13.09929192 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 222 | 1.19e-65 | NR | WP_148550728.1 | 1603555 | g12960 | i0 | 87.7 | 1.96969696969697 | 130 | 15 | 97.7 | 1 | 396 | 10 | 94 | 223 | WP_148550728.1 PEFG-CTERM sorting domain-containing protein [Candidatus Nitrosotenuis cloacae] | diamond | 780 | 222 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 27910315 | 27910315 | PRJNA977246_S_NODE_44265_length_168_cov_2.719424_g43273_i0 | PRJNA977246 | 44265 | 168 | 2.719424 | 4.56863232 | Pyrobaculum arsenaticum | 121277 | Archaea | Archaea | 100 | 6.27e-23 | NR | WP_345803937.1 | 121277 | g43273 | i0 | 100 | 5.35714285714286 | 50 | 0 | 89.3 | 0 | 2 | 151 | 92 | 141 | WP_345803937.1 proton-conducting transporter membrane subunit [Pyrobaculum arsenaticum] | diamond | 900 | 100 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 27916575 | 27916575 | PRJNA977246_S_NODE_25065_length_261_cov_7.745690_g24073_i0 | PRJNA977246 | 25065 | 261 | 7.74569 | 20.2162509 | root | 1 | Root_unresolved | Root_unresolved | 94.7 | 2.29e-20 | NR | RLF07872.1 | 2250277 | g24073 | i0 | 68.9 | 3.37931034482759 | 74 | 20 | 83.9 | 2 | 23 | 241 | 453 | 524 | RLF07872.1 MAG: hypothetical protein DRJ64_02130 [Thermoprotei archaeon] | diamond | 882 | 94.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei archaeon | |||||
| 28920801 | 28920801 | PRJNA977246_S_NODE_39428_length_183_cov_7.175325_g38436_i0 | PRJNA977246 | 39428 | 183 | 7.175325 | 13.13084475 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 106 | 3.4e-26 | NR | MDT7864917.1 | 2056631 | g38436 | i0 | 94.4 | 0.885245901639344 | 54 | 3 | 88.5 | 0 | 20 | 181 | 217 | 270 | MDT7864917.1 DNA polymerase ligase N-terminal domain-containing protein [Thermoproteota archaeon] | diamond | 162 | 106 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29741604 | 29741604 | PRJNA977246_S_NODE_26410_length_251_cov_2.995495_g25418_i0 | PRJNA977246 | 26410 | 251 | 2.995495 | 7.51869245 | Pyrobaculum arsenaticum | 121277 | Archaea | Archaea | 102 | 1.31e-25 | NR | WP_345803931.1 | 121277 | g25418 | i0 | 94.5 | 0.657370517928287 | 55 | 3 | 65.7 | 0 | 5 | 169 | 76 | 130 | WP_345803931.1 Na+/H+ antiporter subunit E [Pyrobaculum arsenaticum] | diamond | 165 | 102 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 29994727 | 29994727 | PRJNA977246_S_NODE_44291_length_168_cov_2.496403_g43299_i0 | PRJNA977246 | 44291 | 168 | 2.496403 | 4.19395704 | Candidatus Brockarchaeota archaeon | 2815303 | Archaea | Archaea | 107 | 1.08e-27 | NR | MBO3757532.1 | 2815303 | g43299 | i0 | 94.5 | 0.982142857142857 | 55 | 3 | 98.2 | 0 | 2 | 166 | 139 | 193 | MBO3757532.1 hypothetical protein [Candidatus Brockarchaeota archaeon] | diamond | 165 | 107 | 1 | Archaea | Thermoproteati | Candidatus Brockarchaeota | Candidatus Brockarchaeota archaeon | ||||||
| 30026285 | 30026285 | PRJNA977246_S_NODE_39631_length_183_cov_2.103896_g38639_i0 | PRJNA977246 | 39631 | 183 | 2.103896 | 3.85012968 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 125 | 1.24e-32 | NR | MDW0282465.1 | 2169593 | g38639 | i0 | 98.4 | 1 | 61 | 1 | 100 | 0 | 183 | 1 | 114 | 174 | MDW0282465.1 phosphoglycerate kinase [Nitrososphaeraceae archaeon] | diamond | 183 | 125 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 30184090 | 30184090 | PRJNA977246_S_NODE_48392_length_157_cov_7.281250_g47400_i0 | PRJNA977246 | 48392 | 157 | 7.28125 | 11.4315625 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 107 | 1.28e-27 | NR | MDT7864673.1 | 2056631 | g47400 | i0 | 96.2 | 0.993630573248408 | 52 | 2 | 99.4 | 0 | 2 | 157 | 58 | 109 | MDT7864673.1 hypothetical protein [Thermoproteota archaeon] | diamond | 156 | 107 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30689526 | 30689526 | PRJNA977246_S_NODE_45073_length_166_cov_2.087591_g44081_i0 | PRJNA977246 | 45073 | 166 | 2.087591 | 3.46540106 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 116 | 1.87e-31 | NR | HYP42999.1 | 2109671 | g44081 | i0 | 100 | 1.98795180722892 | 55 | 0 | 99.4 | 0 | 166 | 2 | 27 | 81 | HYP42999.1 30S ribosomal protein S4e [Candidatus Nitrosocosmicus sp.] | diamond | 330 | 116 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 30910976 | 30910976 | PRJNA977246_S_NODE_48974_length_156_cov_2.984252_g47982_i0 | PRJNA977246 | 48974 | 156 | 2.984252 | 4.65543312 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 99.4 | 4.4e-23 | NR | MDW0282465.1 | 2169593 | g47982 | i0 | 98 | 0.980769230769231 | 51 | 1 | 98.1 | 0 | 3 | 155 | 11 | 61 | MDW0282465.1 phosphoglycerate kinase [Nitrososphaeraceae archaeon] | diamond | 153 | 99.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31353373 | 31353373 | PRJNA977246_S_NODE_26936_length_247_cov_3.174312_g25944_i0 | PRJNA977246 | 26936 | 247 | 3.174312 | 7.84055064 | Acidilobus sp. | 1872109 | Archaea | Archaea | 127 | 6.259999999999999e-32 | NR | NAZ38545.1 | 1872109 | g25944 | i0 | 79 | 12.3643724696356 | 81 | 17 | 98.4 | 0 | 246 | 4 | 309 | 389 | NAZ38545.1 CDC48 family AAA ATPase [Acidilobus sp.] | diamond | 3054 | 127 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Acidilobales | Acidilobaceae | Acidilobus | Acidilobus sp. | ||
| 31770590 | 31770590 | PRJNA977246_S_NODE_22957_length_280_cov_4.298805_g21965_i0 | PRJNA977246 | 22957 | 280 | 4.298805 | 12.036654 | root | 1 | Root_unresolved | Root_unresolved | 155 | 1.04e-43 | NR | WP_345803936.1 | 121277 | g21965 | i0 | 97.8 | 1.90714285714286 | 89 | 2 | 95.4 | 0 | 12 | 278 | 38 | 126 | WP_345803936.1 complex I subunit 5 family protein [Pyrobaculum arsenaticum] | diamond | 534 | 155 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 32624500 | 32624500 | PRJNA977246_S_NODE_33480_length_208_cov_3.949721_g32488_i0 | PRJNA977246 | 33480 | 208 | 3.949721 | 8.21541968 | Archaea | 2157 | Archaea | Archaea | 88.6 | 1.24e-18 | NR | MDT7864683.1 | 2056631 | g32488 | i0 | 90 | 1.41346153846154 | 50 | 5 | 72.1 | 0 | 157 | 8 | 312 | 361 | MDT7864683.1 hypothetical protein [Thermoproteota archaeon] | diamond | 294 | 88.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon |
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);;