contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 848211 | 848211 | PRJNA867519_P_NODE_6581_length_427_cov_1.028249_g6427_i0 | PRJNA867519 | 6581 | 427 | 1.028249 | 4.39062323 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 52.8 | 0.041 | NTclustered | gi|2782928398|ref|XM_067073507.1| | 252671 | g6427 | i0 | 100 | 0.0655737704918033 | 28 | 0 | 7 | 0 | 96 | 123 | 3575 | 3602 | PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136817172), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 7226317 | 7226317 | PRJNA867519_P_NODE_2186_length_677_cov_1.970199_g2037_i0 | PRJNA867519 | 2186 | 677 | 1.970199 | 13.33824723 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 364 | 7.629999999999997e-96 | NTclustered | gi|2782930007|ref|XM_067073869.1| | 252671 | g2037 | i0 | 76.72 | 20.7193500738552 | 683 | 142 | 99 | 16 | 2 | 677 | 341 | 1013 | PREDICTED: Clytia hemisphaerica protein transport protein Sec61 subunit alpha (LOC136817544), mRNA | blastn | 14027 | 364 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 8501008 | 8501008 | PRJNA867519_P_NODE_26027_length_250_cov_1.898305_g25873_i0 | PRJNA867519 | 26027 | 250 | 1.898305 | 4.7457625 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 176 | 1.2899999999999999e-39 | NTclustered | gi|2518990430|ref|XM_057446035.1| | 13093 | g25873 | i0 | 83.784 | 5.728 | 185 | 30 | 74 | 0 | 35 | 219 | 346 | 162 | PREDICTED: Hydractinia symbiolongicarpus V-type proton ATPase catalytic subunit A (LOC130636348), mRNA | blastn | 1432 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 8501062 | 8501062 | PRJNA867519_P_NODE_3267_length_575_cov_1.213147_g3116_i0 | PRJNA867519 | 3267 | 575 | 1.213147 | 6.97559525 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 93.5 | 3.34e-14 | NTclustered | gi|2918369538|emb|OZ237720.1| | 317547 | g3116 | i0 | 79.104 | 2.17391304347826 | 134 | 28 | 23 | 0 | 315 | 448 | 44319884 | 44319751 | Eunicella cavolini genome assembly, chromosome: 4 | blastn | 1250 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 10165517 | 10165517 | PRJNA867519_P_NODE_1948_length_707_cov_3.962145_g1801_i0 | PRJNA867519 | 1948 | 707 | 3.962145 | 28.01236515 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 62.1 | 1.17e-4 | NTclustered | gi|1524882407|ref|XM_027193114.1| | 46731 | g1801 | i0 | 85.246 | 1.05657708628006 | 61 | 7 | 9 | 1 | 158 | 218 | 4856 | 4914 | PREDICTED: Pocillopora damicornis uncharacterized LOC113676458 (LOC113676458), mRNA | blastn | 747 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 10165562 | 10165562 | PRJNA867519_P_NODE_7448_length_404_cov_1.652568_g7294_i0 | PRJNA867519 | 7448 | 404 | 1.652568 | 6.67637472 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 182 | 4.74e-41 | NTclustered | gi|984932283|gb|KT757195.1| | 37524 | g7294 | i0 | 97.222 | 30.3118811881188 | 108 | 2 | 27 | 1 | 297 | 404 | 885 | 991 | Liriope tetraphylla large subunit 28S ribosomal RNA gene, partial sequence | blastn | 12246 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Limnomedusae | Geryoniidae | Liriope | Liriope tetraphylla | |
| 11051861 | 11051861 | PRJNA867519_P_NODE_2969_length_596_cov_30.837476_g2818_i0 | PRJNA867519 | 2969 | 596 | 30.837476 | 183.79135696 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 514 | 6.26e-141 | NTclustered | gi|2782866953|ref|XM_067060166.1| | 252671 | g2818 | i0 | 87.168 | 70.6996644295302 | 452 | 58 | 76 | 0 | 113 | 564 | 557 | 106 | PREDICTED: Clytia hemisphaerica calmodulin (LOC136803441), mRNA | blastn | 42137 | 514 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 16150806 | 16150806 | PRJNA867519_P_NODE_30613_length_245_cov_0.895349_g30459_i0 | PRJNA867519 | 30613 | 245 | 0.895349 | 2.19360505 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 62.1 | 3.67e-5 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g30459 | i0 | 89.583 | 4.89795918367347 | 48 | 5 | 20 | 0 | 146 | 193 | 1087978 | 1088025 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 1200 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 18699502 | 18699502 | PRJNA867519_P_NODE_30615_length_245_cov_0.895349_g30461_i0 | PRJNA867519 | 30615 | 245 | 0.895349 | 2.19360505 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|1778041968|ref|XM_031702652.1| | 6105 | g30461 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 139 | 167 | 1520 | 1548 | PREDICTED: Actinia tenebrosa rab-like protein 6 (LOC116294956), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 20363313 | 20363313 | PRJNA867519_P_NODE_11336_length_342_cov_1.007435_g11182_i0 | PRJNA867519 | 11336 | 342 | 1.007435 | 3.4454277 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|2917940752|emb|OZ237570.1| | 6108 | g11182 | i0 | 100 | 0.353801169590643 | 28 | 0 | 8 | 0 | 114 | 141 | 9709220 | 9709247 | Anemonia sulcata genome assembly, chromosome: 16 | blastn | 121 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 21250394 | 21250394 | PRJNA867519_P_NODE_9977_length_358_cov_2.059649_g9823_i0 | PRJNA867519 | 9977 | 358 | 2.059649 | 7.37354342 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 62.1 | 5.63e-5 | NTclustered | gi|2202610586|ref|XM_046984966.1| | 2897299 | g9823 | i0 | 93.023 | 0.240223463687151 | 43 | 2 | 12 | 1 | 91 | 133 | 2112 | 2071 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124435019 (LOC124435019), transcript variant X1, mRNA | blastn | 86 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 21639016 | 21639016 | PRJNA867519_P_NODE_25857_length_251_cov_0.865169_g25703_i0 | PRJNA867519 | 25857 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 75 | 4.85e-9 | NTclustered | gi|2113846939|ref|XM_044328182.1| | 45264 | g25703 | i0 | 92.308 | 6.70916334661355 | 52 | 4 | 21 | 0 | 3 | 54 | 348 | 399 | PREDICTED: Acropora millepora histone H2A-like (LOC122964539), mRNA | blastn | 1684 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 22524738 | 22524738 | PRJNA867519_P_NODE_13118_length_322_cov_1.184739_g12964_i0 | PRJNA867519 | 13118 | 322 | 1.184739 | 3.81485958 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 233 | 1.01e-56 | NTclustered | gi|1619629998|ref|XM_021041953.2| | 2652724 | g12964 | i0 | 82.707 | 77.2888198757764 | 266 | 42 | 82 | 4 | 4 | 267 | 788 | 1051 | PREDICTED: Exaiptasia diaphana serine/threonine-protein phosphatase alpha-2 isoform (LOC110236432), mRNA | blastn | 24887 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 22524852 | 22524852 | PRJNA867519_P_NODE_29098_length_247_cov_0.885057_g28944_i0 | PRJNA867519 | 29098 | 247 | 0.885057 | 2.18609079 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g28944 | i0 | 100 | 0.117408906882591 | 29 | 0 | 12 | 0 | 76 | 104 | 38791421 | 38791449 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 25074192 | 25074192 | PRJNA867519_P_NODE_22680_length_263_cov_2.705263_g22526_i0 | PRJNA867519 | 22680 | 263 | 2.705263 | 7.11484169 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 71.3 | 6.63e-8 | NTclustered | gi|1603790370|ref|XM_028542900.1| | 151771 | g22526 | i0 | 86.567 | 0.254752851711027 | 67 | 6 | 24 | 3 | 164 | 227 | 1220 | 1286 | PREDICTED: Dendronephthya gigantea presenilin-1-like (LOC114522254), mRNA | blastn | 67 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea |
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);;