contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27110823 | 27110823 | PRJNA565584_P_NODE_18862_length_736_cov_1.933635_g17769_i0 | PRJNA565584 | 18862 | 736 | 1.933635 | 14.2315536 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 149 | 1.09e-40 | NR | MDH5401859.1 | 2026747 | g17769 | i0 | 36.6 | 0.925271739130435 | 227 | 139 | 92.5 | 2 | 728 | 48 | 5 | 226 | MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon] | diamond | 681 | 149 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27364194 | 27364194 | PRJNA565584_P_NODE_203303_length_243_cov_1.747059_g202151_i0 | PRJNA565584 | 203303 | 243 | 1.747059 | 4.24535337 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 45.1 | 0.00541 | NR | NPD90145.1 | 2591838 | g202151 | i0 | 35.5 | 0.938271604938272 | 76 | 44 | 87.7 | 1 | 23 | 235 | 90 | 165 | NPD90145.1 hypothetical protein [Promethearchaeati archaeon] | diamond | 228 | 45.1 | 1 | Archaea | Promethearchaeati | Promethearchaeati archaeon | |||||||
| 28121593 | 28121593 | PRJNA565584_P_NODE_126485_length_278_cov_0.863415_g125333_i0 | PRJNA565584 | 126485 | 278 | 0.863415 | 2.4002937 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 51.2 | 5.69e-5 | NR | TFG25295.1 | 2053489 | g125333 | i0 | 48.4 | 1.38129496402878 | 64 | 30 | 69.1 | 1 | 192 | 1 | 326 | 386 | TFG25295.1 MAG: glycerol-3-phosphate dehydrogenase/oxidase, partial [Promethearchaeota archaeon] | diamond | 384 | 51.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28816069 | 28816069 | PRJNA565584_P_NODE_47668_length_432_cov_1.005571_g46517_i0 | PRJNA565584 | 47668 | 432 | 1.005571 | 4.34406672 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 79 | 1.04e-14 | NR | TET81129.1 | 2026747 | g46517 | i0 | 38.5 | 8.82638888888889 | 122 | 67 | 84.7 | 3 | 392 | 27 | 65 | 178 | TET81129.1 MAG: Kae1-associated serine/threonine protein kinase [Candidatus Heimdallarchaeota archaeon] | diamond | 3813 | 79 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29037528 | 29037528 | PRJNA565584_P_NODE_15908_length_814_cov_1.585695_g14841_i0 | PRJNA565584 | 15908 | 814 | 1.585695 | 12.9075573 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 162 | 1.82e-42 | NR | MCH8907703.1 | 2026747 | g14841 | i0 | 39.8 | 1.67690417690418 | 226 | 119 | 82.6 | 6 | 679 | 8 | 270 | 480 | MCH8907703.1 CD36 family protein [Candidatus Heimdallarchaeota archaeon] | diamond | 1365 | 162 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29069095 | 29069095 | PRJNA565584_P_NODE_42128_length_461_cov_2.747423_g40977_i0 | PRJNA565584 | 42128 | 461 | 2.747423 | 12.66562003 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 70.5 | 8.59e-11 | NR | MCY3415128.1 | 2026747 | g40977 | i0 | 36.5 | 0.676789587852495 | 104 | 60 | 67.7 | 2 | 318 | 7 | 10 | 107 | MCY3415128.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 312 | 70.5 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29289897 | 29289897 | PRJNA565584_P_NODE_47669_length_432_cov_1.002786_g46518_i0 | PRJNA565584 | 47669 | 432 | 1.002786 | 4.33203552 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 60.5 | 1.5e-7 | NR | MBD3157206.1 | 2053489 | g46518 | i0 | 29.6 | 0.798611111111111 | 115 | 77 | 77.1 | 1 | 62 | 394 | 163 | 277 | MBD3157206.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 345 | 60.5 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29321480 | 29321480 | PRJNA565584_P_NODE_91169_length_311_cov_1.294118_g90017_i0 | PRJNA565584 | 91169 | 311 | 1.294118 | 4.02470698 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 132 | 2.05e-33 | NR | MFO7795213.1 | 3067280 | g90017 | i0 | 97 | 0.636655948553055 | 66 | 2 | 63.7 | 0 | 114 | 311 | 546 | 611 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 198 | 132 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 29826629 | 29826629 | PRJNA565584_P_NODE_50951_length_417_cov_1.040698_g49800_i0 | PRJNA565584 | 50951 | 417 | 1.040698 | 4.33971066 | Candidatus Freyarchaeota archaeon SRVP19_Freyarchaeia-1 | 3402145 | Archaea | Archaea | 45.4 | 0.0236 | NR | WXG40936.1 | 3126528 | g49800 | i0 | 24.1 | 0.956834532374101 | 133 | 94 | 95 | 3 | 6 | 401 | 47 | 173 | WXG40936.1 MAG: tRNA (guanine(10)-N(2))-dimethyltransferase [Candidatus Freyarchaeota archaeon SRVP19_Freyarchaeia-1] | diamond | 399 | 45.4 | 1 | Archaea | Promethearchaeati | Candidatus Freyarchaeota | Candidatus Freyarchaeota archaeon SRVP19_Freyarchaeia-1 | ||||||
| 30521704 | 30521704 | PRJNA565584_P_NODE_185973_length_247_cov_0.885057_g184821_i0 | PRJNA565584 | 185973 | 247 | 0.885057 | 2.18609079 | Candidatus Harpocratesius repetitus | 3049170 | Archaea | Archaea | 42.7 | 0.0392 | NR | MCF2140506.1 | 3049170 | g184821 | i0 | 41.7 | 0.437246963562753 | 36 | 21 | 43.7 | 0 | 40 | 147 | 452 | 487 | MCF2140506.1 MBL fold metallo-hydrolase [Candidatus Harpocratesius repetitus] | diamond | 108 | 42.7 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Candidatus Harpocratesius | Candidatus Harpocratesius repetitus | ||
| 31279948 | 31279948 | PRJNA565584_P_NODE_110315_length_288_cov_1.279070_g109163_i0 | PRJNA565584 | 110315 | 288 | 1.27907 | 3.6837216 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 126 | 2.29e-31 | NR | MCY3414927.1 | 2026747 | g109163 | i0 | 66 | 0.979166666666667 | 94 | 30 | 95.8 | 1 | 279 | 4 | 170 | 263 | MCY3414927.1 BspA family leucine-rich repeat surface protein [Candidatus Heimdallarchaeota archaeon] | diamond | 282 | 126 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 31311651 | 31311651 | PRJNA565584_P_NODE_210495_length_242_cov_0.911243_g209343_i0 | PRJNA565584 | 210495 | 242 | 0.911243 | 2.20520806 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 63.9 | 4.41e-10 | NR | NHK30495.1 | 2591838 | g209343 | i0 | 50.8 | 0.756198347107438 | 61 | 30 | 75.6 | 0 | 235 | 53 | 87 | 147 | NHK30495.1 isoprenylcysteine carboxylmethyltransferase family protein [Promethearchaeati archaeon] | diamond | 183 | 63.9 | 1 | Archaea | Promethearchaeati | Promethearchaeati archaeon | |||||||
| 32797222 | 32797222 | PRJNA565584_P_NODE_124860_length_279_cov_1.106796_g123708_i0 | PRJNA565584 | 124860 | 279 | 1.106796 | 3.08796084 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.1 | 0.0403 | NR | MBN2153423.1 | 2053489 | g123708 | i0 | 34.7 | 0.806451612903226 | 75 | 41 | 76.3 | 2 | 12 | 224 | 245 | 315 | MBN2153423.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 225 | 43.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota 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);;