contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1144090" and tax_kingdom = "Promethearchaeati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2838503 | 2838503 | PRJNA1144090_P_NODE_76183_length_289_cov_1.962963_g75648_i0 | PRJNA1144090 | 76183 | 289 | 1.962963 | 5.67296307 | Candidatus Helarchaeota archaeon | 2719382 | Archaea | Archaea | 128 | 1.84e-32 | NR | NVM31140.1 | 2719382 | g75648 | i0 | 66.7 | 2.0242214532872 | 93 | 29 | 95.5 | 2 | 12 | 287 | 99 | 190 | NVM31140.1 carboxylesterase/lipase family protein [Candidatus Helarchaeota archaeon] | diamond | 585 | 128 | 1 | Archaea | Promethearchaeati | Candidatus Helarchaeota | Candidatus Helarchaeota archaeon | ||||||
| 10490653 | 10490653 | PRJNA1144090_P_NODE_16849_length_671_cov_3.356187_g16334_i0 | PRJNA1144090 | 16849 | 671 | 3.356187 | 22.52001477 | root | 1 | Root_unresolved | Root_unresolved | 285 | 2.1500000000000005e-91 | NR | OLS25367.1 | 1841598 | g16334 | i0 | 57.8 | 17.9910581222057 | 225 | 92 | 99.7 | 3 | 670 | 2 | 191 | 414 | OLS25367.1 MAG: hypothetical protein HeimC3_15810 [Candidatus Heimdallarchaeota archaeon LC_3] | diamond | 12072 | 286 | 0.996503496503496 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon LC_3 | ||||||
| 11765917 | 11765917 | PRJNA1144090_P_NODE_36510_length_430_cov_1.294118_g35975_i0 | PRJNA1144090 | 36510 | 430 | 1.294118 | 5.5647074 | Archaea | 2157 | Archaea | Archaea | 207 | 3.65e-62 | NR | KKK45229.1 | 1538547 | g35975 | i0 | 66.4 | 15.9558139534884 | 143 | 48 | 99.8 | 0 | 2 | 430 | 127 | 269 | KKK45229.1 MAG: Cyclic 2,3-diphosphoglycerate synthetase [Candidatus Lokiarchaeum sp. GC14_75] | diamond | 6861 | 207 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Candidatus Lokiarchaeum | Candidatus Lokiarchaeum sp. GC14_75 | ||
| 27260216 | 27260216 | PRJNA1144090_P_NODE_49563_length_362_cov_5.650519_g49028_i0 | PRJNA1144090 | 49563 | 362 | 5.650519 | 20.45487878 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 48.9 | 8.74e-4 | NR | MBY9020929.1 | 2053489 | g49028 | i0 | 39.5 | 0.629834254143646 | 76 | 41 | 61.3 | 3 | 264 | 43 | 165 | 237 | MBY9020929.1 GTP-binding protein [Promethearchaeota archaeon] | diamond | 228 | 48.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 27260230 | 27260230 | PRJNA1144090_P_NODE_66363_length_311_cov_1.294118_g65828_i0 | PRJNA1144090 | 66363 | 311 | 1.294118 | 4.02470698 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 119 | 8.31e-29 | NR | MEA2069919.1 | 2591838 | g65828 | i0 | 56.9 | 0.983922829581994 | 102 | 44 | 98.4 | 0 | 309 | 4 | 80 | 181 | MEA2069919.1 GTP-binding protein [Promethearchaeati archaeon] | diamond | 306 | 119 | 1 | Archaea | Promethearchaeati | Promethearchaeati archaeon | |||||||
| 27702640 | 27702640 | PRJNA1144090_P_NODE_49944_length_361_cov_2.118056_g49409_i0 | PRJNA1144090 | 49944 | 361 | 2.118056 | 7.64618216 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 95.5 | 5.5600000000000006e-21 | NR | MBD3350911.1 | 2053489 | g49409 | i0 | 39.8 | 1.10526315789474 | 133 | 67 | 99.7 | 1 | 1 | 360 | 143 | 275 | MBD3350911.1 DUF1152 domain-containing protein [Promethearchaeota archaeon] | diamond | 399 | 95.5 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 27797168 | 27797168 | PRJNA1144090_P_NODE_117724_length_237_cov_2.993902_g117189_i0 | PRJNA1144090 | 117724 | 237 | 2.993902 | 7.09554774 | Candidatus Sigynarchaeota archaeon | 3036967 | Archaea | Archaea | 102 | 4.65e-23 | NR | MEX2719049.1 | 3036967 | g117189 | i0 | 56.4 | 1.9746835443038 | 78 | 34 | 98.7 | 0 | 3 | 236 | 214 | 291 | MEX2719049.1 SIR2 family protein [Candidatus Sigynarchaeota archaeon] | diamond | 468 | 102 | 1 | Archaea | Promethearchaeati | Candidatus Sigynarchaeota | Candidatus Sigynarchaeota archaeon | ||||||
| 28018185 | 28018185 | PRJNA1144090_P_NODE_68965_length_305_cov_1.306034_g68430_i0 | PRJNA1144090 | 68965 | 305 | 1.306034 | 3.9834037 | Candidatus Odinarchaeota archaeon | 2053490 | Archaea | Archaea | 67.4 | 2.8e-11 | NR | MCD6483744.1 | 2053490 | g68430 | i0 | 46.6 | 0.718032786885246 | 73 | 39 | 71.8 | 0 | 2 | 220 | 90 | 162 | MCD6483744.1 GTP-binding protein [Candidatus Odinarchaeota archaeon] | diamond | 219 | 67.4 | 1 | Archaea | Promethearchaeati | Candidatus Odinarchaeota | Candidatus Odinarchaeota archaeon | ||||||
| 28449249 | 28449249 | PRJNA1144090_P_NODE_111466_length_244_cov_0.900585_g110931_i0 | PRJNA1144090 | 111466 | 244 | 0.900585 | 2.1974274 | Candidatus Harpocratesius | 3049169 | Archaea | Archaea | 91.3 | 2.27e-19 | NR | TFG17558.1 | 2053489 | g110931 | i0 | 60.9 | 8.49590163934426 | 69 | 25 | 84.8 | 1 | 209 | 3 | 2 | 68 | TFG17558.1 MAG: GTPase [Promethearchaeota archaeon] | diamond | 2073 | 91.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28933781 | 28933781 | PRJNA1144090_P_NODE_54908_length_343_cov_2.033333_g54373_i0 | PRJNA1144090 | 54908 | 343 | 2.033333 | 6.97433219 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.1 | 0.0454 | NR | MBY8979638.1 | 2053489 | g54373 | i0 | 28.7 | 0.822157434402332 | 94 | 58 | 82.2 | 2 | 324 | 43 | 77 | 161 | MBY8979638.1 DUF3795 domain-containing protein [Promethearchaeota archaeon] | diamond | 282 | 43.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29375657 | 29375657 | PRJNA1144090_P_NODE_11349_length_835_cov_6.673228_g10907_i0 | PRJNA1144090 | 11349 | 835 | 6.673228 | 55.7214538 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 110 | 4.31e-24 | NR | MCH8906438.1 | 2026747 | g10907 | i0 | 34.6 | 0.819161676646707 | 228 | 101 | 71.5 | 11 | 763 | 167 | 42 | 250 | MCH8906438.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 684 | 110 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30512822 | 30512822 | PRJNA1144090_P_NODE_85713_length_272_cov_1.381910_g85178_i0 | PRJNA1144090 | 85713 | 272 | 1.38191 | 3.7587952 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 47.4 | 9.64e-4 | NR | MBN2154198.1 | 2053489 | g85178 | i0 | 40 | 0.496323529411765 | 45 | 27 | 49.6 | 0 | 163 | 29 | 1 | 45 | MBN2154198.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 135 | 47.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 30544417 | 30544417 | PRJNA1144090_P_NODE_116753_length_241_cov_0.916667_g116218_i0 | PRJNA1144090 | 116753 | 241 | 0.916667 | 2.20916747 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 70.9 | 9.58e-13 | NR | HMF32723.1 | 3067280 | g116218 | i0 | 54.2 | 0.734439834024896 | 59 | 27 | 73.4 | 0 | 181 | 5 | 4 | 62 | HMF32723.1 TSUP family transporter [Promethearchaeia archaeon] | diamond | 177 | 70.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 31176074 | 31176074 | PRJNA1144090_P_NODE_70355_length_301_cov_2.938596_g69820_i0 | PRJNA1144090 | 70355 | 301 | 2.938596 | 8.84517396 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 47 | 0.00224 | NR | TXT54359.1 | 2053491 | g69820 | i0 | 43.9 | 0.408637873754153 | 41 | 23 | 40.9 | 0 | 109 | 231 | 305 | 345 | TXT54359.1 MAG: putative Metallophosphoesterase [Candidatus Thorarchaeota archaeon] | diamond | 123 | 47 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 31608067 | 31608067 | PRJNA1144090_P_NODE_43576_length_389_cov_2.120253_g43041_i0 | PRJNA1144090 | 43576 | 389 | 2.120253 | 8.24778417 | Promethearchaeaceae | 3366644 | Archaea | Archaea | 107 | 2.06e-24 | NR | UYP46776.1 | 2951803 | g43041 | i0 | 48.8 | 1.9974293059126 | 129 | 57 | 99.5 | 2 | 3 | 389 | 305 | 424 | UYP46776.1 Glycerate 2-kinase [Candidatus Lokiarchaeum ossiferum] | diamond | 777 | 107 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Candidatus Lokiarchaeum | Candidatus Lokiarchaeum ossiferum | ||
| 31650492 | 31650492 | PRJNA1144090_P_NODE_100257_length_250_cov_2.412429_g99722_i0 | PRJNA1144090 | 100257 | 250 | 2.412429 | 6.0310725 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 51.2 | 1.07e-5 | NR | MFB0544787.1 | 2591838 | g99722 | i0 | 50 | 0.576 | 48 | 22 | 57.6 | 1 | 144 | 1 | 56 | 101 | MFB0544787.1 lipopolysaccharide core heptose(II) kinase RfaY [Promethearchaeati archaeon] | diamond | 144 | 51.2 | 1 | Archaea | Promethearchaeati | Promethearchaeati archaeon | |||||||
| 31682125 | 31682125 | PRJNA1144090_P_NODE_40197_length_407_cov_1.844311_g39662_i0 | PRJNA1144090 | 40197 | 407 | 1.844311 | 7.50634577 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 58.2 | 8.48e-7 | NR | MCE7735885.1 | 2026747 | g39662 | i0 | 47.6 | 0.464373464373464 | 63 | 31 | 46.4 | 2 | 331 | 143 | 360 | 420 | MCE7735885.1 ABC transporter substrate-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 189 | 58.2 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32283817 | 32283817 | PRJNA1144090_P_NODE_84479_length_274_cov_1.497512_g83944_i0 | PRJNA1144090 | 84479 | 274 | 1.497512 | 4.10318288 | Promethearchaeota archaeon CR_4 | 1849166 | Archaea | Archaea | 56.6 | 6.45e-7 | NR | OLS14127.1 | 1849166 | g83944 | i0 | 76.9 | 0.427007299270073 | 39 | 8 | 42.7 | 1 | 154 | 270 | 15 | 52 | OLS14127.1 MAG: short-chain alcohol dehydrogenase [Promethearchaeota archaeon CR_4] | diamond | 117 | 56.6 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon CR_4 | ||||||
| 32725672 | 32725672 | PRJNA1144090_P_NODE_13800_length_753_cov_2.717647_g13329_i0 | PRJNA1144090 | 13800 | 753 | 2.717647 | 20.46388191 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 186 | 1.3e-51 | NR | MEA2069919.1 | 2591838 | g13329 | i0 | 44.7 | 0.864541832669323 | 217 | 108 | 86.1 | 3 | 2 | 649 | 328 | 533 | MEA2069919.1 GTP-binding protein [Promethearchaeati archaeon] | diamond | 651 | 186 | 1 | Archaea | Promethearchaeati | Promethearchaeati 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);;