contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA658591" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18477796 | 18477796 | PRJNA658591_S_NODE_8455_length_171_cov_2.696721_g8392_i0 | PRJNA658591 | 8455 | 171 | 2.696721 | 4.61139291 | Sanguina aurantia | 2578422 | Plants | Plants | 94 | 1.25e-20 | NR | MEW5299832.1 | 2578422 | g8392 | i0 | 75 | 1.96491228070175 | 56 | 14 | 98.2 | 0 | 170 | 3 | 268 | 323 | MEW5299832.1 hypothetical protein [Sanguina aurantia] | diamond | 336 | 94 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Sanguina | Sanguina aurantia | |
| 28198808 | 28198808 | PRJNA658591_S_NODE_9206_length_167_cov_1.313559_g9143_i0 | PRJNA658591 | 9206 | 167 | 1.313559 | 2.19364353 | Chlorophyta | 3041 | Plants | Plants | 82.4 | 1.36e-16 | NR | KAG2493544.1 | 47281 | g9143 | 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 | ||
| 28420224 | 28420224 | PRJNA658591_S_NODE_9046_length_168_cov_0.873950_g8983_i0 | PRJNA658591 | 9046 | 168 | 0.87395 | 1.468236 | Eukaryota | 2759 | Plants | Plants | 70.1 | 3.02e-12 | NR | XP_002952694.1 | 3068 | g8983 | i0 | 77.8 | 11.3928571428571 | 36 | 8 | 64.3 | 0 | 108 | 1 | 17 | 52 | XP_002952694.1 4-hydroxyphenylpyruvate dioxygenase [Volvox carteri f. nagariensis] | diamond | 1914 | 70.5 | 0.994326241134752 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 29209504 | 29209504 | PRJNA658591_S_NODE_6389_length_189_cov_2.992857_g6326_i0 | PRJNA658591 | 6389 | 189 | 2.992857 | 5.65649973 | Chlorophyta | 3041 | Plants | Plants | 77.4 | 1.05e-14 | NR | KAK3253051.1 | 36881 | g6326 | i0 | 59.7 | 4.73015873015873 | 62 | 25 | 98.4 | 0 | 2 | 187 | 314 | 375 | KAK3253051.1 hypothetical protein CYMTET_37680 [Cymbomonas tetramitiformis] | diamond | 894 | 77.8 | 0.994858611825193 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 29240986 | 29240986 | PRJNA658591_S_NODE_10909_length_157_cov_2.259259_g10846_i0 | PRJNA658591 | 10909 | 157 | 2.259259 | 3.54703663 | root | 1 | Root_unresolved | Root_unresolved | 82.4 | 1.16e-16 | NR | KAG2483093.1 | 47281 | g10846 | 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 | ||
| 29670408 | 29670408 | PRJNA658591_S_NODE_2830_length_257_cov_16.668269_g2767_i0 | PRJNA658591 | 2830 | 257 | 16.668269 | 42.83745133 | Ostreococcus tauri | 70448 | Plants | Plants | 81.6 | 3.88e-16 | NR | XP_022840204.1 | 70448 | g2767 | i0 | 66.7 | 3.15175097276265 | 54 | 18 | 63 | 0 | 255 | 94 | 260 | 313 | XP_022840204.1 G-protein beta WD-40 repeat [Ostreococcus tauri] | diamond | 810 | 81.6 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 30030492 | 30030492 | PRJNA658591_S_NODE_9171_length_167_cov_1.754237_g9108_i0 | PRJNA658591 | 9171 | 167 | 1.754237 | 2.92957579 | Eukaryota | 2759 | Plants | Plants | 77 | 1.08e-14 | NR | KAF5827513.1 | 3046 | g9108 | i0 | 60 | 28.437125748503 | 55 | 22 | 98.8 | 0 | 166 | 2 | 106 | 160 | KAF5827513.1 hypothetical protein DUNSADRAFT_538 [Dunaliella salina] | diamond | 4749 | 77 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 30618383 | 30618383 | PRJNA658591_S_NODE_4513_length_216_cov_1.137725_g4450_i0 | PRJNA658591 | 4513 | 216 | 1.137725 | 2.457486 | Gonium pectorale | 33097 | Plants | Plants | 107 | 3.39e-25 | NR | KXZ56375.1 | 33097 | g4450 | i0 | 79.7 | 0.888888888888889 | 64 | 13 | 88.9 | 0 | 195 | 4 | 438 | 501 | KXZ56375.1 hypothetical protein GPECTOR_1g332 [Gonium pectorale] | diamond | 192 | 107 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 30946841 | 30946841 | PRJNA658591_S_NODE_7554_length_178_cov_5.232558_g7491_i0 | PRJNA658591 | 7554 | 178 | 5.232558 | 9.31395324 | root | 1 | Root_unresolved | Root_unresolved | 114 | 1.34e-27 | NR | XP_002500915.1 | 296587 | g7491 | i0 | 84.5 | 7.93820224719101 | 58 | 9 | 97.8 | 0 | 177 | 4 | 778 | 835 | XP_002500915.1 predicted protein [Micromonas commoda] | diamond | 1413 | 115 | 0.991304347826087 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 31863465 | 31863465 | PRJNA658591_S_NODE_4197_length_221_cov_3.098837_g4134_i0 | PRJNA658591 | 4197 | 221 | 3.098837 | 6.84842977 | Viridiplantae | 33090 | Plants | Plants | 57.4 | 7.19e-9 | NR | XP_007514946.1 | 41875 | g4134 | i0 | 56.5 | 1.50678733031674 | 46 | 20 | 62.4 | 0 | 16 | 153 | 7 | 52 | XP_007514946.1 predicted protein [Bathycoccus prasinos] | diamond | 333 | 57.4 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 32168021 | 32168021 | PRJNA658591_S_NODE_2498_length_271_cov_1.427928_g2435_i0 | PRJNA658591 | 2498 | 271 | 1.427928 | 3.86968488 | Monoraphidium neglectum | 145388 | Plants | Plants | 67.4 | 2.3e-11 | NR | XP_013899290.1 | 145388 | g2435 | i0 | 54.5 | 0.608856088560886 | 55 | 25 | 60.9 | 0 | 269 | 105 | 138 | 192 | XP_013899290.1 hypothetical protein MNEG_7690 [Monoraphidium neglectum] | diamond | 165 | 67.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;