RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA971593" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA971593 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
4772603 4772603 PRJNA971593_P_NODE_23644_length_249_cov_0.875000_g23495_i0 PRJNA971593 23644 249 0.875 2.17875 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 75 4.81e-9   NTclustered gi|1752388613|ref|XM_030997039.1| 7668 g23495 i0 79.464 0.979919678714859 112 18 43 4 85 192 3772 3882 PREDICTED: Strongylocentrotus purpuratus ATP-citrate synthase (LOC594785), mRNA blastn 244 75 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
7322152 7322152 PRJNA971593_P_NODE_10126_length_381_cov_1.155844_g9977_i0 PRJNA971593 10126 381 1.155844 4.40376564 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 313 1.51e-80   NTclustered gi|1752354307|ref|XM_030982482.1| 7668 g9977 i0 91.593 60.1259842519685 226 19 59 0 11 236 6629 6404 PREDICTED: Strongylocentrotus purpuratus serine/threonine-protein kinase 25 (LOC591674), transcript variant X1, mRNA blastn 22908 313 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
8597297 8597297 PRJNA971593_P_NODE_27727_length_243_cov_0.905882_g27578_i0 PRJNA971593 27727 243 0.905882 2.20129326 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 250 7.2399999999999995e-62   NTclustered gi|1752373985|ref|XM_030990816.1| 7668 g27578 i0 89.5 79.5061728395062 200 17 81 4 41 238 1812 2009 PREDICTED: Strongylocentrotus purpuratus lanC-like protein 2 (LOC593095), transcript variant X1, mRNA blastn 19320 250 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
9872505 9872505 PRJNA971593_P_NODE_25868_length_246_cov_0.890173_g25719_i0 PRJNA971593 25868 246 0.890173 2.18982558 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 298 2.5799999999999998e-76   NTclustered gi|164457974|gb|AC204779.10| 7668 g25719 i0 88.71 14.3943089430894 248 22 100 5 1 246 94614 94371 Strongylocentrotus purpuratus BAC CS-181662 (L. Courtney Smith, George Washington University) complete sequence blastn 3541 298 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
12423397 12423397 PRJNA971593_P_NODE_18310_length_279_cov_0.975728_g18161_i0 PRJNA971593 18310 279 0.975728 2.72228112 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 320 6.38e-83   NTclustered gi|985701817|gb|KU668453.1| 7668 g18161 i0 96.875 64.4336917562724 192 5 69 1 88 279 97069 97259 Strongylocentrotus purpuratus clone 10K9 sequence, complete sequence blastn 17977 320 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
16247102 16247102 PRJNA971593_P_NODE_22373_length_251_cov_0.865169_g22224_i0 PRJNA971593 22373 251 0.865169 2.17157419 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 348 2.5900000000000005e-91   NTclustered gi|1752357563|ref|XM_030983870.1| 7668 g22224 i0 91.633 11.9362549800797 251 21 100 0 1 251 1784 2034 PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC100890809 (LOC100890809), mRNA blastn 2996 348 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
24217926 24217926 PRJNA971593_P_NODE_27559_length_243_cov_0.905882_g27410_i0 PRJNA971593 27559 243 0.905882 2.20129326 Echinoidea 7625 Echinodermata other_Eukaryota 270 5.5499999999999986e-68   NTclustered gi|2645092062|gb|PP082968.1| 7668 g27410 i0 91.457 28.1604938271605 199 14 81 2 46 243 9833 9637 Strongylocentrotus purpuratus clone BAC10B1_15, complete sequence blastn 6843 270 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
25170262 25170262 PRJNA971593_P_NODE_11740_length_353_cov_0.785714_g11591_i0 PRJNA971593 11740 353 0.785714 2.77357042 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 148 4.14e-31   NTclustered gi|1752398323|ref|XM_787882.5| 7668 g11591 i0 88.095 4.35694050991501 126 13 36 2 121 246 2137 2014 PREDICTED: Strongylocentrotus purpuratus transcription factor CP2 (LOC588186), mRNA blastn 1538 148 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
25170576 25170576 PRJNA971593_P_NODE_7760_length_437_cov_1.013736_g7611_i0 PRJNA971593 7760 437 1.013736 4.43002632 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 383 1.3199999999999995e-101   NTclustered gi|1752378597|ref|XM_030992663.1| 7668 g7611 i0 87.842 34.4050343249428 329 36 75 3 101 426 2596 2923 PREDICTED: Strongylocentrotus purpuratus myb-related transcription factor (LOC592751), mRNA blastn 15035 383 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus

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