contig_metadata
27 rows where bioproject = "PRJNA520845" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13244122 | 13244122 | PRJNA520845_P_NODE_213311_length_251_cov_1.297753_g211812_i0 | PRJNA520845 | 213311 | 251 | 1.297753 | 3.25736003 | Salinarchaeum sp. Harcht-Bsk1 | 1333523 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|507914357|gb|CP005962.1| | 1333523 | g211812 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 174 | 201 | 3134060 | 3134087 | Salinarchaeum sp. Harcht-Bsk1, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Salinarchaeum | Salinarchaeum sp. Harcht-Bsk1 | |
| 16414142 | 16414142 | PRJNA520845_P_NODE_179973_length_278_cov_1.126829_g178474_i0 | PRJNA520845 | 179973 | 278 | 1.126829 | 3.13258462 | Methanobacteriati | 3366610 | Archaea | Archaea | 108 | 4e-25 | NR | RPG71809.1 | 1986698 | g178474 | i0 | 65 | 4.21942446043165 | 80 | 27 | 85.3 | 1 | 5 | 241 | 587 | 666 | RPG71809.1 MAG: hypothetical protein CBC59_000845 [Euryarchaeota archaeon TMED99] | diamond | 1173 | 109 | 0.990825688073395 | Archaea | Methanobacteriati | Methanobacteriota | Euryarchaeota archaeon TMED99 | ||||||
| 16414800 | 16414800 | PRJNA520845_P_NODE_79653_length_416_cov_1.510204_g78154_i0 | PRJNA520845 | 79653 | 416 | 1.510204 | 6.28244864 | Thermococcus | 2263 | Archaea | Archaea | 741 | 0 | NTclustered | gi|189908859|gb|EU571472.1| | 342948 | g78154 | i0 | 100 | 1.92788461538462 | 401 | 0 | 96 | 0 | 15 | 415 | 4 | 404 | Thermococcus onnurineus dITPase gene, complete cds | blastn | 802 | 741 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus onnurineus | ||
| 18962804 | 18962804 | PRJNA520845_P_NODE_124715_length_334_cov_1.597701_g123216_i0 | PRJNA520845 | 124715 | 334 | 1.597701 | 5.33632134 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 200 | 1.73e-60 | NR | RYE83110.1 | 2250255 | g123216 | i0 | 94.1 | 0.907185628742515 | 101 | 6 | 90.7 | 0 | 333 | 31 | 316 | 416 | RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon] | diamond | 303 | 200 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 26855999 | 26855999 | PRJNA520845_P_NODE_213961_length_251_cov_0.865169_g212462_i0 | PRJNA520845 | 213961 | 251 | 0.865169 | 2.17157419 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.5 | 0.0223 | NR | HZY70575.1 | 1906666 | g212462 | i0 | 46.8 | 0.561752988047809 | 47 | 21 | 56.2 | 2 | 237 | 97 | 615 | 657 | HZY70575.1 aconitate hydratase AcnA [Thermoplasmata archaeon] | diamond | 141 | 43.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26919136 | 26919136 | PRJNA520845_P_NODE_36302_length_629_cov_1.953237_g34842_i0 | PRJNA520845 | 36302 | 629 | 1.953237 | 12.28586073 | Haloplanus rubicundus | 1547898 | Archaea | Archaea | 49.7 | 0.00434 | NR | WP_114584666.1 | 1547898 | g34842 | i0 | 29.3 | 0.58664546899841 | 123 | 72 | 52.5 | 3 | 266 | 595 | 722 | 842 | WP_114584666.1 GAF domain-containing protein [Haloplanus rubicundus] | diamond | 369 | 49.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus rubicundus | |
| 27866769 | 27866769 | PRJNA520845_P_NODE_114005_length_349_cov_1.115942_g112506_i0 | PRJNA520845 | 114005 | 349 | 1.115942 | 3.89463758 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 52.4 | 5.48e-5 | NR | MEE3419037.1 | 2666342 | g112506 | i0 | 29.9 | 1.00573065902579 | 117 | 78 | 98 | 3 | 348 | 7 | 933 | 1048 | MEE3419037.1 hypothetical protein [Methanosphaera sp.] | diamond | 351 | 52.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 27866853 | 27866853 | PRJNA520845_P_NODE_261805_length_242_cov_0.911243_g260306_i0 | PRJNA520845 | 261805 | 242 | 0.911243 | 2.20520806 | Methanocalculus chunghsingensis | 156457 | Archaea | Archaea | 125 | 2.18e-31 | NR | WP_211529921.1 | 156457 | g260306 | i0 | 70.3 | 2.76446280991736 | 74 | 22 | 91.7 | 0 | 17 | 238 | 388 | 461 | WP_211529921.1 beta-propeller domain-containing protein [Methanocalculus chunghsingensis] | diamond | 669 | 125 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocalculaceae | Methanocalculus | Methanocalculus chunghsingensis | |
| 27993322 | 27993322 | PRJNA520845_P_NODE_151065_length_304_cov_1.000000_g149566_i0 | PRJNA520845 | 151065 | 304 | 1 | 3.04 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 76.6 | 9.88e-14 | NR | MEE3419037.1 | 2666342 | g149566 | i0 | 41 | 0.819078947368421 | 83 | 47 | 79.9 | 1 | 297 | 55 | 931 | 1013 | MEE3419037.1 hypothetical protein [Methanosphaera sp.] | diamond | 249 | 76.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 27993363 | 27993363 | PRJNA520845_P_NODE_219345_length_250_cov_0.870056_g217846_i0 | PRJNA520845 | 219345 | 250 | 0.870056 | 2.17514 | Haloferax sp. DFSO6 | 2253 | Archaea | Archaea | 48.5 | 1.25e-4 | NR | WP_410764951.1 | 3388652 | g217846 | i0 | 37.1 | 0.744 | 62 | 35 | 69.6 | 1 | 176 | 3 | 19 | 80 | WP_410764951.1 ester cyclase [Haloferax sp. DFSO60] | diamond | 186 | 48.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. DFSO60 | |
| 28024925 | 28024925 | PRJNA520845_P_NODE_244265_length_245_cov_0.895349_g242766_i0 | PRJNA520845 | 244265 | 245 | 0.895349 | 2.19360505 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 53.5 | 3.44e-6 | NR | MCI0497549.1 | 1906666 | g242766 | i0 | 39 | 1.00408163265306 | 82 | 41 | 94.3 | 2 | 244 | 14 | 10 | 87 | MCI0497549.1 GDSL-type esterase/lipase family protein [Thermoplasmata archaeon] | diamond | 246 | 53.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28260979 | 28260979 | PRJNA520845_P_NODE_141206_length_314_cov_1.917012_g139707_i0 | PRJNA520845 | 141206 | 314 | 1.917012 | 6.01941768 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 1.69e-4 | NR | WP_247378268.1 | 1126241 | g139707 | i0 | 33.3 | 2.8375796178344 | 90 | 59 | 85 | 1 | 273 | 7 | 6 | 95 | WP_247378268.1 universal stress protein [Halorientalis brevis] | diamond | 891 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis brevis | |
| 28530122 | 28530122 | PRJNA520845_P_NODE_165107_length_289_cov_2.578704_g163608_i0 | PRJNA520845 | 165107 | 289 | 2.578704 | 7.45245456 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 42.7 | 0.0319 | NR | MBP5734334.1 | 2517205 | g163608 | i0 | 31.5 | 1.12110726643599 | 54 | 37 | 56.1 | 0 | 1 | 162 | 14 | 67 | MBP5734334.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] | diamond | 324 | 42.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae archaeon | |||
| 28656380 | 28656380 | PRJNA520845_P_NODE_163647_length_291_cov_1.059633_g162148_i0 | PRJNA520845 | 163647 | 291 | 1.059633 | 3.08353203 | Methanosarcina baikalica | 3073890 | Archaea | Archaea | 47.8 | 0.00112 | NR | WP_310577212.1 | 3073890 | g162148 | i0 | 34.7 | 0.77319587628866 | 75 | 48 | 76.3 | 1 | 276 | 55 | 134 | 208 | WP_310577212.1 choice-of-anchor A family protein, partial [Methanosarcina baikalica] | diamond | 225 | 47.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina baikalica | |
| 29287672 | 29287672 | PRJNA520845_P_NODE_208429_length_255_cov_1.230769_g206930_i0 | PRJNA520845 | 208429 | 255 | 1.230769 | 3.13846095 | Archaeoglobus sp. | 1872626 | Archaea | Archaea | 60.5 | 1.59e-8 | NR | WP_290722970.1 | 1872626 | g206930 | i0 | 53.6 | 1.31764705882353 | 56 | 25 | 64.7 | 1 | 89 | 253 | 5 | 60 | WP_290722970.1 alpha/beta hydrolase [Archaeoglobus sp.] | diamond | 336 | 60.5 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Archaeoglobus | Archaeoglobus sp. | ||
| 30045495 | 30045495 | PRJNA520845_P_NODE_182231_length_276_cov_1.211823_g180732_i0 | PRJNA520845 | 182231 | 276 | 1.211823 | 3.34463148 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 121 | 1.43e-31 | NR | MFP4050406.1 | 1906666 | g180732 | i0 | 61.8 | 1.91304347826087 | 89 | 32 | 96.7 | 1 | 8 | 274 | 124 | 210 | MFP4050406.1 adenylate kinase family protein [Thermoplasmata archaeon] | diamond | 528 | 121 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30298891 | 30298891 | PRJNA520845_P_NODE_201512_length_260_cov_1.647059_g200013_i0 | PRJNA520845 | 201512 | 260 | 1.647059 | 4.2823534 | Halobellus rubicundus | 2996466 | Archaea | Archaea | 60.5 | 2.72e-8 | NR | WP_372391497.1 | 2996466 | g200013 | i0 | 47.4 | 0.9 | 78 | 39 | 87.7 | 2 | 2 | 229 | 483 | 560 | WP_372391497.1 beta strand repeat-containing protein [Halobellus rubicundus] | diamond | 234 | 60.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus rubicundus | |
| 30677465 | 30677465 | PRJNA520845_P_NODE_269093_length_233_cov_2.512500_g267594_i0 | PRJNA520845 | 269093 | 233 | 2.5125 | 5.854125 | Haloarcula marina | 2961574 | Archaea | Archaea | 43.1 | 0.00565 | NR | WP_254273060.1 | 2961574 | g267594 | i0 | 43.5 | 0.592274678111588 | 46 | 24 | 56.7 | 1 | 85 | 216 | 31 | 76 | WP_254273060.1 hypothetical protein [Haloarcula marina] | diamond | 138 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula marina | |
| 30993582 | 30993582 | PRJNA520845_P_NODE_173394_length_283_cov_1.114286_g171895_i0 | PRJNA520845 | 173394 | 283 | 1.114286 | 3.15342938 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 52.8 | 1.75e-5 | NR | RMG27843.1 | 2026739 | g171895 | i0 | 37.9 | 0.92226148409894 | 87 | 54 | 92.2 | 0 | 280 | 20 | 50 | 136 | RMG27843.1 MAG: hypothetical protein D6732_19725 [Methanobacteriota archaeon] | diamond | 261 | 52.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30993591 | 30993591 | PRJNA520845_P_NODE_181214_length_277_cov_1.132353_g179715_i0 | PRJNA520845 | 181214 | 277 | 1.132353 | 3.13661781 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 65.9 | 3.45e-10 | NR | MCD6276010.1 | 1906666 | g179715 | i0 | 43.8 | 0.963898916967509 | 89 | 46 | 96.4 | 2 | 268 | 2 | 50 | 134 | MCD6276010.1 bis-aminopropyl spermidine synthase family protein [Thermoplasmata archaeon] | diamond | 267 | 65.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31341303 | 31341303 | PRJNA520845_P_NODE_51716_length_520_cov_1.378076_g50224_i0 | PRJNA520845 | 51716 | 520 | 1.378076 | 7.1659952 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 50.4 | 9.21e-4 | NR | MBT3356971.1 | 2026739 | g50224 | i0 | 29.4 | 0.825 | 143 | 85 | 79 | 6 | 67 | 477 | 107 | 239 | MBT3356971.1 transporter substrate-binding domain-containing protein [Methanobacteriota archaeon] | diamond | 429 | 50.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31373071 | 31373071 | PRJNA520845_P_NODE_224736_length_249_cov_0.875000_g223237_i0 | PRJNA520845 | 224736 | 249 | 0.875 | 2.17875 | Methanolacinia paynteri | 230356 | Archaea | Archaea | 50.4 | 7.41e-5 | NR | WP_048149656.1 | 230356 | g223237 | i0 | 34.6 | 1.81927710843373 | 81 | 49 | 94 | 2 | 5 | 238 | 145 | 224 | WP_048149656.1 cryptochrome/photolyase family protein [Methanolacinia paynteri] | diamond | 453 | 50.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanolacinia | Methanolacinia paynteri | |
| 31625837 | 31625837 | PRJNA520845_P_NODE_219496_length_250_cov_0.870056_g217997_i0 | PRJNA520845 | 219496 | 250 | 0.870056 | 2.17514 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 101 | 1.04e-22 | NR | RMG31057.1 | 2026739 | g217997 | i0 | 51.2 | 2.004 | 82 | 40 | 98.4 | 0 | 249 | 4 | 541 | 622 | RMG31057.1 MAG: hypothetical protein D6732_15215 [Methanobacteriota archaeon] | diamond | 501 | 101 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31815612 | 31815612 | PRJNA520845_P_NODE_166697_length_288_cov_1.432558_g165198_i0 | PRJNA520845 | 166697 | 288 | 1.432558 | 4.12576704 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 64.7 | 1.24e-9 | NR | MEE3325117.1 | 2666342 | g165198 | i0 | 30.3 | 1.13541666666667 | 109 | 51 | 90.6 | 3 | 3 | 263 | 1062 | 1167 | MEE3325117.1 hypothetical protein [Methanosphaera sp.] | diamond | 327 | 64.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 32147495 | 32147495 | PRJNA520845_P_NODE_38558_length_609_cov_1.615672_g37090_i0 | PRJNA520845 | 38558 | 609 | 1.615672 | 9.83944248 | Archaea | 2157 | Archaea | Archaea | 201 | 4.29e-59 | NR | PKK86187.1 | 2013852 | g37090 | i0 | 50 | 4.82758620689655 | 198 | 91 | 95.6 | 3 | 25 | 606 | 1 | 194 | PKK86187.1 MAG: ATPase [Thermoplasmata archaeon HGW-Thermoplasmata-1] | diamond | 2940 | 201 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon HGW-Thermoplasmata-1 | |||||
| 32448673 | 32448673 | PRJNA520845_P_NODE_109999_length_355_cov_1.092199_g108500_i0 | PRJNA520845 | 109999 | 355 | 1.092199 | 3.87730645 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 74.3 | 1.04e-12 | NR | MDP6906002.1 | 2670411 | g108500 | i0 | 42.5 | 0.676056338028169 | 80 | 46 | 67.6 | 0 | 99 | 338 | 319 | 398 | MDP6906002.1 M20/M25/M40 family metallo-hydrolase [Candidatus Thalassarchaeaceae archaeon] | diamond | 240 | 74.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 32763881 | 32763881 | PRJNA520845_P_NODE_234840_length_247_cov_0.885057_g233341_i0 | PRJNA520845 | 234840 | 247 | 0.885057 | 2.18609079 | Haloterrigena alkaliphila | 2816475 | Archaea | Archaea | 47.8 | 6.25e-4 | NR | WP_207287531.1 | 2816475 | g233341 | i0 | 48 | 1.21457489878543 | 50 | 25 | 60.7 | 1 | 152 | 3 | 45 | 93 | WP_207287531.1 DUF4397 domain-containing protein [Haloterrigena alkaliphila] | diamond | 300 | 47.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena alkaliphila |
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);;