contig_metadata
27 rows where bioproject = "PRJEB43370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2610172 | 2610172 | PRJEB43370_P_NODE_8943_length_166_cov_0.888889_g8900_i0 | PRJEB43370 | 8943 | 166 | 0.888889 | 1.47555574 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 75.1 | 1.33e-15 | NR | XP_015757388.1 | 70779 | g8900 | i0 | 82.9 | 10.2469879518072 | 41 | 7 | 74.1 | 0 | 1 | 123 | 71 | 111 | XP_015757388.1 PREDICTED: 60S ribosomal protein L30-like [Acropora digitifera] | diamond | 1701 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 4817790 | 4817790 | PRJEB43370_P_NODE_10604_length_162_cov_1.380531_g10561_i0 | PRJEB43370 | 10604 | 162 | 1.380531 | 2.23646022 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 76.3 | 1.38e-14 | NR | XP_027052229.1 | 46731 | g10561 | i0 | 57.4 | 7.90740740740741 | 54 | 23 | 100 | 0 | 162 | 1 | 205 | 258 | XP_027052229.1 guanine nucleotide-binding protein G(o) subunit alpha-like [Pocillopora damicornis] | diamond | 1281 | 77 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 5162569 | 5162569 | PRJEB43370_P_NODE_9325_length_165_cov_0.896552_g9282_i0 | PRJEB43370 | 9325 | 165 | 0.896552 | 1.4793108 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 64.7 | 2.27e-10 | NR | XP_057294980.1 | 13093 | g9282 | i0 | 65 | 0.727272727272727 | 40 | 14 | 72.7 | 0 | 142 | 23 | 98 | 137 | XP_057294980.1 serine/threonine-protein kinase 36-like [Hydractinia symbiolongicarpus] | diamond | 120 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 17567740 | 17567740 | PRJEB43370_P_NODE_3494_length_234_cov_1.702703_g3451_i0 | PRJEB43370 | 3494 | 234 | 1.702703 | 3.98432502 | root | 1 | Root_unresolved | Root_unresolved | 117 | 2.16e-31 | NR | XP_057303614.1 | 13093 | g3451 | i0 | 76.6 | 53.9615384615385 | 77 | 18 | 98.7 | 0 | 232 | 2 | 2 | 78 | XP_057303614.1 60S ribosomal protein L11-like [Hydractinia symbiolongicarpus] | diamond | 12627 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 17911735 | 17911735 | PRJEB43370_P_NODE_1315_length_378_cov_1.407295_g1272_i0 | PRJEB43370 | 1315 | 378 | 1.407295 | 5.3195751 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 191 | 1.13e-59 | NR | XP_065058821.1 | 499914 | g1272 | i0 | 75.4 | 4.82539682539683 | 122 | 30 | 96.8 | 0 | 368 | 3 | 1 | 122 | XP_065058821.1 uncharacterized protein LOC135686503 [Rhopilema esculentum] | diamond | 1824 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 20116485 | 20116485 | PRJEB43370_P_NODE_6856_length_175_cov_1.611111_g6813_i0 | PRJEB43370 | 6856 | 175 | 1.611111 | 2.81944425 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 98.2 | 2.78e-22 | NR | XP_046840745.1 | 2897299 | g6813 | i0 | 77.2 | 1.95428571428571 | 57 | 13 | 97.7 | 0 | 5 | 175 | 209 | 265 | XP_046840745.1 rab GDP dissociation inhibitor beta-like [Xenia sp. Carnegie-2017] | diamond | 342 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 20461005 | 20461005 | PRJEB43370_P_NODE_10797_length_162_cov_0.920354_g10754_i0 | PRJEB43370 | 10797 | 162 | 0.920354 | 1.49097348 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|1778025819|ref|XM_031694191.1| | 6105 | g10754 | i0 | 100 | 0.172839506172839 | 28 | 0 | 17 | 0 | 48 | 75 | 83 | 56 | PREDICTED: Actinia tenebrosa battenin-like (LOC116287508), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 20461008 | 20461008 | PRJEB43370_P_NODE_11077_length_159_cov_2.200000_g11034_i0 | PRJEB43370 | 11077 | 159 | 2.2 | 3.498 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 99 | 1.67e-16 | NTclustered | gi|1778066600|ref|XM_031714937.1| | 6105 | g11034 | i0 | 78.205 | 1.88679245283019 | 156 | 32 | 97 | 2 | 1 | 155 | 545 | 391 | PREDICTED: Actinia tenebrosa ATP synthase subunit beta, mitochondrial (LOC116305101), mRNA | blastn | 300 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27152771 | 27152771 | PRJEB43370_P_NODE_2202_length_292_cov_1.485597_g2159_i0 | PRJEB43370 | 2202 | 292 | 1.485597 | 4.33794324 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 130 | 3.88e-36 | NR | XP_020620004.1 | 48498 | g2159 | i0 | 69.8 | 2.95890410958904 | 96 | 29 | 98.6 | 0 | 289 | 2 | 13 | 108 | XP_020620004.1 60S ribosomal protein L17-like [Orbicella faveolata] | diamond | 864 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 27563660 | 27563660 | PRJEB43370_P_NODE_2644_length_266_cov_1.834101_g2601_i0 | PRJEB43370 | 2644 | 266 | 1.834101 | 4.87870866 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 85.5 | 3.83e-17 | NR | XP_001640172.3 | 45351 | g2601 | i0 | 57.5 | 9.48496240601504 | 73 | 30 | 81.2 | 1 | 51 | 266 | 24 | 96 | XP_001640172.3 calreticulin [Nematostella vectensis] | diamond | 2523 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 28195234 | 28195234 | PRJEB43370_P_NODE_3846_length_225_cov_2.363636_g3803_i0 | PRJEB43370 | 3846 | 225 | 2.363636 | 5.318181 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 107 | 4.33e-26 | NR | XP_031557545.1 | 6105 | g3803 | i0 | 71.2 | 9.82666666666667 | 66 | 19 | 88 | 0 | 202 | 5 | 1 | 66 | XP_031557545.1 receptor of activated protein C kinase 1 [Actinia tenebrosa] | diamond | 2211 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28542952 | 28542952 | PRJEB43370_P_NODE_4567_length_210_cov_1.291925_g4524_i0 | PRJEB43370 | 4567 | 210 | 1.291925 | 2.7130425 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 102 | 3.32e-23 | NR | XP_031563225.1 | 6105 | g4524 | i0 | 66.7 | 112.057142857143 | 69 | 23 | 98.6 | 0 | 1 | 207 | 1057 | 1125 | XP_031563225.1 cullin-associated NEDD8-dissociated protein 1-like isoform X1 [Actinia tenebrosa] | diamond | 23532 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28707370 | 28707370 | PRJEB43370_P_NODE_6487_length_180_cov_1.511450_g6444_i0 | PRJEB43370 | 6487 | 180 | 1.51145 | 2.72061 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 69.7 | 4.84e-12 | NR | XP_066913602.1 | 252671 | g6444 | i0 | 57.6 | 1.93333333333333 | 59 | 20 | 98.3 | 1 | 3 | 179 | 438 | 491 | XP_066913602.1 protein DD3-3-like [Clytia hemisphaerica] | diamond | 348 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 28732224 | 28732224 | PRJEB43370_P_NODE_8247_length_167_cov_1.762712_g8204_i0 | PRJEB43370 | 8247 | 167 | 1.762712 | 2.94372904 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 45.8 | 2.83e-4 | NR | XP_028401732.1 | 151771 | g8204 | i0 | 66.7 | 3.95209580838323 | 33 | 11 | 59.3 | 0 | 99 | 1 | 5 | 37 | XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea] | diamond | 660 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29868873 | 29868873 | PRJEB43370_P_NODE_7371_length_169_cov_1.300000_g7328_i0 | PRJEB43370 | 7371 | 169 | 1.3 | 2.197 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 65.5 | 2.86e-11 | NR | KAJ7326537.1 | 174260 | g7328 | i0 | 64 | 8.14792899408284 | 50 | 18 | 88.8 | 0 | 18 | 167 | 56 | 105 | KAJ7326537.1 40S ribosomal protein [Desmophyllum pertusum] | diamond | 1377 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 29932248 | 29932248 | PRJEB43370_P_NODE_1451_length_361_cov_2.650641_g1408_i0 | PRJEB43370 | 1451 | 361 | 2.650641 | 9.56881401 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 3.2899999999999996e-31 | NR | XP_020604647.1 | 48498 | g1408 | i0 | 60.4 | 9.45706371191136 | 106 | 39 | 86.4 | 2 | 330 | 19 | 4 | 108 | XP_020604647.1 60S ribosomal protein L31-like isoform X2 [Orbicella faveolata] | diamond | 3414 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 29995361 | 29995361 | PRJEB43370_P_NODE_8331_length_167_cov_0.881356_g8288_i0 | PRJEB43370 | 8331 | 167 | 0.881356 | 1.47186452 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 49.7 | 4.68e-5 | NR | PFX33662.1 | 50429 | g8288 | i0 | 48.6 | 4.86826347305389 | 37 | 19 | 66.5 | 0 | 156 | 46 | 116 | 152 | PFX33662.1 putative S-adenosylmethionine-dependent methyltransferase [Stylophora pistillata] | diamond | 813 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30349972 | 30349972 | PRJEB43370_P_NODE_1512_length_355_cov_3.058824_g1469_i0 | PRJEB43370 | 1512 | 355 | 3.058824 | 10.8588252 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 122 | 2.28e-33 | NR | XP_015753000.1 | 70779 | g1469 | i0 | 59.1 | 0.929577464788732 | 110 | 37 | 93 | 2 | 331 | 2 | 18 | 119 | XP_015753000.1 PREDICTED: 60S ribosomal protein L31-like [Acropora digitifera] | diamond | 330 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 30570334 | 30570334 | PRJEB43370_P_NODE_8093_length_168_cov_0.873950_g8050_i0 | PRJEB43370 | 8093 | 168 | 0.87395 | 1.468236 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 67.8 | 2.04e-11 | NR | CAH3192118.1 | 104178 | g8050 | i0 | 64.6 | 5.19642857142857 | 48 | 15 | 85.7 | 1 | 1 | 144 | 795 | 840 | CAH3192118.1 unnamed protein product [Porites evermanni] | diamond | 873 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 30760244 | 30760244 | PRJEB43370_P_NODE_7434_length_169_cov_0.866667_g7391_i0 | PRJEB43370 | 7434 | 169 | 0.866667 | 1.46466723 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 50.1 | 3.65e-5 | NR | XP_020621253.1 | 48498 | g7391 | i0 | 49 | 2.78698224852071 | 51 | 23 | 85.2 | 1 | 159 | 16 | 10 | 60 | XP_020621253.1 LOW QUALITY PROTEIN: ATP-binding cassette sub-family A member 5-like [Orbicella faveolata] | diamond | 471 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 30791733 | 30791733 | PRJEB43370_P_NODE_2114_length_299_cov_1.416000_g2071_i0 | PRJEB43370 | 2114 | 299 | 1.416 | 4.23384 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 123 | 5.700000000000001e-34 | NR | XP_028401732.1 | 151771 | g2071 | i0 | 65.6 | 1.8561872909699 | 93 | 23 | 85.3 | 2 | 44 | 298 | 5 | 96 | XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea] | diamond | 555 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30981538 | 30981538 | PRJEB43370_P_NODE_6374_length_182_cov_1.210526_g6331_i0 | PRJEB43370 | 6374 | 182 | 1.210526 | 2.20315732 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 51.2 | 1.69e-5 | NR | KAK3752187.1 | 3060491 | g6331 | i0 | 50 | 0.824175824175824 | 50 | 23 | 82.4 | 1 | 15 | 164 | 1113 | 1160 | KAK3752187.1 hypothetical protein QZH41_007018 [Actinostola sp. cb2023] | diamond | 150 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 31265787 | 31265787 | PRJEB43370_P_NODE_6095_length_185_cov_2.294118_g6052_i0 | PRJEB43370 | 6095 | 185 | 2.294118 | 4.2441183 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 87.8 | 2.11e-20 | NR | XP_029203073.1 | 45264 | g6052 | i0 | 81.7 | 11.8540540540541 | 60 | 10 | 95.7 | 1 | 1 | 177 | 74 | 133 | XP_029203073.1 ubiquitin-like protein FUBI [Acropora millepora] | diamond | 2193 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 31859905 | 31859905 | PRJEB43370_P_NODE_3997_length_222_cov_1.086705_g3954_i0 | PRJEB43370 | 3997 | 222 | 1.086705 | 2.4124851 | root | 1 | Root_unresolved | Root_unresolved | 65.1 | 2.82e-10 | NR | XP_028405829.1 | 151771 | g3954 | i0 | 60.8 | 7.85135135135135 | 51 | 20 | 68.9 | 0 | 63 | 215 | 21 | 71 | XP_028405829.1 60S acidic ribosomal protein P0-like isoform X2 [Dendronephthya gigantea] | diamond | 1743 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31929940 | 31929940 | PRJEB43370_P_NODE_2797_length_259_cov_1.485714_g2754_i0 | PRJEB43370 | 2797 | 259 | 1.485714 | 3.84799926 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 72.8 | 1e-12 | NR | XP_047143839.1 | 6087 | g2754 | i0 | 53.8 | 0.752895752895753 | 65 | 30 | 75.3 | 0 | 256 | 62 | 61 | 125 | XP_047143839.1 uncharacterized protein LOC124817601 [Hydra vulgaris] | diamond | 195 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31954887 | 31954887 | PRJEB43370_P_NODE_9297_length_165_cov_0.896552_g9254_i0 | PRJEB43370 | 9297 | 165 | 0.896552 | 1.4793108 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 80.5 | 2.68e-16 | NR | XP_022795578.1 | 50429 | g9254 | i0 | 68.5 | 15.8545454545455 | 54 | 17 | 98.2 | 0 | 165 | 4 | 171 | 224 | XP_022795578.1 ribosome production factor 1-like [Stylophora pistillata] | diamond | 2616 | 81.3 | 0.990159901599016 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32499790 | 32499790 | PRJEB43370_P_NODE_8619_length_167_cov_0.881356_g8576_i0 | PRJEB43370 | 8619 | 167 | 0.881356 | 1.47186452 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 57 | 1.23e-7 | NR | CAH3144942.1 | 104178 | g8576 | i0 | 44.4 | 2.91017964071856 | 54 | 30 | 97 | 0 | 166 | 5 | 270 | 323 | CAH3144942.1 unnamed protein product [Porites evermanni] | diamond | 486 | 57 | 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);;