contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA797655" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27275231 | 27275231 | PRJNA797655_S_NODE_95383_length_250_cov_4.082126_g94778_i0 | PRJNA797655 | 95383 | 250 | 4.082126 | 10.205315 | Chlorella ohadii | 2649997 | Plants | Plants | 42 | 0.0363 | NR | KAI7836672.1 | 2649997 | g94778 | i0 | 46.5 | 0.516 | 43 | 22 | 51.6 | 1 | 40 | 168 | 47 | 88 | KAI7836672.1 hypothetical protein COHA_009448 [Chlorella ohadii] | diamond | 129 | 42 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella ohadii | |
| 30875387 | 30875387 | PRJNA797655_S_NODE_209874_length_174_cov_1.984733_g209269_i0 | PRJNA797655 | 209874 | 174 | 1.984733 | 3.45343542 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 42 | 0.0284 | NR | KAL4457459.1 | 2728915 | g209269 | i0 | 43.1 | 0.879310344827586 | 51 | 27 | 84.5 | 1 | 150 | 4 | 333 | 383 | KAL4457459.1 hypothetical protein ABPG75_012324 [Micractinium tetrahymenae] | diamond | 153 | 42 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 31665679 | 31665679 | PRJNA797655_S_NODE_263717_length_153_cov_1.745455_g263112_i0 | PRJNA797655 | 263717 | 153 | 1.745455 | 2.67054615 | Gonium pectorale | 33097 | Plants | Plants | 41.2 | 0.0371 | NR | KXZ49562.1 | 33097 | g263112 | i0 | 59.4 | 0.627450980392157 | 32 | 13 | 62.7 | 0 | 100 | 5 | 130 | 161 | KXZ49562.1 hypothetical protein GPECTOR_20g417 [Gonium pectorale] | diamond | 96 | 41.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale |
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);;