contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA976345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 948420 | 948420 | PRJNA976345_P_NODE_3601_length_1072_cov_12.287367_g2538_i0 | PRJNA976345 | 3601 | 1072 | 12.287367 | 131.72057424 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 904 | 0 | NTclustered | gi|2744811132|ref|XM_065826202.1| | 6087 | g2538 | i0 | 82.088 | 18.3945895522388 | 1111 | 149 | 99 | 12 | 9 | 1072 | 1719 | 612 | PREDICTED: Hydra vulgaris zinc finger MYM-type protein 1-like (LOC101239105), mRNA | blastn | 19719 | 904 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 2223930 | 2223930 | PRJNA976345_P_NODE_5262_length_815_cov_72197.575641_g1219_i4 | PRJNA976345 | 5262 | 815 | 72197.575641 | 588410.24147415 | Trachyphyllia geoffroyi | 196280 | Cnidaria | other_Eukaryota | 1247 | 0 | NTclustered | gi|23503507|dbj|AB085641.1| | 196280 | g1219 | i4 | 100 | 33.6073619631902 | 675 | 0 | 86 | 0 | 95 | 769 | 675 | 1 | Trachyphyllia geoffroyi mRNA for Kaede, complete cds | blastn | 27390 | 1247 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Trachyphyllia | Trachyphyllia geoffroyi | |
| 2224079 | 2224079 | PRJNA976345_P_NODE_68342_length_218_cov_2.382514_g66734_i0 | PRJNA976345 | 68342 | 218 | 2.382514 | 5.1938805199999996 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.019 | NTclustered | gi|2918369535|emb|OZ237717.1| | 317547 | g66734 | i0 | 100 | 0.128440366972477 | 28 | 0 | 13 | 0 | 21 | 48 | 2125859 | 2125832 | Eunicella cavolini genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 2224245 | 2224245 | PRJNA976345_P_NODE_85922_length_200_cov_3.175758_g84314_i0 | PRJNA976345 | 85922 | 200 | 3.175758 | 6.351516 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2917940701|emb|OZ237558.1| | 6108 | g84314 | i0 | 100 | 0.14 | 28 | 0 | 14 | 0 | 43 | 70 | 8247520 | 8247493 | Anemonia sulcata genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 3499347 | 3499347 | PRJNA976345_P_NODE_67683_length_219_cov_2.048913_g66075_i0 | PRJNA976345 | 67683 | 219 | 2.048913 | 4.48711947 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 52.8 | 0.019 | NTclustered | gi|2729090354|ref|XM_065207842.1| | 499914 | g66075 | i0 | 100 | 0.127853881278539 | 28 | 0 | 13 | 0 | 22 | 49 | 1142 | 1169 | PREDICTED: Rhopilema esculentum uncharacterized LOC135690323 (LOC135690323), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 3499613 | 3499613 | PRJNA976345_P_NODE_9883_length_552_cov_13.984526_g2538_i2 | PRJNA976345 | 9883 | 552 | 13.984526 | 77.19458352 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 503 | 1.25e-137 | NTclustered | gi|2744793474|ref|XM_065822168.1| | 6087 | g2538 | i2 | 85.537 | 0.876811594202899 | 484 | 66 | 87 | 4 | 32 | 513 | 1306 | 825 | PREDICTED: Hydra vulgaris uncharacterized LOC136093203 (LOC136093203), mRNA | blastn | 484 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 6052062 | 6052062 | PRJNA976345_P_NODE_73705_length_212_cov_2.124294_g72097_i0 | PRJNA976345 | 73705 | 212 | 2.124294 | 4.50350328 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 78.7 | 3.08e-10 | NTclustered | gi|1603770980|ref|XM_028542753.1| | 151771 | g72097 | i0 | 90 | 0.283018867924528 | 60 | 6 | 28 | 0 | 134 | 193 | 1056 | 997 | PREDICTED: Dendronephthya gigantea citrate synthase, mitochondrial-like (LOC114522120), mRNA | blastn | 60 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 7326507 | 7326507 | PRJNA976345_P_NODE_56086_length_236_cov_1.502488_g54478_i0 | PRJNA976345 | 56086 | 236 | 1.502488 | 3.54587168 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g54478 | i0 | 100 | 0.11864406779661 | 28 | 0 | 12 | 0 | 177 | 204 | 5377959 | 5377986 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 8601852 | 8601852 | PRJNA976345_P_NODE_90347_length_197_cov_1.512346_g88739_i0 | PRJNA976345 | 90347 | 197 | 1.512346 | 2.97932162 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g88739 | i0 | 100 | 0.142131979695431 | 28 | 0 | 14 | 0 | 42 | 69 | 16218111 | 16218084 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 9876956 | 9876956 | PRJNA976345_P_NODE_74488_length_211_cov_2.687500_g72880_i0 | PRJNA976345 | 74488 | 211 | 2.6875 | 5.670625 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 104 | 5.04e-18 | NTclustered | gi|2744830644|ref|XM_002162514.5| | 6087 | g72880 | i0 | 90.909 | 0.729857819905213 | 77 | 7 | 36 | 0 | 6 | 82 | 625 | 549 | PREDICTED: Hydra vulgaris ADP-ribosylation factor-like protein 8B-A (LOC100213960), transcript variant X1, mRNA | blastn | 154 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 11151248 | 11151248 | PRJNA976345_P_NODE_114349_length_181_cov_1.404110_g112741_i0 | PRJNA976345 | 114349 | 181 | 1.40411 | 2.5414391 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|2918369538|emb|OZ237720.1| | 317547 | g112741 | i0 | 100 | 0.154696132596685 | 28 | 0 | 15 | 0 | 141 | 168 | 8481082 | 8481109 | Eunicella cavolini genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 11151280 | 11151280 | PRJNA976345_P_NODE_118829_length_178_cov_3.860140_g117221_i0 | PRJNA976345 | 118829 | 178 | 3.86014 | 6.8710492 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2113722005|ref|XM_044315973.1| | 45264 | g117221 | i0 | 96.875 | 0.179775280898876 | 32 | 1 | 18 | 0 | 74 | 105 | 160 | 129 | PREDICTED: Acropora millepora uncharacterized LOC114972015 (LOC114972015), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 11152215 | 11152215 | PRJNA976345_P_NODE_59549_length_230_cov_2.179487_g57941_i0 | PRJNA976345 | 59549 | 230 | 2.179487 | 5.0128201 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 99 | 2.6e-16 | NTclustered | gi|2744823557|ref|XM_002164231.5| | 6087 | g57941 | i0 | 87.952 | 1.98260869565217 | 83 | 10 | 36 | 0 | 19 | 101 | 295 | 213 | PREDICTED: Hydra vulgaris RING-box protein 1 (LOC100204043), transcript variant X1, mRNA | blastn | 456 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 11152449 | 11152449 | PRJNA976345_P_NODE_8649_length_598_cov_3.879218_g7183_i0 | PRJNA976345 | 8649 | 598 | 3.879218 | 23.19772364 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 54.7 | 0.016 | NTclustered | gi|2113966495|ref|XR_006391776.1| | 45264 | g7183 | i0 | 100 | 0.048494983277592 | 29 | 0 | 5 | 0 | 170 | 198 | 2020 | 2048 | PREDICTED: Acropora millepora uncharacterized LOC122948646 (LOC122948646), misc_RNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 11470933 | 11470933 | PRJNA976345_P_NODE_170989_length_158_cov_2.577236_g169381_i0 | PRJNA976345 | 170989 | 158 | 2.577236 | 4.07203288 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2744865199|ref|XM_065799422.1| | 6087 | g169381 | i0 | 100 | 1.31012658227848 | 29 | 0 | 18 | 0 | 54 | 82 | 1003 | 975 | PREDICTED: Hydra vulgaris uncharacterized LOC100201104 (LOC100201104), transcript variant X8, mRNA | blastn | 207 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 12426944 | 12426944 | PRJNA976345_P_NODE_125730_length_177_cov_2.725352_g124122_i0 | PRJNA976345 | 125730 | 177 | 2.725352 | 4.82387304 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|1270040074|ref|XM_022926083.1| | 50429 | g124122 | i0 | 100 | 0.15819209039548 | 28 | 0 | 16 | 0 | 58 | 85 | 2579 | 2552 | PREDICTED: Stylophora pistillata disrupted in renal carcinoma protein 2 homolog (LOC111322869), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 13701451 | 13701451 | PRJNA976345_P_NODE_130351_length_175_cov_2.028571_g128743_i0 | PRJNA976345 | 130351 | 175 | 2.028571 | 3.54999925 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|2744827643|ref|XR_010633636.1| | 6087 | g128743 | i0 | 100 | 1.44 | 28 | 0 | 16 | 0 | 115 | 142 | 514 | 541 | PREDICTED: Hydra vulgaris uncharacterized LOC124815867 (LOC124815867), transcript variant X2, ncRNA | blastn | 252 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 14976095 | 14976095 | PRJNA976345_P_NODE_197172_length_150_cov_2.808696_g195564_i0 | PRJNA976345 | 197172 | 150 | 2.808696 | 4.213044 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 75 | 2.61e-9 | NTclustered | gi|2744811800|ref|XR_007025244.2| | 6087 | g195564 | i0 | 93.878 | 0.326666666666667 | 49 | 3 | 33 | 0 | 1 | 49 | 241 | 289 | PREDICTED: Hydra vulgaris uncharacterized LOC124816607 (LOC124816607), ncRNA | blastn | 49 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 14976391 | 14976391 | PRJNA976345_P_NODE_4212_length_955_cov_60375.742391_g1219_i3 | PRJNA976345 | 4212 | 955 | 60375.742391 | 576588.33983405 | Trachyphyllia geoffroyi | 196280 | Cnidaria | other_Eukaryota | 1247 | 0 | NTclustered | gi|23503507|dbj|AB085641.1| | 196280 | g1219 | i3 | 100 | 56.9801047120419 | 675 | 0 | 71 | 0 | 1 | 675 | 675 | 1 | Trachyphyllia geoffroyi mRNA for Kaede, complete cds | blastn | 54416 | 1247 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Trachyphyllia | Trachyphyllia geoffroyi | |
| 14976448 | 14976448 | PRJNA976345_P_NODE_47332_length_253_cov_2.142202_g45724_i0 | PRJNA976345 | 47332 | 253 | 2.142202 | 5.41977106 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g45724 | i0 | 100 | 0.118577075098814 | 30 | 0 | 12 | 0 | 181 | 210 | 10106575 | 10106546 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 16251367 | 16251367 | PRJNA976345_P_NODE_42413_length_265_cov_2.078261_g40805_i0 | PRJNA976345 | 42413 | 265 | 2.078261 | 5.50739165 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2918369538|emb|OZ237720.1| | 317547 | g40805 | i0 | 100 | 0.113207547169811 | 30 | 0 | 11 | 0 | 193 | 222 | 46646167 | 46646138 | Eunicella cavolini genome assembly, chromosome: 4 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 16251793 | 16251793 | PRJNA976345_P_NODE_88273_length_198_cov_3.576687_g86665_i0 | PRJNA976345 | 88273 | 198 | 3.576687 | 7.08184026 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2784721500|ref|XR_010872288.1| | 159855 | g86665 | i0 | 100 | 0.424242424242424 | 28 | 0 | 14 | 0 | 166 | 193 | 890 | 917 | PREDICTED: Acropora muricata uncharacterized lncRNA (LOC136921555), transcript variant X1, ncRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 17526170 | 17526170 | PRJNA976345_P_NODE_180934_length_155_cov_1.908333_g179326_i0 | PRJNA976345 | 180934 | 155 | 1.908333 | 2.95791615 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2744795867|ref|XM_047272042.2| | 6087 | g179326 | i0 | 100 | 0.580645161290323 | 30 | 0 | 19 | 0 | 110 | 139 | 1948 | 1977 | PREDICTED: Hydra vulgaris NACHT, LRR and PYD domains-containing protein 5 (LOC100205866), transcript variant X2, mRNA | blastn | 90 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 17526743 | 17526743 | PRJNA976345_P_NODE_5954_length_749_cov_77797.483193_g1219_i5 | PRJNA976345 | 5954 | 749 | 77797.483193 | 582703.14911557 | Trachyphyllia geoffroyi | 196280 | Cnidaria | other_Eukaryota | 1247 | 0 | NTclustered | gi|23503507|dbj|AB085641.1| | 196280 | g1219 | i5 | 100 | 35.5794392523364 | 675 | 0 | 90 | 0 | 1 | 675 | 675 | 1 | Trachyphyllia geoffroyi mRNA for Kaede, complete cds | blastn | 26649 | 1247 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Trachyphyllia | Trachyphyllia geoffroyi | |
| 18799608 | 18799608 | PRJNA976345_P_NODE_137855_length_172_cov_1.058394_g136247_i0 | PRJNA976345 | 137855 | 172 | 1.058394 | 1.82043768 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2782881015|ref|XM_067063418.1| | 252671 | g136247 | i0 | 90.698 | 0.738372093023256 | 43 | 0 | 25 | 3 | 85 | 127 | 1322 | 1284 | PREDICTED: Clytia hemisphaerica ZP domain-containing protein-like (LOC136806840), mRNA | blastn | 127 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 18800740 | 18800740 | PRJNA976345_P_NODE_95075_length_193_cov_2.316456_g93467_i0 | PRJNA976345 | 95075 | 193 | 2.316456 | 4.47076008 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2782905500|ref|XM_067069547.1| | 252671 | g93467 | i0 | 96.97 | 0.170984455958549 | 33 | 1 | 17 | 0 | 111 | 143 | 3568 | 3536 | PREDICTED: Clytia hemisphaerica chondroitin sulfate synthase 1-like (LOC136813036), mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 23900724 | 23900724 | PRJNA976345_P_NODE_193579_length_151_cov_2.767241_g191971_i0 | PRJNA976345 | 193579 | 151 | 2.767241 | 4.17853391 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.012 | NTclustered | gi|2917940756|emb|OZ237571.1| | 6108 | g191971 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 62 | 89 | 5954049 | 5954076 | Anemonia sulcata genome assembly, chromosome: 17 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata |
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);;