contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA280983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5475028 | 5475028 | PRJNA280983_P_NODE_1705_length_562_cov_1.656920_g1595_i0 | PRJNA280983 | 1705 | 562 | 1.65692 | 9.3118904 | Eukaryota | 2759 | Plants | Plants | 320 | 2.2999999999999994e-107 | NR | BAK02675.1 | 112509 | g1595 | i0 | 82.4 | 10.644128113879 | 182 | 32 | 97.2 | 0 | 561 | 16 | 152 | 333 | BAK02675.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 5982 | 320 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 5475036 | 5475036 | PRJNA280983_P_NODE_2905_length_407_cov_2.019553_g2790_i0 | PRJNA280983 | 2905 | 407 | 2.019553 | 8.21958071 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 99 | 4.22e-21 | NR | BAJ93760.1 | 112509 | g2790 | i0 | 50.4 | 2.86732186732187 | 129 | 30 | 70 | 4 | 5 | 289 | 402 | 530 | BAJ93760.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 1167 | 99 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 26694176 | 26694176 | PRJNA280983_P_NODE_9781_length_167_cov_0.864407_g9666_i0 | PRJNA280983 | 9781 | 167 | 0.864407 | 1.44355969 | Spinacia oleracea | 3562 | Plants | Plants | 63.5 | 6.04e-10 | NR | XP_021851927.1 | 3562 | g9666 | i0 | 93.3 | 1.63473053892216 | 30 | 2 | 53.9 | 0 | 70 | 159 | 673 | 702 | XP_021851927.1 centromere/kinetochore protein zw10 homolog isoform X2 [Spinacia oleracea] | diamond | 273 | 63.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Spinacia | Spinacia oleracea | |
| 26852859 | 26852859 | PRJNA280983_P_NODE_8521_length_188_cov_1.309353_g8406_i0 | PRJNA280983 | 8521 | 188 | 1.309353 | 2.46158364 | Pistacia vera | 55513 | Plants | Plants | 70.5 | 2.92e-12 | NR | XP_031270500.1 | 55513 | g8406 | i0 | 64.6 | 4.53191489361702 | 48 | 17 | 76.6 | 0 | 188 | 45 | 215 | 262 | XP_031270500.1 uncharacterized protein LOC116128868 [Pistacia vera] | diamond | 852 | 70.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Anacardiaceae | Pistacia | Pistacia vera | |
| 26915895 | 26915895 | PRJNA280983_P_NODE_10682_length_164_cov_0.886957_g10567_i0 | PRJNA280983 | 10682 | 164 | 0.886957 | 1.45460948 | Zizania palustris | 103762 | Plants | Plants | 43.9 | 0.00496 | NR | KAG8059836.1 | 103762 | g10567 | i0 | 42.3 | 0.951219512195122 | 52 | 28 | 95.1 | 2 | 6 | 161 | 8 | 57 | KAG8059836.1 hypothetical protein GUJ93_ZPchr0002g23452 [Zizania palustris] | diamond | 156 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zizania | Zizania palustris | |
| 26996716 | 26996716 | PRJNA280983_P_NODE_10022_length_166_cov_0.871795_g9907_i0 | PRJNA280983 | 10022 | 166 | 0.871795 | 1.4471797 | Magnoliopsida | 3398 | Plants | Plants | 68.2 | 1.36e-11 | NR | KAJ0667092.1 | 4232 | g9907 | i0 | 50.8 | 2.18674698795181 | 61 | 23 | 97.6 | 1 | 164 | 3 | 223 | 283 | KAJ0667092.1 putative RNA-directed DNA polymerase [Helianthus annuus] | diamond | 363 | 68.6 | 0.994169096209913 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Helianthus | Helianthus annuus | |
| 27074087 | 27074087 | PRJNA280983_P_NODE_10122_length_166_cov_0.871795_g10007_i0 | PRJNA280983 | 10122 | 166 | 0.871795 | 1.4471797 | Tagetes erecta | 13708 | Plants | Plants | 90.9 | 1.45e-19 | NR | KAK1434639.1 | 13708 | g10007 | i0 | 89.4 | 0.849397590361446 | 47 | 5 | 84.9 | 0 | 141 | 1 | 695 | 741 | KAK1434639.1 hypothetical protein QVD17_00388 [Tagetes erecta] | diamond | 141 | 90.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tagetes | Tagetes erecta | |
| 27200318 | 27200318 | PRJNA280983_P_NODE_10642_length_164_cov_0.886957_g10527_i0 | PRJNA280983 | 10642 | 164 | 0.886957 | 1.45460948 | Spinacia oleracea | 3562 | Plants | Plants | 55.1 | 5.54e-7 | NR | XP_021855296.1 | 3562 | g10527 | i0 | 92.3 | 0.951219512195122 | 26 | 2 | 47.6 | 0 | 163 | 86 | 186 | 211 | XP_021855296.1 agmatine deiminase [Spinacia oleracea] | diamond | 156 | 55.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Spinacia | Spinacia oleracea | |
| 27912829 | 27912829 | PRJNA280983_P_NODE_10345_length_165_cov_0.879310_g10230_i0 | PRJNA280983 | 10345 | 165 | 0.87931 | 1.4508615 | Eukaryota | 2759 | Plants | Plants | 66.6 | 4.74e-11 | NR | BAK01753.1 | 112509 | g10230 | i0 | 100 | 6 | 33 | 0 | 60 | 0 | 3 | 101 | 557 | 589 | BAK01753.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 990 | 66.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 28179288 | 28179288 | PRJNA280983_P_NODE_1546_length_593_cov_1.694853_g1436_i0 | PRJNA280983 | 1546 | 593 | 1.694853 | 10.05047829 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 117 | 8.23e-27 | NR | BAJ93760.1 | 112509 | g1436 | i0 | 41.5 | 1.15851602023609 | 229 | 86 | 97.1 | 6 | 591 | 16 | 84 | 301 | BAJ93760.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 687 | 117 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 28368885 | 28368885 | PRJNA280983_P_NODE_9446_length_172_cov_1.634146_g9331_i0 | PRJNA280983 | 9446 | 172 | 1.634146 | 2.81073112 | Dillenia turbinata | 194707 | Plants | Plants | 62.4 | 1.6e-9 | NR | KAK6917196.1 | 194707 | g9331 | i0 | 59.1 | 0.767441860465116 | 44 | 18 | 76.7 | 0 | 3 | 134 | 398 | 441 | KAK6917196.1 Phospho-N-acetylmuramoyl-pentapeptide transferase, conserved site, partial [Dillenia turbinata] | diamond | 132 | 62.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Dilleniales | Dilleniaceae | Dillenia | Dillenia turbinata | |
| 28449968 | 28449968 | PRJNA280983_P_NODE_10986_length_162_cov_1.654867_g10871_i0 | PRJNA280983 | 10986 | 162 | 1.654867 | 2.68088454 | Eukaryota | 2759 | Plants | Plants | 54.7 | 7.4e-7 | NR | KAK1428844.1 | 13708 | g10871 | i0 | 62.5 | 5.35185185185185 | 40 | 15 | 74.1 | 0 | 42 | 161 | 647 | 686 | KAK1428844.1 hypothetical protein QVD17_17684 [Tagetes erecta] | diamond | 867 | 55.1 | 0.992740471869329 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tagetes | Tagetes erecta | |
| 28702521 | 28702521 | PRJNA280983_P_NODE_9367_length_173_cov_2.161290_g9252_i0 | PRJNA280983 | 9367 | 173 | 2.16129 | 3.7390317 | Caryophyllales | 3524 | Plants | Plants | 87 | 3.57e-18 | NR | KAJ8446711.1 | 171969 | g9252 | i0 | 72.9 | 4.07514450867052 | 59 | 14 | 98.8 | 1 | 173 | 3 | 384 | 442 | KAJ8446711.1 hypothetical protein Cgig2_002873 [Carnegiea gigantea] | diamond | 705 | 87 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Cactaceae | Carnegiea | Carnegiea gigantea | |
| 28891628 | 28891628 | PRJNA280983_P_NODE_10668_length_164_cov_0.886957_g10553_i0 | PRJNA280983 | 10668 | 164 | 0.886957 | 1.45460948 | Solanaceae | 4070 | Plants | Plants | 85.9 | 7.96e-18 | NR | XP_019236372.1 | 49451 | g10553 | i0 | 75 | 5.78048780487805 | 52 | 13 | 95.1 | 0 | 7 | 162 | 472 | 523 | XP_019236372.1 PREDICTED: RNA-directed DNA polymerase from mobile element jockey-like, partial [Nicotiana attenuata] | diamond | 948 | 85.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Nicotiana | Nicotiana attenuata | |
| 29252797 | 29252797 | PRJNA280983_P_NODE_909_length_782_cov_1.435198_g808_i0 | PRJNA280983 | 909 | 782 | 1.435198 | 11.22324836 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 125 | 8.99e-29 | NR | BAJ93760.1 | 112509 | g808 | i0 | 40 | 1.13171355498721 | 295 | 103 | 90.5 | 14 | 75 | 782 | 119 | 398 | BAJ93760.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 885 | 125 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 29410807 | 29410807 | PRJNA280983_P_NODE_10149_length_166_cov_0.871795_g10034_i0 | PRJNA280983 | 10149 | 166 | 0.871795 | 1.4471797 | Pyrus ussuriensis x Pyrus communis | 2448454 | Plants | Plants | 63.2 | 4.44e-11 | NR | KAB2605751.1 | 2448454 | g10034 | i0 | 68.9 | 2.33132530120482 | 45 | 11 | 75.9 | 1 | 25 | 150 | 53 | 97 | KAB2605751.1 hypothetical protein D8674_005468 [Pyrus ussuriensis x Pyrus communis] | diamond | 387 | 63.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Pyrus | Pyrus ussuriensis x Pyrus communis | |
| 29410812 | 29410812 | PRJNA280983_P_NODE_7509_length_209_cov_0.931250_g7394_i0 | PRJNA280983 | 7509 | 209 | 0.93125 | 1.9463125 | Carnegiea gigantea | 171969 | Plants | Plants | 51.2 | 2.41e-5 | NR | KAJ8442822.1 | 171969 | g7394 | i0 | 76 | 0.358851674641148 | 25 | 6 | 35.9 | 0 | 116 | 190 | 314 | 338 | KAJ8442822.1 hypothetical protein Cgig2_016288 [Carnegiea gigantea] | diamond | 75 | 51.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Cactaceae | Carnegiea | Carnegiea gigantea | |
| 30628679 | 30628679 | PRJNA280983_P_NODE_9753_length_167_cov_1.593220_g9638_i0 | PRJNA280983 | 9753 | 167 | 1.59322 | 2.6606774 | Magnoliopsida | 3398 | Plants | Plants | 57 | 1.23e-7 | NR | GMH04189.1 | 150966 | g9638 | i0 | 75 | 3.41317365269461 | 32 | 8 | 57.5 | 0 | 1 | 96 | 786 | 817 | GMH04189.1 hypothetical protein Nepgr_006028 [Nepenthes gracilis] | diamond | 570 | 57 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Nepenthaceae | Nepenthes | Nepenthes gracilis | |
| 30723628 | 30723628 | PRJNA280983_P_NODE_94_length_1841_cov_2.090402_g70_i0 | PRJNA280983 | 94 | 1841 | 2.090402 | 38.48430082 | Eukaryota | 2759 | Plants | Plants | 762 | 3.29e-270 | NR | XP_013642611.2 | 3708 | g70 | i0 | 62 | 66.7463335143944 | 603 | 221 | 97.8 | 4 | 1818 | 19 | 5 | 602 | XP_013642611.2 ABC transporter E family member 1 isoform X1 [Brassica napus] | diamond | 122880 | 768 | 0.9921875 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 31102685 | 31102685 | PRJNA280983_P_NODE_8755_length_184_cov_1.377778_g8640_i0 | PRJNA280983 | 8755 | 184 | 1.377778 | 2.53511152 | Caryophyllales | 3524 | Plants | Plants | 73.6 | 2.25e-13 | NR | KAK9713781.1 | 3572 | g8640 | i0 | 66 | 3.45652173913043 | 53 | 16 | 86.4 | 1 | 18 | 176 | 887 | 937 | KAK9713781.1 hypothetical protein RND81_06G051200 [Saponaria officinalis] | diamond | 636 | 74.3 | 0.990578734858681 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Caryophyllaceae | Saponaria | Saponaria officinalis | |
| 31134131 | 31134131 | PRJNA280983_P_NODE_9795_length_167_cov_0.864407_g9680_i0 | PRJNA280983 | 9795 | 167 | 0.864407 | 1.44355969 | Eukaryota | 2759 | Plants | Plants | 85.1 | 2.43e-19 | NR | XP_016515165.1 | 4097 | g9680 | i0 | 70.9 | 11.7664670658683 | 55 | 16 | 98.8 | 0 | 167 | 3 | 56 | 110 | XP_016515165.1 eukaryotic translation initiation factor 1A-like [Nicotiana tabacum] | diamond | 1965 | 85.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Nicotiana | Nicotiana tabacum | |
| 31464811 | 31464811 | PRJNA280983_P_NODE_10796_length_163_cov_0.894737_g10681_i0 | PRJNA280983 | 10796 | 163 | 0.894737 | 1.45842131 | Heliosperma pusillum | 39905 | Plants | Plants | 75.9 | 2.38e-14 | NR | KAH9608911.1 | 39905 | g10681 | i0 | 84.6 | 3.60736196319018 | 39 | 6 | 71.8 | 0 | 43 | 159 | 302 | 340 | KAH9608911.1 hypothetical protein KSS87_019301, partial [Heliosperma pusillum] | diamond | 588 | 75.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Caryophyllaceae | Heliosperma | Heliosperma pusillum | |
| 31559669 | 31559669 | PRJNA280983_P_NODE_10236_length_165_cov_0.879310_g10121_i0 | PRJNA280983 | 10236 | 165 | 0.87931 | 1.4508615 | Chenopodium quinoa | 63459 | Plants | Plants | 74.7 | 3.52e-14 | NR | XP_021756299.1 | 63459 | g10121 | i0 | 76.2 | 4.67272727272727 | 42 | 10 | 76.4 | 0 | 161 | 36 | 241 | 282 | XP_021756299.1 serrate RNA effector molecule homolog isoform X3 [Chenopodium quinoa] | diamond | 771 | 74.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Chenopodium | Chenopodium quinoa | |
| 31829987 | 31829987 | PRJNA280983_P_NODE_2837_length_414_cov_1.545205_g2722_i0 | PRJNA280983 | 2837 | 414 | 1.545205 | 6.3971487 | Eukaryota | 2759 | Plants | Plants | 125 | 1.33e-32 | NR | BAK00444.1 | 112509 | g2722 | i0 | 72.4 | 1.48550724637681 | 105 | 19 | 76.1 | 2 | 401 | 87 | 142 | 236 | BAK00444.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 615 | 125 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 32382087 | 32382087 | PRJNA280983_P_NODE_9319_length_174_cov_1.264000_g9204_i0 | PRJNA280983 | 9319 | 174 | 1.264 | 2.19936 | Saponaria officinalis | 3572 | Plants | Plants | 74.7 | 7.68e-14 | NR | KAK9725148.1 | 3572 | g9204 | i0 | 91.7 | 1.24137931034483 | 36 | 3 | 62.1 | 0 | 1 | 108 | 414 | 449 | KAK9725148.1 hypothetical protein RND81_05G125200 [Saponaria officinalis] | diamond | 216 | 74.7 | 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);;