contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1118794" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27352772 | 27352772 | PRJNA1118794_P_NODE_39463_length_270_cov_1.274112_g38713_i0 | PRJNA1118794 | 39463 | 270 | 1.274112 | 3.4401024 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 125 | 2.1399999999999997e-31 | NR | HET6405799.1 | 2806419 | g38713 | i0 | 71.3 | 1.93333333333333 | 87 | 25 | 96.7 | 0 | 263 | 3 | 17 | 103 | HET6405799.1 malate synthase A [Thermoplasmatota archaeon] | diamond | 522 | 125 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28015776 | 28015776 | PRJNA1118794_P_NODE_6045_length_573_cov_2.138000_g5307_i0 | PRJNA1118794 | 6045 | 573 | 2.138 | 12.25074 | Euryarchaeota archaeon TMED1 | 2026739 | Archaea | Archaea | 46.2 | 0.0377 | NR | OUV39351.1 | 1986682 | g5307 | i0 | 26.7 | 0.450261780104712 | 86 | 63 | 45 | 0 | 102 | 359 | 224 | 309 | OUV39351.1 MAG: hypothetical protein CBC63_04155 [Euryarchaeota archaeon TMED103] | diamond | 258 | 46.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Euryarchaeota archaeon TMED103 | ||||||
| 28047153 | 28047153 | PRJNA1118794_P_NODE_32165_length_286_cov_2.652582_g31415_i0 | PRJNA1118794 | 32165 | 286 | 2.652582 | 7.58638452 | Methanothrix sp. | 90426 | Archaea | Archaea | 54.3 | 5.47e-6 | NR | HPJ29788.1 | 90426 | g31415 | i0 | 44.1 | 0.618881118881119 | 59 | 27 | 55.6 | 1 | 262 | 104 | 555 | 613 | HPJ29788.1 beta/gamma crystallin-related protein [Methanothrix sp.] | diamond | 177 | 54.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28710420 | 28710420 | PRJNA1118794_P_NODE_60667_length_246_cov_0.890173_g59917_i0 | PRJNA1118794 | 60667 | 246 | 0.890173 | 2.18982558 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 103 | 8.469999999999998e-24 | NR | WP_049934778.1 | 413810 | g59917 | i0 | 76.2 | 1.53658536585366 | 63 | 15 | 76.8 | 0 | 3 | 191 | 281 | 343 | WP_049934778.1 hypothetical protein [Halalkalicoccus jeotgali] | diamond | 378 | 103 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 28859033 | 28859033 | PRJNA1118794_P_NODE_20708_length_334_cov_2.291188_g19958_i0 | PRJNA1118794 | 20708 | 334 | 2.291188 | 7.65256792 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 1.32e-5 | NR | WP_256401952.1 | 755306 | g19958 | i0 | 53.7 | 1.3562874251497 | 54 | 22 | 47.6 | 2 | 150 | 308 | 2312 | 2363 | WP_256401952.1 malectin domain-containing carbohydrate-binding protein [Haloarchaeobius litoreus] | diamond | 453 | 54.3 | 0.992633517495396 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Haloarchaeobius | Haloarchaeobius litoreus | |
| 29120921 | 29120921 | PRJNA1118794_P_NODE_50489_length_250_cov_1.740113_g49739_i0 | PRJNA1118794 | 50489 | 250 | 1.740113 | 4.3502825 | Methanolobus zinderi | 536044 | Archaea | Archaea | 71.2 | 3.83e-12 | NR | WP_176965193.1 | 536044 | g49739 | i0 | 37.7 | 0.924 | 77 | 45 | 88.8 | 1 | 226 | 5 | 493 | 569 | WP_176965193.1 PKD domain-containing protein [Methanolobus zinderi] | diamond | 231 | 71.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus zinderi | |
| 29404885 | 29404885 | PRJNA1118794_P_NODE_40809_length_267_cov_1.335052_g40059_i0 | PRJNA1118794 | 40809 | 267 | 1.335052 | 3.56458884 | Halobacteriota archaeon | 3100168 | Archaea | Archaea | 78.6 | 1.22e-14 | NR | MDY6866055.1 | 3100168 | g40059 | i0 | 50 | 1.93258426966292 | 86 | 40 | 93.3 | 1 | 3 | 251 | 210 | 295 | MDY6866055.1 PEP/pyruvate-binding domain-containing protein [Halobacteriota archaeon] | diamond | 516 | 78.6 | 1 | Archaea | Methanobacteriati | Halobacteriota | Halobacteriota archaeon | ||||||
| 29593963 | 29593963 | PRJNA1118794_P_NODE_59070_length_247_cov_0.885057_g58320_i0 | PRJNA1118794 | 59070 | 247 | 0.885057 | 2.18609079 | Methanospirillum stamsii | 1277351 | Archaea | Archaea | 123 | 1.5e-30 | NR | WP_109941090.1 | 1277351 | g58320 | i0 | 85 | 0.728744939271255 | 60 | 9 | 72.9 | 0 | 181 | 2 | 516 | 575 | WP_109941090.1 PKD domain-containing protein [Methanospirillum stamsii] | diamond | 180 | 123 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum stamsii | |
| 29688671 | 29688671 | PRJNA1118794_P_NODE_22810_length_323_cov_1.760000_g22060_i0 | PRJNA1118794 | 22810 | 323 | 1.76 | 5.6848 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 86.3 | 8.97e-19 | NR | MBD38822.1 | 2026739 | g22060 | i0 | 40.8 | 0.956656346749226 | 103 | 58 | 92.9 | 1 | 3 | 302 | 53 | 155 | MBD38822.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 309 | 86.3 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30122107 | 30122107 | PRJNA1118794_P_NODE_35132_length_279_cov_2.237864_g34382_i0 | PRJNA1118794 | 35132 | 279 | 2.237864 | 6.24364056 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 0.00253 | NR | MDD1700180.1 | 2052170 | g34382 | i0 | 31.9 | 2 | 91 | 59 | 96.8 | 3 | 9 | 278 | 356 | 444 | MDD1700180.1 PKD domain-containing protein [Methanoregula sp.] | diamond | 558 | 46.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30257946 | 30257946 | PRJNA1118794_P_NODE_46932_length_254_cov_1.491713_g46182_i0 | PRJNA1118794 | 46932 | 254 | 1.491713 | 3.78895102 | Methanoregula sp. | 2052170 | Archaea | Archaea | 54.7 | 2.73e-6 | NR | MDP3396888.1 | 2052170 | g46182 | i0 | 40.7 | 4.78346456692913 | 81 | 43 | 94.5 | 3 | 14 | 253 | 170 | 246 | MDP3396888.1 PKD domain-containing protein [Methanoregula sp.] | diamond | 1215 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 31268805 | 31268805 | PRJNA1118794_P_NODE_69535_length_242_cov_1.911243_g68785_i0 | PRJNA1118794 | 69535 | 242 | 1.911243 | 4.62520806 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 84 | 2.35e-17 | NR | HHD16766.1 | 2026739 | g68785 | i0 | 49.4 | 0.979338842975207 | 79 | 40 | 97.9 | 0 | 240 | 4 | 23 | 101 | HHD16766.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 237 | 84 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31806492 | 31806492 | PRJNA1118794_P_NODE_75137_length_234_cov_2.391304_g74387_i0 | PRJNA1118794 | 75137 | 234 | 2.391304 | 5.59565136 | Haladaptatus salinisoli | 2884876 | Archaea | Archaea | 42.4 | 0.0447 | NR | WP_227353393.1 | 2884876 | g74387 | i0 | 38.3 | 0.769230769230769 | 60 | 32 | 70.5 | 1 | 179 | 15 | 467 | 526 | WP_227353393.1 ArnT family glycosyltransferase [Haladaptatus salinisoli] | diamond | 180 | 42.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus salinisoli |
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);;