contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA685060" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5769771 | 5769771 | PRJNA685060_P_NODE_13945_length_250_cov_0.870056_g13855_i0 | PRJNA685060 | 13945 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 140 | 6.38e-39 | NR | XP_031554427.1 | 6105 | g13855 | i0 | 81.9 | 5.976 | 83 | 15 | 99.6 | 0 | 249 | 1 | 140 | 222 | XP_031554427.1 mitochondrial 2-oxoglutarate/malate carrier protein-like isoform X1 [Actinia tenebrosa] | diamond | 1494 | 141 | 0.99290780141844 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 26702180 | 26702180 | PRJNA685060_P_NODE_5361_length_415_cov_1.347953_g5271_i0 | PRJNA685060 | 5361 | 415 | 1.347953 | 5.59400495 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 66.6 | 1.17e-9 | NR | XP_068729214.1 | 246305 | g5271 | i0 | 47.1 | 1.95903614457831 | 51 | 27 | 36.9 | 0 | 3 | 155 | 97 | 147 | XP_068729214.1 polycystin-1-like protein 2 isoform X2 [Montipora capricornis] | diamond | 813 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 27808981 | 27808981 | PRJNA685060_P_NODE_7324_length_352_cov_1.053763_g7234_i0 | PRJNA685060 | 7324 | 352 | 1.053763 | 3.70924576 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 127 | 2.03e-33 | NR | XP_057298340.1 | 13093 | g7234 | i0 | 58.5 | 3.01704545454545 | 118 | 47 | 98.9 | 1 | 2 | 349 | 46 | 163 | XP_057298340.1 uncharacterized protein K02A2.6-like [Hydractinia symbiolongicarpus] | diamond | 1062 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 28009981 | 28009981 | PRJNA685060_P_NODE_5605_length_405_cov_1.936747_g5515_i0 | PRJNA685060 | 5605 | 405 | 1.936747 | 7.84382535 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 95.9 | 2.26e-22 | NR | XP_031572029.1 | 6105 | g5515 | i0 | 50.9 | 2.17037037037037 | 106 | 48 | 78.5 | 1 | 77 | 394 | 15 | 116 | XP_031572029.1 keratinocyte-associated protein 2-like [Actinia tenebrosa] | diamond | 879 | 96.3 | 0.995846313603323 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28136222 | 28136222 | PRJNA685060_P_NODE_5465_length_411_cov_1.331361_g5375_i0 | PRJNA685060 | 5465 | 411 | 1.331361 | 5.47189371 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 117 | 4.86e-28 | NR | XP_015748371.1 | 70779 | g5375 | i0 | 44.6 | 1.94890510948905 | 130 | 70 | 94.9 | 2 | 19 | 408 | 272 | 399 | XP_015748371.1 PREDICTED: gastric triacylglycerol lipase-like [Acropora digitifera] | diamond | 801 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 28136223 | 28136223 | PRJNA685060_P_NODE_7325_length_352_cov_0.989247_g7235_i0 | PRJNA685060 | 7325 | 352 | 0.989247 | 3.48214944 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 159 | 8.14e-45 | NR | KAK2570543.1 | 6130 | g7235 | i0 | 71.1 | 12.2471590909091 | 97 | 28 | 82.7 | 0 | 294 | 4 | 259 | 355 | KAK2570543.1 Histone-binding protein RBBP7 [Acropora cervicornis] | diamond | 4311 | 160 | 0.99375 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28451961 | 28451961 | PRJNA685060_P_NODE_12546_length_261_cov_1.638298_g12456_i0 | PRJNA685060 | 12546 | 261 | 1.638298 | 4.27595778 | Montipora | 46703 | Cnidaria | other_Eukaryota | 60.8 | 1.87e-8 | NR | XP_068726382.1 | 246305 | g12456 | i0 | 52.9 | 2.60919540229885 | 51 | 24 | 58.6 | 0 | 109 | 261 | 21 | 71 | XP_068726382.1 uncharacterized protein [Montipora capricornis] | diamond | 681 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 28661338 | 28661338 | PRJNA685060_P_NODE_9907_length_300_cov_1.356828_g9817_i0 | PRJNA685060 | 9907 | 300 | 1.356828 | 4.070484 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 43.5 | 0.0385 | NR | XP_020894054.1 | 2652724 | g9817 | i0 | 31.4 | 1.05 | 105 | 62 | 98 | 3 | 299 | 6 | 575 | 676 | XP_020894054.1 cleavage and polyadenylation specificity factor subunit 3 [Exaiptasia diaphana] | diamond | 315 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 28736002 | 28736002 | PRJNA685060_P_NODE_17147_length_242_cov_0.911243_g17057_i0 | PRJNA685060 | 17147 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 62.4 | 4.28e-9 | NR | CAB4012364.1 | 317549 | g17057 | i0 | 58 | 1.2396694214876 | 50 | 16 | 62 | 1 | 3 | 152 | 471 | 515 | CAB4012364.1 FAD synthase-like [Paramuricea clavata] | diamond | 300 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 29008906 | 29008906 | PRJNA685060_P_NODE_7288_length_352_cov_2.623656_g7198_i0 | PRJNA685060 | 7288 | 352 | 2.623656 | 9.23526912 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 102 | 1.07e-22 | NR | KAK3752022.1 | 3060491 | g7198 | i0 | 45.6 | 2.52272727272727 | 103 | 52 | 84.4 | 1 | 54 | 350 | 5 | 107 | KAK3752022.1 hypothetical protein QZH41_009342 [Actinostola sp. cb2023] | diamond | 888 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 29576633 | 29576633 | PRJNA685060_P_NODE_3350_length_539_cov_1.896996_g3260_i0 | PRJNA685060 | 3350 | 539 | 1.896996 | 10.22480844 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 142 | 6.449999999999999e-37 | NR | XP_046846730.1 | 2897299 | g3260 | i0 | 48 | 0.846011131725417 | 152 | 79 | 84.6 | 0 | 2 | 457 | 204 | 355 | XP_046846730.1 histone acetyltransferase type B catalytic subunit-like [Xenia sp. Carnegie-2017] | diamond | 456 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 30493023 | 30493023 | PRJNA685060_P_NODE_6533_length_373_cov_2.050000_g6443_i0 | PRJNA685060 | 6533 | 373 | 2.05 | 7.6465 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 82.8 | 8.43e-16 | NR | XP_066935725.1 | 252671 | g6443 | i0 | 39.7 | 1.81769436997319 | 116 | 59 | 92.5 | 2 | 12 | 356 | 154 | 259 | XP_066935725.1 chymotrypsinogen B-like [Clytia hemisphaerica] | diamond | 678 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 30599182 | 30599182 | PRJNA685060_P_NODE_7313_length_352_cov_1.161290_g7223_i0 | PRJNA685060 | 7313 | 352 | 1.16129 | 4.0877408 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 51.6 | 9.47e-5 | NR | KAK2560383.1 | 6130 | g7223 | i0 | 67.7 | 1.34659090909091 | 31 | 10 | 26.4 | 0 | 351 | 259 | 385 | 415 | KAK2560383.1 Bis(5'-adenosyl)-triphosphatase enpp4 [Acropora cervicornis] | diamond | 474 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 30650685 | 30650685 | PRJNA685060_P_NODE_5713_length_402_cov_0.933131_g5623_i0 | PRJNA685060 | 5713 | 402 | 0.933131 | 3.75118662 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 69.7 | 2.37e-11 | NR | XP_020896889.1 | 2652724 | g5623 | i0 | 31 | 0.865671641791045 | 116 | 80 | 86.6 | 0 | 20 | 367 | 82 | 197 | XP_020896889.1 COP9 signalosome complex subunit 3 [Exaiptasia diaphana] | diamond | 348 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 30725636 | 30725636 | PRJNA685060_P_NODE_17934_length_225_cov_4.552632_g17844_i0 | PRJNA685060 | 17934 | 225 | 4.552632 | 10.243422 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 50.4 | 5.44e-5 | NR | EDO38521.1 | 45351 | g17844 | i0 | 47.8 | 1.86666666666667 | 46 | 24 | 61.3 | 0 | 223 | 86 | 398 | 443 | EDO38521.1 predicted protein [Nematostella vectensis] | diamond | 420 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31757348 | 31757348 | PRJNA685060_P_NODE_4977_length_432_cov_1.754875_g4887_i0 | PRJNA685060 | 4977 | 432 | 1.754875 | 7.58106 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 136 | 1.0699999999999999e-34 | NR | XP_027043473.1 | 46731 | g4887 | i0 | 52.7 | 2.9375 | 131 | 59 | 88.9 | 1 | 1 | 384 | 54 | 184 | XP_027043473.1 protein disulfide-isomerase 2-like [Pocillopora damicornis] | diamond | 1269 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 31895483 | 31895483 | PRJNA685060_P_NODE_8317_length_330_cov_0.898833_g8227_i0 | PRJNA685060 | 8317 | 330 | 0.898833 | 2.9661489 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 53.1 | 2.23e-5 | NR | XP_031551888.1 | 6105 | g8227 | i0 | 30.5 | 4.66363636363636 | 105 | 65 | 95.5 | 2 | 322 | 8 | 555 | 651 | XP_031551888.1 poly(A) RNA polymerase GLD2-like isoform X2 [Actinia tenebrosa] | diamond | 1539 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 31915478 | 31915478 | PRJNA685060_P_NODE_11557_length_275_cov_1.282178_g11467_i0 | PRJNA685060 | 11557 | 275 | 1.282178 | 3.5259895 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 139 | 8.49e-36 | NR | XP_066921834.1 | 252671 | g11467 | i0 | 67 | 0.992727272727273 | 91 | 30 | 99.3 | 0 | 3 | 275 | 737 | 827 | XP_066921834.1 dipeptidyl peptidase 9-like [Clytia hemisphaerica] | diamond | 273 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 32022093 | 32022093 | PRJNA685060_P_NODE_5398_length_413_cov_2.200000_g5308_i0 | PRJNA685060 | 5398 | 413 | 2.2 | 9.086 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 121 | 1.73e-29 | NR | XP_048584372.1 | 45351 | g5308 | i0 | 43 | 3.86440677966102 | 135 | 77 | 98.1 | 0 | 412 | 8 | 70 | 204 | XP_048584372.1 ankyrin repeat domain-containing protein 13C [Nematostella vectensis] | diamond | 1596 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32243885 | 32243885 | PRJNA685060_P_NODE_8738_length_321_cov_1.939516_g8648_i0 | PRJNA685060 | 8738 | 321 | 1.939516 | 6.22584636 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 124 | 3.91e-33 | NR | XP_065669526.1 | 6087 | g8648 | i0 | 59.6 | 4.45794392523364 | 94 | 37 | 87.9 | 1 | 282 | 1 | 9 | 101 | XP_065669526.1 PITH domain-containing protein 1 isoform X2 [Hydra vulgaris] | diamond | 1431 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32548610 | 32548610 | PRJNA685060_P_NODE_8539_length_325_cov_1.234127_g8449_i0 | PRJNA685060 | 8539 | 325 | 1.234127 | 4.01091275 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 44.7 | 0.0206 | NR | XP_031571620.1 | 6105 | g8449 | i0 | 30.5 | 0.876923076923077 | 95 | 54 | 81.2 | 3 | 308 | 45 | 824 | 913 | XP_031571620.1 5'-3' exoribonuclease 1-like [Actinia tenebrosa] | diamond | 285 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32622880 | 32622880 | PRJNA685060_P_NODE_13600_length_251_cov_0.865169_g13510_i0 | PRJNA685060 | 13600 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.7 | 1.8e-21 | NR | RMX51371.1 | 46731 | g13510 | i0 | 50 | 7.31474103585657 | 90 | 38 | 99.2 | 2 | 2 | 250 | 8 | 97 | RMX51371.1 hypothetical protein pdam_00011379 [Pocillopora damicornis] | diamond | 1836 | 92 | 0.996739130434783 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 32654137 | 32654137 | PRJNA685060_P_NODE_4880_length_437_cov_1.736264_g4790_i0 | PRJNA685060 | 4880 | 437 | 1.736264 | 7.5874736800000004 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 47.8 | 0.00435 | NR | CAH3192567.1 | 104178 | g4790 | i0 | 51.4 | 0.803203661327231 | 35 | 17 | 24 | 0 | 426 | 322 | 118 | 152 | CAH3192567.1 unnamed protein product [Porites evermanni] | diamond | 351 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni |
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);;