RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA315399 · 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
28211239 28211239 PRJNA315399_P_NODE_466286_length_154_cov_5.871795_g465838_i0 PRJNA315399 466286 154 5.871795 9.0425643 Schistosoma curassoni 6186 Platyhelminthes Platyhelminthes 50.1 1.28e-5   NR VDP64617.1 6186 g465838 i0 56.8 2.68831168831169 44 19 85.7 0 134 3 49 92 VDP64617.1 unnamed protein product [Schistosoma curassoni] diamond 414 50.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma curassoni
28653536 28653536 PRJNA315399_S_NODE_137507_length_164_cov_6.062992_g137306_i0 PRJNA315399 137507 164 6.062992 9.94330688 Protopolystoma xenopodis 117903 Platyhelminthes Platyhelminthes 42 0.0148   NR VEL37462.1 117903 g137306 i0 61.4 0.804878048780488 44 12 71.3 1 10 126 1 44 VEL37462.1 unnamed protein product [Protopolystoma xenopodis] diamond 132 42 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Polystomatidea Polystomatidae Protopolystoma Protopolystoma xenopodis
29379668 29379668 PRJNA315399_P_NODE_62249_length_224_cov_8.898396_g61801_i0 PRJNA315399 62249 224 8.898396 19.93240704 Paragonimus kellicotti 100269 Platyhelminthes Platyhelminthes 49.3 9.38e-5   NR KAF6773936.1 100269 g61801 i0 53.5 1.17857142857143 43 20 57.6 0 205 77 123 165 KAF6773936.1 hypothetical protein AHF37_06135 [Paragonimus kellicotti] diamond 264 49.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Troglotrematidae Paragonimus Paragonimus kellicotti
29948106 29948106 PRJNA315399_P_NODE_349511_length_169_cov_9.446970_g349063_i0 PRJNA315399 349511 169 9.44697 15.9653793 Paragonimus westermani 34504 Platyhelminthes Platyhelminthes 49.7 4.91e-5   NR KAA3669829.1 34504 g349063 i0 54.3 0.816568047337278 46 21 81.7 0 29 166 185 230 KAA3669829.1 uncharacterized protein DEA37_0001408, partial [Paragonimus westermani] diamond 138 49.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Troglotrematidae Paragonimus Paragonimus westermani
31292481 31292481 PRJNA315399_P_NODE_366975_length_166_cov_2.852713_g366527_i0 PRJNA315399 366975 166 2.852713 4.73550358 root 1 Root_unresolved Root_unresolved 54.7 7.66e-7   NR CAH8869896.1 157069 g366527 i0 55.6 4.96987951807229 45 20 81.3 0 10 144 149 193 CAH8869896.1 unnamed protein product [Trichobilharzia regenti] diamond 825 55.1 0.992740471869329 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Trichobilharzia Trichobilharzia regenti
32526695 32526695 PRJNA315399_P_NODE_452719_length_156_cov_2.747899_g452271_i0 PRJNA315399 452719 156 2.747899 4.28672244 Schistosoma 6181 Platyhelminthes Platyhelminthes 52.8 3.12e-6   NR XP_051072164.1 6185 g452271 i0 64.7 8.21153846153846 34 12 65.4 0 154 53 286 319 XP_051072164.1 hypothetical protein MS3_00001239 [Schistosoma haematobium] diamond 1281 53.1 0.994350282485876 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium

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