RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA900028" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA900028 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
2150049 2150049 PRJNA900028_P_NODE_151922_length_164_cov_97.652174_g151173_i0 PRJNA900028 151922 164 97.652174 160.14956536 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 292 7.41e-75   NTclustered gi|56757963|gb|AY815390.1| 6182 g151173 i0 98.788 125.378048780488 165 1 100 1 1 164 1637 1801 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 20562 292 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
7253455 7253455 PRJNA900028_P_NODE_26286_length_249_cov_1.495000_g25537_i0 PRJNA900028 26286 249 1.495 3.72255 Hymenolepis diminuta 6216 Platyhelminthes Platyhelminthes 416 6.939999999999999e-112   NTclustered gi|28273293|gb|AY157181.1| 6216 g25537 i0 97.177 72.6385542168675 248 4 99 1 2 249 2626 2382 Hymenolepis diminuta 28S large subunit ribosomal RNA gene, partial sequence blastn 18087 416 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Hymenolepididae Hymenolepis Hymenolepis diminuta
12724883 12724883 PRJNA900028_P_NODE_40690_length_220_cov_1.175439_g39941_i0 PRJNA900028 40690 220 1.175439 2.5859658 Rhabdocoela 27901 Platyhelminthes Platyhelminthes 89.8 1.48e-13   NTclustered gi|14530151|emb|AJ315645.1| 84153 g39941 i0 86.585 16.6363636363636 82 10 37 1 69 149 837 918 Maehrenthalia agilis partial 28S rRNA gene blastn 3660 89.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Rhabdocoela Byrsophlebidae Maehrenthalia Maehrenthalia agilis
14903532 14903532 PRJNA900028_P_NODE_47652_length_211_cov_0.790123_g46903_i0 PRJNA900028 47652 211 0.790123 1.66715953 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 217 6.209999999999999e-52   NTclustered gi|60687997|gb|AY915111.1| 6182 g46903 i0 98.374 22.1611374407583 123 2 100 0 89 211 147 269 Schistosoma japonicum SJCHGC03023 protein mRNA, complete cds blastn 4676 217 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
17453551 17453551 PRJNA900028_P_NODE_2474_length_703_cov_2.207951_g1802_i0 PRJNA900028 2474 703 2.207951 15.52189553 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 590 1.1999999999999999e-163   NTclustered gi|60698656|gb|AY915745.1| 6182 g1802 i0 98.22 8.46799431009957 337 6 48 0 7 343 131 467 Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds blastn 5953 590 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
23828190 23828190 PRJNA900028_P_NODE_799_length_1500_cov_12.394900_g108_i1 PRJNA900028 799 1500 12.3949 185.9235 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 1779 0   NTclustered gi|1124902734|gb|AY812498.2| 6182 g108 i1 98.801 56.7646666666667 1001 8 67 4 319 1318 1087 90 Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds blastn 85147 1786 0.996080627099664 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);;