contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA733995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4545059 | 4545059 | PRJNA733995_P_NODE_10264_length_270_cov_2.086294_g10217_i0 | PRJNA733995 | 10264 | 270 | 2.086294 | 5.6329938 | Dorcoceras hygrometricum | 472368 | Plants | Plants | 118 | 8.46e-32 | NR | KZV30458.1 | 472368 | g10217 | i0 | 85.1 | 1.45555555555556 | 67 | 10 | 74.4 | 0 | 269 | 69 | 88 | 154 | KZV30458.1 major allergen Pru ar 1-like [Dorcoceras hygrometricum] | diamond | 393 | 118 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Gesneriaceae | Dorcoceras | Dorcoceras hygrometricum | |
| 4545151 | 4545151 | PRJNA733995_P_NODE_7564_length_312_cov_1.728033_g7517_i0 | PRJNA733995 | 7564 | 312 | 1.728033 | 5.39146296 | Pteridaceae | 13819 | Plants | Plants | 165 | 7.52e-45 | NR | KAI5073818.1 | 13818 | g7517 | i0 | 77.9 | 42.9519230769231 | 104 | 23 | 100 | 0 | 312 | 1 | 348 | 451 | KAI5073818.1 hypothetical protein GOP47_0011831 [Adiantum capillus-veneris] | diamond | 13401 | 166 | 0.993975903614458 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Adiantum | Adiantum capillus-veneris | |
| 10125312 | 10125312 | PRJNA733995_P_NODE_11008_length_261_cov_2.393617_g10961_i0 | PRJNA733995 | 11008 | 261 | 2.393617 | 6.24734037 | Dorcoceras hygrometricum | 472368 | Plants | Plants | 80.9 | 4.97e-16 | NR | KZV56074.1 | 472368 | g10961 | i0 | 72.4 | 3.24137931034483 | 58 | 15 | 65.5 | 1 | 250 | 80 | 1 | 58 | KZV56074.1 late embryogenesis abundant protein 76-like [Dorcoceras hygrometricum] | diamond | 846 | 80.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Gesneriaceae | Dorcoceras | Dorcoceras hygrometricum | |
| 26608968 | 26608968 | PRJNA733995_P_NODE_2041_length_628_cov_0.827027_g1994_i0 | PRJNA733995 | 2041 | 628 | 0.827027 | 5.19372956 | Adiantum nelumboides | 2759587 | Plants | Plants | 46.2 | 0.05 | NR | MCO5579219.1 | 2759587 | g1994 | i0 | 28.7 | 0.68312101910828 | 143 | 87 | 66.4 | 3 | 212 | 628 | 16 | 147 | MCO5579219.1 hypothetical protein [Adiantum nelumboides] | diamond | 429 | 46.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Adiantum | Adiantum nelumboides | |
| 26682649 | 26682649 | PRJNA733995_P_NODE_3321_length_484_cov_2.051095_g3274_i0 | PRJNA733995 | 3321 | 484 | 2.051095 | 9.9272998 | Eukaryota | 2759 | Plants | Plants | 96.7 | 7.93e-20 | NR | OIV93883.1 | 3871 | g3274 | i0 | 70.7 | 5.65289256198347 | 75 | 22 | 46.5 | 0 | 258 | 482 | 690 | 764 | OIV93883.1 hypothetical protein TanjilG_05586 [Lupinus angustifolius] | diamond | 2736 | 97.1 | 0.995880535530381 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lupinus | Lupinus angustifolius | |
| 26841330 | 26841330 | PRJNA733995_P_NODE_7781_length_309_cov_1.148305_g7734_i0 | PRJNA733995 | 7781 | 309 | 1.148305 | 3.54826245 | Magnoliopsida | 3398 | Plants | Plants | 122 | 1.18e-29 | NR | GMN51990.1 | 3494 | g7734 | i0 | 55.7 | 3.09708737864078 | 115 | 38 | 99 | 1 | 3 | 308 | 677 | 791 | GMN51990.1 hypothetical protein TIFTF001_021133 [Ficus carica] | diamond | 957 | 123 | 0.991869918699187 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Moraceae | Ficus | Ficus carica | |
| 27684560 | 27684560 | PRJNA733995_P_NODE_11164_length_260_cov_1.235294_g11117_i0 | PRJNA733995 | 11164 | 260 | 1.235294 | 3.2117644 | Elaeis guineensis | 51953 | Plants | Plants | 60.8 | 1.88e-8 | NR | XP_010936429.1 | 51953 | g11117 | i0 | 36.7 | 2.59615384615385 | 79 | 48 | 91.2 | 1 | 13 | 249 | 446 | 522 | XP_010936429.1 probable galacturonosyltransferase 11 [Elaeis guineensis] | diamond | 675 | 60.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Arecales | Arecaceae | Elaeis | Elaeis guineensis | |
| 27757907 | 27757907 | PRJNA733995_P_NODE_424_length_1353_cov_2.116406_g407_i0 | PRJNA733995 | 424 | 1353 | 2.116406 | 28.63497318 | Gentianales | 4055 | Plants | Plants | 76.3 | 7.24e-11 | NR | KAI5683039.1 | 4058 | g407 | i0 | 27.4 | 1.58980044345898 | 237 | 142 | 49.4 | 8 | 681 | 1349 | 132 | 352 | KAI5683039.1 hypothetical protein M9H77_04267 [Catharanthus roseus] | diamond | 2151 | 77 | 0.990909090909091 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Gentianales | Apocynaceae | Catharanthus | Catharanthus roseus | |
| 27947069 | 27947069 | PRJNA733995_P_NODE_12605_length_247_cov_2.212644_g12558_i0 | PRJNA733995 | 12605 | 247 | 2.212644 | 5.46523068 | Streptophyta | 35493 | Plants | Plants | 114 | 1.0600000000000002e-27 | NR | XP_002990169.1 | 88036 | g12558 | i0 | 62.2 | 1.97975708502024 | 82 | 31 | 99.6 | 0 | 2 | 247 | 57 | 138 | XP_002990169.1 COP9 signalosome complex subunit 1 [Selaginella moellendorffii] | diamond | 489 | 114 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Selaginellales | Selaginellaceae | Selaginella | Selaginella moellendorffii | |
| 28315773 | 28315773 | PRJNA733995_P_NODE_5226_length_377_cov_1.266447_g5179_i0 | PRJNA733995 | 5226 | 377 | 1.266447 | 4.77450519 | Mangifera indica | 29780 | Plants | Plants | 47 | 0.00436 | NR | XP_044494738.1 | 29780 | g5179 | i0 | 45.1 | 0.405835543766578 | 51 | 20 | 40.6 | 1 | 29 | 181 | 238 | 280 | XP_044494738.1 tobamovirus multiplication protein 2A-like [Mangifera indica] | diamond | 153 | 47 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Anacardiaceae | Mangifera | Mangifera indica | |
| 28357353 | 28357353 | PRJNA733995_P_NODE_3226_length_493_cov_1.100000_g3179_i0 | PRJNA733995 | 3226 | 493 | 1.1 | 5.423 | Magnoliopsida | 3398 | Plants | Plants | 89.7 | 2.28e-17 | NR | KAF1874752.1 | 3870 | g3179 | i0 | 44.4 | 2.11156186612576 | 142 | 68 | 79.7 | 1 | 396 | 4 | 249 | 390 | KAF1874752.1 hypothetical protein Lal_00007366 [Lupinus albus] | diamond | 1041 | 90.1 | 0.995560488346282 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lupinus | Lupinus albus | |
| 28515438 | 28515438 | PRJNA733995_P_NODE_10167_length_272_cov_1.160804_g10120_i0 | PRJNA733995 | 10167 | 272 | 1.160804 | 3.15738688 | Eukaryota | 2759 | Plants | Plants | 115 | 1.96e-27 | NR | KAF7060528.1 | 4565 | g10120 | i0 | 61.4 | 9.50735294117647 | 88 | 31 | 93.8 | 1 | 17 | 271 | 305 | 392 | KAF7060528.1 hypothetical protein CFC21_067316 [Triticum aestivum] | diamond | 2586 | 115 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 29873119 | 29873119 | PRJNA733995_P_NODE_13731_length_242_cov_0.881657_g13684_i0 | PRJNA733995 | 13731 | 242 | 0.881657 | 2.13360994 | Eukaryota | 2759 | Plants | Plants | 102 | 1.3500000000000002e-26 | NR | MQL76813.1 | 4460 | g13684 | i0 | 74.6 | 17.2066115702479 | 63 | 16 | 78.1 | 0 | 6 | 194 | 5 | 67 | MQL76813.1 hypothetical protein [Colocasia esculenta] | diamond | 4164 | 102 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Colocasia | Colocasia esculenta | |
| 30631183 | 30631183 | PRJNA733995_P_NODE_6633_length_333_cov_1.476923_g6586_i0 | PRJNA733995 | 6633 | 333 | 1.476923 | 4.91815359 | Eukaryota | 2759 | Plants | Plants | 85.1 | 5.15e-19 | NR | NP_001327468.1 | 3702 | g6586 | i0 | 100 | 42.8738738738739 | 40 | 0 | 36 | 0 | 332 | 213 | 44 | 83 | NP_001327468.1 Small nuclear ribonucleoprotein family protein [Arabidopsis thaliana] | diamond | 14277 | 85.9 | 0.990686845168801 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis thaliana | |
| 31316335 | 31316335 | PRJNA733995_P_NODE_6315_length_341_cov_1.876866_g6268_i0 | PRJNA733995 | 6315 | 341 | 1.876866 | 6.40011306 | Salvia splendens | 180675 | Plants | Plants | 61.2 | 6.7e-9 | NR | XP_042032582.1 | 180675 | g6268 | i0 | 51.5 | 0.580645161290323 | 66 | 29 | 58.1 | 1 | 144 | 341 | 68 | 130 | XP_042032582.1 uncharacterized protein LOC121779323 [Salvia splendens] | diamond | 198 | 61.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Lamiaceae | Salvia | Salvia splendens | |
| 31453227 | 31453227 | PRJNA733995_P_NODE_4356_length_416_cov_4.253644_g4309_i0 | PRJNA733995 | 4356 | 416 | 4.253644 | 17.69515904 | Salix | 40685 | Plants | Plants | 146 | 4.12e-39 | NR | KAJ6718744.1 | 77065 | g4309 | i0 | 73 | 2.88461538461538 | 100 | 27 | 72.1 | 0 | 110 | 409 | 50 | 149 | KAJ6718744.1 DIHYDROLIPOYLLYSINE-RESIDUE ACETYLTRANSFERASE COMPONENT 4 OF PYRUVATE DEHYDROGENASE COMPLEX CHLOROPLASTIC [Salix purpurea] | diamond | 1200 | 146 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix purpurea | |
| 31632533 | 31632533 | PRJNA733995_P_NODE_5416_length_370_cov_1.750842_g5369_i0 | PRJNA733995 | 5416 | 370 | 1.750842 | 6.4781154 | Populus alba x Populus x berolinensis | 444605 | Plants | Plants | 130 | 1.15e-34 | NR | KAJ6911972.1 | 444605 | g5369 | i0 | 54.9 | 1.97837837837838 | 122 | 54 | 98.9 | 1 | 368 | 3 | 63 | 183 | KAJ6911972.1 hypothetical protein NC652_022302 [Populus alba x Populus x berolinensis] | diamond | 732 | 130 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus alba x Populus x berolinensis | |
| 31706099 | 31706099 | PRJNA733995_P_NODE_6037_length_349_cov_1.789855_g5990_i0 | PRJNA733995 | 6037 | 349 | 1.789855 | 6.24659395 | Eukaryota | 2759 | Plants | Plants | 122 | 1.08e-29 | NR | KAJ7555079.1 | 34168 | g5990 | i0 | 70.7 | 4.96848137535817 | 82 | 24 | 70.5 | 0 | 246 | 1 | 153 | 234 | KAJ7555079.1 hypothetical protein O6H91_05G021500 [Diphasiastrum complanatum] | diamond | 1734 | 123 | 0.991869918699187 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Lycopodiales | Lycopodiaceae | Diphasiastrum | Diphasiastrum complanatum | |
| 31822240 | 31822240 | PRJNA733995_P_NODE_1517_length_730_cov_2.383562_g1473_i0 | PRJNA733995 | 1517 | 730 | 2.383562 | 17.4000026 | Trapa natans | 22666 | Plants | Plants | 92.8 | 1.58e-17 | NR | KAK4800096.1 | 22666 | g1473 | i0 | 30.1 | 2.81917808219178 | 246 | 145 | 96.2 | 8 | 730 | 29 | 316 | 546 | KAK4800096.1 hypothetical protein SAY86_025461 [Trapa natans] | diamond | 2058 | 92.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Myrtales | Lythraceae | Trapa | Trapa natans | |
| 31948818 | 31948818 | PRJNA733995_P_NODE_11977_length_251_cov_0.865169_g11930_i0 | PRJNA733995 | 11977 | 251 | 0.865169 | 2.17157419 | Eleusine coracana subsp. coracana | 191504 | Plants | Plants | 43.5 | 0.0189 | NR | KAK3146720.1 | 191504 | g11930 | i0 | 43.1 | 0.776892430278884 | 65 | 31 | 74.1 | 3 | 8 | 193 | 96 | 157 | KAK3146720.1 hypothetical protein QOZ80_3BG0270810 [Eleusine coracana subsp. coracana] | diamond | 195 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Eleusine | Eleusine coracana | |
| 32592000 | 32592000 | PRJNA733995_P_NODE_1939_length_644_cov_2.567426_g1892_i0 | PRJNA733995 | 1939 | 644 | 2.567426 | 16.53422344 | Streptophyta | 35493 | Plants | Plants | 90.1 | 6e-17 | NR | KAI4984695.1 | 4513 | g1892 | i0 | 38.5 | 14.832298136646 | 148 | 88 | 68.5 | 2 | 638 | 198 | 316 | 461 | KAI4984695.1 hypothetical protein ZWY2020_017325 [Hordeum vulgare] | diamond | 9552 | 90.5 | 0.995580110497237 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 32675944 | 32675944 | PRJNA733995_P_NODE_11200_length_259_cov_1.655914_g11153_i0 | PRJNA733995 | 11200 | 259 | 1.655914 | 4.28881726 | Carex littledalei | 544730 | Plants | Plants | 42.7 | 0.0449 | NR | KAF3335573.1 | 544730 | g11153 | i0 | 26.5 | 0.787644787644788 | 68 | 50 | 78.8 | 0 | 205 | 2 | 353 | 420 | KAF3335573.1 protein SET DOMAIN GROUP 40 isoform X2 [Carex littledalei] | diamond | 204 | 42.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Cyperaceae | Carex | Carex littledalei |
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);;