RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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

  • PRJNA1095825 · 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
1019272 1019272 PRJNA1095825_P_NODE_132721_length_335_cov_1.469466_g129658_i0 PRJNA1095825 132721 335 1.469466 4.9227111 Opisthokonta 33154 Cnidaria other_Eukaryota 54.7 0.009   NTclustered gi|2917940731|emb|OZ237564.1| 6108 g129658 i0 100 0.516417910447761 29 0 9 0 240 268 9386824 9386852 Anemonia sulcata genome assembly, chromosome: 10 blastn 173 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
6578794 6578794 PRJNA1095825_P_NODE_256226_length_248_cov_0.880000_g253163_i0 PRJNA1095825 256226 248 0.88 2.1824 Hydra vulgaris 6087 Cnidaria other_Eukaryota 309 1.21e-79   NTclustered gi|2744816405|ref|XM_047280136.2| 6087 g253163 i0 92.694 2.6491935483871 219 8 85 2 1 211 2192 1974 PREDICTED: Hydra vulgaris TNF receptor-associated factor 4 (LOC100203793), transcript variant X3, mRNA blastn 657 309 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
13772762 13772762 PRJNA1095825_P_NODE_194391_length_280_cov_2.130435_g191328_i0 PRJNA1095825 194391 280 2.130435 5.965218 Metazoa 33208 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2917940744|emb|OZ237568.1| 6108 g191328 i0 100 2.97857142857143 30 0 11 0 191 220 12182145 12182116 Anemonia sulcata genome assembly, chromosome: 14 blastn 834 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
14229575 14229575 PRJNA1095825_P_NODE_260372_length_247_cov_0.885057_g257309_i0 PRJNA1095825 260372 247 0.885057 2.18609079 Nematostella vectensis 45351 Cnidaria other_Eukaryota 152 2.1399999999999998e-32   NTclustered gi|2257873693|ref|XM_048726870.1| 45351 g257309 i0 86.713 3.21862348178138 143 11 56 8 36 173 441 580 PREDICTED: Nematostella vectensis uncharacterized LOC5501568 (LOC5501568), mRNA blastn 795 152 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
15503980 15503980 PRJNA1095825_P_NODE_33393_length_681_cov_1.103618_g30393_i0 PRJNA1095825 33393 681 1.103618 7.51563858 Anemonia sulcata 6108 Cnidaria other_Eukaryota 58.4 0.001   NTclustered gi|2917940724|emb|OZ237563.1| 6108 g30393 i0 100 0.0455212922173275 31 0 5 0 328 358 6589899 6589869 Anemonia sulcata genome assembly, chromosome: 9 blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
16776991 16776991 PRJNA1095825_P_NODE_154794_length_313_cov_1.529167_g151731_i0 PRJNA1095825 154794 313 1.529167 4.78629271 Hydra vulgaris 6087 Cnidaria other_Eukaryota 440 5.349999999999999e-119   NTclustered gi|2744831861|ref|XM_065785009.1| 6087 g151731 i0 92.013 6 313 25 100 0 1 313 2240 1928 PREDICTED: Hydra vulgaris uncharacterized LOC124819170 (LOC124819170), transcript variant X2, mRNA blastn 1878 440 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
18051943 18051943 PRJNA1095825_P_NODE_197155_length_278_cov_2.243902_g194092_i0 PRJNA1095825 197155 278 2.243902 6.23804756 Anemonia sulcata 6108 Cnidaria other_Eukaryota 71.3 7.06e-8   NTclustered gi|2917940701|emb|OZ237558.1| 6108 g194092 i0 95.556 28.431654676259 45 0 17 1 93 137 10566244 10566202 Anemonia sulcata genome assembly, chromosome: 4 blastn 7904 71.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
22696404 22696404 PRJNA1095825_P_NODE_228278_length_256_cov_1.683060_g225215_i0 PRJNA1095825 228278 256 1.68306 4.3086336 Cnidaria 6073 Cnidaria other_Eukaryota 52.8 0.023   NTclustered gi|2917940720|emb|OZ237562.1| 6108 g225215 i0 100 0.21875 28 0 11 0 56 83 412334 412307 Anemonia sulcata genome assembly, chromosome: 8 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
23152478 23152478 PRJNA1095825_P_NODE_190179_length_284_cov_1.023697_g187116_i0 PRJNA1095825 190179 284 1.023697 2.90729948 Hydra vulgaris 6087 Cnidaria other_Eukaryota 436 6.2e-118   NTclustered gi|2744816405|ref|XM_047280136.2| 6087 g187116 i0 94.158 4.09859154929577 291 9 99 2 2 284 3954 3664 PREDICTED: Hydra vulgaris TNF receptor-associated factor 4 (LOC100203793), transcript variant X3, mRNA blastn 1164 436 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
24427247 24427247 PRJNA1095825_P_NODE_37020_length_640_cov_1.742504_g33992_i0 PRJNA1095825 37020 640 1.742504 11.1520256 Eunicella cavolini 317547 Cnidaria other_Eukaryota 56.5 0.005   NTclustered gi|2918369554|emb|OZ237726.1| 317547 g33992 i0 100 0.046875 30 0 5 0 311 340 8538086 8538057 Eunicella cavolini genome assembly, chromosome: 10 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini

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