contig_metadata
10 rows where bioproject = "PRJNA857143" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13597457 | 13597457 | PRJNA857143_S_NODE_186431_length_245_cov_2.267442_g185338_i0 | PRJNA857143 | 186431 | 245 | 2.267442 | 5.5552329 | Thermococcus piezophilus | 1712654 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|1029171485|gb|CP015520.1| | 1712654 | g185338 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 133 | 160 | 717341 | 717368 | Thermococcus piezophilus strain CDGS chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus piezophilus | ||
| 26991566 | 26991566 | PRJNA857143_S_NODE_155782_length_262_cov_1.650794_g154689_i0 | PRJNA857143 | 155782 | 262 | 1.650794 | 4.32508028 | Methanobacterium alkalithermotolerans | 2731220 | Archaea | Archaea | 61.6 | 1.03e-8 | NR | WP_211532742.1 | 2731220 | g154689 | i0 | 41.1 | 1.08778625954198 | 95 | 48 | 99.6 | 2 | 262 | 2 | 352 | 446 | WP_211532742.1 glutamine synthetase family protein [Methanobacterium alkalithermotolerans] | diamond | 285 | 61.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium alkalithermotolerans | |
| 27379544 | 27379544 | PRJNA857143_S_NODE_129223_length_284_cov_1.109005_g128130_i0 | PRJNA857143 | 129223 | 284 | 1.109005 | 3.1495742 | root | 1 | Root_unresolved | Root_unresolved | 76.3 | 1.18e-14 | NR | WP_013899219.1 | 39669 | g128130 | i0 | 50 | 4.32042253521127 | 66 | 33 | 69.7 | 0 | 15 | 212 | 136 | 201 | WP_013899219.1 NAD(P)H:quinone oxidoreductase [Methanosalsum zhilinae] | diamond | 1227 | 76.6 | 0.996083550913838 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosalsum | Methanosalsum zhilinae | |
| 29865512 | 29865512 | PRJNA857143_S_NODE_59791_length_374_cov_1.186047_g58698_i0 | PRJNA857143 | 59791 | 374 | 1.186047 | 4.43581578 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 67 | 4.01e-10 | NR | MAW93540.1 | 2026739 | g58698 | i0 | 40 | 2.05347593582888 | 85 | 47 | 67.4 | 3 | 372 | 121 | 262 | 343 | MAW93540.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 768 | 67 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30149653 | 30149653 | PRJNA857143_S_NODE_181512_length_248_cov_0.874286_g180419_i0 | PRJNA857143 | 181512 | 248 | 0.874286 | 2.16822928 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 84.7 | 6.79e-17 | NR | MBU38165.1 | 2026739 | g180419 | i0 | 45 | 3.89516129032258 | 80 | 43 | 95.6 | 1 | 1 | 237 | 1718 | 1797 | MBU38165.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 966 | 84.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30221099 | 30221099 | PRJNA857143_S_NODE_111772_length_300_cov_2.471366_g110679_i0 | PRJNA857143 | 111772 | 300 | 2.471366 | 7.414098 | root | 1 | Root_unresolved | Root_unresolved | 54.3 | 6.05e-6 | NR | GIR77113.1 | 2026739 | g110679 | i0 | 52.9 | 2.07 | 34 | 16 | 34 | 0 | 30 | 131 | 347 | 380 | GIR77113.1 MAG: hypothetical protein CM15mP79_0500 [Methanobacteriota archaeon] | diamond | 621 | 54.3 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30497498 | 30497498 | PRJNA857143_S_NODE_128873_length_284_cov_1.691943_g127780_i0 | PRJNA857143 | 128873 | 284 | 1.691943 | 4.80511812 | Halorussus salilacus | 2953750 | Archaea | Archaea | 43.1 | 0.0096 | NR | WP_253484577.1 | 2953750 | g127780 | i0 | 35.9 | 0.823943661971831 | 78 | 46 | 82.4 | 2 | 241 | 8 | 17 | 90 | WP_253484577.1 hypothetical protein [Halorussus salilacus] | diamond | 234 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus salilacus | |
| 30789908 | 30789908 | PRJNA857143_S_NODE_31894_length_456_cov_3.522193_g30802_i0 | PRJNA857143 | 31894 | 456 | 3.522193 | 16.06120008 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 3.85e-6 | NR | MTK63112.1 | 2164 | g30802 | i0 | 49.2 | 2.28289473684211 | 63 | 32 | 41.4 | 0 | 441 | 253 | 130 | 192 | MTK63112.1 hypothetical protein [Methanobacterium sp.] | diamond | 1041 | 56.2 | 0.99288256227758 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 31168853 | 31168853 | PRJNA857143_S_NODE_196915_length_238_cov_2.363636_g195822_i0 | PRJNA857143 | 196915 | 238 | 2.363636 | 5.62545368 | root | 1 | Root_unresolved | Root_unresolved | 47 | 7.87e-4 | NR | MES3517679.1 | 2184060 | g195822 | i0 | 55.6 | 2.4453781512605 | 45 | 18 | 54.2 | 1 | 26 | 154 | 156 | 200 | MES3517679.1 adenylate kinase [Natronomonas sp.] | diamond | 582 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. | |
| 31951583 | 31951583 | PRJNA857143_S_NODE_96757_length_317_cov_1.278689_g95664_i0 | PRJNA857143 | 96757 | 317 | 1.278689 | 4.05344413 | Methanoculleus horonobensis | 528314 | Archaea | Archaea | 73.9 | 8.58e-14 | NR | MDD3071926.1 | 528314 | g95664 | i0 | 41 | 1.93059936908517 | 100 | 51 | 94.6 | 2 | 16 | 315 | 38 | 129 | MDD3071926.1 sialidase family protein [Methanoculleus horonobensis] | diamond | 612 | 73.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus horonobensis |
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);;