RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA971676" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA971676 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
9873038 9873038 PRJNA971676_P_NODE_9508_length_291_cov_1.880734_g9419_i0 PRJNA971676 9508 291 1.880734 5.47293594 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 165 1.33e-47   NR PIK54960.1 307972 g9419 i0 79.6 1.91752577319588 93 19 95.9 0 280 2 150 242 PIK54960.1 putative isocitrate dehydrogenase [Apostichopus japonicus] diamond 558 165 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus
17522912 17522912 PRJNA971676_P_NODE_9634_length_290_cov_1.064516_g9545_i0 PRJNA971676 9634 290 1.064516 3.0870964 Acanthaster planci 133434 Echinodermata other_Eukaryota 112 1.51e-29   NR XP_022101624.1 133434 g9545 i0 62.5 1.6448275862069 80 30 82.8 0 288 49 35 114 XP_022101624.1 thioredoxin-like [Acanthaster planci] diamond 477 112 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
26874336 26874336 PRJNA971676_P_NODE_11461_length_272_cov_2.849246_g11372_i0 PRJNA971676 11461 272 2.849246 7.74994912 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 188 1.68e-56   NR NP_001032234.2 7668 g11372 i0 98.9 750.386029411765 90 1 99.3 0 2 271 9 98 NP_001032234.2 actin, cytoskeletal 1B [Strongylocentrotus purpuratus] diamond 204105 188 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
31074968 31074968 PRJNA971676_P_NODE_5575_length_355_cov_1.638298_g5486_i0 PRJNA971676 5575 355 1.638298 5.8159579 Metazoa 33208 Echinodermata other_Eukaryota 138 7.19e-38   NR XP_041462087.1 7654 g5486 i0 65.7 11.0535211267606 108 34 91.3 1 326 3 1 105 XP_041462087.1 40S ribosomal protein S3a-like [Lytechinus variegatus] diamond 3924 139 0.992805755395683 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
32530202 32530202 PRJNA971676_P_NODE_14599_length_251_cov_0.865169_g14510_i0 PRJNA971676 14599 251 0.865169 2.17157419 Echinoidea 7625 Echinodermata other_Eukaryota 48.1 5.39e-4   NR XP_063959636.1 7653 g14510 i0 47.3 1.97211155378486 55 23 65.7 2 1 165 601 649 XP_063959636.1 uncharacterized protein LOC129267226 isoform X2 [Lytechinus pictus] diamond 495 48.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
32807245 32807245 PRJNA971676_P_NODE_7500_length_320_cov_1.246964_g7411_i0 PRJNA971676 7500 320 1.246964 3.9902848 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 60.1 7.38e-8   NR XP_041485513.1 7654 g7411 i0 44.4 5.175 72 21 63.8 3 58 261 3 59 XP_041485513.1 E3 ubiquitin/ISG15 ligase TRIM25-like [Lytechinus variegatus] diamond 1656 60.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus

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