RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1214993" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1214993 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
6708070 6708070 PRJNA1214993_P_NODE_13386_length_302_cov_1.139738_g13200_i0 PRJNA1214993 13386 302 1.139738 3.44200876 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 167 9.619999999999998e-37   NTclustered gi|1752368967|ref|XM_030988646.1| 7668 g13200 i0 77.228 63.8576158940397 303 57 98 10 6 302 335 631 PREDICTED: Strongylocentrotus purpuratus 60S ribosomal protein L10a (LOC586056), transcript variant X1, mRNA blastn 19285 167 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
9973491 9973491 PRJNA1214993_P_NODE_11328_length_327_cov_1.511811_g11142_i0 PRJNA1214993 11328 327 1.511811 4.94362197 Lytechinus 7652 Echinodermata other_Eukaryota 141 6.38e-29   NTclustered gi|2707407387|ref|XM_054893500.2| 7653 g11142 i0 88.235 3.52293577981651 119 12 36 2 19 136 581 464 PREDICTED: Lytechinus pictus serine/threonine-protein phosphatase 4 catalytic subunit (LOC129254953), mRNA blastn 1152 141 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
19456409 19456409 PRJNA1214993_P_NODE_24376_length_245_cov_0.895349_g24190_i0 PRJNA1214993 24376 245 0.895349 2.19360505 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 453 5.1900000000000006e-123   NTclustered gi|2656634086|gb|PP178709.1| 307972 g24190 i0 100 60.3102040816327 245 0 100 0 1 245 9600 9356 Apostichopus japonicus isolate FJPT mitochondrion, complete genome blastn 14776 453 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus

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