contig_metadata
11 rows where bioproject = "PRJNA1237347", tax_phylum = "Thermoproteota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26788369 | 26788369 | PRJNA1237347_P_NODE_318101_length_322_cov_1.236948_g311528_i0 | PRJNA1237347 | 318101 | 322 | 1.236948 | 3.98297256 | Ignisphaera sp. | 2268142 | Archaea | Archaea | 43.5 | 0.0454 | NR | MEM4513545.1 | 2268142 | g311528 | i0 | 31.6 | 0.885093167701863 | 95 | 60 | 85.7 | 3 | 292 | 17 | 65 | 157 | MEM4513545.1 galactose-1-phosphate uridylyltransferase [Ignisphaera sp.] | diamond | 285 | 43.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Ignisphaera | Ignisphaera sp. | ||
| 28052277 | 28052277 | PRJNA1237347_P_NODE_429225_length_267_cov_3.154639_g422652_i0 | PRJNA1237347 | 429225 | 267 | 3.154639 | 8.42288613 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 49.7 | 1.8e-4 | NR | MDQ2684806.1 | 2056631 | g422652 | i0 | 36.2 | 1.97752808988764 | 69 | 44 | 77.5 | 0 | 213 | 7 | 234 | 302 | MDQ2684806.1 hypothetical protein [Thermoproteota archaeon] | diamond | 528 | 49.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28620923 | 28620923 | PRJNA1237347_P_NODE_528527_length_244_cov_0.900585_g521954_i0 | PRJNA1237347 | 528527 | 244 | 0.900585 | 2.1974274 | Desulfurococcaceae archaeon | 2184738 | Archaea | Archaea | 61.2 | 3.96e-10 | NR | MEM0380901.1 | 2184738 | g521954 | i0 | 41.4 | 1.6844262295082 | 70 | 39 | 86.1 | 1 | 11 | 220 | 14 | 81 | MEM0380901.1 DNA-directed RNA polymerase subunit H [Desulfurococcaceae archaeon] | diamond | 411 | 61.2 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Desulfurococcaceae archaeon | |||
| 29157499 | 29157499 | PRJNA1237347_P_NODE_347249_length_305_cov_0.987069_g340676_i0 | PRJNA1237347 | 347249 | 305 | 0.987069 | 3.01056045 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 61.6 | 1.83e-8 | NR | MEM2696059.1 | 2056631 | g340676 | i0 | 53.6 | 1.20983606557377 | 56 | 26 | 55.1 | 0 | 45 | 212 | 534 | 589 | MEM2696059.1 hypothetical protein [Thermoproteota archaeon] | diamond | 369 | 61.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29630786 | 29630786 | PRJNA1237347_P_NODE_488770_length_249_cov_0.875000_g482197_i0 | PRJNA1237347 | 488770 | 249 | 0.875 | 2.17875 | Pyrobaculum ferrireducens | 1104324 | Archaea | Archaea | 68.9 | 1.43e-11 | NR | WP_014287923.1 | 1104324 | g482197 | i0 | 48.1 | 3.80722891566265 | 79 | 41 | 95.2 | 0 | 1 | 237 | 214 | 292 | WP_014287923.1 deoxyhypusine synthase [Pyrobaculum ferrireducens] | diamond | 948 | 68.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum ferrireducens | ||
| 31292242 | 31292242 | PRJNA1237347_P_NODE_69035_length_864_cov_1.720607_g63267_i0 | PRJNA1237347 | 69035 | 864 | 1.720607 | 14.86604448 | root | 1 | Root_unresolved | Root_unresolved | 135 | 2.4699999999999996e-32 | NR | WP_011278342.1 | 2285 | g63267 | i0 | 32.6 | 7.24305555555556 | 239 | 144 | 79.5 | 3 | 54 | 740 | 3 | 234 | WP_011278342.1 MFS transporter [Sulfolobus acidocaldarius] | diamond | 6258 | 136 | 0.992647058823529 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfolobus | Sulfolobus acidocaldarius | ||
| 32114889 | 32114889 | PRJNA1237347_P_NODE_363938_length_296_cov_1.134529_g357365_i0 | PRJNA1237347 | 363938 | 296 | 1.134529 | 3.35820584 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.00708 | NR | MFN3803649.1 | 2004705 | g357365 | i0 | 43.4 | 7.85472972972973 | 53 | 30 | 53.7 | 0 | 136 | 294 | 1 | 53 | MFN3803649.1 TATA-box-binding protein [Pyrobaculum sp.] | diamond | 2325 | 45.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum sp. | ||
| 32222562 | 32222562 | PRJNA1237347_P_NODE_126998_length_583_cov_14.945098_g120477_i0 | PRJNA1237347 | 126998 | 583 | 14.945098 | 87.12992134 | Candidatus Methanomethylicus sp. | 2282147 | Archaea | Archaea | 138 | 5.059999999999999e-38 | NR | HRR55037.1 | 2282147 | g120477 | i0 | 48.3 | 3.14922813036021 | 151 | 73 | 77.7 | 2 | 102 | 554 | 8 | 153 | HRR55037.1 lipocalin family protein [Candidatus Methanomethylicus sp.] | diamond | 1836 | 138 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicus | Candidatus Methanomethylicus sp. | ||
| 32462850 | 32462850 | PRJNA1237347_P_NODE_175919_length_472_cov_1.804511_g169348_i0 | PRJNA1237347 | 175919 | 472 | 1.804511 | 8.51729192 | root | 1 | Root_unresolved | Root_unresolved | 64.7 | 8.32e-9 | NR | WP_126451064.1 | 1670455 | g169348 | i0 | 31.2 | 3.36864406779661 | 93 | 63 | 59.1 | 1 | 471 | 193 | 279 | 370 | WP_126451064.1 aldehyde dehydrogenase family protein [Sulfodiicoccus acidiphilus] | diamond | 1590 | 65.1 | 0.993855606758833 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfodiicoccus | Sulfodiicoccus acidiphilus | ||
| 32508140 | 32508140 | PRJNA1237347_P_NODE_73919_length_827_cov_1.897878_g68000_i0 | PRJNA1237347 | 73919 | 827 | 1.897878 | 15.69545106 | Thermofilum sp. | 1961369 | Archaea | Archaea | 63.2 | 2.95e-7 | NR | MCC6005754.1 | 1961369 | g68000 | i0 | 53.6 | 0.489721886336155 | 69 | 31 | 25 | 1 | 802 | 596 | 5 | 72 | MCC6005754.1 ankyrin repeat domain-containing protein [Thermofilum sp.] | diamond | 405 | 63.2 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Thermofilum | Thermofilum sp. | ||
| 32602129 | 32602129 | PRJNA1237347_P_NODE_194720_length_441_cov_2.097826_g188148_i0 | PRJNA1237347 | 194720 | 441 | 2.097826 | 9.25141266 | Crenarchaeota archaeon 13_1_2 | 2056631 | Archaea | Archaea | 64.7 | 3.16e-9 | NR | OLE91984.1 | 1805093 | g188148 | i0 | 47.4 | 1.46258503401361 | 76 | 32 | 51.7 | 3 | 228 | 1 | 24 | 91 | OLE91984.1 MAG: peptidase C1 [Crenarchaeota archaeon 13_1_20CM_2_51_8] | diamond | 645 | 64.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Crenarchaeota archaeon 13_1_20CM_2_51_8 |
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);;