contig_metadata
22 rows where bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8080573 | 8080573 | PRJNA429937_P_NODE_6907_length_1337_cov_14.831040_g4067_i0 | PRJNA429937 | 6907 | 1337 | 14.83104 | 198.2910048 | Thermococcus | 2263 | Archaea | Archaea | 767 | 2.2600000000000002e-259 | NR | WP_167728776.1 | 163002 | g4067 | i0 | 98.4 | 4.3866866118175 | 387 | 6 | 86.8 | 0 | 130 | 1290 | 20 | 406 | WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3] | diamond | 5865 | 770 | 0.996103896103896 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. 9N3 | ||
| 10629543 | 10629543 | PRJNA429937_P_NODE_113529_length_265_cov_3.012712_g90906_i0 | PRJNA429937 | 113529 | 265 | 3.012712 | 7.9836868 | Haloarcula regularis | 3033392 | Archaea | Archaea | 198 | 2.94e-46 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g90906 | i0 | 88.485 | 0.9660377358490572 | 165 | 17 | 96 | 2 | 102 | 265 | 99853 | 99690 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 256 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 11905897 | 11905897 | PRJNA429937_P_NODE_62550_length_435_cov_3.105911_g42350_i0 | PRJNA429937 | 62550 | 435 | 3.105911 | 13.510712850000001 | Haloarcula regularis | 3033392 | Archaea | Archaea | 298 | 4.89e-76 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g42350 | i0 | 85.763 | 1.59080459770115 | 295 | 26 | 65 | 9 | 154 | 435 | 99562 | 99853 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 692 | 298 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 11906008 | 11906008 | PRJNA429937_P_NODE_69010_length_407_cov_2.304233_g47626_i0 | PRJNA429937 | 69010 | 407 | 2.304233 | 9.37822831 | Haloarcula regularis | 3033392 | Archaea | Archaea | 198 | 4.74e-46 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g47626 | i0 | 88.485 | 0.734643734643735 | 165 | 17 | 73 | 2 | 1 | 164 | 99690 | 99853 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 299 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 15730307 | 15730307 | PRJNA429937_P_NODE_93833_length_321_cov_2.071918_g71243_i0 | PRJNA429937 | 93833 | 321 | 2.071918 | 6.65085678 | Methanobacterium sp. MB1 | 1379702 | Archaea | Archaea | 448 | 3.289999999999999e-121 | NTclustered | gi|557945513|emb|HG425166.1| | 1379702 | g71243 | i0 | 99.197 | 7.08722741433022 | 249 | 0 | 98 | 2 | 9 | 255 | 743204 | 742956 | Methanobacterium sp. MB1 complete sequence | blastn | 2275 | 448 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. MB1 | |
| 20829041 | 20829041 | PRJNA429937_P_NODE_75537_length_381_cov_5.377841_g53418_i0 | PRJNA429937 | 75537 | 381 | 5.377841 | 20.48957421 | Halorubrum sp. CSM-61 | 2485838 | Archaea | Archaea | 245 | 4.61e-78 | NR | WP_123619210.1 | 2485838 | g53418 | i0 | 95.1 | 0.960629921259842 | 122 | 6 | 96.1 | 0 | 14 | 379 | 34 | 155 | WP_123619210.1 galactonate dehydratase [Halorubrum sp. CSM-61] | diamond | 366 | 245 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. CSM-61 | |
| 24653019 | 24653019 | PRJNA429937_P_NODE_42300_length_552_cov_3.936902_g26907_i0 | PRJNA429937 | 42300 | 552 | 3.936902 | 21.73169904 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 477 | 7.56e-130 | NTclustered | gi|2388573995|gb|CP113312.1| | 2032688 | g26907 | i0 | 88.776 | 0.710144927536232 | 392 | 40 | 71 | 4 | 163 | 552 | 14392 | 14781 | MAG: Candidatus Methanoperedens sp. isolate v3 plasmid unnamed | blastn | 392 | 477 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 27201955 | 27201955 | PRJNA429937_P_NODE_5622_length_1464_cov_13.577700_g3308_i0 | PRJNA429937 | 5622 | 1464 | 13.5777 | 198.777528 | candidate division MSBL1 archaeon SCGC-AAA385M11 | 1698288 | Archaea | Archaea | 162 | 1.16e-44 | NR | KXB09026.1 | 1698288 | g3308 | i0 | 94 | 0.172131147540984 | 84 | 5 | 17.2 | 0 | 878 | 1129 | 1 | 84 | KXB09026.1 hypothetical protein AKJ60_01160 [candidate division MSBL1 archaeon SCGC-AAA385M11] | diamond | 252 | 162 | 1 | Archaea | candidate division MSBL1 | Methanobacteriati | Methanobacteriota | candidate division MSBL1 archaeon SCGC-AAA385M11 | |||||
| 27486547 | 27486547 | PRJNA429937_P_NODE_7463_length_1294_cov_8.309091_g4411_i0 | PRJNA429937 | 7463 | 1294 | 8.309091 | 107.51963754 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 333 | 3.3999999999999993e-108 | NR | RZD45823.1 | 2026739 | g4411 | i0 | 47.9 | 0.783616692426584 | 338 | 169 | 77.7 | 3 | 233 | 1237 | 8 | 341 | RZD45823.1 MAG: branched chain amino acid aminotransferase [Methanobacteriota archaeon] | diamond | 1014 | 333 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27991858 | 27991858 | PRJNA429937_P_NODE_88245_length_339_cov_2.916129_g65678_i0 | PRJNA429937 | 88245 | 339 | 2.916129 | 9.88567731 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 198 | 1.08e-62 | NR | MFH0904072.1 | 2026739 | g65678 | i0 | 93.5 | 0.955752212389381 | 108 | 7 | 95.6 | 0 | 1 | 324 | 70 | 177 | MFH0904072.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 324 | 198 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29475332 | 29475332 | PRJNA429937_P_NODE_104930_length_288_cov_2.486486_g82312_i0 | PRJNA429937 | 104930 | 288 | 2.486486 | 7.16107968 | candidate division MSBL1 archaeon SCGC-AAA385M11 | 1698288 | Archaea | Archaea | 115 | 3.62e-29 | NR | KXB09022.1 | 1698288 | g82312 | i0 | 85.7 | 0.65625 | 63 | 9 | 65.6 | 0 | 2 | 190 | 162 | 224 | KXB09022.1 hypothetical protein AKJ60_01185 [candidate division MSBL1 archaeon SCGC-AAA385M11] | diamond | 189 | 115 | 1 | Archaea | candidate division MSBL1 | Methanobacteriati | Methanobacteriota | candidate division MSBL1 archaeon SCGC-AAA385M11 | |||||
| 29776249 | 29776249 | PRJNA429937_P_NODE_57171_length_461_cov_4.319444_g2639_i3 | PRJNA429937 | 57171 | 461 | 4.319444 | 19.91263684 | root | 1 | Root_unresolved | Root_unresolved | 114 | 2.61e-26 | NR | WP_336247442.1 | 2223 | g2639 | i3 | 52.5 | 1.8351409978308 | 141 | 57 | 85.9 | 3 | 396 | 1 | 245 | 384 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 846 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 29871123 | 29871123 | PRJNA429937_P_NODE_10431_length_1122_cov_2.154620_g6122_i0 | PRJNA429937 | 10431 | 1122 | 2.15462 | 24.1748364 | root | 1 | Root_unresolved | Root_unresolved | 216 | 6.999999999999999e-62 | NR | MCX6692367.1 | 2052170 | g6122 | i0 | 40.7 | 3.42513368983957 | 317 | 158 | 78.3 | 7 | 1 | 879 | 88 | 398 | MCX6692367.1 IS1380 family transposase [Methanoregula sp.] | diamond | 3843 | 218 | 0.990825688073395 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30092072 | 30092072 | PRJNA429937_P_NODE_51812_length_490_cov_4.377440_g2639_i2 | PRJNA429937 | 51812 | 490 | 4.37744 | 21.449456 | root | 1 | Root_unresolved | Root_unresolved | 116 | 1.06e-26 | NR | WP_336247442.1 | 2223 | g2639 | i2 | 52.5 | 1.7265306122449 | 141 | 57 | 80.8 | 3 | 396 | 1 | 245 | 384 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 846 | 116 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 30345536 | 30345536 | PRJNA429937_P_NODE_4472_length_1596_cov_4.192087_g2639_i0 | PRJNA429937 | 4472 | 1596 | 4.192087 | 66.90570852 | root | 1 | Root_unresolved | Root_unresolved | 330 | 9.56e-102 | NR | WP_336247442.1 | 2223 | g2639 | i0 | 66.9 | 1.05639097744361 | 281 | 83 | 51.1 | 3 | 1596 | 781 | 245 | 524 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 1686 | 330 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 30439966 | 30439966 | PRJNA429937_P_NODE_102593_length_295_cov_1.593985_g79979_i0 | PRJNA429937 | 102593 | 295 | 1.593985 | 4.70225575 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 0.00387 | NR | MEN6290573.1 | 2164 | g79979 | i0 | 91.7 | 1.95254237288136 | 24 | 2 | 24.4 | 0 | 3 | 74 | 208 | 231 | MEN6290573.1 nucleotide sugar dehydrogenase [Methanobacterium sp.] | diamond | 576 | 46.6 | 0.991416309012876 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 30755821 | 30755821 | PRJNA429937_P_NODE_72754_length_392_cov_2.851240_g50898_i0 | PRJNA429937 | 72754 | 392 | 2.85124 | 11.1768608 | root | 1 | Root_unresolved | Root_unresolved | 143 | 7.079999999999999e-37 | NR | HVN73417.1 | 2052170 | g50898 | i0 | 61.6 | 25.3316326530612 | 112 | 43 | 85.7 | 0 | 18 | 353 | 590 | 701 | HVN73417.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Methanoregula sp.] | diamond | 9930 | 144 | 0.993055555555556 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 31086798 | 31086798 | PRJNA429937_P_NODE_30475_length_659_cov_6.620635_g18542_i0 | PRJNA429937 | 30475 | 659 | 6.620635 | 43.62998465 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 101 | 9.5e-21 | NR | MBF70874.1 | 2026739 | g18542 | i0 | 41.5 | 0.746585735963581 | 164 | 71 | 74.7 | 2 | 145 | 636 | 367 | 505 | MBF70874.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 492 | 101 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31118094 | 31118094 | PRJNA429937_P_NODE_39275_length_576_cov_2.376600_g24755_i0 | PRJNA429937 | 39275 | 576 | 2.3766 | 13.689216 | Thermococcus sp. | 35749 | Archaea | Archaea | 152 | 8.27e-39 | NR | WP_297519241.1 | 35749 | g24755 | i0 | 55.3 | 3.3125 | 159 | 12 | 60.9 | 2 | 438 | 88 | 486 | 627 | WP_297519241.1 DNA polymerase [Thermococcus sp.] | diamond | 1908 | 152 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. | ||
| 31482969 | 31482969 | PRJNA429937_P_NODE_50296_length_499_cov_4.359574_g2639_i1 | PRJNA429937 | 50296 | 499 | 4.359574 | 21.75427426 | root | 1 | Root_unresolved | Root_unresolved | 114 | 4.1e-26 | NR | WP_336247442.1 | 2223 | g2639 | i1 | 52.5 | 1.69539078156313 | 141 | 57 | 79.4 | 3 | 104 | 499 | 245 | 384 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 846 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 31498000 | 31498000 | PRJNA429937_P_NODE_63276_length_432_cov_1.955335_g42935_i0 | PRJNA429937 | 63276 | 432 | 1.955335 | 8.4470472 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 76.3 | 2.26e-13 | NR | MEM4379222.1 | 2268204 | g42935 | i0 | 43.7 | 1.63194444444444 | 103 | 36 | 71.5 | 1 | 15 | 323 | 14 | 94 | MEM4379222.1 FAD-dependent thymidylate synthase [Thermoplasmatales archaeon] | diamond | 705 | 76.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 32527059 | 32527059 | PRJNA429937_P_NODE_64439_length_426_cov_4.680101_g2639_i4 | PRJNA429937 | 64439 | 426 | 4.680101 | 19.93723026 | root | 1 | Root_unresolved | Root_unresolved | 130 | 4.3199999999999996e-32 | NR | WP_336247442.1 | 2223 | g2639 | i4 | 55.6 | 2.12676056338028 | 151 | 57 | 100 | 3 | 426 | 1 | 235 | 384 | WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] | diamond | 906 | 130 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii |
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);;