contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24615993 | 24615993 | PRJNA330616_P_NODE_5960_length_343_cov_2.816327_g5551_i0 | PRJNA330616 | 5960 | 343 | 2.816327 | 9.66000161 | Eukaryota | 2759 | Plants | Plants | 181 | 5.949999999999999e-54 | NR | KAJ9532284.1 | 44745 | g5551 | i0 | 74.6 | 22.6268221574344 | 114 | 29 | 99.7 | 0 | 342 | 1 | 135 | 248 | KAJ9532284.1 hypothetical protein QJQ45_010414 [Haematococcus lacustris] | diamond | 7761 | 182 | 0.994505494505495 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 26648540 | 26648540 | PRJNA330616_P_NODE_19821_length_189_cov_1.614286_g19412_i0 | PRJNA330616 | 19821 | 189 | 1.614286 | 3.05100054 | Chlamydomonas | 3052 | Plants | Plants | 42.4 | 0.025 | NR | KAG2424799.1 | 51695 | g19412 | i0 | 46.9 | 1.55555555555556 | 49 | 26 | 77.8 | 0 | 175 | 29 | 151 | 199 | KAG2424799.1 hypothetical protein HXX76_014222 [Chlamydomonas incerta] | diamond | 294 | 42.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 29018565 | 29018565 | PRJNA330616_P_NODE_29068_length_164_cov_0.886957_g28659_i0 | PRJNA330616 | 29068 | 164 | 0.886957 | 1.45460948 | Chlorella | 3071 | Plants | Plants | 80.1 | 8.56e-16 | NR | KAI3428567.1 | 3077 | g28659 | i0 | 56.9 | 2.85365853658537 | 51 | 22 | 93.3 | 0 | 164 | 12 | 48 | 98 | KAI3428567.1 hypothetical protein D9Q98_007389 [Chlorella vulgaris] | diamond | 468 | 80.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 29348369 | 29348369 | PRJNA330616_P_NODE_20629_length_186_cov_1.218978_g20220_i0 | PRJNA330616 | 20629 | 186 | 1.218978 | 2.26729908 | Dunaliella salina | 3046 | Plants | Plants | 92.8 | 7.1e-23 | NR | KAF5840039.1 | 3046 | g20220 | i0 | 67.2 | 2.91935483870968 | 61 | 20 | 98.4 | 0 | 184 | 2 | 3 | 63 | KAF5840039.1 ribosomal protein L37a component of cytosolic 80S ribosome and 60S large subunit [Dunaliella salina] | diamond | 543 | 92.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 29379830 | 29379830 | PRJNA330616_P_NODE_14969_length_216_cov_0.970060_g14560_i0 | PRJNA330616 | 14969 | 216 | 0.97006 | 2.0953296 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 107 | 3.26e-25 | NR | KAA6412948.1 | 2608996 | g14560 | i0 | 69 | 0.986111111111111 | 71 | 22 | 98.6 | 0 | 3 | 215 | 457 | 527 | KAA6412948.1 MAG: hypothetical protein FRX49_13747 [Trebouxia sp. A1-2] | diamond | 213 | 107 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 29853546 | 29853546 | PRJNA330616_P_NODE_15511_length_212_cov_1.251534_g15102_i0 | PRJNA330616 | 15511 | 212 | 1.251534 | 2.65325208 | Koliella corcontica | 155904 | Plants | Plants | 47.8 | 3.64e-4 | NR | XAI66889.1 | 155904 | g15102 | i0 | 68.6 | 1.03301886792453 | 35 | 11 | 49.5 | 0 | 102 | 206 | 1 | 35 | XAI66889.1 ATP synthase F0 subunit 6 [Koliella corcontica] | diamond | 219 | 47.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella corcontica | |
| 30755461 | 30755461 | PRJNA330616_P_NODE_16234_length_208_cov_1.257862_g15825_i0 | PRJNA330616 | 16234 | 208 | 1.257862 | 2.61635296 | Trebouxiales | 2507901 | Plants | Plants | 110 | 4.16e-28 | NR | XP_005643653.1 | 574566 | g15825 | i0 | 80.6 | 5.78365384615385 | 67 | 13 | 96.6 | 0 | 203 | 3 | 69 | 135 | XP_005643653.1 60S ribosomal protein L7 [Coccomyxa subellipsoidea C-169] | diamond | 1203 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 31211600 | 31211600 | PRJNA330616_P_NODE_29875_length_163_cov_0.894737_g29466_i0 | PRJNA330616 | 29875 | 163 | 0.894737 | 1.45842131 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 68.2 | 1.36e-11 | NR | GFR41818.1 | 47775 | g29466 | i0 | 57.4 | 5.96319018404908 | 54 | 23 | 99.4 | 0 | 2 | 163 | 336 | 389 | GFR41818.1 hypothetical protein Agub_g2590 [Astrephomene gubernaculifera] | diamond | 972 | 68.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 31306890 | 31306890 | PRJNA330616_P_NODE_31175_length_162_cov_0.902655_g30766_i0 | PRJNA330616 | 31175 | 162 | 0.902655 | 1.4623011 | Pleodorina starrii | 330485 | Plants | Plants | 49.7 | 4.3e-5 | NR | GLC50720.1 | 330485 | g30766 | i0 | 61 | 0.759259259259259 | 41 | 16 | 75.9 | 0 | 38 | 160 | 47 | 87 | GLC50720.1 hypothetical protein PLESTB_000412000 [Pleodorina starrii] | diamond | 123 | 49.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 32446032 | 32446032 | PRJNA330616_P_NODE_28119_length_165_cov_0.879310_g27710_i0 | PRJNA330616 | 28119 | 165 | 0.87931 | 1.4508615 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 97.1 | 6.79e-22 | NR | GAX78472.1 | 1157962 | g27710 | i0 | 81.5 | 0.981818181818182 | 54 | 10 | 98.2 | 0 | 2 | 163 | 106 | 159 | GAX78472.1 hypothetical protein CEUSTIGMA_g5911.t1 [Chlamydomonas eustigma] | diamond | 162 | 97.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma |
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);;