RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA641991" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA641991 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
1894018 1894018 PRJNA641991_S_NODE_7322_length_204_cov_3.322581_g7203_i0 PRJNA641991 7322 204 3.322581 6.77806524 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 252 1.63e-62   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g7203 i0 99.281 0.872549019607843 139 1 68 0 1 139 139 1 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 178 252 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
5721276 5721276 PRJNA641991_P_NODE_1365_length_270_cov_1.153846_g1324_i0 PRJNA641991 1365 270 1.153846 3.1153842 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 239 1.7700000000000002e-58   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g1324 i0 100 0.622222222222222 129 0 48 0 141 269 1 129 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 168 239 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
10821968 10821968 PRJNA641991_S_NODE_10769_length_174_cov_1.632000_g10650_i0 PRJNA641991 10769 174 1.632 2.83968 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 121 3.9599999999999997e-23   NTclustered gi|1084309590|ref|XM_018790693.1| 6183 g10650 i0 84.127 19.1724137931034 126 18 72 2 1 125 2699 2575 Schistosoma mansoni DNA polymerase delta catalytic subunit,putative partial mRNA blastn 3336 121 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
10822039 10822039 PRJNA641991_S_NODE_9309_length_185_cov_1.500000_g9190_i0 PRJNA641991 9309 185 1.5 2.775 Gyrodactylus gurleyi 83195 Platyhelminthes Platyhelminthes 226 8.789999999999998e-55   NTclustered gi|1607200663|ref|NC_041379.1| 83195 g9190 i0 88.77 2.8 187 17 100 4 1 185 370 554 Gyrodactylus gurleyi mitochondrion, complete genome blastn 518 226 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Gyrodactylidea Gyrodactylidae Gyrodactylus Gyrodactylus gurleyi
13371784 13371784 PRJNA641991_P_NODE_2291_length_201_cov_1.250000_g2250_i0 PRJNA641991 2291 201 1.25 2.5125 Gyrodactylus kobayashii 89149 Platyhelminthes Platyhelminthes 267 5.73e-67   NTclustered gi|1025806290|ref|NC_030050.1| 89149 g2250 i0 90.547 3.92537313432836 201 19 100 0 1 201 386 586 Gyrodactylus kobayashii mitochondrion, complete genome blastn 789 267 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Gyrodactylidea Gyrodactylidae Gyrodactylus Gyrodactylus kobayashii
15920636 15920636 PRJNA641991_S_NODE_4933_length_242_cov_1.088083_g4814_i0 PRJNA641991 4933 242 1.088083 2.63316086 Gyrodactylus sp. 1 JWC-2022 2930226 Platyhelminthes Platyhelminthes 414 2.41e-111   NTclustered gi|2214506168|gb|ON117567.1| 2930226 g4814 i0 97.521 36.7768595041322 242 6 100 0 1 242 1049 808 Gyrodactylus sp. 1 JWC-2022 isolate jsjy1 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence blastn 8900 414 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Gyrodactylidea Gyrodactylidae Gyrodactylus Gyrodactylus sp. 1 JWC-2022
18470046 18470046 PRJNA641991_S_NODE_9635_length_183_cov_1.007463_g9516_i0 PRJNA641991 9635 183 1.007463 1.84365729 Gyrodactylus banmae 2907319 Platyhelminthes Platyhelminthes 327 2.31e-85   NTclustered gi|1983548782|gb|MW593152.1| 2907319 g9516 i0 98.907 1.98907103825137 183 2 100 0 1 183 1301 1483 Gyrodactylus banmae isolate A cytochrome c oxidase subunit I (COX1) gene, complete cds; mitochondrial blastn 364 327 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Gyrodactylidea Gyrodactylidae Gyrodactylus Gyrodactylus banmae
19744622 19744622 PRJNA641991_S_NODE_14076_length_162_cov_1.805310_g13957_i0 PRJNA641991 14076 162 1.80531 2.9246022 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 124 2.8199999999999994e-24   NTclustered gi|166156944|gb|EU380241.1| 6161 g13957 i0 80.892 8.05555555555556 157 30 97 0 3 159 213 57 Dugesia japonica heat shock protein 70 (hsp70) mRNA, complete cds blastn 1305 124 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
21020143 21020143 PRJNA641991_P_NODE_1017_length_328_cov_1.738351_g976_i0 PRJNA641991 1017 328 1.738351 5.70179128 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 518 2.53e-142   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g976 i0 94.737 1.04268292682927 342 3 99 3 2 328 554 895 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 342 518 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
21020185 21020185 PRJNA641991_S_NODE_437_length_768_cov_2.777469_g349_i0 PRJNA641991 437 768 2.777469 21.33096192 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 1373 0   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g349 i0 98.958 13.45703125 768 7 100 1 1 768 253 1019 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 10335 1373 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
23570484 23570484 PRJNA641991_S_NODE_13959_length_163_cov_0.894737_g13840_i0 PRJNA641991 13959 163 0.894737 1.45842131 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 84.2 4.82e-12   NTclustered gi|60598183|gb|AY809752.1| 6182 g13840 i0 91.667 1.87730061349693 60 5 37 0 1 60 327 268 Schistosoma japonicum SJCHGC03735 protein mRNA, partial cds blastn 306 84.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
23570487 23570487 PRJNA641991_S_NODE_14399_length_162_cov_0.902655_g14280_i0 PRJNA641991 14399 162 0.902655 1.4623011 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 106 1.02e-18   NTclustered gi|24796638|gb|AY067183.1| 79327 g14280 i0 79.72 0.882716049382716 143 23 86 6 23 162 72 211 Schmidtea mediterranea clone H.89.3e unknown mRNA sequence blastn 143 106 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
24844070 24844070 PRJNA641991_P_NODE_1060_length_318_cov_0.962825_g1019_i0 PRJNA641991 1060 318 0.962825 3.0617835 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 571 1.8499999999999996e-158   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g1019 i0 99.057 16.1729559748428 318 3 100 0 1 318 209 526 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 5143 571 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
25384769 25384769 PRJNA641991_P_NODE_2840_length_179_cov_1.630769_g2799_i0 PRJNA641991 2840 179 1.630769 2.91907651 Gyrodactylus 37846 Platyhelminthes Platyhelminthes 331 1.74e-86   NTclustered gi|1941833495|gb|MW353802.1| 2907319 g2799 i0 100 100 179 0 100 0 1 179 821 643 Gyrodactylus banmae internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence blastn 17900 331 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Gyrodactylidea Gyrodactylidae Gyrodactylus Gyrodactylus banmae

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