RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB81327 · 4 ✖

analysis 1

  • blastn · 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
2690348 2690348 PRJEB81327_P_NODE_8523_length_475_cov_2.860697_g7915_i0 PRJEB81327 8523 475 2.860697 13.58831075 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 329 1.91e-85   NTclustered gi|2782857558|ref|XM_067058140.1| 252671 g7915 i0 81.683 92.4694736842105 404 66 84 8 3 402 1259 860 PREDICTED: Clytia hemisphaerica actin, non-muscle 6.2 (LOC136801505), mRNA blastn 43923 329 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
3547614 3547614 PRJEB81327_P_NODE_41723_length_258_cov_1.664865_g41115_i0 PRJEB81327 41723 258 1.664865 4.2953517 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 161 3.74e-35   NTclustered gi|166007989|gb|EU247810.1| 166266 g41115 i0 89.231 48.515503875969 130 12 50 2 131 258 843 972 Maeotias marginata 28S large subunit ribosomal RNA gene, partial sequence blastn 12517 161 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Limnomedusae Olindiidae Maeotias Maeotias marginata
9067381 9067381 PRJEB81327_P_NODE_57128_length_245_cov_1.156977_g56520_i0 PRJEB81327 57128 245 1.156977 2.83459365 Anemonia sulcata 6108 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|2917940696|emb|OZ237557.1| 6108 g56520 i0 86 0.204081632653061 50 7 20 0 196 245 12940669 12940718 Anemonia sulcata genome assembly, chromosome: 3 blastn 50 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
24366021 24366021 PRJEB81327_P_NODE_64720_length_241_cov_0.916667_g64112_i0 PRJEB81327 64720 241 0.916667 2.20916747 Eunicea flexuosa 437162 Cnidaria other_Eukaryota 86.1 2.14e-12   NTclustered gi|2689317196|gb|PP410695.1| 437162 g64112 i0 87.838 0.614107883817427 74 5 30 4 1 73 2138 2068 Eunicea flexuosa voucher USNM:1606843 large subunit ribosomal RNA gene, partial sequence blastn 148 86.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Eunicea Eunicea flexuosa

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