RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB28589" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB28589 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27722177 27722177 PRJEB28589_S_NODE_16964_length_170_cov_1.455285_g16856_i0 PRJEB28589 16964 170 1.455285 2.4739845 Metazoa 33208 Cnidaria other_Eukaryota 81.3 3.68e-16   NR XP_031552906.1 6105 g16856 i0 97.2 502.323529411765 36 1 63.5 0 151 44 1551 1586 XP_031552906.1 disco-interacting protein 2-like [Actinia tenebrosa] diamond 85395 82 0.991463414634146 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
28580849 28580849 PRJEB28589_S_NODE_11247_length_231_cov_1.108696_g11139_i0 PRJEB28589 11247 231 1.108696 2.56108776 Pocillopora damicornis 46731 Cnidaria other_Eukaryota 48.9 2.15e-4   NR RMX51535.1 46731 g11139 i0 47.3 0.714285714285714 55 28 70.1 1 231 70 431 485 RMX51535.1 hypothetical protein pdam_00010321 [Pocillopora damicornis] diamond 165 48.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
32144814 32144814 PRJEB28589_S_NODE_17198_length_168_cov_1.933884_g17090_i0 PRJEB28589 17198 168 1.933884 3.24892512 Metazoa 33208 Cnidaria other_Eukaryota 53.1 2.84e-6   NR XP_065644490.1 6087 g17090 i0 54.2 2.57142857142857 48 22 85.7 0 23 166 586 633 XP_065644490.1 uncharacterized protein LOC136075392 isoform X1 [Hydra vulgaris] diamond 432 53.5 0.992523364485981 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
32303284 32303284 PRJEB28589_S_NODE_18179_length_162_cov_1.556522_g18071_i0 PRJEB28589 18179 162 1.556522 2.52156564 Acropora 6127 Cnidaria other_Eukaryota 67 2.15e-11   NR XP_015779512.1 70779 g18071 i0 60.8 4.64814814814815 51 18 90.7 1 162 16 21 71 XP_015779512.1 PREDICTED: uncharacterized protein LOC107357391 [Acropora digitifera] diamond 753 67 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera

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