contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJEB50765" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2669618 | 2669618 | PRJEB50765_P_NODE_1603_length_236_cov_1.366834_g1579_i0 | PRJEB50765 | 1603 | 236 | 1.366834 | 3.22572824 | Sphagnum jensenii | 128206 | Plants | Plants | 118 | 6.66e-31 | NR | CAK9251874.1 | 128206 | g1579 | i0 | 73.1 | 0.991525423728814 | 78 | 21 | 99.2 | 0 | 2 | 235 | 120 | 197 | CAK9251874.1 unnamed protein product [Sphagnum jensenii] | diamond | 234 | 118 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum jensenii | |
| 6497788 | 6497788 | PRJEB50765_P_NODE_1286_length_271_cov_2.149573_g1262_i0 | PRJEB50765 | 1286 | 271 | 2.149573 | 5.82534283 | Eukaryota | 2759 | Plants | Plants | 116 | 3.91e-31 | NR | CAM6005785.1 | 128184 | g1262 | i0 | 74.7 | 1.69372693726937 | 75 | 19 | 83 | 0 | 225 | 1 | 8 | 82 | CAM6005785.1 unnamed protein product [Sphagnum balticum] | diamond | 459 | 116 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 15019159 | 15019159 | PRJEB50765_P_NODE_772_length_380_cov_3.766764_g748_i0 | PRJEB50765 | 772 | 380 | 3.766764 | 14.3137032 | Eukaryota | 2759 | Plants | Plants | 147 | 4.89e-41 | NR | KAJ3679406.1 | 13579 | g748 | i0 | 65 | 8.7 | 123 | 43 | 97.1 | 0 | 369 | 1 | 119 | 241 | KAJ3679406.1 hypothetical protein LUZ60_017417 [Juncus effusus] | diamond | 3306 | 147 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus | |
| 17971101 | 17971101 | PRJEB50765_P_NODE_1135_length_294_cov_2.533074_g1111_i0 | PRJEB50765 | 1135 | 294 | 2.533074 | 7.44723756 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 166 | 1.8099999999999994e-48 | NR | BAK02263.1 | 112509 | g1111 | i0 | 89.2 | 0.948979591836735 | 93 | 10 | 94.9 | 0 | 16 | 294 | 1 | 93 | BAK02263.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 279 | 166 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 20520442 | 20520442 | PRJEB50765_P_NODE_1197_length_284_cov_1.615385_g1173_i0 | PRJEB50765 | 1197 | 284 | 1.615385 | 4.5876934 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 138 | 2.629999999999999e-38 | NR | XP_005643653.1 | 574566 | g1173 | i0 | 69.1 | 19.8380281690141 | 94 | 29 | 99.3 | 0 | 2 | 283 | 106 | 199 | XP_005643653.1 60S ribosomal protein L7 [Coccomyxa subellipsoidea C-169] | diamond | 5634 | 138 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 23071564 | 23071564 | PRJEB50765_P_NODE_2159_length_194_cov_1.961783_g2135_i0 | PRJEB50765 | 2159 | 194 | 1.961783 | 3.80585902 | Eukaryota | 2759 | Plants | Plants | 92.4 | 6.180000000000001e-21 | NR | KAI9201765.1 | 4023 | g2135 | i0 | 63.5 | 10.3298969072165 | 63 | 23 | 97.4 | 0 | 6 | 194 | 103 | 165 | KAI9201765.1 hypothetical protein LWI28_028910 [Acer negundo] | diamond | 2004 | 93.2 | 0.991416309012876 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer negundo | |
| 24345420 | 24345420 | PRJEB50765_P_NODE_2620_length_173_cov_1.022059_g2596_i0 | PRJEB50765 | 2620 | 173 | 1.022059 | 1.76816207 | Oryza sativa Japonica Group | 39947 | Plants | Plants | 95.1 | 8.69e-22 | NR | QDX19557.1 | 39947 | g2596 | i0 | 78.9 | 0.988439306358382 | 57 | 12 | 98.8 | 0 | 3 | 173 | 240 | 296 | QDX19557.1 hypothetical protein [Oryza sativa Japonica Group] | diamond | 171 | 95.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 25217450 | 25217450 | PRJEB50765_P_NODE_300_length_608_cov_2.306480_g282_i0 | PRJEB50765 | 300 | 608 | 2.30648 | 14.0233984 | Sphagnum balticum | 128184 | Plants | Plants | 229 | 5.0699999999999986e-74 | NR | CAM6001409.1 | 128184 | g282 | i0 | 83.8 | 0.641447368421053 | 130 | 21 | 64.1 | 0 | 494 | 105 | 1 | 130 | CAM6001409.1 unnamed protein product [Sphagnum balticum] | diamond | 390 | 229 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 26716601 | 26716601 | PRJEB50765_P_NODE_2861_length_164_cov_1.141732_g2837_i0 | PRJEB50765 | 2861 | 164 | 1.141732 | 1.87244048 | Sphagnum balticum | 128184 | Plants | Plants | 96.7 | 2.5899999999999994e-23 | NR | CAM6000560.1 | 128184 | g2837 | i0 | 81.5 | 0.98780487804878 | 54 | 10 | 98.8 | 0 | 2 | 163 | 85 | 138 | CAM6000560.1 unnamed protein product [Sphagnum balticum] | diamond | 162 | 96.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 27121324 | 27121324 | PRJEB50765_P_NODE_1662_length_230_cov_1.383420_g1638_i0 | PRJEB50765 | 1662 | 230 | 1.38342 | 3.181866 | Eukaryota | 2759 | Plants | Plants | 112 | 4.2e-27 | NR | KAG2409700.1 | 3914 | g1638 | i0 | 73 | 11.7 | 74 | 20 | 96.5 | 0 | 230 | 9 | 282 | 355 | KAG2409700.1 Ornithine aminotransferase [Vigna angularis] | diamond | 2691 | 113 | 0.991150442477876 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vigna | Vigna angularis | |
| 27184684 | 27184684 | PRJEB50765_P_NODE_1042_length_315_cov_2.338129_g1018_i0 | PRJEB50765 | 1042 | 315 | 2.338129 | 7.36510635 | root | 1 | Root_unresolved | Root_unresolved | 132 | 3.0599999999999995e-37 | NR | VVW86319.1 | 210225 | g1018 | i0 | 61.5 | 3.95238095238095 | 104 | 40 | 99 | 0 | 4 | 315 | 1 | 104 | VVW86319.1 unnamed protein product, partial [Nymphaea colorata] | diamond | 1245 | 132 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 27286382 | 27286382 | PRJEB50765_P_NODE_3303_length_151_cov_1.000000_g3279_i0 | PRJEB50765 | 3303 | 151 | 1 | 1.51 | Brachiaria hybrid cultivar | 680201 | Plants | Plants | 52 | 5.69e-6 | NR | ACX43954.1 | 680201 | g3279 | i0 | 52 | 0.993377483443709 | 50 | 24 | 99.3 | 0 | 151 | 2 | 39 | 88 | ACX43954.1 cysteine protease 1 [Brachiaria hybrid cultivar] | diamond | 150 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Brachiaria | Brachiaria hybrid cultivar | |
| 28107297 | 28107297 | PRJEB50765_P_NODE_1545_length_243_cov_1.315534_g1521_i0 | PRJEB50765 | 1545 | 243 | 1.315534 | 3.19674762 | Micromonas pusilla CCMP1545 | 564608 | Plants | Plants | 56.6 | 9.01e-8 | NR | XP_003059180.1 | 564608 | g1521 | i0 | 46.8 | 6.65432098765432 | 79 | 37 | 97.5 | 1 | 243 | 7 | 14 | 87 | XP_003059180.1 uncharacterized protein MICPUCDRAFT_49622 [Micromonas pusilla CCMP1545] | diamond | 1617 | 56.6 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 28296750 | 28296750 | PRJEB50765_P_NODE_2466_length_179_cov_1.880282_g2442_i0 | PRJEB50765 | 2466 | 179 | 1.880282 | 3.36570478 | Sphagnum balticum | 128184 | Plants | Plants | 85.5 | 5.88e-19 | NR | CAM6002231.1 | 128184 | g2442 | i0 | 73.6 | 0.888268156424581 | 53 | 14 | 88.8 | 0 | 175 | 17 | 42 | 94 | CAM6002231.1 unnamed protein product [Sphagnum balticum] | diamond | 159 | 85.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 28296751 | 28296751 | PRJEB50765_P_NODE_906_length_347_cov_1.470968_g882_i0 | PRJEB50765 | 906 | 347 | 1.470968 | 5.10425896 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 204 | 4.3e-63 | NR | BAK02263.1 | 112509 | g882 | i0 | 87 | 1.98847262247839 | 115 | 15 | 99.4 | 0 | 347 | 3 | 126 | 240 | BAK02263.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 690 | 204 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 28517982 | 28517982 | PRJEB50765_P_NODE_3207_length_153_cov_1.344828_g3183_i0 | PRJEB50765 | 3207 | 153 | 1.344828 | 2.05758684 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 91.3 | 1.34e-20 | NR | GAX80767.1 | 1157962 | g3183 | i0 | 80 | 1.96078431372549 | 50 | 10 | 98 | 0 | 3 | 152 | 156 | 205 | GAX80767.1 hypothetical protein CEUSTIGMA_g8202.t1 [Chlamydomonas eustigma] | diamond | 300 | 91.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 29149786 | 29149786 | PRJEB50765_P_NODE_2249_length_189_cov_1.684211_g2225_i0 | PRJEB50765 | 2249 | 189 | 1.684211 | 3.18315879 | Trebouxia sp. C | 2796353 | Plants | Plants | 64.7 | 1.6e-11 | NR | KAL0042167.1 | 2905653 | g2225 | i0 | 58.7 | 2.31746031746032 | 46 | 19 | 73 | 0 | 147 | 10 | 3 | 48 | KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004] | diamond | 438 | 64.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 29212713 | 29212713 | PRJEB50765_P_NODE_2389_length_183_cov_1.315068_g2365_i0 | PRJEB50765 | 2389 | 183 | 1.315068 | 2.40657444 | Oryza sativa Japonica Group | 39947 | Plants | Plants | 56.2 | 2.54e-7 | NR | QDX19557.1 | 39947 | g2365 | i0 | 54.7 | 0.868852459016393 | 53 | 24 | 86.9 | 0 | 182 | 24 | 23 | 75 | QDX19557.1 hypothetical protein [Oryza sativa Japonica Group] | diamond | 159 | 56.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 30318461 | 30318461 | PRJEB50765_P_NODE_1472_length_250_cov_1.812207_g1448_i0 | PRJEB50765 | 1472 | 250 | 1.812207 | 4.5305175 | Nymphaea colorata | 210225 | Plants | Plants | 82.4 | 1e-17 | NR | XP_031472781.1 | 210225 | g1448 | i0 | 51.9 | 7.524 | 81 | 35 | 92.4 | 1 | 231 | 1 | 26 | 106 | XP_031472781.1 LOW QUALITY PROTEIN: uncharacterized protein LOC116245286 [Nymphaea colorata] | diamond | 1881 | 82.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 30437834 | 30437834 | PRJEB50765_P_NODE_2333_length_185_cov_2.074324_g2309_i0 | PRJEB50765 | 2333 | 185 | 2.074324 | 3.8374994 | Eukaryota | 2759 | Plants | Plants | 67.4 | 5.12e-12 | NR | GMD54577.1 | 4120 | g2309 | i0 | 69.2 | 8.15675675675676 | 52 | 16 | 84.3 | 0 | 156 | 1 | 50 | 101 | GMD54577.1 60S ribosomal protein L35 [Ipomoea batatas] | diamond | 1509 | 67.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea batatas | |
| 30500762 | 30500762 | PRJEB50765_P_NODE_3013_length_159_cov_0.950820_g2989_i0 | PRJEB50765 | 3013 | 159 | 0.95082 | 1.5118038 | Eukaryota | 2759 | Plants | Plants | 73.2 | 2.25e-13 | NR | PRW45431.1 | 3076 | g2989 | i0 | 62.7 | 12.7547169811321 | 51 | 19 | 96.2 | 0 | 153 | 1 | 34 | 84 | PRW45431.1 proliferating cell nuclear antigen [Chlorella sorokiniana] | diamond | 2028 | 73.9 | 0.990527740189445 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30570407 | 30570407 | PRJEB50765_P_NODE_1173_length_288_cov_1.597610_g1149_i0 | PRJEB50765 | 1173 | 288 | 1.59761 | 4.6011168 | Chlorella sorokiniana | 3076 | Plants | Plants | 82 | 4.6e-17 | NR | PRW57226.1 | 3076 | g1149 | i0 | 51.3 | 11.0208333333333 | 78 | 38 | 81.3 | 0 | 2 | 235 | 52 | 129 | PRW57226.1 60S ribosomal L18a-2 [Chlorella sorokiniana] | diamond | 3174 | 82 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30690228 | 30690228 | PRJEB50765_P_NODE_2793_length_166_cov_1.209302_g2769_i0 | PRJEB50765 | 2793 | 166 | 1.209302 | 2.00744132 | Magnoliopsida | 3398 | Plants | Plants | 61.6 | 1.84e-10 | NR | NP_001334101.1 | 4081 | g2769 | i0 | 81.3 | 2.96385542168675 | 32 | 6 | 57.8 | 0 | 152 | 57 | 75 | 106 | NP_001334101.1 ribosomal protein L7Ae/L30e/S12e/Gadd45 family protein [Solanum lycopersicum] | diamond | 492 | 61.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 31329068 | 31329068 | PRJEB50765_P_NODE_2996_length_159_cov_1.581967_g2972_i0 | PRJEB50765 | 2996 | 159 | 1.581967 | 2.51532753 | Sphagnum balticum | 128184 | Plants | Plants | 90.5 | 1.1200000000000002e-21 | NR | CAM6001409.1 | 128184 | g2972 | i0 | 82.7 | 0.981132075471698 | 52 | 9 | 98.1 | 0 | 157 | 2 | 31 | 82 | CAM6001409.1 unnamed protein product [Sphagnum balticum] | diamond | 156 | 90.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 32240011 | 32240011 | PRJEB50765_P_NODE_2498_length_178_cov_1.092199_g2474_i0 | PRJEB50765 | 2498 | 178 | 1.092199 | 1.94411422 | Eukaryota | 2759 | Plants | Plants | 54.7 | 4.04e-7 | NR | RAL46610.1 | 267555 | g2474 | i0 | 60.9 | 5.32584269662921 | 46 | 18 | 77.5 | 0 | 1 | 138 | 131 | 176 | RAL46610.1 hypothetical protein DM860_004889 [Cuscuta australis] | diamond | 948 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Cuscuta | Cuscuta australis | |
| 32877747 | 32877747 | PRJEB50765_P_NODE_2780_length_166_cov_2.395349_g2756_i0 | PRJEB50765 | 2780 | 166 | 2.395349 | 3.97627934 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 41.2 | 0.0446 | NR | KAL4517980.1 | 1650286 | g2756 | i0 | 48.7 | 0.704819277108434 | 39 | 20 | 70.5 | 0 | 7 | 123 | 121 | 159 | KAL4517980.1 hypothetical protein Ndes2526A_g02346 [Chlorella desiccata (nom. nud.)] | diamond | 117 | 41.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' |
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);;