contig_metadata
9 rows where bioproject = "PRJNA1237347", tax_phylum = "Promethearchaeota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28178135 | 28178135 | PRJNA1237347_P_NODE_247586_length_377_cov_1.213816_g241013_i0 | PRJNA1237347 | 247586 | 377 | 1.213816 | 4.57608632 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 44.7 | 0.0188 | NR | MBD3351332.1 | 2053489 | g241013 | i0 | 31.6 | 0.755968169761273 | 95 | 63 | 75.6 | 2 | 67 | 351 | 28 | 120 | MBD3351332.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 285 | 44.7 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28431137 | 28431137 | PRJNA1237347_P_NODE_283346_length_346_cov_1.476190_g276773_i0 | PRJNA1237347 | 283346 | 346 | 1.47619 | 5.1076174 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 169 | 2.24e-50 | NR | MBN1803085.1 | 2053489 | g276773 | i0 | 68.4 | 1.97687861271676 | 114 | 36 | 98.8 | 0 | 344 | 3 | 115 | 228 | MBN1803085.1 ribose 5-phosphate isomerase A [Promethearchaeota archaeon] | diamond | 684 | 169 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28557306 | 28557306 | PRJNA1237347_P_NODE_160527_length_501_cov_1.799065_g153966_i0 | PRJNA1237347 | 160527 | 501 | 1.799065 | 9.01331565 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 65.5 | 7.33e-9 | NR | NHI92814.1 | 2053489 | g153966 | i0 | 38.1 | 3.5688622754491 | 105 | 59 | 59.9 | 3 | 39 | 338 | 3375 | 3478 | NHI92814.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 1788 | 65.5 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29220789 | 29220789 | PRJNA1237347_P_NODE_461609_length_255_cov_1.016484_g455036_i0 | PRJNA1237347 | 461609 | 255 | 1.016484 | 2.5920342 | Promethearchaeum syntrophicum | 2594042 | Archaea | Archaea | 140 | 2.54e-36 | NR | WP_147663262.1 | 2594042 | g455036 | i0 | 69 | 0.988235294117647 | 84 | 26 | 98.8 | 0 | 253 | 2 | 166 | 249 | WP_147663262.1 SIR2 family protein [Promethearchaeum syntrophicum] | diamond | 252 | 140 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Promethearchaeum | Promethearchaeum syntrophicum | ||
| 29441032 | 29441032 | PRJNA1237347_P_NODE_217890_length_410_cov_1.195846_g211318_i0 | PRJNA1237347 | 217890 | 410 | 1.195846 | 4.9029686 | Candidatus Harpocratesius repetitus | 3049170 | Archaea | Archaea | 49.3 | 0.00111 | NR | MCF2139066.1 | 3049170 | g211318 | i0 | 28.3 | 0.929268292682927 | 127 | 73 | 89.3 | 3 | 369 | 4 | 6 | 119 | MCF2139066.1 GTP-binding protein [Candidatus Harpocratesius repetitus] | diamond | 381 | 49.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Candidatus Harpocratesius | Candidatus Harpocratesius repetitus | ||
| 29712188 | 29712188 | PRJNA1237347_P_NODE_349330_length_303_cov_3.143478_g342757_i0 | PRJNA1237347 | 349330 | 303 | 3.143478 | 9.52473834 | root | 1 | Root_unresolved | Root_unresolved | 47 | 0.00235 | NR | TFG18915.1 | 2053489 | g342757 | i0 | 44.1 | 2.9009900990099 | 59 | 33 | 58.4 | 0 | 115 | 291 | 2 | 60 | TFG18915.1 MAG: 3-hydroxyacyl-CoA dehydrogenase family protein [Promethearchaeota archaeon] | diamond | 879 | 47.4 | 0.991561181434599 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 31336762 | 31336762 | PRJNA1237347_P_NODE_212256_length_417_cov_1.290698_g205684_i0 | PRJNA1237347 | 212256 | 417 | 1.290698 | 5.38221066 | Promethearchaeota archaeon CR_4 | 1849166 | Archaea | Archaea | 78.2 | 2.1e-15 | NR | OLS12533.1 | 1849166 | g205684 | i0 | 35.4 | 0.913669064748201 | 127 | 78 | 91.4 | 3 | 381 | 1 | 7 | 129 | OLS12533.1 MAG: hypothetical protein RBG13Loki_3844 [Promethearchaeota archaeon CR_4] | diamond | 381 | 78.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon CR_4 | ||||||
| 31969287 | 31969287 | PRJNA1237347_P_NODE_111378_length_636_cov_1.777975_g104904_i0 | PRJNA1237347 | 111378 | 636 | 1.777975 | 11.307921 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 166 | 3.4799999999999997e-46 | NR | MCK4285265.1 | 2053489 | g104904 | i0 | 43.3 | 1.02358490566038 | 217 | 112 | 98.6 | 6 | 635 | 9 | 9 | 222 | MCK4285265.1 actin family protein [Promethearchaeota archaeon] | diamond | 651 | 166 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 32444696 | 32444696 | PRJNA1237347_P_NODE_451919_length_258_cov_2.043243_g445346_i0 | PRJNA1237347 | 451919 | 258 | 2.043243 | 5.27156694 | Candidatus Harpocratesius repetitus | 3049170 | Archaea | Archaea | 42.7 | 0.00775 | NR | MCF2140270.1 | 3049170 | g445346 | i0 | 44.4 | 0.883720930232558 | 45 | 25 | 52.3 | 0 | 164 | 30 | 4 | 48 | MCF2140270.1 cold-shock protein [Candidatus Harpocratesius repetitus] | diamond | 228 | 42.7 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Candidatus Harpocratesius | Candidatus Harpocratesius repetitus |
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);;