RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA699078" and tax_phylum = "Hemichordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Hemichordata · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA699078 · 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
10886456 10886456 PRJNA699078_S_NODE_52289_length_236_cov_1.882353_g51340_i0 PRJNA699078 52289 236 1.882353 4.44235308 Ptychodera flava 63121 Hemichordata other_Eukaryota 52.8 0.021   NTclustered gi|2875732179|ref|XM_070696868.1| 63121 g51340 i0 100 0.593220338983051 28 0 12 0 80 107 5202 5229 PREDICTED: Ptychodera flava NFX1-type zinc finger-containing protein 1-like (LOC139130985), transcript variant X5, mRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
18534087 18534087 PRJNA699078_S_NODE_43415_length_261_cov_17.764151_g42466_i0 PRJNA699078 43415 261 17.764151 46.36443411 Ptychodera flava 63121 Hemichordata other_Eukaryota 91.6 5.04e-14   NTclustered gi|2875692900|ref|XM_070679714.1| 63121 g42466 i0 86.585 2.98467432950192 82 11 31 0 180 261 1515 1434 PREDICTED: Ptychodera flava tubulin alpha-1A chain-like (LOC139116962), mRNA blastn 779 91.6 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
23635744 23635744 PRJNA699078_S_NODE_80759_length_187_cov_1.130435_g79810_i0 PRJNA699078 80759 187 1.130435 2.11391345 Saccoglossus kowalevskii 10224 Hemichordata other_Eukaryota 73.1 1.23e-8   NTclustered gi|585666790|ref|XM_006817118.1| 10224 g79810 i0 86.567 0.358288770053476 67 7 35 2 20 85 7474 7539 PREDICTED: Saccoglossus kowalevskii dynein heavy chain 10, axonemal-like (LOC100374422), mRNA blastn 67 73.1 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii

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