RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA975724" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA975724 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
2542548 2542548 PRJNA975724_S_NODE_9802_length_452_cov_3.343008_g9621_i0 PRJNA975724 9802 452 3.343008 15.11039616 Aurelia 6144 Cnidaria other_Eukaryota 132 5.470000000000001e-26   NTclustered gi|806386891|dbj|LC005414.1| 237397 g9621 i0 81.875 8.55309734513274 160 25 35 4 2 159 1778 1621 Aurelia sp. 4 sensu Dawson et al. (2005) mitochondrial DNA, complete genome blastn 3866 132 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Semaeostomeae Ulmaridae Aurelia Aurelia sp. 4 sensu Dawson et al. (2005)
6370874 6370874 PRJNA975724_S_NODE_14045_length_419_cov_1.656069_g13864_i0 PRJNA975724 14045 419 1.656069 6.93892911 Aurelia 6144 Cnidaria other_Eukaryota 106 3.05e-18   NTclustered gi|806386891|dbj|LC005414.1| 237397 g13864 i0 92 17.1766109785203 75 6 18 0 135 209 1809 1735 Aurelia sp. 4 sensu Dawson et al. (2005) mitochondrial DNA, complete genome blastn 7197 106 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Semaeostomeae Ulmaridae Aurelia Aurelia sp. 4 sensu Dawson et al. (2005)
8599088 8599088 PRJNA975724_S_NODE_4187_length_545_cov_1.908898_g4009_i0 PRJNA975724 4187 545 1.908898 10.4034941 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 97.1 2.44e-15   NTclustered gi|2729058829|ref|XR_010517322.1| 499914 g4009 i0 95.082 23.2844036697248 61 3 11 0 463 523 3549 3609 PREDICTED: Rhopilema esculentum large subunit ribosomal RNA (LOC135695981), rRNA blastn 12690 97.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
15294723 15294723 PRJNA975724_S_NODE_2592_length_618_cov_73.227523_g2420_i0 PRJNA975724 2592 618 73.227523 452.54609214 Leptothecata 500008 Cnidaria other_Eukaryota 217 2.05e-51   NTclustered gi|66864859|gb|AY920799.1| 6100 g2420 i0 84.12 51.8398058252427 233 28 54 9 13 242 2451 2677 Aequorea victoria large subunit 28S ribosomal RNA gene, partial sequence blastn 32037 217 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Aequoreidae Aequorea Aequorea victoria
17523549 17523549 PRJNA975724_S_NODE_17834_length_397_cov_1.712963_g17653_i0 PRJNA975724 17834 397 1.712963 6.80046311 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.038   NTclustered gi|2917940712|emb|OZ237560.1| 6108 g17653 i0 96.774 0.0780856423173804 31 1 8 0 93 123 11317190 11317220 Anemonia sulcata genome assembly, chromosome: 6 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
17525354 17525354 PRJNA975724_S_NODE_85134_length_246_cov_0.890173_g84953_i0 PRJNA975724 85134 246 0.890173 2.18982558 Anemonia sulcata 6108 Cnidaria other_Eukaryota 60.2 1.33e-4   NTclustered gi|2917940737|emb|OZ237566.1| 6108 g84953 i0 97.143 1.69918699186992 35 1 14 0 207 241 11790617 11790651 Anemonia sulcata genome assembly, chromosome: 12 blastn 418 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
21669118 21669118 PRJNA975724_S_NODE_44277_length_309_cov_4.241525_g44096_i0 PRJNA975724 44277 309 4.241525 13.10631225 Metazoa 33208 Cnidaria other_Eukaryota 52.8 0.029   NTclustered gi|2917940735|emb|OZ237565.1| 6108 g44096 i0 100 0.935275080906149 28 0 9 0 98 125 11252093 11252066 Anemonia sulcata genome assembly, chromosome: 11 blastn 289 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
23899030 23899030 PRJNA975724_S_NODE_57459_length_283_cov_1.738095_g57278_i0 PRJNA975724 57459 283 1.738095 4.91880885 Anemonia sulcata 6108 Cnidaria other_Eukaryota 65.8 3.35e-6   NTclustered gi|2917940724|emb|OZ237563.1| 6108 g57278 i0 100 25.6183745583039 35 0 12 0 26 60 7612711 7612677 Anemonia sulcata genome assembly, chromosome: 9 blastn 7250 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
23899896 23899896 PRJNA975724_S_NODE_88059_length_243_cov_2.264706_g87878_i0 PRJNA975724 88059 243 2.264706 5.50323558 Hydra vulgaris 6087 Cnidaria other_Eukaryota 80.5 1e-10   NTclustered gi|2744783096|ref|XM_004209988.4| 6087 g87878 i0 91.379 1.52263374485597 58 5 24 0 144 201 525 582 PREDICTED: Hydra vulgaris adenylate kinase isoenzyme 5 (LOC100215094), transcript variant X1, mRNA blastn 370 80.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
25172696 25172696 PRJNA975724_S_NODE_58360_length_281_cov_3.168269_g58179_i0 PRJNA975724 58360 281 3.168269 8.90283589 Montipora foliosa 591990 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|2812084986|ref|XM_068813917.1| 591990 g58179 i0 100 0.103202846975089 29 0 10 0 44 72 44 16 PREDICTED: Montipora foliosa BRCA1-associated RING domain protein 1-like (LOC137967375), transcript variant X4, mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora foliosa

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;