contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3475630 | 3475630 | PRJNA944406_P_NODE_75763_length_248_cov_1.760000_g74804_i0 | PRJNA944406 | 75763 | 248 | 1.76 | 4.3648 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 137 | 3.799999999999999e-38 | NR | XP_047129295.1 | 6087 | g74804 | i0 | 74.4 | 19.8387096774194 | 82 | 21 | 99.2 | 0 | 1 | 246 | 137 | 218 | XP_047129295.1 peroxiredoxin-4 [Hydra vulgaris] | diamond | 4920 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 7302518 | 7302518 | PRJNA944406_P_NODE_35526_length_277_cov_1.161765_g34567_i0 | PRJNA944406 | 35526 | 277 | 1.161765 | 3.21808905 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 140 | 1.95e-37 | NR | XP_031569420.1 | 6105 | g34567 | i0 | 79.1 | 22.7003610108303 | 91 | 19 | 98.6 | 0 | 2 | 274 | 289 | 379 | XP_031569420.1 S-adenosylmethionine synthase-like isoform X1 [Actinia tenebrosa] | diamond | 6288 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 26715129 | 26715129 | PRJNA944406_P_NODE_45981_length_267_cov_1.345361_g45022_i0 | PRJNA944406 | 45981 | 267 | 1.345361 | 3.59211387 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.2 | 1.57e-7 | NR | EDO38942.1 | 45351 | g45022 | i0 | 37.4 | 4.12359550561798 | 91 | 54 | 98.9 | 2 | 266 | 3 | 184 | 274 | EDO38942.1 predicted protein [Nematostella vectensis] | diamond | 1101 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 26739977 | 26739977 | PRJNA944406_P_NODE_105501_length_242_cov_0.911243_g104542_i0 | PRJNA944406 | 105501 | 242 | 0.911243 | 2.20520806 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 47 | 0.0012 | NR | CAH3123386.1 | 104759 | g104542 | i0 | 72 | 0.309917355371901 | 25 | 7 | 31 | 0 | 98 | 172 | 305 | 329 | CAH3123386.1 unnamed protein product [Porites lobata] | diamond | 75 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 26746805 | 26746805 | PRJNA944406_P_NODE_20061_length_295_cov_1.373874_g19102_i0 | PRJNA944406 | 20061 | 295 | 1.373874 | 4.0529283 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.0109 | NR | CAB4009898.1 | 317549 | g19102 | i0 | 33.9 | 6.52881355932203 | 62 | 33 | 63.1 | 1 | 222 | 37 | 956 | 1009 | CAB4009898.1 RING finger and CHY zinc finger domain-containing 1-like [Paramuricea clavata] | diamond | 1926 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 26803691 | 26803691 | PRJNA944406_P_NODE_46781_length_266_cov_1.595855_g45822_i0 | PRJNA944406 | 46781 | 266 | 1.595855 | 4.2449743 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 106 | 1.29e-25 | NR | KAK3747778.1 | 3060491 | g45822 | i0 | 61.4 | 9.82330827067669 | 88 | 34 | 99.2 | 0 | 3 | 266 | 63 | 150 | KAK3747778.1 hypothetical protein QZH41_008805 [Actinostola sp. cb2023] | diamond | 2613 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 27119842 | 27119842 | PRJNA944406_P_NODE_11302_length_372_cov_1.030100_g10343_i0 | PRJNA944406 | 11302 | 372 | 1.0301 | 3.831972 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 55.1 | 7.76e-6 | NR | KAK3727404.1 | 3060491 | g10343 | i0 | 56.8 | 0.354838709677419 | 44 | 19 | 35.5 | 0 | 122 | 253 | 685 | 728 | KAK3727404.1 hypothetical protein QZH41_020065 [Actinostola sp. cb2023] | diamond | 132 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 27878173 | 27878173 | PRJNA944406_P_NODE_19005_length_301_cov_2.407895_g18046_i0 | PRJNA944406 | 19005 | 301 | 2.407895 | 7.24776395 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 80.1 | 5.31e-15 | NR | XP_057312408.1 | 13093 | g18046 | i0 | 55.7 | 1.3953488372093 | 70 | 31 | 69.8 | 0 | 3 | 212 | 394 | 463 | XP_057312408.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 1-like [Hydractinia symbiolongicarpus] | diamond | 420 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 28200491 | 28200491 | PRJNA944406_P_NODE_69706_length_250_cov_0.870056_g68747_i0 | PRJNA944406 | 69706 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 108 | 1.61e-26 | NR | XP_020619658.1 | 48498 | g68747 | i0 | 61.4 | 9.96 | 83 | 32 | 99.6 | 0 | 1 | 249 | 143 | 225 | XP_020619658.1 uncharacterized protein LOC110057413 [Orbicella faveolata] | diamond | 2490 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 28856821 | 28856821 | PRJNA944406_P_NODE_49488_length_263_cov_2.915789_g48529_i0 | PRJNA944406 | 49488 | 263 | 2.915789 | 7.66852507 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 54.3 | 3.35e-6 | NR | XP_031558128.1 | 6105 | g48529 | i0 | 40.8 | 3.19391634980989 | 71 | 40 | 78.7 | 1 | 8 | 214 | 33 | 103 | XP_031558128.1 FK506-binding protein 4-like [Actinia tenebrosa] | diamond | 840 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29211235 | 29211235 | PRJNA944406_P_NODE_111469_length_235_cov_2.487654_g110510_i0 | PRJNA944406 | 111469 | 235 | 2.487654 | 5.8459869 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 80.9 | 1.15e-15 | NR | XP_032241858.2 | 45351 | g110510 | i0 | 52.1 | 10.5574468085106 | 71 | 34 | 90.6 | 0 | 21 | 233 | 263 | 333 | XP_032241858.2 protein phosphatase 1E [Nematostella vectensis] | diamond | 2481 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 29393850 | 29393850 | PRJNA944406_P_NODE_47589_length_265_cov_1.859375_g46630_i0 | PRJNA944406 | 47589 | 265 | 1.859375 | 4.92734375 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 69.7 | 1.59e-11 | NR | EDO31677.1 | 45351 | g46630 | i0 | 44.9 | 1.76603773584906 | 78 | 41 | 87.2 | 2 | 2 | 232 | 95 | 171 | EDO31677.1 predicted protein [Nematostella vectensis] | diamond | 468 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 29835741 | 29835741 | PRJNA944406_P_NODE_47611_length_265_cov_1.703125_g46652_i0 | PRJNA944406 | 47611 | 265 | 1.703125 | 4.51328125 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 75.9 | 9.93e-14 | NR | XP_047127863.1 | 6087 | g46652 | i0 | 47.3 | 1.03018867924528 | 91 | 42 | 99.6 | 3 | 2 | 265 | 298 | 385 | XP_047127863.1 putative kinase HI_0665 isoform X1 [Hydra vulgaris] | diamond | 273 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29930766 | 29930766 | PRJNA944406_P_NODE_82111_length_247_cov_0.885057_g81152_i0 | PRJNA944406 | 82111 | 247 | 0.885057 | 2.18609079 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 65.1 | 5.04e-10 | NR | XP_068684338.1 | 591990 | g81152 | i0 | 73 | 1.34817813765182 | 37 | 10 | 44.9 | 0 | 135 | 245 | 516 | 552 | XP_068684338.1 uncharacterized protein [Montipora foliosa] | diamond | 333 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 30088496 | 30088496 | PRJNA944406_P_NODE_73392_length_249_cov_0.875000_g72433_i0 | PRJNA944406 | 73392 | 249 | 0.875 | 2.17875 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 44.3 | 0.0116 | NR | KXJ16858.1 | 2652724 | g72433 | i0 | 43.5 | 2.24096385542169 | 62 | 25 | 65.1 | 4 | 74 | 235 | 930 | 989 | KXJ16858.1 Collagen alpha-6(VI) chain [Exaiptasia diaphana] | diamond | 558 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 30119966 | 30119966 | PRJNA944406_P_NODE_109892_length_241_cov_0.916667_g108933_i0 | PRJNA944406 | 109892 | 241 | 0.916667 | 2.20916747 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 97.8 | 5.31e-22 | NR | CAB4004515.1 | 317549 | g108933 | i0 | 61.4 | 7.81742738589212 | 70 | 27 | 87.1 | 0 | 210 | 1 | 58 | 127 | CAB4004515.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 1884 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30214747 | 30214747 | PRJNA944406_P_NODE_70912_length_250_cov_0.870056_g69953_i0 | PRJNA944406 | 70912 | 250 | 0.870056 | 2.17514 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 44.3 | 0.00978 | NR | CAB4039092.1 | 317549 | g69953 | i0 | 49 | 0.588 | 49 | 23 | 58.8 | 2 | 42 | 188 | 133 | 179 | CAB4039092.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 147 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30632220 | 30632220 | PRJNA944406_P_NODE_50793_length_262_cov_1.666667_g49834_i0 | PRJNA944406 | 50793 | 262 | 1.666667 | 4.36666754 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 97.8 | 7.000000000000001e-23 | NR | XP_020627673.1 | 48498 | g49834 | i0 | 52.3 | 5.04961832061069 | 88 | 40 | 99.6 | 2 | 262 | 2 | 97 | 183 | XP_020627673.1 protein zer-1 homolog [Orbicella faveolata] | diamond | 1323 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 30846835 | 30846835 | PRJNA944406_P_NODE_79034_length_248_cov_0.880000_g78075_i0 | PRJNA944406 | 79034 | 248 | 0.88 | 2.1824 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 44.3 | 0.0113 | NR | KAJ7331180.1 | 174260 | g78075 | i0 | 31.2 | 0.931451612903226 | 77 | 45 | 84.7 | 2 | 14 | 223 | 430 | 505 | KAJ7331180.1 hypothetical protein OS493_020883 [Desmophyllum pertusum] | diamond | 231 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 31637070 | 31637070 | PRJNA944406_P_NODE_18916_length_302_cov_1.585153_g17957_i0 | PRJNA944406 | 18916 | 302 | 1.585153 | 4.78716206 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 63.5 | 1.5e-10 | NR | CAH3027012.1 | 104178 | g17957 | i0 | 54.7 | 0.526490066225166 | 53 | 24 | 52.6 | 0 | 3 | 161 | 52 | 104 | CAH3027012.1 unnamed protein product [Porites evermanni] | diamond | 159 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 31991834 | 31991834 | PRJNA944406_P_NODE_24518_length_287_cov_1.439252_g23559_i0 | PRJNA944406 | 24518 | 287 | 1.439252 | 4.13065324 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 115 | 2.4e-27 | NR | CAH3196117.1 | 104178 | g23559 | i0 | 58.6 | 7.36933797909408 | 87 | 36 | 90.9 | 0 | 23 | 283 | 241 | 327 | CAH3196117.1 unnamed protein product [Porites evermanni] | diamond | 2115 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 32175158 | 32175158 | PRJNA944406_P_NODE_105178_length_242_cov_0.911243_g104219_i0 | PRJNA944406 | 105178 | 242 | 0.911243 | 2.20520806 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 73.2 | 1.67e-14 | NR | XP_068707130.1 | 591990 | g104219 | i0 | 58.1 | 3.83057851239669 | 62 | 26 | 76.9 | 0 | 242 | 57 | 7 | 68 | XP_068707130.1 large ribosomal subunit protein P1-like [Montipora foliosa] | diamond | 927 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 32428193 | 32428193 | PRJNA944406_P_NODE_27719_length_284_cov_1.459716_g26760_i0 | PRJNA944406 | 27719 | 284 | 1.459716 | 4.14559344 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 89.7 | 1.52e-19 | NR | XP_028400666.1 | 151771 | g26760 | i0 | 56.2 | 3.88732394366197 | 89 | 38 | 94 | 1 | 268 | 2 | 146 | 233 | XP_028400666.1 60S ribosomal protein L6-like [Dendronephthya gigantea] | diamond | 1104 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 32459914 | 32459914 | PRJNA944406_P_NODE_82479_length_247_cov_0.885057_g81520_i0 | PRJNA944406 | 82479 | 247 | 0.885057 | 2.18609079 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 56.6 | 5.28e-7 | NR | XP_066920325.1 | 252671 | g81520 | i0 | 65.7 | 1.16599190283401 | 35 | 12 | 42.5 | 0 | 2 | 106 | 2536 | 2570 | XP_066920325.1 uncharacterized protein [Clytia hemisphaerica] | diamond | 288 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 32900981 | 32900981 | PRJNA944406_P_NODE_97360_length_243_cov_2.223529_g96401_i0 | PRJNA944406 | 97360 | 243 | 2.223529 | 5.40317547 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 43.1 | 0.0241 | NR | RMX56984.1 | 46731 | g96401 | i0 | 29 | 1.44444444444444 | 62 | 44 | 76.5 | 0 | 240 | 55 | 10 | 71 | RMX56984.1 hypothetical protein pdam_00025533 [Pocillopora damicornis] | diamond | 351 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis |
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);;