RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1073183 · 6 ✖

analysis 1

  • diamond · 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
27067332 27067332 PRJNA1073183_P_NODE_28222_length_249_cov_0.875000_g28127_i0 PRJNA1073183 28222 249 0.875 2.17875 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 112 3.23e-28   NR CAH8464680.1 57078 g28127 i0 61.7 0.975903614457831 81 31 97.6 0 2 244 162 242 CAH8464680.1 unnamed protein product [Dicrocoelium dendriticum] diamond 243 112 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
27856995 27856995 PRJNA1073183_P_NODE_32305_length_244_cov_0.900585_g32210_i0 PRJNA1073183 32305 244 0.900585 2.1974274 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 64.7 5.48e-10   NR PAA92714.1 282301 g32210 i0 44.4 2.79098360655738 72 40 88.5 0 26 241 15 86 PAA92714.1 hypothetical protein BOX15_Mlig032518g3 [Macrostomum lignano] diamond 681 64.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
28488646 28488646 PRJNA1073183_P_NODE_28747_length_248_cov_0.880000_g28652_i0 PRJNA1073183 28747 248 0.88 2.1824 Schistosoma haematobium 6185 Platyhelminthes Platyhelminthes 68.9 6.59e-12   NR XP_051074705.1 6185 g28652 i0 63.3 7.83870967741935 49 18 59.3 0 101 247 2 50 XP_051074705.1 Intraflagellar transport protein 46 [Schistosoma haematobium] diamond 1944 68.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium
28890430 28890430 PRJNA1073183_P_NODE_15948_length_327_cov_1.212598_g15853_i0 PRJNA1073183 15948 327 1.212598 3.96519546 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 79.7 5.58e-16   NR VUZ41708.1 6216 g15853 i0 64.3 10.8532110091743 56 20 51.4 0 170 3 9 64 VUZ41708.1 unnamed protein product [Hymenolepis diminuta] diamond 3549 80.1 0.995006242197254 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Hymenolepididae Hymenolepis Hymenolepis diminuta
30943722 30943722 PRJNA1073183_P_NODE_30154_length_246_cov_1.572254_g30059_i0 PRJNA1073183 30154 246 1.572254 3.86774484 Metazoa 33208 Platyhelminthes Platyhelminthes 102 4e-23   NR PAA67076.1 282301 g30059 i0 74 14.7682926829268 73 19 89 0 233 15 212 284 PAA67076.1 hypothetical protein BOX15_Mlig017708g1, partial [Macrostomum lignano] diamond 3633 103 0.990291262135922 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
31679141 31679141 PRJNA1073183_P_NODE_11557_length_379_cov_1.761438_g11462_i0 PRJNA1073183 11557 379 1.761438 6.67585002 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 60.1 1.38e-7   NR PAA86220.1 282301 g11462 i0 37 1.28232189973615 81 51 64.1 0 379 137 156 236 PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] diamond 486 60.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano

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