RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA864829 · 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
847267 847267 PRJNA864829_S_NODE_241_length_840_cov_4.156764_g191_i0 PRJNA864829 241 840 4.156764 34.9168176 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 1456 0   NTclustered gi|1124902734|gb|AY812498.2| 6182 g191 i0 98.095 104.442857142857 840 8 100 3 1 840 1380 549 Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds blastn 87732 1461 0.996577686516085 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
7614906 7614906 PRJNA864829_S_NODE_4026_length_285_cov_6.991525_g3940_i0 PRJNA864829 4026 285 6.991525 19.92584625 Metazoa 33208 Platyhelminthes Platyhelminthes 78.7 4.34e-10   NTclustered gi|14280070|gb|AF342800.1| 46768 g3940 i0 79.167 1.67017543859649 120 20 41 5 58 174 3982 4099 Stylochus zebra internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 476 78.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Polycladida Stylochidae Stylochus Stylochus zebra
9775329 9775329 PRJNA864829_S_NODE_8368_length_215_cov_1.530120_g8282_i0 PRJNA864829 8368 215 1.53012 3.289758 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 392 9.83e-105   NTclustered gi|60698688|gb|AY915747.1| 6182 g8282 i0 99.535 2.38604651162791 215 1 100 0 1 215 310 96 Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds blastn 513 392 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
18698596 18698596 PRJNA864829_S_NODE_1235_length_442_cov_2.106870_g1149_i0 PRJNA864829 1235 442 2.10687 9.3123654 Diplorchis hangzhouensis 1131906 Platyhelminthes Platyhelminthes 54.7 0.012   NTclustered gi|379771686|gb|JQ038227.1| 1131906 g1149 i0 100 0.0656108597285068 29 0 7 0 125 153 5361 5389 Diplorchis hangzhouensis mitochondrion sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Polystomatidea Polystomatidae Diplorchis Diplorchis hangzhouensis
25073403 25073403 PRJNA864829_S_NODE_960_length_489_cov_3.988636_g874_i0 PRJNA864829 960 489 3.988636 19.50443004 Gyratrix hermaphroditus 84080 Platyhelminthes Platyhelminthes 121 1.29e-22   NTclustered gi|588313922|gb|KC869880.1| 84080 g874 i0 83.582 17.3660531697342 134 17 27 5 220 351 1954 1824 Gyratrix hermaphroditus 28S ribosomal RNA gene, partial sequence blastn 8492 121 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Rhabdocoela Polycystididae Gyratrix Gyratrix hermaphroditus

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