contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA914897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26644441 | 26644441 | PRJNA914897_P_NODE_11501_length_546_cov_1.503171_g11081_i0 | PRJNA914897 | 11501 | 546 | 1.503171 | 8.20731366 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 108 | 1.74e-25 | NR | RMG30150.1 | 2026739 | g11081 | i0 | 37.5 | 0.923076923076923 | 168 | 100 | 91.2 | 2 | 47 | 544 | 56 | 220 | RMG30150.1 MAG: aquaporin [Methanobacteriota archaeon] | diamond | 504 | 108 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 26644457 | 26644457 | PRJNA914897_P_NODE_2381_length_1256_cov_1.918850_g2169_i0 | PRJNA914897 | 2381 | 1256 | 1.91885 | 24.100756 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 52.4 | 0.00429 | NR | WP_292749283.1 | 66852 | g2169 | i0 | 28.7 | 0.32484076433121 | 136 | 84 | 29.4 | 3 | 430 | 62 | 268 | 403 | WP_292749283.1 C1 family peptidase [Methanobrevibacter sp.] | diamond | 408 | 52.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27309224 | 27309224 | PRJNA914897_P_NODE_9303_length_625_cov_3.054348_g8888_i0 | PRJNA914897 | 9303 | 625 | 3.054348 | 19.089675 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 99.4 | 9.87e-22 | NR | RMG30150.1 | 2026739 | g8888 | i0 | 32.5 | 0.7968 | 166 | 108 | 79.2 | 2 | 130 | 624 | 10 | 172 | RMG30150.1 MAG: aquaporin [Methanobacteriota archaeon] | diamond | 498 | 99.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28982736 | 28982736 | PRJNA914897_P_NODE_27928_length_303_cov_1.339130_g27504_i0 | PRJNA914897 | 27928 | 303 | 1.33913 | 4.0575639 | Methanothermobacter marburgensis | 145263 | Archaea | Archaea | 52 | 4.32e-5 | NR | WP_013295055.1 | 145263 | g27504 | i0 | 38.9 | 6.05940594059406 | 72 | 42 | 71.3 | 1 | 88 | 303 | 338 | 407 | WP_013295055.1 IGHMBP2 family helicase [Methanothermobacter marburgensis] | diamond | 1836 | 52 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanothermobacter | Methanothermobacter marburgensis | |
| 29329796 | 29329796 | PRJNA914897_P_NODE_229_length_2660_cov_10.045613_g192_i0 | PRJNA914897 | 229 | 2660 | 10.045613 | 267.2133058 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 69.3 | 6.59e-8 | NR | HNJ81026.1 | 2485498 | g192 | i0 | 53.3 | 0.841353383458647 | 60 | 26 | 6.8 | 1 | 799 | 620 | 603 | 660 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 2238 | 69.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 29361435 | 29361435 | PRJNA914897_P_NODE_23729_length_338_cov_1.528302_g23305_i0 | PRJNA914897 | 23729 | 338 | 1.528302 | 5.16566076 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 60.5 | 7.03e-8 | NR | WP_292800363.1 | 66852 | g23305 | i0 | 41.1 | 1.29585798816568 | 73 | 38 | 61.2 | 2 | 1 | 207 | 922 | 993 | WP_292800363.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 438 | 60.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29676756 | 29676756 | PRJNA914897_P_NODE_12930_length_506_cov_2.667436_g12508_i0 | PRJNA914897 | 12930 | 506 | 2.667436 | 13.49722616 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 56.6 | 7.05e-6 | NR | MEE3134389.1 | 2806419 | g12508 | i0 | 49.1 | 1.82608695652174 | 55 | 27 | 32 | 1 | 45 | 206 | 339 | 393 | MEE3134389.1 exosome complex RNA-binding protein Csl4 [Thermoplasmatota archaeon] | diamond | 924 | 56.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30055986 | 30055986 | PRJNA914897_P_NODE_14151_length_477_cov_8.297030_g13729_i0 | PRJNA914897 | 14151 | 477 | 8.29703 | 39.5768331 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 53.1 | 1.02e-5 | NR | HWR63617.1 | 2806419 | g13729 | i0 | 35.1 | 1.10691823899371 | 77 | 50 | 48.4 | 0 | 156 | 386 | 17 | 93 | HWR63617.1 thioredoxin family protein [Thermoplasmatota archaeon] | diamond | 528 | 53.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30309418 | 30309418 | PRJNA914897_P_NODE_9152_length_631_cov_1.844086_g8739_i0 | PRJNA914897 | 9152 | 631 | 1.844086 | 11.63618266 | Candidatus Saliniplasma sp. | 3080558 | Archaea | Archaea | 52 | 6.54e-4 | NR | MFO7793095.1 | 3080558 | g8739 | i0 | 48.9 | 1.29793977812995 | 45 | 23 | 21.4 | 0 | 492 | 358 | 274 | 318 | MFO7793095.1 histidine ammonia-lyase [Candidatus Saliniplasma sp.] | diamond | 819 | 52 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Candidatus Halarchaeoplasmatales | Candidatus Halarchaeoplasmataceae | Candidatus Saliniplasma | Candidatus Saliniplasma sp. | ||
| 30687931 | 30687931 | PRJNA914897_P_NODE_34893_length_260_cov_1.235294_g34469_i0 | PRJNA914897 | 34893 | 260 | 1.235294 | 3.2117644 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 43.5 | 0.0105 | NR | WP_345895079.1 | 66852 | g34469 | i0 | 36.4 | 0.888461538461538 | 77 | 42 | 86.5 | 3 | 20 | 244 | 56 | 127 | WP_345895079.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 231 | 43.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31130059 | 31130059 | PRJNA914897_P_NODE_23415_length_341_cov_1.436567_g22991_i0 | PRJNA914897 | 23415 | 341 | 1.436567 | 4.89869347 | Methanocorpusculum sp. | 2058474 | Archaea | Archaea | 69.3 | 1.41e-11 | NR | MDO5844305.1 | 2058474 | g22991 | i0 | 36.8 | 1.7683284457478 | 106 | 67 | 93.3 | 0 | 337 | 20 | 111 | 216 | MDO5844305.1 MIP/aquaporin family protein [Methanocorpusculum sp.] | diamond | 603 | 69.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum sp. | |
| 31225074 | 31225074 | PRJNA914897_P_NODE_6075_length_804_cov_2.265390_g5711_i0 | PRJNA914897 | 6075 | 804 | 2.26539 | 18.2137356 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 146 | 3.01e-39 | NR | RMG30150.1 | 2026739 | g5711 | i0 | 35.8 | 0.843283582089552 | 226 | 141 | 84.3 | 2 | 6 | 683 | 2 | 223 | RMG30150.1 MAG: aquaporin [Methanobacteriota archaeon] | diamond | 678 | 146 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31288357 | 31288357 | PRJNA914897_P_NODE_4955_length_900_cov_1.943168_g4619_i0 | PRJNA914897 | 4955 | 900 | 1.943168 | 17.488512 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 126 | 5.47e-31 | NR | RMG30150.1 | 2026739 | g4619 | i0 | 36.3 | 0.743333333333333 | 223 | 135 | 73.7 | 4 | 58 | 720 | 5 | 222 | RMG30150.1 MAG: aquaporin [Methanobacteriota archaeon] | diamond | 669 | 126 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31390864 | 31390864 | PRJNA914897_P_NODE_5076_length_888_cov_2.592638_g4734_i0 | PRJNA914897 | 5076 | 888 | 2.592638 | 23.02262544 | root | 1 | Root_unresolved | Root_unresolved | 60.8 | 2.38e-6 | NR | MBO7518105.1 | 66852 | g4734 | i0 | 47.4 | 1.05743243243243 | 57 | 29 | 18.9 | 1 | 519 | 686 | 415 | 471 | MBO7518105.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 939 | 60.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31446642 | 31446642 | PRJNA914897_P_NODE_31036_length_282_cov_2.014354_g30612_i0 | PRJNA914897 | 31036 | 282 | 2.014354 | 5.68047828 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 42.7 | 0.018 | NR | WP_296881009.1 | 253161 | g30612 | i0 | 37.1 | 0.659574468085106 | 62 | 39 | 66 | 0 | 237 | 52 | 42 | 103 | WP_296881009.1 hypothetical protein [uncultured Methanobrevibacter sp.] | diamond | 186 | 42.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 31921077 | 31921077 | PRJNA914897_P_NODE_27797_length_304_cov_1.545455_g27373_i0 | PRJNA914897 | 27797 | 304 | 1.545455 | 4.6981832 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 78.2 | 1.79e-14 | NR | RZD42668.1 | 2026739 | g27373 | i0 | 42.2 | 0.888157894736842 | 90 | 51 | 88.8 | 1 | 35 | 304 | 63 | 151 | RZD42668.1 MAG: hypothetical protein CXT73_02465 [Methanobacteriota archaeon] | diamond | 270 | 78.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32110984 | 32110984 | PRJNA914897_P_NODE_2998_length_1141_cov_11.198502_g192_i1 | PRJNA914897 | 2998 | 1141 | 11.198502 | 127.77490782 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 69.3 | 1.16e-8 | NR | HNJ81026.1 | 2485498 | g192 | i1 | 53.3 | 0.157756354075372 | 60 | 26 | 15.8 | 1 | 799 | 620 | 603 | 660 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 180 | 69.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 32490793 | 32490793 | PRJNA914897_P_NODE_34919_length_260_cov_1.133690_g34495_i0 | PRJNA914897 | 34919 | 260 | 1.13369 | 2.947594 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.5 | 0.0158 | NR | RLF57416.1 | 1906666 | g34495 | i0 | 27.9 | 1.98461538461538 | 86 | 47 | 87.7 | 3 | 27 | 254 | 42 | 122 | RLF57416.1 MAG: DNA polymerase elongation subunit (family B), partial [Thermoplasmata archaeon] | diamond | 516 | 43.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32529852 | 32529852 | PRJNA914897_P_NODE_10379_length_583_cov_1.650980_g9962_i0 | PRJNA914897 | 10379 | 583 | 1.65098 | 9.6252134 | root | 1 | Root_unresolved | Root_unresolved | 84.7 | 3.99e-16 | NR | MDR3292372.1 | 66852 | g9962 | i0 | 33.5 | 3.89536878216123 | 194 | 109 | 91.6 | 6 | 536 | 3 | 10 | 199 | MDR3292372.1 aquaporin family protein [Methanobrevibacter sp.] | diamond | 2271 | 85.5 | 0.990643274853801 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. |
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);;