contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1106784 | 1106784 | PRJNA494251_P_NODE_37581_length_251_cov_0.865169_g37267_i0 | PRJNA494251 | 37581 | 251 | 0.865169 | 2.17157419 | root | 1 | Root_unresolved | Root_unresolved | 73.2 | 9.55e-14 | NR | HKZ62992.1 | 1906666 | g37267 | i0 | 64.3 | 2.71314741035857 | 56 | 20 | 66.9 | 0 | 2 | 169 | 19 | 74 | HKZ62992.1 DUF5655 domain-containing protein [Thermoplasmata archaeon] | diamond | 681 | 73.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26649174 | 26649174 | PRJNA494251_P_NODE_5161_length_561_cov_1.262295_g4867_i0 | PRJNA494251 | 5161 | 561 | 1.262295 | 7.08147495 | Methanoregula | 395331 | Archaea | Archaea | 79.7 | 1.73e-14 | NR | HSQ94182.1 | 2052170 | g4867 | i0 | 26.2 | 9.77540106951872 | 191 | 129 | 99.5 | 4 | 3 | 560 | 47 | 230 | HSQ94182.1 aquaporin Z [Methanoregula sp.] | diamond | 5484 | 80.1 | 0.995006242197254 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 26776180 | 26776180 | PRJNA494251_P_NODE_34741_length_257_cov_1.103261_g34427_i0 | PRJNA494251 | 34741 | 257 | 1.103261 | 2.83538077 | Stenosarchaea group | 2290931 | Archaea | Archaea | 48.1 | 5.14e-4 | NR | WP_199233658.1 | 1537267 | g34427 | i0 | 31.2 | 6.18677042801556 | 77 | 53 | 89.9 | 0 | 10 | 240 | 29 | 105 | WP_199233658.1 NAD-dependent epimerase/dehydratase family protein, partial [Halorubrum sp. SP9] | diamond | 1590 | 48.5 | 0.991752577319588 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. SP9 | |
| 26887322 | 26887322 | PRJNA494251_P_NODE_7721_length_471_cov_1.298995_g7418_i0 | PRJNA494251 | 7721 | 471 | 1.298995 | 6.11826645 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 51.6 | 2.4e-4 | NR | RYE84638.1 | 2250255 | g7418 | i0 | 38 | 0.452229299363057 | 71 | 41 | 45.2 | 1 | 259 | 471 | 75 | 142 | RYE84638.1 MAG: hypothetical protein EOO65_01930 [Methanosarcinales archaeon] | diamond | 213 | 51.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 27772092 | 27772092 | PRJNA494251_P_NODE_43844_length_245_cov_1.755814_g43530_i0 | PRJNA494251 | 43844 | 245 | 1.755814 | 4.3017443 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 68.9 | 1.64e-11 | NR | RYF00025.1 | 2026739 | g43530 | i0 | 40 | 0.857142857142857 | 70 | 42 | 85.7 | 0 | 1 | 210 | 102 | 171 | RYF00025.1 MAG: hypothetical protein EOO41_00120 [Methanobacteriota archaeon] | diamond | 210 | 68.9 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28024578 | 28024578 | PRJNA494251_P_NODE_41085_length_248_cov_0.880000_g40771_i0 | PRJNA494251 | 41085 | 248 | 0.88 | 2.1824 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 78.6 | 1.46e-15 | NR | MEM4779004.1 | 1906666 | g40771 | i0 | 47.4 | 5.6491935483871 | 78 | 41 | 94.4 | 0 | 15 | 248 | 55 | 132 | MEM4779004.1 ATP-binding cassette domain-containing protein [Thermoplasmata archaeon] | diamond | 1401 | 78.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28308718 | 28308718 | PRJNA494251_P_NODE_2926_length_716_cov_2.259720_g2657_i0 | PRJNA494251 | 2926 | 716 | 2.25972 | 16.1795952 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 57.8 | 1.32e-5 | NR | MEE3325473.1 | 2666342 | g2657 | i0 | 25.4 | 1.88128491620112 | 244 | 128 | 96.8 | 13 | 697 | 5 | 100 | 302 | MEE3325473.1 hypothetical protein [Methanosphaera sp.] | diamond | 1347 | 57.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 28656039 | 28656039 | PRJNA494251_P_NODE_24347_length_294_cov_1.361991_g24033_i0 | PRJNA494251 | 24347 | 294 | 1.361991 | 4.00425354 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 102 | 2.41e-25 | NR | MEE3444538.1 | 66852 | g24033 | i0 | 52.6 | 0.989795918367347 | 97 | 46 | 99 | 0 | 3 | 293 | 5 | 101 | MEE3444538.1 40S ribosomal protein S19 [Methanobrevibacter sp.] | diamond | 291 | 102 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28797630 | 28797630 | PRJNA494251_P_NODE_36127_length_253_cov_1.122222_g35813_i0 | PRJNA494251 | 36127 | 253 | 1.122222 | 2.83922166 | Archaea | 2157 | Archaea | Archaea | 82.4 | 7.57e-18 | NR | RZP10485.1 | 2163009 | g35813 | i0 | 47.5 | 2.83399209486166 | 80 | 40 | 94.9 | 1 | 252 | 13 | 56 | 133 | RZP10485.1 MAG: PaaI family thioesterase, partial [Candidatus Poseidoniales archaeon] | diamond | 717 | 82.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 29871425 | 29871425 | PRJNA494251_P_NODE_39211_length_249_cov_0.875000_g38897_i0 | PRJNA494251 | 39211 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.0063 | NR | AIF23262.1 | 1456558 | g38897 | i0 | 32.4 | 5.49397590361446 | 71 | 45 | 85.5 | 1 | 214 | 2 | 2027 | 2094 | AIF23262.1 RCC1 domain-containing protein [uncultured marine group II/III euryarchaeote SAT1000_14_B08] | diamond | 1368 | 45.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | uncultured marine group II/III euryarchaeote SAT1000_14_B08 | ||||||
| 30108447 | 30108447 | PRJNA494251_P_NODE_16032_length_348_cov_1.116364_g15719_i0 | PRJNA494251 | 16032 | 348 | 1.116364 | 3.88494672 | Candidatus Sysuiplasma superficiale | 2823368 | Archaea | Archaea | 54.7 | 8.23e-6 | NR | MBX8643924.1 | 2823368 | g15719 | i0 | 36.7 | 0.844827586206897 | 98 | 56 | 83.6 | 3 | 304 | 14 | 490 | 582 | MBX8643924.1 AAA family ATPase [Candidatus Sysuiplasma superficiale] | diamond | 294 | 54.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Candidatus Sysuiplasmatales | Candidatus Sysuiplasmataceae | Candidatus Sysuiplasma | Candidatus Sysuiplasma superficiale | ||
| 30171598 | 30171598 | PRJNA494251_P_NODE_13072_length_378_cov_1.262295_g12764_i0 | PRJNA494251 | 13072 | 378 | 1.262295 | 4.7714751 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 156 | 2.96e-41 | NR | MAD56215.1 | 2026739 | g12764 | i0 | 61.6 | 0.992063492063492 | 125 | 48 | 99.2 | 0 | 2 | 376 | 912 | 1036 | MAD56215.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 375 | 156 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30393352 | 30393352 | PRJNA494251_P_NODE_4233_length_612_cov_4.812616_g3943_i0 | PRJNA494251 | 4233 | 612 | 4.812616 | 29.45320992 | Haloplanus salinus | 1126245 | Archaea | Archaea | 84.7 | 2.01e-16 | NR | WP_114450628.1 | 1126245 | g3943 | i0 | 32.6 | 2.07843137254902 | 138 | 88 | 67.6 | 1 | 14 | 427 | 48 | 180 | WP_114450628.1 DUF4397 domain-containing protein [Haloplanus salinus] | diamond | 1272 | 84.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus salinus | |
| 30645432 | 30645432 | PRJNA494251_P_NODE_31473_length_267_cov_1.231959_g31159_i0 | PRJNA494251 | 31473 | 267 | 1.231959 | 3.28933053 | Candidatus Poseidoniaceae archaeon | 2666346 | Archaea | Archaea | 80.1 | 7.83e-16 | NR | HII50895.1 | 2666346 | g31159 | i0 | 53.7 | 3.01123595505618 | 67 | 31 | 75.3 | 0 | 216 | 16 | 3 | 69 | HII50895.1 hypothetical protein [Candidatus Poseidoniaceae archaeon] | diamond | 804 | 80.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidoniaceae archaeon | |||
| 30835175 | 30835175 | PRJNA494251_P_NODE_2914_length_717_cov_1.739130_g2645_i0 | PRJNA494251 | 2914 | 717 | 1.73913 | 12.4695621 | Haladaptatus caseinilyticus | 2993314 | Archaea | Archaea | 79.7 | 4.29e-13 | NR | WP_266077698.1 | 2993314 | g2645 | i0 | 30.4 | 1.88284518828452 | 148 | 99 | 60.7 | 3 | 22 | 456 | 123 | 269 | WP_266077698.1 DUF4397 domain-containing protein [Haladaptatus caseinilyticus] | diamond | 1350 | 79.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus caseinilyticus | |
| 30929989 | 30929989 | PRJNA494251_P_NODE_10474_length_415_cov_1.798246_g10168_i0 | PRJNA494251 | 10474 | 415 | 1.798246 | 7.4627209 | Haloarculaceae archaeon | 2497615 | Archaea | Archaea | 45.4 | 0.0167 | NR | MEF8842997.1 | 2497615 | g10168 | i0 | 40 | 0.650602409638554 | 90 | 46 | 60.7 | 3 | 19 | 270 | 60 | 147 | MEF8842997.1 MBL fold metallo-hydrolase [Haloarculaceae archaeon] | diamond | 270 | 45.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarculaceae archaeon | ||
| 31229777 | 31229777 | PRJNA494251_P_NODE_5415_length_549_cov_3.508403_g5120_i0 | PRJNA494251 | 5415 | 549 | 3.508403 | 19.26113247 | Archaea | 2157 | Archaea | Archaea | 49.3 | 3.64e-4 | NR | HID25561.1 | 1906666 | g5120 | i0 | 49 | 1.51366120218579 | 51 | 26 | 27.9 | 0 | 37 | 189 | 4 | 54 | HID25561.1 50S ribosomal protein P1 [Thermoplasmata archaeon] | diamond | 831 | 49.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31340879 | 31340879 | PRJNA494251_P_NODE_17636_length_334_cov_1.750958_g17322_i0 | PRJNA494251 | 17636 | 334 | 1.750958 | 5.84819972 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 90.1 | 1.5e-19 | NR | RMG30150.1 | 2026739 | g17322 | i0 | 45.9 | 1.77844311377246 | 98 | 53 | 88 | 0 | 299 | 6 | 7 | 104 | RMG30150.1 MAG: aquaporin [Methanobacteriota archaeon] | diamond | 594 | 90.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31546421 | 31546421 | PRJNA494251_P_NODE_20136_length_316_cov_2.432099_g19822_i0 | PRJNA494251 | 20136 | 316 | 2.432099 | 7.68543284 | Methanomicrobiales | 2191 | Archaea | Archaea | 60.5 | 4.82e-8 | NR | WP_318622147.1 | 394967 | g19822 | i0 | 39.4 | 3.9493670886076 | 104 | 52 | 98.7 | 3 | 314 | 3 | 33 | 125 | WP_318622147.1 peptide chain release factor aRF-1 [Methanoculleus receptaculi] | diamond | 1248 | 60.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus receptaculi | |
| 31641041 | 31641041 | PRJNA494251_P_NODE_37256_length_251_cov_0.865169_g36942_i0 | PRJNA494251 | 37256 | 251 | 0.865169 | 2.17157419 | Methanobacteriati | 3366610 | Archaea | Archaea | 48.9 | 2.68e-4 | NR | MAY05171.1 | 2026739 | g36942 | i0 | 51.4 | 0.884462151394422 | 37 | 18 | 44.2 | 0 | 249 | 139 | 176 | 212 | MAY05171.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 222 | 49.3 | 0.991886409736308 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32068341 | 32068341 | PRJNA494251_P_NODE_43258_length_246_cov_0.890173_g42944_i0 | PRJNA494251 | 43258 | 246 | 0.890173 | 2.18982558 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 80.5 | 1.93e-15 | NR | RMG40079.1 | 2026739 | g42944 | i0 | 50 | 0.951219512195122 | 78 | 34 | 95.1 | 1 | 239 | 6 | 445 | 517 | RMG40079.1 MAG: S9 family peptidase [Methanobacteriota archaeon] | diamond | 234 | 80.5 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota 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);;