contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA484127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15751196 | 15751196 | PRJNA484127_P_NODE_25953_length_266_cov_2.051813_g25804_i0 | PRJNA484127 | 25953 | 266 | 2.051813 | 5.45782258 | Eukaryota | 2759 | Plants | Plants | 129 | 7.5899999999999996e-34 | NR | KAL2929432.1 | 338654 | g25804 | i0 | 70.3 | 92.9210526315789 | 91 | 23 | 98.1 | 1 | 263 | 3 | 220 | 310 | KAL2929432.1 26S proteasome regulatory subunit 8-like protein A [Bienertia sinuspersici] | diamond | 24717 | 129 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Bienertia | Bienertia sinuspersici | |
| 22125064 | 22125064 | PRJNA484127_P_NODE_28098_length_258_cov_2.021622_g27949_i0 | PRJNA484127 | 28098 | 258 | 2.021622 | 5.21578476 | Eukaryota | 2759 | Plants | Plants | 116 | 1.02e-31 | NR | AAC32177.1 | 3335 | g27949 | i0 | 73 | 17.2093023255814 | 74 | 20 | 86 | 0 | 3 | 224 | 33 | 106 | AAC32177.1 putative 60S ribosomal protein L15, partial [Picea mariana] | diamond | 4440 | 117 | 0.991452991452991 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea mariana | |
| 27170914 | 27170914 | PRJNA484127_P_NODE_24122_length_274_cov_1.646766_g23973_i0 | PRJNA484127 | 24122 | 274 | 1.646766 | 4.51213884 | Paspalum notatum var. saurae | 547442 | Plants | Plants | 43.1 | 0.0412 | NR | WVZ73083.1 | 547442 | g23973 | i0 | 55.6 | 0.394160583941606 | 36 | 16 | 39.4 | 0 | 172 | 65 | 1035 | 1070 | WVZ73083.1 LOW QUALITY PROTEIN: hypothetical protein U9M48_021431, partial [Paspalum notatum var. saurae] | diamond | 108 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Paspalum | Paspalum notatum | |
| 27202527 | 27202527 | PRJNA484127_P_NODE_32762_length_249_cov_0.886364_g32613_i0 | PRJNA484127 | 32762 | 249 | 0.886364 | 2.20704636 | Helianthus annuus | 4232 | Plants | Plants | 63.2 | 2.54e-9 | NR | XP_021987073.1 | 4232 | g32613 | i0 | 37.8 | 3.80722891566265 | 82 | 50 | 98.8 | 1 | 248 | 3 | 548 | 628 | XP_021987073.1 serine/threonine-protein phosphatase 4 regulatory subunit 3 [Helianthus annuus] | diamond | 948 | 63.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Helianthus | Helianthus annuus | |
| 27234330 | 27234330 | PRJNA484127_P_NODE_24663_length_272_cov_1.507538_g24514_i0 | PRJNA484127 | 24663 | 272 | 1.507538 | 4.10050336 | Selaginella moellendorffii | 88036 | Plants | Plants | 114 | 6.200000000000001e-28 | NR | XP_024532472.1 | 88036 | g24514 | i0 | 62.5 | 1.94117647058824 | 88 | 33 | 97.1 | 0 | 8 | 271 | 63 | 150 | XP_024532472.1 COP9 signalosome complex subunit 5a isoform X2 [Selaginella moellendorffii] | diamond | 528 | 114 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Selaginellales | Selaginellaceae | Selaginella | Selaginella moellendorffii | |
| 27392513 | 27392513 | PRJNA484127_P_NODE_33283_length_248_cov_1.765714_g33134_i0 | PRJNA484127 | 33283 | 248 | 1.765714 | 4.37897072 | Sinapis alba | 3728 | Plants | Plants | 42 | 0.0308 | NR | ABU95412.1 | 3728 | g33134 | i0 | 42.3 | 0.629032258064516 | 52 | 27 | 59.3 | 2 | 226 | 80 | 2 | 53 | ABU95412.1 Sin a 4 allergen [Sinapis alba] | diamond | 156 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Sinapis | Sinapis alba | |
| 27424160 | 27424160 | PRJNA484127_P_NODE_12343_length_353_cov_1.110714_g12194_i0 | PRJNA484127 | 12343 | 353 | 1.110714 | 3.92082042 | Brassica cretica | 69181 | Plants | Plants | 60.8 | 5.72e-8 | NR | KAF3521419.1 | 69181 | g12194 | i0 | 43.6 | 4.18980169971671 | 94 | 50 | 77.3 | 1 | 351 | 79 | 275 | 368 | KAF3521419.1 hypothetical protein F2Q69_00046583 [Brassica cretica] | diamond | 1479 | 60.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica cretica | |
| 27645164 | 27645164 | PRJNA484127_P_NODE_21024_length_289_cov_1.444444_g20875_i0 | PRJNA484127 | 21024 | 289 | 1.444444 | 4.17444316 | Juglans regia | 51240 | Plants | Plants | 77.8 | 6.48e-16 | NR | KAF5451886.1 | 51240 | g20875 | i0 | 53.6 | 3.13494809688581 | 69 | 32 | 71.6 | 0 | 249 | 43 | 25 | 93 | KAF5451886.1 hypothetical protein F2P56_026947, partial [Juglans regia] | diamond | 906 | 77.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Juglandaceae | Juglans | Juglans regia | |
| 27740029 | 27740029 | PRJNA484127_P_NODE_8104_length_416_cov_0.906706_g7955_i0 | PRJNA484127 | 8104 | 416 | 0.906706 | 3.77189696 | Eleusine coracana subsp. coracana | 191504 | Plants | Plants | 47 | 0.00654 | NR | KAK3144554.1 | 191504 | g7955 | i0 | 27.5 | 2.74038461538462 | 80 | 50 | 57.7 | 2 | 249 | 10 | 37 | 108 | KAK3144554.1 hypothetical protein QOZ80_4AG0314650 [Eleusine coracana subsp. coracana] | diamond | 1140 | 47 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Eleusine | Eleusine coracana | |
| 28166300 | 28166300 | PRJNA484127_P_NODE_30285_length_252_cov_1.307263_g30136_i0 | PRJNA484127 | 30285 | 252 | 1.307263 | 3.29430276 | Eukaryota | 2759 | Plants | Plants | 151 | 2e-40 | NR | KAI5665173.1 | 4058 | g30136 | i0 | 89.2 | 155.988095238095 | 83 | 9 | 98.8 | 0 | 252 | 4 | 350 | 432 | KAI5665173.1 hypothetical protein M9H77_24496 [Catharanthus roseus] | diamond | 39309 | 152 | 0.993421052631579 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Gentianales | Apocynaceae | Catharanthus | Catharanthus roseus | |
| 28434351 | 28434351 | PRJNA484127_P_NODE_29306_length_254_cov_1.458564_g29157_i0 | PRJNA484127 | 29306 | 254 | 1.458564 | 3.70475256 | Trifolium pratense | 57577 | Plants | Plants | 56.2 | 7.48e-7 | NR | CAJ2657585.1 | 57577 | g29157 | i0 | 56.5 | 9.01181102362205 | 46 | 20 | 54.3 | 0 | 247 | 110 | 477 | 522 | CAJ2657585.1 unnamed protein product [Trifolium pratense] | diamond | 2289 | 56.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Trifolium | Trifolium pratense | |
| 29097454 | 29097454 | PRJNA484127_P_NODE_12648_length_350_cov_1.054152_g12499_i0 | PRJNA484127 | 12648 | 350 | 1.054152 | 3.689532 | Dendrobium catenatum | 906689 | Plants | Plants | 76.6 | 4.44e-14 | NR | XP_028553577.1 | 906689 | g12499 | i0 | 48.8 | 0.72 | 84 | 35 | 72 | 1 | 16 | 267 | 155 | 230 | XP_028553577.1 RNA-binding protein 2 isoform X2 [Dendrobium catenatum] | diamond | 252 | 76.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Orchidaceae | Dendrobium | Dendrobium catenatum | |
| 29286683 | 29286683 | PRJNA484127_P_NODE_32209_length_250_cov_0.881356_g32060_i0 | PRJNA484127 | 32209 | 250 | 0.881356 | 2.20339 | Lolium multiflorum | 4521 | Plants | Plants | 43.1 | 0.0304 | NR | KAK1670835.1 | 4521 | g32060 | i0 | 31.3 | 0.768 | 64 | 44 | 76.8 | 0 | 226 | 35 | 621 | 684 | KAK1670835.1 hypothetical protein QYE76_058994 [Lolium multiflorum] | diamond | 192 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium multiflorum | |
| 29318298 | 29318298 | PRJNA484127_P_NODE_21749_length_285_cov_2.141509_g21600_i0 | PRJNA484127 | 21749 | 285 | 2.141509 | 6.10330065 | Solanum stoloniferum | 62892 | Plants | Plants | 63.9 | 2.97e-10 | NR | KAL3322857.1 | 62892 | g21600 | i0 | 66.7 | 5.77894736842105 | 51 | 16 | 52.6 | 1 | 154 | 5 | 41 | 91 | KAL3322857.1 hypothetical protein AABB24_040110, partial [Solanum stoloniferum] | diamond | 1647 | 63.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum stoloniferum | |
| 29318301 | 29318301 | PRJNA484127_P_NODE_28429_length_257_cov_1.690217_g28280_i0 | PRJNA484127 | 28429 | 257 | 1.690217 | 4.34385769 | Dorcoceras hygrometricum | 472368 | Plants | Plants | 42.7 | 0.0436 | NR | KZV39262.1 | 472368 | g28280 | i0 | 34.1 | 0.992217898832685 | 85 | 43 | 84 | 2 | 16 | 231 | 101 | 185 | KZV39262.1 ATP binding microtubule motor family protein isoform 1 [Dorcoceras hygrometricum] | diamond | 255 | 42.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Gesneriaceae | Dorcoceras | Dorcoceras hygrometricum | |
| 29318304 | 29318304 | PRJNA484127_P_NODE_34789_length_247_cov_0.896552_g34640_i0 | PRJNA484127 | 34789 | 247 | 0.896552 | 2.21448344 | Musa acuminata AAA Group | 214697 | Plants | Plants | 75.5 | 1.01e-13 | NR | XP_065023321.1 | 214697 | g34640 | i0 | 53.2 | 1.91902834008097 | 79 | 30 | 87.4 | 2 | 216 | 1 | 183 | 261 | XP_065023321.1 LOW QUALITY PROTEIN: DEAD-box ATP-dependent RNA helicase 57 [Musa acuminata AAA Group] | diamond | 474 | 75.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Musa | Musa acuminata | |
| 29460434 | 29460434 | PRJNA484127_P_NODE_11990_length_357_cov_1.390845_g11841_i0 | PRJNA484127 | 11990 | 357 | 1.390845 | 4.96531665 | Magnoliopsida | 3398 | Plants | Plants | 156 | 1.19e-45 | NR | XP_020103220.1 | 4615 | g11841 | i0 | 60 | 31.7983193277311 | 115 | 45 | 95.8 | 1 | 14 | 355 | 38 | 152 | XP_020103220.1 phosphopantothenoylcysteine decarboxylase-like [Ananas comosus] | diamond | 11352 | 157 | 0.993630573248408 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus | |
| 29681429 | 29681429 | PRJNA484127_P_NODE_22870_length_280_cov_1.304348_g22721_i0 | PRJNA484127 | 22870 | 280 | 1.304348 | 3.6521744 | root | 1 | Root_unresolved | Root_unresolved | 120 | 2.85e-29 | NR | XP_059075885.1 | 3369 | g22721 | i0 | 67.5 | 37.6821428571429 | 83 | 27 | 88.9 | 0 | 1 | 249 | 888 | 970 | XP_059075885.1 xanthine dehydrogenase isoform X3 [Cryptomeria japonica] | diamond | 10551 | 121 | 0.991735537190083 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 29760262 | 29760262 | PRJNA484127_P_NODE_16691_length_315_cov_1.880165_g16542_i0 | PRJNA484127 | 16691 | 315 | 1.880165 | 5.92251975 | Vaccinium darrowii | 229202 | Plants | Plants | 46.2 | 0.00521 | NR | KAH7860140.1 | 229202 | g16542 | i0 | 32.6 | 2.44761904761905 | 89 | 43 | 81 | 4 | 314 | 60 | 615 | 690 | KAH7860140.1 hypothetical protein Vadar_009858 [Vaccinium darrowii] | diamond | 771 | 46.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Vaccinium | Vaccinium darrowii | |
| 29966072 | 29966072 | PRJNA484127_P_NODE_37451_length_243_cov_2.270588_g37302_i0 | PRJNA484127 | 37451 | 243 | 2.270588 | 5.51752884 | Eukaryota | 2759 | Plants | Plants | 42.7 | 0.0352 | NR | KAK7400164.1 | 3891 | g37302 | i0 | 43.4 | 2.03703703703704 | 53 | 24 | 65.4 | 1 | 239 | 81 | 59 | 105 | KAK7400164.1 hypothetical protein VNO78_11364 [Psophocarpus tetragonolobus] | diamond | 495 | 42.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Psophocarpus | Psophocarpus tetragonolobus | |
| 30029319 | 30029319 | PRJNA484127_P_NODE_4031_length_558_cov_1.773196_g3886_i0 | PRJNA484127 | 4031 | 558 | 1.773196 | 9.89443368 | Eukaryota | 2759 | Plants | Plants | 156 | 2.31e-45 | NR | EPS74566.1 | 192259 | g3886 | i0 | 56.3 | 2.30645161290323 | 144 | 57 | 76.9 | 2 | 116 | 544 | 5 | 143 | EPS74566.1 hypothetical protein M569_00188 [Genlisea aurea] | diamond | 1287 | 157 | 0.993630573248408 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Lentibulariaceae | Genlisea | Genlisea aurea | |
| 30597746 | 30597746 | PRJNA484127_P_NODE_7773_length_423_cov_1.288571_g7625_i0 | PRJNA484127 | 7773 | 423 | 1.288571 | 5.45065533 | Magnoliopsida | 3398 | Plants | Plants | 188 | 3.0299999999999997e-56 | NR | XP_021846549.2 | 3562 | g7625 | i0 | 64.9 | 40.4609929078014 | 134 | 47 | 95 | 0 | 3 | 404 | 176 | 309 | XP_021846549.2 40S ribosomal protein S2-4-like [Spinacia oleracea] | diamond | 17115 | 189 | 0.994708994708995 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Spinacia | Spinacia oleracea | |
| 30866107 | 30866107 | PRJNA484127_P_NODE_33034_length_249_cov_0.886364_g32885_i0 | PRJNA484127 | 33034 | 249 | 0.886364 | 2.20704636 | Ceratopteris richardii | 49495 | Plants | Plants | 67.4 | 7.68e-11 | NR | KAH7405278.1 | 49495 | g32885 | i0 | 45.8 | 4 | 83 | 44 | 100 | 1 | 1 | 249 | 90 | 171 | KAH7405278.1 hypothetical protein KP509_15G063400 [Ceratopteris richardii] | diamond | 996 | 67.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Ceratopteris | Ceratopteris richardii | |
| 30961065 | 30961065 | PRJNA484127_P_NODE_11634_length_361_cov_1.625000_g11485_i0 | PRJNA484127 | 11634 | 361 | 1.625 | 5.86625 | Lupinus albus | 3870 | Plants | Plants | 87.4 | 4.94e-19 | NR | KAE9616737.1 | 3870 | g11485 | i0 | 58.7 | 0.623268698060942 | 75 | 31 | 62.3 | 0 | 28 | 252 | 31 | 105 | KAE9616737.1 putative ribosomal protein L12 family [Lupinus albus] | diamond | 225 | 87.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lupinus | Lupinus albus | |
| 31134705 | 31134705 | PRJNA484127_P_NODE_37035_length_244_cov_0.912281_g36886_i0 | PRJNA484127 | 37035 | 244 | 0.912281 | 2.22596564 | Eukaryota | 2759 | Plants | Plants | 62.4 | 4.56e-9 | NR | XP_057853738.2 | 3369 | g36886 | i0 | 46.1 | 6.59016393442623 | 76 | 33 | 84.8 | 2 | 243 | 37 | 562 | 636 | XP_057853738.2 probable methionine--tRNA ligase [Cryptomeria japonica] | diamond | 1608 | 62.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 31308557 | 31308557 | PRJNA484127_P_NODE_4055_length_556_cov_2.126294_g3909_i0 | PRJNA484127 | 4055 | 556 | 2.126294 | 11.82219464 | Oryza sativa Japonica Group | 39947 | Plants | Plants | 46.6 | 0.0303 | NR | XP_015643308.1 | 39947 | g3909 | i0 | 35.1 | 0.615107913669065 | 114 | 59 | 58.8 | 5 | 545 | 219 | 368 | 471 | XP_015643308.1 E4 SUMO-protein ligase PIAL1 [Oryza sativa Japonica Group] | diamond | 342 | 46.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 31388137 | 31388137 | PRJNA484127_P_NODE_23056_length_279_cov_1.427184_g22907_i0 | PRJNA484127 | 23056 | 279 | 1.427184 | 3.98184336 | Eukaryota | 2759 | Plants | Plants | 106 | 1.08e-25 | NR | KDO69205.1 | 2711 | g22907 | i0 | 53.3 | 39.6774193548387 | 92 | 43 | 98.9 | 0 | 4 | 279 | 57 | 148 | KDO69205.1 hypothetical protein CISIN_1g020919mg [Citrus sinensis] | diamond | 11070 | 107 | 0.990654205607477 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus sinensis |
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);;