RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJDB14274" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB14274 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
7660872 7660872 PRJDB14274_S_NODE_7507_length_231_cov_1.517647_g7429_i0 PRJDB14274 7507 231 1.517647 3.50576457 Metazoa 33208 Echinodermata other_Eukaryota 116 3.9199999999999995e-30   NR XP_041475269.1 7654 g7429 i0 72 1.94805194805195 75 21 97.4 0 4 228 148 222 XP_041475269.1 ATP-dependent Clp protease proteolytic subunit, mitochondrial-like [Lytechinus variegatus] diamond 450 117 0.991452991452991 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
27406023 27406023 PRJDB14274_S_NODE_963_length_613_cov_2.143116_g888_i0 PRJDB14274 963 613 2.143116 13.13730108 Metazoa 33208 Echinodermata other_Eukaryota 114 4.15e-26   NR AAL05452.1 7594 g888 i0 41.5 15.8319738988581 183 90 83.2 5 511 2 55 233 AAL05452.1 cyclin B [Patiria pectinifera] diamond 9705 114 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria pectinifera
28138110 28138110 PRJDB14274_S_NODE_6225_length_252_cov_1.162304_g6147_i0 PRJDB14274 6225 252 1.162304 2.92900608 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 91.7 2.38e-19   NR PIK37567.1 307972 g6147 i0 48.2 3.91666666666667 83 43 98.8 0 2 250 263 345 PIK37567.1 hypothetical protein BSL78_25594 [Apostichopus japonicus] diamond 987 91.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus
28289703 28289703 PRJDB14274_S_NODE_5226_length_273_cov_1.613208_g5148_i0 PRJDB14274 5226 273 1.613208 4.40405784 Opisthokonta 33154 Echinodermata other_Eukaryota 59.7 5.89e-8   NR XP_030854918.1 7668 g5148 i0 47.5 4.43956043956044 80 35 80.2 2 273 55 323 402 XP_030854918.1 E3 ubiquitin-protein ligase synoviolin A [Strongylocentrotus purpuratus] diamond 1212 60.1 0.993344425956739 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
29047762 29047762 PRJDB14274_S_NODE_3348_length_335_cov_1.423358_g3270_i0 PRJDB14274 3348 335 1.423358 4.7682493 Metazoa 33208 Echinodermata other_Eukaryota 70.5 1.87e-11   NR XP_071499753.1 105358 g3270 i0 37.1 1.8089552238806 116 63 94.9 3 334 17 113 228 XP_071499753.1 tumor susceptibility gene 101 protein-like [Diadema antillarum] diamond 606 70.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
30853872 30853872 PRJDB14274_S_NODE_5934_length_258_cov_0.949239_g5856_i0 PRJDB14274 5934 258 0.949239 2.44903662 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 68.2 4.66e-11   NR KAJ8031873.1 206669 g5856 i0 58.9 1.25581395348837 56 23 65.1 0 254 87 176 231 KAJ8031873.1 Gastric triacylglycerol lipase [Holothuria leucospilota] diamond 324 68.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
32150510 32150510 PRJDB14274_S_NODE_8938_length_212_cov_1.291391_g8860_i0 PRJDB14274 8938 212 1.291391 2.73774892 Anneissia japonica 1529436 Echinodermata other_Eukaryota 74.7 1.33e-14   NR XP_033103497.1 1529436 g8860 i0 49.3 10.5990566037736 69 35 97.6 0 1 207 80 148 XP_033103497.1 dual specificity protein phosphatase 1B-like isoform X2 [Anneissia japonica] diamond 2247 74.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
32340497 32340497 PRJDB14274_S_NODE_4659_length_287_cov_2.146018_g4581_i0 PRJDB14274 4659 287 2.146018 6.15907166 Lytechinus pictus 7653 Echinodermata other_Eukaryota 49.3 7.05e-5   NR XP_054769073.1 7653 g4581 i0 46.2 1.63066202090592 52 28 54.4 0 284 129 76 127 XP_054769073.1 EF-hand domain-containing protein D2 homolog [Lytechinus pictus] diamond 468 49.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
32397837 32397837 PRJDB14274_S_NODE_9659_length_206_cov_1.586207_g9581_i0 PRJDB14274 9659 206 1.586207 3.26758642 Metazoa 33208 Echinodermata other_Eukaryota 73.6 3.19e-13   NR XP_063960127.1 7653 g9581 i0 55.2 2.63592233009709 67 30 97.6 0 204 4 2610 2676 XP_063960127.1 E3 ubiquitin-protein ligase UBR5-like [Lytechinus pictus] diamond 543 74.3 0.990578734858681 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus

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