RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJDB3785" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB3785 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
8935884 8935884 PRJDB3785_S_NODE_4768_length_347_cov_3.852349_g4615_i0 PRJDB3785 4768 347 3.852349 13.36765103 Acanthaster planci 133434 Echinodermata other_Eukaryota 82.4 4.19e-11   NTclustered gi|1229160970|ref|XM_022237704.1| 133434 g4615 i0 88.235 0.829971181556196 68 8 20 0 48 115 770 837 PREDICTED: Acanthaster planci 60S ribosomal protein L8 (LOC110980756), mRNA blastn 288 82.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
11486872 11486872 PRJDB3785_S_NODE_5910_length_310_cov_2.333333_g5757_i0 PRJDB3785 5910 310 2.333333 7.2333323 Paracentrotus lividus 7656 Echinodermata other_Eukaryota 52.8 0.029   NTclustered gi|1166456|emb|X95268.1| 7656 g5757 i0 85.185 0.174193548387097 54 4 17 2 1 52 365 416 P.lividus mRNA for ribosomal protein S24 blastn 54 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Echinidae Paracentrotus Paracentrotus lividus
14036913 14036913 PRJDB3785_S_NODE_26352_length_162_cov_1.194690_g26199_i0 PRJDB3785 26352 162 1.19469 1.9353978 Patiria miniata 46514 Echinodermata other_Eukaryota 137 3.6199999999999997e-28   NTclustered gi|1944835412|ref|XM_038191074.1| 46514 g26199 i0 91.919 19.0740740740741 99 6 60 2 59 156 1537 1440 PREDICTED: Patiria miniata delta(14)-sterol reductase TM7SF2-like (LOC119721175), mRNA blastn 3090 137 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
17860544 17860544 PRJDB3785_S_NODE_12715_length_215_cov_1.493976_g12562_i0 PRJDB3785 12715 215 1.493976 3.2120484 Lytechinus pictus 7653 Echinodermata other_Eukaryota 60.2 1.13e-4   NTclustered gi|2707348294|ref|XM_064114516.1| 7653 g12562 i0 100 10.6790697674419 32 0 15 0 78 109 966 997 PREDICTED: Lytechinus pictus zinc finger protein 330 homolog (LOC129261045), transcript variant X3, mRNA blastn 2296 60.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
24234615 24234615 PRJDB3785_S_NODE_1620_length_628_cov_4.376511_g1488_i0 PRJDB3785 1620 628 4.376511 27.48448908 Diadema antillarum 105358 Echinodermata other_Eukaryota 276 3.3999999999999996e-69   NTclustered gi|2919435354|ref|XM_071637819.1| 105358 g1488 i0 79.389 35.6369426751592 393 79 62 2 235 626 486 95 PREDICTED: Diadema antillarum ubiquitin-ribosomal protein eS31 fusion protein (LOC139726824), mRNA blastn 22380 276 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);;