contig_metadata
24 rows where bioproject = "PRJNA827593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2096501 | 2096501 | PRJNA827593_P_NODE_25422_length_416_cov_1.244898_g25123_i0 | PRJNA827593 | 25422 | 416 | 1.244898 | 5.17877568 | root | 1 | Root_unresolved | Root_unresolved | 192 | 9.59e-54 | NR | WP_324474872.1 | 45200 | g25123 | i0 | 65.2 | 12.9447115384615 | 138 | 47 | 99.5 | 1 | 3 | 416 | 558 | 694 | WP_324474872.1 type I restriction endonuclease subunit R [Methanospirillum sp.] | diamond | 5385 | 192 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 8474047 | 8474047 | PRJNA827593_P_NODE_36987_length_335_cov_3.675573_g36688_i0 | PRJNA827593 | 36987 | 335 | 3.675573 | 12.31316955 | Methanosarcina acetivorans | 2214 | Archaea | Archaea | 52.8 | 0.032 | NTclustered | gi|19918815|gb|AE010299.1| | 188937 | g36688 | i0 | 100 | 0.0835820895522388 | 28 | 0 | 8 | 0 | 230 | 257 | 2077152 | 2077179 | Methanosarcina acetivorans str. C2A, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina acetivorans | |
| 12300181 | 12300181 | PRJNA827593_P_NODE_24950_length_420_cov_1.902017_g24651_i0 | PRJNA827593 | 24950 | 420 | 1.902017 | 7.9884714 | Natrarchaeobaculum aegyptiacum | 745377 | Archaea | Archaea | 56.5 | 0.003 | NTclustered | gi|1196598842|gb|CP019893.1| | 745377 | g24651 | i0 | 100 | 0.0714285714285714 | 30 | 0 | 7 | 0 | 44 | 73 | 2973647 | 2973618 | Natrarchaeobaculum aegyptiacum strain JW/NM-HA 15 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrarchaeobaculum | Natrarchaeobaculum aegyptiacum | |
| 17399242 | 17399242 | PRJNA827593_P_NODE_22634_length_444_cov_1.207547_g22335_i0 | PRJNA827593 | 22634 | 444 | 1.207547 | 5.36150868 | Thermococcus sp. GR5 | 1638255 | Archaea | Archaea | 176 | 4.9999999999999996e-54 | NR | WP_167731702.1 | 1638255 | g22335 | i0 | 97.8 | 0.608108108108108 | 90 | 2 | 60.8 | 0 | 174 | 443 | 1 | 90 | WP_167731702.1 ABC transporter ATP-binding protein, partial [Thermococcus sp. GR5] | diamond | 270 | 176 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. GR5 | ||
| 25047873 | 25047873 | PRJNA827593_P_NODE_58460_length_258_cov_1.659459_g58161_i0 | PRJNA827593 | 58460 | 258 | 1.659459 | 4.28140422 | Haloferax mediterranei | 2252 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|640913992|gb|CP001868.2| | 523841 | g58161 | i0 | 100 | 0.325581395348837 | 28 | 0 | 11 | 0 | 18 | 45 | 2426173 | 2426146 | Haloferax mediterranei ATCC 33500, complete genome | blastn | 84 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax mediterranei | |
| 26619931 | 26619931 | PRJNA827593_P_NODE_17401_length_514_cov_3.716553_g17103_i0 | PRJNA827593 | 17401 | 514 | 3.716553 | 19.10308242 | root | 1 | Root_unresolved | Root_unresolved | 108 | 5.2699999999999994e-24 | NR | MDD4580503.1 | 90426 | g17103 | i0 | 54.2 | 1.86186770428016 | 107 | 48 | 61.9 | 1 | 414 | 97 | 1 | 107 | MDD4580503.1 glycosyltransferase [Methanothrix sp.] | diamond | 957 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 26737497 | 26737497 | PRJNA827593_P_NODE_10301_length_688_cov_2.422764_g10011_i0 | PRJNA827593 | 10301 | 688 | 2.422764 | 16.66861632 | Thermococcus sp. M36 | 1638261 | Archaea | Archaea | 259 | 1.95e-85 | NR | WP_167895510.1 | 1638261 | g10011 | i0 | 100 | 0.571220930232558 | 131 | 0 | 57.1 | 0 | 259 | 651 | 1 | 131 | WP_167895510.1 hypothetical protein [Thermococcus sp. M36] | diamond | 393 | 259 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. M36 | ||
| 27031431 | 27031431 | PRJNA827593_P_NODE_19842_length_478_cov_1.661728_g19544_i0 | PRJNA827593 | 19842 | 478 | 1.661728 | 7.94305984 | root | 1 | Root_unresolved | Root_unresolved | 221 | 1.85e-70 | NR | WP_167895507.1 | 1638261 | g19544 | i0 | 100 | 1.30543933054393 | 104 | 0 | 65.3 | 0 | 312 | 1 | 1 | 104 | WP_167895507.1 hypothetical protein, partial [Thermococcus sp. M36] | diamond | 624 | 221 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. M36 | ||
| 27086192 | 27086192 | PRJNA827593_P_NODE_21242_length_460_cov_1.297158_g20944_i0 | PRJNA827593 | 21242 | 460 | 1.297158 | 5.9669268 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 67.8 | 7.33e-10 | NR | RYE99733.1 | 2026739 | g20944 | i0 | 48.8 | 0.521739130434783 | 80 | 40 | 52.2 | 1 | 250 | 11 | 7 | 85 | RYE99733.1 MAG: hypothetical protein EOO41_00630, partial [Methanobacteriota archaeon] | diamond | 240 | 67.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27244155 | 27244155 | PRJNA827593_P_NODE_35903_length_341_cov_1.958955_g35604_i0 | PRJNA827593 | 35903 | 341 | 1.958955 | 6.68003655 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 95.1 | 2e-20 | NR | MEM0353959.1 | 1906666 | g35604 | i0 | 42.9 | 1.82111436950147 | 98 | 56 | 86.2 | 0 | 8 | 301 | 126 | 223 | MEM0353959.1 TIGR03118 family protein [Thermoplasmata archaeon] | diamond | 621 | 95.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27497004 | 27497004 | PRJNA827593_P_NODE_52583_length_274_cov_2.452736_g52284_i0 | PRJNA827593 | 52583 | 274 | 2.452736 | 6.72049664 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 77 | 1.52e-15 | NR | MCZ7382623.1 | 2032688 | g52284 | i0 | 46.3 | 1.65328467153285 | 80 | 42 | 87.6 | 1 | 16 | 255 | 3 | 81 | MCZ7382623.1 50S ribosomal protein L11 [Candidatus Methanoperedens sp.] | diamond | 453 | 77 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 27528412 | 27528412 | PRJNA827593_P_NODE_34403_length_350_cov_1.108303_g34104_i0 | PRJNA827593 | 34403 | 350 | 1.108303 | 3.8790605 | Archaeoglobaceae archaeon | 2511821 | Archaea | Archaea | 132 | 5.979999999999999e-34 | NR | MEM1672925.1 | 2511821 | g34104 | i0 | 58.6 | 0.951428571428571 | 111 | 46 | 95.1 | 0 | 16 | 348 | 225 | 335 | MEM1672925.1 replicative DNA helicase [Archaeoglobaceae archaeon] | diamond | 333 | 132 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Archaeoglobaceae archaeon | |||
| 28349372 | 28349372 | PRJNA827593_P_NODE_42386_length_311_cov_1.294118_g42087_i0 | PRJNA827593 | 42386 | 311 | 1.294118 | 4.02470698 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 99 | 4.76e-22 | NR | RYE85335.1 | 2250255 | g42087 | i0 | 56 | 0.877813504823151 | 91 | 33 | 87.8 | 1 | 23 | 295 | 73 | 156 | RYE85335.1 MAG: hypothetical protein EOO65_00610 [Methanosarcinales archaeon] | diamond | 273 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28539035 | 28539035 | PRJNA827593_P_NODE_2687_length_1432_cov_4.470935_g2494_i0 | PRJNA827593 | 2687 | 1432 | 4.470935 | 64.0237892 | Thermococcus sp. M36 | 1638261 | Archaea | Archaea | 222 | 1.1999999999999998e-67 | NR | WP_206203666.1 | 1638261 | g2494 | i0 | 100 | 0.224162011173184 | 107 | 0 | 22.4 | 0 | 357 | 37 | 1 | 107 | WP_206203666.1 hypothetical protein, partial [Thermococcus sp. M36] | diamond | 321 | 222 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. M36 | ||
| 28602074 | 28602074 | PRJNA827593_P_NODE_3027_length_1345_cov_2.540881_g2823_i0 | PRJNA827593 | 3027 | 1345 | 2.540881 | 34.17484945 | Theionarchaea archaeon | 2747605 | Archaea | Archaea | 459 | 3.7199999999999986e-148 | NR | MBU7018736.1 | 2747605 | g2823 | i0 | 53 | 3.9724907063197 | 445 | 208 | 99.3 | 1 | 7 | 1341 | 347 | 790 | MBU7018736.1 DEAD/DEAH box helicase [Theionarchaea archaeon] | diamond | 5343 | 459 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Theionarchaea | Theionarchaea archaeon | |||||
| 28665260 | 28665260 | PRJNA827593_P_NODE_46667_length_294_cov_2.565611_g46368_i0 | PRJNA827593 | 46667 | 294 | 2.565611 | 7.54289634 | Candidatus Argoarchaeum ethanivorans | 2608793 | Archaea | Archaea | 86.7 | 2.14e-17 | NR | RZB31008.1 | 2608793 | g46368 | i0 | 45.2 | 1.71428571428571 | 84 | 45 | 85.7 | 1 | 292 | 41 | 296 | 378 | RZB31008.1 MAG: hypothetical protein AEth_00962 [Candidatus Argoarchaeum ethanivorans] | diamond | 504 | 86.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Argoarchaeum | Candidatus Argoarchaeum ethanivorans | ||
| 29746986 | 29746986 | PRJNA827593_P_NODE_21750_length_454_cov_1.551181_g21452_i0 | PRJNA827593 | 21750 | 454 | 1.551181 | 7.04236174 | root | 1 | Root_unresolved | Root_unresolved | 244 | 3.07e-80 | NR | WP_167895525.1 | 1638261 | g21452 | i0 | 98.5 | 1.71806167400881 | 130 | 2 | 85.9 | 0 | 452 | 63 | 53 | 182 | WP_167895525.1 FadR/GntR family transcriptional regulator, partial [Thermococcus sp. M36] | diamond | 780 | 244 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. M36 | ||
| 30086043 | 30086043 | PRJNA827593_P_NODE_54552_length_269_cov_1.178571_g54253_i0 | PRJNA827593 | 54552 | 269 | 1.178571 | 3.17035599 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 86.7 | 1.86e-17 | NR | MEM0354068.1 | 1906666 | g54253 | i0 | 50.5 | 1.01486988847584 | 91 | 38 | 99.3 | 3 | 2 | 268 | 165 | 250 | MEM0354068.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 273 | 86.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30947998 | 30947998 | PRJNA827593_P_NODE_32434_length_361_cov_3.236111_g32135_i0 | PRJNA827593 | 32434 | 361 | 3.236111 | 11.68236071 | root | 1 | Root_unresolved | Root_unresolved | 217 | 2.19e-70 | NR | WP_167895504.1 | 1638261 | g32135 | i0 | 100 | 1.77839335180055 | 107 | 0 | 88.9 | 0 | 20 | 340 | 1 | 107 | WP_167895504.1 TraB/GumN family protein, partial [Thermococcus sp. M36] | diamond | 642 | 217 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. M36 | ||
| 31327007 | 31327007 | PRJNA827593_P_NODE_26555_length_405_cov_2.331325_g26256_i0 | PRJNA827593 | 26555 | 405 | 2.331325 | 9.44186625 | root | 1 | Root_unresolved | Root_unresolved | 198 | 8.69e-63 | NR | WP_167893422.1 | 1638263 | g26256 | i0 | 99.1 | 1.58518518518519 | 107 | 1 | 79.3 | 0 | 85 | 405 | 18 | 124 | WP_167893422.1 hypothetical protein, partial [Thermococcus sp. MAR1] | diamond | 642 | 198 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. MAR1 | ||
| 31327015 | 31327015 | PRJNA827593_P_NODE_49355_length_285_cov_1.452830_g49056_i0 | PRJNA827593 | 49355 | 285 | 1.45283 | 4.1405655 | root | 1 | Root_unresolved | Root_unresolved | 182 | 1.3599999999999996e-55 | NR | WP_167895489.1 | 1638261 | g49056 | i0 | 98.9 | 1.97894736842105 | 94 | 1 | 98.9 | 0 | 283 | 2 | 99 | 192 | WP_167895489.1 outer membrane beta-barrel protein, partial [Thermococcus sp. M36] | diamond | 564 | 182 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. M36 | ||
| 31928037 | 31928037 | PRJNA827593_P_NODE_6677_length_870_cov_2.613551_g6411_i0 | PRJNA827593 | 6677 | 870 | 2.613551 | 22.7378937 | root | 1 | Root_unresolved | Root_unresolved | 332 | 1.8099999999999994e-112 | NR | WP_167895500.1 | 1638261 | g6411 | i0 | 99.4 | 1.17931034482759 | 171 | 1 | 59 | 0 | 79 | 591 | 10 | 180 | WP_167895500.1 DUF4954 family protein, partial [Thermococcus sp. M36] | diamond | 1026 | 332 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. M36 | ||
| 32466160 | 32466160 | PRJNA827593_P_NODE_2139_length_1612_cov_9.321637_g1962_i0 | PRJNA827593 | 2139 | 1612 | 9.321637 | 150.26478844 | root | 1 | Root_unresolved | Root_unresolved | 289 | 1.73e-92 | NR | WP_167895546.1 | 1638261 | g1962 | i0 | 100 | 0.53970223325062 | 145 | 0 | 27 | 0 | 1177 | 1611 | 1 | 145 | WP_167895546.1 pyridoxamine 5'-phosphate oxidase, partial [Thermococcus sp. M36] | diamond | 870 | 289 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. M36 | ||
| 32781150 | 32781150 | PRJNA827593_P_NODE_31140_length_370_cov_1.814815_g30841_i0 | PRJNA827593 | 31140 | 370 | 1.814815 | 6.7148155 | Halococcus | 2249 | Archaea | Archaea | 54.7 | 9.61e-6 | NR | RBI58627.1 | 29295 | g30841 | i0 | 41.8 | 1.36216216216216 | 79 | 42 | 60.8 | 2 | 225 | 1 | 175 | 253 | RBI58627.1 hypothetical protein DMJ13_26235 [halophilic archaeon] | diamond | 504 | 55.1 | 0.992740471869329 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | halophilic 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);;