RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1249042" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1249042 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1629145 1629145 PRJNA1249042_S_NODE_28782_length_244_cov_1.611940_g28568_i0 PRJNA1249042 28782 244 1.61194 3.9331336 Eunicella cavolini 317547 Cnidaria other_Eukaryota 62.1 3.66e-5   NTclustered gi|2918369567|emb|OZ237733.1| 317547 g28568 i0 90 0.204918032786885 50 2 20 3 112 161 250880 250834 Eunicella cavolini genome assembly, chromosome: 17 blastn 50 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
6732646 6732646 PRJNA1249042_S_NODE_92606_length_167_cov_1.548387_g92392_i0 PRJNA1249042 92606 167 1.548387 2.58580629 Eunicella cavolini 317547 Cnidaria other_Eukaryota 56.5 0.001   NTclustered gi|2918369552|emb|OZ237724.1| 317547 g92392 i0 100 0.179640718562874 30 0 18 0 44 73 14057433 14057462 Eunicella cavolini genome assembly, chromosome: 8 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
9282534 9282534 PRJNA1249042_S_NODE_21128_length_261_cov_2.527523_g20914_i0 PRJNA1249042 21128 261 2.527523 6.59683503 Hydra vulgaris 6087 Cnidaria other_Eukaryota 52.8 0.024   NTclustered gi|2744893764|ref|XR_010642317.1| 6087 g20914 i0 100 0.10727969348659 28 0 11 0 136 163 1674 1701 PREDICTED: Hydra vulgaris uncharacterized LOC136088605 (LOC136088605), ncRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
13108321 13108321 PRJNA1249042_S_NODE_36311_length_230_cov_1.834225_g36097_i0 PRJNA1249042 36311 230 1.834225 4.2187175 Anemonia sulcata 6108 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2917940766|emb|OZ237573.1| 6108 g36097 i0 94.444 0.156521739130435 36 2 16 0 25 60 10324652 10324617 Anemonia sulcata genome assembly, chromosome: 19 blastn 36 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
13108494 13108494 PRJNA1249042_S_NODE_58211_length_200_cov_2.019108_g57997_i0 PRJNA1249042 58211 200 2.019108 4.038216 Anemonia sulcata 6108 Cnidaria other_Eukaryota 54.7 0.005   NTclustered gi|2917940703|emb|OZ237559.1| 6108 g57997 i0 100 0.145 29 0 15 0 110 138 190678 190706 Anemonia sulcata genome assembly, chromosome: 5 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
14383261 14383261 PRJNA1249042_S_NODE_102172_length_160_cov_1.205128_g101958_i0 PRJNA1249042 102172 160 1.205128 1.9282048 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 54.7 0.004   NTclustered gi|1778061432|ref|XM_031712209.1| 6105 g101958 i0 96.875 0.2 32 1 20 0 18 49 2459 2428 PREDICTED: Actinia tenebrosa matrix metalloproteinase-25-like (LOC116302823), mRNA blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
15657401 15657401 PRJNA1249042_S_NODE_40453_length_223_cov_2.911111_g40239_i0 PRJNA1249042 40453 223 2.911111 6.49177753 Anemonia sulcata 6108 Cnidaria other_Eukaryota 60.2 1.18e-4   NTclustered gi|2917940766|emb|OZ237573.1| 6108 g40239 i0 100 0.143497757847534 32 0 14 0 188 219 8609603 8609634 Anemonia sulcata genome assembly, chromosome: 19 blastn 32 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata

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