RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA980839" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA980839 · 9 ✖

analysis 1

  • diamond · 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
26646166 26646166 PRJNA980839_P_NODE_93461_length_378_cov_3.059016_g89677_i0 PRJNA980839 93461 378 3.059016 11.56308048 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 58.5 1.55e-8   NR AAX31080.1 6182 g89677 i0 81.1 0.293650793650794 37 7 29.4 0 130 20 1 37 AAX31080.1 SJCHGC09793 protein [Schistosoma japonicum] diamond 111 58.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
27342590 27342590 PRJNA980839_P_NODE_71223_length_459_cov_1.774611_g67440_i0 PRJNA980839 71223 459 1.774611 8.14546449 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 50.8 2.14e-5   NR ABA40899.1 6182 g67440 i0 61.5 0.254901960784314 39 13 24.2 1 222 112 4 42 ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] diamond 117 50.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
27753030 27753030 PRJNA980839_P_NODE_193084_length_253_cov_2.566667_g189300_i0 PRJNA980839 193084 253 2.566667 6.49366751 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 72.4 1.82e-13   NR AAX25032.2 6182 g189300 i0 53.6 0.99604743083004 84 30 99.6 2 253 2 41 115 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 252 72.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28321122 28321122 PRJNA980839_P_NODE_222746_length_245_cov_0.895349_g218962_i0 PRJNA980839 222746 245 0.895349 2.19360505 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 44.3 0.0015   NR AAM80477.1 6182 g218962 i0 64.1 0.477551020408163 39 7 39.2 1 110 15 41 79 AAM80477.1 Hm1 protein [Schistosoma japonicum] diamond 117 44.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29994834 29994834 PRJNA980839_P_NODE_204471_length_249_cov_1.551136_g200687_i0 PRJNA980839 204471 249 1.551136 3.86232864 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 91.7 7.67e-22   NR AAX24941.2 6182 g200687 i0 87.8 0.590361445783133 49 6 59 0 148 2 46 94 AAX24941.2 SJCHGC03936 protein, partial [Schistosoma japonicum] diamond 147 91.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31290062 31290062 PRJNA980839_P_NODE_184955_length_259_cov_1.655914_g181171_i0 PRJNA980839 184955 259 1.655914 4.28881726 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 88.6 1.2e-20   NR AAW25230.1 6182 g181171 i0 69 0.822393822393822 71 17 78.8 3 206 3 16 84 AAW25230.1 SJCHGC04882 protein [Schistosoma japonicum] diamond 213 88.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31827708 31827708 PRJNA980839_P_NODE_219697_length_245_cov_2.145349_g215913_i0 PRJNA980839 219697 245 2.145349 5.25610505 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 83.2 3.36e-18   NR AAX28478.2 6182 g215913 i0 67.2 0.710204081632653 58 19 71 0 1 174 57 114 AAX28478.2 SJCHGC03032 protein, partial [Schistosoma japonicum] diamond 174 83.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32460822 32460822 PRJNA980839_P_NODE_33839_length_848_cov_2.650323_g30424_i0 PRJNA980839 33839 848 2.650323 22.47473904 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 121 7.46e-30   NR AAX25032.2 6182 g30424 i0 45.7 0.580188679245283 164 79 58 2 492 1 2 155 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 492 121 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32524287 32524287 PRJNA980839_P_NODE_231419_length_243_cov_0.888235_g227635_i0 PRJNA980839 231419 243 0.888235 2.15841105 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 102 2.28e-25   NR AAX25032.2 6182 g227635 i0 67.6 0.91358024691358 74 24 91.4 0 6 227 58 131 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 222 102 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);;