RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1123436", tax_clade = "Opisthokonta" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 3 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 3 ✖

bioproject 1

  • PRJNA1123436 · 3 ✖

analysis 1

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
11757765 11757765 PRJNA1123436_P_NODE_129130_length_196_cov_33.731707_g127916_i0 PRJNA1123436 129130 196 33.731707 66.11414572 Ophiura kinbergi 3253740 Echinodermata other_Eukaryota 119 1.65e-22   NTclustered gi|2549241453|dbj|LC749659.1| 1815251 g127916 i0 79.679 18.8877551020408 187 20 93 13 3 184 226 399 Ophiura kinbergi NSMT:E13942 mitochondrial gene for 16S rRNA, partial sequence blastn 3702 119 1 Eukaryota Opisthokonta Metazoa Echinodermata Ophiuroidea Amphilepidida Ophiuridae Ophiura Ophiura kinbergi
19405144 19405144 PRJNA1123436_P_NODE_128996_length_211_cov_106.275362_g127782_i0 PRJNA1123436 128996 211 106.275362 224.24101382 Holothuria paraprinceps 3027004 Echinodermata other_Eukaryota 145 2.97e-30   NTclustered gi|2442313045|gb|OQ418150.1| 3027004 g127782 i0 80.296 75.5118483412322 203 30 95 9 1 200 196 391 Holothuria paraprinceps voucher Holothuria.paraprinceps21008932 large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 15933 145 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria paraprinceps
23232697 23232697 PRJNA1123436_P_NODE_77259_length_283_cov_1.319048_g76045_i0 PRJNA1123436 77259 283 1.319048 3.73290584 Luidia quinaria 60585 Echinodermata other_Eukaryota 401 2.2499999999999992e-107   NTclustered gi|2756305430|dbj|LC773532.1| 60585 g76045 i0 93.68 61.1625441696113 269 16 95 1 13 281 495 228 Luidia quinaria NSMT:E-14360 mitochondrial gene for 16S rRNA, partial sequence blastn 17309 401 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Paxillosida Luidiidae Luidia Luidia quinaria

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