contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1111146" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16793676 | 16793676 | PRJNA1111146_P_NODE_354254_length_182_cov_0.883721_g353116_i0 | PRJNA1111146 | 354254 | 182 | 0.883721 | 1.60837222 | root | 1 | Root_unresolved | Root_unresolved | 87 | 4.08e-18 | NR | KAL4853082.1 | 3077 | g353116 | i0 | 83.3 | 8.25824175824176 | 42 | 7 | 69.2 | 0 | 1 | 126 | 84 | 125 | KAL4853082.1 Ribonuclease J [Chlorella vulgaris] | diamond | 1503 | 87 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 27636620 | 27636620 | PRJNA1111146_P_NODE_315284_length_185_cov_0.863636_g314146_i0 | PRJNA1111146 | 315284 | 185 | 0.863636 | 1.5977266 | Monoraphidium neglectum | 145388 | Plants | Plants | 51.6 | 2.29e-6 | NR | XP_013895809.1 | 145388 | g314146 | i0 | 63.9 | 0.583783783783784 | 36 | 13 | 58.4 | 0 | 108 | 1 | 1 | 36 | XP_013895809.1 hypothetical protein MNEG_11174 [Monoraphidium neglectum] | diamond | 108 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 27699955 | 27699955 | PRJNA1111146_P_NODE_251624_length_196_cov_1.328671_g250486_i0 | PRJNA1111146 | 251624 | 196 | 1.328671 | 2.60419516 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 70.9 | 2.35e-12 | NR | KAA6420936.1 | 2608996 | g250486 | i0 | 89.2 | 0.566326530612245 | 37 | 4 | 56.6 | 0 | 84 | 194 | 1 | 37 | KAA6420936.1 MAG: hypothetical protein FRX49_09077 [Trebouxia sp. A1-2] | diamond | 111 | 70.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 27920576 | 27920576 | PRJNA1111146_P_NODE_341485_length_183_cov_0.869231_g340347_i0 | PRJNA1111146 | 341485 | 183 | 0.869231 | 1.59069273 | Micractinium conductrix | 554055 | Plants | Plants | 57.4 | 1.18e-7 | NR | PSC74993.1 | 554055 | g340347 | i0 | 90 | 0.491803278688525 | 30 | 3 | 49.2 | 0 | 165 | 76 | 863 | 892 | PSC74993.1 ankyrin repeat [Micractinium conductrix] | diamond | 90 | 57.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 28962815 | 28962815 | PRJNA1111146_P_NODE_357188_length_182_cov_0.875969_g356050_i0 | PRJNA1111146 | 357188 | 182 | 0.875969 | 1.59426358 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 70.5 | 2.7e-12 | NR | KAL4422479.1 | 2728915 | g356050 | i0 | 84.8 | 0.543956043956044 | 33 | 5 | 54.4 | 0 | 99 | 1 | 280 | 312 | KAL4422479.1 hypothetical protein ABPG75_008676 [Micractinium tetrahymenae] | diamond | 99 | 70.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 29679692 | 29679692 | PRJNA1111146_P_NODE_358910_length_182_cov_0.868217_g357772_i0 | PRJNA1111146 | 358910 | 182 | 0.868217 | 1.58015494 | Trebouxiophyceae | 75966 | Plants | Plants | 43.9 | 0.00597 | NR | PRW56719.1 | 3076 | g357772 | i0 | 43.5 | 1.45054945054945 | 46 | 26 | 75.8 | 0 | 42 | 179 | 177 | 222 | PRW56719.1 SOUL heme-binding [Chlorella sorokiniana] | diamond | 264 | 43.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31490134 | 31490134 | PRJNA1111146_P_NODE_218296_length_203_cov_0.986667_g217158_i0 | PRJNA1111146 | 218296 | 203 | 0.986667 | 2.00293401 | Chlorella sorokiniana | 3076 | Plants | Plants | 68.6 | 1.76e-11 | NR | PRW58082.1 | 3076 | g217158 | i0 | 53 | 2.76354679802956 | 66 | 27 | 97.5 | 2 | 203 | 6 | 1409 | 1470 | PRW58082.1 strawberry notch-like protein 1-like [Chlorella sorokiniana] | diamond | 561 | 68.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31584954 | 31584954 | PRJNA1111146_P_NODE_108656_length_239_cov_1.204301_g107518_i0 | PRJNA1111146 | 108656 | 239 | 1.204301 | 2.87827939 | Tetradesmus obliquus | 3088 | Plants | Plants | 57 | 3.12e-7 | NR | WIA23049.1 | 3088 | g107518 | i0 | 48.6 | 0.928870292887029 | 74 | 37 | 91.6 | 1 | 236 | 18 | 137 | 210 | WIA23049.1 hypothetical protein OEZ85_001398 [Tetradesmus obliquus] | diamond | 222 | 57 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 32659792 | 32659792 | PRJNA1111146_P_NODE_347940_length_182_cov_1.410853_g346802_i0 | PRJNA1111146 | 347940 | 182 | 1.410853 | 2.56775246 | Micractinium conductrix | 554055 | Plants | Plants | 45.1 | 0.00126 | NR | PSC75108.1 | 554055 | g346802 | i0 | 81 | 0.346153846153846 | 21 | 4 | 34.6 | 0 | 91 | 29 | 133 | 153 | PSC75108.1 hypothetical protein C2E20_1860 [Micractinium conductrix] | diamond | 63 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix |
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);;