RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA274362" 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

  • PRJNA274362 · 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
370650 370650 PRJNA274362_S_NODE_28161_length_178_cov_2.813953_g28041_i0 PRJNA274362 28161 178 2.813953 5.00883634 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 307 2.91e-79   NTclustered gi|68479954|gb|DQ076149.1| 6182 g28041 i0 97.753 1 178 4 100 0 1 178 216 39 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 178 307 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
6748050 6748050 PRJNA274362_S_NODE_13586_length_242_cov_1.025907_g13466_i0 PRJNA274362 13586 242 1.025907 2.48269494 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 289 1.53e-73   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g13466 i0 90.783 0.896694214876033 217 19 89 1 1 216 8256 8040 Stenostomum sthenum mitochondrion, complete genome blastn 217 289 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
7436510 7436510 PRJNA274362_S_NODE_24246_length_190_cov_6.340426_g24126_i0 PRJNA274362 24246 190 6.340426 12.0468094 Metazoa 33208 Platyhelminthes Platyhelminthes 307 3.16e-79   NTclustered gi|1126394097|gb|AY813297.2| 6182 g24126 i0 99.412 34.7421052631579 170 0 89 1 21 190 148 316 Schistosoma japonicum clone SJCHGC01483 unknown mRNA, partial cds blastn 6601 307 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
13811947 13811947 PRJNA274362_S_NODE_10871_length_265_cov_3.217593_g10751_i0 PRJNA274362 10871 265 3.217593 8.52662145 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 475 1.2099999999999996e-129   NTclustered gi|2866376384|gb|PQ722296.1| 39377 g10751 i0 99.615 96.6754716981132 260 1 98 0 1 260 282 23 Stenostomum sp. (in: flatworms) isolate F8 small subunit ribosomal RNA gene, partial sequence blastn 25619 477 0.9958071278826 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sp. (in: flatworms)
19496372 19496372 PRJNA274362_S_NODE_16996_length_220_cov_1.497076_g16876_i0 PRJNA274362 16996 220 1.497076 3.2935672 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 270 4.9399999999999996e-68   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g16876 i0 88.991 0.990909090909091 218 24 99 0 3 220 13856 14073 Stenostomum sthenum mitochondrion, complete genome blastn 218 270 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
20771767 20771767 PRJNA274362_S_NODE_1117_length_726_cov_17.084195_g1030_i0 PRJNA274362 1117 726 17.084195 124.0312557 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1168 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g1030 i0 95.856 29.0151515151515 724 26 99 4 4 725 8242 8963 Stenostomum sthenum mitochondrion, complete genome blastn 21065 1168 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum

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