contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28823219 | 28823219 | PRJNA853194_S_NODE_26388_length_401_cov_2.789634_g25297_i0 | PRJNA853194 | 26388 | 401 | 2.789634 | 11.18643234 | Micractinium conductrix | 554055 | Plants | Plants | 52 | 1.29e-4 | NR | PSC73309.1 | 554055 | g25297 | i0 | 31.1 | 0.553615960099751 | 74 | 49 | 53.9 | 1 | 381 | 166 | 1198 | 1271 | PSC73309.1 cysteine ase isoform A [Micractinium conductrix] | diamond | 222 | 52 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 29265329 | 29265329 | PRJNA853194_S_NODE_19649_length_450_cov_14.331565_g18559_i0 | PRJNA853194 | 19649 | 450 | 14.331565 | 64.4920425 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 107 | 1.35e-24 | NR | BDA43847.1 | 2315456 | g18559 | i0 | 44.6 | 1.49333333333333 | 112 | 61 | 74.7 | 1 | 449 | 114 | 200 | 310 | BDA43847.1 GPN-loop GTPase 1 [Coccomyxa sp. Obi] | diamond | 672 | 107 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 29715487 | 29715487 | PRJNA853194_S_NODE_58610_length_286_cov_1.051643_g57519_i0 | PRJNA853194 | 58610 | 286 | 1.051643 | 3.00769898 | Eukaryota | 2759 | Plants | Plants | 108 | 6.3e-25 | NR | XP_002955626.1 | 3068 | g57519 | i0 | 57.1 | 6.17832167832168 | 84 | 36 | 88.1 | 0 | 253 | 2 | 333 | 416 | XP_002955626.1 uncharacterized protein VOLCADRAFT_66026, partial [Volvox carteri f. nagariensis] | diamond | 1767 | 108 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 29905421 | 29905421 | PRJNA853194_S_NODE_591_length_1698_cov_20.197538_g411_i0 | PRJNA853194 | 591 | 1698 | 20.197538 | 342.95419524 | Chlorophyceae | 3166 | Plants | Plants | 144 | 4.29e-33 | NR | MEW5300207.1 | 2578422 | g411 | i0 | 30.7 | 4.37985865724382 | 319 | 210 | 55.7 | 8 | 1642 | 698 | 13 | 324 | MEW5300207.1 hypothetical protein [Sanguina aurantia] | diamond | 7437 | 145 | 0.993103448275862 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Sanguina | Sanguina aurantia | |
| 29991880 | 29991880 | PRJNA853194_S_NODE_52191_length_301_cov_2.333333_g51100_i0 | PRJNA853194 | 52191 | 301 | 2.333333 | 7.02333233 | Ostreobium quekettii | 121088 | Plants | Plants | 43.5 | 0.0391 | NR | CAD7701693.1 | 121088 | g51100 | i0 | 33 | 0.877076411960133 | 88 | 53 | 82.7 | 3 | 285 | 37 | 97 | 183 | CAD7701693.1 unnamed protein product [Ostreobium quekettii] | diamond | 264 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 30813244 | 30813244 | PRJNA853194_S_NODE_13334_length_527_cov_37.621145_g12258_i0 | PRJNA853194 | 13334 | 527 | 37.621145 | 198.26343415 | Pleodorina starrii | 330485 | Plants | Plants | 82.8 | 6.35e-16 | NR | GLC37514.1 | 330485 | g12258 | i0 | 35 | 0.77988614800759 | 137 | 87 | 76.9 | 1 | 38 | 442 | 76 | 212 | GLC37514.1 hypothetical protein PLESTM_000597400 [Pleodorina starrii] | diamond | 411 | 82.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 30939837 | 30939837 | PRJNA853194_S_NODE_11154_length_569_cov_4.754032_g10099_i0 | PRJNA853194 | 11154 | 569 | 4.754032 | 27.05044208 | Ostreobium quekettii | 121088 | Plants | Plants | 60.1 | 8.51e-7 | NR | CAD7705180.1 | 121088 | g10099 | i0 | 31.3 | 0.506151142355009 | 96 | 65 | 50.6 | 1 | 508 | 221 | 219 | 313 | CAD7705180.1 unnamed protein product [Ostreobium quekettii] | diamond | 288 | 60.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 32434713 | 32434713 | PRJNA853194_S_NODE_74939_length_253_cov_3.777778_g73848_i0 | PRJNA853194 | 74939 | 253 | 3.777778 | 9.55777834 | Chlamydomonadales | 3042 | Plants | Plants | 49.7 | 1.47e-4 | NR | GLC43887.1 | 330485 | g73848 | i0 | 50 | 1.93280632411067 | 44 | 22 | 52.2 | 0 | 227 | 96 | 65 | 108 | GLC43887.1 hypothetical protein PLESTM_001530200 [Pleodorina starrii] | diamond | 489 | 49.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii |
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);;