RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA788929 · 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
769323 769323 PRJNA788929_P_NODE_28861_length_294_cov_22.027149_g28200_i0 PRJNA788929 28861 294 22.027149 64.75981806 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 235 2.5199999999999997e-57   NTclustered gi|421976077|gb|JX679684.1| 6161 g28200 i0 91.716 56.1258503401361 169 14 57 0 24 192 974 1142 Dugesia japonica beta-actin mRNA, complete cds blastn 16501 235 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
3320319 3320319 PRJNA788929_P_NODE_11663_length_512_cov_4.646925_g11009_i0 PRJNA788929 11663 512 4.646925 23.792256 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 472 3.25e-128   NTclustered gi|690816508|emb|LN310741.1| 99802 g11009 i0 87.104 2.857421875 442 25 83 10 65 490 569 144 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0219101 blastn 1463 472 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
11418239 11418239 PRJNA788929_P_NODE_33209_length_271_cov_14.393939_g32548_i0 PRJNA788929 33209 271 14.393939 39.00757469 Anthocephaliidae 1617303 Platyhelminthes Platyhelminthes 86.1 2.45e-12   NTclustered gi|223670572|gb|FJ177099.1| 595947 g32548 i0 90.909 24.3247232472325 66 3 24 3 202 265 1067 1131 Anthocephalum cf. centrurum LRP4219 voucher LRP4219 (TE141) 28S ribosomal RNA gene, partial sequence blastn 6592 86.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Rhinebothriidea Anthocephaliidae Anthocephalum Anthocephalum cf. centrurum LRP4219
21172110 21172110 PRJNA788929_P_NODE_43917_length_234_cov_13.111801_g43256_i0 PRJNA788929 43917 234 13.111801 30.68161434 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 52.8 0.021   NTclustered gi|1240504568|gb|MF667538.1| 6161 g43256 i0 100 0.11965811965812 28 0 12 0 205 232 28 1 Dugesia japonica 14-3-3 epsilon mRNA, complete cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
22446855 22446855 PRJNA788929_P_NODE_4238_length_988_cov_31.036066_g3737_i0 PRJNA788929 4238 988 31.036066 306.63633208 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1467 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g3737 i0 94.804 21.8927125506073 943 45 95 4 46 986 8040 8980 Stenostomum sthenum mitochondrion, complete genome blastn 21630 1467 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);;