contig_metadata
22 rows where bioproject = "PRJNA1118794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 230646 | 230646 | PRJNA1118794_P_NODE_37061_length_275_cov_1.381188_g36311_i0 | PRJNA1118794 | 37061 | 275 | 1.381188 | 3.798267 | Methanolapillus ohkumae | 3028298 | Archaea | Archaea | 54.7 | 0.007 | NTclustered | gi|2591778106|gb|CP131061.1| | 3028298 | g36311 | i0 | 100 | 0.105454545454545 | 29 | 0 | 11 | 0 | 139 | 167 | 1605995 | 1605967 | Methanolapillus ohkumae strain Am2 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolapillus | Methanolapillus ohkumae | |
| 1024984 | 1024984 | PRJNA1118794_P_NODE_66401_length_244_cov_0.900585_g65651_i0 | PRJNA1118794 | 66401 | 244 | 0.900585 | 2.1974274 | Methanocella | 570266 | Archaea | Archaea | 246 | 9.409999999999999e-61 | NTclustered | gi|282154984|dbj|AP011532.1| | 304371 | g65651 | i0 | 84.898 | 14.8934426229508 | 245 | 35 | 100 | 2 | 1 | 244 | 110507 | 110264 | Methanocella paludicola SANAE DNA, complete genome | blastn | 3634 | 246 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella paludicola | |
| 2781519 | 2781519 | PRJNA1118794_P_NODE_63823_length_245_cov_0.895349_g63073_i0 | PRJNA1118794 | 63823 | 245 | 0.895349 | 2.19360505 | Methanocorpusculum labreanum | 83984 | Archaea | Archaea | 209 | 1.24e-49 | NTclustered | gi|124362370|gb|CP000559.1| | 410358 | g63073 | i0 | 95.42 | 2.62857142857143 | 131 | 6 | 53 | 0 | 115 | 245 | 82717 | 82587 | Methanocorpusculum labreanum Z, complete genome | blastn | 644 | 209 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum labreanum | |
| 4057306 | 4057306 | PRJNA1118794_P_NODE_23364_length_320_cov_4.821862_g22614_i0 | PRJNA1118794 | 23364 | 320 | 4.821862 | 15.4299584 | Methanochimaera problematica | 2609417 | Archaea | Archaea | 58.4 | 6.45e-4 | NTclustered | gi|2594454307|gb|CP043875.1| | 2609417 | g22614 | i0 | 94.595 | 0.296875 | 37 | 2 | 12 | 0 | 257 | 293 | 1525667 | 1525703 | Methanochimaera problematica strain FWC-SCC4 chromosome, complete genome | blastn | 95 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanochimaera | Methanochimaera problematica | |
| 8678212 | 8678212 | PRJNA1118794_P_NODE_48147_length_251_cov_2.410112_g47397_i0 | PRJNA1118794 | 48147 | 251 | 2.410112 | 6.04938112 | Methanocella | 570266 | Archaea | Archaea | 316 | 7.31e-82 | NTclustered | gi|282154984|dbj|AP011532.1| | 304371 | g47397 | i0 | 89.641 | 12.4143426294821 | 251 | 22 | 99 | 3 | 1 | 249 | 109433 | 109681 | Methanocella paludicola SANAE DNA, complete genome | blastn | 3116 | 316 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella paludicola | |
| 11709687 | 11709687 | PRJNA1118794_P_NODE_61690_length_246_cov_0.890173_g60940_i0 | PRJNA1118794 | 61690 | 246 | 0.890173 | 2.18982558 | Natronobacterium lacisalsi | 229731 | Archaea | Archaea | 62.1 | 3.69e-5 | NTclustered | gi|1134496220|gb|CP019285.1| | 358396 | g60940 | i0 | 86.667 | 0.414634146341463 | 60 | 3 | 23 | 3 | 41 | 96 | 1323563 | 1323621 | Halobiforma lacisalsi AJ5, complete genome | blastn | 102 | 62.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium lacisalsi | |
| 20151510 | 20151510 | PRJNA1118794_P_NODE_9356_length_461_cov_3.427835_g8608_i0 | PRJNA1118794 | 9356 | 461 | 3.427835 | 15.80231935 | Methanococcus | 2184 | Archaea | Archaea | 52.8 | 0.045 | NTclustered | gi|1377580313|gb|CP020120.1| | 39152 | g8608 | i0 | 96.774 | 0.262472885032538 | 31 | 1 | 7 | 0 | 400 | 430 | 476940 | 476910 | Methanococcus maripaludis strain OS7mut1, complete genome | blastn | 121 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus maripaludis | |
| 22701801 | 22701801 | PRJNA1118794_P_NODE_13918_length_387_cov_4.745223_g13168_i0 | PRJNA1118794 | 13918 | 387 | 4.745223 | 18.36401301 | Methanococcus | 2184 | Archaea | Archaea | 52.8 | 0.037 | NTclustered | gi|1377580313|gb|CP020120.1| | 39152 | g13168 | i0 | 96.774 | 0.31266149870801 | 31 | 1 | 8 | 0 | 332 | 362 | 476910 | 476940 | Methanococcus maripaludis strain OS7mut1, complete genome | blastn | 121 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus maripaludis | |
| 25251181 | 25251181 | PRJNA1118794_P_NODE_14160_length_385_cov_0.855769_g13410_i0 | PRJNA1118794 | 14160 | 385 | 0.855769 | 3.29471065 | Methanocella | 570266 | Archaea | Archaea | 562 | 1.37e-155 | NTclustered | gi|282154984|dbj|AP011532.1| | 304371 | g13410 | i0 | 93.194 | 219.651948051948 | 382 | 26 | 99 | 0 | 1 | 382 | 109854 | 110235 | Methanocella paludicola SANAE DNA, complete genome | blastn | 84566 | 562 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella paludicola | |
| 27352772 | 27352772 | PRJNA1118794_P_NODE_39463_length_270_cov_1.274112_g38713_i0 | PRJNA1118794 | 39463 | 270 | 1.274112 | 3.4401024 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 125 | 2.1399999999999997e-31 | NR | HET6405799.1 | 2806419 | g38713 | i0 | 71.3 | 1.93333333333333 | 87 | 25 | 96.7 | 0 | 263 | 3 | 17 | 103 | HET6405799.1 malate synthase A [Thermoplasmatota archaeon] | diamond | 522 | 125 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28015776 | 28015776 | PRJNA1118794_P_NODE_6045_length_573_cov_2.138000_g5307_i0 | PRJNA1118794 | 6045 | 573 | 2.138 | 12.25074 | Euryarchaeota archaeon TMED1 | 2026739 | Archaea | Archaea | 46.2 | 0.0377 | NR | OUV39351.1 | 1986682 | g5307 | i0 | 26.7 | 0.450261780104712 | 86 | 63 | 45 | 0 | 102 | 359 | 224 | 309 | OUV39351.1 MAG: hypothetical protein CBC63_04155 [Euryarchaeota archaeon TMED103] | diamond | 258 | 46.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Euryarchaeota archaeon TMED103 | ||||||
| 28047153 | 28047153 | PRJNA1118794_P_NODE_32165_length_286_cov_2.652582_g31415_i0 | PRJNA1118794 | 32165 | 286 | 2.652582 | 7.58638452 | Methanothrix sp. | 90426 | Archaea | Archaea | 54.3 | 5.47e-6 | NR | HPJ29788.1 | 90426 | g31415 | i0 | 44.1 | 0.618881118881119 | 59 | 27 | 55.6 | 1 | 262 | 104 | 555 | 613 | HPJ29788.1 beta/gamma crystallin-related protein [Methanothrix sp.] | diamond | 177 | 54.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28710420 | 28710420 | PRJNA1118794_P_NODE_60667_length_246_cov_0.890173_g59917_i0 | PRJNA1118794 | 60667 | 246 | 0.890173 | 2.18982558 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 103 | 8.469999999999998e-24 | NR | WP_049934778.1 | 413810 | g59917 | i0 | 76.2 | 1.53658536585366 | 63 | 15 | 76.8 | 0 | 3 | 191 | 281 | 343 | WP_049934778.1 hypothetical protein [Halalkalicoccus jeotgali] | diamond | 378 | 103 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 28859033 | 28859033 | PRJNA1118794_P_NODE_20708_length_334_cov_2.291188_g19958_i0 | PRJNA1118794 | 20708 | 334 | 2.291188 | 7.65256792 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 1.32e-5 | NR | WP_256401952.1 | 755306 | g19958 | i0 | 53.7 | 1.3562874251497 | 54 | 22 | 47.6 | 2 | 150 | 308 | 2312 | 2363 | WP_256401952.1 malectin domain-containing carbohydrate-binding protein [Haloarchaeobius litoreus] | diamond | 453 | 54.3 | 0.992633517495396 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Haloarchaeobius | Haloarchaeobius litoreus | |
| 29120921 | 29120921 | PRJNA1118794_P_NODE_50489_length_250_cov_1.740113_g49739_i0 | PRJNA1118794 | 50489 | 250 | 1.740113 | 4.3502825 | Methanolobus zinderi | 536044 | Archaea | Archaea | 71.2 | 3.83e-12 | NR | WP_176965193.1 | 536044 | g49739 | i0 | 37.7 | 0.924 | 77 | 45 | 88.8 | 1 | 226 | 5 | 493 | 569 | WP_176965193.1 PKD domain-containing protein [Methanolobus zinderi] | diamond | 231 | 71.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus zinderi | |
| 29404885 | 29404885 | PRJNA1118794_P_NODE_40809_length_267_cov_1.335052_g40059_i0 | PRJNA1118794 | 40809 | 267 | 1.335052 | 3.56458884 | Halobacteriota archaeon | 3100168 | Archaea | Archaea | 78.6 | 1.22e-14 | NR | MDY6866055.1 | 3100168 | g40059 | i0 | 50 | 1.93258426966292 | 86 | 40 | 93.3 | 1 | 3 | 251 | 210 | 295 | MDY6866055.1 PEP/pyruvate-binding domain-containing protein [Halobacteriota archaeon] | diamond | 516 | 78.6 | 1 | Archaea | Methanobacteriati | Halobacteriota | Halobacteriota archaeon | ||||||
| 29593963 | 29593963 | PRJNA1118794_P_NODE_59070_length_247_cov_0.885057_g58320_i0 | PRJNA1118794 | 59070 | 247 | 0.885057 | 2.18609079 | Methanospirillum stamsii | 1277351 | Archaea | Archaea | 123 | 1.5e-30 | NR | WP_109941090.1 | 1277351 | g58320 | i0 | 85 | 0.728744939271255 | 60 | 9 | 72.9 | 0 | 181 | 2 | 516 | 575 | WP_109941090.1 PKD domain-containing protein [Methanospirillum stamsii] | diamond | 180 | 123 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum stamsii | |
| 29688671 | 29688671 | PRJNA1118794_P_NODE_22810_length_323_cov_1.760000_g22060_i0 | PRJNA1118794 | 22810 | 323 | 1.76 | 5.6848 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 86.3 | 8.97e-19 | NR | MBD38822.1 | 2026739 | g22060 | i0 | 40.8 | 0.956656346749226 | 103 | 58 | 92.9 | 1 | 3 | 302 | 53 | 155 | MBD38822.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 309 | 86.3 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30122107 | 30122107 | PRJNA1118794_P_NODE_35132_length_279_cov_2.237864_g34382_i0 | PRJNA1118794 | 35132 | 279 | 2.237864 | 6.24364056 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 0.00253 | NR | MDD1700180.1 | 2052170 | g34382 | i0 | 31.9 | 2 | 91 | 59 | 96.8 | 3 | 9 | 278 | 356 | 444 | MDD1700180.1 PKD domain-containing protein [Methanoregula sp.] | diamond | 558 | 46.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30257946 | 30257946 | PRJNA1118794_P_NODE_46932_length_254_cov_1.491713_g46182_i0 | PRJNA1118794 | 46932 | 254 | 1.491713 | 3.78895102 | Methanoregula sp. | 2052170 | Archaea | Archaea | 54.7 | 2.73e-6 | NR | MDP3396888.1 | 2052170 | g46182 | i0 | 40.7 | 4.78346456692913 | 81 | 43 | 94.5 | 3 | 14 | 253 | 170 | 246 | MDP3396888.1 PKD domain-containing protein [Methanoregula sp.] | diamond | 1215 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 31268805 | 31268805 | PRJNA1118794_P_NODE_69535_length_242_cov_1.911243_g68785_i0 | PRJNA1118794 | 69535 | 242 | 1.911243 | 4.62520806 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 84 | 2.35e-17 | NR | HHD16766.1 | 2026739 | g68785 | i0 | 49.4 | 0.979338842975207 | 79 | 40 | 97.9 | 0 | 240 | 4 | 23 | 101 | HHD16766.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 237 | 84 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31806492 | 31806492 | PRJNA1118794_P_NODE_75137_length_234_cov_2.391304_g74387_i0 | PRJNA1118794 | 75137 | 234 | 2.391304 | 5.59565136 | Haladaptatus salinisoli | 2884876 | Archaea | Archaea | 42.4 | 0.0447 | NR | WP_227353393.1 | 2884876 | g74387 | i0 | 38.3 | 0.769230769230769 | 60 | 32 | 70.5 | 1 | 179 | 15 | 467 | 526 | WP_227353393.1 ArnT family glycosyltransferase [Haladaptatus salinisoli] | diamond | 180 | 42.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus salinisoli |
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);;