RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA812001" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA812001 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
26642633 26642633 PRJNA812001_P_NODE_73201_length_257_cov_2.260870_g72955_i0 PRJNA812001 73201 257 2.26087 5.8104359 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 77 5.04e-16   NR AAX24941.2 6182 g72955 i0 70.4 0.630350194552529 54 16 63 0 244 83 37 90 AAX24941.2 SJCHGC03936 protein, partial [Schistosoma japonicum] diamond 162 77 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
27370687 27370687 PRJNA812001_P_NODE_82783_length_250_cov_2.570621_g82537_i0 PRJNA812001 82783 250 2.570621 6.4265525 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 95.5 7.76e-23   NR AAX25839.2 6182 g82537 i0 80 0.66 55 11 66 0 86 250 2 56 AAX25839.2 SJCHGC09516 protein, partial [Schistosoma japonicum] diamond 165 95.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28128274 28128274 PRJNA812001_P_NODE_137585_length_214_cov_6.666667_g137339_i0 PRJNA812001 137585 214 6.666667 14.26666738 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 130 1.4999999999999999e-33   NR AAX28387.3 6182 g137339 i0 100 8.66355140186916 68 0 95.3 0 2 205 373 440 AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] diamond 1854 131 0.99236641221374 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28254354 28254354 PRJNA812001_P_NODE_13026_length_443_cov_4.056757_g12780_i0 PRJNA812001 13026 443 4.056757 17.97143351 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 103 1.97e-24   NR AAX25032.2 6182 g12780 i0 50.9 0.785553047404063 116 48 78.6 1 72 419 31 137 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 348 103 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28475486 28475486 PRJNA812001_P_NODE_13926_length_431_cov_3.511173_g13680_i0 PRJNA812001 13926 431 3.511173 15.13315563 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 57 8.86e-7   NR AAX25032.2 6182 g13680 i0 48 0.522041763341067 75 26 50.8 2 221 3 53 116 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 225 57 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29296388 29296388 PRJNA812001_P_NODE_28569_length_340_cov_4.715356_g28323_i0 PRJNA812001 28569 340 4.715356 16.0322104 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 64.3 1.77e-10   NR AAX24812.2 6182 g28323 i0 63.3 1.34117647058824 49 16 43.2 1 202 56 8 54 AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] diamond 456 64.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31729330 31729330 PRJNA812001_P_NODE_93017_length_248_cov_2.091429_g92771_i0 PRJNA812001 93017 248 2.091429 5.18674392 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 49.7 8.33e-6   NR ABA40899.1 6182 g92771 i0 59 0.471774193548387 39 14 44.8 1 65 175 4 42 ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] diamond 117 49.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum

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