contig_metadata
21 rows where bioproject = "PRJNA340009", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2943288 | 2943288 | PRJNA340009_P_NODE_8683_length_383_cov_5.353293_g8376_i0 | PRJNA340009 | 8683 | 383 | 5.353293 | 20.50311219 | Methanosarcina sp. MTP4 | 1434100 | Archaea | Archaea | 56.5 | 0.003 | NTclustered | gi|805342629|gb|CP009505.1| | 1434100 | g8376 | i0 | 100 | 0.0783289817232376 | 30 | 0 | 8 | 0 | 335 | 364 | 341886 | 341915 | Methanosarcina sp. MTP4, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. MTP4 | |
| 8045608 | 8045608 | PRJNA340009_P_NODE_55447_length_175_cov_2.428571_g55140_i0 | PRJNA340009 | 55447 | 175 | 2.428571 | 4.24999925 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 182 | 1.8e-41 | NTclustered | gi|2621784703|emb|OY781161.1| | 1005933 | g55140 | i0 | 86.585 | 0.9371428571428572 | 164 | 22 | 94 | 0 | 12 | 175 | 1002823 | 1002660 | MAG: uncultured Methanoregula sp. isolate bdb6c56a-0f97-41a9-9319-40fe56c94967 genome assembly, chromosome: 1 | blastn | 164 | 182 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 26807163 | 26807163 | PRJNA340009_P_NODE_63181_length_167_cov_0.864407_g62874_i0 | PRJNA340009 | 63181 | 167 | 0.864407 | 1.44355969 | Methanoregula | 395331 | Archaea | Archaea | 87 | 1.71e-18 | NR | WP_320161339.1 | 1005933 | g62874 | i0 | 69.1 | 4.94011976047904 | 55 | 17 | 98.8 | 0 | 167 | 3 | 290 | 344 | WP_320161339.1 non-hydrolyzing UDP-N-acetylglucosamine 2-epimerase [uncultured Methanoregula sp.] | diamond | 825 | 87 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 26821688 | 26821688 | PRJNA340009_P_NODE_16341_length_295_cov_1.239837_g16034_i0 | PRJNA340009 | 16341 | 295 | 1.239837 | 3.65751915 | Methanogenium sp. | 2196 | Archaea | Archaea | 49.3 | 3.49e-4 | NR | MFA5398661.1 | 2196 | g16034 | i0 | 36.9 | 0.854237288135593 | 84 | 41 | 78.3 | 3 | 240 | 10 | 98 | 176 | MFA5398661.1 hypothetical protein [Methanogenium sp.] | diamond | 252 | 49.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 26948060 | 26948060 | PRJNA340009_P_NODE_66722_length_165_cov_0.879310_g66415_i0 | PRJNA340009 | 66722 | 165 | 0.87931 | 1.4508615 | Methanoculleus sp. | 90427 | Archaea | Archaea | 56.2 | 1.54e-7 | NR | WP_292561174.1 | 90427 | g66415 | i0 | 48.2 | 1.01818181818182 | 56 | 28 | 100 | 1 | 1 | 165 | 172 | 227 | WP_292561174.1 hypothetical protein [Methanoculleus sp.] | diamond | 168 | 56.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 27011374 | 27011374 | PRJNA340009_P_NODE_76642_length_161_cov_0.910714_g76335_i0 | PRJNA340009 | 76642 | 161 | 0.910714 | 1.46624954 | Methanosarcina sp. | 2213 | Archaea | Archaea | 41.6 | 0.0317 | NR | HET8688143.1 | 2213 | g76335 | i0 | 48.8 | 0.801242236024845 | 43 | 22 | 80.1 | 0 | 3 | 131 | 189 | 231 | HET8688143.1 hypothetical protein [Methanosarcina sp.] | diamond | 129 | 41.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 27359383 | 27359383 | PRJNA340009_P_NODE_72263_length_163_cov_0.894737_g71956_i0 | PRJNA340009 | 72263 | 163 | 0.894737 | 1.45842131 | Salinigranum salinum | 1364937 | Archaea | Archaea | 41.2 | 0.0453 | NR | WP_204959945.1 | 1364937 | g71956 | i0 | 39.5 | 0.699386503067485 | 38 | 23 | 69.9 | 0 | 124 | 11 | 47 | 84 | WP_204959945.1 helix-hairpin-helix domain-containing protein [Salinigranum salinum] | diamond | 114 | 41.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum salinum | |
| 28338039 | 28338039 | PRJNA340009_P_NODE_22286_length_258_cov_1.248804_g21979_i0 | PRJNA340009 | 22286 | 258 | 1.248804 | 3.22191432 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 127 | 2.38e-34 | NR | MCX9026283.1 | 2032688 | g21979 | i0 | 64.3 | 0.976744186046512 | 84 | 30 | 97.7 | 0 | 256 | 5 | 132 | 215 | MCX9026283.1 GNAT family N-acetyltransferase [Candidatus Methanoperedens sp.] | diamond | 252 | 127 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 29176343 | 29176343 | PRJNA340009_P_NODE_43629_length_194_cov_1.406897_g43322_i0 | PRJNA340009 | 43629 | 194 | 1.406897 | 2.72938018 | Stenosarchaea group | 2290931 | Archaea | Archaea | 53.9 | 2.18e-6 | NR | WP_054519926.1 | 1604004 | g43322 | i0 | 47.5 | 1.80927835051546 | 59 | 31 | 91.2 | 0 | 2 | 178 | 98 | 156 | WP_054519926.1 DNA methyltransferase [Halanaeroarchaeum sulfurireducens] | diamond | 351 | 54.3 | 0.992633517495396 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 29253423 | 29253423 | PRJNA340009_P_NODE_69989_length_164_cov_0.886957_g69682_i0 | PRJNA340009 | 69989 | 164 | 0.886957 | 1.45460948 | Methanosarcina sp. | 2213 | Archaea | Archaea | 83.6 | 4.16e-17 | NR | HET8686749.1 | 2213 | g69682 | i0 | 71.7 | 1.9390243902439 | 53 | 15 | 97 | 0 | 164 | 6 | 183 | 235 | HET8686749.1 ribonucleotide reductase N-terminal alpha domain-containing protein [Methanosarcina sp.] | diamond | 318 | 83.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29348467 | 29348467 | PRJNA340009_P_NODE_38429_length_205_cov_1.108974_g38122_i0 | PRJNA340009 | 38429 | 205 | 1.108974 | 2.2733967 | Methanosarcina sp. | 2213 | Archaea | Archaea | 119 | 2.86e-29 | NR | HET8689276.1 | 2213 | g38122 | i0 | 74.6 | 0.980487804878049 | 67 | 17 | 98 | 0 | 203 | 3 | 292 | 358 | HET8689276.1 DNA polymerase [Methanosarcina sp.] | diamond | 201 | 119 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29348507 | 29348507 | PRJNA340009_P_NODE_74969_length_162_cov_0.902655_g74662_i0 | PRJNA340009 | 74969 | 162 | 0.902655 | 1.4623011 | Methanogenium sp. | 2196 | Archaea | Archaea | 53.9 | 1.44e-6 | NR | MFA5394632.1 | 2196 | g74662 | i0 | 60 | 0.740740740740741 | 40 | 16 | 74.1 | 0 | 40 | 159 | 24 | 63 | MFA5394632.1 lytic transglycosylase domain-containing protein [Methanogenium sp.] | diamond | 120 | 53.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 29411460 | 29411460 | PRJNA340009_P_NODE_66889_length_165_cov_0.879310_g66582_i0 | PRJNA340009 | 66889 | 165 | 0.87931 | 1.4508615 | Methanoregula sp. | 2052170 | Archaea | Archaea | 47 | 4.12e-5 | NR | MCK9593839.1 | 2052170 | g66582 | i0 | 46.2 | 0.709090909090909 | 39 | 21 | 70.9 | 0 | 163 | 47 | 31 | 69 | MCK9593839.1 hypothetical protein [Methanoregula sp.] | diamond | 117 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 29506184 | 29506184 | PRJNA340009_P_NODE_79430_length_155_cov_15.962264_g79123_i0 | PRJNA340009 | 79430 | 155 | 15.962264 | 24.7415092 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 43.1 | 0.00807 | NR | MFQ5891455.1 | 2099674 | g79123 | i0 | 55.9 | 1.47096774193548 | 34 | 11 | 58.1 | 1 | 66 | 155 | 69 | 102 | MFQ5891455.1 endonuclease domain-containing protein [Candidatus Methanofastidiosia archaeon] | diamond | 228 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 30801270 | 30801270 | PRJNA340009_P_NODE_25134_length_245_cov_2.341837_g24827_i0 | PRJNA340009 | 25134 | 245 | 2.341837 | 5.73750065 | Methanoculleus sp. | 90427 | Archaea | Archaea | 138 | 1.86e-39 | NR | WP_292561629.1 | 90427 | g24827 | i0 | 78.5 | 0.96734693877551 | 79 | 17 | 96.7 | 0 | 2 | 238 | 82 | 160 | WP_292561629.1 MT-A70 family methyltransferase [Methanoculleus sp.] | diamond | 237 | 138 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 31008247 | 31008247 | PRJNA340009_P_NODE_60794_length_168_cov_1.714286_g60487_i0 | PRJNA340009 | 60794 | 168 | 1.714286 | 2.88000048 | Halobacteriales | 2235 | Archaea | Archaea | 50.8 | 1.94e-5 | NR | WP_121744814.1 | 1702106 | g60487 | i0 | 44.6 | 5 | 56 | 31 | 100 | 0 | 1 | 168 | 107 | 162 | WP_121744814.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Natronorubrum halophilum] | diamond | 840 | 50.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum halophilum | |
| 31402116 | 31402116 | PRJNA340009_P_NODE_50856_length_182_cov_1.533835_g50549_i0 | PRJNA340009 | 50856 | 182 | 1.533835 | 2.7915797 | Methanosarcina sp. DH1 | 2605695 | Archaea | Archaea | 40.8 | 0.0397 | NR | WP_229393533.1 | 2605695 | g50549 | i0 | 57.6 | 0.543956043956044 | 33 | 14 | 54.4 | 0 | 138 | 40 | 13 | 45 | WP_229393533.1 SET domain-containing protein [Methanosarcina sp. DH1] | diamond | 99 | 40.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. DH1 | |
| 32066112 | 32066112 | PRJNA340009_P_NODE_35458_length_211_cov_10.308642_g35151_i0 | PRJNA340009 | 35458 | 211 | 10.308642 | 21.75123462 | Methanothrix sp. | 90426 | Archaea | Archaea | 82.4 | 2.53e-16 | NR | WP_214083743.1 | 90426 | g35151 | i0 | 55.1 | 1.91943127962085 | 69 | 31 | 98.1 | 0 | 3 | 209 | 293 | 361 | WP_214083743.1 SBBP repeat-containing protein [Methanothrix sp.] | diamond | 405 | 82.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 32305268 | 32305268 | PRJNA340009_P_NODE_71659_length_163_cov_0.894737_g71352_i0 | PRJNA340009 | 71659 | 163 | 0.894737 | 1.45842131 | root | 1 | Root_unresolved | Root_unresolved | 97.1 | 9.51e-22 | NR | WP_091934339.1 | 487685 | g71352 | i0 | 81.5 | 2.98159509202454 | 54 | 10 | 99.4 | 0 | 162 | 1 | 30 | 83 | WP_091934339.1 ATP-binding protein [Methanolobus profundi] | diamond | 486 | 97.4 | 0.996919917864476 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus profundi | |
| 32319730 | 32319730 | PRJNA340009_P_NODE_73799_length_162_cov_0.902655_g73492_i0 | PRJNA340009 | 73799 | 162 | 0.902655 | 1.4623011 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 48.9 | 7.54e-5 | NR | HPD11387.1 | 2485498 | g73492 | i0 | 69 | 0.537037037037037 | 29 | 9 | 53.7 | 0 | 89 | 3 | 1 | 29 | HPD11387.1 hypothetical protein [Methanoregulaceae archaeon] | diamond | 87 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 32446167 | 32446167 | PRJNA340009_P_NODE_68279_length_164_cov_1.773913_g67972_i0 | PRJNA340009 | 68279 | 164 | 1.773913 | 2.90921732 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 78.2 | 4.07e-15 | NR | HNU62017.1 | 2666341 | g67972 | i0 | 67.3 | 0.896341463414634 | 49 | 16 | 89.6 | 0 | 13 | 159 | 554 | 602 | HNU62017.1 hypothetical protein [Methanofastidiosum sp.] | diamond | 147 | 78.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum 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);;