contig_metadata
14 rows where bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2249179 | 2249179 | PRJNA986481_P_NODE_59562_length_242_cov_1.046632_g59037_i0 | PRJNA986481 | 59562 | 242 | 1.046632 | 2.53284944 | Methanobrevibacter sp. YE315 | 1609968 | Archaea | Archaea | 392 | 1.1299999999999999e-104 | NTclustered | gi|985614202|gb|CP010834.1| | 1609968 | g59037 | i0 | 95.868 | 10.9876033057851 | 242 | 10 | 100 | 0 | 1 | 242 | 219271 | 219030 | Methanobrevibacter sp. YE315, complete genome | blastn | 2659 | 392 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. YE315 | |
| 11176593 | 11176593 | PRJNA986481_P_NODE_14029_length_438_cov_1.120823_g13505_i0 | PRJNA986481 | 14029 | 438 | 1.120823 | 4.90920474 | Methanolobus sp. ZRKC2 | 3125783 | Archaea | Archaea | 54.7 | 0.012 | NTclustered | gi|2708450131|gb|CP146980.1| | 3125783 | g13505 | i0 | 92.308 | 0.089041095890411 | 39 | 1 | 9 | 2 | 282 | 319 | 2375858 | 2375821 | Methanolobus sp. ZRKC2 chromosome, complete genome | blastn | 39 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. ZRKC2 | |
| 13727130 | 13727130 | PRJNA986481_P_NODE_32951_length_285_cov_1.233051_g32426_i0 | PRJNA986481 | 32951 | 285 | 1.233051 | 3.51419535 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 152 | 1.99e-41 | NR | WP_405289692.1 | 66852 | g32426 | i0 | 77.7 | 2.96842105263158 | 94 | 20 | 98.9 | 1 | 284 | 3 | 26 | 118 | WP_405289692.1 molecular chaperone DnaK, partial [Methanobrevibacter sp.] | diamond | 846 | 152 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 15300002 | 15300002 | PRJNA986481_P_NODE_38132_length_266_cov_0.930876_g37607_i0 | PRJNA986481 | 38132 | 266 | 0.930876 | 2.47613016 | Halalkalicoccus | 332246 | Archaea | Archaea | 446 | 9.549999999999999e-121 | NTclustered | gi|1779814881|ref|NR_164956.1| | 2675002 | g37607 | i0 | 96.992 | 101.661654135338 | 266 | 7 | 99 | 1 | 2 | 266 | 281 | 16 | Halalkalicoccus subterraneus strain GSM28 16S ribosomal RNA, partial sequence | blastn | 27042 | 446 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus subterraneus | |
| 26747047 | 26747047 | PRJNA986481_P_NODE_50541_length_252_cov_0.970443_g50016_i0 | PRJNA986481 | 50541 | 252 | 0.97044299999999994 | 2.44551636 | Thermococcus | 2263 | Archaea | Archaea | 99 | 2.88e-22 | NR | MEO2152120.1 | 35749 | g50016 | i0 | 62 | 7.54761904761905 | 79 | 30 | 94 | 0 | 11 | 247 | 134 | 212 | MEO2152120.1 RtcB family protein [Thermococcus sp.] | diamond | 1902 | 99 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. | ||
| 27342660 | 27342660 | PRJNA986481_P_NODE_10963_length_494_cov_4.656180_g10441_i0 | PRJNA986481 | 10963 | 494 | 4.65618 | 23.0015292 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 228 | 4.49e-67 | NR | WP_295614768.1 | 253161 | g10441 | i0 | 73.6 | 0.874493927125506 | 144 | 38 | 87.4 | 0 | 3 | 434 | 677 | 820 | WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.] | diamond | 432 | 228 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 27658441 | 27658441 | PRJNA986481_P_NODE_14544_length_430_cov_2.036745_g14019_i0 | PRJNA986481 | 14544 | 430 | 2.036745 | 8.7580035 | Haloferacaceae | 1644056 | Archaea | Archaea | 67.4 | 7.42e-10 | NR | WP_122104754.1 | 1644056 | g14019 | i0 | 34.7 | 4.08837209302326 | 118 | 66 | 76.7 | 3 | 365 | 36 | 1912 | 2026 | WP_122104754.1 MULTISPECIES: malectin domain-containing carbohydrate-binding protein [Haloferacaceae] | diamond | 1758 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | |||
| 28258027 | 28258027 | PRJNA986481_P_NODE_56506_length_245_cov_1.030612_g55981_i0 | PRJNA986481 | 56506 | 245 | 1.030612 | 2.5249994 | Methanobacterium sp. | 2164 | Archaea | Archaea | 128 | 2.09e-33 | NR | TMS43079.1 | 2164 | g55981 | i0 | 75.9 | 1.93469387755102 | 79 | 19 | 96.7 | 0 | 238 | 2 | 21 | 99 | TMS43079.1 MAG: DUF2117 domain-containing protein [Methanobacterium sp.] | diamond | 474 | 128 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 28794716 | 28794716 | PRJNA986481_P_NODE_39467_length_264_cov_2.083721_g38942_i0 | PRJNA986481 | 39467 | 264 | 2.083721 | 5.50102344 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 48.9 | 1.36e-4 | NR | MEE3444538.1 | 66852 | g38942 | i0 | 46.4 | 0.636363636363636 | 56 | 29 | 62.5 | 1 | 258 | 94 | 108 | 163 | MEE3444538.1 40S ribosomal protein S19 [Methanobrevibacter sp.] | diamond | 168 | 48.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29079225 | 29079225 | PRJNA986481_P_NODE_60528_length_241_cov_1.046875_g60003_i0 | PRJNA986481 | 60528 | 241 | 1.046875 | 2.52296875 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 48.9 | 2.33e-4 | NR | RPI38806.1 | 2485498 | g60003 | i0 | 39.7 | 0.721991701244813 | 58 | 32 | 72.2 | 1 | 63 | 236 | 185 | 239 | RPI38806.1 MAG: hypothetical protein EHM53_07905 [Methanoregulaceae archaeon] | diamond | 174 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 30026538 | 30026538 | PRJNA986481_P_NODE_40331_length_263_cov_1.345794_g39806_i0 | PRJNA986481 | 40331 | 263 | 1.345794 | 3.53943822 | Methanococcus voltae | 2188 | Archaea | Archaea | 48.5 | 4.37e-4 | NR | WP_013180395.1 | 2188 | g39806 | i0 | 42.9 | 1.42585551330798 | 63 | 28 | 69.6 | 2 | 226 | 44 | 635 | 691 | WP_013180395.1 protease inhibitor I42 family protein [Methanococcus voltae] | diamond | 375 | 48.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus voltae | |
| 30632502 | 30632502 | PRJNA986481_P_NODE_51633_length_250_cov_1.875622_g51108_i0 | PRJNA986481 | 51633 | 250 | 1.875622 | 4.689055 | Methanomicrobiales | 2191 | Archaea | Archaea | 49.7 | 1.39e-4 | NR | WP_346733691.1 | 90427 | g51108 | i0 | 37.8 | 3.732 | 82 | 28 | 94.8 | 3 | 3 | 239 | 201 | 262 | WP_346733691.1 kelch repeat-containing protein [Methanoculleus sp.] | diamond | 933 | 50.1 | 0.992015968063872 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 31069258 | 31069258 | PRJNA986481_P_NODE_28435_length_307_cov_3.449612_g27910_i0 | PRJNA986481 | 28435 | 307 | 3.449612 | 10.59030884 | Candidatus Methanophagales archaeon | 2056316 | Archaea | Archaea | 45.8 | 0.00585 | NR | MCR5852524.1 | 2056316 | g27910 | i0 | 29.3 | 1.60260586319218 | 82 | 57 | 80.1 | 1 | 302 | 57 | 81 | 161 | MCR5852524.1 hypothetical protein [Candidatus Methanophagales archaeon] | diamond | 492 | 45.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagales archaeon | |||
| 32618765 | 32618765 | PRJNA986481_P_NODE_61080_length_237_cov_2.473404_g60555_i0 | PRJNA986481 | 61080 | 237 | 2.473404 | 5.86196748 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 60.5 | 1.54e-9 | NR | MCL5804599.1 | 2806419 | g60555 | i0 | 67.5 | 0.506329113924051 | 40 | 13 | 50.6 | 0 | 23 | 142 | 79 | 118 | MCL5804599.1 nascent polypeptide-associated complex protein [Thermoplasmatota archaeon] | diamond | 120 | 60.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota 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);;