contig_metadata
13 rows where bioproject = "PRJNA605033" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1857669 | 1857669 | PRJNA605033_P_NODE_165622_length_183_cov_1.229730_g164053_i0 | PRJNA605033 | 165622 | 183 | 1.22973 | 2.2504059 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 67.6 | 5.57e-7 | NTclustered | gi|2108123351|gb|CP070732.1| | 2026739 | g164053 | i0 | 100 | 4.11475409836066 | 36 | 0 | 20 | 0 | 6 | 41 | 1649628 | 1649593 | MAG: Methanobacteriota archaeon isolate bin41 chromosome | blastn | 753 | 67.6 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 3697509 | 3697509 | PRJNA605033_P_NODE_88623_length_222_cov_2.219251_g87054_i0 | PRJNA605033 | 88623 | 222 | 2.219251 | 4.92673722 | Halobacteriales | 2235 | Archaea | Archaea | 111 | 3.2e-20 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g87054 | i0 | 95.652 | 1.52702702702703 | 69 | 3 | 31 | 0 | 1 | 69 | 1318414 | 1318482 | Halalkalicoccus jeotgali B3, complete genome | blastn | 339 | 111 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 10073213 | 10073213 | PRJNA605033_P_NODE_11388_length_412_cov_2.628647_g9857_i0 | PRJNA605033 | 11388 | 412 | 2.628647 | 10.83002564 | Thermococcus | 2263 | Archaea | Archaea | 256 | 1.69e-78 | NR | MEO2152736.1 | 35749 | g9857 | i0 | 98.5 | 17.8252427184466 | 136 | 2 | 99 | 0 | 3 | 410 | 511 | 646 | MEO2152736.1 DNA polymerase domain-containing protein [Thermococcus sp.] | diamond | 7344 | 256 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. | ||
| 10074371 | 10074371 | PRJNA605033_P_NODE_66048_length_222_cov_3.737968_g64479_i0 | PRJNA605033 | 66048 | 222 | 3.737968 | 8.29828896 | Halorubrum | 56688 | Archaea | Archaea | 52.8 | 0.02 | NTclustered | gi|1540603140|gb|CP030064.1| | 634157 | g64479 | i0 | 100 | 0.252252252252252 | 28 | 0 | 13 | 0 | 160 | 187 | 2695383 | 2695356 | Halorubrum sp. PV6 chromosome, complete genome | blastn | 56 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. PV6 | |
| 19708237 | 19708237 | PRJNA605033_P_NODE_1576_length_1291_cov_2.747611_g758_i0 | PRJNA605033 | 1576 | 1291 | 2.747611 | 35.47165801 | Thermococcus | 2263 | Archaea | Archaea | 807 | 1.87e-276 | NR | WP_014121997.1 | 246969 | g758 | i0 | 88 | 2.16576297443842 | 466 | 20 | 99.9 | 3 | 2 | 1291 | 1 | 466 | WP_014121997.1 DNA polymerase domain-containing protein [Thermococcus sp. AM4] | diamond | 2796 | 807 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. AM4 | ||
| 20983543 | 20983543 | PRJNA605033_P_NODE_113997_length_222_cov_1.727273_g112428_i0 | PRJNA605033 | 113997 | 222 | 1.727273 | 3.83454606 | Halorubrum ezzemoulense | 337243 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|1565814486|gb|CP034940.1| | 337243 | g112428 | i0 | 96.97 | 0.148648648648649 | 33 | 1 | 15 | 0 | 188 | 220 | 2855919 | 2855951 | Halorubrum ezzemoulense strain Fb21 chromosome, complete genome | blastn | 33 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum ezzemoulense | |
| 22260332 | 22260332 | PRJNA605033_P_NODE_93758_length_222_cov_2.096257_g92189_i0 | PRJNA605033 | 93758 | 222 | 2.096257 | 4.65369054 | Haloplanus aerogenes | 660522 | Archaea | Archaea | 102 | 1.93e-17 | NTclustered | gi|1526250537|gb|CP034145.1| | 660522 | g92189 | i0 | 91.781 | 0.657657657657658 | 73 | 6 | 33 | 0 | 3 | 75 | 1832118 | 1832046 | Haloplanus aerogenes strain JCM 16430 chromosome, complete genome | blastn | 146 | 102 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus aerogenes | |
| 24809335 | 24809335 | PRJNA605033_P_NODE_64140_length_222_cov_4.679144_g62571_i0 | PRJNA605033 | 64140 | 222 | 4.679144 | 10.38769968 | Halovenus aranensis | 890420 | Archaea | Archaea | 67.8 | 3.8e-11 | NR | SDJ86709.1 | 890420 | g62571 | i0 | 46.6 | 0.986486486486487 | 73 | 30 | 98.6 | 1 | 220 | 2 | 271 | 334 | SDJ86709.1 Transposase DDE domain-containing protein [Halovenus aranensis] | diamond | 219 | 67.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halovenus | Halovenus aranensis | |
| 24809379 | 24809379 | PRJNA605033_P_NODE_72540_length_222_cov_2.914439_g70971_i0 | PRJNA605033 | 72540 | 222 | 2.914439 | 6.47005458 | Halalkalicoccus salilacus | 3117459 | Archaea | Archaea | 110 | 1.15e-19 | NTclustered | gi|2674869203|gb|CP144461.1| | 3117459 | g70971 | i0 | 93.243 | 5.26576576576577 | 74 | 5 | 33 | 0 | 1 | 74 | 620372 | 620445 | Halalkalicoccus salilacus strain FCH27 chromosome, complete genome | blastn | 1169 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus salilacus | |
| 26935006 | 26935006 | PRJNA605033_P_NODE_153282_length_191_cov_3.147436_g151713_i0 | PRJNA605033 | 153282 | 191 | 3.147436 | 6.01160276 | Thermococcus | 2263 | Archaea | Archaea | 133 | 2.07e-34 | NR | WP_167728776.1 | 163002 | g151713 | i0 | 100 | 4.94764397905759 | 63 | 0 | 99 | 0 | 2 | 190 | 1761 | 1823 | WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3] | diamond | 945 | 133 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. 9N3 | ||
| 28596069 | 28596069 | PRJNA605033_P_NODE_109247_length_222_cov_1.807487_g107678_i0 | PRJNA605033 | 109247 | 222 | 1.807487 | 4.01262114 | Methanospirillum sp. | 45200 | Archaea | Archaea | 50.1 | 7.37e-5 | NR | MBP9009538.1 | 45200 | g107678 | i0 | 41.1 | 1.97297297297297 | 73 | 20 | 98.6 | 1 | 219 | 1 | 199 | 248 | MBP9009538.1 DNA cytosine methyltransferase [Methanospirillum sp.] | diamond | 438 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 30585416 | 30585416 | PRJNA605033_P_NODE_180613_length_174_cov_6.985612_g179044_i0 | PRJNA605033 | 180613 | 174 | 6.985612 | 12.15496488 | Pyrococcus furiosus | 2261 | Archaea | Archaea | 110 | 1.47e-26 | NR | 4AHC_A | 2261 | g179044 | i0 | 96.5 | 0.982758620689655 | 57 | 2 | 98.3 | 0 | 172 | 2 | 131 | 187 | 4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus] | diamond | 171 | 110 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 32229986 | 32229986 | PRJNA605033_P_NODE_170558_length_180_cov_1.379310_g168989_i0 | PRJNA605033 | 170558 | 180 | 1.37931 | 2.482758 | Halobaculum sp. | 1891221 | Archaea | Archaea | 40 | 0.0495 | NR | MFB6177911.1 | 1891221 | g168989 | i0 | 35.8 | 0.883333333333333 | 53 | 28 | 78.3 | 1 | 177 | 37 | 49 | 101 | MFB6177911.1 AAA family ATPase [Halobaculum sp.] | diamond | 159 | 40 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum sp. |
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);;