RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA914897" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA914897 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
2170149 2170149 PRJNA914897_P_NODE_11682_length_540_cov_131.839400_g11262_i0 PRJNA914897 11682 540 131.8394 711.93276 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 556 9.22e-154   NTclustered gi|68479954|gb|DQ076149.1| 6182 g11262 i0 98.125 0.825925925925926 320 5 82 1 222 540 136 455 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 446 556 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
4723327 4723327 PRJNA914897_P_NODE_16684_length_427_cov_1.824859_g16262_i0 PRJNA914897 16684 427 1.824859 7.79214793 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 523 7.259999999999998e-144   NTclustered gi|68479954|gb|DQ076149.1| 6182 g16262 i0 90.609 0.92271662763466 394 37 92 0 5 398 12 405 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 394 523 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
9822658 9822658 PRJNA914897_P_NODE_12108_length_528_cov_1.481319_g11688_i0 PRJNA914897 12108 528 1.481319 7.82136432 Schistosoma haematobium 6185 Platyhelminthes Platyhelminthes 76.8 3.07e-9   NTclustered gi|2318749084|ref|XM_051210484.1| 6185 g11688 i0 94 0.0946969696969697 50 3 9 0 202 251 4294 4245 Schistosoma haematobium Dynein heavy chain 1, axonemal (DNAH1), mRNA blastn 50 76.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium
13648398 13648398 PRJNA914897_P_NODE_15471_length_449_cov_216.207447_g15049_i0 PRJNA914897 15471 449 216.207447 970.77143703 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 763 0   NTclustered gi|68479954|gb|DQ076149.1| 6182 g15049 i0 97.748 0.988864142538975 444 9 99 1 7 449 12 455 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 444 763 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
22572062 22572062 PRJNA914897_P_NODE_378_length_2310_cov_6.510505_g319_i0 PRJNA914897 378 2310 6.510505 150.3926655 Schistosoma haematobium 6185 Platyhelminthes Platyhelminthes 56.5 0.018   NTclustered gi|2318760874|ref|XM_051210051.1| 6185 g319 i0 96.97 0.0142857142857143 33 1 1 0 2185 2217 2984 2952 Schistosoma haematobium uncharacterized protein (MS3_00002450), mRNA blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium

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