RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA1004255" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1004255 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
26907887 26907887 PRJNA1004255_S_NODE_7602_length_225_cov_3.906593_g7394_i0 PRJNA1004255 7602 225 3.906593 8.78983425 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 102 3.07e-23   NR AAX28387.3 6182 g7394 i0 81 10.88 63 12 84 0 35 223 412 474 AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] diamond 2448 103 0.990291262135922 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
27571586 27571586 PRJNA1004255_S_NODE_12324_length_183_cov_5.228571_g12116_i0 PRJNA1004255 12324 183 5.228571 9.56828493 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 73.9 1.79e-14   NR AAX25032.2 6182 g12116 i0 75 0.852459016393443 52 13 85.2 0 157 2 134 185 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 156 73.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28455828 28455828 PRJNA1004255_S_NODE_1166_length_428_cov_3.371429_g958_i0 PRJNA1004255 1166 428 3.371429 14.42971612 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 65.9 4.06e-10   NR AAX25032.2 6182 g958 i0 66 0.329439252336449 47 16 32.9 0 290 150 141 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 141 65.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29939867 29939867 PRJNA1004255_S_NODE_8351_length_217_cov_1.620690_g8143_i0 PRJNA1004255 8351 217 1.62069 3.5168973 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 68.6 3.49e-12   NR AAX25032.2 6182 g8143 i0 69.4 0.67741935483871 49 15 67.7 0 59 205 127 175 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 147 68.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30508418 30508418 PRJNA1004255_S_NODE_16033_length_162_cov_4.344538_g15825_i0 PRJNA1004255 16033 162 4.344538 7.03815156 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 42 0.0181   NR AAX25032.2 6182 g15825 i0 71 0.574074074074074 31 9 57.4 0 29 121 154 184 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 93 42 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31108564 31108564 PRJNA1004255_S_NODE_4875_length_265_cov_7.819820_g4667_i0 PRJNA1004255 4875 265 7.81982 20.722523 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 49.7 1.02e-5   NR ABA40899.1 6182 g4667 i0 59 0.441509433962264 39 14 41.9 1 44 154 4 42 ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] diamond 117 49.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31329961 31329961 PRJNA1004255_S_NODE_17176_length_157_cov_2.473684_g16968_i0 PRJNA1004255 17176 157 2.473684 3.88368388 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 52.4 8.1e-7   NR AAX24812.2 6182 g16968 i0 60 0.764331210191083 40 16 76.4 0 122 3 6 45 AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] diamond 120 52.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32595427 32595427 PRJNA1004255_S_NODE_3200_length_306_cov_1.893536_g2992_i0 PRJNA1004255 3200 306 1.893536 5.79422016 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 45.8 0.00387   NR AAX25032.2 6182 g2992 i0 76.7 0.588235294117647 30 7 29.4 0 4 93 151 180 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 180 45.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum

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