contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5271814 | 5271814 | PRJNA1035005_P_NODE_57805_length_252_cov_0.871508_g57399_i0 | PRJNA1035005 | 57805 | 252 | 0.871508 | 2.19620016 | root | 1 | Root_unresolved | Root_unresolved | 79.7 | 3.19e-15 | NR | MCX9085574.1 | 2032688 | g57399 | i0 | 48.2 | 9.77380952380952 | 83 | 42 | 98.8 | 1 | 249 | 1 | 215 | 296 | MCX9085574.1 DEAD/DEAH box helicase [Candidatus Methanoperedens sp.] | diamond | 2463 | 79.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 23121486 | 23121486 | PRJNA1035005_P_NODE_9999_length_364_cov_2.041237_g9594_i0 | PRJNA1035005 | 9999 | 364 | 2.041237 | 7.43010268 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 204 | 3.8999999999999995e-62 | NR | MBX7076500.1 | 2099680 | g9594 | i0 | 81.4 | 0.972527472527473 | 118 | 22 | 97.3 | 0 | 357 | 4 | 12 | 129 | MBX7076500.1 elongation factor Tu [Methanobacteriaceae archaeon] | diamond | 354 | 204 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 27161300 | 27161300 | PRJNA1035005_P_NODE_58762_length_251_cov_1.443820_g58356_i0 | PRJNA1035005 | 58762 | 251 | 1.44382 | 3.6239882 | Haloferax sp. Atlit-1 | 2253 | Archaea | Archaea | 112 | 2.64e-30 | NR | WP_119712927.1 | 2077204 | g58356 | i0 | 88.6 | 0.836653386454183 | 70 | 8 | 83.7 | 0 | 251 | 42 | 31 | 100 | WP_119712927.1 hypothetical protein [Haloferax sp. Atlit-10N] | diamond | 210 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. Atlit-10N | |
| 27627618 | 27627618 | PRJNA1035005_P_NODE_24544_length_290_cov_1.078341_g24138_i0 | PRJNA1035005 | 24544 | 290 | 1.078341 | 3.1271889 | root | 1 | Root_unresolved | Root_unresolved | 47 | 0.00203 | NR | WP_109968281.1 | 668570 | g24138 | i0 | 51.6 | 0.589655172413793 | 31 | 15 | 32.1 | 0 | 138 | 230 | 273 | 303 | WP_109968281.1 Coenzyme F420 hydrogenase/dehydrogenase, beta subunit C-terminal domain [Methanospirillum lacunae] | diamond | 171 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum lacunae | |
| 27659219 | 27659219 | PRJNA1035005_P_NODE_26744_length_287_cov_1.224299_g26338_i0 | PRJNA1035005 | 26744 | 287 | 1.224299 | 3.51373813 | Methanobacteriota | 28890 | Archaea | Archaea | 85.1 | 7.28e-17 | NR | MCZ7358014.1 | 2032688 | g26338 | i0 | 58 | 2.05923344947735 | 69 | 28 | 72.1 | 1 | 80 | 286 | 305 | 372 | MCZ7358014.1 proline--tRNA ligase [Candidatus Methanoperedens sp.] | diamond | 591 | 85.5 | 0.9953216374269 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 28140884 | 28140884 | PRJNA1035005_P_NODE_23465_length_291_cov_1.431193_g23059_i0 | PRJNA1035005 | 23465 | 291 | 1.431193 | 4.16477163 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 43.9 | 0.00762 | NR | MBO7695419.1 | 66852 | g23059 | i0 | 44.2 | 1.11340206185567 | 52 | 25 | 52.6 | 2 | 14 | 166 | 3 | 51 | MBO7695419.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 324 | 43.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28298412 | 28298412 | PRJNA1035005_P_NODE_40986_length_268_cov_1.600000_g40580_i0 | PRJNA1035005 | 40986 | 268 | 1.6 | 4.288 | Haloarcula sp. K1 | 1622207 | Archaea | Archaea | 152 | 1.59e-41 | NR | WP_064289135.1 | 1622207 | g40580 | i0 | 80.7 | 0.985074626865672 | 88 | 17 | 98.5 | 0 | 266 | 3 | 133 | 220 | WP_064289135.1 DUF6610 family protein [Haloarcula sp. K1] | diamond | 264 | 152 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula sp. K1 | |
| 28298430 | 28298430 | PRJNA1035005_P_NODE_82946_length_243_cov_0.917647_g82540_i0 | PRJNA1035005 | 82946 | 243 | 0.917647 | 2.22988221 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 92.8 | 2.84e-22 | NR | MBQ6630168.1 | 66852 | g82540 | i0 | 61.3 | 0.925925925925926 | 75 | 27 | 90.1 | 1 | 9 | 227 | 40 | 114 | MBQ6630168.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 225 | 92.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28488059 | 28488059 | PRJNA1035005_P_NODE_87127_length_239_cov_2.090361_g86721_i0 | PRJNA1035005 | 87127 | 239 | 2.090361 | 4.99596279 | Halorarum salinum | 2743089 | Archaea | Archaea | 87.4 | 2.27e-19 | NR | WP_179269447.1 | 2743089 | g86721 | i0 | 66.1 | 0.740585774058577 | 59 | 20 | 74.1 | 0 | 230 | 54 | 9 | 67 | WP_179269447.1 hypothetical protein [Halorarum salinum] | diamond | 177 | 87.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorarum | Halorarum salinum | |
| 29151354 | 29151354 | PRJNA1035005_P_NODE_26089_length_288_cov_1.097674_g25683_i0 | PRJNA1035005 | 26089 | 288 | 1.097674 | 3.16130112 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 190 | 3.2400000000000002e-59 | NR | WP_181691241.1 | 2750669 | g25683 | i0 | 98.9 | 0.989583333333333 | 95 | 1 | 99 | 0 | 286 | 2 | 54 | 148 | WP_181691241.1 DUF7114 family protein [Natronomonas sp. LN261] | diamond | 285 | 190 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 29624090 | 29624090 | PRJNA1035005_P_NODE_12110_length_344_cov_0.863469_g11705_i0 | PRJNA1035005 | 12110 | 344 | 0.863469 | 2.97033336 | Thermococcus | 2263 | Archaea | Archaea | 89.4 | 2.22e-19 | NR | WP_076612194.1 | 2263 | g11705 | i0 | 47.7 | 1.88372093023256 | 111 | 53 | 92.4 | 3 | 329 | 12 | 59 | 169 | WP_076612194.1 MULTISPECIES: IS607-like element ISTsi1 family transposase [Thermococcus] | diamond | 648 | 89.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | |||
| 32564813 | 32564813 | PRJNA1035005_P_NODE_41519_length_267_cov_2.979381_g41113_i0 | PRJNA1035005 | 41519 | 267 | 2.979381 | 7.95494727 | Haladaptatus sp. CMSO5 | 3120514 | Archaea | Archaea | 63.9 | 1.7e-9 | NR | WP_332900305.1 | 3120514 | g41113 | i0 | 42.2 | 0.932584269662921 | 83 | 48 | 93.3 | 0 | 262 | 14 | 228 | 310 | WP_332900305.1 archaea-specific SMC-related protein [Haladaptatus sp. CMSO5] | diamond | 249 | 63.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus sp. CMSO5 | |
| 32596116 | 32596116 | PRJNA1035005_P_NODE_65500_length_249_cov_0.886364_g65094_i0 | PRJNA1035005 | 65500 | 249 | 0.886364 | 2.20704636 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 59.7 | 4.17e-8 | NR | MEE3325102.1 | 2666342 | g65094 | i0 | 40 | 1.72289156626506 | 70 | 42 | 84.3 | 0 | 214 | 5 | 408 | 477 | MEE3325102.1 hypothetical protein [Methanosphaera sp.] | diamond | 429 | 59.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 32784816 | 32784816 | PRJNA1035005_P_NODE_4080_length_529_cov_1.614035_g3682_i0 | PRJNA1035005 | 4080 | 529 | 1.614035 | 8.53824515 | Methanoregula sp. | 2052170 | Archaea | Archaea | 60.8 | 3.45e-7 | NR | MFA7304797.1 | 2052170 | g3682 | i0 | 29.8 | 1.32703213610586 | 114 | 73 | 64.7 | 3 | 525 | 184 | 22 | 128 | MFA7304797.1 NosD domain-containing protein [Methanoregula sp.] | diamond | 702 | 60.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula 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);;