RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA752278 · 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
4555507 4555507 PRJNA752278_P_NODE_1824_length_844_cov_9.933852_g1648_i0 PRJNA752278 1824 844 9.933852 83.84171088 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1330 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g1648 i0 95.148 25.2476303317536 845 37 99 4 2 844 8963 8121 Stenostomum sthenum mitochondrion, complete genome blastn 21309 1330 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
12206871 12206871 PRJNA752278_P_NODE_38150_length_288_cov_3.679070_g37947_i0 PRJNA752278 38150 288 3.67907 10.5957216 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 532 7.8e-147   NTclustered gi|546143622|ref|NC_022448.1| 79327 g37947 i0 100 19.6805555555556 288 0 100 0 1 288 22984 23271 Schmidtea mediterranea mitochondrion, complete genome blastn 5668 532 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
13482235 13482235 PRJNA752278_P_NODE_90971_length_246_cov_0.890173_g90768_i0 PRJNA752278 90971 246 0.890173 2.18982558 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 316 7.14e-82   NTclustered gi|68479954|gb|DQ076149.1| 6182 g90768 i0 89.837 1 246 25 100 0 1 246 40 285 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 246 316 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
17305154 17305154 PRJNA752278_P_NODE_20434_length_352_cov_4.057348_g20231_i0 PRJNA752278 20434 352 4.057348 14.28186496 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 139 2.4799999999999998e-28   NTclustered gi|690929153|emb|LN438066.1| 99802 g20231 i0 84.397 0.997159090909091 141 22 40 0 212 352 310 170 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0186957 blastn 351 139 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
24953543 24953543 PRJNA752278_P_NODE_18960_length_362_cov_1.598616_g18757_i0 PRJNA752278 18960 362 1.598616 5.78698992 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 337 8.46e-88   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g18757 i0 83.754 3.70165745856354 357 56 98 2 7 362 5470 5115 Stenostomum sthenum mitochondrion, complete genome blastn 1340 337 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);;