contig_metadata
11 rows where bioproject = "PRJNA520845", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13244122 | 13244122 | PRJNA520845_P_NODE_213311_length_251_cov_1.297753_g211812_i0 | PRJNA520845 | 213311 | 251 | 1.297753 | 3.25736003 | Salinarchaeum sp. Harcht-Bsk1 | 1333523 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|507914357|gb|CP005962.1| | 1333523 | g211812 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 174 | 201 | 3134060 | 3134087 | Salinarchaeum sp. Harcht-Bsk1, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Salinarchaeum | Salinarchaeum sp. Harcht-Bsk1 | |
| 18962804 | 18962804 | PRJNA520845_P_NODE_124715_length_334_cov_1.597701_g123216_i0 | PRJNA520845 | 124715 | 334 | 1.597701 | 5.33632134 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 200 | 1.73e-60 | NR | RYE83110.1 | 2250255 | g123216 | i0 | 94.1 | 0.907185628742515 | 101 | 6 | 90.7 | 0 | 333 | 31 | 316 | 416 | RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon] | diamond | 303 | 200 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 26919136 | 26919136 | PRJNA520845_P_NODE_36302_length_629_cov_1.953237_g34842_i0 | PRJNA520845 | 36302 | 629 | 1.953237 | 12.28586073 | Haloplanus rubicundus | 1547898 | Archaea | Archaea | 49.7 | 0.00434 | NR | WP_114584666.1 | 1547898 | g34842 | i0 | 29.3 | 0.58664546899841 | 123 | 72 | 52.5 | 3 | 266 | 595 | 722 | 842 | WP_114584666.1 GAF domain-containing protein [Haloplanus rubicundus] | diamond | 369 | 49.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus rubicundus | |
| 27866853 | 27866853 | PRJNA520845_P_NODE_261805_length_242_cov_0.911243_g260306_i0 | PRJNA520845 | 261805 | 242 | 0.911243 | 2.20520806 | Methanocalculus chunghsingensis | 156457 | Archaea | Archaea | 125 | 2.18e-31 | NR | WP_211529921.1 | 156457 | g260306 | i0 | 70.3 | 2.76446280991736 | 74 | 22 | 91.7 | 0 | 17 | 238 | 388 | 461 | WP_211529921.1 beta-propeller domain-containing protein [Methanocalculus chunghsingensis] | diamond | 669 | 125 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocalculaceae | Methanocalculus | Methanocalculus chunghsingensis | |
| 27993363 | 27993363 | PRJNA520845_P_NODE_219345_length_250_cov_0.870056_g217846_i0 | PRJNA520845 | 219345 | 250 | 0.870056 | 2.17514 | Haloferax sp. DFSO6 | 2253 | Archaea | Archaea | 48.5 | 1.25e-4 | NR | WP_410764951.1 | 3388652 | g217846 | i0 | 37.1 | 0.744 | 62 | 35 | 69.6 | 1 | 176 | 3 | 19 | 80 | WP_410764951.1 ester cyclase [Haloferax sp. DFSO60] | diamond | 186 | 48.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. DFSO60 | |
| 28260979 | 28260979 | PRJNA520845_P_NODE_141206_length_314_cov_1.917012_g139707_i0 | PRJNA520845 | 141206 | 314 | 1.917012 | 6.01941768 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 1.69e-4 | NR | WP_247378268.1 | 1126241 | g139707 | i0 | 33.3 | 2.8375796178344 | 90 | 59 | 85 | 1 | 273 | 7 | 6 | 95 | WP_247378268.1 universal stress protein [Halorientalis brevis] | diamond | 891 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis brevis | |
| 28656380 | 28656380 | PRJNA520845_P_NODE_163647_length_291_cov_1.059633_g162148_i0 | PRJNA520845 | 163647 | 291 | 1.059633 | 3.08353203 | Methanosarcina baikalica | 3073890 | Archaea | Archaea | 47.8 | 0.00112 | NR | WP_310577212.1 | 3073890 | g162148 | i0 | 34.7 | 0.77319587628866 | 75 | 48 | 76.3 | 1 | 276 | 55 | 134 | 208 | WP_310577212.1 choice-of-anchor A family protein, partial [Methanosarcina baikalica] | diamond | 225 | 47.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina baikalica | |
| 30298891 | 30298891 | PRJNA520845_P_NODE_201512_length_260_cov_1.647059_g200013_i0 | PRJNA520845 | 201512 | 260 | 1.647059 | 4.2823534 | Halobellus rubicundus | 2996466 | Archaea | Archaea | 60.5 | 2.72e-8 | NR | WP_372391497.1 | 2996466 | g200013 | i0 | 47.4 | 0.9 | 78 | 39 | 87.7 | 2 | 2 | 229 | 483 | 560 | WP_372391497.1 beta strand repeat-containing protein [Halobellus rubicundus] | diamond | 234 | 60.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus rubicundus | |
| 30677465 | 30677465 | PRJNA520845_P_NODE_269093_length_233_cov_2.512500_g267594_i0 | PRJNA520845 | 269093 | 233 | 2.5125 | 5.854125 | Haloarcula marina | 2961574 | Archaea | Archaea | 43.1 | 0.00565 | NR | WP_254273060.1 | 2961574 | g267594 | i0 | 43.5 | 0.592274678111588 | 46 | 24 | 56.7 | 1 | 85 | 216 | 31 | 76 | WP_254273060.1 hypothetical protein [Haloarcula marina] | diamond | 138 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula marina | |
| 31373071 | 31373071 | PRJNA520845_P_NODE_224736_length_249_cov_0.875000_g223237_i0 | PRJNA520845 | 224736 | 249 | 0.875 | 2.17875 | Methanolacinia paynteri | 230356 | Archaea | Archaea | 50.4 | 7.41e-5 | NR | WP_048149656.1 | 230356 | g223237 | i0 | 34.6 | 1.81927710843373 | 81 | 49 | 94 | 2 | 5 | 238 | 145 | 224 | WP_048149656.1 cryptochrome/photolyase family protein [Methanolacinia paynteri] | diamond | 453 | 50.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanolacinia | Methanolacinia paynteri | |
| 32763881 | 32763881 | PRJNA520845_P_NODE_234840_length_247_cov_0.885057_g233341_i0 | PRJNA520845 | 234840 | 247 | 0.885057 | 2.18609079 | Haloterrigena alkaliphila | 2816475 | Archaea | Archaea | 47.8 | 6.25e-4 | NR | WP_207287531.1 | 2816475 | g233341 | i0 | 48 | 1.21457489878543 | 50 | 25 | 60.7 | 1 | 152 | 3 | 45 | 93 | WP_207287531.1 DUF4397 domain-containing protein [Haloterrigena alkaliphila] | diamond | 300 | 47.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena alkaliphila |
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);;