RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB81327" 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

  • PRJEB81327 · 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
2272450 2272450 PRJEB81327_P_NODE_8502_length_476_cov_1.526055_g7894_i0 PRJEB81327 8502 476 1.526055 7.2640218 Taenia asiatica 60517 Platyhelminthes Platyhelminthes 135 2e-35   NR BAH03397.1 60517 g7894 i0 50.8 1.62605042016807 124 58 76.3 1 102 464 37 160 BAH03397.1 cathepsin L-like cysteine peptidase [Taenia asiatica] diamond 774 135 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Taenia Taenia asiatica
27160409 27160409 PRJEB81327_P_NODE_21902_length_297_cov_1.718750_g21294_i0 PRJEB81327 21902 297 1.71875 5.1046875 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 43.5 0.0037200000000000002   NR ABA40899.1 6182 g21294 i0 48.9 0.454545454545455 45 22 45.5 1 297 163 11 54 ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] diamond 135 43.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28771164 28771164 PRJEB81327_P_NODE_22547_length_293_cov_10.622727_g21939_i0 PRJEB81327 22547 293 10.622727 31.12459011 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 79.3 1.76e-16   NR AAW27122.1 6182 g21939 i0 81.6 0.501706484641638 49 7 48.1 1 37 177 1 49 AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] diamond 147 79.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30666111 30666111 PRJEB81327_P_NODE_18853_length_311_cov_2.176471_g18245_i0 PRJEB81327 18853 311 2.176471 6.76882481 Heterobilharzia americana 39320 Platyhelminthes Platyhelminthes 88.6 3.82e-18   NR CAH8605900.1 39320 g18245 i0 53.8 3.81028938906752 78 36 75.2 0 311 78 303 380 CAH8605900.1 unnamed protein product [Heterobilharzia americana] diamond 1185 88.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Heterobilharzia Heterobilharzia americana
30887355 30887355 PRJEB81327_P_NODE_17734_length_321_cov_1.241935_g17126_i0 PRJEB81327 17734 321 1.241935 3.98661135 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 48.9 5.92e-4   NR PAA93316.1 282301 g17126 i0 46.3 0.747663551401869 41 22 38.3 0 3 125 291 331 PAA93316.1 hypothetical protein BOX15_Mlig013126g2 [Macrostomum lignano] diamond 240 48.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
31101062 31101062 PRJEB81327_P_NODE_55955_length_246_cov_0.890173_g55347_i0 PRJEB81327 55955 246 0.890173 2.18982558 Cestoda 6199 Platyhelminthes Platyhelminthes 58.9 7.79e-8   NR VDM00316.1 70667 g55347 i0 59.2 2.32926829268293 49 19 58.5 1 144 1 121 169 VDM00316.1 unnamed protein product [Schistocephalus solidus] diamond 573 58.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Schistocephalus Schistocephalus solidus
31607199 31607199 PRJEB81327_P_NODE_17236_length_325_cov_1.904762_g16628_i0 PRJEB81327 17236 325 1.904762 6.1904765 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 48.9 6.75e-4   NR CAI2738754.1 57078 g16628 i0 42.2 1.14461538461538 64 35 59.1 1 1 192 18 79 CAI2738754.1 unnamed protein product [Dicrocoelium dendriticum] diamond 372 48.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
32689453 32689453 PRJEB81327_P_NODE_10640_length_418_cov_1.226087_g10032_i0 PRJEB81327 10640 418 1.226087 5.12504366 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 59.7 2.79e-7   NR PAA86220.1 282301 g10032 i0 37 2.36842105263158 81 51 58.1 0 376 134 156 236 PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] diamond 990 59.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano

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