contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA1020641" and tax_kingdom = "Metazoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10363779 | 10363779 | PRJNA1020641_P_NODE_4709_length_277_cov_1.132353_g4666_i0 | PRJNA1020641 | 4709 | 277 | 1.132353 | 3.13661781 | Sarcoptes scabiei | 52283 | Arthropoda | Arthropoda | 84 | 1.76e-16 | NR | KAF7494767.1 | 52283 | g4666 | i0 | 51.1 | 8.8158844765343 | 90 | 41 | 97.5 | 1 | 6 | 275 | 77 | 163 | KAF7494767.1 Kinesin-like protein KIF3A [Sarcoptes scabiei] | diamond | 2442 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Sarcoptidae | Sarcoptes | Sarcoptes scabiei | |
| 11639181 | 11639181 | PRJNA1020641_P_NODE_7310_length_242_cov_0.881657_g7267_i0 | PRJNA1020641 | 7310 | 242 | 0.881657 | 2.13360994 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 91.3 | 3.11e-19 | NR | XP_065907847.1 | 196820 | g7267 | i0 | 51.3 | 5.9504132231405 | 80 | 39 | 99.2 | 0 | 240 | 1 | 1459 | 1538 | XP_065907847.1 phosphatidylinositol 4-kinase alpha-like isoform X2 [Dysidea avara] | diamond | 1440 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 21837413 | 21837413 | PRJNA1020641_P_NODE_4818_length_273_cov_1.145000_g4775_i0 | PRJNA1020641 | 4818 | 273 | 1.145 | 3.12585 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 150 | 5.62e-40 | NR | XP_038064386.1 | 46514 | g4775 | i0 | 80.7 | 13.5604395604396 | 88 | 17 | 96.7 | 0 | 272 | 9 | 1894 | 1981 | XP_038064386.1 dynein beta chain, ciliary-like isoform X1 [Patiria miniata] | diamond | 3702 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26805505 | 26805505 | PRJNA1020641_P_NODE_4581_length_282_cov_1.105263_g4538_i0 | PRJNA1020641 | 4581 | 282 | 1.105263 | 3.11684166 | Mytilus | 6548 | Mollusca | Mollusca | 47 | 0.00199 | NR | XP_052105827.1 | 6549 | g4538 | i0 | 34.1 | 5.80851063829787 | 91 | 50 | 96.8 | 2 | 6 | 278 | 1408 | 1488 | XP_052105827.1 dynein axonemal heavy chain 6-like isoform X2 [Mytilus californianus] | diamond | 1638 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 26869085 | 26869085 | PRJNA1020641_P_NODE_7221_length_242_cov_0.911243_g7178_i0 | PRJNA1020641 | 7221 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Arthropoda | Arthropoda | 102 | 2.68e-23 | NR | XP_037797912.1 | 6687 | g7178 | i0 | 64.1 | 57.4710743801653 | 78 | 26 | 96.7 | 1 | 234 | 1 | 627 | 702 | XP_037797912.1 putative pre-mRNA-splicing factor ATP-dependent RNA helicase PRP1 [Penaeus monodon] | diamond | 13908 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus monodon | |
| 27192784 | 27192784 | PRJNA1020641_P_NODE_3822_length_312_cov_1.288703_g3779_i0 | PRJNA1020641 | 3822 | 312 | 1.288703 | 4.02075336 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 45.4 | 0.00981 | NR | BBA10910.1 | 6161 | g3779 | i0 | 42.9 | 0.403846153846154 | 42 | 24 | 40.4 | 0 | 291 | 166 | 104 | 145 | BBA10910.1 mitogen-activated protein kinase kinase kinase 1 [Dugesia japonica] | diamond | 126 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 27256095 | 27256095 | PRJNA1020641_P_NODE_2703_length_372_cov_1.043478_g2660_i0 | PRJNA1020641 | 2703 | 372 | 1.043478 | 3.88173816 | Cooperia oncophora | 27828 | Nematoda | Nematoda | 108 | 1.16e-24 | NR | KAK6051238.1 | 27828 | g2660 | i0 | 41.5 | 0.991935483870968 | 123 | 68 | 99.2 | 1 | 371 | 3 | 45 | 163 | KAK6051238.1 putative capsid protein [Cooperia oncophora] | diamond | 369 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 27635283 | 27635283 | PRJNA1020641_P_NODE_2704_length_372_cov_1.030100_g2661_i0 | PRJNA1020641 | 2704 | 372 | 1.0301 | 3.831972 | Liolophura japonica | 13599 | Mollusca | Mollusca | 171 | 1.9e-46 | NR | XP_064608081.1 | 13599 | g2661 | i0 | 65.8 | 0.967741935483871 | 120 | 36 | 96.8 | 2 | 1 | 360 | 108 | 222 | XP_064608081.1 serine/threonine-protein kinase dst1-like isoform X2 [Liolophura japonica] | diamond | 360 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 27793149 | 27793149 | PRJNA1020641_P_NODE_6344_length_247_cov_0.885057_g6301_i0 | PRJNA1020641 | 6344 | 247 | 0.885057 | 2.18609079 | Enterobius vermicularis | 51028 | Nematoda | Nematoda | 57.8 | 1.66e-7 | NR | VDD88457.1 | 51028 | g6301 | i0 | 41.3 | 4.90688259109312 | 80 | 36 | 96 | 3 | 5 | 241 | 144 | 213 | VDD88457.1 unnamed protein product [Enterobius vermicularis] | diamond | 1212 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Enterobius | Enterobius vermicularis | |
| 27856111 | 27856111 | PRJNA1020641_P_NODE_3625_length_321_cov_1.354839_g3582_i0 | PRJNA1020641 | 3625 | 321 | 1.354839 | 4.34903319 | Ranitomeya imitator | 111125 | Chordata | Chordata | 62 | 1.59e-8 | NR | CAJ0933392.1 | 111125 | g3582 | i0 | 62.5 | 0.448598130841121 | 48 | 16 | 43 | 1 | 142 | 5 | 53 | 100 | CAJ0933392.1 unnamed protein product [Ranitomeya imitator] | diamond | 144 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 28290300 | 28290300 | PRJNA1020641_P_NODE_6026_length_249_cov_0.875000_g5983_i0 | PRJNA1020641 | 6026 | 249 | 0.875 | 2.17875 | Bivalvia | 6544 | Mollusca | Mollusca | 87 | 1.04e-17 | NR | XP_052816497.1 | 6604 | g5983 | i0 | 59.1 | 7.80722891566265 | 66 | 25 | 77.1 | 1 | 246 | 55 | 364 | 429 | XP_052816497.1 lysine--tRNA ligase-like isoform X2 [Mya arenaria] | diamond | 1944 | 87.8 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 28551001 | 28551001 | PRJNA1020641_P_NODE_4267_length_294_cov_0.904977_g4224_i0 | PRJNA1020641 | 4267 | 294 | 0.904977 | 2.66063238 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 48.5 | 6.02e-4 | NR | XP_044171043.1 | 45264 | g4224 | i0 | 51.4 | 0.714285714285714 | 35 | 17 | 35.7 | 0 | 120 | 16 | 185 | 219 | XP_044171043.1 uncharacterized protein LOC122955325 [Acropora millepora] | diamond | 210 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 29964001 | 29964001 | PRJNA1020641_P_NODE_2691_length_373_cov_1.173333_g2648_i0 | PRJNA1020641 | 2691 | 373 | 1.173333 | 4.37653209 | Chordata | 7711 | Chordata | Chordata | 115 | 5.7600000000000005e-27 | NR | OCT97315.1 | 8355 | g2648 | i0 | 50.4 | 64.7372654155496 | 115 | 50 | 91.7 | 2 | 372 | 31 | 2524 | 2632 | OCT97315.1 hypothetical protein XELAEV_18009541mg [Xenopus laevis] | diamond | 24147 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 30224379 | 30224379 | PRJNA1020641_P_NODE_3852_length_311_cov_0.970588_g3809_i0 | PRJNA1020641 | 3852 | 311 | 0.970588 | 3.01852868 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 86.3 | 3.74e-17 | NR | XP_029194785.1 | 45264 | g3809 | i0 | 48.8 | 2.52733118971061 | 80 | 38 | 77.2 | 2 | 51 | 290 | 193 | 269 | XP_029194785.1 LOW QUALITY PROTEIN: intraflagellar transport protein 52 homolog [Acropora millepora] | diamond | 786 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 30571779 | 30571779 | PRJNA1020641_P_NODE_1653_length_474_cov_1.129676_g1610_i0 | PRJNA1020641 | 1653 | 474 | 1.129676 | 5.35466424 | Leucoraja erinaceus | 7782 | Chordata | Chordata | 47.8 | 0.00515 | NR | XP_055487001.1 | 7782 | g1610 | i0 | 48.5 | 1.4746835443038 | 66 | 30 | 40.5 | 3 | 51 | 242 | 152 | 215 | XP_055487001.1 E3 ubiquitin-protein ligase TRIM47-like isoform X1 [Leucoraja erinaceus] | diamond | 699 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 30919739 | 30919739 | PRJNA1020641_P_NODE_7294_length_242_cov_0.911243_g7251_i0 | PRJNA1020641 | 7294 | 242 | 0.911243 | 2.20520806 | Agrilus planipennis | 224129 | Arthropoda | Arthropoda | 82.4 | 4.06e-16 | NR | XP_025837070.1 | 224129 | g7251 | i0 | 54.7 | 5.62809917355372 | 75 | 21 | 93 | 1 | 10 | 234 | 1369 | 1430 | XP_025837070.1 dynein heavy chain 3, axonemal isoform X3 [Agrilus planipennis] | diamond | 1362 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Buprestidae | Agrilus | Agrilus planipennis | |
| 31235387 | 31235387 | PRJNA1020641_P_NODE_5515_length_251_cov_0.865169_g5472_i0 | PRJNA1020641 | 5515 | 251 | 0.865169 | 2.17157419 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 51.2 | 4.28e-5 | NR | CAF0857574.1 | 433720 | g5472 | i0 | 51.2 | 0.51394422310757 | 43 | 21 | 51.4 | 0 | 2 | 130 | 468 | 510 | CAF0857574.1 unnamed protein product [Adineta steineri] | diamond | 129 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31393872 | 31393872 | PRJNA1020641_P_NODE_6316_length_247_cov_0.885057_g6273_i0 | PRJNA1020641 | 6316 | 247 | 0.885057 | 2.18609079 | Loa loa | 7209 | Nematoda | Nematoda | 62.8 | 3.29e-9 | NR | XP_003137764.1 | 7209 | g6273 | i0 | 43 | 1.04453441295547 | 86 | 31 | 99.6 | 3 | 1 | 246 | 219 | 290 | XP_003137764.1 hypothetical protein LOAG_02178 [Loa loa] | diamond | 258 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 31638821 | 31638821 | PRJNA1020641_P_NODE_4136_length_299_cov_0.876106_g4093_i0 | PRJNA1020641 | 4136 | 299 | 0.876106 | 2.61955694 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 108 | 4.01e-25 | NR | CAG5091339.1 | 34765 | g4093 | i0 | 54.5 | 13.0234113712375 | 99 | 43 | 97.3 | 1 | 1 | 291 | 29 | 127 | CAG5091339.1 Oidioi.mRNA.OKI2018_I69.PAR.g12983.t2.cds [Oikopleura dioica] | diamond | 3894 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 31923566 | 31923566 | PRJNA1020641_P_NODE_6557_length_246_cov_0.890173_g6514_i0 | PRJNA1020641 | 6557 | 246 | 0.890173 | 2.18982558 | Hemiptera | 7524 | Arthropoda | Arthropoda | 97.8 | 1.68e-21 | NR | XKL59431.1 | 473130 | g6514 | i0 | 56.8 | 5.81707317073171 | 81 | 35 | 98.8 | 0 | 1 | 243 | 513 | 593 | XKL59431.1 hypothetical protein PGB90_000447 [Kerria lacca] | diamond | 1431 | 98.2 | 0.995926680244399 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Tachardiidae | Kerria | Kerria lacca | |
| 32057961 | 32057961 | PRJNA1020641_P_NODE_6758_length_245_cov_0.895349_g6715_i0 | PRJNA1020641 | 6758 | 245 | 0.895349 | 2.19360505 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 42.7 | 0.0384 | NR | XP_028398983.1 | 151771 | g6715 | i0 | 38 | 0.612244897959184 | 50 | 31 | 61.2 | 0 | 227 | 78 | 175 | 224 | XP_028398983.1 uncharacterized protein LOC114522489 isoform X2 [Dendronephthya gigantea] | diamond | 150 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 32152938 | 32152938 | PRJNA1020641_P_NODE_7278_length_242_cov_0.911243_g7235_i0 | PRJNA1020641 | 7278 | 242 | 0.911243 | 2.20520806 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 70.9 | 3.73e-12 | NR | CAF1387172.1 | 392033 | g7235 | i0 | 48.4 | 4.89669421487603 | 64 | 31 | 76.9 | 1 | 197 | 12 | 198 | 261 | CAF1387172.1 unnamed protein product [Rotaria sordida] | diamond | 1185 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32279690 | 32279690 | PRJNA1020641_P_NODE_6919_length_244_cov_0.900585_g6876_i0 | PRJNA1020641 | 6919 | 244 | 0.900585 | 2.1974274 | Miniopterus natalensis | 291302 | Chordata | Chordata | 73.9 | 3.55e-13 | NR | XP_016074710.1 | 291302 | g6876 | i0 | 48 | 0.922131147540984 | 75 | 39 | 92.2 | 0 | 15 | 239 | 88 | 162 | XP_016074710.1 PREDICTED: actin-related protein T2 [Miniopterus natalensis] | diamond | 225 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Miniopteridae | Miniopterus | Miniopterus natalensis | |
| 32374550 | 32374550 | PRJNA1020641_P_NODE_6459_length_246_cov_0.890173_g6416_i0 | PRJNA1020641 | 6459 | 246 | 0.890173 | 2.18982558 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 76.6 | 4.43e-14 | NR | XP_036077575.1 | 9407 | g6416 | i0 | 47.9 | 2.48780487804878 | 73 | 34 | 89 | 1 | 230 | 12 | 65 | 133 | XP_036077575.1 kinesin-like protein KIF18A isoform X2 [Rousettus aegyptiacus] | diamond | 612 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 32690083 | 32690083 | PRJNA1020641_P_NODE_5380_length_254_cov_1.309392_g5337_i0 | PRJNA1020641 | 5380 | 254 | 1.309392 | 3.32585568 | Ranitomeya imitator | 111125 | Chordata | Chordata | 45.4 | 0.00433 | NR | CAJ0956274.1 | 111125 | g5337 | i0 | 50 | 0.838582677165354 | 34 | 17 | 40.2 | 0 | 102 | 1 | 1 | 34 | CAJ0956274.1 unnamed protein product [Ranitomeya imitator] | diamond | 213 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator |
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);;