contig_metadata
12 rows where bioproject = "PRJNA641991" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168594 | 3168594 | PRJNA641991_P_NODE_2343_length_199_cov_1.053333_g2302_i0 | PRJNA641991 | 2343 | 199 | 1.053333 | 2.09613267 | Bathycoccus prasinos | 41875 | Plants | Plants | 56.5 | 0.001 | NTclustered | gi|612398356|ref|XM_007514636.1| | 41875 | g2302 | i0 | 100 | 0.150753768844221 | 30 | 0 | 15 | 0 | 24 | 53 | 320 | 349 | Bathycoccus prasinos prolyl-tRNA synthetase (Bathy02g02510), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 3168619 | 3168619 | PRJNA641991_S_NODE_14243_length_162_cov_0.902655_g14124_i0 | PRJNA641991 | 14243 | 162 | 0.902655 | 1.4623011 | Chlorophyta | 3041 | Plants | Plants | 68.2 | 1.36e-11 | NR | KAK3257406.1 | 36881 | g14124 | i0 | 69 | 6.22222222222222 | 42 | 13 | 77.8 | 0 | 162 | 37 | 557 | 598 | KAK3257406.1 Transmembrane 9 super member 3 [Cymbomonas tetramitiformis] | diamond | 1008 | 68.6 | 0.994169096209913 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 28704274 | 28704274 | PRJNA641991_P_NODE_1627_length_244_cov_1.830769_g1586_i0 | PRJNA641991 | 1627 | 244 | 1.830769 | 4.46707636 | Chlorophyta | 3041 | Plants | Plants | 101 | 5.26e-24 | NR | YP_008802565.1 | 141716 | g1586 | i0 | 60.5 | 7.65983606557377 | 81 | 32 | 99.6 | 0 | 243 | 1 | 101 | 181 | YP_008802565.1 cytochrome c oxidase subunit 3 [Monomastix sp. OKE-1] | diamond | 1869 | 102 | 0.990196078431373 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Monomastigales | Monomastigaceae | Monomastix | Monomastix sp. OKE-1 | ||
| 29146558 | 29146558 | PRJNA641991_S_NODE_12309_length_166_cov_1.743590_g12190_i0 | PRJNA641991 | 12309 | 166 | 1.74359 | 2.8943594 | Opisthokonta | 33154 | Plants | Plants | 50.1 | 3.36e-5 | NR | XP_007509908.1 | 41875 | g12190 | i0 | 45.5 | 40.7530120481928 | 55 | 30 | 99.4 | 0 | 1 | 165 | 148 | 202 | XP_007509908.1 40S ribosomal protein S2 [Bathycoccus prasinos] | diamond | 6765 | 50.1 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 29670283 | 29670283 | PRJNA641991_S_NODE_4350_length_256_cov_1.410628_g4231_i0 | PRJNA641991 | 4350 | 256 | 1.410628 | 3.61120768 | Trebouxia sp. C | 2796353 | Plants | Plants | 149 | 8e-43 | NR | KAL0019246.1 | 2905654 | g4231 | i0 | 83.1 | 2.91796875 | 83 | 14 | 97.3 | 0 | 251 | 3 | 1 | 83 | KAL0019246.1 hypothetical protein WJX79_009739 [Trebouxia sp. C0005] | diamond | 747 | 149 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0005 | |
| 30820301 | 30820301 | PRJNA641991_S_NODE_7894_length_198_cov_1.449664_g7775_i0 | PRJNA641991 | 7894 | 198 | 1.449664 | 2.87033472 | Chlorellaceae | 35461 | Plants | Plants | 43.1 | 0.0152 | NR | PRW59214.1 | 3076 | g7775 | i0 | 54.3 | 6.89393939393939 | 46 | 14 | 68.2 | 2 | 24 | 158 | 489 | 528 | PRW59214.1 NADH:ubiquinone oxidoreductase 76 kDa subunit [Chlorella sorokiniana] | diamond | 1365 | 43.5 | 0.990804597701149 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30997594 | 30997594 | PRJNA641991_P_NODE_3734_length_164_cov_0.886957_g3693_i0 | PRJNA641991 | 3734 | 164 | 0.886957 | 1.45460948 | Ostreococcus lucimarinus CCE99 | 242159 | Plants | Plants | 52 | 5.35e-6 | NR | XP_001417453.1 | 436017 | g3693 | i0 | 50 | 2.96341463414634 | 54 | 27 | 98.8 | 0 | 164 | 3 | 85 | 138 | XP_001417453.1 mitochondrial GrpE-like protein [Ostreococcus lucimarinus CCE9901] | diamond | 486 | 52 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus sp. 'lucimarinus' | ||
| 31294213 | 31294213 | PRJNA641991_P_NODE_1575_length_250_cov_1.014925_g1534_i0 | PRJNA641991 | 1575 | 250 | 1.014925 | 2.5373125 | Eukaryota | 2759 | Plants | Plants | 77.4 | 2.55e-14 | NR | PRW45211.1 | 3076 | g1534 | i0 | 47 | 11.712 | 83 | 43 | 99.6 | 1 | 250 | 2 | 229 | 310 | PRW45211.1 mitogen-activated kinase 3 [Chlorella sorokiniana] | diamond | 2928 | 77.8 | 0.994858611825193 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31452570 | 31452570 | PRJNA641991_S_NODE_6596_length_214_cov_1.436364_g6477_i0 | PRJNA641991 | 6596 | 214 | 1.436364 | 3.07381896 | Eukaryota | 2759 | Plants | Plants | 104 | 1.53e-26 | NR | KAK2077587.1 | 3111 | g6477 | i0 | 65.7 | 42.2102803738318 | 70 | 24 | 98.1 | 0 | 213 | 4 | 7 | 76 | KAK2077587.1 60S ribosomal protein L21A [Prototheca wickerhamii] | diamond | 9033 | 105 | 0.990476190476191 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 31547494 | 31547494 | PRJNA641991_P_NODE_3556_length_165_cov_0.879310_g3515_i0 | PRJNA641991 | 3556 | 165 | 0.87931 | 1.4508615 | Eukaryota | 2759 | Plants | Plants | 109 | 4.38e-26 | NR | PRW33236.1 | 3076 | g3515 | i0 | 94.4 | 61.8545454545455 | 54 | 3 | 98.2 | 0 | 2 | 163 | 193 | 246 | PRW33236.1 nucleolar GTP-binding isoform A [Chlorella sorokiniana] | diamond | 10206 | 110 | 0.990909090909091 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31882820 | 31882820 | PRJNA641991_S_NODE_13817_length_163_cov_0.894737_g13698_i0 | PRJNA641991 | 13817 | 163 | 0.894737 | 1.45842131 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 67.8 | 1.86e-11 | NR | XP_005642775.1 | 574566 | g13698 | i0 | 57.4 | 0.993865030674847 | 54 | 22 | 99.4 | 1 | 163 | 2 | 217 | 269 | XP_005642775.1 heat shock protein 70E [Coccomyxa subellipsoidea C-169] | diamond | 162 | 67.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 32211736 | 32211736 | PRJNA641991_S_NODE_12798_length_165_cov_1.318966_g12679_i0 | PRJNA641991 | 12798 | 165 | 1.318966 | 2.1762939 | Chlorophyta | 3041 | Plants | Plants | 80.9 | 3.73e-17 | NR | CAD7702270.1 | 121088 | g12679 | i0 | 75.5 | 4.89090909090909 | 53 | 13 | 96.4 | 0 | 163 | 5 | 29 | 81 | CAD7702270.1 unnamed protein product [Ostreobium quekettii] | diamond | 807 | 80.9 | 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);;