contig_metadata
16 rows where bioproject = "PRJNA1011833", tax_clade = "Opisthokonta" and tax_phylum = "Echinodermata"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26995150 | 26995150 | PRJNA1011833_S_NODE_15962_length_302_cov_4.613900_g15542_i0 | PRJNA1011833 | 15962 | 302 | 4.6139 | 13.933978 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 106 | 1.84e-24 | NR | XP_054774179.2 | 7653 | g15542 | i0 | 43.4 | 1.96688741721854 | 99 | 56 | 98.3 | 0 | 301 | 5 | 411 | 509 | XP_054774179.2 cGMP-dependent protein kinase 1-like [Lytechinus pictus] | diamond | 594 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 27603621 | 27603621 | PRJNA1011833_S_NODE_5824_length_445_cov_4.029851_g5412_i0 | PRJNA1011833 | 5824 | 445 | 4.029851 | 17.93283695 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 100 | 1.33e-21 | NR | XP_022106049.1 | 133434 | g5412 | i0 | 41.6 | 1.67865168539326 | 125 | 72 | 84.3 | 1 | 3 | 377 | 410 | 533 | XP_022106049.1 mitochondrial-processing peptidase subunit alpha-like [Acanthaster planci] | diamond | 747 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27943211 | 27943211 | PRJNA1011833_S_NODE_18525_length_281_cov_2.117647_g18105_i0 | PRJNA1011833 | 18525 | 281 | 2.117647 | 5.95058807 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 141 | 9.55e-37 | NR | XP_041465106.1 | 7654 | g18105 | i0 | 61.3 | 5.92526690391459 | 93 | 36 | 99.3 | 0 | 2 | 280 | 672 | 764 | XP_041465106.1 cactin-like [Lytechinus variegatus] | diamond | 1665 | 142 | 0.992957746478873 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28234645 | 28234645 | PRJNA1011833_S_NODE_25126_length_237_cov_2.969072_g24706_i0 | PRJNA1011833 | 25126 | 237 | 2.969072 | 7.03670064 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 129 | 1.64e-32 | NR | KAJ8040749.1 | 206669 | g24706 | i0 | 75.6 | 2.9620253164557 | 78 | 19 | 98.7 | 0 | 236 | 3 | 72 | 149 | KAJ8040749.1 Structural maintenance of chromosomes protein 2 [Holothuria leucospilota] | diamond | 702 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29584624 | 29584624 | PRJNA1011833_S_NODE_58430_length_152_cov_0.880734_g58010_i0 | PRJNA1011833 | 58430 | 152 | 0.880734 | 1.33871568 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 51.6 | 6.99e-6 | NR | XP_033632484.1 | 7604 | g58010 | i0 | 45.8 | 3.80921052631579 | 48 | 25 | 94.7 | 1 | 151 | 8 | 136 | 182 | XP_033632484.1 protein unc-50 homolog [Asterias rubens] | diamond | 579 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30382669 | 30382669 | PRJNA1011833_S_NODE_8033_length_401_cov_1.988827_g7616_i0 | PRJNA1011833 | 8033 | 401 | 1.988827 | 7.97519627 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 85.5 | 1.83e-16 | NR | PIK56934.1 | 307972 | g7616 | i0 | 35.4 | 0.950124688279302 | 127 | 80 | 94.3 | 2 | 395 | 18 | 298 | 423 | PIK56934.1 putative rRNA methyltransferase 3, mitochondrial [Apostichopus japonicus] | diamond | 381 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 30563883 | 30563883 | PRJNA1011833_S_NODE_21313_length_260_cov_4.354839_g20893_i0 | PRJNA1011833 | 21313 | 260 | 4.354839 | 11.3225814 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 75.9 | 9.57e-16 | NR | XP_033627414.1 | 7604 | g20893 | i0 | 47.2 | 9.12692307692308 | 72 | 37 | 83.1 | 1 | 258 | 43 | 22 | 92 | XP_033627414.1 mitochondrial import inner membrane translocase subunit Tim10-like [Asterias rubens] | diamond | 2373 | 76.3 | 0.99475753604194 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30761468 | 30761468 | PRJNA1011833_S_NODE_27134_length_227_cov_2.978261_g26714_i0 | PRJNA1011833 | 27134 | 227 | 2.978261 | 6.76065247 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 67 | 7.24e-11 | NR | XP_033644818.1 | 7604 | g26714 | i0 | 45.5 | 3.56828193832599 | 66 | 36 | 87.2 | 0 | 198 | 1 | 257 | 322 | XP_033644818.1 adenosine 3'-phospho 5'-phosphosulfate transporter 2-like [Asterias rubens] | diamond | 810 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31417511 | 31417511 | PRJNA1011833_S_NODE_11156_length_354_cov_8.012862_g10736_i0 | PRJNA1011833 | 11156 | 354 | 8.012862 | 28.36553148 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 171 | 1.29e-47 | NR | XP_071479759.1 | 105358 | g10736 | i0 | 72.6 | 35.6016949152542 | 106 | 29 | 89.8 | 0 | 2 | 319 | 489 | 594 | XP_071479759.1 lysine--tRNA ligase-like [Diadema antillarum] | diamond | 12603 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31796872 | 31796872 | PRJNA1011833_S_NODE_15857_length_303_cov_4.888462_g15437_i0 | PRJNA1011833 | 15857 | 303 | 4.888462 | 14.81203986 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 70.9 | 2.86e-12 | NR | XP_041481822.1 | 7654 | g15437 | i0 | 42.4 | 3.79207920792079 | 99 | 42 | 98 | 1 | 302 | 6 | 20 | 103 | XP_041481822.1 survival of motor neuron-related-splicing factor 30-like [Lytechinus variegatus] | diamond | 1149 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31796873 | 31796873 | PRJNA1011833_S_NODE_18157_length_284_cov_2.016598_g17737_i0 | PRJNA1011833 | 18157 | 284 | 2.016598 | 5.72713832 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 87.4 | 1.15e-18 | NR | XP_038078338.1 | 46514 | g17737 | i0 | 49.4 | 18.2429577464789 | 77 | 37 | 81.3 | 2 | 272 | 42 | 154 | 228 | XP_038078338.1 protein pygopus-like [Patiria miniata] | diamond | 5181 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32057770 | 32057770 | PRJNA1011833_S_NODE_7378_length_412_cov_7.043360_g6962_i0 | PRJNA1011833 | 7378 | 412 | 7.04336 | 29.0186432 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 97.1 | 2.83e-22 | NR | XP_071476142.1 | 105358 | g6962 | i0 | 44.9 | 2.49029126213592 | 89 | 49 | 64.8 | 0 | 66 | 332 | 81 | 169 | XP_071476142.1 E3 ubiquitin-protein ligase RNF126-like isoform X2 [Diadema antillarum] | diamond | 1026 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32279499 | 32279499 | PRJNA1011833_S_NODE_9639_length_375_cov_4.536145_g9221_i0 | PRJNA1011833 | 9639 | 375 | 4.536145 | 17.01054375 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 88.2 | 2.38e-19 | NR | XP_030833531.1 | 7668 | g9221 | i0 | 44.2 | 14.648 | 95 | 52 | 76 | 1 | 6 | 290 | 34 | 127 | XP_030833531.1 prefoldin subunit 2-like [Strongylocentrotus purpuratus] | diamond | 5493 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32461601 | 32461601 | PRJNA1011833_S_NODE_43359_length_176_cov_2.526316_g42939_i0 | PRJNA1011833 | 43359 | 176 | 2.526316 | 4.44631616 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.6 | 1.87e-7 | NR | XP_041481324.1 | 7654 | g42939 | i0 | 54.3 | 5.94886363636364 | 46 | 21 | 78.4 | 0 | 169 | 32 | 283 | 328 | XP_041481324.1 guanine nucleotide-binding protein G(i) subunit alpha-like [Lytechinus variegatus] | diamond | 1047 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32753004 | 32753004 | PRJNA1011833_S_NODE_48960_length_165_cov_2.245902_g48540_i0 | PRJNA1011833 | 48960 | 165 | 2.245902 | 3.7057383 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 70.9 | 1.58e-12 | NR | KAJ8032907.1 | 206669 | g48540 | i0 | 62 | 0.909090909090909 | 50 | 19 | 90.9 | 0 | 165 | 16 | 412 | 461 | KAJ8032907.1 Serine/threonine-protein kinase Sgk3 [Holothuria leucospilota] | diamond | 150 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32871315 | 32871315 | PRJNA1011833_S_NODE_16760_length_295_cov_4.257937_g16340_i0 | PRJNA1011833 | 16760 | 295 | 4.257937 | 12.56091415 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 44.7 | 0.0064 | NR | XP_041456625.1 | 7654 | g16340 | i0 | 32.7 | 3.58983050847458 | 101 | 61 | 95.6 | 3 | 290 | 9 | 29 | 129 | XP_041456625.1 zinc finger HIT domain-containing protein 3-like [Lytechinus variegatus] | diamond | 1059 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus |
Advanced export
JSON shape: default, array, newline-delimited
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);;