RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA680334 · 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
650415 650415 PRJNA680334_S_NODE_84101_length_162_cov_4.186047_g83615_i0 PRJNA680334 84101 162 4.186047 6.78139614 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 52.8 0.013   NTclustered gi|2782839894|ref|XM_067055043.1| 252671 g83615 i0 100 0.345679012345679 28 0 17 0 92 119 7961 7988 PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136798434), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
1925824 1925824 PRJNA680334_S_NODE_40642_length_204_cov_8.888889_g40156_i0 PRJNA680334 40642 204 8.888889 18.13333356 Pocillopora verrucosa 203993 Cnidaria other_Eukaryota 54.7 0.005   NTclustered gi|2751561322|ref|XM_066170206.1| 203993 g40156 i0 100 0.142156862745098 29 0 14 0 146 174 54 26 PREDICTED: Pocillopora verrucosa serine-rich adhesin for platelets-like (LOC131778651), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora verrucosa
4478197 4478197 PRJNA680334_S_NODE_71144_length_171_cov_5.137681_g70658_i0 PRJNA680334 71144 171 5.137681 8.78543451 Anemonia sulcata 6108 Cnidaria other_Eukaryota 62.1 2.38e-5   NTclustered gi|2917940737|emb|OZ237566.1| 6108 g70658 i0 94.872 21.5555555555556 39 2 23 0 50 88 11801012 11800974 Anemonia sulcata genome assembly, chromosome: 12 blastn 3686 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
11372795 11372795 PRJNA680334_S_NODE_18129_length_262_cov_3.838428_g17643_i0 PRJNA680334 18129 262 3.838428 10.05668136 Opisthokonta 33154 Cnidaria other_Eukaryota 130 1.07e-25   NTclustered gi|1270066931|ref|XM_022940473.1| 50429 g17643 i0 77.727 54.175572519084 220 44 83 4 45 262 475 259 PREDICTED: Stylophora pistillata uncharacterized LOC111334664 (LOC111334664), mRNA blastn 14194 130 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
13403334 13403334 PRJNA680334_S_NODE_16091_length_271_cov_54.882353_g15605_i0 PRJNA680334 16091 271 54.882353 148.73117663 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.025   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g15605 i0 100 0.103321033210332 28 0 10 0 181 208 1923041 1923014 Anemonia sulcata genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
15197839 15197839 PRJNA680334_S_NODE_51792_length_190_cov_1.566879_g51306_i0 PRJNA680334 51792 190 1.566879 2.9770701 root 1 Root_unresolved Root_unresolved 52.8 0.016   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g51306 i0 100 0.589473684210526 28 0 15 0 108 135 5000108 5000081 Anemonia sulcata genome assembly, chromosome: 1 blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
15952198 15952198 PRJNA680334_S_NODE_23233_length_243_cov_2.642857_g22747_i0 PRJNA680334 23233 243 2.642857 6.42214251 Stylophora pistillata 50429 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|1270061058|ref|XM_022937329.1| 50429 g22747 i0 100 0.358024691358025 29 0 12 0 193 221 3434 3462 PREDICTED: Stylophora pistillata mediator of DNA damage checkpoint protein 1-like (LOC111332069), transcript variant X1, mRNA blastn 87 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata

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