RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Hemichordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Hemichordata · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB64798 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
19253891 19253891 PRJEB64798_P_NODE_231396_length_158_cov_4.256881_g229630_i0 PRJEB64798 231396 158 4.256881 6.72587198 Ptychodera flava 63121 Hemichordata other_Eukaryota 57.4 6.64e-8   NR XP_070541844.1 63121 g229630 i0 71.1 5.24050632911392 45 13 85.4 0 147 13 216 260 XP_070541844.1 small ribosomal subunit protein eS6-like [Ptychodera flava] diamond 828 57.4 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
26963382 26963382 PRJEB64798_P_NODE_212982_length_164_cov_1.426087_g211216_i0 PRJEB64798 212982 164 1.426087 2.33878268 Metazoa 33208 Hemichordata other_Eukaryota 61.6 2.71e-9   NR XP_070551288.1 63121 g211216 i0 61.5 1.90243902439024 52 18 95.1 1 7 162 8 57 XP_070551288.1 UDP-N-acetylglucosamine--dolichyl-phosphate N-acetylglucosaminephosphotransferase-like [Ptychodera flava] diamond 312 62 0.993548387096774 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
27507919 27507919 PRJEB64798_P_NODE_18023_length_470_cov_3.862233_g16308_i0 PRJEB64798 18023 470 3.862233 18.1524951 Ptychodera flava 63121 Hemichordata other_Eukaryota 80.9 6.12e-15   NR XP_070559946.1 63121 g16308 i0 39.2 1.7936170212766 125 72 79.8 1 6 380 30 150 XP_070559946.1 calcium-activated chloride channel regulator family member 3-like [Ptychodera flava] diamond 843 80.9 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
27729086 27729086 PRJEB64798_P_NODE_158564_length_184_cov_3.296296_g156798_i0 PRJEB64798 158564 184 3.296296 6.06518464 Ptychodera flava 63121 Hemichordata other_Eukaryota 42 0.0332   NR XP_070570129.1 63121 g156798 i0 36.1 0.994565217391304 61 37 99.5 2 184 2 130 188 XP_070570129.1 dnaJ homolog subfamily C member 13-like isoform X2 [Ptychodera flava] diamond 183 42 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
28202133 28202133 PRJEB64798_P_NODE_158526_length_184_cov_3.422222_g156760_i0 PRJEB64798 158526 184 3.422222 6.29688848 Ptychodera flava 63121 Hemichordata other_Eukaryota 52.4 3.47e-6   NR XP_070581591.1 63121 g156760 i0 52 0.815217391304348 50 24 81.5 0 152 3 7 56 XP_070581591.1 apolipoprotein D-like [Ptychodera flava] diamond 150 52.4 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
29717741 29717741 PRJEB64798_P_NODE_74710_length_223_cov_4.586207_g72945_i0 PRJEB64798 74710 223 4.586207 10.22724161 Ptychodera flava 63121 Hemichordata other_Eukaryota 50.4 5.38e-5   NR XP_070557394.1 63121 g72945 i0 37.7 1.88340807174888 69 30 92.8 4 15 221 8 63 XP_070557394.1 adhesion G protein-coupled receptor L3-like [Ptychodera flava] diamond 420 50.4 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
30216315 30216315 PRJEB64798_P_NODE_34872_length_334_cov_5.284211_g33114_i0 PRJEB64798 34872 334 5.284211 17.64926474 Metazoa 33208 Hemichordata other_Eukaryota 119 3.8699999999999995e-30   NR XP_070541844.1 63121 g33114 i0 65.1 14.6317365269461 106 36 95.2 1 326 9 161 265 XP_070541844.1 small ribosomal subunit protein eS6-like [Ptychodera flava] diamond 4887 119 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
30248240 30248240 PRJEB64798_P_NODE_148652_length_189_cov_3.400000_g146886_i0 PRJEB64798 148652 189 3.4 6.426 Metazoa 33208 Hemichordata other_Eukaryota 48.1 2.21e-4   NR XP_070557758.1 63121 g146886 i0 35 2.96825396825397 60 39 95.2 0 181 2 125 184 XP_070557758.1 LOW QUALITY PROTEIN: dipeptidyl peptidase 1-like [Ptychodera flava] diamond 561 48.1 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
30350259 30350259 PRJEB64798_P_NODE_190672_length_170_cov_2.909091_g188906_i0 PRJEB64798 190672 170 2.909091 4.9454547 Ptychodera flava 63121 Hemichordata other_Eukaryota 42.7 0.0141   NR XP_070536963.1 63121 g188906 i0 38.9 1.97647058823529 54 32 95.3 1 4 165 501 553 XP_070536963.1 fibroblast growth factor receptor 4-like [Ptychodera flava] diamond 336 42.7 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
30855170 30855170 PRJEB64798_P_NODE_171754_length_178_cov_2.364341_g169988_i0 PRJEB64798 171754 178 2.364341 4.20852698 Ptychodera flava 63121 Hemichordata other_Eukaryota 57 1.47e-7   NR XP_070545129.1 63121 g169988 i0 60 3.58988764044944 40 16 67.4 0 59 178 218 257 XP_070545129.1 uncharacterized protein [Ptychodera flava] diamond 639 57 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
31163990 31163990 PRJEB64798_P_NODE_226275_length_160_cov_3.936937_g224509_i0 PRJEB64798 226275 160 3.936937 6.2990992 root 1 Root_unresolved Root_unresolved 65.1 1.53e-10   NR XP_070549843.1 63121 g224509 i0 55.8 3.76875 52 23 97.5 0 158 3 10011 10062 XP_070549843.1 uncharacterized protein [Ptychodera flava] diamond 603 65.1 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
31701959 31701959 PRJEB64798_P_NODE_160277_length_183_cov_4.641791_g158511_i0 PRJEB64798 160277 183 4.6417909999999996 8.49447753 Hemichordata 10219 Hemichordata other_Eukaryota 99.8 7.919999999999999e-23   NR XP_006823776.1 10224 g158511 i0 74.6 2.90163934426229 59 15 96.7 0 6 182 367 425 XP_006823776.1 PREDICTED: protein dcd1A-like [Saccoglossus kowalevskii] diamond 531 99.8 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
31796646 31796646 PRJEB64798_P_NODE_147557_length_189_cov_17.392857_g145791_i0 PRJEB64798 147557 189 17.392857 32.87249973 Metazoa 33208 Hemichordata other_Eukaryota 72.8 4.45e-13   NR XP_070539278.1 63121 g145791 i0 54.4 6.20634920634921 57 26 90.5 0 6 176 136 192 XP_070539278.1 nucleoside diphosphate kinase homolog 7-like isoform X2 [Ptychodera flava] diamond 1173 73.2 0.994535519125683 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
31962006 31962006 PRJEB64798_P_NODE_78938_length_216_cov_7.574850_g77172_i0 PRJEB64798 78938 216 7.57485 16.361676 Saccoglossus kowalevskii 10224 Hemichordata other_Eukaryota 81.3 7.06e-16   NR XP_006814192.1 10224 g77172 i0 57.8 1.77777777777778 64 22 88.9 2 208 17 1170 1228 XP_006814192.1 PREDICTED: SCO-spondin-like [Saccoglossus kowalevskii] diamond 384 81.3 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
32688845 32688845 PRJEB64798_P_NODE_114340_length_209_cov_4.193750_g112574_i0 PRJEB64798 114340 209 4.19375 8.7649375 Ptychodera flava 63121 Hemichordata other_Eukaryota 44.3 0.00706   NR XP_070579639.1 63121 g112574 i0 59.4 1.03349282296651 32 10 41.6 1 206 120 363 394 XP_070579639.1 polycystin-1-related protein-like [Ptychodera flava] diamond 216 44.3 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
32752179 32752179 PRJEB64798_P_NODE_83240_length_213_cov_7.115854_g81474_i0 PRJEB64798 83240 213 7.115854 15.15676902 Ptychodera flava 63121 Hemichordata other_Eukaryota 77 6.82e-15   NR XP_070543867.1 63121 g81474 i0 47.2 5.94366197183099 72 36 98.6 1 211 2 77 148 XP_070543867.1 serine protease hepsin-like [Ptychodera flava] diamond 1266 77 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava

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