RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA484127 · 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
10025568 10025568 PRJNA484127_P_NODE_12908_length_347_cov_1.540146_g12759_i0 PRJNA484127 12908 347 1.540146 5.34430662 Echinodermata 7586 Echinodermata other_Eukaryota 158 1.57e-46   NR XP_071509954.1 105358 g12759 i0 64.7 4.0028818443804 116 40 99.4 1 2 346 2 117 XP_071509954.1 large ribosomal subunit protein uL6-like [Diadema antillarum] diamond 1389 159 0.993710691823899 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
11300512 11300512 PRJNA484127_P_NODE_19269_length_299_cov_1.570796_g19120_i0 PRJNA484127 19269 299 1.570796 4.69668004 Acanthaster planci 133434 Echinodermata other_Eukaryota 144 3.39e-41   NR XP_022100359.1 133434 g19120 i0 63.3 5.89966555183946 98 36 98.3 0 294 1 1 98 XP_022100359.1 60S ribosomal protein L9-like [Acanthaster planci] diamond 1764 144 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
27377145 27377145 PRJNA484127_P_NODE_15383_length_325_cov_1.960317_g15234_i0 PRJNA484127 15383 325 1.960317 6.37103025 Metazoa 33208 Echinodermata other_Eukaryota 73.9 9.95e-13   NR XP_033638687.1 7604 g15234 i0 57.1 4.08923076923077 63 27 58.2 0 281 93 17 79 XP_033638687.1 microfibrillar-associated protein 1-like [Asterias rubens] diamond 1329 74.3 0.994616419919246 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
29003087 29003087 PRJNA484127_P_NODE_27288_length_261_cov_1.792553_g27139_i0 PRJNA484127 27288 261 1.792553 4.67856333 Diadema antillarum 105358 Echinodermata other_Eukaryota 82.4 4.81e-16   NR XP_071490913.1 105358 g27139 i0 48.1 3.91954022988506 81 42 93.1 0 1 243 304 384 XP_071490913.1 cytochrome P450 1A1-like [Diadema antillarum] diamond 1023 82.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
30771572 30771572 PRJNA484127_P_NODE_5274_length_497_cov_1.742925_g5126_i0 PRJNA484127 5274 497 1.742925 8.66233725 Asterias rubens 7604 Echinodermata other_Eukaryota 58.9 1.1e-6   NR XP_033647670.1 7604 g5126 i0 30.6 1.34607645875252 124 70 68.8 5 152 493 377 494 XP_033647670.1 F-box only protein 7-like [Asterias rubens] diamond 669 58.9 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
31798989 31798989 PRJNA484127_P_NODE_35757_length_245_cov_2.947674_g35608_i0 PRJNA484127 35757 245 2.947674 7.2218013 Metazoa 33208 Echinodermata other_Eukaryota 59.3 5.47e-8   NR XP_071490114.1 105358 g35608 i0 44.9 3.77142857142857 78 38 89.4 3 221 3 265 342 XP_071490114.1 zinc finger protein 711-like [Diadema antillarum] diamond 924 59.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum

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