contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA812715" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26642690 | 26642690 | PRJNA812715_P_NODE_90961_length_267_cov_1.350515_g89160_i0 | PRJNA812715 | 90961 | 267 | 1.350515 | 3.60587505 | Halorubrum | 56688 | Archaea | Archaea | 174 | 5.69e-51 | NR | WP_053771994.1 | 56688 | g89160 | i0 | 95.5 | 0.98876404494382 | 88 | 4 | 98.9 | 0 | 266 | 3 | 288 | 375 | WP_053771994.1 MULTISPECIES: ABC transporter ATP-binding protein [Halorubrum] | diamond | 264 | 174 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | ||
| 27884325 | 27884325 | PRJNA812715_P_NODE_108125_length_248_cov_0.880000_g106324_i0 | PRJNA812715 | 108125 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 41.2 | 0.0413 | NR | WP_214041426.1 | 90427 | g106324 | i0 | 34.9 | 2.26209677419355 | 63 | 34 | 76.2 | 1 | 18 | 206 | 28 | 83 | WP_214041426.1 ferredoxin-thioredoxin reductase catalytic domain-containing protein [Methanoculleus sp.] | diamond | 561 | 41.6 | 0.990384615384615 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 31034071 | 31034071 | PRJNA812715_P_NODE_116035_length_244_cov_0.900585_g114234_i0 | PRJNA812715 | 116035 | 244 | 0.900585 | 2.1974274 | Halodesulfurarchaeum formicicum | 1873524 | Archaea | Archaea | 147 | 2.62e-41 | NR | WP_070365717.1 | 1873524 | g114234 | i0 | 90 | 0.983606557377049 | 80 | 8 | 98.4 | 0 | 242 | 3 | 18 | 97 | WP_070365717.1 bile acid:sodium symporter family protein [Halodesulfurarchaeum formicicum] | diamond | 240 | 147 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum formicicum | |
| 31643163 | 31643163 | PRJNA812715_P_NODE_61776_length_332_cov_1.783784_g59977_i0 | PRJNA812715 | 61776 | 332 | 1.783784 | 5.92216288 | Candidatus Methanoperedens | 1392997 | Archaea | Archaea | 107 | 2.52e-24 | NR | WP_096204125.1 | 1392998 | g59977 | i0 | 51.3 | 4.9789156626506 | 113 | 45 | 98.5 | 3 | 4 | 330 | 438 | 544 | WP_096204125.1 glycine--tRNA ligase [Candidatus Methanoperedens nitroreducens] | diamond | 1653 | 108 | 0.990740740740741 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens nitratireducens | |
| 32362468 | 32362468 | PRJNA812715_P_NODE_117499_length_243_cov_0.905882_g115698_i0 | PRJNA812715 | 117499 | 243 | 0.905882 | 2.20129326 | Natronosalvus caseinilyticus | 2953747 | Archaea | Archaea | 57.4 | 1.84e-8 | NR | WP_312911353.1 | 2953747 | g115698 | i0 | 82.9 | 0.432098765432099 | 35 | 6 | 43.2 | 0 | 139 | 243 | 1 | 35 | WP_312911353.1 DUF4242 domain-containing protein [Natronosalvus caseinilyticus] | diamond | 105 | 57.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronosalvus | Natronosalvus caseinilyticus | |
| 32457309 | 32457309 | PRJNA812715_P_NODE_56319_length_353_cov_1.114286_g54520_i0 | PRJNA812715 | 56319 | 353 | 1.114286 | 3.93342958 | Methanoculleus horonobensis | 528314 | Archaea | Archaea | 43.5 | 0.0431 | NR | MDD3071884.1 | 528314 | g54520 | i0 | 31.6 | 0.484419263456091 | 57 | 37 | 46.7 | 1 | 79 | 243 | 117 | 173 | MDD3071884.1 flavodoxin family protein [Methanoculleus horonobensis] | diamond | 171 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus horonobensis | |
| 32835431 | 32835431 | PRJNA812715_P_NODE_81320_length_282_cov_1.473684_g79520_i0 | PRJNA812715 | 81320 | 282 | 1.473684 | 4.15578888 | Halococcus saccharolyticus | 62319 | Archaea | Archaea | 62 | 1.07e-9 | NR | WP_006078351.1 | 62319 | g79520 | i0 | 62 | 0.531914893617021 | 50 | 19 | 53.2 | 0 | 1 | 150 | 89 | 138 | WP_006078351.1 universal stress protein [Halococcus saccharolyticus] | diamond | 150 | 62 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus saccharolyticus |
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);;