RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1035005 · 16 ✖

analysis 1

  • blastn · 16 ✖
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
3995265 3995265 PRJNA1035005_P_NODE_24684_length_289_cov_2.194444_g24278_i0 PRJNA1035005 24684 289 2.194444 6.34194316 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 484 2.2299999999999998e-132   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g24278 i0 96.886 2 289 9 100 0 1 289 2284 1996 Stenostomum sthenum mitochondrion, complete genome blastn 578 484 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
14197350 14197350 PRJNA1035005_P_NODE_2112_length_813_cov_3.933784_g1750_i0 PRJNA1035005 2112 813 3.933784 31.98166392 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 374 1.54e-98   NTclustered gi|60698656|gb|AY915745.1| 6182 g1750 i0 99.512 6.81918819188192 205 1 25 0 513 717 467 263 Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds blastn 5544 374 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
14197573 14197573 PRJNA1035005_P_NODE_50212_length_257_cov_0.847826_g49806_i0 PRJNA1035005 50212 257 0.847826 2.17891282 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 93.5 1.38e-14   NTclustered gi|56753506|gb|AY813225.1| 6182 g49806 i0 98.113 16.136186770428 53 1 21 0 1 53 96 148 Schistosoma japonicum SJCHGC06004 protein mRNA, complete cds blastn 4147 93.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
14197695 14197695 PRJNA1035005_P_NODE_7052_length_409_cov_1.092262_g6650_i0 PRJNA1035005 7052 409 1.092262 4.46735158 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 313 1.63e-80   NTclustered gi|60700756|gb|AY915859.1| 6182 g6650 i0 89.105 1.84841075794621 257 20 61 2 161 409 2 258 Schistosoma japonicum SJCHGC09793 protein mRNA, complete cds blastn 756 313 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
16745598 16745598 PRJNA1035005_P_NODE_1154_length_1243_cov_2.622222_g895_i0 PRJNA1035005 1154 1243 2.622222 32.59421946 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1323 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g895 i0 86.039 59.9782783588093 1232 172 99 0 2 1233 307 1538 Stenostomum sthenum mitochondrion, complete genome blastn 74553 1323 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
16745637 16745637 PRJNA1035005_P_NODE_1614_length_972_cov_53.985539_g1287_i0 PRJNA1035005 1614 972 53.985539 524.73943908 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1469 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g1287 i0 94.731 22.3786008230453 949 42 97 6 6 950 8984 8040 Stenostomum sthenum mitochondrion, complete genome blastn 21752 1469 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
16745896 16745896 PRJNA1035005_P_NODE_49814_length_257_cov_1.695652_g49408_i0 PRJNA1035005 49814 257 1.695652 4.35782564 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 235 2.16e-57   NTclustered gi|60691664|gb|AY915363.1| 6182 g49408 i0 100 16.9143968871595 127 0 84 0 131 257 258 132 Schistosoma japonicum SJCHGC05292 protein mRNA, partial cds blastn 4347 235 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
16746133 16746133 PRJNA1035005_P_NODE_81554_length_243_cov_1.376471_g81148_i0 PRJNA1035005 81554 243 1.376471 3.34482453 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 60.2 1.31e-4   NTclustered gi|56753506|gb|AY813225.1| 6182 g81148 i0 100 13.8271604938272 32 0 13 0 126 157 396 365 Schistosoma japonicum SJCHGC06004 protein mRNA, complete cds blastn 3360 60.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
18020509 18020509 PRJNA1035005_P_NODE_14535_length_326_cov_1.399209_g14129_i0 PRJNA1035005 14535 326 1.399209 4.56142134 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 525 1.5e-144   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g14129 i0 95.706 2 326 14 100 0 1 326 2283 2608 Stenostomum sthenum mitochondrion, complete genome blastn 652 525 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
19294459 19294459 PRJNA1035005_P_NODE_15096_length_323_cov_0.968000_g14690_i0 PRJNA1035005 15096 323 0.968 3.12664 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 54.7 0.008   NTclustered gi|690539252|emb|LN091525.1| 99802 g14690 i0 100 0.185758513931889 29 0 9 0 247 275 30 58 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0087185 blastn 60 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
19294673 19294673 PRJNA1035005_P_NODE_45376_length_262_cov_11.269841_g44970_i0 PRJNA1035005 45376 262 11.269841 29.52698342 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 431 2.629999999999999e-116   NTclustered gi|56757963|gb|AY815390.1| 6182 g44970 i0 96.226 120.25572519084 265 7 100 1 1 262 1487 1223 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 31507 431 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
21845744 21845744 PRJNA1035005_P_NODE_37778_length_272_cov_1.944724_g37372_i0 PRJNA1035005 37778 272 1.944724 5.28964928 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 167 8.54e-37   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g37372 i0 87.075 0.540441176470588 147 19 54 0 124 270 1 147 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 147 167 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
23120967 23120967 PRJNA1035005_P_NODE_24859_length_289_cov_1.555556_g24453_i0 PRJNA1035005 24859 289 1.555556 4.49555684 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 108 5.63e-19   NTclustered gi|60602543|gb|AY811840.1| 6182 g24453 i0 100 436.865051903114 58 0 20 0 1 58 58 1 Schistosoma japonicum SJCHGC03025 protein mRNA, partial cds blastn 126254 108 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
24394758 24394758 PRJNA1035005_P_NODE_18580_length_306_cov_2.682403_g18174_i0 PRJNA1035005 18580 306 2.682403 8.20815318 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 388 1.92e-103   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g18174 i0 89.542 1 306 32 100 0 1 306 13607 13912 Stenostomum sthenum mitochondrion, complete genome blastn 306 388 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
24394936 24394936 PRJNA1035005_P_NODE_45340_length_263_cov_1.189474_g44934_i0 PRJNA1035005 45340 263 1.189474 3.12831662 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 235 2.22e-57   NTclustered gi|60598617|gb|AY809969.1| 6182 g44934 i0 97.143 19.0152091254753 140 3 56 1 117 255 216 355 Schistosoma japonicum SJCHGC07053 protein mRNA, partial cds blastn 5001 235 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
24395032 24395032 PRJNA1035005_P_NODE_58040_length_251_cov_16.432584_g57634_i0 PRJNA1035005 58040 251 16.432584 41.24578584 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 459 1.1499999999999996e-124   NTclustered gi|60698688|gb|AY915747.1| 6182 g57634 i0 99.602 2.33067729083665 251 1 100 0 1 251 373 123 Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds blastn 585 459 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);;