RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA927284" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA927284 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
4730293 4730293 PRJNA927284_P_NODE_44_length_2821_cov_4.331662_g37_i0 PRJNA927284 44 2821 4.331662 122.19618502 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 453 6.87e-122   NTclustered gi|1778058141|ref|XM_031710468.1| 6105 g37 i0 81.034 19.8089330024814 580 100 20 7 2162 2736 742 168 PREDICTED: Actinia tenebrosa ras-related protein Rab-7a (LOC116301417), mRNA blastn 55881 453 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
8905356 8905356 PRJNA927284_P_NODE_3407_length_349_cov_1.834375_g3202_i0 PRJNA927284 3407 349 1.834375 6.40196875 Acropora 6127 Cnidaria other_Eukaryota 52.8 0.033   NTclustered gi|2114314307|ref|XM_044325267.1| 45264 g3202 i0 100 0.160458452722063 28 0 8 0 154 181 1102 1129 PREDICTED: Acropora millepora cullin-associated NEDD8-dissociated protein 1-like (LOC114948737), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
11105430 11105430 PRJNA927284_P_NODE_2889_length_391_cov_1.770718_g2687_i0 PRJNA927284 2889 391 1.770718 6.92350738 Acropora millepora 45264 Cnidaria other_Eukaryota 82.4 4.77e-11   NTclustered gi|2113842426|ref|XM_044328091.1| 45264 g2687 i0 76.73 4.0076726342711 159 30 39 6 206 359 1420 1264 PREDICTED: Acropora millepora cytosolic non-specific dipeptidase-like (LOC114951153), transcript variant X1, mRNA blastn 1567 82.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora

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