RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA986481 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
3523752 3523752 PRJNA986481_P_NODE_10083_length_516_cov_1.918630_g9563_i0 PRJNA986481 10083 516 1.91863 9.9001308 Anemonia sulcata 6108 Cnidaria other_Eukaryota 69.4 5.02e-7   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g9563 i0 97.561 12.4302325581395 41 0 9 1 234 273 25671823 25671783 Anemonia sulcata genome assembly, chromosome: 1 blastn 6414 69.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
20100249 20100249 PRJNA986481_P_NODE_48316_length_254_cov_0.985366_g47791_i0 PRJNA986481 48316 254 0.985366 2.50282964 Acropora digitifera 70779 Cnidaria other_Eukaryota 52.8 0.023   NTclustered gi|1005431766|ref|XM_015898063.1| 70779 g47791 i0 100 0.110236220472441 28 0 11 0 145 172 607 634 PREDICTED: Acropora digitifera von Willebrand factor D and EGF domain-containing protein-like (LOC107333277), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
23925759 23925759 PRJNA986481_P_NODE_13979_length_438_cov_5.172237_g13455_i0 PRJNA986481 13979 438 5.172237 22.65439806 Orbicella faveolata 48498 Cnidaria other_Eukaryota 52.8 0.042   NTclustered gi|1176088533|ref|XR_002297069.1| 48498 g13455 i0 100 0.319634703196347 28 0 6 0 163 190 1862 1889 PREDICTED: Orbicella faveolata uncharacterized LOC110052784 (LOC110052784), transcript variant X1, ncRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
23926024 23926024 PRJNA986481_P_NODE_30319_length_297_cov_1.572581_g29794_i0 PRJNA986481 30319 297 1.572581 4.67056557 Eunicella cavolini 317547 Cnidaria other_Eukaryota 60.2 1.65e-4   NTclustered gi|2918369536|emb|OZ237718.1| 317547 g29794 i0 97.222 0.121212121212121 36 0 12 1 95 130 21975556 21975522 Eunicella cavolini genome assembly, chromosome: 2 blastn 36 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
25498541 25498541 PRJNA986481_P_NODE_30260_length_297_cov_2.241935_g29735_i0 PRJNA986481 30260 297 2.241935 6.65854695 Metazoa 33208 Cnidaria other_Eukaryota 52.8 0.028   NTclustered gi|2917940731|emb|OZ237564.1| 6108 g29735 i0 100 0.292929292929293 28 0 9 0 265 292 12105366 12105339 Anemonia sulcata genome assembly, chromosome: 10 blastn 87 52.8 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);;