contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA807685" and tax_phylum = "Streptophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8459468 | 8459468 | PRJNA807685_P_NODE_22427_length_288_cov_1.442231_g21354_i0 | PRJNA807685 | 22427 | 288 | 1.442231 | 4.15362528 | Populus nigra | 3691 | Plants | Plants | 75.9 | 1.44e-13 | NR | XP_061971828.1 | 3691 | g21354 | i0 | 81.6 | 5.98958333333333 | 38 | 7 | 39.6 | 0 | 270 | 157 | 360 | 397 | XP_061971828.1 uncharacterized protein LOC133694346 [Populus nigra] | diamond | 1725 | 75.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus nigra | |
| 8459623 | 8459623 | PRJNA807685_P_NODE_41467_length_190_cov_2.490196_g40394_i0 | PRJNA807685 | 41467 | 190 | 2.490196 | 4.7313724 | Eukaryota | 2759 | Plants | Plants | 76.3 | 2.54e-14 | NR | VFQ72151.1 | 132261 | g40394 | i0 | 54.1 | 13.5789473684211 | 61 | 28 | 96.3 | 0 | 188 | 6 | 376 | 436 | VFQ72151.1 unnamed protein product [Cuscuta campestris] | diamond | 2580 | 77 | 0.990909090909091 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Cuscuta | Cuscuta campestris | |
| 9734656 | 9734656 | PRJNA807685_P_NODE_44728_length_183_cov_1.246575_g43655_i0 | PRJNA807685 | 44728 | 183 | 1.246575 | 2.28123225 | Acer saccharum | 4024 | Plants | Plants | 70.1 | 2.05e-12 | NR | KAK0584804.1 | 4024 | g43655 | i0 | 53.3 | 0.983606557377049 | 60 | 28 | 98.4 | 0 | 181 | 2 | 165 | 224 | KAK0584804.1 hypothetical protein LWI29_018907 [Acer saccharum] | diamond | 180 | 70.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer saccharum | |
| 26642543 | 26642543 | PRJNA807685_P_NODE_67741_length_150_cov_1.619469_g66668_i0 | PRJNA807685 | 67741 | 150 | 1.619469 | 2.4292035 | Spatholobus suberectus | 455371 | Plants | Plants | 42.4 | 0.0142 | NR | TKY67763.1 | 455371 | g66668 | i0 | 41.3 | 9.2 | 46 | 27 | 92 | 0 | 12 | 149 | 194 | 239 | TKY67763.1 Lysine-specific demethylase JMJ706 [Spatholobus suberectus] | diamond | 1380 | 42.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Spatholobus | Spatholobus suberectus | |
| 26873494 | 26873494 | PRJNA807685_P_NODE_36601_length_205_cov_1.511905_g35528_i0 | PRJNA807685 | 36601 | 205 | 1.511905 | 3.09940525 | Magnoliopsida | 3398 | Plants | Plants | 89.7 | 1.6e-19 | NR | KAJ7961990.1 | 32244 | g35528 | i0 | 57.4 | 14.9268292682927 | 68 | 29 | 99.5 | 0 | 1 | 204 | 184 | 251 | KAJ7961990.1 Transposon Ty3-I Gag-Pol polyprotein [Quillaja saponaria] | diamond | 3060 | 89.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Quillajaceae | Quillaja | Quillaja saponaria | |
| 27347694 | 27347694 | PRJNA807685_P_NODE_33123_length_219_cov_1.175824_g32050_i0 | PRJNA807685 | 33123 | 219 | 1.175824 | 2.57505456 | Castanea | 21019 | Plants | Plants | 105 | 1.5999999999999999e-24 | NR | KAF3946560.1 | 60419 | g32050 | i0 | 70 | 2.87671232876712 | 70 | 21 | 95.9 | 0 | 215 | 6 | 273 | 342 | KAF3946560.1 hypothetical protein CMV_027186 [Castanea mollissima] | diamond | 630 | 105 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Castanea | Castanea mollissima | |
| 27906771 | 27906771 | PRJNA807685_P_NODE_50485_length_172_cov_1.140741_g49412_i0 | PRJNA807685 | 50485 | 172 | 1.140741 | 1.96207452 | Erythranthe guttata | 4155 | Plants | Plants | 43.1 | 0.0107 | NR | EYU22869.1 | 4155 | g49412 | i0 | 39.7 | 1.01162790697674 | 58 | 32 | 95.9 | 2 | 8 | 172 | 213 | 270 | EYU22869.1 hypothetical protein MIMGU_mgv1a005206mg [Erythranthe guttata] | diamond | 174 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Phrymaceae | Erythranthe | Erythranthe guttata | |
| 28001913 | 28001913 | PRJNA807685_P_NODE_9285_length_565_cov_2.662879_g8273_i0 | PRJNA807685 | 9285 | 565 | 2.662879 | 15.04526635 | Paulownia fortunei | 586722 | Plants | Plants | 111 | 4.0400000000000005e-27 | NR | KAI3451139.1 | 586722 | g8273 | i0 | 40.8 | 2.50088495575221 | 157 | 88 | 81.2 | 3 | 562 | 104 | 1 | 156 | KAI3451139.1 hypothetical protein Pfo_007804 [Paulownia fortunei] | diamond | 1413 | 111 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Paulowniaceae | Paulownia | Paulownia fortunei | |
| 28159832 | 28159832 | PRJNA807685_P_NODE_49725_length_173_cov_1.558824_g48652_i0 | PRJNA807685 | 49725 | 173 | 1.558824 | 2.69676552 | Rhynchospora tenuis | 198213 | Plants | Plants | 62 | 2.32e-9 | NR | KAJ3684022.1 | 198213 | g48652 | i0 | 46.4 | 0.971098265895954 | 56 | 30 | 97.1 | 0 | 173 | 6 | 1099 | 1154 | KAJ3684022.1 hypothetical protein LUZ61_013186 [Rhynchospora tenuis] | diamond | 168 | 62 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Cyperaceae | Rhynchospora | Rhynchospora tenuis | |
| 28317503 | 28317503 | PRJNA807685_P_NODE_60486_length_158_cov_1.190083_g59413_i0 | PRJNA807685 | 60486 | 158 | 1.190083 | 1.88033114 | Oryza sativa Japonica Group | 39947 | Plants | Plants | 41.6 | 0.0226 | NR | KAF2919713.1 | 39947 | g59413 | i0 | 52.7 | 1.04430379746835 | 55 | 16 | 85.4 | 3 | 149 | 15 | 111 | 165 | KAF2919713.1 hypothetical protein DAI22_08g156300 [Oryza sativa Japonica Group] | diamond | 165 | 41.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 28412289 | 28412289 | PRJNA807685_P_NODE_30826_length_230_cov_1.145078_g29753_i0 | PRJNA807685 | 30826 | 230 | 1.145078 | 2.6336794 | Klebsormidium nitens | 105231 | Plants | Plants | 53.9 | 3.68e-6 | NR | GAQ90479.1 | 105231 | g29753 | i0 | 72.4 | 1.16086956521739 | 29 | 8 | 37.8 | 0 | 228 | 142 | 939 | 967 | GAQ90479.1 KRAB-A domain-containing protein [Klebsormidium nitens] | diamond | 267 | 53.9 | 1 | Eukaryota | Viridiplantae | Streptophyta | Klebsormidiophyceae | Klebsormidiales | Klebsormidiaceae | Klebsormidium | Klebsormidium nitens | ||
| 28507004 | 28507004 | PRJNA807685_P_NODE_63507_length_154_cov_2.000000_g62434_i0 | PRJNA807685 | 63507 | 154 | 2 | 3.08 | Hevea brasiliensis | 3981 | Plants | Plants | 62.4 | 1.3e-9 | NR | XP_021668849.2 | 3981 | g62434 | i0 | 56.9 | 0.993506493506494 | 51 | 21 | 99.4 | 1 | 154 | 2 | 192 | 241 | XP_021668849.2 receptor-like protein kinase FERONIA [Hevea brasiliensis] | diamond | 153 | 62.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Euphorbiaceae | Hevea | Hevea brasiliensis | |
| 28538716 | 28538716 | PRJNA807685_P_NODE_50607_length_171_cov_4.320896_g49534_i0 | PRJNA807685 | 50607 | 171 | 4.320896 | 7.38873216 | Trifolium medium | 97028 | Plants | Plants | 39.7 | 0.0361 | NR | MCI16130.1 | 97028 | g49534 | i0 | 38.1 | 0.736842105263158 | 42 | 18 | 61.4 | 2 | 49 | 153 | 12 | 52 | MCI16130.1 hypothetical protein [Trifolium medium] | diamond | 126 | 39.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Trifolium | Trifolium medium | |
| 28790964 | 28790964 | PRJNA807685_P_NODE_58367_length_160_cov_1.878049_g57294_i0 | PRJNA807685 | 58367 | 160 | 1.878049 | 3.0048784 | Drosera rotundifolia | 173423 | Plants | Plants | 42 | 0.022 | NR | GAB2251199.1 | 173423 | g57294 | i0 | 38.5 | 1.9875 | 39 | 24 | 73.1 | 0 | 131 | 15 | 382 | 420 | GAB2251199.1 hypothetical protein Droror1_Dr00017449 [Drosera rotundifolia] | diamond | 318 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Droseraceae | Drosera | Drosera rotundifolia | |
| 29012448 | 29012448 | PRJNA807685_P_NODE_53328_length_167_cov_1.630769_g52255_i0 | PRJNA807685 | 53328 | 167 | 1.630769 | 2.72338423 | Beta vulgaris subsp. vulgaris | 3555 | Plants | Plants | 50.1 | 3.12e-5 | NR | KMT09618.1 | 3555 | g52255 | i0 | 46 | 1.86826347305389 | 50 | 24 | 89.8 | 1 | 162 | 13 | 122 | 168 | KMT09618.1 hypothetical protein BVRB_6g130710 [Beta vulgaris subsp. vulgaris] | diamond | 312 | 50.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Beta | Beta vulgaris | |
| 29201689 | 29201689 | PRJNA807685_P_NODE_22589_length_286_cov_2.714859_g21516_i0 | PRJNA807685 | 22589 | 286 | 2.714859 | 7.76449674 | Gossypium anomalum | 47600 | Plants | Plants | 99 | 9.07e-22 | NR | KAG8502441.1 | 47600 | g21516 | i0 | 52.6 | 3.98601398601399 | 95 | 45 | 99.7 | 0 | 285 | 1 | 159 | 253 | KAG8502441.1 hypothetical protein CXB51_000404 [Gossypium anomalum] | diamond | 1140 | 99 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium anomalum | |
| 29336751 | 29336751 | PRJNA807685_P_NODE_52209_length_169_cov_1.181818_g51136_i0 | PRJNA807685 | 52209 | 169 | 1.181818 | 1.99727242 | Eukaryota | 2759 | Plants | Plants | 65.5 | 1.32e-10 | NR | XP_019188128.1 | 35883 | g51136 | i0 | 78.4 | 25.5443786982249 | 37 | 8 | 65.7 | 0 | 160 | 50 | 360 | 396 | XP_019188128.1 PREDICTED: glutathione synthetase, chloroplastic [Ipomoea nil] | diamond | 4317 | 65.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea nil | |
| 29706332 | 29706332 | PRJNA807685_P_NODE_62530_length_155_cov_2.288136_g61457_i0 | PRJNA807685 | 62530 | 155 | 2.288136 | 3.5466108 | Solanum tuberosum | 4113 | Plants | Plants | 47.4 | 2.56e-4 | NR | KAH0715561.1 | 4113 | g61457 | i0 | 58.1 | 1.2 | 31 | 13 | 60 | 0 | 95 | 3 | 2 | 32 | KAH0715561.1 hypothetical protein KY284_008466 [Solanum tuberosum] | diamond | 186 | 47.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum tuberosum | |
| 30591240 | 30591240 | PRJNA807685_P_NODE_13793_length_416_cov_2.050132_g12731_i0 | PRJNA807685 | 13793 | 416 | 2.050132 | 8.52854912 | Phtheirospermum japonicum | 374723 | Plants | Plants | 59.7 | 2.1e-8 | NR | GFP88009.1 | 374723 | g12731 | i0 | 37 | 1.96875 | 92 | 57 | 66.3 | 1 | 1 | 276 | 26 | 116 | GFP88009.1 hypothetical protein PHJA_000944600 [Phtheirospermum japonicum] | diamond | 819 | 59.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Orobanchaceae | Phtheirospermum | Phtheirospermum japonicum | |
| 30631612 | 30631612 | PRJNA807685_P_NODE_61853_length_156_cov_1.588235_g60780_i0 | PRJNA807685 | 61853 | 156 | 1.588235 | 2.4776466 | Magnoliopsida | 3398 | Plants | Plants | 65.1 | 1.46e-10 | NR | EOY22757.1 | 3641 | g60780 | i0 | 60.4 | 13.2307692307692 | 48 | 19 | 92.3 | 0 | 6 | 149 | 358 | 405 | EOY22757.1 Uncharacterized protein TCM_014834 [Theobroma cacao] | diamond | 2064 | 65.5 | 0.993893129770992 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Theobroma | Theobroma cacao | |
| 31002146 | 31002146 | PRJNA807685_P_NODE_47574_length_177_cov_1.400000_g46501_i0 | PRJNA807685 | 47574 | 177 | 1.4 | 2.478 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 44.7 | 0.00267 | NR | GEY87203.1 | 118510 | g46501 | i0 | 46.6 | 4.66101694915254 | 58 | 28 | 96.6 | 2 | 173 | 3 | 63 | 118 | GEY87203.1 retrotransposon protein, putative, Ty1-copia subclass [Tanacetum cinerariifolium] | diamond | 825 | 44.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 31286345 | 31286345 | PRJNA807685_P_NODE_59715_length_159_cov_0.959016_g58642_i0 | PRJNA807685 | 59715 | 159 | 0.959016 | 1.52483544 | Chara braunii | 69332 | Plants | Plants | 43.1 | 0.00873 | NR | GBG60263.1 | 69332 | g58642 | i0 | 40.4 | 0.886792452830189 | 47 | 28 | 88.7 | 0 | 11 | 151 | 2565 | 2611 | GBG60263.1 hypothetical protein CBR_g4216 [Chara braunii] | diamond | 141 | 43.1 | 1 | Eukaryota | Viridiplantae | Streptophyta | Charophyceae | Charales | Characeae | Chara | Chara braunii | ||
| 31991153 | 31991153 | PRJNA807685_P_NODE_29878_length_235_cov_1.560606_g28805_i0 | PRJNA807685 | 29878 | 235 | 1.560606 | 3.6674241 | Magnoliopsida | 3398 | Plants | Plants | 79.3 | 4.24e-15 | NR | XP_009360627.3 | 225117 | g28805 | i0 | 65.5 | 5.85957446808511 | 58 | 20 | 74 | 0 | 176 | 3 | 125 | 182 | XP_009360627.3 receptor-like protein kinase FERONIA [Pyrus x bretschneideri] | diamond | 1377 | 79.7 | 0.994981179422836 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Pyrus | Pyrus x bretschneideri | |
| 32149545 | 32149545 | PRJNA807685_P_NODE_46058_length_180_cov_1.405594_g44985_i0 | PRJNA807685 | 46058 | 180 | 1.405594 | 2.5300692 | root | 1 | Root_unresolved | Root_unresolved | 52 | 8.53e-6 | NR | CAK9856009.1 | 128206 | g44985 | i0 | 69.7 | 1.7 | 33 | 10 | 55 | 0 | 166 | 68 | 3 | 35 | CAK9856009.1 unnamed protein product, partial [Sphagnum jensenii] | diamond | 306 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum jensenii | |
| 32772279 | 32772279 | PRJNA807685_P_NODE_40740_length_192_cov_2.006452_g39667_i0 | PRJNA807685 | 40740 | 192 | 2.006452 | 3.85238784 | Saponaria officinalis | 3572 | Plants | Plants | 44.3 | 0.00487 | NR | KAK9669161.1 | 3572 | g39667 | i0 | 66.7 | 0.375 | 24 | 8 | 37.5 | 0 | 190 | 119 | 223 | 246 | KAK9669161.1 hypothetical protein RND81_13G112500 [Saponaria officinalis] | diamond | 72 | 44.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Caryophyllaceae | Saponaria | Saponaria officinalis |
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);;