contig_metadata
22 rows where bioproject = "PRJEB11748", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1289995 | 1289995 | PRJEB11748_P_NODE_191962_length_290_cov_37.187773_g189779_i0 | PRJEB11748 | 191962 | 290 | 37.187773 | 107.8445417 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 143 | 1.55e-29 | NTclustered | gi|2113891346|ref|XM_029335370.2| | 45264 | g189779 | i0 | 83.66 | 46.6310344827586 | 153 | 23 | 52 | 2 | 117 | 268 | 497 | 346 | PREDICTED: Acropora millepora ubiquitin-40S ribosomal protein S27a (LOC114957821), mRNA | blastn | 13523 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 3844199 | 3844199 | PRJEB11748_P_NODE_314744_length_212_cov_17.410596_g312561_i0 | PRJEB11748 | 314744 | 212 | 17.410596 | 36.91046352 | Galaxea astreata | 154325 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|640940784|gb|KJ591050.1| | 154325 | g312561 | i0 | 94.444 | 0.169811320754717 | 36 | 2 | 17 | 0 | 4 | 39 | 1 | 36 | Galaxea astreata ferritin mRNA, complete cds | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Euphylliidae | Galaxea | Galaxea astreata | |
| 6393739 | 6393739 | PRJEB11748_P_NODE_186046_length_296_cov_3.570213_g183863_i0 | PRJEB11748 | 186046 | 296 | 3.570213 | 10.56783048 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 60.2 | 1.64e-4 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g183863 | i0 | 97.222 | 0.638513513513513 | 36 | 0 | 12 | 1 | 77 | 111 | 4869875 | 4869840 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 189 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 6394372 | 6394372 | PRJEB11748_P_NODE_219206_length_268_cov_2.637681_g217023_i0 | PRJEB11748 | 219206 | 268 | 2.637681 | 7.06898508 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g217023 | i0 | 96.875 | 0.119402985074627 | 32 | 1 | 12 | 0 | 31 | 62 | 8021993 | 8022024 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 7361836 | 7361836 | PRJEB11748_P_NODE_294146_length_222_cov_4.596273_g291963_i0 | PRJEB11748 | 294146 | 222 | 4.596273 | 10.20372606 | Coronatae | 86058 | Cnidaria | other_Eukaryota | 73.1 | 1.51e-8 | NTclustered | gi|15208481|gb|AY026368.1| | 86043 | g291963 | i0 | 86.567 | 0.603603603603604 | 67 | 8 | 30 | 1 | 23 | 88 | 1403 | 1469 | Atolla vanhoeffeni 28S large subunit ribosomal RNA gene, partial sequence | blastn | 134 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Coronatae | Atollidae | Atolla | Atolla vanhoeffeni | |
| 9913212 | 9913212 | PRJEB11748_P_NODE_54508_length_578_cov_17.529981_g52392_i0 | PRJEB11748 | 54508 | 578 | 17.529981 | 101.32329018 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 196 | 2.49e-45 | NTclustered | gi|15208481|gb|AY026368.1| | 86043 | g52392 | i0 | 78.55 | 56.9134948096886 | 331 | 47 | 63 | 24 | 58 | 377 | 1804 | 2121 | Atolla vanhoeffeni 28S large subunit ribosomal RNA gene, partial sequence | blastn | 32896 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Coronatae | Atollidae | Atolla | Atolla vanhoeffeni | |
| 10220108 | 10220108 | PRJEB11748_P_NODE_274309_length_232_cov_14.725146_g272126_i0 | PRJEB11748 | 274309 | 232 | 14.725146 | 34.16233872 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2744802182|ref|XM_047268008.2| | 6087 | g272126 | i0 | 96.875 | 0.275862068965517 | 32 | 1 | 14 | 0 | 53 | 84 | 1154 | 1185 | PREDICTED: Hydra vulgaris torsin-1A (LOC100197977), transcript variant X1, mRNA | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 14046036 | 14046036 | PRJEB11748_P_NODE_311732_length_214_cov_2.104575_g309549_i0 | PRJEB11748 | 311732 | 214 | 2.104575 | 4.5037905 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 65.8 | 2.42e-6 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g309549 | i0 | 95.238 | 19.5747663551402 | 42 | 1 | 20 | 1 | 1 | 42 | 15020049 | 15020009 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 4189 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 16286016 | 16286016 | PRJEB11748_P_NODE_190993_length_291_cov_16.308696_g188810_i0 | PRJEB11748 | 190993 | 291 | 16.308696 | 47.45830536 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 58.4 | 5.79e-4 | NTclustered | gi|448871684|gb|KC150884.1| | 50429 | g188810 | i0 | 100 | 1.28178694158076 | 31 | 0 | 11 | 0 | 229 | 259 | 2257 | 2287 | Stylophora pistillata hemicentin-like protein (g11674) gene, partial cds | blastn | 373 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 16594768 | 16594768 | PRJEB11748_P_NODE_309234_length_215_cov_2.811688_g307051_i0 | PRJEB11748 | 309234 | 215 | 2.811688 | 6.0451292 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 112 | 1.2599999999999998e-29 | NR | XP_057290043.1 | 13093 | g307051 | i0 | 75.4 | 2.72093023255814 | 65 | 16 | 90.7 | 0 | 5 | 199 | 49 | 113 | XP_057290043.1 60S ribosomal protein L27a-like [Hydractinia symbiolongicarpus] | diamond | 585 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 20109269 | 20109269 | PRJEB11748_P_NODE_120856_length_377_cov_9.066456_g118680_i0 | PRJEB11748 | 120856 | 377 | 9.066456 | 34.18053912 | Ptilella | 2610848 | Cnidaria | other_Eukaryota | 196 | 1.57e-45 | NTclustered | gi|2160785908|gb|OL741702.1| | 2610849 | g118680 | i0 | 86.486 | 49.7957559681698 | 185 | 17 | 49 | 6 | 169 | 351 | 181 | 3 | Ptilella grandis voucher NMS.Z.2019.25.9 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 18773 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Pennatulidae | Ptilella | Ptilella grandis | |
| 27469247 | 27469247 | PRJEB11748_P_NODE_56483_length_567_cov_5.179842_g54358_i0 | PRJEB11748 | 56483 | 567 | 5.179842 | 29.36970414 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 89.7 | 2.12e-18 | NR | XP_001638931.2 | 45351 | g54358 | i0 | 45.8 | 8.79365079365079 | 96 | 48 | 48.7 | 2 | 348 | 73 | 78 | 173 | XP_001638931.2 nuclear transcription factor Y subunit beta isoform X2 [Nematostella vectensis] | diamond | 4986 | 90.5 | 0.991160220994475 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 27728368 | 27728368 | PRJEB11748_P_NODE_95064_length_429_cov_2.896739_g92896_i0 | PRJEB11748 | 95064 | 429 | 2.896739 | 12.42701031 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 58.2 | 1.17e-6 | NR | XP_066920451.1 | 252671 | g92896 | i0 | 43.9 | 0.573426573426573 | 82 | 32 | 55.2 | 3 | 175 | 411 | 694 | 764 | XP_066920451.1 origin recognition complex subunit 3-like [Clytia hemisphaerica] | diamond | 246 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 27791241 | 27791241 | PRJEB11748_P_NODE_78924_length_473_cov_6.094660_g76764_i0 | PRJEB11748 | 78924 | 473 | 6.09466 | 28.8277418 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 73.2 | 2.59e-13 | NR | CAH3038652.1 | 104759 | g76764 | i0 | 79.5 | 2.43551797040169 | 44 | 9 | 27.9 | 0 | 18 | 149 | 81 | 124 | CAH3038652.1 unnamed protein product [Porites lobata] | diamond | 1152 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 29621845 | 29621845 | PRJEB11748_P_NODE_246810_length_249_cov_1.617021_g244627_i0 | PRJEB11748 | 246810 | 249 | 1.617021 | 4.02638229 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 44.7 | 0.00826 | NR | XP_020625288.1 | 48498 | g244627 | i0 | 40.7 | 0.710843373493976 | 59 | 32 | 68.7 | 2 | 249 | 79 | 189 | 246 | XP_020625288.1 coadhesin-like [Orbicella faveolata] | diamond | 177 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 29811669 | 29811669 | PRJEB11748_P_NODE_320851_length_210_cov_2.000000_g318668_i0 | PRJEB11748 | 320851 | 210 | 2 | 4.2 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 55.5 | 8.18e-7 | NR | CAH3189486.1 | 104178 | g318668 | i0 | 46.9 | 0.914285714285714 | 64 | 34 | 91.4 | 0 | 19 | 210 | 950 | 1013 | CAH3189486.1 unnamed protein product [Porites evermanni] | diamond | 192 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 29969605 | 29969605 | PRJEB11748_P_NODE_200311_length_283_cov_7.157658_g198128_i0 | PRJEB11748 | 200311 | 283 | 7.157658 | 20.25617214 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 69.3 | 2.58e-11 | NR | XP_046843595.1 | 2897299 | g198128 | i0 | 44.8 | 1.87632508833922 | 87 | 37 | 92.2 | 3 | 18 | 278 | 477 | 552 | XP_046843595.1 anoctamin-10-like [Xenia sp. Carnegie-2017] | diamond | 531 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 30343162 | 30343162 | PRJEB11748_P_NODE_285712_length_226_cov_11.721212_g283529_i0 | PRJEB11748 | 285712 | 226 | 11.721212 | 26.48993912 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 55.1 | 1.39e-6 | NR | XP_027055156.1 | 46731 | g283529 | i0 | 76.7 | 1.64601769911504 | 30 | 7 | 39.8 | 0 | 195 | 106 | 1038 | 1067 | XP_027055156.1 LOW QUALITY PROTEIN: sporulation-specific protein 15-like [Pocillopora damicornis] | diamond | 372 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 30475305 | 30475305 | PRJEB11748_P_NODE_214233_length_272_cov_2.132701_g212050_i0 | PRJEB11748 | 214233 | 272 | 2.132701 | 5.80094672 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 44.3 | 0.0139 | NR | XP_068686699.1 | 591990 | g212050 | i0 | 34.8 | 2.28308823529412 | 69 | 31 | 64 | 3 | 23 | 196 | 83 | 148 | XP_068686699.1 bone morphogenetic protein 1-like [Montipora foliosa] | diamond | 621 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 31486858 | 31486858 | PRJEB11748_P_NODE_372856_length_185_cov_6.548387_g370673_i0 | PRJEB11748 | 372856 | 185 | 6.548387 | 12.11451595 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 55.8 | 1.08e-7 | NR | XP_044162838.1 | 45264 | g370673 | i0 | 47.6 | 2.74054054054054 | 42 | 22 | 68.1 | 0 | 171 | 46 | 113 | 154 | XP_044162838.1 DPH4 homolog isoform X1 [Acropora millepora] | diamond | 507 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 31897689 | 31897689 | PRJEB11748_P_NODE_178277_length_303_cov_14.971074_g176094_i0 | PRJEB11748 | 178277 | 303 | 14.971074 | 45.36235422 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 129 | 3.72e-35 | NR | RMX48186.1 | 46731 | g176094 | i0 | 79 | 2.35643564356436 | 81 | 17 | 80.2 | 0 | 267 | 25 | 115 | 195 | RMX48186.1 hypothetical protein pdam_00015396 [Pocillopora damicornis] | diamond | 714 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 32687970 | 32687970 | PRJEB11748_P_NODE_147620_length_338_cov_3.844765_g145439_i0 | PRJEB11748 | 147620 | 338 | 3.844765 | 12.9953057 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 103 | 2.18e-24 | NR | KAF0986447.1 | 69463 | g145439 | i0 | 63.8 | 1.43786982248521 | 80 | 28 | 71 | 1 | 12 | 251 | 178 | 256 | KAF0986447.1 hypothetical protein HZS_1981 [Henneguya salminicola] | diamond | 486 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola |
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);;