RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1158727 · 14 ✖

analysis 1

  • diamond · 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
27261672 27261672 PRJNA1158727_P_NODE_118583_length_269_cov_1.372449_g111122_i0 PRJNA1158727 118583 269 1.372449 3.69188781 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 44.7 0.00445   NR AAX30334.2 6182 g111122 i0 90.9 0.245353159851301 22 2 24.5 0 116 51 1 22 AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] diamond 66 44.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28019660 28019660 PRJNA1158727_P_NODE_148325_length_246_cov_1.271676_g140863_i0 PRJNA1158727 148325 246 1.271676 3.12832296 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 83.2 1.09e-17   NR AAX25032.2 6182 g140863 i0 77.4 0.646341463414634 53 12 64.6 0 86 244 135 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 159 83.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28114084 28114084 PRJNA1158727_P_NODE_38745_length_637_cov_3.471631_g31372_i0 PRJNA1158727 38745 637 3.471631 22.11428947 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 67 8.06e-10   NR AAX25032.2 6182 g31372 i0 41.7 0.54160125588697 115 57 54.2 3 345 1 1 105 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 345 67 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28619616 28619616 PRJNA1158727_P_NODE_82307_length_333_cov_1.169231_g74846_i0 PRJNA1158727 82307 333 1.169231 3.89353923 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 91.3 2.35e-20   NR AAX25032.2 6182 g74846 i0 74.5 0.495495495495495 55 13 48.6 1 144 305 74 128 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 165 91.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28808516 28808516 PRJNA1158727_P_NODE_126008_length_260_cov_2.310160_g118547_i0 PRJNA1158727 126008 260 2.31016 6.006416 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 85.5 1.67e-18   NR AAX25032.2 6182 g118547 i0 84 0.576923076923077 50 8 57.7 0 258 109 14 63 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 150 85.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29314049 29314049 PRJNA1158727_P_NODE_166749_length_229_cov_2.391026_g159287_i0 PRJNA1158727 166749 229 2.391026 5.47544954 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 66.2 1.61e-10   NR AAX28387.3 6182 g159287 i0 72 2.62008733624454 50 12 62.9 2 210 67 108 157 AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] diamond 600 66.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29850902 29850902 PRJNA1158727_P_NODE_118851_length_269_cov_0.790816_g111390_i0 PRJNA1158727 118851 269 0.790816 2.12729504 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 121 1.85e-32   NR AAX25032.2 6182 g111390 i0 83.1 0.79182156133829 71 12 79.2 0 267 55 117 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 213 121 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30577223 30577223 PRJNA1158727_P_NODE_44013_length_564_cov_1.725051_g36586_i0 PRJNA1158727 44013 564 1.725051 9.72928764 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 194 4.01e-61   NR AAX31034.1 6182 g36586 i0 100 0.473404255319149 89 0 47.3 0 564 298 1 89 AAX31034.1 unknown [Schistosoma japonicum] diamond 267 194 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30798540 30798540 PRJNA1158727_P_NODE_52974_length_474_cov_20.216958_g45516_i0 PRJNA1158727 52974 474 20.216958 95.82838092 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 80.9 3.38e-16   NR AAW27122.1 6182 g45516 i0 83.7 0.310126582278481 49 4 28.5 1 468 334 1 49 AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] diamond 147 80.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31462668 31462668 PRJNA1158727_P_NODE_98436_length_296_cov_1.049327_g90975_i0 PRJNA1158727 98436 296 1.049327 3.10600792 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 103 1.65e-25   NR AAX25032.2 6182 g90975 i0 85.7 0.567567567567568 56 8 56.8 0 3 170 104 159 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 168 103 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31557541 31557541 PRJNA1158727_P_NODE_154456_length_244_cov_0.900585_g146994_i0 PRJNA1158727 154456 244 0.900585 2.1974274 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 106 3.72e-27   NR AAM55226.1 6182 g146994 i0 85.5 5.49590163934426 55 8 67.6 0 2 166 26 80 AAM55226.1 CA protein [Schistosoma japonicum] diamond 1341 106 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31746983 31746983 PRJNA1158727_P_NODE_115837_length_272_cov_1.547739_g108376_i0 PRJNA1158727 115837 272 1.547739 4.20985008 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 134 4.54e-38   NR AAM55226.1 6182 g108376 i0 89.9 0.761029411764706 69 7 76.1 0 3 209 32 100 AAM55226.1 CA protein [Schistosoma japonicum] diamond 207 134 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31797860 31797860 PRJNA1158727_P_NODE_156717_length_243_cov_0.905882_g149255_i0 PRJNA1158727 156717 243 0.905882 2.20129326 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 80.9 9.74e-17   NR KAF8564821.1 34504 g149255 i0 50.6 8.23456790123457 79 29 85.2 1 208 2 82 160 KAF8564821.1 hypothetical protein P879_07365 [Paragonimus westermani] diamond 2001 80.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Troglotrematidae Paragonimus Paragonimus westermani
32126917 32126917 PRJNA1158727_P_NODE_135618_length_251_cov_0.865169_g128156_i0 PRJNA1158727 135618 251 0.865169 2.17157419 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 44.7 0.00851   NR PAA58183.1 282301 g128156 i0 44.6 1.9601593625498 56 27 62.2 1 1 156 503 558 PAA58183.1 hypothetical protein BOX15_Mlig012053g1 [Macrostomum lignano] diamond 492 44.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);;