contig_metadata
14 rows where bioproject = "PRJNA890871" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4692537 | 4692537 | PRJNA890871_P_NODE_28044_length_319_cov_1.719512_g27909_i0 | PRJNA890871 | 28044 | 319 | 1.719512 | 5.48524328 | Halorubrum sp. DM2 | 2527867 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|2474087799|emb|LR594487.1| | 2527867 | g27909 | i0 | 100 | 0.0909090909090909 | 29 | 0 | 9 | 0 | 21 | 49 | 2285676 | 2285648 | Halorubrum sp. DM2 isolate Halorubrum diamantensis DM21 genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. DM2 | |
| 8517435 | 8517435 | PRJNA890871_P_NODE_44987_length_274_cov_1.318408_g44852_i0 | PRJNA890871 | 44987 | 274 | 1.318408 | 3.61243792 | Halobaculum rubrum | 2872158 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2090002430|gb|CP082284.1| | 2872158 | g44852 | i0 | 97.059 | 0.124087591240876 | 34 | 0 | 12 | 1 | 238 | 270 | 2015418 | 2015451 | Halobaculum rubrum strain C46 chromosome, complete genome | blastn | 34 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum rubrum | |
| 9793394 | 9793394 | PRJNA890871_P_NODE_93408_length_210_cov_4.145985_g93273_i0 | PRJNA890871 | 93408 | 210 | 4.145985 | 8.7065685 | Methanosarcina sp. Kolksee | 1434099 | Archaea | Archaea | 54.7 | 0.005 | NTclustered | gi|805394978|gb|CP009524.1| | 1434099 | g93273 | i0 | 100 | 0.138095238095238 | 29 | 0 | 14 | 0 | 19 | 47 | 991096 | 991068 | Methanosarcina sp. Kolksee, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. Kolksee | |
| 28161155 | 28161155 | PRJNA890871_P_NODE_10765_length_472_cov_6.290727_g10630_i0 | PRJNA890871 | 10765 | 472 | 6.290727 | 29.69223144 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 53.9 | 3.61e-5 | NR | NMC58615.1 | 2099674 | g10630 | i0 | 41.8 | 1.04872881355932 | 55 | 32 | 35 | 0 | 471 | 307 | 216 | 270 | NMC58615.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] | diamond | 495 | 53.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 30371916 | 30371916 | PRJNA890871_P_NODE_34412_length_294_cov_3.466063_g34277_i0 | PRJNA890871 | 34412 | 294 | 3.466063 | 10.19022522 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 79.3 | 3.66e-17 | NR | MBO6110342.1 | 66852 | g34277 | i0 | 55.1 | 0.704081632653061 | 69 | 31 | 70.4 | 0 | 272 | 66 | 1 | 69 | MBO6110342.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 207 | 79.3 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30466596 | 30466596 | PRJNA890871_P_NODE_17853_length_382_cov_1.750809_g17718_i0 | PRJNA890871 | 17853 | 382 | 1.750809 | 6.68809038 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 62.4 | 1.75e-8 | NR | MBP3225391.1 | 66852 | g17718 | i0 | 49.2 | 0.479057591623037 | 61 | 30 | 47.1 | 1 | 200 | 379 | 1 | 61 | MBP3225391.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 183 | 62.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30687351 | 30687351 | PRJNA890871_P_NODE_5253_length_656_cov_2.828473_g5118_i0 | PRJNA890871 | 5253 | 656 | 2.828473 | 18.55478288 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 65.5 | 9.31e-10 | NR | MFA5559230.1 | 2666341 | g5118 | i0 | 36 | 0.507621951219512 | 111 | 66 | 48.5 | 2 | 6 | 323 | 9 | 119 | MFA5559230.1 hypothetical protein [Methanofastidiosum sp.] | diamond | 333 | 65.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum sp. | |
| 30813815 | 30813815 | PRJNA890871_P_NODE_94194_length_198_cov_7.144000_g94059_i0 | PRJNA890871 | 94194 | 198 | 7.144 | 14.14512 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 44.7 | 0.00404 | NR | NMC58615.1 | 2099674 | g94059 | i0 | 53.8 | 0.590909090909091 | 39 | 18 | 59.1 | 0 | 15 | 131 | 233 | 271 | NMC58615.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] | diamond | 117 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 30845484 | 30845484 | PRJNA890871_P_NODE_1594_length_1521_cov_4.435083_g1493_i0 | PRJNA890871 | 1594 | 1521 | 4.435083 | 67.45761243 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 110 | 1.53e-25 | NR | MBO6110343.1 | 66852 | g1493 | i0 | 71 | 0.258382642998028 | 69 | 20 | 13.6 | 0 | 993 | 787 | 1 | 69 | MBO6110343.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 393 | 110 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31161003 | 31161003 | PRJNA890871_P_NODE_1755_length_1393_cov_3.536364_g1649_i0 | PRJNA890871 | 1755 | 1393 | 3.536364 | 49.26155052 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 110 | 3.909999999999999e-23 | NR | NMC58615.1 | 2099674 | g1649 | i0 | 35.2 | 0.525484565685571 | 244 | 142 | 50.6 | 10 | 71 | 775 | 35 | 271 | NMC58615.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] | diamond | 732 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 32078659 | 32078659 | PRJNA890871_P_NODE_9778_length_492_cov_2.634845_g9643_i0 | PRJNA890871 | 9778 | 492 | 2.634845 | 12.9634374 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 65.1 | 1.69e-10 | NR | MBO6109614.1 | 66852 | g9643 | i0 | 38.8 | 0.48780487804878 | 80 | 47 | 48.8 | 1 | 322 | 83 | 5 | 82 | MBO6109614.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 240 | 65.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32426770 | 32426770 | PRJNA890871_P_NODE_37859_length_286_cov_1.863850_g37724_i0 | PRJNA890871 | 37859 | 286 | 1.86385 | 5.330611 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 132 | 5.56e-38 | NR | MCH7659049.1 | 2026739 | g37724 | i0 | 100 | 0.723776223776224 | 69 | 0 | 72.4 | 0 | 3 | 209 | 36 | 104 | MCH7659049.1 AzlD domain-containing protein [Methanobacteriota archaeon] | diamond | 207 | 132 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32585025 | 32585025 | PRJNA890871_P_NODE_22159_length_350_cov_2.014440_g22024_i0 | PRJNA890871 | 22159 | 350 | 2.01444 | 7.05054 | Haloarculaceae archaeon | 2497615 | Archaea | Archaea | 43.9 | 0.0419 | NR | MFB6172384.1 | 2497615 | g22024 | i0 | 35.6 | 0.865714285714286 | 101 | 64 | 86.6 | 1 | 1 | 303 | 15 | 114 | MFB6172384.1 SDR family oxidoreductase [Haloarculaceae archaeon] | diamond | 303 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarculaceae archaeon | ||
| 32616338 | 32616338 | PRJNA890871_P_NODE_3940_length_762_cov_6.965167_g3809_i0 | PRJNA890871 | 3940 | 762 | 6.965167 | 53.07457254 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 240 | 2.3e-76 | NR | MBO6110344.1 | 66852 | g3809 | i0 | 71.7 | 0.653543307086614 | 166 | 47 | 65.4 | 0 | 263 | 760 | 3 | 168 | MBO6110344.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 498 | 240 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter 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);;