RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA764222" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA764222 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
27337793 27337793 PRJNA764222_S_NODE_4503_length_318_cov_1.461255_g4345_i0 PRJNA764222 4503 318 1.461255 4.6467909 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 86.7 1.03e-19   NR PAA56754.1 282301 g4345 i0 80.5 0.386792452830189 41 8 38.7 0 317 195 48 88 PAA56754.1 hypothetical protein BOX15_Mlig011635g4 [Macrostomum lignano] diamond 123 86.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
27432691 27432691 PRJNA764222_S_NODE_32343_length_162_cov_3.582609_g32185_i0 PRJNA764222 32343 162 3.582609 5.80382658 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 69.7 2.06e-13   NR PAA67750.1 282301 g32185 i0 97.1 0.648148148148148 35 1 64.8 0 162 58 101 135 PAA67750.1 hypothetical protein BOX15_Mlig022537g2, partial [Macrostomum lignano] diamond 105 69.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
28600797 28600797 PRJNA764222_S_NODE_12087_length_249_cov_2.430693_g11929_i0 PRJNA764222 12087 249 2.430693 6.05242557 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 56.6 6.58e-8   NR PAA53801.1 282301 g11929 i0 56.1 0.493975903614458 41 18 49.4 0 5 127 86 126 PAA53801.1 hypothetical protein BOX15_Mlig023736g2, partial [Macrostomum lignano] diamond 123 56.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
28600800 28600800 PRJNA764222_S_NODE_25787_length_185_cov_1.847826_g25629_i0 PRJNA764222 25787 185 1.847826 3.4184781 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 105 4.86e-27   NR PAA58262.1 282301 g25629 i0 89.3 1.81621621621622 56 6 90.8 0 3 170 121 176 PAA58262.1 hypothetical protein BOX15_Mlig017433g2 [Macrostomum lignano] diamond 336 105 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
30684996 30684996 PRJNA764222_S_NODE_32953_length_160_cov_2.008850_g32795_i0 PRJNA764222 32953 160 2.00885 3.21416 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 92.4 3.75e-22   NR PAA45962.1 282301 g32795 i0 93.6 0.88125 47 3 88.1 0 1 141 107 153 PAA45962.1 hypothetical protein BOX15_Mlig032769g3, partial [Macrostomum lignano] diamond 141 92.4 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);;