contig_metadata
13 rows where bioproject = "PRJNA1123309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18130153 | 18130153 | PRJNA1123309_P_NODE_43835_length_261_cov_1.228723_g43455_i0 | PRJNA1123309 | 43835 | 261 | 1.228723 | 3.20696703 | Pyrococcus furiosus | 2261 | Archaea | Archaea | 177 | 6.94e-50 | NR | 4AHC_A | 2261 | g43455 | i0 | 100 | 9.88505747126437 | 86 | 0 | 98.9 | 0 | 3 | 260 | 206 | 291 | 4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus] | diamond | 2580 | 177 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 20155400 | 20155400 | PRJNA1123309_P_NODE_39096_length_273_cov_1.160000_g38716_i0 | PRJNA1123309 | 39096 | 273 | 1.16 | 3.1668 | root | 1 | Root_unresolved | Root_unresolved | 492 | 1.2499999999999996e-134 | NTclustered | gi|2515741548|gb|CP117271.1| | 2209 | g38716 | i0 | 100 | 98.0476190476191 | 266 | 0 | 97 | 0 | 1 | 266 | 3941703 | 3941968 | Mutant Methanosarcina mazei strain Mm Mut 208, complete genome | blastn | 26767 | 492 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina mazei | |
| 23230732 | 23230732 | PRJNA1123309_P_NODE_46699_length_253_cov_1.700000_g46319_i0 | PRJNA1123309 | 46699 | 253 | 1.7 | 4.301 | Salinirarus marinus | 3068310 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g46319 | i0 | 96.97 | 0.130434782608696 | 33 | 1 | 13 | 0 | 180 | 212 | 930919 | 930887 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 33 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 26626990 | 26626990 | PRJNA1123309_P_NODE_53601_length_249_cov_1.301136_g53221_i0 | PRJNA1123309 | 53601 | 249 | 1.301136 | 3.23982864 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 47 | 0.00127 | NR | RJU88526.1 | 2163009 | g53221 | i0 | 40.8 | 0.855421686746988 | 71 | 40 | 85.5 | 1 | 23 | 235 | 485 | 553 | RJU88526.1 MAG: hypothetical protein DWC02_01490, partial [Candidatus Poseidoniales archaeon] | diamond | 213 | 47 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 27280733 | 27280733 | PRJNA1123309_P_NODE_30843_length_293_cov_3.581818_g30463_i0 | PRJNA1123309 | 30843 | 293 | 3.581818 | 10.49472674 | root | 1 | Root_unresolved | Root_unresolved | 205 | 6.86e-60 | NR | 4AHC_A | 2261 | g30463 | i0 | 100 | 1.98634812286689 | 97 | 0 | 99.3 | 0 | 293 | 3 | 422 | 518 | 4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus] | diamond | 582 | 205 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 27323084 | 27323084 | PRJNA1123309_P_NODE_15463_length_393_cov_1.896875_g15084_i0 | PRJNA1123309 | 15463 | 393 | 1.896875 | 7.45471875 | Pyrococcus furiosus | 2261 | Archaea | Archaea | 261 | 2.73e-80 | NR | 4AHC_A | 2261 | g15084 | i0 | 97.7 | 1 | 131 | 3 | 100 | 0 | 393 | 1 | 14 | 144 | 4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus] | diamond | 393 | 261 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 27828346 | 27828346 | PRJNA1123309_P_NODE_57304_length_247_cov_0.896552_g56924_i0 | PRJNA1123309 | 57304 | 247 | 0.896552 | 2.21448344 | Candidatus Methanophagales archaeon | 2056316 | Archaea | Archaea | 46.6 | 0.00168 | NR | MCD6210180.1 | 2056316 | g56924 | i0 | 46.8 | 2.89068825910931 | 47 | 25 | 57.1 | 0 | 32 | 172 | 53 | 99 | MCD6210180.1 transposase [Candidatus Methanophagales archaeon] | diamond | 714 | 46.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagales archaeon | |||
| 27954621 | 27954621 | PRJNA1123309_P_NODE_26725_length_312_cov_2.974895_g26345_i0 | PRJNA1123309 | 26725 | 312 | 2.974895 | 9.2816724 | Methanocella arvoryzae | 1175445 | Archaea | Archaea | 65.5 | 8.38e-10 | NR | WP_012035946.1 | 1175445 | g26345 | i0 | 68.1 | 0.451923076923077 | 47 | 15 | 45.2 | 0 | 303 | 163 | 35 | 81 | WP_012035946.1 prephenate dehydrogenase/arogenate dehydrogenase family protein [Methanocella arvoryzae] | diamond | 141 | 65.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella arvoryzae | |
| 28575225 | 28575225 | PRJNA1123309_P_NODE_29567_length_299_cov_1.292035_g29187_i0 | PRJNA1123309 | 29567 | 299 | 1.292035 | 3.86318465 | root | 1 | Root_unresolved | Root_unresolved | 64.3 | 6.13e-10 | NR | HLF07260.1 | 1906666 | g29187 | i0 | 62.5 | 2.47826086956522 | 48 | 18 | 48.2 | 0 | 285 | 142 | 166 | 213 | HLF07260.1 GTP cyclohydrolase II [Thermoplasmata archaeon] | diamond | 741 | 64.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28996836 | 28996836 | PRJNA1123309_P_NODE_52088_length_250_cov_0.881356_g51708_i0 | PRJNA1123309 | 52088 | 250 | 0.881356 | 2.20339 | Candidatus Methanogaster sp. ANME-2c ERB4 | 2759911 | Archaea | Archaea | 93.2 | 4.19e-20 | NR | QNO45974.1 | 2759911 | g51708 | i0 | 71 | 2.232 | 62 | 18 | 74.4 | 0 | 65 | 250 | 1 | 62 | QNO45974.1 hypothetical protein EBOGGPCF_00019 [Candidatus Methanogaster sp. ANME-2c ERB4] | diamond | 558 | 93.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanogasteraceae | Candidatus Methanogaster | Candidatus Methanogaster sp. ANME-2c ERB4 | |
| 29996359 | 29996359 | PRJNA1123309_P_NODE_9431_length_490_cov_2.268585_g9056_i0 | PRJNA1123309 | 9431 | 490 | 2.268585 | 11.1160665 | root | 1 | Root_unresolved | Root_unresolved | 309 | 5.14e-98 | NR | 4AHC_A | 2261 | g9056 | i0 | 100 | 1.91632653061225 | 156 | 0 | 95.5 | 0 | 3 | 470 | 620 | 775 | 4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus] | diamond | 939 | 310 | 0.996774193548387 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 30702046 | 30702046 | PRJNA1123309_P_NODE_13074_length_423_cov_1.297143_g12698_i0 | PRJNA1123309 | 13074 | 423 | 1.297143 | 5.48691489 | Candidatus Methanocrinis natronophilus | 3033396 | Archaea | Archaea | 48.9 | 0.00161 | NR | WP_316965640.1 | 3033396 | g12698 | i0 | 28.5 | 0.971631205673759 | 137 | 85 | 93.6 | 6 | 414 | 19 | 58 | 186 | WP_316965640.1 PQQ-binding-like beta-propeller repeat protein [Candidatus Methanocrinis natronophilus] | diamond | 411 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanocrinis | Candidatus Methanocrinis natronophilus | |
| 31903438 | 31903438 | PRJNA1123309_P_NODE_52297_length_250_cov_0.881356_g51917_i0 | PRJNA1123309 | 52297 | 250 | 0.881356 | 2.20339 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 70.9 | 2.84e-12 | NR | RLF65297.1 | 1906666 | g51917 | i0 | 50.8 | 0.732 | 61 | 30 | 73.2 | 0 | 184 | 2 | 192 | 252 | RLF65297.1 MAG: hypothetical protein DRN30_04235 [Thermoplasmata archaeon] | diamond | 183 | 70.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata 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);;