contig_metadata
17 rows where bioproject = "PRJEB10140" and tax_clade = "Stenosarchaea 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8940359 | 8940359 | PRJEB10140_P_NODE_82928_length_441_cov_7.612245_g65667_i0 | PRJEB10140 | 82928 | 441 | 7.612245 | 33.57000045 | Candidatus Methanoperedenaceae archaeon GB37 | 2691037 | Archaea | Archaea | 56.5 | 0.003 | NTclustered | gi|1964039634|emb|LR991653.1| | 2691037 | g65667 | i0 | 96.97 | 0.0748299319727891 | 33 | 1 | 7 | 0 | 75 | 107 | 1721911 | 1721879 | Candidatus Methanoperedenaceae archaeon GB37 isolate gfbio:2ba61e4a-a911-483b-ba5e-e0ad8afd3b38:GoM-Arc1_E37 genome assembly, chromosome: 1 | blastn | 33 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedenaceae archaeon GB37 | ||
| 19137319 | 19137319 | PRJEB10140_P_NODE_174276_length_218_cov_1.739645_g156967_i0 | PRJEB10140 | 174276 | 218 | 1.739645 | 3.7924261 | Methanocorpusculum labreanum | 83984 | Archaea | Archaea | 52.8 | 0.019 | NTclustered | gi|124362370|gb|CP000559.1| | 410358 | g156967 | i0 | 100 | 0.128440366972477 | 28 | 0 | 13 | 0 | 159 | 186 | 1026969 | 1026942 | Methanocorpusculum labreanum Z, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum labreanum | |
| 27032575 | 27032575 | PRJEB10140_P_NODE_47062_length_770_cov_14.413315_g31678_i0 | PRJEB10140 | 47062 | 770 | 14.413315 | 110.9825255 | Natrinema hispanicum | 392421 | Archaea | Archaea | 57.4 | 1.01e-5 | NR | WP_130501464.1 | 392421 | g31678 | i0 | 51.9 | 0.814285714285714 | 54 | 23 | 21 | 1 | 770 | 609 | 156 | 206 | WP_130501464.1 glucose 1-dehydrogenase [Natrinema hispanicum] | diamond | 627 | 57.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema hispanicum | |
| 28106381 | 28106381 | PRJEB10140_P_NODE_230845_length_176_cov_2.094488_g213536_i0 | PRJEB10140 | 230845 | 176 | 2.094488 | 3.68629888 | Candidatus Syntrophoarchaeum butanivorans | 1839936 | Archaea | Archaea | 50.4 | 2.45e-5 | NR | OFV65781.1 | 1839936 | g213536 | i0 | 37.3 | 1.00568181818182 | 59 | 34 | 95.5 | 1 | 4 | 171 | 81 | 139 | OFV65781.1 MAG: archaeal kinase [Candidatus Syntrophoarchaeum butanivorans] | diamond | 177 | 50.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Syntropharchaeum | Candidatus Syntropharchaeum butanivorans | ||
| 28264247 | 28264247 | PRJEB10140_P_NODE_276926_length_164_cov_0.904348_g259617_i0 | PRJEB10140 | 276926 | 164 | 0.904348 | 1.48313072 | Methanosarcina sp. KYL-1 | 2602068 | Archaea | Archaea | 42 | 0.0244 | NR | WP_255335200.1 | 2602068 | g259617 | i0 | 48.6 | 0.676829268292683 | 37 | 19 | 67.7 | 0 | 138 | 28 | 477 | 513 | WP_255335200.1 AAA domain-containing protein [Methanosarcina sp. KYL-1] | diamond | 111 | 42 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. KYL-1 | |
| 28422427 | 28422427 | PRJEB10140_P_NODE_190946_length_202_cov_2.640523_g173637_i0 | PRJEB10140 | 190946 | 202 | 2.640523 | 5.33385646 | Natrinema salaciae | 1186196 | Archaea | Archaea | 65.1 | 2.81e-10 | NR | WP_139210861.1 | 1186196 | g173637 | i0 | 64.1 | 0.579207920792079 | 39 | 14 | 57.9 | 0 | 151 | 35 | 388 | 426 | WP_139210861.1 carbohydrate-binding protein [Natrinema salaciae] | diamond | 117 | 65.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema salaciae | |
| 28643375 | 28643375 | PRJEB10140_P_NODE_139707_length_264_cov_0.823256_g122400_i0 | PRJEB10140 | 139707 | 264 | 0.823256 | 2.17339584 | Methanosarcina sp. | 2213 | Archaea | Archaea | 59.3 | 3.71e-9 | NR | HET8688242.1 | 2213 | g122400 | i0 | 56.3 | 1.125 | 48 | 21 | 54.5 | 0 | 121 | 264 | 9 | 56 | HET8688242.1 hypothetical protein [Methanosarcina sp.] | diamond | 297 | 59.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29022475 | 29022475 | PRJEB10140_P_NODE_114528_length_319_cov_1.348148_g97222_i0 | PRJEB10140 | 114528 | 319 | 1.348148 | 4.30059212 | Haloarcula terrestris | 2950533 | Archaea | Archaea | 86.7 | 3.44e-17 | NR | WP_310897214.1 | 2950533 | g97222 | i0 | 37.3 | 2.07836990595611 | 110 | 62 | 96.9 | 1 | 1 | 309 | 39 | 148 | WP_310897214.1 alpha-glucosidase [Haloarcula terrestris] | diamond | 663 | 86.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula terrestris | |
| 29306245 | 29306245 | PRJEB10140_P_NODE_258489_length_167_cov_0.881356_g241180_i0 | PRJEB10140 | 258489 | 167 | 0.881356 | 1.47186452 | Halococcus sediminicola | 1264579 | Archaea | Archaea | 45.1 | 0.00203 | NR | WP_049998952.1 | 1264579 | g241180 | i0 | 53.7 | 0.736526946107784 | 41 | 19 | 73.7 | 0 | 167 | 45 | 343 | 383 | WP_049998952.1 PGF-CTERM sorting domain-containing protein [Halococcus sediminicola] | diamond | 123 | 45.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sediminicola | |
| 29678844 | 29678844 | PRJEB10140_P_NODE_157610_length_237_cov_1.377660_g140302_i0 | PRJEB10140 | 157610 | 237 | 1.37766 | 3.2650542 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 5.06e-4 | NR | SFP53613.1 | 699431 | g140302 | i0 | 46.2 | 1.27848101265823 | 39 | 21 | 49.4 | 0 | 191 | 75 | 108 | 146 | SFP53613.1 hypothetical protein SAMN05216277_104244 [Halolamina pelagica] | diamond | 303 | 47.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina pelagica | |
| 29748015 | 29748015 | PRJEB10140_P_NODE_121291_length_302_cov_1.027668_g103984_i0 | PRJEB10140 | 121291 | 302 | 1.027668 | 3.10355736 | Methanothrix sp. | 90426 | Archaea | Archaea | 77 | 6.89e-14 | NR | HOL44086.1 | 90426 | g103984 | i0 | 55.9 | 0.586092715231788 | 59 | 26 | 58.6 | 0 | 126 | 302 | 793 | 851 | HOL44086.1 anaerobic ribonucleoside-triphosphate reductase [Methanothrix sp.] | diamond | 177 | 77 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 30601211 | 30601211 | PRJEB10140_P_NODE_210873_length_188_cov_1.453237_g193564_i0 | PRJEB10140 | 210873 | 188 | 1.453237 | 2.73208556 | Halorubrum | 56688 | Archaea | Archaea | 77.8 | 5.19e-17 | NR | WP_241686147.1 | 56688 | g193564 | i0 | 80.9 | 1.5 | 47 | 9 | 75 | 0 | 1 | 141 | 38 | 84 | WP_241686147.1 MULTISPECIES: hypothetical protein [Halorubrum] | diamond | 282 | 77.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | ||
| 30753346 | 30753346 | PRJEB10140_P_NODE_57674_length_636_cov_3.025554_g41134_i0 | PRJEB10140 | 57674 | 636 | 3.025554 | 19.24252344 | Methanothrix | 2222 | Archaea | Archaea | 119 | 5.28e-27 | NR | MCX6674432.1 | 90426 | g41134 | i0 | 42.8 | 1.76415094339623 | 187 | 91 | 82.1 | 6 | 534 | 13 | 334 | 517 | MCX6674432.1 S8 family serine peptidase [Methanothrix sp.] | diamond | 1122 | 119 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 31264876 | 31264876 | PRJEB10140_P_NODE_15275_length_1783_cov_5.453287_g8627_i1 | PRJEB10140 | 15275 | 1783 | 5.453287 | 97.23210721 | Methanocalculus sp. MSAO_Arc2 | 2293855 | Archaea | Archaea | 49.3 | 0.0245 | NR | WP_346865908.1 | 2293855 | g8627 | i1 | 33.3 | 0.151430173864274 | 90 | 59 | 15 | 1 | 799 | 1065 | 81 | 170 | WP_346865908.1 SMP-30/gluconolactonase/LRE family protein, partial [Methanocalculus sp. MSAO_Arc2] | diamond | 270 | 49.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocalculaceae | Methanocalculus | Methanocalculus sp. MSAO_Arc2 | |
| 31834023 | 31834023 | PRJEB10140_P_NODE_167657_length_225_cov_1.704545_g150348_i0 | PRJEB10140 | 167657 | 225 | 1.704545 | 3.83522625 | Halosimplex aquaticum | 3026162 | Archaea | Archaea | 46.2 | 0.00145 | NR | WP_274324730.1 | 3026162 | g150348 | i0 | 27.1 | 0.933333333333333 | 70 | 51 | 93.3 | 0 | 1 | 210 | 136 | 205 | WP_274324730.1 hypothetical protein [Halosimplex aquaticum] | diamond | 210 | 46.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex aquaticum | |
| 31960706 | 31960706 | PRJEB10140_P_NODE_15238_length_1785_cov_6.627880_g8627_i0 | PRJEB10140 | 15238 | 1785 | 6.62788 | 118.307658 | Methanocalculus sp. MSAO_Arc2 | 2293855 | Archaea | Archaea | 49.3 | 0.0246 | NR | WP_346865908.1 | 2293855 | g8627 | i0 | 33.3 | 0.151260504201681 | 90 | 59 | 15 | 1 | 987 | 721 | 81 | 170 | WP_346865908.1 SMP-30/gluconolactonase/LRE family protein, partial [Methanocalculus sp. MSAO_Arc2] | diamond | 270 | 49.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocalculaceae | Methanocalculus | Methanocalculus sp. MSAO_Arc2 | |
| 32207989 | 32207989 | PRJEB10140_P_NODE_265738_length_166_cov_0.880342_g248429_i0 | PRJEB10140 | 265738 | 166 | 0.880342 | 1.46136772 | root | 1 | Root_unresolved | Root_unresolved | 68.2 | 1.43e-11 | NR | HET8688830.1 | 2213 | g248429 | i0 | 57.7 | 1.95180722891566 | 52 | 22 | 94 | 0 | 11 | 166 | 1562 | 1613 | HET8688830.1 DUF4815 domain-containing protein [Methanosarcina sp.] | diamond | 324 | 68.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina 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);;