contig_metadata
20 rows where bioproject = "PRJNA721440" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 710122 | 710122 | PRJNA721440_S_NODE_15741_length_173_cov_2.758065_g15615_i0 | PRJNA721440 | 15741 | 173 | 2.758065 | 4.77145245 | Eukaryota | 2759 | Plants | Plants | 102 | 3.7e-24 | NR | WIA42672.1 | 3088 | g15615 | i0 | 73.7 | 11.8612716763006 | 57 | 15 | 98.8 | 0 | 2 | 172 | 43 | 99 | WIA42672.1 hypothetical protein OEZ86_008632 [Tetradesmus obliquus] | diamond | 2052 | 103 | 0.990291262135922 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 4538523 | 4538523 | PRJNA721440_S_NODE_1084_length_502_cov_1.836645_g960_i0 | PRJNA721440 | 1084 | 502 | 1.836645 | 9.2199579 | root | 1 | Root_unresolved | Root_unresolved | 256 | 4.32e-79 | NR | GFR43178.1 | 47775 | g960 | i0 | 73.5 | 8.93426294820717 | 166 | 44 | 99.2 | 0 | 3 | 500 | 293 | 458 | GFR43178.1 hypothetical protein Agub_g4228 [Astrephomene gubernaculifera] | diamond | 4485 | 256 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 7088936 | 7088936 | PRJNA721440_S_NODE_2586_length_349_cov_2.713333_g2460_i0 | PRJNA721440 | 2586 | 349 | 2.713333 | 9.46953217 | Eukaryota | 2759 | Plants | Plants | 141 | 1.24e-37 | NR | PRW32880.1 | 3076 | g2460 | i0 | 91 | 1016.86246418338 | 78 | 7 | 67 | 0 | 1 | 234 | 59 | 136 | PRW32880.1 histone H3 [Chlorella sorokiniana] | diamond | 354885 | 142 | 0.992957746478873 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 16496561 | 16496561 | PRJNA721440_S_NODE_1493_length_437_cov_313.152062_g1367_i0 | PRJNA721440 | 1493 | 437 | 313.152062 | 1368.47451094 | Eukaryota | 2759 | Plants | Plants | 673 | 0 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g1367 | i0 | 100 | 83.1144164759725 | 364 | 0 | 83 | 0 | 1 | 364 | 506 | 869 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 36321 | 673 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 18561988 | 18561988 | PRJNA721440_S_NODE_3435_length_308_cov_10.571429_g3309_i0 | PRJNA721440 | 3435 | 308 | 10.571429 | 32.56000132 | Tetradesmus obliquus | 3088 | Plants | Plants | 186 | 2.7899999999999992e-55 | NR | WIA42672.1 | 3088 | g3309 | i0 | 90.3 | 0.905844155844156 | 93 | 9 | 90.6 | 0 | 280 | 2 | 16 | 108 | WIA42672.1 hypothetical protein OEZ86_008632 [Tetradesmus obliquus] | diamond | 279 | 186 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 26703657 | 26703657 | PRJNA721440_S_NODE_17941_length_166_cov_4.222222_g17815_i0 | PRJNA721440 | 17941 | 166 | 4.222222 | 7.00888852 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 98.2 | 2.7e-22 | NR | GAX78472.1 | 1157962 | g17815 | i0 | 83.6 | 0.993975903614458 | 55 | 9 | 99.4 | 0 | 166 | 2 | 349 | 403 | GAX78472.1 hypothetical protein CEUSTIGMA_g5911.t1 [Chlamydomonas eustigma] | diamond | 165 | 98.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 27368490 | 27368490 | PRJNA721440_S_NODE_9563_length_208_cov_1.635220_g9437_i0 | PRJNA721440 | 9563 | 208 | 1.63522 | 3.4012576 | Monoraphidium minutum | 39955 | Plants | Plants | 43.5 | 0.013 | NR | KAI8474118.1 | 39955 | g9437 | i0 | 43.8 | 0.692307692307692 | 48 | 27 | 69.2 | 0 | 64 | 207 | 3 | 50 | KAI8474118.1 MAG: hypothetical protein J3K34DRAFT_408903 [Monoraphidium minutum] | diamond | 144 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 27873322 | 27873322 | PRJNA721440_S_NODE_4485_length_278_cov_1.847162_g4359_i0 | PRJNA721440 | 4485 | 278 | 1.847162 | 5.13511036 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 107 | 1.15e-25 | NR | BDA45866.1 | 2315456 | g4359 | i0 | 62 | 0.992805755395683 | 92 | 32 | 98.2 | 2 | 276 | 4 | 87 | 176 | BDA45866.1 Metal tolerance protein 9 [Coccomyxa sp. Obi] | diamond | 276 | 107 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 28062713 | 28062713 | PRJNA721440_S_NODE_7905_length_223_cov_1.626437_g7779_i0 | PRJNA721440 | 7905 | 223 | 1.626437 | 3.62695451 | Edaphochlamys debaryana | 47281 | Plants | Plants | 112 | 3.88e-28 | NR | KAG2495107.1 | 47281 | g7779 | i0 | 75.7 | 1.99103139013453 | 74 | 18 | 99.6 | 0 | 222 | 1 | 201 | 274 | KAG2495107.1 hypothetical protein HYH03_006717 [Edaphochlamys debaryana] | diamond | 444 | 112 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 28157756 | 28157756 | PRJNA721440_S_NODE_14365_length_179_cov_2.046154_g14239_i0 | PRJNA721440 | 14365 | 179 | 2.046154 | 3.66261566 | Volvox africanus | 51714 | Plants | Plants | 56.6 | 1.99e-7 | NR | GIL62576.1 | 51714 | g14239 | i0 | 46.6 | 0.972067039106145 | 58 | 30 | 95.5 | 1 | 8 | 178 | 84 | 141 | GIL62576.1 hypothetical protein Vafri_16759 [Volvox africanus] | diamond | 174 | 56.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 28199328 | 28199328 | PRJNA721440_S_NODE_17706_length_167_cov_1.313559_g17580_i0 | PRJNA721440 | 17706 | 167 | 1.313559 | 2.19364353 | Chlorophyta | 3041 | Plants | Plants | 82.4 | 1.36e-16 | NR | KAG2493544.1 | 47281 | g17580 | i0 | 65.5 | 2.96407185628743 | 55 | 19 | 98.8 | 0 | 3 | 167 | 335 | 389 | KAG2493544.1 hypothetical protein HYH03_008358 [Edaphochlamys debaryana] | diamond | 495 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 28641751 | 28641751 | PRJNA721440_S_NODE_1167_length_485_cov_3.405963_g1043_i0 | PRJNA721440 | 1167 | 485 | 3.405963 | 16.51892055 | Eukaryota | 2759 | Plants | Plants | 92 | 3.22e-18 | NR | KAF5827513.1 | 3046 | g1043 | i0 | 54.5 | 5.74020618556701 | 88 | 33 | 51.3 | 2 | 236 | 484 | 75 | 160 | KAF5827513.1 hypothetical protein DUNSADRAFT_538 [Dunaliella salina] | diamond | 2784 | 92.8 | 0.991379310344828 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 29399303 | 29399303 | PRJNA721440_S_NODE_11489_length_195_cov_1.294521_g11363_i0 | PRJNA721440 | 11489 | 195 | 1.294521 | 2.52431595 | root | 1 | Root_unresolved | Root_unresolved | 97.1 | 1.47e-21 | NR | PRW61378.1 | 3076 | g11363 | i0 | 69.8 | 9.70769230769231 | 63 | 19 | 96.9 | 0 | 3 | 191 | 1152 | 1214 | PRW61378.1 putative phosphoribosylformylglycinamidine chloroplastic mitochondrial [Chlorella sorokiniana] | diamond | 1893 | 97.4 | 0.996919917864476 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 29525769 | 29525769 | PRJNA721440_S_NODE_4230_length_284_cov_5.089362_g4104_i0 | PRJNA721440 | 4230 | 284 | 5.089362 | 14.45378808 | Chlorophyceae | 3166 | Plants | Plants | 119 | 2.66e-31 | NR | WIA40074.1 | 3088 | g4104 | i0 | 56.4 | 5.93661971830986 | 94 | 41 | 99.3 | 0 | 2 | 283 | 55 | 148 | WIA40074.1 hypothetical protein OEZ86_013489 [Tetradesmus obliquus] | diamond | 1686 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 29746405 | 29746405 | PRJNA721440_S_NODE_14190_length_180_cov_1.587786_g14064_i0 | PRJNA721440 | 14190 | 180 | 1.587786 | 2.8580148 | Chlorophyta | 3041 | Plants | Plants | 57.8 | 7.67e-8 | NR | KXZ48051.1 | 33097 | g14064 | i0 | 54.7 | 3.56666666666667 | 53 | 22 | 88.3 | 1 | 3 | 161 | 265 | 315 | KXZ48051.1 hypothetical protein GPECTOR_30g146 [Gonium pectorale] | diamond | 642 | 57.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 31031764 | 31031764 | PRJNA721440_S_NODE_15855_length_173_cov_1.064516_g15729_i0 | PRJNA721440 | 15855 | 173 | 1.064516 | 1.84161268 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 49.7 | 5.22e-5 | NR | KAF8066373.1 | 2742167 | g15729 | i0 | 62.5 | 2.02890173410405 | 40 | 15 | 69.4 | 0 | 170 | 51 | 1550 | 1589 | KAF8066373.1 hypothetical protein HT031_002697 [Scenedesmus sp. PABB004] | diamond | 351 | 49.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 31105028 | 31105028 | PRJNA721440_S_NODE_8195_length_220_cov_1.520468_g8069_i0 | PRJNA721440 | 8195 | 220 | 1.520468 | 3.3450296 | Eukaryota | 2759 | Plants | Plants | 70.1 | 6.08e-12 | NR | XP_002952694.1 | 3068 | g8069 | i0 | 77.8 | 9.58636363636364 | 36 | 8 | 49.1 | 0 | 112 | 219 | 17 | 52 | XP_002952694.1 4-hydroxyphenylpyruvate dioxygenase [Volvox carteri f. nagariensis] | diamond | 2109 | 70.5 | 0.994326241134752 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 31410957 | 31410957 | PRJNA721440_S_NODE_14316_length_179_cov_3.884615_g14190_i0 | PRJNA721440 | 14316 | 179 | 3.884615 | 6.95346085 | Monoraphidium neglectum | 145388 | Plants | Plants | 63.2 | 2.96e-10 | NR | XP_013899290.1 | 145388 | g14190 | i0 | 54.7 | 0.888268156424581 | 53 | 24 | 88.8 | 0 | 177 | 19 | 140 | 192 | XP_013899290.1 hypothetical protein MNEG_7690 [Monoraphidium neglectum] | diamond | 159 | 63.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 31895783 | 31895783 | PRJNA721440_S_NODE_20897_length_157_cov_2.740741_g20771_i0 | PRJNA721440 | 20897 | 157 | 2.740741 | 4.30296337 | root | 1 | Root_unresolved | Root_unresolved | 82.4 | 1.16e-16 | NR | KAG2483093.1 | 47281 | g20771 | i0 | 73.5 | 7.35668789808917 | 49 | 13 | 93.6 | 0 | 155 | 9 | 244 | 292 | KAG2483093.1 hypothetical protein HYH03_018031 [Edaphochlamys debaryana] | diamond | 1155 | 83.2 | 0.990384615384615 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 32043545 | 32043545 | PRJNA721440_S_NODE_18378_length_165_cov_2.801724_g18252_i0 | PRJNA721440 | 18378 | 165 | 2.801724 | 4.6228446 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 47.4 | 3.09e-4 | NR | GAX72653.1 | 1157962 | g18252 | i0 | 56.8 | 2 | 37 | 16 | 67.3 | 0 | 153 | 43 | 63 | 99 | GAX72653.1 hypothetical protein CEUSTIGMA_g109.t1 [Chlamydomonas eustigma] | diamond | 330 | 47.4 | 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);;