contig_metadata
6 rows where bioproject = "PRJNA1150539" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15064530 | 15064530 | PRJNA1150539_S_NODE_73192_length_275_cov_1.866337_g72596_i0 | PRJNA1150539 | 73192 | 275 | 1.866337 | 5.13242675 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.025 | NTclustered | gi|302836320|ref|XM_002949675.1| | 3068 | g72596 | i0 | 100 | 0.203636363636364 | 28 | 0 | 10 | 0 | 33 | 60 | 484 | 457 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_104367), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 24527505 | 24527505 | PRJNA1150539_S_NODE_66760_length_284_cov_2.407583_g66164_i0 | PRJNA1150539 | 66760 | 284 | 2.407583 | 6.83753572 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 520 | 5.98e-143 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g66164 | i0 | 99.648 | 100.580985915493 | 284 | 1 | 100 | 0 | 1 | 284 | 6208 | 6491 | Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 28565 | 520 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 26913602 | 26913602 | PRJNA1150539_S_NODE_12762_length_417_cov_2.177326_g12167_i0 | PRJNA1150539 | 12762 | 417 | 2.177326 | 9.07944942 | Chlorella ohadii | 2649997 | Plants | Plants | 45.1 | 0.0368 | NR | KAI7835581.1 | 2649997 | g12167 | i0 | 37.1 | 0.640287769784173 | 89 | 41 | 55.4 | 2 | 329 | 99 | 877 | 962 | KAI7835581.1 hypothetical protein COHA_010526 [Chlorella ohadii] | diamond | 267 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella ohadii | |
| 27040315 | 27040315 | PRJNA1150539_S_NODE_101002_length_242_cov_7.520710_g100406_i0 | PRJNA1150539 | 101002 | 242 | 7.52071 | 18.2001182 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 45.1 | 0.00564 | NR | RMZ53420.1 | 3075 | g100406 | i0 | 45.3 | 0.65702479338843 | 53 | 27 | 65.7 | 1 | 205 | 47 | 171 | 221 | RMZ53420.1 hypothetical protein APUTEX25_004908, partial [Auxenochlorella protothecoides] | diamond | 159 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 32443376 | 32443376 | PRJNA1150539_S_NODE_60339_length_294_cov_1.742081_g59743_i0 | PRJNA1150539 | 60339 | 294 | 1.742081 | 5.12171814 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 43.1 | 0.0489 | NR | GFR43980.1 | 47775 | g59743 | i0 | 31.9 | 0.959183673469388 | 94 | 54 | 91.8 | 3 | 277 | 8 | 81 | 168 | GFR43980.1 hypothetical protein Agub_g5124, partial [Astrephomene gubernaculifera] | diamond | 282 | 43.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 32789828 | 32789828 | PRJNA1150539_S_NODE_88500_length_255_cov_2.532967_g87904_i0 | PRJNA1150539 | 88500 | 255 | 2.532967 | 6.45906585 | Ostreobium quekettii | 121088 | Plants | Plants | 42.7 | 0.0325 | NR | CAD7696493.1 | 121088 | g87904 | i0 | 44.4 | 0.423529411764706 | 36 | 16 | 37.6 | 1 | 227 | 132 | 36 | 71 | CAD7696493.1 unnamed protein product [Ostreobium quekettii] | diamond | 108 | 42.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii |
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);;