contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838485 | 838485 | PRJNA849822_P_NODE_13081_length_406_cov_1.234234_g12907_i0 | PRJNA849822 | 13081 | 406 | 1.234234 | 5.01099004 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|1778058997|ref|XM_031710919.1| | 6105 | g12907 | i0 | 94.286 | 0.0862068965517241 | 35 | 2 | 9 | 0 | 312 | 346 | 2304 | 2270 | PREDICTED: Actinia tenebrosa major facilitator superfamily domain-containing protein 6-like (LOC116301801), mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 2113952 | 2113952 | PRJNA849822_P_NODE_16102_length_362_cov_1.079585_g15928_i0 | PRJNA849822 | 16102 | 362 | 1.079585 | 3.9080977 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 178 | 5.43e-40 | NTclustered | gi|2782838984|ref|XM_067054804.1| | 252671 | g15928 | i0 | 76.033 | 12.439226519337 | 363 | 75 | 99 | 10 | 6 | 362 | 135 | 491 | PREDICTED: Clytia hemisphaerica large ribosomal subunit protein uL15-like (LOC136798225), mRNA | blastn | 4503 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 2114091 | 2114091 | PRJNA849822_P_NODE_3542_length_860_cov_1.584498_g3386_i0 | PRJNA849822 | 3542 | 860 | 1.584498 | 13.6266828 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 54.7 | 0.024 | NTclustered | gi|1270048438|ref|XM_022930553.1| | 50429 | g3386 | i0 | 100 | 0.101162790697674 | 29 | 0 | 3 | 0 | 656 | 684 | 2662 | 2634 | PREDICTED: Stylophora pistillata uncharacterized LOC111326543 (LOC111326543), mRNA | blastn | 87 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 2114176 | 2114176 | PRJNA849822_P_NODE_5662_length_658_cov_1.729915_g5493_i0 | PRJNA849822 | 5662 | 658 | 1.729915 | 11.3828407 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 374 | 1.23e-98 | NTclustered | gi|2782902330|ref|XM_067068799.1| | 252671 | g5493 | i0 | 78.211 | 70.5471124620061 | 615 | 112 | 92 | 17 | 1 | 604 | 979 | 376 | PREDICTED: Clytia hemisphaerica ATP synthase subunit beta, mitochondrial-like (LOC136812302), mRNA | blastn | 46420 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 3389312 | 3389312 | PRJNA849822_P_NODE_26523_length_283_cov_1.109524_g26349_i0 | PRJNA849822 | 26523 | 283 | 1.109524 | 3.13995292 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|1270063409|ref|XM_022938584.1| | 50429 | g26349 | i0 | 100 | 0.0989399293286219 | 28 | 0 | 10 | 0 | 169 | 196 | 2199 | 2226 | PREDICTED: Stylophora pistillata dynamin-1-like (LOC111333062), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 5941995 | 5941995 | PRJNA849822_P_NODE_7465_length_560_cov_2.266940_g7293_i0 | PRJNA849822 | 7465 | 560 | 2.26694 | 12.694864 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 73.1 | 4.24e-8 | NTclustered | gi|1619639958|ref|XM_021044386.2| | 2652724 | g7293 | i0 | 80.682 | 0.707142857142857 | 88 | 17 | 16 | 0 | 365 | 452 | 2467 | 2380 | PREDICTED: Exaiptasia diaphana ATP-binding cassette sub-family B member 9 (LOC110238703), mRNA | blastn | 396 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 9766709 | 9766709 | PRJNA849822_P_NODE_30508_length_265_cov_1.151042_g30334_i0 | PRJNA849822 | 30508 | 265 | 1.151042 | 3.0502613 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2917940752|emb|OZ237570.1| | 6108 | g30334 | i0 | 96.875 | 0.120754716981132 | 32 | 1 | 12 | 0 | 110 | 141 | 8800285 | 8800316 | Anemonia sulcata genome assembly, chromosome: 16 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11042126 | 11042126 | PRJNA849822_P_NODE_10229_length_467_cov_1.461929_g10056_i0 | PRJNA849822 | 10229 | 467 | 1.461929 | 6.82720843 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.045 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g10056 | i0 | 100 | 0.0599571734475375 | 28 | 0 | 6 | 0 | 282 | 309 | 9630133 | 9630160 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11042246 | 11042246 | PRJNA849822_P_NODE_24389_length_293_cov_1.563636_g24215_i0 | PRJNA849822 | 24389 | 293 | 1.563636 | 4.58145348 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 60.2 | 1.62e-4 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g24215 | i0 | 97.222 | 0.122866894197952 | 36 | 0 | 12 | 1 | 74 | 109 | 21975556 | 21975522 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 36 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 12317657 | 12317657 | PRJNA849822_P_NODE_10830_length_451_cov_8.666667_g10657_i0 | PRJNA849822 | 10830 | 451 | 8.666667 | 39.08666817 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 318 | 3.9e-82 | NTclustered | gi|2518991437|ref|XM_057446583.1| | 13093 | g10657 | i0 | 83.146 | 77.9157427937916 | 356 | 52 | 78 | 7 | 88 | 439 | 515 | 164 | PREDICTED: Hydractinia symbiolongicarpus ubiquitin-60S ribosomal protein L40 (LOC130636750), mRNA | blastn | 35140 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 12317915 | 12317915 | PRJNA849822_P_NODE_43930_length_230_cov_2.484076_g43756_i0 | PRJNA849822 | 43930 | 230 | 2.484076 | 5.7133748 | Parvicapsula minibicornis | 109801 | Cnidaria | other_Eukaryota | 121 | 5.55e-23 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g43756 | i0 | 86.486 | 50.0173913043478 | 111 | 13 | 48 | 2 | 1 | 111 | 341 | 233 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 11504 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 13592321 | 13592321 | PRJNA849822_P_NODE_27431_length_278_cov_2.204878_g27257_i0 | PRJNA849822 | 27431 | 278 | 2.204878 | 6.12956084 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 60.2 | 1.53e-4 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g27257 | i0 | 90.909 | 0.158273381294964 | 44 | 4 | 16 | 0 | 136 | 179 | 21626782 | 21626739 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 44 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13592498 | 13592498 | PRJNA849822_P_NODE_9171_length_496_cov_2.933806_g8998_i0 | PRJNA849822 | 9171 | 496 | 2.933806 | 14.55167776 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 274 | 9.499999999999999e-69 | NTclustered | gi|1619698735|ref|XM_021060602.2| | 2652724 | g8998 | i0 | 79.167 | 67.6209677419355 | 408 | 67 | 80 | 13 | 85 | 480 | 422 | 21 | PREDICTED: Exaiptasia diaphana histone H3 (LOC110253653), mRNA | blastn | 33540 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 13987308 | 13987308 | PRJNA849822_P_NODE_28031_length_276_cov_1.137931_g27857_i0 | PRJNA849822 | 28031 | 276 | 1.137931 | 3.14068956 | root | 1 | Root_unresolved | Root_unresolved | 62.1 | 4.22e-5 | NTclustered | gi|2917940701|emb|OZ237558.1| | 6108 | g27857 | i0 | 100 | 33.2898550724638 | 33 | 0 | 12 | 0 | 96 | 128 | 11018709 | 11018677 | Anemonia sulcata genome assembly, chromosome: 4 | blastn | 9188 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 16141454 | 16141454 | PRJNA849822_P_NODE_40433_length_245_cov_0.906977_g40259_i0 | PRJNA849822 | 40433 | 245 | 0.906977 | 2.22209365 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g40259 | i0 | 100 | 0.240816326530612 | 30 | 0 | 12 | 0 | 126 | 155 | 6448411 | 6448382 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 17416718 | 17416718 | PRJNA849822_P_NODE_11374_length_439_cov_1.625683_g11200_i0 | PRJNA849822 | 11374 | 439 | 1.625683 | 7.13674837 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.042 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g11200 | i0 | 100 | 0.191343963553531 | 28 | 0 | 6 | 0 | 124 | 151 | 923631 | 923604 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 17810925 | 17810925 | PRJNA849822_P_NODE_18674_length_335_cov_1.080153_g18500_i0 | PRJNA849822 | 18674 | 335 | 1.080153 | 3.61851255 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 58.4 | 6.79e-4 | NTclustered | gi|2917940752|emb|OZ237570.1| | 6108 | g18500 | i0 | 100 | 4.93432835820896 | 31 | 0 | 9 | 0 | 99 | 129 | 11537191 | 11537161 | Anemonia sulcata genome assembly, chromosome: 16 | blastn | 1653 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 17810967 | 17810967 | PRJNA849822_P_NODE_36794_length_249_cov_0.886364_g36620_i0 | PRJNA849822 | 36794 | 249 | 0.886364 | 2.20704636 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940735|emb|OZ237565.1| | 6108 | g36620 | i0 | 89.13 | 1.8433734939759 | 46 | 4 | 18 | 1 | 61 | 106 | 8772394 | 8772350 | Anemonia sulcata genome assembly, chromosome: 11 | blastn | 459 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 18690050 | 18690050 | PRJNA849822_P_NODE_43075_length_242_cov_0.923077_g42901_i0 | PRJNA849822 | 43075 | 242 | 0.923077 | 2.23384634 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|1176056884|ref|XM_020747765.1| | 48498 | g42901 | i0 | 96.875 | 0.363636363636364 | 32 | 0 | 13 | 1 | 42 | 72 | 4946 | 4915 | PREDICTED: Orbicella faveolata uncharacterized LOC110042398 (LOC110042398), mRNA | blastn | 88 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 19964926 | 19964926 | PRJNA849822_P_NODE_11676_length_432_cov_2.061281_g11502_i0 | PRJNA849822 | 11676 | 432 | 2.061281 | 8.90473392 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g11502 | i0 | 96.97 | 0.486111111111111 | 33 | 1 | 8 | 0 | 393 | 425 | 11447043 | 11447075 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 210 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 21635570 | 21635570 | PRJNA849822_P_NODE_23377_length_299_cov_2.685841_g23203_i0 | PRJNA849822 | 23377 | 299 | 2.685841 | 8.03066459 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 5.98e-4 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g23203 | i0 | 100 | 4.438127090301 | 31 | 0 | 10 | 0 | 25 | 55 | 8497694 | 8497724 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 1327 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 22911093 | 22911093 | PRJNA849822_P_NODE_14918_length_377_cov_1.026316_g14744_i0 | PRJNA849822 | 14918 | 377 | 1.026316 | 3.86921132 | Montipora | 46703 | Cnidaria | other_Eukaryota | 54.7 | 0.01 | NTclustered | gi|2812168054|ref|XM_068896822.1| | 246305 | g14744 | i0 | 96.875 | 0.753315649867374 | 32 | 1 | 8 | 0 | 256 | 287 | 1659 | 1628 | PREDICTED: Montipora capricornis skin secretory protein xP2-like (LOC138050498), transcript variant X2, mRNA | blastn | 284 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 22911170 | 22911170 | PRJNA849822_P_NODE_4658_length_733_cov_4.943939_g4494_i0 | PRJNA849822 | 4658 | 733 | 4.943939 | 36.23907287 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 300 | 2.37e-76 | NTclustered | gi|1524893463|ref|XM_027198986.1| | 46731 | g4494 | i0 | 81.003 | 58.4010914051842 | 379 | 70 | 52 | 2 | 115 | 492 | 502 | 125 | PREDICTED: Pocillopora damicornis 40S ribosomal protein S14 (LOC113681859), mRNA | blastn | 42808 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 24185085 | 24185085 | PRJNA849822_P_NODE_41439_length_244_cov_0.912281_g41265_i0 | PRJNA849822 | 41439 | 244 | 0.912281 | 2.22596564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g41265 | i0 | 100 | 2.14344262295082 | 30 | 0 | 12 | 0 | 49 | 78 | 1012627 | 1012656 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 523 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 25460141 | 25460141 | PRJNA849822_P_NODE_19260_length_330_cov_1.093385_g19086_i0 | PRJNA849822 | 19260 | 330 | 1.093385 | 3.6081705 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|2917940701|emb|OZ237558.1| | 6108 | g19086 | i0 | 100 | 0.763636363636364 | 28 | 0 | 8 | 0 | 113 | 140 | 8469358 | 8469385 | Anemonia sulcata genome assembly, chromosome: 4 | blastn | 252 | 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);;