RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA692200 · 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
16482094 16482094 PRJNA692200_S_NODE_20653_length_165_cov_1.750000_g20596_i0 PRJNA692200 20653 165 1.75 2.8875 Montipora foliosa 591990 Cnidaria other_Eukaryota 92.8 5.15e-22   NR XP_068705947.1 591990 g20596 i0 81.3 16.6727272727273 48 9 87.3 0 158 15 131 178 XP_068705947.1 large ribosomal subunit protein uL30-like [Montipora foliosa] diamond 2751 92.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora foliosa
27504891 27504891 PRJNA692200_S_NODE_21403_length_163_cov_2.254386_g21346_i0 PRJNA692200 21403 163 2.254386 3.67464918 Metazoa 33208 Cnidaria other_Eukaryota 87.8 9.03e-20   NR XP_028404257.1 151771 g21346 i0 70.4 4.96932515337423 54 16 99.4 0 162 1 32 85 XP_028404257.1 40S ribosomal protein S8-like [Dendronephthya gigantea] diamond 810 88.2 0.99546485260771 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
30315567 30315567 PRJNA692200_S_NODE_21212_length_164_cov_0.895652_g21155_i0 PRJNA692200 21212 164 0.895652 1.46886928 Metazoa 33208 Cnidaria other_Eukaryota 42.7 0.0127   NR XP_068750036.1 246305 g21155 i0 39.2 2.79878048780488 51 30 93.3 1 158 6 243 292 XP_068750036.1 nucleoside hydrolase-like [Montipora capricornis] diamond 459 43.1 0.990719257540603 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
32390537 32390537 PRJNA692200_S_NODE_10079_length_223_cov_1.172414_g10022_i0 PRJNA692200 10079 223 1.172414 2.61448322 Porites lobata 104759 Cnidaria other_Eukaryota 66.2 1.39e-10   NR CAH3146431.1 104759 g10022 i0 57.7 1.38565022421525 52 19 70 1 158 3 284 332 CAH3146431.1 unnamed protein product [Porites lobata] diamond 309 66.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites lobata

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