RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB14175 · 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
32939582 32939582 PRJEB14175_P_NODE_162873_length_262_cov_1.273632_g160606_i0 PRJEB14175 162873 262 1.273632 3.33691584 Metazoa 33208 Platyhelminthes Platyhelminthes 47.8 7.87e-4   NR TNN13271.1 6182 g160606 i0 95.5 456.458015267176 22 1 25.2 0 260 195 318 339 TNN13271.1 Protein FEV [Schistosoma japonicum] diamond 119592 47.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32956675 32956675 PRJEB14175_P_NODE_101450_length_354_cov_16.071672_g99184_i0 PRJEB14175 101450 354 16.071672 56.89371888 Opisthokonta 33154 Platyhelminthes Platyhelminthes 65.5 5.8e-11   NR AAP06323.1 6182 g99184 i0 74.4 7.04237288135593 43 11 36.4 0 206 334 66 108 AAP06323.1 SJCHGC06193 protein [Schistosoma japonicum] diamond 2493 65.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32974197 32974197 PRJEB14175_P_NODE_80266_length_407_cov_16.670520_g78004_i0 PRJEB14175 80266 407 16.67052 67.8490164 root 1 Root_unresolved Root_unresolved 45.4 0.026   NR THD26651.1 6192 g78004 i0 29.3 1.98280098280098 99 69 73 1 336 40 342 439 THD26651.1 hypothetical protein D915_002490 [Fasciola hepatica] diamond 807 45.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciola Fasciola hepatica
32978304 32978304 PRJEB14175_P_NODE_277899_length_173_cov_8.000000_g275631_i0 PRJEB14175 277899 173 8 13.84 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 61.2 4.49e-10   NR AAW27122.1 6182 g275631 i0 87.1 0.53757225433526 31 4 53.8 0 33 125 19 49 AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] diamond 93 61.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
33041884 33041884 PRJEB14175_P_NODE_101620_length_354_cov_3.587031_g99354_i0 PRJEB14175 101620 354 3.587031 12.69808974 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 124 2.29e-30   NR VDP91574.1 27848 g99354 i0 54.8 7.30508474576271 104 46 87.3 1 332 24 583 686 VDP91574.1 unnamed protein product [Echinostoma caproni] diamond 2586 124 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Echinostomatidae Echinostoma Echinostoma caproni
33110360 33110360 PRJEB14175_P_NODE_223222_length_211_cov_3.400000_g220954_i0 PRJEB14175 223222 211 3.4 7.174 Taeniidae 6208 Platyhelminthes Platyhelminthes 61.6 5.4e-9   NR VDM32539.1 6205 g220954 i0 50.8 6.35545023696682 61 29 86.7 1 4 186 140 199 VDM32539.1 unnamed protein product [Hydatigera taeniaeformis] diamond 1341 61.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Hydatigera Hydatigera taeniaeformis

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