RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA927284 · 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
2177207 2177207 PRJNA927284_P_NODE_3522_length_340_cov_2.765273_g3317_i0 PRJNA927284 3522 340 2.765273 9.4019282 Metazoa 33208 Hemichordata other_Eukaryota 216 1.62e-63   NR XP_070580119.1 63121 g3317 i0 89.4 5.98235294117647 113 12 99.7 0 340 2 618 730 XP_070580119.1 aconitate hydratase, mitochondrial-like [Ptychodera flava] diamond 2034 216 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
6356600 6356600 PRJNA927284_P_NODE_2745_length_404_cov_2.448000_g2544_i0 PRJNA927284 2745 404 2.448 9.88992 Ptychodera flava 63121 Hemichordata other_Eukaryota 202 9.82e-63   NR XP_070568289.1 63121 g2544 i0 69.6 2.98514851485149 135 40 99.5 1 403 2 115 249 XP_070568289.1 glutathione peroxidase 2-like [Ptychodera flava] diamond 1206 202 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
9829642 9829642 PRJNA927284_P_NODE_6448_length_208_cov_2.027933_g6241_i0 PRJNA927284 6448 208 2.027933 4.21810064 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 119 4.72e-30   NR XP_006815002.1 10224 g6241 i0 89.7 2.87019230769231 68 7 98.1 0 3 206 45 112 XP_006815002.1 PREDICTED: T-complex protein 1 subunit beta [Saccoglossus kowalevskii] diamond 597 119 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
16204817 16204817 PRJNA927284_P_NODE_273_length_1525_cov_2.116310_g218_i0 PRJNA927284 273 1525 2.11631 32.2737275 Metazoa 33208 Hemichordata other_Eukaryota 340 1.3799999999999995e-106   NR XP_002740264.1 10224 g218 i0 72.1 4.06819672131148 208 58 40.9 0 395 1018 226 433 XP_002740264.1 PREDICTED: dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 1 [Saccoglossus kowalevskii] diamond 6204 340 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
25127973 25127973 PRJNA927284_P_NODE_280_length_1505_cov_2.102304_g218_i1 PRJNA927284 280 1505 2.102304 31.6396752 Metazoa 33208 Hemichordata other_Eukaryota 340 1.1e-106   NR XP_002740264.1 10224 g218 i1 72.1 4.12225913621262 208 58 41.5 0 1111 488 226 433 XP_002740264.1 PREDICTED: dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 1 [Saccoglossus kowalevskii] diamond 6204 340 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
27467274 27467274 PRJNA927284_P_NODE_6243_length_214_cov_2.005405_g6036_i0 PRJNA927284 6243 214 2.005405 4.2915667 Ptychodera flava 63121 Hemichordata other_Eukaryota 66.6 3.93e-11   NR XP_070553518.1 63121 g6036 i0 47.8 0.939252336448598 67 35 93.9 0 5 205 108 174 XP_070553518.1 putative defense protein 3 [Ptychodera flava] diamond 201 66.6 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
27720226 27720226 PRJNA927284_P_NODE_8164_length_171_cov_1.774648_g7957_i0 PRJNA927284 8164 171 1.774648 3.03464808 Saccoglossus kowalevskii 10224 Hemichordata other_Eukaryota 91.3 7.3e-20   NR XP_002734673.1 10224 g7957 i0 67.9 0.982456140350877 56 18 98.2 0 3 170 319 374 XP_002734673.1 PREDICTED: angio-associated migratory cell protein-like [Saccoglossus kowalevskii] diamond 168 91.3 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
27720228 27720228 PRJNA927284_P_NODE_9384_length_150_cov_1.363636_g9177_i0 PRJNA927284 9384 150 1.363636 2.045454 Ptychodera flava 63121 Hemichordata other_Eukaryota 44.7 0.00227   NR XP_070541075.1 63121 g9177 i0 41.7 0.96 48 28 96 0 144 1 4248 4295 XP_070541075.1 fibrocystin-L-like [Ptychodera flava] diamond 144 44.7 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
29463137 29463137 PRJNA927284_P_NODE_5450_length_240_cov_2.213270_g5243_i0 PRJNA927284 5450 240 2.21327 5.311848 Metazoa 33208 Hemichordata other_Eukaryota 42.7 0.0366   NR XP_070571615.1 63121 g5243 i0 37.3 2.75 67 40 81.3 1 197 3 14 80 XP_070571615.1 neurogenic locus notch homolog protein 1-like isoform X1 [Ptychodera flava] diamond 660 42.7 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
29582298 29582298 PRJNA927284_P_NODE_810_length_870_cov_3.667063_g692_i0 PRJNA927284 810 870 3.667063 31.9034481 Saccoglossus kowalevskii 10224 Hemichordata other_Eukaryota 92.8 1.24e-17   NR XP_002734635.1 10224 g692 i0 37.3 0.582758620689655 169 96 57.9 5 684 181 45 204 XP_002734635.1 PREDICTED: uncharacterized protein LOC100373810 [Saccoglossus kowalevskii] diamond 507 92.8 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
29961560 29961560 PRJNA927284_P_NODE_5151_length_252_cov_1.502242_g4944_i0 PRJNA927284 5151 252 1.502242 3.78564984 Ptychodera flava 63121 Hemichordata other_Eukaryota 124 6.459999999999999e-31   NR XP_070541735.1 63121 g4944 i0 73.9 2.58333333333333 69 18 82.1 0 207 1 240 308 XP_070541735.1 dual oxidase 2-like isoform X2 [Ptychodera flava] diamond 651 124 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
30372696 30372696 PRJNA927284_P_NODE_1432_length_621_cov_1.763514_g1276_i0 PRJNA927284 1432 621 1.763514 10.95142194 Ptychodera flava 63121 Hemichordata other_Eukaryota 131 6.64e-34   NR XP_070553518.1 63121 g1276 i0 43.6 2.18840579710145 156 83 73.9 2 468 10 21 174 XP_070553518.1 putative defense protein 3 [Ptychodera flava] diamond 1359 131 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
31098856 31098856 PRJNA927284_P_NODE_2395_length_444_cov_2.089157_g2200_i0 PRJNA927284 2395 444 2.089157 9.27585708 Ptychodera flava 63121 Hemichordata other_Eukaryota 56.2 2.92e-6   NR XP_070553457.1 63121 g2200 i0 38.8 1.97297297297297 85 46 57.4 2 3 257 105 183 XP_070553457.1 putative defense protein 3 isoform X2 [Ptychodera flava] diamond 876 56.2 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
31478643 31478643 PRJNA927284_P_NODE_4816_length_267_cov_1.760504_g4609_i0 PRJNA927284 4816 267 1.760504 4.70054568 Saccoglossus kowalevskii 10224 Hemichordata other_Eukaryota 89.4 2.78e-19   NR XP_002731397.2 10224 g4609 i0 64.1 1.43820224719101 64 23 71.9 0 267 76 202 265 XP_002731397.2 PREDICTED: 26S proteasome non-ATPase regulatory subunit 8-like [Saccoglossus kowalevskii] diamond 384 89.4 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
32079443 32079443 PRJNA927284_P_NODE_5258_length_248_cov_1.694064_g5051_i0 PRJNA927284 5258 248 1.694064 4.20127872 Ptychodera flava 63121 Hemichordata other_Eukaryota 59.3 3.23e-8   NR XP_070553518.1 63121 g5051 i0 52 1.23387096774194 50 24 60.5 0 247 98 116 165 XP_070553518.1 putative defense protein 3 [Ptychodera flava] diamond 306 59.3 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
32774463 32774463 PRJNA927284_P_NODE_820_length_864_cov_3.917365_g692_i1 PRJNA927284 820 864 3.917365 33.8460336 Saccoglossus kowalevskii 10224 Hemichordata other_Eukaryota 91.3 4.26e-17   NR XP_002734635.1 10224 g692 i1 37.9 1.29513888888889 169 93 57.6 6 187 684 45 204 XP_002734635.1 PREDICTED: uncharacterized protein LOC100373810 [Saccoglossus kowalevskii] diamond 1119 91.3 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii

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