contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_kingdom = "Viridiplantae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2270628 | 2270628 | PRJEB73599_P_NODE_7022_length_218_cov_3.000000_g6735_i0 | PRJEB73599 | 7022 | 218 | 3 | 6.54 | Streptophyta | 35493 | Plants | Plants | 72.8 | 1.35e-13 | NR | CAM6026948.1 | 128184 | g6735 | i0 | 80 | 31.1422018348624 | 40 | 8 | 55 | 0 | 215 | 96 | 136 | 175 | CAM6026948.1 unnamed protein product [Sphagnum balticum] | diamond | 6789 | 73.2 | 0.994535519125683 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 6513240 | 6513240 | PRJEB73599_P_NODE_1326_length_647_cov_2.752427_g1123_i0 | PRJEB73599 | 1326 | 647 | 2.752427 | 17.80820269 | Streptophyta | 35493 | Plants | Plants | 206 | 1.48e-63 | NR | KAI5068948.1 | 13818 | g1123 | i0 | 54.9 | 24.0185471406492 | 215 | 79 | 99.7 | 5 | 2 | 646 | 1 | 197 | KAI5068948.1 hypothetical protein GOP47_0015249 [Adiantum capillus-veneris] | diamond | 15540 | 207 | 0.995169082125604 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Adiantum | Adiantum capillus-veneris | |
| 6513255 | 6513255 | PRJEB73599_P_NODE_3046_length_414_cov_1.942857_g2761_i0 | PRJEB73599 | 3046 | 414 | 1.942857 | 8.04342798 | Eukaryota | 2759 | Plants | Plants | 102 | 4.41e-22 | NR | MCL7034904.1 | 74823 | g2761 | i0 | 51.5 | 6.32608695652174 | 97 | 47 | 70.3 | 0 | 292 | 2 | 494 | 590 | MCL7034904.1 hypothetical protein [Papaver nudicaule] | diamond | 2619 | 103 | 0.990291262135922 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver nudicaule | |
| 9062431 | 9062431 | PRJEB73599_P_NODE_2428_length_473_cov_2.157658_g2161_i0 | PRJEB73599 | 2428 | 473 | 2.157658 | 10.20572234 | Symbiochloris irregularis | 706552 | Plants | Plants | 188 | 4.82e-52 | NR | KAK9789544.1 | 706552 | g2161 | i0 | 69.9 | 0.780126849894292 | 123 | 37 | 78 | 0 | 2 | 370 | 932 | 1054 | KAK9789544.1 hypothetical protein WJX73_004313 [Symbiochloris irregularis] | diamond | 369 | 188 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 20536084 | 20536084 | PRJEB73599_P_NODE_3997_length_346_cov_1.870662_g3710_i0 | PRJEB73599 | 3997 | 346 | 1.870662 | 6.47249052 | Riccia fluitans | 41844 | Plants | Plants | 115 | 6.1399999999999995e-30 | NR | KAL2623906.1 | 41844 | g3710 | i0 | 81.8 | 1.71676300578035 | 66 | 12 | 57.2 | 0 | 83 | 280 | 80 | 145 | KAL2623906.1 hypothetical protein R1flu_008151 [Riccia fluitans] | diamond | 594 | 115 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Ricciaceae | Riccia | Riccia fluitans | |
| 24360982 | 24360982 | PRJEB73599_P_NODE_3060_length_413_cov_2.963542_g2775_i0 | PRJEB73599 | 3060 | 413 | 2.963542 | 12.23942846 | Opisthokonta | 33154 | Plants | Plants | 196 | 7.3e-59 | NR | GBG82800.1 | 69332 | g2775 | i0 | 75.4 | 10.953995157385 | 138 | 33 | 99.5 | 1 | 3 | 413 | 139 | 276 | GBG82800.1 hypothetical protein CBR_g36331 [Chara braunii] | diamond | 4524 | 197 | 0.99492385786802 | Eukaryota | Viridiplantae | Streptophyta | Charophyceae | Charales | Characeae | Chara | Chara braunii | ||
| 26837192 | 26837192 | PRJEB73599_P_NODE_8141_length_189_cov_1.443750_g7854_i0 | PRJEB73599 | 8141 | 189 | 1.44375 | 2.7286875 | Magnoliopsida | 3398 | Plants | Plants | 62 | 2.86e-9 | NR | GMH03277.1 | 150966 | g7854 | i0 | 47.5 | 3.87301587301587 | 61 | 32 | 96.8 | 0 | 3 | 185 | 725 | 785 | GMH03277.1 hypothetical protein Nepgr_005116 [Nepenthes gracilis] | diamond | 732 | 62 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Nepenthaceae | Nepenthes | Nepenthes gracilis | |
| 27627367 | 27627367 | PRJEB73599_P_NODE_7224_length_212_cov_2.398907_g6937_i0 | PRJEB73599 | 7224 | 212 | 2.398907 | 5.08568284 | root | 1 | Root_unresolved | Root_unresolved | 76.3 | 3.83e-14 | NR | XP_002954858.1 | 3068 | g6937 | i0 | 65.4 | 50.1367924528302 | 52 | 18 | 73.6 | 0 | 212 | 57 | 702 | 753 | XP_002954858.1 uncharacterized protein VOLCADRAFT_76494 [Volvox carteri f. nagariensis] | diamond | 10629 | 76.6 | 0.996083550913838 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 27816861 | 27816861 | PRJEB73599_P_NODE_5184_length_284_cov_1.898039_g4897_i0 | PRJEB73599 | 5184 | 284 | 1.898039 | 5.39043076 | Eukaryota | 2759 | Plants | Plants | 96.3 | 9.53e-21 | NR | PRW20411.1 | 3076 | g4897 | i0 | 70.7 | 11.0492957746479 | 58 | 17 | 61.3 | 0 | 176 | 3 | 648 | 705 | PRW20411.1 elongation factor EF-3 isoform B [Chlorella sorokiniana] | diamond | 3138 | 97.1 | 0.991761071060762 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 27879795 | 27879795 | PRJEB73599_P_NODE_5585_length_267_cov_2.147059_g5298_i0 | PRJEB73599 | 5585 | 267 | 2.147059 | 5.73264753 | Viridiplantae | 33090 | Plants | Plants | 64.3 | 6.07e-11 | NR | KAJ6756078.1 | 77065 | g5298 | i0 | 54.2 | 4.31460674157303 | 72 | 31 | 79.8 | 2 | 15 | 227 | 41 | 111 | KAJ6756078.1 30S 40S RIBOSOMAL PROTEIN [Salix purpurea] | diamond | 1152 | 64.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix purpurea | |
| 28581781 | 28581781 | PRJEB73599_P_NODE_7067_length_217_cov_1.936170_g6780_i0 | PRJEB73599 | 7067 | 217 | 1.93617 | 4.2014889 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 69.3 | 2.8e-12 | NR | KAK3256391.1 | 36881 | g6780 | i0 | 57.4 | 0.746543778801843 | 54 | 22 | 74.7 | 1 | 1 | 162 | 54 | 106 | KAK3256391.1 hypothetical protein CYMTET_34473 [Cymbomonas tetramitiformis] | diamond | 162 | 69.3 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 28669289 | 28669289 | PRJEB73599_P_NODE_2147_length_506_cov_2.750524_g1891_i0 | PRJEB73599 | 2147 | 506 | 2.750524 | 13.91765144 | Eukaryota | 2759 | Plants | Plants | 137 | 2.4e-36 | NR | QDX19557.1 | 39947 | g1891 | i0 | 46 | 13.0079051383399 | 163 | 82 | 93.7 | 2 | 482 | 9 | 5 | 166 | QDX19557.1 hypothetical protein [Oryza sativa Japonica Group] | diamond | 6582 | 138 | 0.992753623188406 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 29213335 | 29213335 | PRJEB73599_P_NODE_4609_length_311_cov_2.460993_g4322_i0 | PRJEB73599 | 4609 | 311 | 2.460993 | 7.65368823 | Anisodus tanguticus | 243964 | Plants | Plants | 42.7 | 0.0465 | NR | KAK4369194.1 | 243964 | g4322 | i0 | 45.2 | 0.405144694533762 | 42 | 23 | 40.5 | 0 | 154 | 29 | 6 | 47 | KAK4369194.1 hypothetical protein RND71_012986 [Anisodus tanguticus] | diamond | 126 | 42.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Anisodus | Anisodus tanguticus | |
| 29371074 | 29371074 | PRJEB73599_P_NODE_8189_length_188_cov_1.515723_g7902_i0 | PRJEB73599 | 8189 | 188 | 1.515723 | 2.84955924 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 76.3 | 2.77e-14 | NR | GEU28527.1 | 118510 | g7902 | i0 | 75 | 3.15957446808511 | 52 | 12 | 83 | 1 | 33 | 188 | 3425 | 3475 | GEU28527.1 aspartate--tRNA ligase, chloroplastic/mitochondrial [Tanacetum cinerariifolium] | diamond | 594 | 76.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 29616040 | 29616040 | PRJEB73599_P_NODE_4110_length_339_cov_1.909677_g3823_i0 | PRJEB73599 | 4110 | 339 | 1.909677 | 6.47380503 | Eukaryota | 2759 | Plants | Plants | 53.9 | 4.48e-6 | NR | PWZ11267.1 | 4577 | g3823 | i0 | 44.7 | 3.17699115044248 | 76 | 40 | 66.4 | 2 | 1 | 225 | 13 | 87 | PWZ11267.1 Uncharacterized protein Zm00014a_012555 [Zea mays] | diamond | 1077 | 53.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 29869005 | 29869005 | PRJEB73599_P_NODE_2851_length_431_cov_2.223881_g2572_i0 | PRJEB73599 | 2851 | 431 | 2.223881 | 9.58492711 | Eukaryota | 2759 | Plants | Plants | 114 | 2.82e-26 | NR | KAI3438154.1 | 3077 | g2572 | i0 | 52.3 | 2.26914153132251 | 109 | 51 | 75.2 | 1 | 326 | 3 | 313 | 421 | KAI3438154.1 hypothetical protein D9Q98_000592 [Chlorella vulgaris] | diamond | 978 | 114 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 30350615 | 30350615 | PRJEB73599_P_NODE_7372_length_207_cov_2.882022_g7085_i0 | PRJEB73599 | 7372 | 207 | 2.882022 | 5.96578554 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 62 | 3.5e-10 | NR | KAK3254765.1 | 36881 | g7085 | i0 | 58.1 | 0.898550724637681 | 62 | 25 | 88.4 | 1 | 185 | 3 | 7 | 68 | KAK3254765.1 hypothetical protein CYMTET_36031 [Cymbomonas tetramitiformis] | diamond | 186 | 62 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 30816809 | 30816809 | PRJEB73599_P_NODE_3494_length_380_cov_1.629630_g3208_i0 | PRJEB73599 | 3494 | 380 | 1.62963 | 6.192594 | Streptophyta | 35493 | Plants | Plants | 129 | 2.36e-32 | NR | KAG0567129.1 | 3225 | g3208 | i0 | 56.8 | 3.97105263157895 | 132 | 50 | 98.7 | 2 | 6 | 380 | 309 | 440 | KAG0567129.1 hypothetical protein KC19_7G112700 [Ceratodon purpureus] | diamond | 1509 | 129 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 30855553 | 30855553 | PRJEB73599_P_NODE_10154_length_150_cov_2.165289_g9867_i0 | PRJEB73599 | 10154 | 150 | 2.165289 | 3.2479335 | Brassica carinata | 52824 | Plants | Plants | 48.5 | 7.03e-5 | NR | KAL0642007.1 | 52824 | g9867 | i0 | 67.5 | 0.8 | 40 | 10 | 78 | 2 | 146 | 30 | 18 | 55 | KAL0642007.1 hypothetical protein Bca4012_102970 [Brassica carinata] | diamond | 120 | 48.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica carinata | |
| 31266457 | 31266457 | PRJEB73599_P_NODE_5555_length_268_cov_2.548117_g5268_i0 | PRJEB73599 | 5555 | 268 | 2.548117 | 6.82895356 | Durio zibethinus | 66656 | Plants | Plants | 83.2 | 6.09e-18 | NR | XP_022752929.1 | 66656 | g5268 | i0 | 61.8 | 2.18283582089552 | 68 | 20 | 69.4 | 1 | 78 | 263 | 64 | 131 | XP_022752929.1 SUMO-conjugating enzyme UBC9-like isoform X1 [Durio zibethinus] | diamond | 585 | 83.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Durio | Durio zibethinus | |
| 31297989 | 31297989 | PRJEB73599_P_NODE_7395_length_207_cov_1.325843_g7108_i0 | PRJEB73599 | 7395 | 207 | 1.325843 | 2.74449501 | Trebouxia sp. C | 2796353 | Plants | Plants | 99.8 | 5.68e-23 | NR | KAL0049813.1 | 2905655 | g7108 | i0 | 62.7 | 1.94202898550725 | 67 | 25 | 97.1 | 0 | 203 | 3 | 207 | 273 | KAL0049813.1 hypothetical protein WJX82_010375 [Trebouxia sp. C0006] | diamond | 402 | 99.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0006 | |
| 31638650 | 31638650 | PRJEB73599_P_NODE_7536_length_203_cov_1.982759_g7249_i0 | PRJEB73599 | 7536 | 203 | 1.982759 | 4.02500077 | Streptophyta | 35493 | Plants | Plants | 81.6 | 3.35e-16 | NR | KAG6545352.1 | 56867 | g7249 | i0 | 57.9 | 12.3546798029557 | 76 | 22 | 97.5 | 1 | 203 | 6 | 128 | 203 | KAG6545352.1 hypothetical protein Mapa_013201 [Marchantia paleacea] | diamond | 2508 | 81.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Marchantiaceae | Marchantia | Marchantia paleacea | |
| 32342231 | 32342231 | PRJEB73599_P_NODE_819_length_836_cov_1.950434_g662_i0 | PRJEB73599 | 819 | 836 | 1.950434 | 16.30562824 | Cryptomeria japonica | 3369 | Plants | Plants | 160 | 9.29e-43 | NR | XP_057865708.1 | 3369 | g662 | i0 | 43.2 | 2.47607655502392 | 222 | 104 | 75 | 9 | 90 | 716 | 62 | 274 | XP_057865708.1 cysteine proteinase 15A [Cryptomeria japonica] | diamond | 2070 | 160 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 32745346 | 32745346 | PRJEB73599_P_NODE_8040_length_191_cov_1.895062_g7753_i0 | PRJEB73599 | 8040 | 191 | 1.895062 | 3.61956842 | Eukaryota | 2759 | Plants | Plants | 76.6 | 2.09e-14 | NR | TVU17487.1 | 38414 | g7753 | i0 | 68.8 | 13.7120418848168 | 64 | 19 | 99 | 1 | 2 | 190 | 291 | 354 | TVU17487.1 hypothetical protein EJB05_33525, partial [Eragrostis curvula] | diamond | 2619 | 77 | 0.994805194805195 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Eragrostis | Eragrostis curvula |
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);;