RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax_phylum = "Hemichordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Hemichordata · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA379145 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
5504379 5504379 PRJNA379145_P_NODE_31005_length_402_cov_3.647696_g28878_i0 PRJNA379145 31005 402 3.647696 14.66373792 Ptychodera flava 63121 Hemichordata other_Eukaryota 171 1.0199999999999998e-37   NTclustered gi|2875653540|ref|XM_070711777.1| 63121 g28878 i0 88.571 32.9452736318408 140 16 35 0 1 140 2088 2227 PREDICTED: Ptychodera flava tubulin alpha-1A chain-like (LOC139141995), mRNA blastn 13244 171 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
6778636 6778636 PRJNA379145_P_NODE_4086_length_1455_cov_12.215190_g3571_i0 PRJNA379145 4086 1455 12.21519 177.7310145 Saccoglossus kowalevskii 10224 Hemichordata other_Eukaryota 56.5 0.012   NTclustered gi|269785160|ref|NM_001168064.1| 10224 g3571 i0 100 0.0206185567010309 30 0 2 0 1421 1450 1284 1313 Saccoglossus kowalevskii FGF13-like protein (LOC100313599), mRNA blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
16978239 16978239 PRJNA379145_P_NODE_40534_length_298_cov_4.260377_g38383_i0 PRJNA379145 40534 298 4.260377 12.69592346 Ptychodera flava 63121 Hemichordata other_Eukaryota 189 2.02e-43   NTclustered gi|2875653540|ref|XM_070711777.1| 63121 g38383 i0 90.278 43.1275167785235 144 14 48 0 1 144 2088 2231 PREDICTED: Ptychodera flava tubulin alpha-1A chain-like (LOC139141995), mRNA blastn 12852 189 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
23353180 23353180 PRJNA379145_P_NODE_71459_length_156_cov_1.504065_g69304_i0 PRJNA379145 71459 156 1.504065 2.3463414 Ptychodera flava 63121 Hemichordata other_Eukaryota 132 1.6e-26   NTclustered gi|2875698141|ref|XM_070682228.1| 63121 g69304 i0 82.993 25.5897435897436 147 23 94 2 11 156 1116 971 PREDICTED: Ptychodera flava succinate--CoA ligase [ADP-forming] subunit beta, mitochondrial-like (LOC139118776), mRNA blastn 3992 132 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava

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