contig_metadata
12 rows where bioproject = "PRJNA546018" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2394818 | 2394818 | PRJNA546018_S_NODE_9002_length_583_cov_2.457854_g8686_i0 | PRJNA546018 | 9002 | 583 | 2.457854 | 14.32928882 | Nitrosopumilales archaeon | 2026768 | Archaea | Archaea | 138 | 6.67e-39 | NR | RPJ29686.1 | 2026768 | g8686 | i0 | 98.6 | 0.355060034305317 | 69 | 1 | 35.5 | 0 | 551 | 345 | 18 | 86 | RPJ29686.1 MAG: hypothetical protein EHM25_08605 [Nitrosopumilales archaeon] | diamond | 207 | 138 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilales archaeon | ||||
| 28056900 | 28056900 | PRJNA546018_S_NODE_29365_length_290_cov_3.794760_g29040_i0 | PRJNA546018 | 29365 | 290 | 3.79476 | 11.004804 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 128 | 2.2999999999999998e-32 | NR | MEM3368523.1 | 2056631 | g29040 | i0 | 94.2 | 0.713793103448276 | 69 | 4 | 71.4 | 0 | 266 | 60 | 495 | 563 | MEM3368523.1 hypothetical protein [Thermoproteota archaeon] | diamond | 207 | 128 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28499241 | 28499241 | PRJNA546018_S_NODE_46547_length_223_cov_3.746914_g46222_i0 | PRJNA546018 | 46547 | 223 | 3.746914 | 8.35561822 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 126 | 8.89e-32 | NR | MEM3368643.1 | 2056631 | g46222 | i0 | 95.5 | 0.887892376681614 | 66 | 3 | 88.8 | 0 | 25 | 222 | 791 | 856 | MEM3368643.1 hypothetical protein [Thermoproteota archaeon] | diamond | 198 | 126 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28892645 | 28892645 | PRJNA546018_S_NODE_45868_length_225_cov_3.896341_g45543_i0 | PRJNA546018 | 45868 | 225 | 3.896341 | 8.76676725 | Nanobdellati | 1783276 | Archaea | Archaea | 132 | 1.2e-33 | NR | MCG2720205.1 | 2026764 | g45543 | i0 | 89.3 | 4 | 75 | 8 | 100 | 0 | 1 | 225 | 387 | 461 | MCG2720205.1 Eco57I restriction-modification methylase domain-containing protein [Nanoarchaeota archaeon] | diamond | 900 | 132 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 30678031 | 30678031 | PRJNA546018_S_NODE_23013_length_334_cov_2.732601_g22688_i0 | PRJNA546018 | 23013 | 334 | 2.732601 | 9.12688734 | Ignisphaera sp. | 2268142 | Archaea | Archaea | 61.6 | 1.1e-8 | NR | MCI4435342.1 | 2268142 | g22688 | i0 | 32.3 | 1.44610778443114 | 96 | 56 | 85.3 | 3 | 12 | 296 | 69 | 156 | MCI4435342.1 hypothetical protein [Ignisphaera sp.] | diamond | 483 | 61.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Ignisphaera | Ignisphaera sp. | ||
| 30867713 | 30867713 | PRJNA546018_S_NODE_20934_length_352_cov_6.635739_g20609_i0 | PRJNA546018 | 20934 | 352 | 6.635739 | 23.35780128 | archaeon | 1906665 | Archaea | Archaea | 48.9 | 7.98e-5 | NR | MDP2437058.1 | 1906665 | g20609 | i0 | 65.5 | 1.29545454545455 | 29 | 10 | 24.7 | 0 | 230 | 316 | 55 | 83 | MDP2437058.1 hypothetical protein [archaeon] | diamond | 456 | 48.9 | 1 | Archaea | archaeon | ||||||||
| 31310131 | 31310131 | PRJNA546018_S_NODE_17915_length_386_cov_5.289231_g17590_i0 | PRJNA546018 | 17915 | 386 | 5.289231 | 20.41643166 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 83.2 | 1.32e-15 | NR | MCX8150022.1 | 2026714 | g17590 | i0 | 43.8 | 0.940414507772021 | 121 | 66 | 93.3 | 2 | 22 | 381 | 239 | 358 | MCX8150022.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 363 | 83.2 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31595146 | 31595146 | PRJNA546018_S_NODE_54476_length_206_cov_2.358621_g54151_i0 | PRJNA546018 | 54476 | 206 | 2.358621 | 4.85875926 | Nitrosopumilales archaeon | 2026768 | Archaea | Archaea | 136 | 2.1e-35 | NR | RPJ31358.1 | 2026768 | g54151 | i0 | 98.5 | 5.85436893203883 | 67 | 1 | 97.6 | 0 | 205 | 5 | 442 | 508 | RPJ31358.1 MAG: DNA-directed DNA polymerase I [Nitrosopumilales archaeon] | diamond | 1206 | 136 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilales archaeon | ||||
| 31752976 | 31752976 | PRJNA546018_S_NODE_15677_length_417_cov_18.485955_g15352_i0 | PRJNA546018 | 15677 | 417 | 18.485955 | 77.08643235 | archaeon | 1906665 | Archaea | Archaea | 132 | 1.14e-34 | NR | RYG65852.1 | 1906665 | g15352 | i0 | 72.2 | 0.568345323741007 | 79 | 22 | 56.8 | 0 | 395 | 159 | 232 | 310 | RYG65852.1 MAG: hypothetical protein EON64_11065 [archaeon] | diamond | 237 | 132 | 1 | Archaea | archaeon | ||||||||
| 31847873 | 31847873 | PRJNA546018_S_NODE_53877_length_207_cov_1.965753_g53552_i0 | PRJNA546018 | 53877 | 207 | 1.965753 | 4.06910871 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 66.6 | 3.37e-11 | NR | MDP7658232.1 | 2268197 | g53552 | i0 | 41.2 | 0.985507246376812 | 68 | 40 | 98.6 | 0 | 205 | 2 | 139 | 206 | MDP7658232.1 molecular chaperone TorD family protein [Nitrososphaerales archaeon] | diamond | 204 | 66.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 32069384 | 32069384 | PRJNA546018_S_NODE_7458_length_650_cov_6.190153_g7160_i0 | PRJNA546018 | 7458 | 650 | 6.190153 | 40.2359945 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 183 | 1.87e-51 | NR | HEX9430277.1 | 3045160 | g7160 | i0 | 47.8 | 0.955384615384615 | 207 | 79 | 92.8 | 5 | 24 | 626 | 122 | 305 | HEX9430277.1 DNA polymerase A family protein [Candidatus Bathyarchaeia archaeon] | diamond | 621 | 183 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 32385844 | 32385844 | PRJNA546018_S_NODE_13259_length_462_cov_11.738155_g12935_i0 | PRJNA546018 | 13259 | 462 | 11.738155 | 54.2302761 | archaeon | 1906665 | Archaea | Archaea | 82.8 | 2.11e-17 | NR | RYH28346.1 | 1906665 | g12935 | i0 | 49.4 | 1.22727272727273 | 89 | 45 | 57.8 | 0 | 80 | 346 | 10 | 98 | RYH28346.1 MAG: hypothetical protein EON65_12530 [archaeon] | diamond | 567 | 82.8 | 1 | Archaea | 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);;