contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA437204" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15736210 | 15736210 | PRJNA437204_P_NODE_91633_length_249_cov_0.875000_g91334_i0 | PRJNA437204 | 91633 | 249 | 0.875 | 2.17875 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 161 | 5.929999999999999e-47 | NR | MBE6528590.1 | 1906666 | g91334 | i0 | 98.8 | 0.987951807228916 | 82 | 1 | 98.8 | 0 | 3 | 248 | 174 | 255 | MBE6528590.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 246 | 161 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 18283540 | 18283540 | PRJNA437204_P_NODE_123635_length_242_cov_0.911243_g123336_i0 | PRJNA437204 | 123635 | 242 | 0.911243 | 2.20520806 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 156 | 2.8199999999999994e-42 | NR | WP_295614768.1 | 253161 | g123336 | i0 | 91.3 | 0.991735537190083 | 80 | 7 | 99.2 | 0 | 242 | 3 | 139 | 218 | WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.] | diamond | 240 | 156 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 24658123 | 24658123 | PRJNA437204_P_NODE_118600_length_243_cov_0.905882_g118301_i0 | PRJNA437204 | 118600 | 243 | 0.905882 | 2.20129326 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 155 | 7.56e-42 | NR | WP_295614768.1 | 253161 | g118301 | i0 | 96.3 | 1 | 81 | 3 | 100 | 0 | 243 | 1 | 7 | 87 | WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.] | diamond | 243 | 155 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 27123563 | 27123563 | PRJNA437204_P_NODE_124082_length_242_cov_0.911243_g123783_i0 | PRJNA437204 | 124082 | 242 | 0.911243 | 2.20520806 | Methanobrevibacter | 2172 | Archaea | Archaea | 144 | 3.929999999999999e-40 | NR | WP_069575356.1 | 2172 | g123783 | i0 | 87.5 | 1.98347107438017 | 80 | 10 | 99.2 | 0 | 3 | 242 | 8 | 87 | WP_069575356.1 MULTISPECIES: beta-ribofuranosylaminobenzene 5'-phosphate synthase [Methanobrevibacter] | diamond | 480 | 144 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | ||
| 27392099 | 27392099 | PRJNA437204_P_NODE_22423_length_395_cov_0.776398_g22124_i0 | PRJNA437204 | 22423 | 395 | 0.776398 | 3.0667721 | Candidatus Poseidoniaceae archaeon | 2666346 | Archaea | Archaea | 80.5 | 2.5e-15 | NR | HII50895.1 | 2666346 | g22124 | i0 | 53.7 | 2.03544303797468 | 67 | 31 | 50.9 | 0 | 173 | 373 | 3 | 69 | HII50895.1 hypothetical protein [Candidatus Poseidoniaceae archaeon] | diamond | 804 | 80.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidoniaceae archaeon | |||
| 27455291 | 27455291 | PRJNA437204_P_NODE_127383_length_241_cov_0.916667_g127084_i0 | PRJNA437204 | 127383 | 241 | 0.916667 | 2.20916747 | unclassified Methanobrevibacter | 2638681 | Archaea | Archaea | 148 | 2.36e-41 | NR | WP_305514040.1 | 2638681 | g127084 | i0 | 91.3 | 1.99170124481328 | 80 | 7 | 99.6 | 0 | 241 | 2 | 57 | 136 | WP_305514040.1 MULTISPECIES: nicotinate mononucleotide-dependent phosphoribosyltransferase CobT [unclassified Methanobrevibacter] | diamond | 480 | 148 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | ||
| 28086454 | 28086454 | PRJNA437204_P_NODE_113125_length_244_cov_0.900585_g112826_i0 | PRJNA437204 | 113125 | 244 | 0.900585 | 2.1974274 | Methanogenium sp. | 2196 | Archaea | Archaea | 75.1 | 1.14e-13 | NR | MFA5396831.1 | 2196 | g112826 | i0 | 45.1 | 1.00819672131148 | 82 | 42 | 98.4 | 2 | 242 | 3 | 131 | 211 | MFA5396831.1 DUF559 domain-containing protein [Methanogenium sp.] | diamond | 246 | 75.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 28181081 | 28181081 | PRJNA437204_P_NODE_88586_length_249_cov_1.181818_g88287_i0 | PRJNA437204 | 88586 | 249 | 1.181818 | 2.94272682 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 42.4 | 0.00798 | NR | MBO7695000.1 | 66852 | g88287 | i0 | 53.3 | 0.542168674698795 | 45 | 19 | 51.8 | 1 | 144 | 16 | 4 | 48 | MBO7695000.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 135 | 42.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28781067 | 28781067 | PRJNA437204_P_NODE_51587_length_297_cov_1.370536_g51288_i0 | PRJNA437204 | 51587 | 297 | 1.370536 | 4.07049192 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 96.7 | 2.5300000000000003e-21 | NR | RLF38486.1 | 1906666 | g51288 | i0 | 68.7 | 4.3030303030303 | 67 | 21 | 67.7 | 0 | 63 | 263 | 3 | 69 | RLF38486.1 MAG: molecular chaperone DnaJ [Thermoplasmata archaeon] | diamond | 1278 | 96.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28844190 | 28844190 | PRJNA437204_P_NODE_60048_length_281_cov_1.110577_g59749_i0 | PRJNA437204 | 60048 | 281 | 1.110577 | 3.12072137 | Methanococcoides burtonii | 29291 | Archaea | Archaea | 54.3 | 4.8e-6 | NR | WP_232221983.1 | 29291 | g59749 | i0 | 35.2 | 0.97153024911032 | 91 | 58 | 97.2 | 1 | 273 | 1 | 37 | 126 | WP_232221983.1 serpin family protein [Methanococcoides burtonii] | diamond | 273 | 54.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanococcoides | Methanococcoides burtonii | |
| 29002669 | 29002669 | PRJNA437204_P_NODE_103108_length_246_cov_0.890173_g102809_i0 | PRJNA437204 | 103108 | 246 | 0.890173 | 2.18982558 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 79.3 | 3.33e-15 | NR | MEM4258062.1 | 2806419 | g102809 | i0 | 46.3 | 0.975609756097561 | 80 | 43 | 97.6 | 0 | 241 | 2 | 268 | 347 | MEM4258062.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 240 | 79.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29397485 | 29397485 | PRJNA437204_P_NODE_118789_length_243_cov_0.905882_g118490_i0 | PRJNA437204 | 118789 | 243 | 0.905882 | 2.20129326 | Archaea | 2157 | Archaea | Archaea | 73.2 | 6.67e-13 | NR | MBM4248069.1 | 2026739 | g118490 | i0 | 63.5 | 2.44444444444444 | 63 | 21 | 77.8 | 1 | 241 | 53 | 245 | 305 | MBM4248069.1 mevalonate kinase [Methanobacteriota archaeon] | diamond | 594 | 73.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29444033 | 29444033 | PRJNA437204_P_NODE_42190_length_319_cov_0.825203_g41891_i0 | PRJNA437204 | 42190 | 319 | 0.825203 | 2.63239757 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 67 | 2.82e-10 | NR | MBU38166.1 | 2026739 | g41891 | i0 | 45.7 | 0.987460815047022 | 105 | 45 | 97.8 | 6 | 317 | 6 | 1927 | 2020 | MBU38166.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 315 | 67 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29886491 | 29886491 | PRJNA437204_P_NODE_41651_length_320_cov_1.246964_g41352_i0 | PRJNA437204 | 41651 | 320 | 1.246964 | 3.9902848 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 186 | 1.25e-57 | NR | MBE6526235.1 | 1906666 | g41352 | i0 | 100 | 0.99375 | 106 | 0 | 99.4 | 0 | 318 | 1 | 8 | 113 | MBE6526235.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 318 | 186 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30265724 | 30265724 | PRJNA437204_P_NODE_112812_length_244_cov_0.900585_g112513_i0 | PRJNA437204 | 112812 | 244 | 0.900585 | 2.1974274 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 142 | 3.039999999999999e-38 | NR | WP_292786634.1 | 66852 | g112513 | i0 | 88.8 | 1.9672131147541 | 80 | 9 | 98.4 | 0 | 242 | 3 | 8 | 87 | WP_292786634.1 TrkH family potassium uptake protein [Methanobrevibacter sp.] | diamond | 480 | 142 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30329162 | 30329162 | PRJNA437204_P_NODE_102632_length_246_cov_0.890173_g102333_i0 | PRJNA437204 | 102632 | 246 | 0.890173 | 2.18982558 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 61.2 | 1.2e-8 | NR | MBU38165.1 | 2026739 | g102333 | i0 | 38.4 | 1.04878048780488 | 86 | 47 | 98.8 | 4 | 244 | 2 | 211 | 295 | MBU38165.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 258 | 61.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30834168 | 30834168 | PRJNA437204_P_NODE_105334_length_246_cov_0.890173_g105035_i0 | PRJNA437204 | 105334 | 246 | 0.890173 | 2.18982558 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 111 | 3.5800000000000003e-29 | NR | WP_405268717.1 | 66852 | g105035 | i0 | 65.9 | 2.82926829268293 | 85 | 24 | 98.8 | 2 | 245 | 3 | 1 | 84 | WP_405268717.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 696 | 111 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30834211 | 30834211 | PRJNA437204_P_NODE_92294_length_249_cov_0.875000_g91995_i0 | PRJNA437204 | 92294 | 249 | 0.875 | 2.17875 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 50.1 | 1.08e-4 | NR | MBU38166.1 | 2026739 | g91995 | i0 | 45.8 | 0.710843373493976 | 59 | 29 | 69.9 | 2 | 175 | 2 | 1969 | 2025 | MBU38166.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 177 | 50.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31023793 | 31023793 | PRJNA437204_P_NODE_55035_length_290_cov_1.202765_g54736_i0 | PRJNA437204 | 55035 | 290 | 1.202765 | 3.4880185 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 175 | 1.3e-52 | NR | WP_296788087.1 | 253161 | g54736 | i0 | 93.2 | 0.910344827586207 | 88 | 6 | 91 | 0 | 264 | 1 | 1 | 88 | WP_296788087.1 class II glutamine amidotransferase [uncultured Methanobrevibacter sp.] | diamond | 264 | 175 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 31023810 | 31023810 | PRJNA437204_P_NODE_92195_length_249_cov_0.875000_g91896_i0 | PRJNA437204 | 92195 | 249 | 0.875 | 2.17875 | Methanobrevibacter thaueri | 190975 | Archaea | Archaea | 149 | 6.11e-42 | NR | WP_116591199.1 | 190975 | g91896 | i0 | 92.3 | 0.939759036144578 | 78 | 6 | 94 | 0 | 1 | 234 | 159 | 236 | WP_116591199.1 NAD-dependent epimerase/dehydratase family protein [Methanobrevibacter thaueri] | diamond | 234 | 149 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter thaueri | |
| 31149715 | 31149715 | PRJNA437204_P_NODE_84355_length_250_cov_0.870056_g84056_i0 | PRJNA437204 | 84355 | 250 | 0.870056 | 2.17514 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 108 | 3.87e-28 | NR | MBQ2653521.1 | 66852 | g84056 | i0 | 67.9 | 0.936 | 78 | 23 | 91.2 | 2 | 229 | 2 | 1 | 78 | MBQ2653521.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 234 | 108 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31561425 | 31561425 | PRJNA437204_P_NODE_33776_length_343_cov_1.114815_g33477_i0 | PRJNA437204 | 33776 | 343 | 1.114815 | 3.82381545 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 80.1 | 1.01e-14 | NR | MBU38166.1 | 2026739 | g33477 | i0 | 42.7 | 1.74927113702624 | 89 | 47 | 77 | 3 | 80 | 343 | 1795 | 1880 | MBU38166.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 600 | 80.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31750900 | 31750900 | PRJNA437204_P_NODE_51757_length_297_cov_1.031250_g51458_i0 | PRJNA437204 | 51757 | 297 | 1.03125 | 3.0628125 | Methanobrevibacter thaueri | 190975 | Archaea | Archaea | 198 | 1.35e-61 | NR | WP_303723960.1 | 190975 | g51458 | i0 | 97.8 | 13.8383838383838 | 92 | 2 | 92.9 | 0 | 276 | 1 | 1 | 92 | WP_303723960.1 class II glutamine amidotransferase [Methanobrevibacter thaueri] | diamond | 4110 | 198 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter thaueri | |
| 32162462 | 32162462 | PRJNA437204_P_NODE_63138_length_276_cov_1.059113_g62839_i0 | PRJNA437204 | 63138 | 276 | 1.059113 | 2.92315188 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 114 | 5.09e-27 | NR | MBG17153.1 | 2026739 | g62839 | i0 | 59.1 | 15.0652173913043 | 93 | 36 | 98.9 | 1 | 274 | 2 | 519 | 611 | MBG17153.1 ribonucleoside-diphosphate reductase subunit alpha [Methanobacteriota archaeon] | diamond | 4158 | 114 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32605142 | 32605142 | PRJNA437204_P_NODE_69280_length_266_cov_1.357513_g68981_i0 | PRJNA437204 | 69280 | 266 | 1.357513 | 3.6109845800000002 | Methanobacterium sp. SMA-27 | 1495336 | Archaea | Archaea | 57.4 | 2.3e-7 | NR | WP_197050653.1 | 1495336 | g68981 | i0 | 50 | 0.586466165413534 | 52 | 26 | 58.6 | 0 | 111 | 266 | 1 | 52 | WP_197050653.1 ABC transporter ATP-binding protein [Methanobacterium sp. SMA-27] | diamond | 156 | 57.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. SMA-27 |
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);;