contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA1073005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1461559 | 1461559 | PRJNA1073005_P_NODE_8442_length_268_cov_0.948718_g8323_i0 | PRJNA1073005 | 8442 | 268 | 0.948718 | 2.54256424 | Eukaryota | 2759 | Plants | Plants | 169 | 1.27e-48 | NR | CAM6002297.1 | 128184 | g8323 | i0 | 93.3 | 45.8283582089552 | 89 | 6 | 99.6 | 0 | 1 | 267 | 263 | 351 | CAM6002297.1 unnamed protein product [Sphagnum balticum] | diamond | 12282 | 170 | 0.994117647058824 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 11665632 | 11665632 | PRJNA1073005_P_NODE_5890_length_376_cov_1.273927_g5771_i0 | PRJNA1073005 | 5890 | 376 | 1.273927 | 4.78996552 | Eukaryota | 2759 | Plants | Plants | 145 | 6.76e-42 | NR | ABK21285.1 | 3332 | g5771 | i0 | 65.3 | 19.9787234042553 | 121 | 42 | 96.5 | 0 | 372 | 10 | 7 | 127 | ABK21285.1 unknown [Picea sitchensis] | diamond | 7512 | 145 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea sitchensis | |
| 18038676 | 18038676 | PRJNA1073005_P_NODE_3515_length_556_cov_1.434783_g3396_i0 | PRJNA1073005 | 3515 | 556 | 1.434783 | 7.97739348 | Eukaryota | 2759 | Plants | Plants | 244 | 3.99e-79 | NR | XP_024385696.1 | 3218 | g3396 | i0 | 74.6 | 115.160071942446 | 173 | 44 | 93.3 | 0 | 18 | 536 | 1 | 173 | XP_024385696.1 60S ribosomal protein L19-3-like [Physcomitrium patens] | diamond | 64029 | 246 | 0.991869918699187 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 26592313 | 26592313 | PRJNA1073005_P_NODE_7661_length_295_cov_1.734234_g7542_i0 | PRJNA1073005 | 7661 | 295 | 1.734234 | 5.1159903 | Nymphaea colorata | 210225 | Plants | Plants | 116 | 1.7699999999999996e-31 | NR | XP_031472904.1 | 210225 | g7542 | i0 | 57.6 | 0.935593220338983 | 92 | 39 | 93.6 | 0 | 280 | 5 | 8 | 99 | XP_031472904.1 uncharacterized protein LOC116245563 [Nymphaea colorata] | diamond | 276 | 116 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 26963832 | 26963832 | PRJNA1073005_P_NODE_8082_length_280_cov_1.280193_g7963_i0 | PRJNA1073005 | 8082 | 280 | 1.280193 | 3.5845404 | Eukaryota | 2759 | Plants | Plants | 166 | 4.9699999999999994e-48 | NR | MQL90264.1 | 4460 | g7963 | i0 | 84.9 | 172.35 | 93 | 14 | 99.6 | 0 | 279 | 1 | 69 | 161 | MQL90264.1 hypothetical protein [Colocasia esculenta] | diamond | 48258 | 166 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Colocasia | Colocasia esculenta | |
| 27193703 | 27193703 | PRJNA1073005_P_NODE_7022_length_322_cov_1.742972_g6903_i0 | PRJNA1073005 | 7022 | 322 | 1.742972 | 5.61236984 | Turnera subulata | 218843 | Plants | Plants | 43.5 | 0.0494 | NR | KAJ4849974.1 | 218843 | g6903 | i0 | 31.9 | 0.670807453416149 | 72 | 44 | 62.4 | 1 | 289 | 89 | 508 | 579 | KAJ4849974.1 hypothetical protein Tsubulata_004868 [Turnera subulata] | diamond | 216 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Passifloraceae | Turnera | Turnera subulata | |
| 27636198 | 27636198 | PRJNA1073005_P_NODE_6784_length_333_cov_3.850000_g6665_i0 | PRJNA1073005 | 6784 | 333 | 3.85 | 12.8205 | Salix dunnii | 1413687 | Plants | Plants | 218 | 1.9499999999999993e-68 | NR | KAF9670542.1 | 1413687 | g6665 | i0 | 91.8 | 0.990990990990991 | 110 | 9 | 99.1 | 0 | 332 | 3 | 122 | 231 | KAF9670542.1 hypothetical protein SADUNF_Sadunf13G0079900 [Salix dunnii] | diamond | 330 | 218 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix dunnii | |
| 27722729 | 27722729 | PRJNA1073005_P_NODE_6904_length_328_cov_1.207843_g6785_i0 | PRJNA1073005 | 6904 | 328 | 1.207843 | 3.96172504 | Eukaryota | 2759 | Plants | Plants | 154 | 2.86e-42 | NR | KAG5626052.1 | 4109 | g6785 | i0 | 72.5 | 22.875 | 109 | 30 | 99.7 | 0 | 327 | 1 | 277 | 385 | KAG5626052.1 hypothetical protein H5410_011270, partial [Solanum commersonii] | diamond | 7503 | 155 | 0.993548387096774 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum commersonii | |
| 28069612 | 28069612 | PRJNA1073005_P_NODE_6285_length_357_cov_1.084507_g6166_i0 | PRJNA1073005 | 6285 | 357 | 1.084507 | 3.87168999 | Magnoliopsida | 3398 | Plants | Plants | 156 | 2.6399999999999998e-42 | NR | TXG59414.1 | 1000413 | g6166 | i0 | 61.3 | 15.9327731092437 | 119 | 43 | 99.2 | 2 | 355 | 2 | 372 | 488 | TXG59414.1 hypothetical protein EZV62_013987 [Acer yangbiense] | diamond | 5688 | 157 | 0.993630573248408 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer yangbiense | |
| 28290496 | 28290496 | PRJNA1073005_P_NODE_6546_length_344_cov_0.955720_g6427_i0 | PRJNA1073005 | 6546 | 344 | 0.95572 | 3.2876768 | Eukaryota | 2759 | Plants | Plants | 159 | 6.92e-45 | NR | XP_004497605.1 | 3827 | g6427 | i0 | 66.7 | 31.8488372093023 | 114 | 38 | 99.4 | 0 | 343 | 2 | 107 | 220 | XP_004497605.1 fructose-bisphosphate aldolase 6, cytosolic isoform X2 [Cicer arietinum] | diamond | 10956 | 160 | 0.99375 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Cicer | Cicer arietinum | |
| 28898840 | 28898840 | PRJNA1073005_P_NODE_9428_length_248_cov_0.880000_g9309_i0 | PRJNA1073005 | 9428 | 248 | 0.88 | 2.1824 | Citrus sinensis | 2711 | Plants | Plants | 71.6 | 2.67e-12 | NR | KAH9697875.1 | 2711 | g9309 | i0 | 61.7 | 0.725806451612903 | 60 | 23 | 72.6 | 0 | 246 | 67 | 919 | 978 | KAH9697875.1 hypothetical protein KPL71_023796 [Citrus sinensis] | diamond | 180 | 71.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus sinensis | |
| 29143418 | 29143418 | PRJNA1073005_P_NODE_9829_length_245_cov_0.895349_g9710_i0 | PRJNA1073005 | 9829 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | Plants | Plants | 90.9 | 4.18e-19 | NR | PPD69362.1 | 3634 | g9710 | i0 | 63.9 | 16.7142857142857 | 72 | 24 | 88.2 | 1 | 1 | 216 | 494 | 563 | PPD69362.1 hypothetical protein GOBAR_DD33752 [Gossypium barbadense] | diamond | 4095 | 90.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium barbadense | |
| 29435476 | 29435476 | PRJNA1073005_P_NODE_10070_length_243_cov_0.905882_g9951_i0 | PRJNA1073005 | 10070 | 243 | 0.905882 | 2.20129326 | Cocos nucifera | 13894 | Plants | Plants | 68.6 | 2.83e-11 | NR | KAG1337946.1 | 13894 | g9951 | i0 | 43.6 | 27.8024691358025 | 78 | 44 | 96.3 | 0 | 238 | 5 | 183 | 260 | KAG1337946.1 protein GPR107 [Cocos nucifera] | diamond | 6756 | 68.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Arecales | Arecaceae | Cocos | Cocos nucifera | |
| 29498864 | 29498864 | PRJNA1073005_P_NODE_9210_length_249_cov_0.875000_g9091_i0 | PRJNA1073005 | 9210 | 249 | 0.875 | 2.17875 | Salix brachista | 2182728 | Plants | Plants | 140 | 6.8e-40 | NR | KAB5537425.1 | 2182728 | g9091 | i0 | 92.9 | 1.68674698795181 | 70 | 5 | 84.3 | 0 | 39 | 248 | 1 | 70 | KAB5537425.1 hypothetical protein DKX38_014958 [Salix brachista] | diamond | 420 | 140 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix brachista | |
| 30248723 | 30248723 | PRJNA1073005_P_NODE_9212_length_249_cov_0.875000_g9093_i0 | PRJNA1073005 | 9212 | 249 | 0.875 | 2.17875 | Magnoliopsida | 3398 | Plants | Plants | 126 | 1.09e-34 | NR | KAG5584562.1 | 4109 | g9093 | i0 | 74.4 | 5.92771084337349 | 82 | 21 | 98.8 | 0 | 248 | 3 | 100 | 181 | KAG5584562.1 hypothetical protein H5410_044996 [Solanum commersonii] | diamond | 1476 | 127 | 0.992125984251969 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum commersonii | |
| 30478242 | 30478242 | PRJNA1073005_P_NODE_7973_length_284_cov_1.222749_g7854_i0 | PRJNA1073005 | 7973 | 284 | 1.222749 | 3.47260716 | Glycine max | 3847 | Plants | Plants | 52 | 2.7e-6 | NR | ACU20526.1 | 3847 | g7854 | i0 | 67.6 | 0.359154929577465 | 34 | 11 | 35.9 | 0 | 182 | 283 | 1 | 34 | ACU20526.1 unknown [Glycine max] | diamond | 102 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 30635910 | 30635910 | PRJNA1073005_P_NODE_10033_length_243_cov_0.905882_g9914_i0 | PRJNA1073005 | 10033 | 243 | 0.905882 | 2.20129326 | Ananas comosus | 4615 | Plants | Plants | 65.9 | 9.49e-12 | NR | XP_020092020.1 | 4615 | g9914 | i0 | 61.1 | 4.69135802469136 | 54 | 17 | 61.7 | 1 | 239 | 90 | 20 | 73 | XP_020092020.1 uncharacterized protein LOC109712697 [Ananas comosus] | diamond | 1140 | 65.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus | |
| 30943718 | 30943718 | PRJNA1073005_P_NODE_9214_length_249_cov_0.875000_g9095_i0 | PRJNA1073005 | 9214 | 249 | 0.875 | 2.17875 | Magnoliopsida | 3398 | Plants | Plants | 89 | 1.98e-18 | NR | GEW95825.1 | 118510 | g9095 | i0 | 57.7 | 7.53012048192771 | 78 | 32 | 92.8 | 1 | 19 | 249 | 244 | 321 | GEW95825.1 putative reverse transcriptase domain-containing protein [Tanacetum cinerariifolium] | diamond | 1875 | 89 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 31015245 | 31015245 | PRJNA1073005_P_NODE_9215_length_249_cov_0.875000_g9096_i0 | PRJNA1073005 | 9215 | 249 | 0.875 | 2.17875 | Striga asiatica | 4170 | Plants | Plants | 112 | 6.91e-30 | NR | GER57402.1 | 4170 | g9096 | i0 | 66.7 | 2.81927710843373 | 81 | 27 | 97.6 | 0 | 243 | 1 | 4 | 84 | GER57402.1 60S ribosomal protein L31 [Striga asiatica] | diamond | 702 | 112 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Orobanchaceae | Striga | Striga asiatica | |
| 31141247 | 31141247 | PRJNA1073005_P_NODE_8795_length_255_cov_1.549451_g8676_i0 | PRJNA1073005 | 8795 | 255 | 1.549451 | 3.95110005 | Salix dunnii | 1413687 | Plants | Plants | 52.4 | 1.24e-5 | NR | KAF9682735.1 | 1413687 | g8676 | i0 | 77.8 | 0.423529411764706 | 36 | 5 | 38.8 | 1 | 112 | 210 | 167 | 202 | KAF9682735.1 hypothetical protein SADUNF_Sadunf05G0139500 [Salix dunnii] | diamond | 108 | 52.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix dunnii | |
| 31354569 | 31354569 | PRJNA1073005_P_NODE_9636_length_246_cov_0.890173_g9517_i0 | PRJNA1073005 | 9636 | 246 | 0.890173 | 2.18982558 | Camellia | 4441 | Plants | Plants | 146 | 1.16e-38 | NR | CAL5387824.1 | 4442 | g9517 | i0 | 89.9 | 3.85365853658537 | 79 | 8 | 96.3 | 0 | 245 | 9 | 1079 | 1157 | CAL5387824.1 unnamed protein product [Camellia sinensis] | diamond | 948 | 146 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Theaceae | Camellia | Camellia sinensis | |
| 31394733 | 31394733 | PRJNA1073005_P_NODE_3996_length_505_cov_0.891204_g3877_i0 | PRJNA1073005 | 3996 | 505 | 0.891204 | 4.5005802 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 177 | 4.4699999999999994e-48 | NR | BAK02651.1 | 112509 | g3877 | i0 | 60.4 | 0.944554455445545 | 159 | 49 | 90.9 | 5 | 3 | 461 | 828 | 978 | BAK02651.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 477 | 177 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 31457991 | 31457991 | PRJNA1073005_P_NODE_9496_length_247_cov_1.109195_g9377_i0 | PRJNA1073005 | 9496 | 247 | 1.109195 | 2.73971165 | Nymphaea colorata | 210225 | Plants | Plants | 164 | 1.6199999999999998e-48 | NR | XP_049931405.1 | 210225 | g9377 | i0 | 90.2 | 1.9919028340081 | 82 | 8 | 99.6 | 0 | 2 | 247 | 140 | 221 | XP_049931405.1 CBL-interacting serine/threonine-protein kinase 23-like [Nymphaea colorata] | diamond | 492 | 164 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 32050404 | 32050404 | PRJNA1073005_P_NODE_9978_length_244_cov_0.900585_g9859_i0 | PRJNA1073005 | 9978 | 244 | 0.900585 | 2.1974274 | Magnoliopsida | 3398 | Plants | Plants | 67 | 1.03e-10 | NR | KAH0456619.1 | 161865 | g9859 | i0 | 72.5 | 15 | 40 | 10 | 49.2 | 1 | 122 | 3 | 43 | 81 | KAH0456619.1 hypothetical protein IEQ34_014526 [Dendrobium chrysotoxum] | diamond | 3660 | 67 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Orchidaceae | Dendrobium | Dendrobium chrysotoxum | |
| 32398579 | 32398579 | PRJNA1073005_P_NODE_3959_length_509_cov_1.584862_g3840_i0 | PRJNA1073005 | 3959 | 509 | 1.584862 | 8.06694758 | Streptophyta | 35493 | Plants | Plants | 130 | 2.24e-34 | NR | XP_026426638.1 | 3469 | g3840 | i0 | 47.2 | 19.090373280943 | 161 | 62 | 93.7 | 4 | 504 | 28 | 30 | 169 | XP_026426638.1 60S ribosomal protein L6-3-like [Papaver somniferum] | diamond | 9717 | 131 | 0.99236641221374 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver somniferum | |
| 32650879 | 32650879 | PRJNA1073005_P_NODE_8760_length_256_cov_1.683060_g8641_i0 | PRJNA1073005 | 8760 | 256 | 1.68306 | 4.3086336 | Eukaryota | 2759 | Plants | Plants | 129 | 1.5399999999999999e-34 | NR | ONK75370.1 | 4686 | g8641 | i0 | 72.9 | 81.97265625 | 85 | 23 | 99.6 | 0 | 256 | 2 | 168 | 252 | ONK75370.1 uncharacterized protein A4U43_C03F16120 [Asparagus officinalis] | diamond | 20985 | 129 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Asparagaceae | Asparagus | Asparagus officinalis | |
| 32879984 | 32879984 | PRJNA1073005_P_NODE_6600_length_341_cov_2.011194_g6481_i0 | PRJNA1073005 | 6600 | 341 | 2.011194 | 6.85817154 | Acer yangbiense | 1000413 | Plants | Plants | 62.4 | 1.32e-8 | NR | TXG67626.1 | 1000413 | g6481 | i0 | 42.4 | 2.61290322580645 | 99 | 50 | 87.1 | 3 | 341 | 45 | 106 | 197 | TXG67626.1 hypothetical protein EZV62_008901 [Acer yangbiense] | diamond | 891 | 62.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer yangbiense |
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);;