contig_metadata
22 rows where bioproject = "PRJNA966993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12421074 | 12421074 | PRJNA966993_P_NODE_22290_length_445_cov_1.685484_g21843_i0 | PRJNA966993 | 22290 | 445 | 1.685484 | 7.5004038 | Halorutilales archaeon Cl-col2-1 | 3242703 | Archaea | Archaea | 54.7 | 0.012 | NTclustered | gi|2801083086|gb|CP169074.1| | 3242703 | g21843 | i0 | 100 | 0.0651685393258427 | 29 | 0 | 7 | 0 | 2 | 30 | 912412 | 912384 | Halorutilales archaeon Cl-col2-1 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halorutilales | Halorutilales archaeon Cl-col2-1 | |||
| 12421417 | 12421417 | PRJNA966993_P_NODE_60150_length_284_cov_2.919431_g59698_i0 | PRJNA966993 | 60150 | 284 | 2.919431 | 8.29118404 | Halomarina rubra | 2071873 | Archaea | Archaea | 96.7 | 1.18e-21 | NR | WP_250873790.1 | 2071873 | g59698 | i0 | 50 | 0.992957746478873 | 94 | 46 | 99.3 | 1 | 282 | 1 | 23 | 115 | WP_250873790.1 oxidoreductase [Halomarina rubra] | diamond | 282 | 96.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina rubra | |
| 13695817 | 13695817 | PRJNA966993_P_NODE_4411_length_979_cov_2.591611_g4103_i0 | PRJNA966993 | 4411 | 979 | 2.591611 | 25.37187169 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 627 | 5.91e-225 | NR | RYE83110.1 | 2250255 | g4103 | i0 | 94.5 | 0.995914198161389 | 325 | 18 | 99.6 | 0 | 977 | 3 | 55 | 379 | RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon] | diamond | 975 | 627 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 23894984 | 23894984 | PRJNA966993_P_NODE_76439_length_260_cov_1.647059_g75987_i0 | PRJNA966993 | 76439 | 260 | 1.647059 | 4.2823534 | Salinibaculum marinum | 3131993 | Archaea | Archaea | 54.7 | 0.007 | NTclustered | gi|2700494403|gb|CP147838.1| | 3131993 | g75987 | i0 | 100 | 0.111538461538462 | 29 | 0 | 11 | 0 | 41 | 69 | 145888 | 145916 | Salinibaculum marinum strain SYNS191 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Salinibaculum | Salinibaculum marinum | |
| 26899401 | 26899401 | PRJNA966993_P_NODE_81_length_3854_cov_4.586353_g68_i0 | PRJNA966993 | 81 | 3854 | 4.586353 | 176.75804462 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 151 | 3.29e-34 | NR | RMG33649.1 | 2026739 | g68 | i0 | 29.9 | 0.559678256357032 | 388 | 251 | 29.3 | 10 | 2370 | 1243 | 105 | 483 | RMG33649.1 MAG: hypothetical protein D6732_11770 [Methanobacteriota archaeon] | diamond | 2157 | 151 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27025842 | 27025842 | PRJNA966993_P_NODE_36322_length_356_cov_1.088339_g35870_i0 | PRJNA966993 | 36322 | 356 | 1.088339 | 3.87448684 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 69.7 | 4.93e-11 | NR | RCH77183.1 | 2163009 | g35870 | i0 | 40 | 0.884831460674157 | 105 | 58 | 86 | 2 | 31 | 336 | 366 | 468 | RCH77183.1 MAG: hypothetical protein DBX04_01445 [Candidatus Poseidoniales archaeon] | diamond | 315 | 69.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 27752614 | 27752614 | PRJNA966993_P_NODE_13764_length_566_cov_1.557809_g13330_i0 | PRJNA966993 | 13764 | 566 | 1.557809 | 8.81719894 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 99 | 2.41e-20 | NR | RMG33649.1 | 2026739 | g13330 | i0 | 30.3 | 0.996466431095406 | 188 | 127 | 97.5 | 2 | 14 | 565 | 274 | 461 | RMG33649.1 MAG: hypothetical protein D6732_11770 [Methanobacteriota archaeon] | diamond | 564 | 99 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27752620 | 27752620 | PRJNA966993_P_NODE_24904_length_422_cov_1.656160_g24457_i0 | PRJNA966993 | 24904 | 422 | 1.65616 | 6.9889952 | Methanoregula sp. | 2052170 | Archaea | Archaea | 57.8 | 1.33e-6 | NR | HZK31245.1 | 2052170 | g24457 | i0 | 29.2 | 3.69668246445498 | 130 | 88 | 91 | 2 | 39 | 422 | 15 | 142 | HZK31245.1 AMP-binding protein [Methanoregula sp.] | diamond | 1560 | 57.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 28225821 | 28225821 | PRJNA966993_P_NODE_76466_length_260_cov_1.647059_g76014_i0 | PRJNA966993 | 76466 | 260 | 1.647059 | 4.2823534 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 49.7 | 1.6e-4 | NR | RMG27843.1 | 2026739 | g76014 | i0 | 36.8 | 1.00384615384615 | 87 | 46 | 95.8 | 3 | 11 | 259 | 281 | 362 | RMG27843.1 MAG: hypothetical protein D6732_19725 [Methanobacteriota archaeon] | diamond | 261 | 49.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28320767 | 28320767 | PRJNA966993_P_NODE_70366_length_269_cov_4.846939_g69914_i0 | PRJNA966993 | 70366 | 269 | 4.846939 | 13.03826591 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 52.4 | 4.93e-6 | NR | MEI7649696.1 | 2184052 | g69914 | i0 | 51 | 1.66171003717472 | 49 | 21 | 54.6 | 1 | 118 | 264 | 8 | 53 | MEI7649696.1 ester cyclase [Methanomicrobiales archaeon] | diamond | 447 | 52.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 28326967 | 28326967 | PRJNA966993_P_NODE_18826_length_483_cov_0.970732_g18381_i0 | PRJNA966993 | 18826 | 483 | 0.970732 | 4.68863556 | Archaea | 2157 | Archaea | Archaea | 55.8 | 4.25e-6 | NR | WP_052358743.1 | 2234 | g18381 | i0 | 28.4 | 2.54658385093168 | 102 | 71 | 62.7 | 2 | 26 | 328 | 95 | 195 | WP_052358743.1 PD-(D/E)XK nuclease family protein [Archaeoglobus fulgidus] | diamond | 1230 | 56.2 | 0.99288256227758 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Archaeoglobus | Archaeoglobus fulgidus | ||
| 28668245 | 28668245 | PRJNA966993_P_NODE_45867_length_319_cov_1.252033_g45415_i0 | PRJNA966993 | 45867 | 319 | 1.252033 | 3.99398527 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 75.9 | 4.53e-14 | NR | MFL2976240.1 | 2670411 | g45415 | i0 | 43.8 | 3.38557993730408 | 89 | 41 | 83.7 | 2 | 268 | 2 | 11 | 90 | MFL2976240.1 glutathione S-transferase family protein [Candidatus Thalassarchaeaceae archaeon] | diamond | 1080 | 75.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 29804698 | 29804698 | PRJNA966993_P_NODE_47591_length_313_cov_1.925000_g47139_i0 | PRJNA966993 | 47591 | 313 | 1.925 | 6.02525 | Methanonatronarchaeum sp. AMET-Sl | 3037654 | Archaea | Archaea | 55.1 | 4.67e-7 | NR | WP_280109054.1 | 3037654 | g47139 | i0 | 35.6 | 0.833865814696486 | 87 | 50 | 83.4 | 1 | 2 | 262 | 6 | 86 | WP_280109054.1 DUF4870 domain-containing protein [Methanonatronarchaeum sp. AMET-Sl] | diamond | 261 | 55.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanonatronarchaeia | Methanonatronarchaeales | Methanonatronarchaeaceae | Methanonatronarchaeum | Methanonatronarchaeum sp. AMET-Sl | ||
| 29994423 | 29994423 | PRJNA966993_P_NODE_101051_length_230_cov_2.515924_g100599_i0 | PRJNA966993 | 101051 | 230 | 2.515924 | 5.7866252 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 65.1 | 4.2e-10 | NR | MEC7178563.1 | 2806419 | g100599 | i0 | 56.5 | 0.808695652173913 | 62 | 25 | 78.3 | 2 | 51 | 230 | 416 | 477 | MEC7178563.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 186 | 65.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30499892 | 30499892 | PRJNA966993_P_NODE_82073_length_251_cov_1.342697_g81621_i0 | PRJNA966993 | 82073 | 251 | 1.342697 | 3.37016947 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 85.9 | 1.25e-19 | NR | MBU4374237.1 | 2026739 | g81621 | i0 | 60.7 | 2.91633466135458 | 61 | 24 | 72.9 | 0 | 184 | 2 | 4 | 64 | MBU4374237.1 hypoxanthine phosphoribosyltransferase [Methanobacteriota archaeon] | diamond | 732 | 85.9 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30537726 | 30537726 | PRJNA966993_P_NODE_15493_length_531_cov_4.703057_g15051_i0 | PRJNA966993 | 15493 | 531 | 4.703057 | 24.97323267 | Archaea | 2157 | Archaea | Archaea | 85.9 | 1.04e-17 | NR | HXQ49019.1 | 1906666 | g15051 | i0 | 38 | 3.24858757062147 | 137 | 82 | 76.3 | 2 | 32 | 436 | 12 | 147 | HXQ49019.1 universal stress protein [Thermoplasmata archaeon] | diamond | 1725 | 85.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30626023 | 30626023 | PRJNA966993_P_NODE_30933_length_382_cov_1.495146_g30481_i0 | PRJNA966993 | 30933 | 382 | 1.495146 | 5.71145772 | Methanoregula sp. | 2052170 | Archaea | Archaea | 67.8 | 3.12e-10 | NR | WP_373007287.1 | 2052170 | g30481 | i0 | 38 | 0.950261780104712 | 121 | 51 | 82.5 | 5 | 338 | 24 | 126 | 238 | WP_373007287.1 TIGR03768 family metallophosphoesterase [Methanoregula sp.] | diamond | 363 | 67.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30784147 | 30784147 | PRJNA966993_P_NODE_29374_length_391_cov_1.761006_g28922_i0 | PRJNA966993 | 29374 | 391 | 1.761006 | 6.88553346 | Candidatus Poseidoniaceae archaeon | 2666346 | Archaea | Archaea | 62.4 | 2.81e-8 | NR | MDP7203619.1 | 2666346 | g28922 | i0 | 55.8 | 0.398976982097187 | 52 | 23 | 39.9 | 0 | 391 | 236 | 211 | 262 | MDP7203619.1 hypothetical protein [Candidatus Poseidoniaceae archaeon] | diamond | 156 | 62.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidoniaceae archaeon | |||
| 31226394 | 31226394 | PRJNA966993_P_NODE_24995_length_421_cov_4.818966_g24548_i0 | PRJNA966993 | 24995 | 421 | 4.818966 | 20.28784686 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 80.5 | 1.78e-14 | NR | UCH71462.1 | 2268204 | g24548 | i0 | 46.1 | 1.43230403800475 | 102 | 51 | 71.3 | 2 | 406 | 107 | 306 | 405 | UCH71462.1 MAG: pyruvate:ferredoxin (flavodoxin) oxidoreductase, partial [Thermoplasmatales archaeon] | diamond | 603 | 80.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 31827298 | 31827298 | PRJNA966993_P_NODE_16757_length_511_cov_1.801370_g16315_i0 | PRJNA966993 | 16757 | 511 | 1.80137 | 9.2050007 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 131 | 3.939999999999999e-32 | NR | MBF26215.1 | 2026739 | g16315 | i0 | 42 | 0.921722113502935 | 157 | 69 | 82.8 | 2 | 12 | 434 | 174 | 324 | MBF26215.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 471 | 131 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31922367 | 31922367 | PRJNA966993_P_NODE_19977_length_469_cov_2.949495_g19532_i0 | PRJNA966993 | 19977 | 469 | 2.949495 | 13.83313155 | Euryarchaeota archaeon TMED97 | 1986697 | Archaea | Archaea | 65.1 | 7.44e-9 | NR | OUV24995.1 | 1986697 | g19532 | i0 | 46 | 0.805970149253731 | 63 | 34 | 40.3 | 0 | 457 | 269 | 2888 | 2950 | OUV24995.1 MAG: hypothetical protein CBC57_05920, partial [Euryarchaeota archaeon TMED97] | diamond | 378 | 65.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Euryarchaeota archaeon TMED97 | ||||||
| 32245486 | 32245486 | PRJNA966993_P_NODE_28378_length_397_cov_1.956790_g27928_i0 | PRJNA966993 | 28378 | 397 | 1.95679 | 7.7684563 | Thermococcus | 2263 | Archaea | Archaea | 60.5 | 1.16e-7 | NR | WP_088881714.1 | 122420 | g27928 | i0 | 37.4 | 1.97984886649874 | 131 | 65 | 87.7 | 5 | 364 | 17 | 150 | 278 | WP_088881714.1 phosphate ABC transporter substrate-binding protein PstS [Thermococcus sp. P6] | diamond | 786 | 60.5 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. P6 |
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);;