RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJEB50332" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB50332 · 10 ✖

analysis 1

  • diamond · 10 ✖
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
15421817 15421817 PRJEB50332_P_NODE_2653_length_351_cov_1.127586_g2571_i0 PRJEB50332 2653 351 1.127586 3.95782686 Platyhelminthes 6157 Platyhelminthes Platyhelminthes 147 3.2299999999999995e-42   NR KAA0196388.1 27845 g2571 i0 71.3 3.4017094017094 101 29 86.3 0 304 2 4 104 KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii] diamond 1194 147 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciolopsis Fasciolopsis buskii
26685210 26685210 PRJEB50332_P_NODE_9381_length_228_cov_1.245509_g9299_i0 PRJEB50332 9381 228 1.245509 2.83976052 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 56.6 3.51e-7   NR TNN04691.1 6182 g9299 i0 49.2 0.776315789473684 59 30 77.6 0 226 50 249 307 TNN04691.1 hypothetical protein EWB00_000459 [Schistosoma japonicum] diamond 177 56.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
27413045 27413045 PRJEB50332_P_NODE_203_length_1113_cov_3.103612_g162_i0 PRJEB50332 203 1113 3.103612 34.54320156 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 99.8 5.74e-19   NR PAA86220.1 282301 g162 i0 31.7 0.433962264150943 161 109 43.1 1 591 112 76 236 PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] diamond 483 99.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
28707450 28707450 PRJEB50332_P_NODE_5227_length_268_cov_1.256039_g5145_i0 PRJEB50332 5227 268 1.256039 3.36618452 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 57.4 2.34e-7   NR PAA46296.1 282301 g5145 i0 36.1 3.4589552238806 83 51 92.9 2 250 2 4 84 PAA46296.1 hypothetical protein BOX15_Mlig024231g2, partial [Macrostomum lignano] diamond 927 57.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
28763693 28763693 PRJEB50332_P_NODE_5547_length_262_cov_1.616915_g5465_i0 PRJEB50332 5547 262 1.616915 4.2363173 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 57.4 3.17e-7   NR PAA48869.1 282301 g5465 i0 38 3.24045801526718 71 43 80.2 1 262 53 287 357 PAA48869.1 hypothetical protein BOX15_Mlig012536g2 [Macrostomum lignano] diamond 849 57.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
29332098 29332098 PRJEB50332_P_NODE_17409_length_203_cov_0.915493_g17327_i0 PRJEB50332 17409 203 0.915493 1.85845079 Platyhelminthes 6157 Platyhelminthes Platyhelminthes 44.7 0.00466   NR TNN15422.1 6182 g17327 i0 42.9 2.79310344827586 63 36 93.1 0 200 12 655 717 TNN15422.1 Anoctamin-7 [Schistosoma japonicum] diamond 567 44.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29489810 29489810 PRJEB50332_P_NODE_5650_length_260_cov_1.904523_g5568_i0 PRJEB50332 5650 260 1.904523 4.9517598 Metazoa 33208 Platyhelminthes Platyhelminthes 74.7 3.6e-14   NR KAA3679161.1 34504 g5568 i0 44.6 13.3846153846154 83 45 94.6 1 258 13 118 200 KAA3679161.1 ubiquitin-conjugating enzyme E2 L3 [Paragonimus westermani] diamond 3480 75.1 0.994673768308922 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Troglotrematidae Paragonimus Paragonimus westermani
30128050 30128050 PRJEB50332_P_NODE_5872_length_256_cov_1.702564_g5790_i0 PRJEB50332 5872 256 1.702564 4.35856384 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 45.4 0.00216   NR PAA75409.1 282301 g5790 i0 35.4 2.6484375 82 48 96.1 1 254 9 26 102 PAA75409.1 hypothetical protein BOX15_Mlig034209g1, partial [Macrostomum lignano] diamond 678 45.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
30974810 30974810 PRJEB50332_P_NODE_16654_length_204_cov_0.909091_g16572_i0 PRJEB50332 16654 204 0.909091 1.85454564 Metazoa 33208 Platyhelminthes Platyhelminthes 50.8 2.97e-5   NR XP_009167839.1 6198 g16572 i0 40 3.70588235294118 60 36 88.2 0 181 2 126 185 XP_009167839.1 hypothetical protein T265_13582, partial [Opisthorchis viverrini] diamond 756 50.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Opisthorchiidae Opisthorchis Opisthorchis viverrini
32720385 32720385 PRJEB50332_P_NODE_13080_length_210_cov_0.872483_g12998_i0 PRJEB50332 13080 210 0.872483 1.8322143 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 44.3 0.00698   NR PAA61643.1 282301 g12998 i0 40.8 0.7 49 28 68.6 1 2 145 1117 1165 PAA61643.1 hypothetical protein BOX15_Mlig004442g3, partial [Macrostomum lignano] diamond 147 44.3 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);;