contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax_clade = "Methanomada group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26973690 | 26973690 | PRJNA1120060_P_NODE_1938382_length_275_cov_2.178218_g1920358_i0 | PRJNA1120060 | 1938382 | 275 | 2.178218 | 5.9900995 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 48.1 | 6.43e-4 | NR | WP_292799713.1 | 66852 | g1920358 | i0 | 39.7 | 0.741818181818182 | 68 | 34 | 68.7 | 2 | 65 | 253 | 169 | 234 | WP_292799713.1 class I SAM-dependent methyltransferase [Methanobrevibacter sp.] | diamond | 204 | 48.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27449063 | 27449063 | PRJNA1120060_P_NODE_3410643_length_215_cov_4.830986_g3392523_i0 | PRJNA1120060 | 3410643 | 215 | 4.830986 | 10.3866199 | Methanobacterium | 2160 | Archaea | Archaea | 146 | 5.259999999999998e-42 | NR | WP_069583365.1 | 2160 | g3392523 | i0 | 93 | 2.97209302325581 | 71 | 5 | 99.1 | 0 | 214 | 2 | 37 | 107 | WP_069583365.1 MULTISPECIES: flavodoxin family protein [Methanobacterium] | diamond | 639 | 146 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | ||
| 27922023 | 27922023 | PRJNA1120060_P_NODE_2733025_length_247_cov_5.528736_g2714941_i0 | PRJNA1120060 | 2733025 | 247 | 5.528736 | 13.65597792 | Methanococcaceae archaeon | 2528253 | Archaea | Archaea | 43.5 | 0.0196 | NR | HID47519.1 | 2528253 | g2714941 | i0 | 30.8 | 1.78542510121457 | 39 | 27 | 47.4 | 0 | 175 | 59 | 19 | 57 | HID47519.1 radical SAM protein [Methanococcaceae archaeon] | diamond | 441 | 43.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcaceae archaeon | ||
| 28522074 | 28522074 | PRJNA1120060_P_NODE_2704587_length_248_cov_2.451429_g2686504_i0 | PRJNA1120060 | 2704587 | 248 | 2.451429 | 6.07954392 | Methanocaldococcus villosus | 667126 | Archaea | Archaea | 44.7 | 0.00828 | NR | WP_017980999.1 | 667126 | g2686504 | i0 | 45.2 | 1.01612903225806 | 42 | 20 | 50.8 | 1 | 204 | 79 | 399 | 437 | WP_017980999.1 cohesin domain-containing protein [Methanocaldococcus villosus] | diamond | 252 | 44.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus villosus | |
| 28617020 | 28617020 | PRJNA1120060_P_NODE_2958387_length_242_cov_2.118343_g2940293_i0 | PRJNA1120060 | 2958387 | 242 | 2.118343 | 5.12639006 | Methanothermococcus okinawensis | 155863 | Archaea | Archaea | 42.7 | 0.0159 | NR | WP_013866548.1 | 155863 | g2940293 | i0 | 33.3 | 0.669421487603306 | 54 | 36 | 66.9 | 0 | 233 | 72 | 67 | 120 | WP_013866548.1 hypothetical protein [Methanothermococcus okinawensis] | diamond | 162 | 42.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanothermococcus | Methanothermococcus okinawensis | |
| 29374891 | 29374891 | PRJNA1120060_P_NODE_3450569_length_211_cov_5.405797_g3432444_i0 | PRJNA1120060 | 3450569 | 211 | 5.405797 | 11.40623167 | Methanobacterium sp. | 2164 | Archaea | Archaea | 135 | 5.41e-36 | NR | MEN6292430.1 | 2164 | g3432444 | i0 | 97.1 | 1.96208530805687 | 69 | 2 | 98.1 | 0 | 210 | 4 | 127 | 195 | MEN6292430.1 DUF5814 domain-containing protein [Methanobacterium sp.] | diamond | 414 | 135 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 30132725 | 30132725 | PRJNA1120060_P_NODE_637732_length_342_cov_4.345725_g619967_i0 | PRJNA1120060 | 637732 | 342 | 4.345725 | 14.8623795 | Methanobacteriales archaeon HGW-Methanobacteriales-1 | 2013815 | Archaea | Archaea | 43.5 | 0.0248 | NR | PKL66576.1 | 2013815 | g619967 | i0 | 48.8 | 0.37719298245614 | 43 | 18 | 34.2 | 1 | 341 | 225 | 75 | 117 | PKL66576.1 MAG: hypothetical protein CVV28_09230 [Methanobacteriales archaeon HGW-Methanobacteriales-1] | diamond | 129 | 43.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriales archaeon HGW-Methanobacteriales-1 | |||
| 30290621 | 30290621 | PRJNA1120060_P_NODE_2516112_length_253_cov_2.500000_g2498040_i0 | PRJNA1120060 | 2516112 | 253 | 2.5 | 6.325 | Methanobacterium sp. | 2164 | Archaea | Archaea | 45.4 | 0.00466 | NR | MDO5836812.1 | 2164 | g2498040 | i0 | 36.5 | 0.74703557312253 | 63 | 40 | 74.7 | 0 | 34 | 222 | 47 | 109 | MDO5836812.1 DUF460 domain-containing protein [Methanobacterium sp.] | diamond | 189 | 45.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 30859305 | 30859305 | PRJNA1120060_P_NODE_3022574_length_239_cov_13.765060_g3004475_i0 | PRJNA1120060 | 3022574 | 239 | 13.76506 | 32.8984934 | Methanobacterium sp. | 2164 | Archaea | Archaea | 94 | 1.84e-22 | NR | HML05427.1 | 2164 | g3004475 | i0 | 74.2 | 0.778242677824268 | 62 | 16 | 77.8 | 0 | 186 | 1 | 1 | 62 | HML05427.1 hemerythrin domain-containing protein [Methanobacterium sp.] | diamond | 186 | 94 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 31459223 | 31459223 | PRJNA1120060_P_NODE_1797996_length_281_cov_1.355769_g1779984_i0 | PRJNA1120060 | 1797996 | 281 | 1.355769 | 3.80971089 | Methanococcus maripaludis | 39152 | Archaea | Archaea | 43.9 | 0.0231 | NR | WP_181505141.1 | 39152 | g1779984 | i0 | 28.9 | 0.811387900355872 | 76 | 53 | 80.1 | 1 | 247 | 23 | 311 | 386 | WP_181505141.1 DEAD/DEAH box helicase [Methanococcus maripaludis] | diamond | 228 | 43.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus maripaludis | |
| 31586481 | 31586481 | PRJNA1120060_P_NODE_2772176_length_247_cov_0.781609_g2754092_i0 | PRJNA1120060 | 2772176 | 247 | 0.781609 | 1.93057423 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 43.9 | 0.0159 | NR | MBR0371871.1 | 66852 | g2754092 | i0 | 41.7 | 1.1417004048583 | 48 | 25 | 54.7 | 1 | 148 | 14 | 968 | 1015 | MBR0371871.1 Ig-like domain repeat protein [Methanobrevibacter sp.] | diamond | 282 | 43.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31734125 | 31734125 | PRJNA1120060_P_NODE_2036977_length_271_cov_2.328283_g2018940_i0 | PRJNA1120060 | 2036977 | 271 | 2.328283 | 6.30964693 | Archaea | 2157 | Archaea | Archaea | 126 | 3.56e-32 | NR | PKL67444.1 | 2013815 | g2018940 | i0 | 72.2 | 3.46494464944649 | 90 | 25 | 99.6 | 0 | 2 | 271 | 325 | 414 | PKL67444.1 MAG: hypothetical protein CVV28_06180 [Methanobacteriales archaeon HGW-Methanobacteriales-1] | diamond | 939 | 126 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriales archaeon HGW-Methanobacteriales-1 | |||
| 31776307 | 31776307 | PRJNA1120060_P_NODE_330177_length_409_cov_1.470238_g312960_i0 | PRJNA1120060 | 330177 | 409 | 1.470238 | 6.01327342 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 47 | 0.00752 | NR | WP_405316112.1 | 66852 | g312960 | i0 | 38.4 | 0.535452322738386 | 73 | 34 | 49.1 | 3 | 66 | 266 | 516 | 583 | WP_405316112.1 hypothetical protein, partial [Methanobrevibacter sp.] | diamond | 219 | 47 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31807810 | 31807810 | PRJNA1120060_P_NODE_2961337_length_242_cov_1.810651_g2943243_i0 | PRJNA1120060 | 2961337 | 242 | 1.810651 | 4.38177542 | Methanobacterium | 2160 | Archaea | Archaea | 157 | 1.55e-44 | NR | WP_069584556.1 | 2160 | g2943243 | i0 | 92.5 | 0.991735537190083 | 80 | 6 | 99.2 | 0 | 2 | 241 | 128 | 207 | WP_069584556.1 MULTISPECIES: DUF1972 domain-containing protein [Methanobacterium] | diamond | 240 | 157 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | ||
| 31955664 | 31955664 | PRJNA1120060_P_NODE_2595157_length_251_cov_1.471910_g2577080_i0 | PRJNA1120060 | 2595157 | 251 | 1.47191 | 3.6944941 | Methanobacterium | 2160 | Archaea | Archaea | 158 | 7.48e-43 | NR | WP_069581922.1 | 2160 | g2577080 | i0 | 89.2 | 2.97609561752988 | 83 | 9 | 99.2 | 0 | 2 | 250 | 123 | 205 | WP_069581922.1 MULTISPECIES: DUF3656 domain-containing U32 family peptidase [Methanobacterium] | diamond | 747 | 159 | 0.993710691823899 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium |
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);;