contig_metadata
11 rows where bioproject = "PRJNA1120203" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 275266 | 275266 | PRJNA1120203_P_NODE_69981_length_268_cov_1.492308_g68965_i0 | PRJNA1120203 | 69981 | 268 | 1.492308 | 3.99938544 | Haloferax volcanii | 2246 | Archaea | Archaea | 490 | 4.39e-134 | NTclustered | gi|291370026|gb|CP001956.1| | 309800 | g68965 | i0 | 99.627 | 5.23880597014925 | 268 | 1 | 100 | 0 | 1 | 268 | 719642 | 719909 | Haloferax volcanii DS2, complete sequence | blastn | 1404 | 490 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 16330575 | 16330575 | PRJNA1120203_P_NODE_78913_length_251_cov_0.865169_g77897_i0 | PRJNA1120203 | 78913 | 251 | 0.865169 | 2.17157419 | Haloarcula | 2237 | Archaea | Archaea | 202 | 2.13e-47 | NTclustered | gi|2461916621|gb|CP119559.1| | 3032584 | g77897 | i0 | 81.6 | 3.80876494023904 | 250 | 40 | 98 | 6 | 1 | 247 | 2699501 | 2699747 | Haloarcula halophila strain DFY41 chromosome, complete genome | blastn | 956 | 202 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula halophila | |
| 16852727 | 16852727 | PRJNA1120203_P_NODE_84594_length_249_cov_0.875000_g83578_i0 | PRJNA1120203 | 84594 | 249 | 0.875 | 2.17875 | Methanosarcina horonobensis | 418008 | Archaea | Archaea | 285 | 2.0399999999999997e-72 | NTclustered | gi|805380606|gb|CP009516.1| | 1434110 | g83578 | i0 | 92.079 | 0.811244979919679 | 202 | 16 | 81 | 0 | 1 | 202 | 3978663 | 3978462 | Methanosarcina horonobensis HB-1, complete genome | blastn | 202 | 285 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina horonobensis | |
| 28112246 | 28112246 | PRJNA1120203_P_NODE_72165_length_263_cov_1.747368_g71149_i0 | PRJNA1120203 | 72165 | 263 | 1.747368 | 4.59557784 | Halorubrum vacuolatum | 63740 | Archaea | Archaea | 77.4 | 2.93e-14 | NR | WP_089384072.1 | 63740 | g71149 | i0 | 60.3 | 0.832699619771863 | 73 | 22 | 81 | 2 | 262 | 50 | 466 | 533 | WP_089384072.1 histidine ammonia-lyase [Halorubrum vacuolatum] | diamond | 219 | 77.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum vacuolatum | |
| 28238410 | 28238410 | PRJNA1120203_P_NODE_101606_length_242_cov_0.911243_g100590_i0 | PRJNA1120203 | 101606 | 242 | 0.911243 | 2.20520806 | Methanothrix sp. | 90426 | Archaea | Archaea | 94.4 | 1.2800000000000001e-22 | NR | MCK9565542.1 | 90426 | g100590 | i0 | 67.8 | 6.01239669421488 | 59 | 16 | 73.1 | 1 | 59 | 235 | 1 | 56 | MCK9565542.1 hypothetical protein [Methanothrix sp.] | diamond | 1455 | 94.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28901530 | 28901530 | PRJNA1120203_P_NODE_87728_length_248_cov_0.880000_g86712_i0 | PRJNA1120203 | 87728 | 248 | 0.88 | 2.1824 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 115 | 1.01e-29 | NR | HWR97620.1 | 2032688 | g86712 | i0 | 77 | 0.895161290322581 | 74 | 17 | 89.5 | 0 | 228 | 7 | 19 | 92 | HWR97620.1 hypothetical protein [Candidatus Methanoperedens sp.] | diamond | 222 | 115 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 29469714 | 29469714 | PRJNA1120203_P_NODE_87930_length_248_cov_0.880000_g86914_i0 | PRJNA1120203 | 87930 | 248 | 0.88 | 2.1824 | Halobacteriales archaeon | 1904752 | Archaea | Archaea | 135 | 2.3e-37 | NR | MDX1746556.1 | 1904752 | g86914 | i0 | 80.5 | 1.97177419354839 | 82 | 16 | 99.2 | 0 | 2 | 247 | 83 | 164 | MDX1746556.1 hypothetical protein [Halobacteriales archaeon] | diamond | 489 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon | |||
| 30796700 | 30796700 | PRJNA1120203_P_NODE_74614_length_258_cov_1.437838_g73598_i0 | PRJNA1120203 | 74614 | 258 | 1.437838 | 3.70962204 | Halorubrum tibetense | 175631 | Archaea | Archaea | 160 | 1.4099999999999998e-45 | NR | WP_379781343.1 | 175631 | g73598 | i0 | 90.7 | 3 | 86 | 8 | 100 | 0 | 1 | 258 | 253 | 338 | WP_379781343.1 MBL fold metallo-hydrolase [Halorubrum tibetense] | diamond | 774 | 160 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum tibetense | |
| 30859964 | 30859964 | PRJNA1120203_P_NODE_95254_length_245_cov_0.895349_g94238_i0 | PRJNA1120203 | 95254 | 245 | 0.895349 | 2.19360505 | Methanosarcina sp. | 2213 | Archaea | Archaea | 70.1 | 1.62e-13 | NR | HET8688237.1 | 2213 | g94238 | i0 | 62.5 | 0.783673469387755 | 64 | 24 | 78.4 | 0 | 1 | 192 | 31 | 94 | HET8688237.1 HNH endonuclease signature motif containing protein [Methanosarcina sp.] | diamond | 192 | 70.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30923383 | 30923383 | PRJNA1120203_P_NODE_86974_length_248_cov_0.880000_g85958_i0 | PRJNA1120203 | 86974 | 248 | 0.88 | 2.1824 | Methanofollis | 81416 | Archaea | Archaea | 77 | 9.84e-17 | NR | WP_160329460.1 | 81416 | g85958 | i0 | 94.3 | 0.423387096774194 | 35 | 2 | 42.3 | 0 | 106 | 2 | 1 | 35 | WP_160329460.1 MULTISPECIES: hydrogenase maturation nickel metallochaperone HypA [Methanofollis] | diamond | 105 | 77 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanofollis | ||
| 31966503 | 31966503 | PRJNA1120203_P_NODE_102598_length_242_cov_0.911243_g101582_i0 | PRJNA1120203 | 102598 | 242 | 0.911243 | 2.20520806 | Halobacteriales archaeon QH_1_68_42 | 1919146 | Archaea | Archaea | 43.1 | 0.0165 | NR | PSP49880.1 | 1919146 | g101582 | i0 | 35.7 | 0.867768595041322 | 70 | 45 | 86.8 | 0 | 32 | 241 | 84 | 153 | PSP49880.1 MAG: hypothetical protein BRC60_05900 [Halobacteriales archaeon QH_1_68_42] | diamond | 210 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon QH_1_68_42 |
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);;