RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB81463" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB81463 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1415291 1415291 PRJEB81463_P_NODE_6642_length_388_cov_2.066667_g6370_i0 PRJEB81463 6642 388 2.066667 8.01866796 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 329 1.53e-85   NTclustered gi|2782873191|ref|XM_067061560.1| 252671 g6370 i0 81.959 52.951030927835 388 70 100 0 1 388 989 602 PREDICTED: Clytia hemisphaerica tubulin alpha-2/alpha-4 chain (LOC136805028), mRNA blastn 20545 329 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
9067871 9067871 PRJEB81463_P_NODE_27288_length_243_cov_0.917647_g27016_i0 PRJEB81463 27288 243 0.917647 2.22988221 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2519013470|ref|XM_057458142.1| 13093 g27016 i0 100 1.55555555555556 30 0 12 0 28 57 987 1016 PREDICTED: Hydractinia symbiolongicarpus keratin, type I cytoskeletal 9-like (LOC130655392), mRNA blastn 378 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
11200639 11200639 PRJEB81463_P_NODE_16989_length_267_cov_1.304124_g16717_i0 PRJEB81463 16989 267 1.304124 3.48201108 Metazoa 33208 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2917940724|emb|OZ237563.1| 6108 g16717 i0 100 1.00749063670412 30 0 11 0 128 157 455682 455653 Anemonia sulcata genome assembly, chromosome: 9 blastn 269 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
14169089 14169089 PRJEB81463_P_NODE_6852_length_382_cov_1.385113_g6580_i0 PRJEB81463 6852 382 1.385113 5.29113166 Hydra vulgaris 6087 Cnidaria other_Eukaryota 195 5.72e-45   NTclustered gi|2744782653|ref|XM_002164918.5| 6087 g6580 i0 76.166 39.3821989528796 386 82 99 9 1 381 564 184 PREDICTED: Hydra vulgaris large ribosomal subunit protein uL15 (LOC100215276), mRNA blastn 15044 195 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
15443114 15443114 PRJEB81463_P_NODE_30173_length_217_cov_4.256944_g29901_i0 PRJEB81463 30173 217 4.256944 9.23756848 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 215 2.31e-51   NTclustered gi|2782938510|ref|XM_067075511.1| 252671 g29901 i0 84.906 4.33179723502304 212 32 98 0 4 215 211 422 PREDICTED: Clytia hemisphaerica small ribosomal subunit protein uS12 (LOC136819280), mRNA blastn 940 215 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
23092375 23092375 PRJEB81463_P_NODE_20839_length_252_cov_0.871508_g20567_i0 PRJEB81463 20839 252 0.871508 2.19620016 Acropora millepora 45264 Cnidaria other_Eukaryota 202 2.14e-47   NTclustered gi|2114070846|ref|XM_044319240.1| 45264 g20567 i0 83.41 33.0515873015873 217 36 86 0 1 217 1039 1255 PREDICTED: Acropora millepora membrane-bound transcription factor site-1 protease-like (LOC114962121), mRNA blastn 8329 202 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);;