RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA533623 · 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
5610865 5610865 PRJNA533623_P_NODE_66485_length_231_cov_4.311765_g64704_i0 PRJNA533623 66485 231 4.311765 9.96017715 Laodicea undulata 662012 Cnidaria other_Eukaryota 91.6 4.37e-14   NTclustered gi|256674486|gb|FJ550390.1| 662012 g64704 i0 85.556 25.8095238095238 90 10 38 3 145 231 373 462 Laodicea undulata voucher MHNG INVE31753 28S ribosomal RNA gene, partial sequence blastn 5962 91.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Laodiceidae Laodicea Laodicea undulata
6884466 6884466 PRJNA533623_P_NODE_53906_length_278_cov_0.811060_g52127_i0 PRJNA533623 53906 278 0.81106 2.2547468 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|1191051559|ref|XM_021047964.1| 2652724 g52127 i0 100 0.10431654676259 29 0 10 0 80 108 3846 3818 PREDICTED: Exaiptasia diaphana monocarboxylate transporter 10 (LOC110242031), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
8159686 8159686 PRJNA533623_P_NODE_56687_length_266_cov_11.282927_g54907_i0 PRJNA533623 56687 266 11.282927 30.01258582 Acropora muricata 159855 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|2784679309|ref|XM_067169918.1| 159855 g54907 i0 100 0.109022556390977 29 0 11 0 115 143 119 147 PREDICTED: Acropora muricata uncharacterized protein (LOC136897032), transcript variant X3, mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora muricata
13260147 13260147 PRJNA533623_P_NODE_33011_length_390_cov_5.504559_g31240_i0 PRJNA533623 33011 390 5.504559 21.4677801 Eunicella cavolini 317547 Cnidaria other_Eukaryota 63.9 1.72e-5   NTclustered gi|2918369536|emb|OZ237718.1| 317547 g31240 i0 82.716 1.74102564102564 81 5 20 9 55 133 65601797 65601870 Eunicella cavolini genome assembly, chromosome: 2 blastn 679 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
14534845 14534845 PRJNA533623_P_NODE_19992_length_522_cov_21.934924_g18247_i0 PRJNA533623 19992 522 21.934924 114.50030328 Anemonia sulcata 6108 Cnidaria other_Eukaryota 60.2 3.06e-4   NTclustered gi|2917940756|emb|OZ237571.1| 6108 g18247 i0 97.143 2.31034482758621 35 1 7 0 372 406 12189174 12189140 Anemonia sulcata genome assembly, chromosome: 17 blastn 1206 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
15145773 15145773 PRJNA533623_P_NODE_17332_length_564_cov_10.127237_g15604_i0 PRJNA533623 17332 564 10.127237 57.11761668 root 1 Root_unresolved Root_unresolved 65.8 7.14e-6   NTclustered gi|1778058997|ref|XM_031710919.1| 6105 g15604 i0 88.679 19.0230496453901 53 6 9 0 266 318 2316 2368 PREDICTED: Actinia tenebrosa major facilitator superfamily domain-containing protein 6-like (LOC116301801), mRNA blastn 10729 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
24732845 24732845 PRJNA533623_P_NODE_5820_length_950_cov_3.475816_g4546_i0 PRJNA533623 5820 950 3.475816 33.020252 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 56.5 0.007   NTclustered gi|224287113|gb|AC234883.1| 13093 g4546 i0 100 0.0315789473684211 30 0 3 0 706 735 30807 30836 Hydractinia symbiolongicarpus clone YU00-84I16, complete sequence blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus

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