RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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

  • PRJNA1063685 · 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
6115366 6115366 PRJNA1063685_S_NODE_79985_length_208_cov_5.377778_g79442_i0 PRJNA1063685 79985 208 5.377778 11.18577824 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 159 1.04e-34   NTclustered gi|2919530995|ref|XM_071655174.1| 105358 g79442 i0 84.242 99.9038461538462 165 24 79 2 42 205 17 180 PREDICTED: Diadema antillarum ubiquitin-ribosomal protein eL40 fusion protein (LOC139744751), mRNA blastn 20780 159 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
6557543 6557543 PRJNA1063685_S_NODE_38006_length_379_cov_2.715686_g37463_i0 PRJNA1063685 38006 379 2.715686 10.29244994 Lytechinus pictus 7653 Echinodermata other_Eukaryota 52.8 0.036   NTclustered gi|2707349217|ref|XM_064114909.1| 7653 g37463 i0 100 0.147757255936675 28 0 7 0 200 227 1463 1436 PREDICTED: Lytechinus pictus netrin receptor UNC5C-like (LOC129282865), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
12933546 12933546 PRJNA1063685_S_NODE_66471_length_260_cov_1.235294_g65928_i0 PRJNA1063685 66471 260 1.235294 3.2117644 Ophiura sarsii 861515 Echinodermata other_Eukaryota 444 3.35e-120   NTclustered gi|2075388299|gb|MW430004.1| 861515 g65928 i0 98.039 43.0576923076923 255 5 98 0 6 260 11653 11399 Ophiura sarsii mitochondrion, complete genome blastn 11195 444 1 Eukaryota Opisthokonta Metazoa Echinodermata Ophiuroidea Amphilepidida Ophiuridae Ophiura Ophiura sarsii
21856606 21856606 PRJNA1063685_S_NODE_61238_length_276_cov_0.827586_g60695_i0 PRJNA1063685 61238 276 0.827586 2.28413736 Patiria miniata 46514 Echinodermata other_Eukaryota 58.4 5.45e-4   NTclustered gi|1944864162|ref|XR_005270744.1| 46514 g60695 i0 94.595 0.134057971014493 37 2 13 0 93 129 37 1 PREDICTED: Patiria miniata uncharacterized LOC119725865 (LOC119725865), ncRNA blastn 37 58.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
23131636 23131636 PRJNA1063685_S_NODE_1279_length_1033_cov_16.562500_g1017_i0 PRJNA1063685 1279 1033 16.5625 171.090625 Anneissia japonica 1529436 Echinodermata other_Eukaryota 100 3.69e-16   NTclustered gi|1826653364|ref|XM_033258718.1| 1529436 g1017 i0 77.114 0.245885769603098 201 28 18 6 275 457 546 346 PREDICTED: Anneissia japonica protein SSUH2 homolog (LOC117115064), mRNA blastn 254 100 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica

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