RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA436017 · 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
15116810 15116810 PRJNA436017_P_NODE_15752_length_208_cov_1.824561_g15454_i0 PRJNA436017 15752 208 1.824561 3.79508688 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 115 6.539999999999999e-31   NR QUL61907.1 6145 g15454 i0 83.8 39.2451923076923 68 11 98.1 0 1 204 52 119 QUL61907.1 cytochrome c oxidase subunit I, partial [Aurelia aurita] diamond 8163 116 0.991379310344828 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Semaeostomeae Ulmaridae Aurelia Aurelia aurita
27960203 27960203 PRJNA436017_P_NODE_17705_length_195_cov_1.221519_g17407_i0 PRJNA436017 17705 195 1.221519 2.38196205 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 87.4 1.64e-20   NR XP_020914455.1 2652724 g17407 i0 71.4 10.5692307692308 63 18 96.9 0 194 6 33 95 XP_020914455.1 60S ribosomal protein L36 [Exaiptasia diaphana] diamond 2061 87.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
28797381 28797381 PRJNA436017_P_NODE_23567_length_168_cov_1.290076_g23269_i0 PRJNA436017 23567 168 1.290076 2.16732768 Metazoa 33208 Cnidaria other_Eukaryota 92 1.19e-20   NR XP_031558145.1 6105 g23269 i0 80 8.83928571428571 55 11 98.2 0 167 3 13 67 XP_031558145.1 ADP,ATP carrier protein-like [Actinia tenebrosa] diamond 1485 92.4 0.995670995670996 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
30297518 30297518 PRJNA436017_P_NODE_13152_length_231_cov_3.206186_g12854_i0 PRJNA436017 13152 231 3.206186 7.40628966 Nematostella vectensis 45351 Cnidaria other_Eukaryota 57.4 1.42e-7   NR XP_001633436.1 45351 g12854 i0 84.8 0.428571428571429 33 5 42.9 0 99 1 90 122 XP_001633436.1 60S ribosomal protein L6 [Nematostella vectensis] diamond 99 57.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis

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