RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA789095 · 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
3322233 3322233 PRJNA789095_P_NODE_53343_length_278_cov_1.502439_g52009_i0 PRJNA789095 53343 278 1.502439 4.17678042 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 254 6.54e-63   NTclustered gi|1791034299|ref|NM_001123508.2| 7668 g52009 i0 84.646 26.0611510791367 254 39 91 0 1 254 336 83 Strongylocentrotus purpuratus histone H2 A.F/Z (H2A.F/Z), mRNA blastn 7245 254 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
7149964 7149964 PRJNA789095_P_NODE_68886_length_248_cov_0.880000_g67552_i0 PRJNA789095 68886 248 0.88 2.1824 Lytechinus pictus 7653 Echinodermata other_Eukaryota 63.9 1.04e-5   NTclustered gi|2707409147|ref|XM_064113984.1| 7653 g67552 i0 93.182 1.54435483870968 44 2 17 1 141 183 905 862 PREDICTED: Lytechinus pictus zinc finger protein 236-like (LOC135157633), mRNA blastn 383 63.9 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
14799840 14799840 PRJNA789095_P_NODE_61392_length_260_cov_2.385027_g60058_i0 PRJNA789095 61392 260 2.385027 6.2010702 Acanthaster planci 133434 Echinodermata other_Eukaryota 217 7.94e-52   NTclustered gi|1229129172|ref|XM_022234113.1| 133434 g60058 i0 83.122 14.0538461538462 237 40 91 0 18 254 76 312 PREDICTED: Acanthaster planci ras-related protein Rab-10-like (LOC110978808), transcript variant X4, mRNA blastn 3654 217 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
19896855 19896855 PRJNA789095_P_NODE_19996_length_544_cov_3.284501_g18671_i0 PRJNA789095 19996 544 3.284501 17.86768544 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 425 2.74e-114   NTclustered gi|2037989818|ref|XM_041607740.1| 7654 g18671 i0 86.877 72.1268382352941 381 48 70 2 22 401 1065 1444 PREDICTED: Lytechinus variegatus tubulin alpha-2/alpha-4 chain-like (LOC121414530), mRNA blastn 39237 425 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
22447539 22447539 PRJNA789095_P_NODE_28478_length_405_cov_0.927711_g27146_i0 PRJNA789095 28478 405 0.927711 3.75722955 Lytechinus pictus 7653 Echinodermata other_Eukaryota 292 2.1e-74   NTclustered gi|2707420633|ref|XM_054902824.2| 7653 g27146 i0 79.8 125.906172839506 401 81 99 0 4 404 81 481 PREDICTED: Lytechinus pictus ubiquitin-ribosomal protein eS31 fusion protein (LOC129264867), mRNA blastn 50992 292 1 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);;