RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1200128" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1200128 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26977660 26977660 PRJNA1200128_S_NODE_24862_length_190_cov_1.863946_g24753_i0 PRJNA1200128 24862 190 1.863946 3.5414974 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 74.3 7.96e-16   NR AAM80478.1 6182 g24753 i0 72.3 12.4263157894737 47 13 74.2 0 180 40 1 47 AAM80478.1 Hm2 protein [Schistosoma japonicum] diamond 2361 74.7 0.994645247657296 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28114710 28114710 PRJNA1200128_S_NODE_20545_length_202_cov_1.477987_g20436_i0 PRJNA1200128 20545 202 1.477987 2.98553374 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 73.6 7.65e-15   NR AAX24812.2 6182 g20436 i0 64.7 2.03465346534653 51 18 75.7 0 18 170 1 51 AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] diamond 411 73.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28399021 28399021 PRJNA1200128_S_NODE_43266_length_157_cov_2.473684_g43157_i0 PRJNA1200128 43266 157 2.473684 3.88368388 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 101 1.4e-25   NR AAM55226.1 6182 g43157 i0 90 0.955414012738854 50 5 95.5 0 3 152 112 161 AAM55226.1 CA protein [Schistosoma japonicum] diamond 150 101 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29314680 29314680 PRJNA1200128_S_NODE_45469_length_155_cov_0.919643_g45360_i0 PRJNA1200128 45469 155 0.919643 1.42544665 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 44.3 0.00188   NR AAW25703.1 6182 g45360 i0 78.3 0.445161290322581 23 5 44.5 0 80 12 33 55 AAW25703.1 SJCHGC03999 protein [Schistosoma japonicum] diamond 69 44.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29567125 29567125 PRJNA1200128_S_NODE_6590_length_288_cov_1.563265_g6481_i0 PRJNA1200128 6590 288 1.563265 4.5022032 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 92 6.71e-21   NR AAX25032.2 6182 g6481 i0 64.6 0.677083333333333 65 23 67.7 0 59 253 58 122 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 195 92 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29977726 29977726 PRJNA1200128_S_NODE_13231_length_231_cov_2.223404_g13122_i0 PRJNA1200128 13231 231 2.223404 5.13606324 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 103 1.37e-26   NR AAP06205.1 6182 g13122 i0 78.7 2.8961038961039 75 12 97.4 2 230 6 43 113 AAP06205.1 hypothetical protein [Schistosoma japonicum] diamond 669 103 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30198734 30198734 PRJNA1200128_S_NODE_3512_length_361_cov_2.616352_g3403_i0 PRJNA1200128 3512 361 2.616352 9.44503072 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 60.1 1.56e-8   NR AAX30334.2 6182 g3403 i0 69 0.698060941828255 42 13 34.9 0 127 2 67 108 AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] diamond 252 60.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30451949 30451949 PRJNA1200128_S_NODE_12713_length_234_cov_1.722513_g12604_i0 PRJNA1200128 12713 234 1.722513 4.03068042 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 48.1 2.36e-4   NR AAX25032.2 6182 g12604 i0 61.5 0.5 39 15 50 0 63 179 149 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 117 48.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30546527 30546527 PRJNA1200128_S_NODE_5393_length_308_cov_2.373585_g5284_i0 PRJNA1200128 5393 308 2.373585 7.3106418 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 66.2 7.18e-12   NR AAX31080.1 6182 g5284 i0 80 0.38961038961039 40 8 39 0 189 308 1 40 AAX31080.1 SJCHGC09793 protein [Schistosoma japonicum] diamond 120 66.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30988970 30988970 PRJNA1200128_S_NODE_27954_length_183_cov_1.342857_g27845_i0 PRJNA1200128 27954 183 1.342857 2.45742831 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 48.9 4.21e-5   NR AAX25839.2 6182 g27845 i0 57.1 1.19672131147541 42 18 68.9 0 17 142 5 46 AAX25839.2 SJCHGC09516 protein, partial [Schistosoma japonicum] diamond 219 48.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31020523 31020523 PRJNA1200128_S_NODE_9495_length_257_cov_1.537383_g9386_i0 PRJNA1200128 9495 257 1.537383 3.95107431 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 47.4 1.12e-4   NR AAX30470.1 6182 g9386 i0 71.9 1.1673151750972799 32 9 37.4 0 160 255 11 42 AAX30470.1 SJCHGC03833 protein [Schistosoma japonicum] diamond 300 47.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31083657 31083657 PRJNA1200128_S_NODE_39895_length_162_cov_1.184874_g39786_i0 PRJNA1200128 39895 162 1.184874 1.91949588 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 43.9 0.00245   NR AAX30334.2 6182 g39786 i0 80.8 0.481481481481481 26 5 48.1 0 37 114 40 65 AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] diamond 78 43.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31114977 31114977 PRJNA1200128_S_NODE_19255_length_206_cov_1.251534_g19146_i0 PRJNA1200128 19255 206 1.251534 2.57816004 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 40.8 0.0461   NR AAX24812.2 6182 g19146 i0 71.4 0.407766990291262 28 8 40.8 0 167 84 44 71 AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] diamond 84 40.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31716083 31716083 PRJNA1200128_S_NODE_27337_length_184_cov_2.354610_g27228_i0 PRJNA1200128 27337 184 2.35461 4.3324824 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 45.8 9.36e-4   NR AAX25032.2 6182 g27228 i0 51.1 0.766304347826087 47 23 76.6 0 43 183 90 136 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 141 45.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31779208 31779208 PRJNA1200128_S_NODE_3377_length_367_cov_1.608025_g3268_i0 PRJNA1200128 3377 367 1.608025 5.90145175 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 118 1.08e-30   NR AAX25032.2 6182 g3268 i0 70.2 0.686648501362398 84 25 68.7 0 104 355 104 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 252 118 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32095682 32095682 PRJNA1200128_S_NODE_15278_length_221_cov_1.320225_g15169_i0 PRJNA1200128 15278 221 1.320225 2.91769725 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 48.5 2.53e-4   NR AAX28387.3 6182 g15169 i0 53.1 3.47511312217195 64 27 82.8 2 218 36 99 162 AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] diamond 768 48.9 0.991820040899796 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32349106 32349106 PRJNA1200128_S_NODE_43699_length_157_cov_1.236842_g43590_i0 PRJNA1200128 43699 157 1.236842 1.94184194 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 51.2 6.25e-6   NR AAX25032.2 6182 g43590 i0 62.5 0.611464968152866 32 12 61.1 0 2 97 103 134 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 96 51.2 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);;