contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3959069 | 3959069 | PRJEB66218_P_NODE_25164_length_755_cov_1.550432_g22948_i0 | PRJEB66218 | 25164 | 755 | 1.550432 | 11.7057616 | root | 1 | Root_unresolved | Root_unresolved | 90.5 | 1.72e-16 | NR | WP_321506807.1 | 1005933 | g22948 | i0 | 37.9 | 2.53907284768212 | 161 | 80 | 62.8 | 6 | 15 | 488 | 2935 | 3078 | WP_321506807.1 DUF3821 domain-containing protein [uncultured Methanoregula sp.] | diamond | 1917 | 90.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 6098099 | 6098099 | PRJEB66218_P_NODE_44865_length_514_cov_2.543046_g42453_i0 | PRJEB66218 | 44865 | 514 | 2.543046 | 13.07125644 | root | 1 | Root_unresolved | Root_unresolved | 231 | 1.49e-70 | NR | MBX7076496.1 | 2099680 | g42453 | i0 | 68.5 | 1.92607003891051 | 165 | 52 | 96.3 | 0 | 497 | 3 | 125 | 289 | MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon] | diamond | 990 | 231 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 19257271 | 19257271 | PRJEB66218_P_NODE_165696_length_230_cov_1.538462_g163266_i0 | PRJEB66218 | 165696 | 230 | 1.538462 | 3.5384626 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 79 | 2.19e-15 | NR | MEK9738531.1 | 2026739 | g163266 | i0 | 56.6 | 6.96521739130435 | 76 | 29 | 99.1 | 1 | 3 | 230 | 18 | 89 | MEK9738531.1 NCS2 family permease [Methanobacteriota archaeon] | diamond | 1602 | 79 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 21808484 | 21808484 | PRJEB66218_P_NODE_17178_length_975_cov_4.374179_g15254_i0 | PRJEB66218 | 17178 | 975 | 4.374179 | 42.64824525 | Acidiplasma aeolicum | 507754 | Archaea | Archaea | 489 | 1.2299999999999998e-171 | NR | WP_393917166.1 | 507754 | g15254 | i0 | 80.4 | 1.88923076923077 | 306 | 60 | 94.2 | 0 | 2 | 919 | 24 | 329 | WP_393917166.1 NADH-quinone oxidoreductase subunit NuoH [Acidiplasma aeolicum] | diamond | 1842 | 489 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Ferroplasmaceae | Acidiplasma | Acidiplasma aeolicum | ||
| 26780862 | 26780862 | PRJEB66218_P_NODE_100181_length_306_cov_2.416327_g97753_i0 | PRJEB66218 | 100181 | 306 | 2.416327 | 7.39396062 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 52.4 | 3.23e-5 | NR | RYE99387.1 | 2026739 | g97753 | i0 | 36.8 | 0.852941176470588 | 87 | 37 | 81.4 | 2 | 260 | 12 | 816 | 888 | RYE99387.1 MAG: hypothetical protein EOO41_01105, partial [Methanobacteriota archaeon] | diamond | 261 | 52.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 26781029 | 26781029 | PRJEB66218_P_NODE_97601_length_311_cov_1.804000_g95173_i0 | PRJEB66218 | 97601 | 311 | 1.804 | 5.61044 | Natrinema soli | 1930624 | Archaea | Archaea | 60.8 | 3.35e-8 | NR | WP_273737973.1 | 1930624 | g95173 | i0 | 60 | 2.56591639871383 | 45 | 18 | 43.4 | 0 | 310 | 176 | 351 | 395 | WP_273737973.1 cystathionine gamma-synthase [Natrinema soli] | diamond | 798 | 60.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema soli | |
| 26907395 | 26907395 | PRJEB66218_P_NODE_117202_length_279_cov_0.894495_g114773_i0 | PRJEB66218 | 117202 | 279 | 0.894495 | 2.49564105 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 77 | 7.62e-15 | NR | HYB63318.1 | 1906666 | g114773 | i0 | 46.7 | 2.96774193548387 | 92 | 33 | 98.9 | 2 | 2 | 277 | 22 | 97 | HYB63318.1 adenylate kinase [Thermoplasmata archaeon] | diamond | 828 | 77 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27026845 | 27026845 | PRJEB66218_P_NODE_34962_length_607_cov_4.576923_g32586_i0 | PRJEB66218 | 34962 | 607 | 4.576923 | 27.78192261 | Methanoculleus | 45989 | Archaea | Archaea | 50.4 | 0.00126 | NR | WP_348532016.1 | 90427 | g32586 | i0 | 28.6 | 1.17627677100494 | 119 | 69 | 58.8 | 3 | 222 | 578 | 62 | 164 | WP_348532016.1 kelch repeat-containing protein, partial [Methanoculleus sp.] | diamond | 714 | 50.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 27286907 | 27286907 | PRJEB66218_P_NODE_25283_length_752_cov_3.600579_g23064_i0 | PRJEB66218 | 25283 | 752 | 3.600579 | 27.07635408 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 208 | 1.83e-58 | NR | MDE1837010.1 | 2026739 | g23064 | i0 | 60.1 | 0.63031914893617 | 158 | 61 | 62.2 | 1 | 500 | 33 | 142 | 299 | MDE1837010.1 PKD domain-containing protein [Methanobacteriota archaeon] | diamond | 474 | 208 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27602964 | 27602964 | PRJEB66218_P_NODE_38344_length_571_cov_1.849020_g35949_i0 | PRJEB66218 | 38344 | 571 | 1.84902 | 10.5579042 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 58.2 | 3.86e-6 | NR | MDD1719583.1 | 2485498 | g35949 | i0 | 36 | 1.38704028021016 | 89 | 55 | 45.7 | 1 | 301 | 561 | 66 | 154 | MDD1719583.1 hypothetical protein [Methanoregulaceae archaeon] | diamond | 792 | 58.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 27760865 | 27760865 | PRJEB66218_P_NODE_120564_length_274_cov_1.370892_g118135_i0 | PRJEB66218 | 120564 | 274 | 1.370892 | 3.75624408 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 60.8 | 1.43e-8 | NR | RYE99835.1 | 2026739 | g118135 | i0 | 38.3 | 1.02919708029197 | 94 | 51 | 97.4 | 3 | 269 | 3 | 96 | 187 | RYE99835.1 MAG: hypothetical protein EOO41_00480, partial [Methanobacteriota archaeon] | diamond | 282 | 60.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27823993 | 27823993 | PRJEB66218_P_NODE_90184_length_327_cov_1.759398_g87757_i0 | PRJEB66218 | 90184 | 327 | 1.759398 | 5.75323146 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 140 | 6.05e-36 | NR | MDE1837010.1 | 2026739 | g87757 | i0 | 60.2 | 0.990825688073395 | 108 | 41 | 99.1 | 1 | 4 | 327 | 158 | 263 | MDE1837010.1 PKD domain-containing protein [Methanobacteriota archaeon] | diamond | 324 | 140 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28581600 | 28581600 | PRJEB66218_P_NODE_10067_length_1381_cov_2.720455_g8666_i0 | PRJEB66218 | 10067 | 1381 | 2.720455 | 37.56948355 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 49.7 | 0.0347 | NR | WP_298517334.1 | 253161 | g8666 | i0 | 37.5 | 0.156408399710355 | 72 | 43 | 15.2 | 1 | 449 | 240 | 480 | 551 | WP_298517334.1 C1 family peptidase [uncultured Methanobrevibacter sp.] | diamond | 216 | 49.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 28707958 | 28707958 | PRJEB66218_P_NODE_201607_length_210_cov_1.167785_g199177_i0 | PRJEB66218 | 201607 | 210 | 1.167785 | 2.4523485 | Methanobrevibacter sp. UBA212 | 1915476 | Archaea | Archaea | 43.9 | 0.0096 | NR | WP_292888079.1 | 1915476 | g199177 | i0 | 58.5 | 1.18571428571429 | 41 | 17 | 58.6 | 0 | 29 | 151 | 345 | 385 | WP_292888079.1 Ig-like domain repeat protein [Methanobrevibacter sp. UBA212] | diamond | 249 | 43.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. UBA212 | |
| 28802294 | 28802294 | PRJEB66218_P_NODE_207788_length_209_cov_0.878378_g205358_i0 | PRJEB66218 | 207788 | 209 | 0.878378 | 1.83581002 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 53.5 | 3.79e-6 | NR | WP_296876610.1 | 253161 | g205358 | i0 | 47.6 | 2.6555023923445 | 63 | 31 | 90.4 | 1 | 206 | 18 | 1103 | 1163 | WP_296876610.1 hypothetical protein, partial [uncultured Methanobrevibacter sp.] | diamond | 555 | 53.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 28928801 | 28928801 | PRJEB66218_P_NODE_140588_length_250_cov_2.063492_g138159_i0 | PRJEB66218 | 140588 | 250 | 2.063492 | 5.15873 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 73.2 | 6.06e-14 | NR | MEA3190336.1 | 1906666 | g138159 | i0 | 49.3 | 6.612 | 75 | 38 | 90 | 0 | 23 | 247 | 32 | 106 | MEA3190336.1 deoxyhypusine monooxygenase [Thermoplasmata archaeon] | diamond | 1653 | 73.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29458180 | 29458180 | PRJEB66218_P_NODE_196590_length_211_cov_1.733333_g194160_i0 | PRJEB66218 | 196590 | 211 | 1.733333 | 3.65733263 | root | 1 | Root_unresolved | Root_unresolved | 41.6 | 0.0283 | NR | MEF8873836.1 | 2806419 | g194160 | i0 | 35.3 | 1.56398104265403 | 51 | 33 | 72.5 | 0 | 9 | 161 | 20 | 70 | MEF8873836.1 tetratricopeptide repeat protein [Thermoplasmatota archaeon] | diamond | 330 | 42 | 0.990476190476191 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29686319 | 29686319 | PRJEB66218_P_NODE_30_length_15996_cov_27.932852_g25_i0 | PRJEB66218 | 30 | 15996 | 27.932852 | 4468.13900592 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 97.8 | 4.24e-16 | NR | RPI38806.1 | 2485498 | g25 | i0 | 31.5 | 0.0481995498874719 | 257 | 156 | 4.7 | 9 | 15465 | 14707 | 89 | 329 | RPI38806.1 MAG: hypothetical protein EHM53_07905 [Methanoregulaceae archaeon] | diamond | 771 | 97.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 29939471 | 29939471 | PRJEB66218_P_NODE_73551_length_372_cov_3.710611_g71126_i0 | PRJEB66218 | 73551 | 372 | 3.710611 | 13.80347292 | Methanoregula sp. | 2052170 | Archaea | Archaea | 70.5 | 3.22e-11 | NR | MDD1700180.1 | 2052170 | g71126 | i0 | 34.5 | 0.959677419354839 | 119 | 70 | 91.1 | 3 | 22 | 360 | 285 | 401 | MDD1700180.1 PKD domain-containing protein [Methanoregula sp.] | diamond | 357 | 70.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30785198 | 30785198 | PRJEB66218_P_NODE_71434_length_379_cov_2.754717_g69010_i0 | PRJEB66218 | 71434 | 379 | 2.754717 | 10.44037743 | root | 1 | Root_unresolved | Root_unresolved | 94.4 | 3.1200000000000004e-21 | NR | WP_006601361.1 | 2246 | g69010 | i0 | 53 | 7.50395778364116 | 115 | 44 | 90.2 | 4 | 37 | 378 | 3 | 108 | WP_006601361.1 cysteine hydrolase family protein [Haloferax volcanii] | diamond | 2844 | 94.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 30823944 | 30823944 | PRJEB66218_P_NODE_235834_length_203_cov_0.915493_g233403_i0 | PRJEB66218 | 235834 | 203 | 0.915493 | 1.85845079 | Methanoculleus frigidifontis | 2584085 | Archaea | Archaea | 67.4 | 4.28e-11 | NR | WP_301663031.1 | 2584085 | g233403 | i0 | 44.8 | 1.98029556650246 | 67 | 37 | 99 | 0 | 201 | 1 | 131 | 197 | WP_301663031.1 glycosyltransferase [Methanoculleus frigidifontis] | diamond | 402 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus frigidifontis | |
| 31171169 | 31171169 | PRJEB66218_P_NODE_135475_length_256_cov_1.000000_g133046_i0 | PRJEB66218 | 135475 | 256 | 1 | 2.56 | Methanomicrobiales archaeon HGW-Methanomicrobiales-4 | 2013820 | Archaea | Archaea | 46.6 | 0.00178 | NR | PKL60559.1 | 2013820 | g133046 | i0 | 45.3 | 0.62109375 | 53 | 20 | 51.6 | 2 | 12 | 143 | 85 | 137 | PKL60559.1 MAG: mechanosensitive ion channel protein MscS [Methanomicrobiales archaeon HGW-Methanomicrobiales-4] | diamond | 159 | 46.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon HGW-Methanomicrobiales-4 | |||
| 31361321 | 31361321 | PRJEB66218_P_NODE_150976_length_241_cov_1.100000_g148547_i0 | PRJEB66218 | 150976 | 241 | 1.1 | 2.651 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 50.4 | 6.91e-5 | NR | HID71581.1 | 1906666 | g148547 | i0 | 56.8 | 0.921161825726141 | 37 | 16 | 46.1 | 0 | 130 | 240 | 210 | 246 | HID71581.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 222 | 50.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31645707 | 31645707 | PRJEB66218_P_NODE_19337_length_900_cov_3.131108_g17304_i0 | PRJEB66218 | 19337 | 900 | 3.131108 | 28.179972 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 68.6 | 1.02e-8 | NR | WP_292800363.1 | 66852 | g17304 | i0 | 29.4 | 0.703333333333333 | 211 | 116 | 65.3 | 10 | 883 | 296 | 779 | 971 | WP_292800363.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 633 | 68.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31740592 | 31740592 | PRJEB66218_P_NODE_154217_length_238_cov_2.033898_g151788_i0 | PRJEB66218 | 154217 | 238 | 2.033898 | 4.84067724 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 43.1 | 0.0269 | NR | MBQ2654221.1 | 66852 | g151788 | i0 | 38.8 | 0.617647058823529 | 49 | 29 | 61.8 | 1 | 8 | 154 | 558 | 605 | MBQ2654221.1 Ig-like domain repeat protein [Methanobrevibacter sp.] | diamond | 147 | 43.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31740658 | 31740658 | PRJEB66218_P_NODE_35877_length_597_cov_2.761194_g33494_i0 | PRJEB66218 | 35877 | 597 | 2.761194 | 16.48432818 | Methanoculleus sp. | 90427 | Archaea | Archaea | 78.2 | 5.36e-13 | NR | WP_346733691.1 | 90427 | g33494 | i0 | 35.6 | 0.748743718592965 | 149 | 82 | 73.9 | 5 | 458 | 18 | 162 | 298 | WP_346733691.1 kelch repeat-containing protein [Methanoculleus sp.] | diamond | 447 | 78.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 31835537 | 31835537 | PRJEB66218_P_NODE_90197_length_327_cov_1.710526_g87770_i0 | PRJEB66218 | 90197 | 327 | 1.710526 | 5.59342002 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 66.2 | 4.08e-10 | NR | NJD76986.1 | 2032688 | g87770 | i0 | 30.8 | 1.96330275229358 | 107 | 66 | 98.2 | 2 | 321 | 1 | 120 | 218 | NJD76986.1 hypothetical protein [Candidatus Methanoperedens sp.] | diamond | 642 | 66.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 32468659 | 32468659 | PRJEB66218_P_NODE_134759_length_256_cov_3.015385_g132330_i0 | PRJEB66218 | 134759 | 256 | 3.015385 | 7.7193856 | Methanocaldococcus villosus | 667126 | Archaea | Archaea | 50.4 | 2.75e-5 | NR | WP_004592618.1 | 667126 | g132330 | i0 | 38.7 | 0.87890625 | 75 | 29 | 87.9 | 2 | 255 | 31 | 85 | 142 | WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus] | diamond | 225 | 50.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus villosus |
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);;