contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA641991" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 617760 | 617760 | PRJNA641991_S_NODE_14561_length_161_cov_1.366071_g14442_i0 | PRJNA641991 | 14561 | 161 | 1.366071 | 2.19937431 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 89.8 | 1.02e-13 | NTclustered | gi|1778039994|ref|XM_031701610.1| | 6105 | g14442 | i0 | 92.063 | 2.67080745341615 | 63 | 5 | 39 | 0 | 99 | 161 | 153 | 215 | PREDICTED: Actinia tenebrosa tubulin alpha-1 chain-like (LOC116294078), partial mRNA | blastn | 430 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 7536302 | 7536302 | PRJNA641991_S_NODE_6706_length_212_cov_2.165644_g6587_i0 | PRJNA641991 | 6706 | 212 | 2.165644 | 4.59116528 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 250 | 6.1599999999999994e-62 | NTclustered | gi|2782835665|ref|XM_067053980.1| | 252671 | g6587 | i0 | 88.152 | 95.8396226415094 | 211 | 24 | 99 | 1 | 1 | 210 | 1345 | 1135 | PREDICTED: Clytia hemisphaerica tubulin alpha-1A chain-like (LOC136797397), mRNA | blastn | 20318 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 8271062 | 8271062 | PRJNA641991_S_NODE_6047_length_222_cov_1.150289_g5928_i0 | PRJNA641991 | 6047 | 222 | 1.150289 | 2.55364158 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 145 | 3.16e-30 | NTclustered | gi|2202626756|ref|XM_046990698.1| | 2897299 | g5928 | i0 | 80.645 | 38.3558558558559 | 186 | 36 | 84 | 0 | 36 | 221 | 1262 | 1447 | PREDICTED: Xenia sp. Carnegie-2017 heat shock protein 60A-like (LOC124440324), mRNA | blastn | 8515 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 10822009 | 10822009 | PRJNA641991_S_NODE_4749_length_246_cov_0.939086_g4630_i0 | PRJNA641991 | 4749 | 246 | 0.939086 | 2.31015156 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 183 | 7.549999999999997e-42 | NTclustered | gi|2213067084|ref|XM_047285907.1| | 6087 | g4630 | i0 | 80.321 | 14.6178861788618 | 249 | 43 | 100 | 4 | 1 | 246 | 825 | 580 | PREDICTED: Hydra vulgaris serine/threonine-protein phosphatase alpha-2 isoform (LOC100198416), mRNA | blastn | 3596 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 13371797 | 13371797 | PRJNA641991_S_NODE_10111_length_179_cov_1.569231_g9992_i0 | PRJNA641991 | 10111 | 179 | 1.569231 | 2.80892349 | Obelia geniculata | 185004 | Cnidaria | other_Eukaryota | 154 | 4.04e-33 | NTclustered | gi|62825475|gb|AY789874.1| | 185004 | g9992 | i0 | 82.286 | 20.0335195530726 | 175 | 31 | 98 | 0 | 5 | 179 | 379 | 205 | Obelia geniculata voucher 713NB calmodulin gene, partial cds | blastn | 3586 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Obeliidae | Obelia | Obelia geniculata | |
| 15920588 | 15920588 | PRJNA641991_P_NODE_2013_length_216_cov_1.353293_g1972_i0 | PRJNA641991 | 2013 | 216 | 1.353293 | 2.92311288 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 222 | 1.37e-53 | NTclustered | gi|2782941961|ref|XM_067076399.1| | 252671 | g1972 | i0 | 85.185 | 54.787037037037 | 216 | 32 | 100 | 0 | 1 | 216 | 225 | 440 | PREDICTED: Clytia hemisphaerica tubulin alpha-1A chain-like (LOC136820162), mRNA | blastn | 11834 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 15920627 | 15920627 | PRJNA641991_S_NODE_3633_length_277_cov_2.574561_g3514_i0 | PRJNA641991 | 3633 | 277 | 2.574561 | 7.1315339699999996 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 239 | 1.82e-58 | NTclustered | gi|2782951454|ref|XM_067078864.1| | 252671 | g3514 | i0 | 82.482 | 73.3682310469314 | 274 | 46 | 99 | 2 | 5 | 277 | 454 | 182 | PREDICTED: Clytia hemisphaerica tubulin beta-4B chain-like (LOC136822602), mRNA | blastn | 20323 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 17736312 | 17736312 | PRJNA641991_S_NODE_2774_length_316_cov_2.453184_g2655_i0 | PRJNA641991 | 2774 | 316 | 2.453184 | 7.75206144 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 292 | 1.6e-74 | NTclustered | gi|2519007827|ref|XM_057455710.1| | 13093 | g2655 | i0 | 83.596 | 99.7626582278481 | 317 | 46 | 99 | 6 | 3 | 316 | 960 | 647 | PREDICTED: Hydractinia symbiolongicarpus actin, non-muscle 6.2 (LOC130649433), mRNA | blastn | 31525 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 18470022 | 18470022 | PRJNA641991_S_NODE_3175_length_296_cov_1.983806_g3056_i0 | PRJNA641991 | 3175 | 296 | 1.983806 | 5.87206576 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2744889029|ref|XM_065810454.1| | 6087 | g3056 | i0 | 100 | 0.195945945945946 | 29 | 0 | 10 | 0 | 231 | 259 | 2276 | 2248 | PREDICTED: Hydra vulgaris kinesin-like protein KIF28P (LOC100208423), transcript variant X3, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 19744646 | 19744646 | PRJNA641991_S_NODE_6156_length_220_cov_1.473684_g6037_i0 | PRJNA641991 | 6156 | 220 | 1.473684 | 3.2421048 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 172 | 1.43e-38 | NTclustered | gi|2518981757|ref|XM_057441245.1| | 13093 | g6037 | i0 | 81.364 | 2.19545454545455 | 220 | 34 | 99 | 7 | 2 | 218 | 512 | 297 | PREDICTED: Hydractinia symbiolongicarpus mitochondrial-processing peptidase subunit beta-like (LOC130626140), mRNA | blastn | 483 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 21020156 | 21020156 | PRJNA641991_P_NODE_917_length_350_cov_1.013289_g876_i0 | PRJNA641991 | 917 | 350 | 1.013289 | 3.5465115 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 167 | 1.13e-36 | NTclustered | gi|2518990952|ref|XM_057446321.1| | 13093 | g876 | i0 | 80.087 | 4.84857142857143 | 231 | 40 | 65 | 4 | 123 | 350 | 1357 | 1130 | PREDICTED: Hydractinia symbiolongicarpus eukaryotic initiation factor 4A-I-like (LOC130636561), mRNA | blastn | 1697 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 21020206 | 21020206 | PRJNA641991_S_NODE_8397_length_193_cov_2.736111_g8278_i0 | PRJNA641991 | 8397 | 193 | 2.736111 | 5.28069423 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 207 | 3.36e-49 | NTclustered | gi|2782873195|ref|XM_067061561.1| | 252671 | g8278 | i0 | 86.01 | 33.7668393782383 | 193 | 27 | 100 | 0 | 1 | 193 | 139 | 331 | PREDICTED: Clytia hemisphaerica tubulin alpha-1 chain-like (LOC136805029), mRNA | blastn | 6517 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 21560371 | 21560371 | PRJNA641991_S_NODE_4637_length_248_cov_3.698492_g4518_i0 | PRJNA641991 | 4637 | 248 | 3.698492 | 9.17226016 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87.9 | 6.15e-13 | NTclustered | gi|2114279968|ref|XM_029330392.2| | 45264 | g4518 | i0 | 84.884 | 6.90322580645161 | 86 | 13 | 35 | 0 | 1 | 86 | 1523 | 1608 | PREDICTED: Acropora millepora tubulin beta-4B chain (LOC114953952), mRNA | blastn | 1712 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 23570512 | 23570512 | PRJNA641991_S_NODE_4779_length_245_cov_1.301020_g4660_i0 | PRJNA641991 | 4779 | 245 | 1.30102 | 3.187499 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 180 | 9.72e-41 | NTclustered | gi|2518959034|ref|XM_057433457.1| | 13093 | g4660 | i0 | 81.991 | 1.79183673469388 | 211 | 38 | 86 | 0 | 18 | 228 | 833 | 623 | PREDICTED: Hydractinia symbiolongicarpus ruvB-like 2 (LOC130612159), partial mRNA | blastn | 439 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 25384776 | 25384776 | PRJNA641991_S_NODE_2540_length_330_cov_1.217082_g2421_i0 | PRJNA641991 | 2540 | 330 | 1.217082 | 4.0163706 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1524872234|ref|XM_027187692.1| | 46731 | g2421 | i0 | 92.5 | 0.242424242424242 | 40 | 2 | 12 | 1 | 110 | 148 | 80 | 41 | PREDICTED: Pocillopora damicornis THO complex subunit 4-like (LOC113671482), mRNA | blastn | 80 | 56.5 | 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);;