contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax_kingdom = "Viridiplantae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10829709 | 10829709 | PRJNA658591_S_NODE_2069_length_293_cov_4.737705_g2006_i0 | PRJNA658591 | 2069 | 293 | 4.737705 | 13.88147565 | Eukaryota | 2759 | Plants | Plants | 148 | 5.469999999999999e-42 | NR | XP_023536739.1 | 3664 | g2006 | i0 | 86.7 | 122.150170648464 | 83 | 11 | 85 | 0 | 2 | 250 | 170 | 252 | XP_023536739.1 14-3-3-like protein GF14 iota [Cucurbita pepo subsp. pepo] | diamond | 35790 | 149 | 0.993288590604027 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucurbita | Cucurbita pepo | |
| 14654440 | 14654440 | PRJNA658591_S_NODE_9552_length_165_cov_2.793103_g9489_i0 | PRJNA658591 | 9552 | 165 | 2.793103 | 4.60861995 | Eukaryota | 2759 | Plants | Plants | 84.7 | 2.25e-18 | NR | KAH0913690.1 | 3708 | g9489 | i0 | 75.5 | 14.7454545454545 | 49 | 12 | 89.1 | 0 | 147 | 1 | 34 | 82 | KAH0913690.1 hypothetical protein HID58_037011 [Brassica napus] | diamond | 2433 | 84.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 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 | |
| 26606335 | 26606335 | PRJNA658591_S_NODE_4241_length_220_cov_6.076023_g4178_i0 | PRJNA658591 | 4241 | 220 | 6.076023 | 13.3672506 | Sphagnum balticum | 128184 | Plants | Plants | 89.7 | 5.8e-20 | NR | CAM6002349.1 | 128184 | g4178 | i0 | 57.5 | 0.995454545454545 | 73 | 31 | 99.5 | 0 | 1 | 219 | 7 | 79 | CAM6002349.1 unnamed protein product, partial [Sphagnum balticum] | diamond | 219 | 89.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 26828354 | 26828354 | PRJNA658591_S_NODE_3501_length_237_cov_3.223404_g3438_i0 | PRJNA658591 | 3501 | 237 | 3.223404 | 7.63946748 | Sphagnum balticum | 128184 | Plants | Plants | 115 | 7.18e-30 | NR | CAM6002349.1 | 128184 | g3438 | i0 | 65.8 | 1 | 79 | 27 | 100 | 0 | 237 | 1 | 102 | 180 | CAM6002349.1 unnamed protein product, partial [Sphagnum balticum] | diamond | 237 | 115 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 27081347 | 27081347 | PRJNA658591_S_NODE_7222_length_181_cov_2.068182_g7159_i0 | PRJNA658591 | 7222 | 181 | 2.068182 | 3.74340942 | Sphagnum jensenii | 128206 | Plants | Plants | 79.7 | 8.76e-16 | NR | CAK9251169.1 | 128206 | g7159 | i0 | 56.9 | 1.93922651933702 | 58 | 25 | 96.1 | 0 | 179 | 6 | 239 | 296 | CAK9251169.1 unnamed protein product [Sphagnum jensenii] | diamond | 351 | 79.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum jensenii | |
| 27681956 | 27681956 | PRJNA658591_S_NODE_10084_length_163_cov_0.956140_g10021_i0 | PRJNA658591 | 10084 | 163 | 0.95614 | 1.5585082 | Sphagnum compactum | 128190 | Plants | Plants | 100 | 8.76e-24 | NR | CAM6032031.1 | 128190 | g10021 | i0 | 92.6 | 0.993865030674847 | 54 | 4 | 99.4 | 0 | 2 | 163 | 150 | 203 | CAM6032031.1 unnamed protein product, partial [Sphagnum compactum] | diamond | 162 | 100 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum compactum | |
| 27681957 | 27681957 | PRJNA658591_S_NODE_4264_length_220_cov_1.538012_g4201_i0 | PRJNA658591 | 4264 | 220 | 1.538012 | 3.3836264 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 80.5 | 1.34e-15 | NR | BAK03058.1 | 112509 | g4201 | i0 | 53.5 | 1.95 | 71 | 33 | 96.8 | 0 | 1 | 213 | 128 | 198 | BAK03058.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 429 | 80.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 27820269 | 27820269 | PRJNA658591_S_NODE_9204_length_167_cov_1.322034_g9141_i0 | PRJNA658591 | 9204 | 167 | 1.322034 | 2.20779678 | Eukaryota | 2759 | Plants | Plants | 106 | 6.92e-26 | NR | CAM0881047.1 | 114194 | g9141 | i0 | 85.5 | 373.473053892216 | 55 | 8 | 98.8 | 0 | 2 | 166 | 182 | 236 | CAM0881047.1 unnamed protein product [Alopecurus aequalis] | diamond | 62370 | 107 | 0.990654205607477 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Alopecurus | Alopecurus aequalis | |
| 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 | |
| 29008021 | 29008021 | PRJNA658591_S_NODE_2008_length_297_cov_1.814516_g1945_i0 | PRJNA658591 | 2008 | 297 | 1.814516 | 5.38911252 | Mangifera indica | 29780 | Plants | Plants | 43.5 | 0.0374 | NR | XP_044495229.1 | 29780 | g1945 | i0 | 30 | 0.808080808080808 | 80 | 55 | 80.8 | 1 | 265 | 26 | 151 | 229 | XP_044495229.1 probable potassium transporter 13 isoform X2 [Mangifera indica] | diamond | 240 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Anacardiaceae | Mangifera | Mangifera indica | |
| 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 | |
| 30049603 | 30049603 | PRJNA658591_S_NODE_5551_length_199_cov_6.293333_g5488_i0 | PRJNA658591 | 5551 | 199 | 6.293333 | 12.52373267 | Sphagnum balticum | 128184 | Plants | Plants | 106 | 1.6e-26 | NR | CAM6002349.1 | 128184 | g5488 | i0 | 93.4 | 1.8391959798995 | 61 | 4 | 92 | 0 | 197 | 15 | 171 | 231 | CAM6002349.1 unnamed protein product, partial [Sphagnum balticum] | diamond | 366 | 106 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 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 | |
| 30662286 | 30662286 | PRJNA658591_S_NODE_7133_length_182_cov_1.052632_g7070_i0 | PRJNA658591 | 7133 | 182 | 1.052632 | 1.91579024 | Arabidopsis | 3701 | Plants | Plants | 58.9 | 3.23e-8 | NR | CAE5956253.1 | 38785 | g7070 | i0 | 75.7 | 2.91758241758242 | 37 | 9 | 61 | 0 | 115 | 5 | 1848 | 1884 | CAE5956253.1 unnamed protein product [Arabidopsis arenosa] | diamond | 531 | 58.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis arenosa | |
| 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 | |
| 32231333 | 32231333 | PRJNA658591_S_NODE_8638_length_170_cov_1.297521_g8575_i0 | PRJNA658591 | 8638 | 170 | 1.297521 | 2.2057857 | Carnegiea gigantea | 171969 | Plants | Plants | 53.9 | 1.59e-6 | NR | KAJ8447308.1 | 171969 | g8575 | i0 | 53.7 | 7.11176470588235 | 41 | 19 | 72.4 | 0 | 127 | 5 | 1646 | 1686 | KAJ8447308.1 hypothetical protein Cgig2_013085 [Carnegiea gigantea] | diamond | 1209 | 53.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Cactaceae | Carnegiea | Carnegiea gigantea |
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);;