contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11868231 | 11868231 | PRJNA330616_P_NODE_17210_length_202_cov_1.333333_g16801_i0 | PRJNA330616 | 17210 | 202 | 1.333333 | 2.69333266 | Eukaryota | 2759 | Plants | Plants | 119 | 1.16e-29 | NR | XP_007510486.1 | 41875 | g16801 | i0 | 86.4 | 14.6138613861386 | 66 | 9 | 98 | 0 | 200 | 3 | 470 | 535 | XP_007510486.1 S-adenosyl-L-homocysteine hydrolase [Bathycoccus prasinos] | diamond | 2952 | 120 | 0.991666666666667 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 13143056 | 13143056 | PRJNA330616_P_NODE_11471_length_244_cov_1.569231_g11062_i0 | PRJNA330616 | 11471 | 244 | 1.569231 | 3.82892364 | Opisthokonta | 33154 | Plants | Plants | 131 | 1.07e-35 | NR | XP_002502307.1 | 296587 | g11062 | i0 | 77.8 | 24.8975409836066 | 81 | 18 | 99.6 | 0 | 243 | 1 | 50 | 130 | XP_002502307.1 predicted protein [Micromonas commoda] | diamond | 6075 | 131 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 17646917 | 17646917 | PRJNA330616_P_NODE_22374_length_179_cov_1.007692_g21965_i0 | PRJNA330616 | 22374 | 179 | 1.007692 | 1.80376868 | root | 1 | Root_unresolved | Root_unresolved | 95.9 | 1.46e-21 | NR | YP_009310466.1 | 36894 | g21965 | i0 | 77.2 | 52.4413407821229 | 57 | 13 | 95.5 | 0 | 6 | 176 | 9 | 65 | YP_009310466.1 NADH dehydrogenase subunit 7 [Pyramimonas parkeae] | diamond | 9387 | 95.9 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Pyramimonas | Pyramimonas parkeae | ||
| 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 | |
| 27895774 | 27895774 | PRJNA330616_P_NODE_26885_length_166_cov_0.871795_g26476_i0 | PRJNA330616 | 26885 | 166 | 0.871795 | 1.4471797 | Ostreococcus tauri | 70448 | Plants | Plants | 61.2 | 3.61e-9 | NR | XP_003081198.1 | 70448 | g26476 | i0 | 52.7 | 2.00602409638554 | 55 | 26 | 99.4 | 0 | 165 | 1 | 25 | 79 | XP_003081198.1 Thioredoxin, conserved site [Ostreococcus tauri] | diamond | 333 | 61.2 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 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 | |
| 32399998 | 32399998 | PRJNA330616_P_NODE_22939_length_176_cov_2.401575_g22530_i0 | PRJNA330616 | 22939 | 176 | 2.401575 | 4.226772 | Opisthokonta | 33154 | Plants | Plants | 92 | 6.52e-21 | NR | XP_022840602.1 | 70448 | g22530 | i0 | 77.6 | 7.90909090909091 | 58 | 13 | 98.9 | 0 | 2 | 175 | 157 | 214 | XP_022840602.1 Ribosomal protein S3Ae [Ostreococcus tauri] | diamond | 1392 | 92 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 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);;