contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA1011833" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11633971 | 11633971 | PRJNA1011833_S_NODE_25570_length_235_cov_1.750000_g25150_i0 | PRJNA1011833 | 25570 | 235 | 1.75 | 4.1125 | Eukaryota | 2759 | Plants | Plants | 149 | 1.31e-44 | NR | NP_001077473.1 | 3702 | g25150 | i0 | 91.5 | 143.246808510638 | 71 | 6 | 90.6 | 0 | 233 | 21 | 39 | 109 | NP_001077473.1 PHF5-like protein [Arabidopsis thaliana] | diamond | 33663 | 150 | 0.993333333333333 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis thaliana | |
| 11634155 | 11634155 | PRJNA1011833_S_NODE_7070_length_418_cov_7.578667_g6654_i0 | PRJNA1011833 | 7070 | 418 | 7.578667 | 31.67882806 | Eukaryota | 2759 | Plants | Plants | 81.6 | 4.3e-16 | NR | KAJ3675634.1 | 13579 | g6654 | i0 | 64.9 | 2.64114832535885 | 57 | 20 | 40.9 | 0 | 418 | 248 | 87 | 143 | KAJ3675634.1 hypothetical protein LUZ60_004676 [Juncus effusus] | diamond | 1104 | 82.4 | 0.990291262135922 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus | |
| 15458145 | 15458145 | PRJNA1011833_S_NODE_5633_length_449_cov_27.300493_g5221_i0 | PRJNA1011833 | 5633 | 449 | 27.300493 | 122.57921357 | Eukaryota | 2759 | Plants | Plants | 220 | 3.72e-68 | NR | XP_022154562.1 | 3673 | g5221 | i0 | 91.4 | 963.581291759465 | 128 | 11 | 85.5 | 0 | 449 | 66 | 9 | 136 | XP_022154562.1 uncharacterized protein LOC111021800 [Momordica charantia] | diamond | 432648 | 222 | 0.990990990990991 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Momordica | Momordica charantia | |
| 18007338 | 18007338 | PRJNA1011833_S_NODE_8255_length_396_cov_12.152975_g7838_i0 | PRJNA1011833 | 8255 | 396 | 12.152975 | 48.125781 | Sphagnum tenellum | 128247 | Plants | Plants | 120 | 3.729999999999999e-32 | NR | CAM6054793.1 | 128247 | g7838 | i0 | 51.8 | 3.32575757575758 | 110 | 52 | 83.3 | 1 | 394 | 65 | 34 | 142 | CAM6054793.1 unnamed protein product [Sphagnum tenellum] | diamond | 1317 | 120 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum tenellum | |
| 21832254 | 21832254 | PRJNA1011833_S_NODE_44618_length_174_cov_1.099237_g44198_i0 | PRJNA1011833 | 44618 | 174 | 1.099237 | 1.91267238 | Eukaryota | 2759 | Plants | Plants | 93.6 | 1.85e-20 | NR | KAH7280799.1 | 49495 | g44198 | i0 | 74.1 | 10.8448275862069 | 58 | 15 | 100 | 0 | 174 | 1 | 501 | 558 | KAH7280799.1 hypothetical protein KP509_36G014900 [Ceratopteris richardii] | diamond | 1887 | 93.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Ceratopteris | Ceratopteris richardii | |
| 23107636 | 23107636 | PRJNA1011833_S_NODE_17859_length_286_cov_6.798354_g17439_i0 | PRJNA1011833 | 17859 | 286 | 6.798354 | 19.44329244 | Magnoliopsida | 3398 | Plants | Plants | 135 | 8.999999999999999e-39 | NR | VVA24395.1 | 3755 | g17439 | i0 | 72.4 | 15.8286713286713 | 87 | 24 | 91.3 | 0 | 278 | 18 | 35 | 121 | VVA24395.1 PREDICTED: small nuclear, partial [Prunus dulcis] | diamond | 4527 | 136 | 0.992647058823529 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Prunus | Prunus dulcis | |
| 26615363 | 26615363 | PRJNA1011833_S_NODE_54421_length_156_cov_1.699115_g54001_i0 | PRJNA1011833 | 54421 | 156 | 1.699115 | 2.6506194 | Eukaryota | 2759 | Plants | Plants | 67 | 3.19e-11 | NR | KAI5349152.1 | 3755 | g54001 | i0 | 58.8 | 14.7307692307692 | 51 | 21 | 98.1 | 0 | 4 | 156 | 1056 | 1106 | KAI5349152.1 hypothetical protein L3X38_002039 [Prunus dulcis] | diamond | 2298 | 67.4 | 0.99406528189911 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Prunus | Prunus dulcis | |
| 26781615 | 26781615 | PRJNA1011833_S_NODE_19961_length_270_cov_2.537445_g19541_i0 | PRJNA1011833 | 19961 | 270 | 2.537445 | 6.8511015 | Cardamine amara subsp. amara | 228776 | Plants | Plants | 52 | 3.05e-5 | NR | KAL1211858.1 | 228776 | g19541 | i0 | 32.8 | 7.41111111111111 | 67 | 45 | 74.4 | 0 | 13 | 213 | 2130 | 2196 | KAL1211858.1 hypothetical protein V5N11_023843 [Cardamine amara subsp. amara] | diamond | 2001 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Cardamine | Cardamine amara | |
| 27058691 | 27058691 | PRJNA1011833_S_NODE_31762_length_208_cov_2.909091_g31342_i0 | PRJNA1011833 | 31762 | 208 | 2.909091 | 6.05090928 | Eukaryota | 2759 | Plants | Plants | 93.6 | 4.17e-22 | NR | KAB8111270.1 | 4530 | g31342 | i0 | 60.9 | 23.7980769230769 | 69 | 27 | 99.5 | 0 | 1 | 207 | 91 | 159 | KAB8111270.1 hypothetical protein EE612_048861, partial [Oryza sativa] | diamond | 4950 | 94.4 | 0.991525423728813 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 27595935 | 27595935 | PRJNA1011833_S_NODE_5804_length_445_cov_9.823383_g5392_i0 | PRJNA1011833 | 5804 | 445 | 9.823383 | 43.71405435 | Eukaryota | 2759 | Plants | Plants | 121 | 1.72e-29 | NR | XP_022025792.1 | 4232 | g5392 | i0 | 49.2 | 13.6786516853933 | 120 | 60 | 80.2 | 1 | 1 | 357 | 311 | 430 | XP_022025792.1 protein DJ-1 homolog B [Helianthus annuus] | diamond | 6087 | 122 | 0.991803278688525 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Helianthus | Helianthus annuus | |
| 27824565 | 27824565 | PRJNA1011833_S_NODE_11804_length_346_cov_3.607261_g11384_i0 | PRJNA1011833 | 11804 | 346 | 3.607261 | 12.48112306 | Ficus carica | 3494 | Plants | Plants | 44.3 | 0.00316 | NR | GMN50239.1 | 3494 | g11384 | i0 | 49.1 | 0.494219653179191 | 57 | 16 | 41.6 | 2 | 3 | 146 | 13 | 65 | GMN50239.1 hypothetical protein TIFTF001_019411 [Ficus carica] | diamond | 171 | 44.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Moraceae | Ficus | Ficus carica | |
| 28361056 | 28361056 | PRJNA1011833_S_NODE_2306_length_600_cov_14.635548_g1944_i0 | PRJNA1011833 | 2306 | 600 | 14.635548 | 87.813288 | Selaginella moellendorffii | 88036 | Plants | Plants | 46.2 | 0.0311 | NR | XP_002983666.1 | 88036 | g1944 | i0 | 45.7 | 0.46 | 46 | 25 | 23 | 0 | 598 | 461 | 31 | 76 | XP_002983666.1 vesicle-associated protein 1-2 isoform X2 [Selaginella moellendorffii] | diamond | 276 | 46.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Selaginellales | Selaginellaceae | Selaginella | Selaginella moellendorffii | |
| 28574480 | 28574480 | PRJNA1011833_S_NODE_20087_length_269_cov_2.548673_g19667_i0 | PRJNA1011833 | 20087 | 269 | 2.548673 | 6.85593037 | Eukaryota | 2759 | Plants | Plants | 42.7 | 0.0478 | NR | KAK1285928.1 | 4465 | g19667 | i0 | 29 | 3.1003717472119 | 69 | 45 | 77 | 1 | 235 | 29 | 237 | 301 | KAK1285928.1 hypothetical protein QJS10_CPB20g01403 [Acorus calamus] | diamond | 834 | 42.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Acorales | Acoraceae | Acorus | Acorus calamus | |
| 28606129 | 28606129 | PRJNA1011833_S_NODE_3287_length_532_cov_9.186094_g2897_i0 | PRJNA1011833 | 3287 | 532 | 9.186094 | 48.87002008 | Eukaryota | 2759 | Plants | Plants | 122 | 5.34e-29 | NR | XP_008372269.3 | 3750 | g2897 | i0 | 39.8 | 5.90413533834586 | 166 | 89 | 90.2 | 3 | 517 | 38 | 338 | 498 | XP_008372269.3 UDP-glycosyltransferase TURAN-like isoform X3 [Malus domestica] | diamond | 3141 | 123 | 0.991869918699187 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Malus | Malus domestica | |
| 28637926 | 28637926 | PRJNA1011833_S_NODE_26367_length_231_cov_1.787234_g25947_i0 | PRJNA1011833 | 26367 | 231 | 1.787234 | 4.12851054 | Magnoliopsida | 3398 | Plants | Plants | 50.4 | 1.5e-5 | NR | XP_021999348.1 | 4232 | g25947 | i0 | 40.6 | 10.4545454545455 | 64 | 38 | 83.1 | 0 | 213 | 22 | 34 | 97 | XP_021999348.1 bet1-like SNARE 1-2 [Helianthus annuus] | diamond | 2415 | 50.8 | 0.992125984251969 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Helianthus | Helianthus annuus | |
| 28645442 | 28645442 | PRJNA1011833_S_NODE_10887_length_358_cov_4.536508_g10468_i0 | PRJNA1011833 | 10887 | 358 | 4.536508 | 16.24069864 | Asparagus officinalis | 4686 | Plants | Plants | 63.5 | 6.4e-9 | NR | XP_020261073.1 | 4686 | g10468 | i0 | 33 | 2.02793296089385 | 115 | 69 | 89.7 | 4 | 356 | 36 | 291 | 405 | XP_020261073.1 ubiquitin-like modifier-activating enzyme 5 [Asparagus officinalis] | diamond | 726 | 63.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Asparagaceae | Asparagus | Asparagus officinalis | |
| 28929529 | 28929529 | PRJNA1011833_S_NODE_18508_length_281_cov_2.596639_g18088_i0 | PRJNA1011833 | 18508 | 281 | 2.596639 | 7.29655559 | Cryptomeria japonica | 3369 | Plants | Plants | 43.1 | 0.0432 | NR | GLJ29223.1 | 3369 | g18088 | i0 | 31.5 | 0.950177935943061 | 89 | 59 | 94 | 2 | 273 | 10 | 659 | 746 | GLJ29223.1 hypothetical protein SUGI_0576370 [Cryptomeria japonica] | diamond | 267 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 29087526 | 29087526 | PRJNA1011833_S_NODE_28608_length_221_cov_1.617978_g28188_i0 | PRJNA1011833 | 28608 | 221 | 1.617978 | 3.57573138 | Spinacia oleracea | 3562 | Plants | Plants | 76.6 | 1.69e-15 | NR | XP_021848044.1 | 3562 | g28188 | i0 | 63.8 | 1.8868778280543 | 47 | 17 | 63.8 | 0 | 183 | 43 | 118 | 164 | XP_021848044.1 uncharacterized protein LOC110787714 [Spinacia oleracea] | diamond | 417 | 76.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Spinacia | Spinacia oleracea | |
| 29426854 | 29426854 | PRJNA1011833_S_NODE_2049_length_625_cov_12.609966_g1699_i0 | PRJNA1011833 | 2049 | 625 | 12.609966 | 78.8122875 | Eukaryota | 2759 | Plants | Plants | 256 | 1.76e-81 | NR | KAH7284858.1 | 49495 | g1699 | i0 | 65 | 88.0032 | 200 | 68 | 95.5 | 2 | 2 | 598 | 142 | 340 | KAH7284858.1 hypothetical protein KP509_34G074100 [Ceratopteris richardii] | diamond | 55002 | 258 | 0.992248062015504 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Ceratopteris | Ceratopteris richardii | |
| 30066198 | 30066198 | PRJNA1011833_S_NODE_30152_length_214_cov_4.304094_g29732_i0 | PRJNA1011833 | 30152 | 214 | 4.304094 | 9.21076116 | Ceratopteris richardii | 49495 | Plants | Plants | 47.8 | 2.14e-4 | NR | KAH7295277.1 | 49495 | g29732 | i0 | 39.6 | 4.19158878504673 | 53 | 30 | 71.5 | 1 | 1 | 153 | 109 | 161 | KAH7295277.1 hypothetical protein KP509_27G040900 [Ceratopteris richardii] | diamond | 897 | 47.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Ceratopteris | Ceratopteris richardii | |
| 30469671 | 30469671 | PRJNA1011833_S_NODE_5953_length_442_cov_10.378446_g5541_i0 | PRJNA1011833 | 5953 | 442 | 10.378446 | 45.87273132 | Fabaceae | 3803 | Plants | Plants | 48.5 | 6.88e-4 | NR | KHN46146.1 | 3848 | g5541 | i0 | 62.2 | 7.05203619909502 | 37 | 14 | 25.1 | 0 | 324 | 214 | 73 | 109 | KHN46146.1 SelT-like protein [Glycine soja] | diamond | 3117 | 48.9 | 0.991820040899796 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine soja | |
| 31267026 | 31267026 | PRJNA1011833_S_NODE_19595_length_273_cov_1.491304_g19175_i0 | PRJNA1011833 | 19595 | 273 | 1.491304 | 4.07125992 | Vaccinium darrowii | 229202 | Plants | Plants | 47.4 | 0.00126 | NR | KAH7835713.1 | 229202 | g19175 | i0 | 48.6 | 3.14285714285714 | 35 | 18 | 38.5 | 0 | 140 | 244 | 192 | 226 | KAH7835713.1 hypothetical protein Vadar_029117 [Vaccinium darrowii] | diamond | 858 | 47.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Vaccinium | Vaccinium darrowii | |
| 31481092 | 31481092 | PRJNA1011833_S_NODE_4196_length_493_cov_5.384444_g3794_i0 | PRJNA1011833 | 4196 | 493 | 5.384444 | 26.54530892 | Eukaryota | 2759 | Plants | Plants | 80.1 | 1.4e-14 | NR | XP_024376907.1 | 3218 | g3794 | i0 | 55.9 | 11.0993914807302 | 68 | 29 | 41.4 | 1 | 48 | 251 | 128 | 194 | XP_024376907.1 THO complex subunit 4B-like [Physcomitrium patens] | diamond | 5472 | 80.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 31583474 | 31583474 | PRJNA1011833_S_NODE_39096_length_186_cov_1.678322_g38676_i0 | PRJNA1011833 | 39096 | 186 | 1.678322 | 3.12167892 | Miscanthus lutarioriparius | 422564 | Plants | Plants | 49.7 | 6.46e-5 | NR | CAD6226389.1 | 422564 | g38676 | i0 | 43.6 | 2.66129032258065 | 55 | 30 | 88.7 | 1 | 168 | 4 | 1268 | 1321 | CAD6226389.1 unnamed protein product [Miscanthus lutarioriparius] | diamond | 495 | 49.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Miscanthus | Miscanthus lutarioriparius | |
| 31614896 | 31614896 | PRJNA1011833_S_NODE_33736_length_202_cov_0.905660_g33316_i0 | PRJNA1011833 | 33736 | 202 | 0.90566 | 1.8294332 | Malania oleifera | 397392 | Plants | Plants | 47 | 5.19e-4 | NR | XP_057973784.1 | 397392 | g33316 | i0 | 68.8 | 0.475247524752475 | 32 | 9 | 47.5 | 1 | 97 | 192 | 156 | 186 | XP_057973784.1 glycine-rich protein 2-like [Malania oleifera] | diamond | 96 | 47 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Ximeniaceae | Malania | Malania oleifera | |
| 32050153 | 32050153 | PRJNA1011833_S_NODE_14858_length_313_cov_2.662963_g14438_i0 | PRJNA1011833 | 14858 | 313 | 2.662963 | 8.33507419 | Linum | 4005 | Plants | Plants | 46.6 | 0.00354 | NR | CAI0436930.1 | 586396 | g14438 | i0 | 36.4 | 1.47603833865815 | 77 | 41 | 73.8 | 1 | 232 | 2 | 43 | 111 | CAI0436930.1 unnamed protein product [Linum tenue] | diamond | 462 | 46.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Linaceae | Linum | Linum tenue | |
| 32208425 | 32208425 | PRJNA1011833_S_NODE_30738_length_212_cov_1.988166_g30318_i0 | PRJNA1011833 | 30738 | 212 | 1.988166 | 4.21491192 | Eukaryota | 2759 | Plants | Plants | 55.8 | 5.98e-7 | NR | KAJ3681232.1 | 13579 | g30318 | i0 | 39.4 | 5.94339622641509 | 71 | 41 | 97.6 | 2 | 2 | 208 | 992 | 1062 | KAJ3681232.1 hypothetical protein LUZ60_015721 [Juncus effusus] | diamond | 1260 | 55.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus |
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);;