contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 692951 | 692951 | PRJNA704949_P_NODE_1879441_length_172_cov_1.268293_g1864102_i0 | PRJNA704949 | 1879441 | 172 | 1.268293 | 2.18146396 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|1778026920|ref|XM_031694773.1| | 6105 | g1864102 | i0 | 100 | 0.162790697674419 | 28 | 0 | 16 | 0 | 4 | 31 | 1380 | 1407 | PREDICTED: Actinia tenebrosa cannabinoid receptor 1-like (LOC116288062), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 699644 | 699644 | PRJNA704949_P_NODE_655961_length_334_cov_1.333333_g640635_i0 | PRJNA704949 | 655961 | 334 | 1.333333 | 4.45333222 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|1619636416|ref|XM_021043382.2| | 2652724 | g640635 | i0 | 100 | 0.0838323353293413 | 28 | 0 | 8 | 0 | 25 | 52 | 4538 | 4511 | PREDICTED: Exaiptasia diaphana ATP-dependent DNA helicase Q5 (LOC110237770), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 5793010 | 5793010 | PRJNA704949_P_NODE_1434665_length_207_cov_1.240506_g1419327_i0 | PRJNA704949 | 1434665 | 207 | 1.240506 | 2.56784742 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 97.1 | 8.25e-16 | NTclustered | gi|2782894698|ref|XM_067067084.1| | 252671 | g1419327 | i0 | 80.769 | 2.33333333333333 | 130 | 20 | 62 | 5 | 69 | 196 | 1407 | 1281 | PREDICTED: Clytia hemisphaerica DNA repair protein RAD51 homolog 3-like (LOC136810507), mRNA | blastn | 483 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 5796791 | 5796791 | PRJNA704949_P_NODE_1907965_length_170_cov_1.289256_g1892626_i0 | PRJNA704949 | 1907965 | 170 | 1.289256 | 2.1917352 | Chrysaora quinquecirrha | 6148 | Cnidaria | other_Eukaryota | 63.9 | 6.57e-6 | NTclustered | gi|1967532496|gb|MW401676.1| | 6148 | g1892626 | i0 | 93.182 | 0.258823529411765 | 44 | 2 | 25 | 1 | 63 | 105 | 10170 | 10213 | Chrysaora quinquecirrha mitochondrion, complete genome | blastn | 44 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Semaeostomeae | Pelagiidae | Chrysaora | Chrysaora quinquecirrha | |
| 8342127 | 8342127 | PRJNA704949_P_NODE_1371087_length_213_cov_1.378049_g1355749_i0 | PRJNA704949 | 1371087 | 213 | 1.378049 | 2.93524437 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.019 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g1355749 | i0 | 100 | 0.131455399061033 | 28 | 0 | 13 | 0 | 16 | 43 | 32483424 | 32483451 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11392344 | 11392344 | PRJNA704949_P_NODE_261189_length_522_cov_2.067653_g246577_i0 | PRJNA704949 | 261189 | 522 | 2.067653 | 10.79314866 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 78.7 | 8.44e-10 | NTclustered | gi|2917940744|emb|OZ237568.1| | 6108 | g246577 | i0 | 83.529 | 2.11877394636015 | 85 | 13 | 16 | 1 | 416 | 500 | 12267771 | 12267688 | Anemonia sulcata genome assembly, chromosome: 14 | blastn | 1106 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13942253 | 13942253 | PRJNA704949_P_NODE_2112671_length_164_cov_0.904348_g2097332_i0 | PRJNA704949 | 2112671 | 164 | 0.904348 | 1.48313072 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 63.9 | 6.33e-6 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g2097332 | i0 | 100 | 5.64634146341463 | 34 | 0 | 21 | 0 | 84 | 117 | 15781053 | 15781086 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 926 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 14716560 | 14716560 | PRJNA704949_P_NODE_1203012_length_232_cov_1.136612_g1187675_i0 | PRJNA704949 | 1203012 | 232 | 1.136612 | 2.63693984 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 69.4 | 2.06e-7 | NTclustered | gi|2257805163|ref|XM_001641825.3| | 45351 | g1187675 | i0 | 75.497 | 0.892241379310345 | 151 | 32 | 64 | 5 | 13 | 160 | 777 | 925 | PREDICTED: Nematostella vectensis inosine-5'-monophosphate dehydrogenase 1b (LOC5521993), mRNA | blastn | 207 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 15990340 | 15990340 | PRJNA704949_P_NODE_1221793_length_229_cov_2.600000_g1206456_i0 | PRJNA704949 | 1221793 | 229 | 2.6 | 5.954 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 121 | 5.519999999999999e-23 | NTclustered | gi|2519019259|ref|XM_057460967.1| | 13093 | g1206456 | i0 | 81.633 | 0.641921397379913 | 147 | 25 | 64 | 2 | 64 | 209 | 515 | 370 | PREDICTED: Hydractinia symbiolongicarpus ubiquitin-40S ribosomal protein S27a (LOC130657959), mRNA | blastn | 147 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 18549947 | 18549947 | PRJNA704949_P_NODE_493495_length_388_cov_1.362832_g478244_i0 | PRJNA704949 | 493495 | 388 | 1.362832 | 5.28778816 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 82.4 | 4.73e-11 | NTclustered | gi|2917940737|emb|OZ237566.1| | 6108 | g478244 | i0 | 94.34 | 41.7061855670103 | 53 | 3 | 14 | 0 | 336 | 388 | 6506733 | 6506785 | Anemonia sulcata genome assembly, chromosome: 12 | blastn | 16182 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 19826030 | 19826030 | PRJNA704949_P_NODE_588576_length_354_cov_1.600000_g573257_i0 | PRJNA704949 | 588576 | 354 | 1.6 | 5.664 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|2744838618|ref|XM_065787177.1| | 6087 | g573257 | i0 | 100 | 0.23728813559322 | 28 | 0 | 8 | 0 | 130 | 157 | 1275 | 1302 | PREDICTED: Hydra vulgaris uncharacterized LOC136074994 (LOC136074994), transcript variant X3, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 19827987 | 19827987 | PRJNA704949_P_NODE_811116_length_295_cov_2.849593_g795784_i0 | PRJNA704949 | 811116 | 295 | 2.849593 | 8.40629935 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 87.9 | 7.51e-13 | NTclustered | gi|2729067059|ref|XM_065195473.1| | 499914 | g795784 | i0 | 86.42 | 0.416949152542373 | 81 | 10 | 27 | 1 | 158 | 237 | 3163 | 3083 | PREDICTED: Rhopilema esculentum craniofacial development protein 2-like (LOC135681158), mRNA | blastn | 123 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 22867299 | 22867299 | PRJNA704949_P_NODE_597798_length_351_cov_1.721854_g582475_i0 | PRJNA704949 | 597798 | 351 | 1.721854 | 6.04370754 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 289 | 2.32e-73 | NTclustered | gi|636577207|gb|KJ483041.1| | 51773 | g582475 | i0 | 84.459 | 83.7464387464387 | 296 | 43 | 84 | 3 | 4 | 298 | 958 | 1251 | Corynactis viridis 28S large subunit ribosomal RNA gene and external transcribed spacer, partial sequence | blastn | 29395 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Corallimorpharia | Corallimorphidae | Corynactis | Corynactis viridis | |
| 25412187 | 25412187 | PRJNA704949_P_NODE_1133420_length_241_cov_1.083333_g1118084_i0 | PRJNA704949 | 1133420 | 241 | 1.083333 | 2.61083253 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|1524873816|ref|XM_027188540.1| | 46731 | g1118084 | i0 | 100 | 0.705394190871369 | 29 | 0 | 12 | 0 | 43 | 71 | 883 | 855 | PREDICTED: Pocillopora damicornis keratin-associated protein 10-5-like (LOC113672255), mRNA | blastn | 170 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 25412985 | 25412985 | PRJNA704949_P_NODE_141380_length_678_cov_2.171701_g128059_i0 | PRJNA704949 | 141380 | 678 | 2.171701 | 14.72413278 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 65.8 | 8.68e-6 | NTclustered | gi|1524891704|ref|XM_027198052.1| | 46731 | g128059 | i0 | 95.122 | 0.210914454277286 | 41 | 2 | 6 | 0 | 291 | 331 | 4180 | 4220 | PREDICTED: Pocillopora damicornis collagen alpha-1(III) chain-like (LOC113680997), mRNA | blastn | 143 | 65.8 | 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);;