contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA664479" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26764954 | 26764954 | PRJNA664479_S_NODE_8921_length_195_cov_1.102740_g8845_i0 | PRJNA664479 | 8921 | 195 | 1.10274 | 2.150343 | Gossypium australe | 47621 | Plants | Plants | 60.5 | 7.45e-10 | NR | KAA3467503.1 | 47621 | g8845 | i0 | 60 | 0.769230769230769 | 50 | 16 | 76.9 | 1 | 159 | 10 | 23 | 68 | KAA3467503.1 hypothetical protein EPI10_002509 [Gossypium australe] | diamond | 150 | 60.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium australe | |
| 26998532 | 26998532 | PRJNA664479_S_NODE_3842_length_263_cov_3.476636_g3766_i0 | PRJNA664479 | 3842 | 263 | 3.476636 | 9.14355268 | Magnoliopsida | 3398 | Plants | Plants | 57.8 | 2.31e-7 | NR | MQM01258.1 | 4460 | g3766 | i0 | 53.4 | 3.86692015209125 | 58 | 27 | 66.2 | 0 | 3 | 176 | 216 | 273 | MQM01258.1 hypothetical protein [Colocasia esculenta] | diamond | 1017 | 57.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Colocasia | Colocasia esculenta | |
| 27334500 | 27334500 | PRJNA664479_S_NODE_3483_length_274_cov_2.577778_g3407_i0 | PRJNA664479 | 3483 | 274 | 2.577778 | 7.06311172 | Castanea dentata | 134033 | Plants | Plants | 54.7 | 4.65e-7 | NR | KAL4615304.1 | 134033 | g3407 | i0 | 59.3 | 0.591240875912409 | 54 | 22 | 59.1 | 0 | 184 | 23 | 47 | 100 | KAL4615304.1 hypothetical protein ACB092_07G113800 [Castanea dentata] | diamond | 162 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Castanea | Castanea dentata | |
| 27776595 | 27776595 | PRJNA664479_S_NODE_7364_length_207_cov_1.506329_g7288_i0 | PRJNA664479 | 7364 | 207 | 1.506329 | 3.11810103 | Mucuna pruriens | 157652 | Plants | Plants | 41.2 | 0.0169 | NR | RDX57848.1 | 157652 | g7288 | i0 | 50.9 | 0.768115942028985 | 53 | 26 | 76.8 | 0 | 3 | 161 | 27 | 79 | RDX57848.1 hypothetical protein CR513_62883, partial [Mucuna pruriens] | diamond | 159 | 41.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Mucuna | Mucuna pruriens | |
| 27839404 | 27839404 | PRJNA664479_S_NODE_17524_length_163_cov_0.894737_g17448_i0 | PRJNA664479 | 17524 | 163 | 0.894737 | 1.45842131 | Persea americana | 3435 | Plants | Plants | 56.2 | 2e-7 | NR | KAJ8640106.1 | 3435 | g17448 | i0 | 56.3 | 0.883435582822086 | 48 | 21 | 88.3 | 0 | 8 | 151 | 96 | 143 | KAJ8640106.1 hypothetical protein MRB53_016800 [Persea americana] | diamond | 144 | 56.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Persea | Persea americana | |
| 28123770 | 28123770 | PRJNA664479_S_NODE_14645_length_167_cov_0.864407_g14569_i0 | PRJNA664479 | 14645 | 167 | 0.864407 | 1.44355969 | Cryptomeria japonica | 3369 | Plants | Plants | 80.5 | 1.55e-16 | NR | GLJ44234.1 | 3369 | g14569 | i0 | 67.3 | 1.86826347305389 | 52 | 17 | 93.4 | 0 | 10 | 165 | 114 | 165 | GLJ44234.1 hypothetical protein SUGI_0923980 [Cryptomeria japonica] | diamond | 312 | 80.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 28230326 | 28230326 | PRJNA664479_S_NODE_3486_length_274_cov_2.097778_g3410_i0 | PRJNA664479 | 3486 | 274 | 2.097778 | 5.74791172 | Eukaryota | 2759 | Plants | Plants | 46.2 | 2.89e-4 | NR | KAJ6756213.1 | 77065 | g3410 | i0 | 56.9 | 1.11678832116788 | 51 | 22 | 55.8 | 0 | 156 | 4 | 8 | 58 | KAJ6756213.1 hypothetical protein OIU79_028589 [Salix purpurea] | diamond | 306 | 46.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix purpurea | |
| 28912832 | 28912832 | PRJNA664479_S_NODE_2268_length_329_cov_0.803571_g2192_i0 | PRJNA664479 | 2268 | 329 | 0.803571 | 2.64374859 | Platanthera zijinensis | 2320716 | Plants | Plants | 52.8 | 5.09e-6 | NR | KAK8957619.1 | 2320716 | g2192 | i0 | 26.3 | 0.729483282674772 | 80 | 59 | 72.9 | 0 | 88 | 327 | 22 | 101 | KAK8957619.1 hypothetical protein KSP39_PZI001215 [Platanthera zijinensis] | diamond | 240 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Orchidaceae | Platanthera | Platanthera zijinensis | |
| 29165896 | 29165896 | PRJNA664479_S_NODE_629_length_588_cov_2.552876_g560_i0 | PRJNA664479 | 629 | 588 | 2.552876 | 15.01091088 | Ipomoea batatas | 4120 | Plants | Plants | 92.8 | 1.12e-19 | NR | GME01233.1 | 4120 | g560 | i0 | 46.3 | 0.627551020408163 | 123 | 66 | 62.8 | 0 | 413 | 45 | 5 | 127 | GME01233.1 ribosomal protein [Ipomoea batatas] | diamond | 369 | 92.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea batatas | |
| 29260197 | 29260197 | PRJNA664479_S_NODE_17809_length_162_cov_1.292035_g17733_i0 | PRJNA664479 | 17809 | 162 | 1.292035 | 2.0930967 | Arachis hypogaea | 3818 | Plants | Plants | 55.5 | 6.63e-8 | NR | QHO59308.1 | 3818 | g17733 | i0 | 49.1 | 0.981481481481482 | 53 | 27 | 98.1 | 0 | 161 | 3 | 67 | 119 | QHO59308.1 uncharacterized protein DS421_3g98070 [Arachis hypogaea] | diamond | 159 | 55.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Arachis | Arachis hypogaea | |
| 29481100 | 29481100 | PRJNA664479_S_NODE_5070_length_236_cov_1.614973_g4994_i0 | PRJNA664479 | 5070 | 236 | 1.614973 | 3.81133628 | Triticum aestivum | 4565 | Plants | Plants | 62.8 | 3.66e-10 | NR | XBJ25593.1 | 4565 | g4994 | i0 | 47.2 | 0.915254237288136 | 72 | 38 | 91.5 | 0 | 19 | 234 | 6 | 77 | XBJ25593.1 hypothetical protein VPH35_003212 [Triticum aestivum] | diamond | 216 | 62.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 29525243 | 29525243 | PRJNA664479_S_NODE_2570_length_310_cov_1.636015_g2494_i0 | PRJNA664479 | 2570 | 310 | 1.636015 | 5.0716465 | Eukaryota | 2759 | Plants | Plants | 63.2 | 9.84e-10 | NR | GMC85192.1 | 4120 | g2494 | i0 | 50.5 | 2.68064516129032 | 93 | 46 | 90 | 0 | 290 | 12 | 77 | 169 | GMC85192.1 protein TUB21 [Ipomoea batatas] | diamond | 831 | 63.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea batatas | |
| 29765432 | 29765432 | PRJNA664479_S_NODE_2411_length_319_cov_2.111111_g2335_i0 | PRJNA664479 | 2411 | 319 | 2.111111 | 6.73444409 | Marchantia paleacea | 56867 | Plants | Plants | 73.6 | 9.6e-13 | NR | KAG6557671.1 | 56867 | g2335 | i0 | 45.6 | 1.69278996865204 | 90 | 49 | 84.6 | 0 | 48 | 317 | 209 | 298 | KAG6557671.1 hypothetical protein Mapa_000434 [Marchantia paleacea] | diamond | 540 | 73.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Marchantiaceae | Marchantia | Marchantia paleacea | |
| 29860292 | 29860292 | PRJNA664479_S_NODE_791_length_528_cov_1.450939_g719_i0 | PRJNA664479 | 791 | 528 | 1.450939 | 7.66095792 | Ceratodon purpureus | 3225 | Plants | Plants | 63.5 | 1.03e-9 | NR | KAG0562380.1 | 3225 | g719 | i0 | 47.5 | 0.454545454545455 | 80 | 42 | 45.5 | 0 | 61 | 300 | 5 | 84 | KAG0562380.1 hypothetical protein KC19_9G141400, partial [Ceratodon purpureus] | diamond | 240 | 63.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 30176141 | 30176141 | PRJNA664479_S_NODE_5332_length_232_cov_1.191257_g5256_i0 | PRJNA664479 | 5332 | 232 | 1.191257 | 2.76371624 | Oryza sativa | 4530 | Plants | Plants | 62 | 7.58e-10 | NR | KAB8101316.1 | 4530 | g5256 | i0 | 61.4 | 0.737068965517241 | 57 | 22 | 73.7 | 0 | 44 | 214 | 4 | 60 | KAB8101316.1 hypothetical protein EE612_032074, partial [Oryza sativa] | diamond | 171 | 62 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 30315262 | 30315262 | PRJNA664479_S_NODE_11472_length_180_cov_0.786260_g11396_i0 | PRJNA664479 | 11472 | 180 | 0.78626 | 1.415268 | Eukaryota | 2759 | Plants | Plants | 79.7 | 1.45e-15 | NR | KAF3632508.1 | 4072 | g11396 | i0 | 63.8 | 442.683333333333 | 58 | 21 | 96.7 | 0 | 176 | 3 | 80 | 137 | KAF3632508.1 Actin-2 [Capsicum annuum] | diamond | 79683 | 79.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 30693908 | 30693908 | PRJNA664479_S_NODE_7353_length_207_cov_1.772152_g7277_i0 | PRJNA664479 | 7353 | 207 | 1.772152 | 3.66835464 | Magnoliopsida | 3398 | Plants | Plants | 54.7 | 8.67e-7 | NR | KAJ6674039.1 | 40686 | g7277 | i0 | 45.6 | 13.6521739130435 | 68 | 37 | 98.6 | 0 | 1 | 204 | 125 | 192 | KAJ6674039.1 GTP-BINDING NUCLEAR PROTEIN [Salix viminalis] | diamond | 2826 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix viminalis | |
| 30744990 | 30744990 | PRJNA664479_S_NODE_12014_length_177_cov_0.968750_g11938_i0 | PRJNA664479 | 12014 | 177 | 0.96875 | 1.7146875 | Clitoria ternatea | 43366 | Plants | Plants | 40.8 | 0.0308 | NR | KAK7294531.1 | 43366 | g11938 | i0 | 41.8 | 0.932203389830508 | 55 | 22 | 91.5 | 3 | 9 | 170 | 74 | 119 | KAK7294531.1 hypothetical protein RJT34_17420 [Clitoria ternatea] | diamond | 165 | 40.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Clitoria | Clitoria ternatea | |
| 31377206 | 31377206 | PRJNA664479_S_NODE_10216_length_187_cov_0.855072_g10140_i0 | PRJNA664479 | 10216 | 187 | 0.855072 | 1.59898464 | Melastoma candidum | 119954 | Plants | Plants | 43.9 | 0.00699 | NR | KAI4330963.1 | 119954 | g10140 | i0 | 42.2 | 1.02673796791444 | 64 | 29 | 93 | 2 | 178 | 5 | 122 | 183 | KAI4330963.1 hypothetical protein MLD38_029199 [Melastoma candidum] | diamond | 192 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Myrtales | Melastomataceae | Melastoma | Melastoma candidum | |
| 31535400 | 31535400 | PRJNA664479_S_NODE_936_length_483_cov_8.898618_g861_i0 | PRJNA664479 | 936 | 483 | 8.898618 | 42.98032494 | Paspalum notatum var. saurae | 547442 | Plants | Plants | 65.9 | 3.65e-9 | NR | WVZ96592.1 | 547442 | g861 | i0 | 30.8 | 4.36024844720497 | 156 | 101 | 94.4 | 3 | 482 | 27 | 298 | 450 | WVZ96592.1 hypothetical protein U9M48_042208 [Paspalum notatum var. saurae] | diamond | 2106 | 65.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Paspalum | Paspalum notatum | |
| 31630112 | 31630112 | PRJNA664479_S_NODE_716_length_554_cov_8.904950_g646_i0 | PRJNA664479 | 716 | 554 | 8.90495 | 49.333423 | Ipomoea batatas | 4120 | Plants | Plants | 59.7 | 2.6e-7 | NR | GME01233.1 | 4120 | g646 | i0 | 42.1 | 0.617328519855596 | 114 | 66 | 61.7 | 0 | 349 | 8 | 4 | 117 | GME01233.1 ribosomal protein [Ipomoea batatas] | diamond | 342 | 59.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea batatas | |
| 31693331 | 31693331 | PRJNA664479_S_NODE_11497_length_179_cov_7.607692_g11421_i0 | PRJNA664479 | 11497 | 179 | 7.607692 | 13.61776868 | Adiantum nelumboides | 2759587 | Plants | Plants | 54.7 | 9.19e-7 | NR | MCO5553831.1 | 2759587 | g11421 | i0 | 55 | 16.1061452513966 | 40 | 18 | 67 | 0 | 121 | 2 | 60 | 99 | MCO5553831.1 hypothetical protein [Adiantum nelumboides] | diamond | 2883 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Adiantum | Adiantum nelumboides | |
| 32009748 | 32009748 | PRJNA664479_S_NODE_15278_length_166_cov_0.871795_g15202_i0 | PRJNA664479 | 15278 | 166 | 0.871795 | 1.4471797 | Camellia sinensis var. sinensis | 542762 | Plants | Plants | 66.2 | 6.36e-11 | NR | GMP66376.1 | 542762 | g15202 | i0 | 90.9 | 0.596385542168675 | 33 | 3 | 59.6 | 0 | 66 | 164 | 394 | 426 | GMP66376.1 hypothetical protein CsSME_00026758 [Camellia sinensis var. sinensis] | diamond | 99 | 66.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Theaceae | Camellia | Camellia sinensis | |
| 32073005 | 32073005 | PRJNA664479_S_NODE_438_length_679_cov_4.365079_g375_i0 | PRJNA664479 | 438 | 679 | 4.365079 | 29.63888641 | Spirodela intermedia | 51605 | Plants | Plants | 90.5 | 7.1e-17 | NR | CAA7406321.1 | 51605 | g375 | i0 | 29.3 | 0.874815905743741 | 198 | 140 | 87.5 | 0 | 85 | 678 | 104 | 301 | CAA7406321.1 unnamed protein product [Spirodela intermedia] | diamond | 594 | 90.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Spirodela | Spirodela intermedia | |
| 32199628 | 32199628 | PRJNA664479_S_NODE_17618_length_163_cov_0.815789_g17542_i0 | PRJNA664479 | 17618 | 163 | 0.815789 | 1.32973607 | Gossypium australe | 47621 | Plants | Plants | 50.8 | 2.82e-6 | NR | KAA3467503.1 | 47621 | g17542 | i0 | 61.8 | 0.625766871165644 | 34 | 9 | 62.6 | 1 | 62 | 163 | 23 | 52 | KAA3467503.1 hypothetical protein EPI10_002509 [Gossypium australe] | diamond | 102 | 50.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium australe |
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);;