contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA1065838" and tax_clade = "Embryophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5282791 | 5282791 | PRJNA1065838_S_NODE_15485_length_216_cov_1.245509_g15383_i0 | PRJNA1065838 | 15485 | 216 | 1.245509 | 2.69029944 | Nymphaea colorata | 210225 | Plants | Plants | 143 | 5.19e-41 | NR | XP_031472889.1 | 210225 | g15383 | i0 | 97.2 | 0.986111111111111 | 71 | 2 | 98.6 | 0 | 215 | 3 | 12 | 82 | XP_031472889.1 uncharacterized protein LOC116245542 [Nymphaea colorata] | diamond | 213 | 143 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 16314849 | 16314849 | PRJNA1065838_S_NODE_25033_length_188_cov_1.122302_g24931_i0 | PRJNA1065838 | 25033 | 188 | 1.122302 | 2.10992776 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 68.6 | 1.37e-11 | NR | BAJ98423.1 | 112509 | g24931 | i0 | 53.3 | 0.957446808510638 | 60 | 26 | 95.7 | 1 | 1 | 180 | 162 | 219 | BAJ98423.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 180 | 68.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 19305796 | 19305796 | PRJNA1065838_S_NODE_35096_length_164_cov_0.886957_g34994_i0 | PRJNA1065838 | 35096 | 164 | 0.886957 | 1.45460948 | Triticum aestivum | 4565 | Plants | Plants | 103 | 4.709999999999999e-24 | NR | SPT20292.1 | 4565 | g34994 | i0 | 90.7 | 1.97560975609756 | 54 | 5 | 98.8 | 0 | 3 | 164 | 271 | 324 | SPT20292.1 unnamed protein product [Triticum aestivum] | diamond | 324 | 103 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 26655356 | 26655356 | PRJNA1065838_S_NODE_26601_length_183_cov_0.970149_g26499_i0 | PRJNA1065838 | 26601 | 183 | 0.970149 | 1.77537267 | Nymphaea colorata | 210225 | Plants | Plants | 66.2 | 2.57e-12 | NR | VVW88554.1 | 210225 | g26499 | i0 | 100 | 0.475409836065574 | 29 | 0 | 47.5 | 0 | 181 | 95 | 51 | 79 | VVW88554.1 unnamed protein product [Nymphaea colorata] | diamond | 87 | 66.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 26687234 | 26687234 | PRJNA1065838_S_NODE_34401_length_165_cov_0.879310_g34299_i0 | PRJNA1065838 | 34401 | 165 | 0.87931 | 1.4508615 | Triticum aestivum | 4565 | Plants | Plants | 58.9 | 2.35e-8 | NR | KAF7043331.1 | 4565 | g34299 | i0 | 63.4 | 0.745454545454545 | 41 | 15 | 74.5 | 0 | 128 | 6 | 266 | 306 | KAF7043331.1 hypothetical protein CFC21_052705 [Triticum aestivum] | diamond | 123 | 58.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 26750222 | 26750222 | PRJNA1065838_S_NODE_34941_length_164_cov_0.904348_g34839_i0 | PRJNA1065838 | 34941 | 164 | 0.904348 | 1.48313072 | Nymphaea colorata | 210225 | Plants | Plants | 50.1 | 4.58e-6 | NR | VVW88554.1 | 210225 | g34839 | i0 | 78.6 | 0.51219512195122 | 28 | 6 | 51.2 | 0 | 85 | 2 | 1 | 28 | VVW88554.1 unnamed protein product [Nymphaea colorata] | diamond | 84 | 50.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 27856736 | 27856736 | PRJNA1065838_S_NODE_4545_length_339_cov_1.603448_g4443_i0 | PRJNA1065838 | 4545 | 339 | 1.603448 | 5.43568872 | Nymphaea colorata | 210225 | Plants | Plants | 171 | 3.61e-52 | NR | XP_031472563.1 | 210225 | g4443 | i0 | 79.8 | 0.964601769911504 | 109 | 21 | 95.6 | 1 | 325 | 2 | 1 | 109 | XP_031472563.1 uncharacterized protein LOC116244889 [Nymphaea colorata] | diamond | 327 | 171 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 28038098 | 28038098 | PRJNA1065838_S_NODE_24765_length_189_cov_0.814286_g24663_i0 | PRJNA1065838 | 24765 | 189 | 0.814286 | 1.53900054 | Magnoliopsida | 3398 | Plants | Plants | 94.7 | 1.7000000000000002e-22 | NR | XP_016513555.1 | 4097 | g24663 | i0 | 67.7 | 25.4603174603175 | 62 | 20 | 98.4 | 0 | 3 | 188 | 98 | 159 | XP_016513555.1 RNA-directed DNA polymerase homolog [Nicotiana tabacum] | diamond | 4812 | 95.5 | 0.991623036649215 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Nicotiana | Nicotiana tabacum | |
| 28519992 | 28519992 | PRJNA1065838_S_NODE_33307_length_166_cov_1.777778_g33205_i0 | PRJNA1065838 | 33307 | 166 | 1.777778 | 2.95111148 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 58.5 | 3.52e-8 | NR | BAK00514.1 | 112509 | g33205 | i0 | 52.7 | 0.993975903614458 | 55 | 24 | 99.4 | 1 | 165 | 1 | 62 | 114 | BAK00514.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 165 | 58.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 28551615 | 28551615 | PRJNA1065838_S_NODE_25627_length_186_cov_1.270073_g25525_i0 | PRJNA1065838 | 25627 | 186 | 1.270073 | 2.36233578 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 54.3 | 1.43e-6 | NR | BAJ95050.1 | 112509 | g25525 | i0 | 66.7 | 0.532258064516129 | 33 | 11 | 53.2 | 0 | 87 | 185 | 613 | 645 | BAJ95050.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 99 | 54.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 28583178 | 28583178 | PRJNA1065838_S_NODE_18767_length_206_cov_0.993631_g18665_i0 | PRJNA1065838 | 18767 | 206 | 0.993631 | 2.04687986 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 96.3 | 3.15e-21 | NR | BAK00514.1 | 112509 | g18665 | i0 | 76.3 | 0.859223300970874 | 59 | 14 | 85.9 | 0 | 3 | 179 | 542 | 600 | BAK00514.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 177 | 96.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 28890374 | 28890374 | PRJNA1065838_S_NODE_27928_length_179_cov_0.838462_g27826_i0 | PRJNA1065838 | 27928 | 179 | 0.838462 | 1.50084698 | Magnoliopsida | 3398 | Plants | Plants | 50.8 | 2.2e-5 | NR | XP_020257167.1 | 4686 | g27826 | i0 | 43.4 | 5.04469273743017 | 53 | 30 | 88.8 | 0 | 175 | 17 | 124 | 176 | XP_020257167.1 uncharacterized protein LOC109833769 [Asparagus officinalis] | diamond | 903 | 50.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Asparagaceae | Asparagus | Asparagus officinalis | |
| 29174844 | 29174844 | PRJNA1065838_S_NODE_1009_length_588_cov_4.656772_g909_i0 | PRJNA1065838 | 1009 | 588 | 4.656772 | 27.38181936 | root | 1 | Root_unresolved | Root_unresolved | 134 | 3.1299999999999997e-37 | NR | VVW92858.1 | 210225 | g909 | i0 | 88.4 | 6.05612244897959 | 69 | 8 | 35.2 | 0 | 347 | 553 | 4 | 72 | VVW92858.1 unnamed protein product, partial [Nymphaea colorata] | diamond | 3561 | 135 | 0.992592592592593 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 29466757 | 29466757 | PRJNA1065838_S_NODE_35750_length_163_cov_0.894737_g35648_i0 | PRJNA1065838 | 35750 | 163 | 0.894737 | 1.45842131 | Triticum aestivum | 4565 | Plants | Plants | 75.5 | 1.04e-14 | NR | XBI58118.1 | 4565 | g35648 | i0 | 89.2 | 0.680981595092024 | 37 | 4 | 68.1 | 0 | 112 | 2 | 1 | 37 | XBI58118.1 hypothetical protein VPH35_039393 [Triticum aestivum] | diamond | 111 | 75.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 29624476 | 29624476 | PRJNA1065838_S_NODE_36430_length_162_cov_0.902655_g36328_i0 | PRJNA1065838 | 36430 | 162 | 0.902655 | 1.4623011 | Aegilops tauschii subsp. strangulata | 200361 | Plants | Plants | 52.8 | 3.51e-6 | NR | XP_020181403.1 | 200361 | g36328 | i0 | 49.1 | 0.981481481481482 | 53 | 27 | 98.1 | 0 | 3 | 161 | 249 | 301 | XP_020181403.1 wiskott-Aldrich syndrome protein homolog 1-like [Aegilops tauschii subsp. strangulata] | diamond | 159 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops tauschii | |
| 29814314 | 29814314 | PRJNA1065838_S_NODE_36091_length_162_cov_1.371681_g35989_i0 | PRJNA1065838 | 36091 | 162 | 1.371681 | 2.22212322 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 43.1 | 0.00902 | NR | BAK00514.1 | 112509 | g35989 | i0 | 95.5 | 0.407407407407407 | 22 | 1 | 40.7 | 0 | 8 | 73 | 319 | 340 | BAK00514.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 66 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 30415015 | 30415015 | PRJNA1065838_S_NODE_27193_length_181_cov_1.219697_g27091_i0 | PRJNA1065838 | 27193 | 181 | 1.219697 | 2.20765157 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 55.8 | 3.89e-7 | NR | BAK00514.1 | 112509 | g27091 | i0 | 48.1 | 0.861878453038674 | 52 | 25 | 82.9 | 2 | 31 | 180 | 1 | 52 | BAK00514.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 156 | 55.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 30477979 | 30477979 | PRJNA1065838_S_NODE_25633_length_186_cov_1.233577_g25531_i0 | PRJNA1065838 | 25633 | 186 | 1.233577 | 2.29445322 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 115 | 2.59e-29 | NR | BAJ99744.1 | 112509 | g25531 | i0 | 96.7 | 0.983870967741935 | 61 | 2 | 98.4 | 0 | 2 | 184 | 39 | 99 | BAJ99744.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 183 | 115 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 30604153 | 30604153 | PRJNA1065838_S_NODE_13033_length_226_cov_1.175141_g12931_i0 | PRJNA1065838 | 13033 | 226 | 1.175141 | 2.65581866 | Nymphaea colorata | 210225 | Plants | Plants | 92.8 | 9.9e-22 | NR | XP_031472563.1 | 210225 | g12931 | i0 | 69.1 | 0.902654867256637 | 68 | 21 | 90.3 | 0 | 226 | 23 | 102 | 169 | XP_031472563.1 uncharacterized protein LOC116244889 [Nymphaea colorata] | diamond | 204 | 92.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 30793744 | 30793744 | PRJNA1065838_S_NODE_34994_length_164_cov_0.904348_g34892_i0 | PRJNA1065838 | 34994 | 164 | 0.904348 | 1.48313072 | Nymphaea colorata | 210225 | Plants | Plants | 55.1 | 4.48e-7 | NR | VVW86390.1 | 210225 | g34892 | i0 | 46 | 0.914634146341463 | 50 | 27 | 91.5 | 0 | 159 | 10 | 183 | 232 | VVW86390.1 unnamed protein product, partial [Nymphaea colorata] | diamond | 150 | 55.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 30888634 | 30888634 | PRJNA1065838_S_NODE_12614_length_228_cov_1.452514_g12512_i0 | PRJNA1065838 | 12614 | 228 | 1.452514 | 3.31173192 | Nymphaea colorata | 210225 | Plants | Plants | 140 | 7.34e-39 | NR | XP_031472561.1 | 210225 | g12512 | i0 | 82.9 | 1 | 76 | 13 | 100 | 0 | 228 | 1 | 154 | 229 | XP_031472561.1 uncharacterized protein LOC116244886 [Nymphaea colorata] | diamond | 228 | 140 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 31204093 | 31204093 | PRJNA1065838_S_NODE_22235_length_195_cov_7.554795_g22133_i0 | PRJNA1065838 | 22235 | 195 | 7.554795 | 14.73185025 | Helianthus annuus | 4232 | Plants | Plants | 42 | 0.00856 | NR | KAJ0524210.1 | 4232 | g22133 | i0 | 32.8 | 0.984615384615385 | 64 | 41 | 95.4 | 1 | 3 | 188 | 10 | 73 | KAJ0524210.1 hypothetical protein HanIR_Chr10g0502051 [Helianthus annuus] | diamond | 192 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Helianthus | Helianthus annuus | |
| 31236064 | 31236064 | PRJNA1065838_S_NODE_20235_length_201_cov_1.907895_g20133_i0 | PRJNA1065838 | 20235 | 201 | 1.907895 | 3.83486895 | Nymphaea colorata | 210225 | Plants | Plants | 114 | 3.3199999999999996e-31 | NR | VVW87047.1 | 210225 | g20133 | i0 | 89.4 | 0.985074626865672 | 66 | 7 | 98.5 | 0 | 200 | 3 | 23 | 88 | VVW87047.1 unnamed protein product, partial [Nymphaea colorata] | diamond | 198 | 114 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 31670679 | 31670679 | PRJNA1065838_S_NODE_34417_length_165_cov_0.879310_g34315_i0 | PRJNA1065838 | 34417 | 165 | 0.87931 | 1.4508615 | Magnoliopsida | 3398 | Plants | Plants | 59.3 | 5.77e-9 | NR | XP_068463563.1 | 3885 | g34315 | i0 | 63.8 | 6 | 47 | 16 | 83.6 | 1 | 140 | 3 | 83 | 129 | XP_068463563.1 uncharacterized protein [Phaseolus vulgaris] | diamond | 990 | 59.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Phaseolus | Phaseolus vulgaris | |
| 32343661 | 32343661 | PRJNA1065838_S_NODE_7519_length_276_cov_1.616740_g7417_i0 | PRJNA1065838 | 7519 | 276 | 1.61674 | 4.4622024 | Sphagnum balticum | 128184 | Plants | Plants | 81.6 | 4.97e-18 | NR | CAM5998936.1 | 128184 | g7417 | i0 | 50.6 | 0.923913043478261 | 85 | 37 | 92.4 | 1 | 273 | 19 | 1 | 80 | CAM5998936.1 unnamed protein product, partial [Sphagnum balticum] | diamond | 255 | 81.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 32438574 | 32438574 | PRJNA1065838_S_NODE_4079_length_355_cov_1.741830_g3977_i0 | PRJNA1065838 | 4079 | 355 | 1.74183 | 6.1834965 | Sphagnum balticum | 128184 | Plants | Plants | 155 | 3.03e-46 | NR | CAM6000740.1 | 128184 | g3977 | i0 | 68.5 | 0.938028169014084 | 111 | 34 | 93 | 1 | 1 | 330 | 17 | 127 | CAM6000740.1 unnamed protein product [Sphagnum balticum] | diamond | 333 | 155 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 32722376 | 32722376 | PRJNA1065838_S_NODE_29540_length_174_cov_1.408000_g29438_i0 | PRJNA1065838 | 29540 | 174 | 1.408 | 2.44992 | Nymphaea colorata | 210225 | Plants | Plants | 60.5 | 8.36e-9 | NR | VVW88752.1 | 210225 | g29438 | i0 | 62.1 | 2 | 58 | 12 | 82.8 | 2 | 1 | 144 | 464 | 521 | VVW88752.1 unnamed protein product, partial [Nymphaea colorata] | diamond | 348 | 60.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata |
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);;