RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1151638" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1151638 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
30008895 30008895 PRJNA1151638_P_NODE_3951_length_269_cov_1.091837_g3884_i0 PRJNA1151638 3951 269 1.091837 2.93704153 Ranitomeya imitator 111125 Chordata Chordata 43.9 0.0181   NR CAJ0956274.1 111125 g3884 i0 55.9 0.769516728624535 34 15 37.9 0 161 262 1 34 CAJ0956274.1 unnamed protein product [Ranitomeya imitator] diamond 207 43.9 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Dendrobatidae Ranitomeya Ranitomeya imitator
31873510 31873510 PRJNA1151638_P_NODE_5037_length_251_cov_1.426966_g4970_i0 PRJNA1151638 5037 251 1.426966 3.58168466 Bufotes viridis 30338 Chordata Chordata 42.7 0.0393   NR CAK8629749.1 30338 g4970 i0 69 0.346613545816733 29 9 34.7 0 91 5 335 363 CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] diamond 87 42.7 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Bufonidae Bufotes Bufotes viridis
32884376 32884376 PRJNA1151638_P_NODE_2820_length_300_cov_1.621145_g2753_i0 PRJNA1151638 2820 300 1.621145 4.863435 Erpetoichthys calabaricus 27687 Chordata Chordata 70.5 9.17e-12   NR XP_051791274.1 27687 g2753 i0 73.5 3 49 12 48 1 26 169 156 204 XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] diamond 900 70.5 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Erpetoichthys Erpetoichthys calabaricus

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