contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1146366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 290314 | 290314 | PRJNA1146366_S_NODE_801_length_342_cov_13.111524_g798_i0 | PRJNA1146366 | 801 | 342 | 13.111524 | 44.84141208 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 166 | 4.54e-51 | NR | XP_002164628.1 | 6087 | g798 | i0 | 85.9 | 0.807017543859649 | 92 | 13 | 80.7 | 0 | 293 | 18 | 1 | 92 | XP_002164628.1 large ribosomal subunit protein eL43 isoform X1 [Hydra vulgaris] | diamond | 276 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 1564933 | 1564933 | PRJNA1146366_S_NODE_322_length_431_cov_3.494413_g319_i0 | PRJNA1146366 | 322 | 431 | 3.494413 | 15.06092003 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 85.5 | 1.32e-18 | NR | KAK3742108.1 | 3060491 | g319 | i0 | 56.8 | 1.53828306264501 | 74 | 30 | 50.1 | 1 | 102 | 317 | 24 | 97 | KAK3742108.1 hypothetical protein QZH41_020264 [Actinostola sp. cb2023] | diamond | 663 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 6136527 | 6136527 | PRJNA1146366_S_NODE_365_length_416_cov_10.169096_g362_i0 | PRJNA1146366 | 365 | 416 | 10.169096 | 42.30343936 | Ochotona princeps | 9978 | Chordata | Chordata | 72.8 | 3.68e-14 | NR | XP_058514412.1 | 9978 | g362 | i0 | 74 | 1.75240384615385 | 50 | 13 | 36.1 | 0 | 78 | 227 | 3 | 52 | XP_058514412.1 thymosin beta-15A isoform X1 [Ochotona princeps] | diamond | 729 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Ochotonidae | Ochotona | Ochotona princeps | |
| 19416384 | 19416384 | PRJNA1146366_S_NODE_396_length_408_cov_11.465672_g393_i0 | PRJNA1146366 | 396 | 408 | 11.465672 | 46.77994176 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 81.3 | 4.81e-17 | NR | XP_057302225.1 | 13093 | g393 | i0 | 45.4 | 0.713235294117647 | 97 | 44 | 64.7 | 3 | 315 | 52 | 1 | 97 | XP_057302225.1 U8-theraphotoxin-Hhn1c 3-like [Hydractinia symbiolongicarpus] | diamond | 291 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 24516208 | 24516208 | PRJNA1146366_S_NODE_1360_length_295_cov_16.072072_g1357_i0 | PRJNA1146366 | 1360 | 295 | 16.072072 | 47.4126124 | Metazoa | 33208 | Arthropoda | Arthropoda | 98.2 | 3.519999999999999e-23 | NR | ERL91937.1 | 77166 | g1357 | i0 | 80 | 12.2847457627119 | 55 | 11 | 55.9 | 0 | 61 | 225 | 140 | 194 | ERL91937.1 hypothetical protein D910_09260 [Dendroctonus ponderosae] | diamond | 3624 | 98.6 | 0.995943204868154 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Curculionidae | Dendroctonus | Dendroctonus ponderosae | |
| 24516211 | 24516211 | PRJNA1146366_S_NODE_1620_length_279_cov_2.766990_g1617_i0 | PRJNA1146366 | 1620 | 279 | 2.76699 | 7.7199021 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 94.7 | 1.8299999999999994e-23 | NR | CAB3982470.1 | 317549 | g1617 | i0 | 80.7 | 8.62365591397849 | 57 | 11 | 61.3 | 0 | 88 | 258 | 1 | 57 | CAB3982470.1 60S ribosomal L29 [Paramuricea clavata] | diamond | 2406 | 95.5 | 0.991623036649215 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 24516228 | 24516228 | PRJNA1146366_S_NODE_820_length_340_cov_9.872659_g817_i0 | PRJNA1146366 | 820 | 340 | 9.872659 | 33.5670406 | Acanthocheilonema viteae | 6277 | Nematoda | Nematoda | 109 | 3.81e-25 | NR | VBB29199.1 | 6277 | g817 | i0 | 78.6 | 4.80882352941176 | 56 | 12 | 49.4 | 0 | 283 | 116 | 65 | 120 | VBB29199.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 1635 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 26647757 | 26647757 | PRJNA1146366_S_NODE_501_length_387_cov_11.662420_g498_i0 | PRJNA1146366 | 501 | 387 | 11.66242 | 45.1335654 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 4.29e-5 | NR | GBN61280.1 | 182803 | g498 | i0 | 50.9 | 4.25581395348837 | 53 | 26 | 41.1 | 0 | 262 | 104 | 1136 | 1188 | GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] | diamond | 1647 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 26721957 | 26721957 | PRJNA1146366_S_NODE_1961_length_262_cov_2.724868_g1958_i0 | PRJNA1146366 | 1961 | 262 | 2.724868 | 7.13915416 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 118 | 1.11e-30 | NR | XP_066913556.1 | 252671 | g1958 | i0 | 71.1 | 1.03053435114504 | 90 | 23 | 99.6 | 1 | 2 | 262 | 164 | 253 | XP_066913556.1 uncharacterized protein [Clytia hemisphaerica] | diamond | 270 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 27165248 | 27165248 | PRJNA1146366_S_NODE_1382_length_294_cov_1.058824_g1379_i0 | PRJNA1146366 | 1382 | 294 | 1.058824 | 3.11294256 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 52.4 | 1.88e-5 | NR | XP_066932640.1 | 252671 | g1379 | i0 | 48.1 | 0.551020408163265 | 54 | 28 | 55.1 | 0 | 292 | 131 | 183 | 236 | XP_066932640.1 uncharacterized protein [Clytia hemisphaerica] | diamond | 162 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 27260320 | 27260320 | PRJNA1146366_S_NODE_1003_length_324_cov_3.984064_g1000_i0 | PRJNA1146366 | 1003 | 324 | 3.984064 | 12.90836736 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 65.9 | 2.49e-11 | NR | KAK3730808.1 | 3060491 | g1000 | i0 | 50 | 0.611111111111111 | 66 | 33 | 61.1 | 0 | 302 | 105 | 39 | 104 | KAK3730808.1 hypothetical protein QZH41_001165 [Actinostola sp. cb2023] | diamond | 198 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 28227805 | 28227805 | PRJNA1146366_S_NODE_746_length_351_cov_8.661871_g743_i0 | PRJNA1146366 | 746 | 351 | 8.661871 | 30.40316721 | Metazoa | 33208 | Mollusca | Mollusca | 117 | 7.62e-32 | NR | CAL1530465.1 | 6523 | g743 | i0 | 85.5 | 4.64102564102564 | 69 | 7 | 56.4 | 1 | 74 | 271 | 10 | 78 | CAL1530465.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 1629 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 28365274 | 28365274 | PRJNA1146366_S_NODE_466_length_393_cov_2.659375_g463_i0 | PRJNA1146366 | 466 | 393 | 2.659375 | 10.45134375 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 56.2 | 2.35e-6 | NR | XP_066924927.1 | 252671 | g463 | i0 | 37.9 | 0.66412213740458 | 87 | 45 | 62.6 | 3 | 88 | 333 | 168 | 250 | XP_066924927.1 uncharacterized protein [Clytia hemisphaerica] | diamond | 261 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 28764754 | 28764754 | PRJNA1146366_S_NODE_1767_length_271_cov_4.505051_g1764_i0 | PRJNA1146366 | 1767 | 271 | 4.505051 | 12.20868821 | root | 1 | Root_unresolved | Root_unresolved | 92.4 | 2.88e-22 | NR | KAK2531691.1 | 8932 | g1764 | i0 | 97.8 | 82.859778597786 | 46 | 1 | 50.9 | 0 | 266 | 129 | 22 | 67 | KAK2531691.1 hypothetical protein Q9966_008500 [Columba livia] | diamond | 22455 | 93.2 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Columbiformes | Columbidae | Columba | Columba livia | |
| 28870568 | 28870568 | PRJNA1146366_S_NODE_1108_length_314_cov_1.958506_g1105_i0 | PRJNA1146366 | 1108 | 314 | 1.958506 | 6.14970884 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 107 | 2.32e-27 | NR | XP_029649637.2 | 2607531 | g1105 | i0 | 81 | 3.01910828025478 | 63 | 12 | 60.2 | 0 | 309 | 121 | 62 | 124 | XP_029649637.2 transmembrane protein 258 [Octopus sinensis] | diamond | 948 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 29722854 | 29722854 | PRJNA1146366_S_NODE_2270_length_249_cov_0.886364_g2267_i0 | PRJNA1146366 | 2270 | 249 | 0.886364 | 2.20704636 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 137 | 3.61e-37 | NR | XP_057314052.1 | 13093 | g2267 | i0 | 75.3 | 0.975903614457831 | 81 | 20 | 97.6 | 0 | 243 | 1 | 102 | 182 | XP_057314052.1 uncharacterized protein LOC130655325 isoform X3 [Hydractinia symbiolongicarpus] | diamond | 243 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 30575862 | 30575862 | PRJNA1146366_S_NODE_1993_length_260_cov_2.422460_g1990_i0 | PRJNA1146366 | 1993 | 260 | 2.42246 | 6.298396 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 84.3 | 2.3e-18 | NR | XP_057307294.1 | 13093 | g1990 | i0 | 63.2 | 0.657692307692308 | 57 | 21 | 65.8 | 0 | 244 | 74 | 96 | 152 | XP_057307294.1 28S ribosomal protein S6, mitochondrial-like [Hydractinia symbiolongicarpus] | diamond | 171 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 31176148 | 31176148 | PRJNA1146366_S_NODE_835_length_339_cov_2.616541_g832_i0 | PRJNA1146366 | 835 | 339 | 2.616541 | 8.87007399 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 204 | 2.13e-63 | NR | XP_066933110.1 | 252671 | g832 | i0 | 89.4 | 0.920353982300885 | 104 | 11 | 92 | 0 | 3 | 314 | 28 | 131 | XP_066933110.1 ficolin-1-like [Clytia hemisphaerica] | diamond | 312 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 31714117 | 31714117 | PRJNA1146366_S_NODE_1537_length_284_cov_1.981043_g1534_i0 | PRJNA1146366 | 1537 | 284 | 1.981043 | 5.62616212 | Ciona intestinalis | 7719 | Chordata | Chordata | 60.5 | 1.33e-9 | NR | NP_001177191.1 | 7719 | g1534 | i0 | 68.4 | 0.77112676056338 | 38 | 12 | 40.1 | 0 | 284 | 171 | 49 | 86 | NP_001177191.1 selenoprotein W, 1 [Ciona intestinalis] | diamond | 219 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 32304372 | 32304372 | PRJNA1146366_S_NODE_1659_length_277_cov_2.676471_g1656_i0 | PRJNA1146366 | 1659 | 277 | 2.676471 | 7.41382467 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 72.4 | 2.03e-14 | NR | CAH3174559.1 | 104178 | g1656 | i0 | 44.9 | 2.97833935018051 | 69 | 38 | 74.7 | 0 | 277 | 71 | 6 | 74 | CAH3174559.1 unnamed protein product [Porites evermanni] | diamond | 825 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 32347131 | 32347131 | PRJNA1146366_S_NODE_1379_length_294_cov_1.407240_g1376_i0 | PRJNA1146366 | 1379 | 294 | 1.40724 | 4.1372856 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 90.5 | 1.19e-18 | NR | XP_057303236.1 | 13093 | g1376 | i0 | 43.2 | 2.69387755102041 | 88 | 48 | 88.8 | 2 | 265 | 5 | 19163 | 19249 | XP_057303236.1 uncharacterized protein LOC130640729 isoform X3 [Hydractinia symbiolongicarpus] | diamond | 792 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32442069 | 32442069 | PRJNA1146366_S_NODE_1499_length_287_cov_1.364486_g1496_i0 | PRJNA1146366 | 1499 | 287 | 1.364486 | 3.91607482 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 62.4 | 2.83e-9 | NR | XP_012562072.2 | 6087 | g1496 | i0 | 82.1 | 0.773519163763066 | 39 | 7 | 40.8 | 0 | 169 | 285 | 3 | 41 | XP_012562072.2 cysteinyl leukotriene receptor 1 [Hydra vulgaris] | diamond | 222 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32725803 | 32725803 | PRJNA1146366_S_NODE_2340_length_246_cov_1.445087_g2337_i0 | PRJNA1146366 | 2340 | 246 | 1.445087 | 3.55491402 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 40.8 | 0.0367 | NR | XP_046839560.1 | 2897299 | g2337 | i0 | 39.6 | 0.585365853658537 | 48 | 29 | 58.5 | 0 | 6 | 149 | 36 | 83 | XP_046839560.1 cytochrome c oxidase subunit 7A-related protein, mitochondrial-like [Xenia sp. Carnegie-2017] | diamond | 144 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 32777546 | 32777546 | PRJNA1146366_S_NODE_1340_length_297_cov_1.741071_g1337_i0 | PRJNA1146366 | 1340 | 297 | 1.741071 | 5.17098087 | Metazoa | 33208 | Arthropoda | Arthropoda | 154 | 6.19e-45 | NR | XP_045599629.2 | 6728 | g1337 | i0 | 70.1 | 4.91919191919192 | 97 | 29 | 98 | 0 | 297 | 7 | 20 | 116 | XP_045599629.2 glutathione S-transferase Mu 3 isoform X2 [Procambarus clarkii] | diamond | 1461 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Cambaridae | Procambarus | Procambarus clarkii |
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);;