contig_metadata
27 rows where bioproject = "PRJEB7366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 995548 | 995548 | PRJEB7366_P_NODE_4521_length_434_cov_1.704261_g4091_i0 | PRJEB7366 | 4521 | 434 | 1.704261 | 7.39649274 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 178 | 6.6299999999999996e-40 | NTclustered | gi|1752399365|ref|XM_011667624.2| | 7668 | g4091 | i0 | 83.077 | 51.6382488479263 | 195 | 33 | 45 | 0 | 49 | 243 | 583 | 389 | PREDICTED: Strongylocentrotus purpuratus ATP synthase F(0) complex subunit C2, mitochondrial (LOC583818), mRNA | blastn | 22411 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 3961388 | 3961388 | PRJEB7366_P_NODE_6224_length_354_cov_3.692790_g5791_i0 | PRJEB7366 | 6224 | 354 | 3.69279 | 13.0724766 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 80.5 | 2.05e-15 | NR | XP_054768604.2 | 7653 | g5791 | i0 | 36.4 | 3.77118644067797 | 118 | 72 | 100 | 2 | 1 | 354 | 127 | 241 | XP_054768604.2 trypsin-like [Lytechinus pictus] | diamond | 1335 | 80.9 | 0.995055624227441 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 10338265 | 10338265 | PRJEB7366_P_NODE_10009_length_262_cov_1.585903_g9575_i0 | PRJEB7366 | 10009 | 262 | 1.585903 | 4.15506586 | Apostichopus parvimensis | 1902835 | Echinodermata | other_Eukaryota | 84 | 1.48e-16 | NR | WAS27823.1 | 1902835 | g9575 | i0 | 44.6 | 0.950381679389313 | 83 | 39 | 93.9 | 3 | 262 | 17 | 342 | 418 | WAS27823.1 putative Dbh [Apostichopus parvimensis] | diamond | 249 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus parvimensis | |
| 15437734 | 15437734 | PRJEB7366_P_NODE_18513_length_178_cov_1.286713_g18079_i0 | PRJEB7366 | 18513 | 178 | 1.286713 | 2.29034914 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 122 | 1.93e-30 | NR | XP_038049607.1 | 46514 | g18079 | i0 | 94.9 | 42.7584269662921 | 59 | 3 | 99.4 | 0 | 177 | 1 | 456 | 514 | XP_038049607.1 transitional endoplasmic reticulum ATPase [Patiria miniata] | diamond | 7611 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26615231 | 26615231 | PRJEB7366_P_NODE_1921_length_707_cov_3.022321_g1576_i0 | PRJEB7366 | 1921 | 707 | 3.022321 | 21.36780947 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 100 | 4.24e-20 | NR | XP_030840786.1 | 7668 | g1576 | i0 | 38.6 | 2.78359264497878 | 207 | 86 | 80.6 | 12 | 628 | 59 | 455 | 637 | XP_030840786.1 uncharacterized protein LOC576169 [Strongylocentrotus purpuratus] | diamond | 1968 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 26622516 | 26622516 | PRJEB7366_P_NODE_16041_length_194_cov_1.660377_g15607_i0 | PRJEB7366 | 16041 | 194 | 1.660377 | 3.22113138 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 49.3 | 8.08e-5 | NR | XP_033126943.1 | 1529436 | g15607 | i0 | 39.3 | 1.79381443298969 | 61 | 35 | 91.2 | 1 | 184 | 8 | 67 | 127 | XP_033126943.1 protein mesh-like, partial [Anneissia japonica] | diamond | 348 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26773777 | 26773777 | PRJEB7366_P_NODE_15541_length_198_cov_1.030675_g15107_i0 | PRJEB7366 | 15541 | 198 | 1.030675 | 2.0407365 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 43.9 | 0.00827 | NR | XP_041473485.1 | 7654 | g15107 | i0 | 44.6 | 2.6969696969697 | 56 | 29 | 81.8 | 1 | 37 | 198 | 430 | 485 | XP_041473485.1 UPF0394 inner membrane protein YeeE-like [Lytechinus variegatus] | diamond | 534 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27350474 | 27350474 | PRJEB7366_P_NODE_16383_length_192_cov_1.019108_g15949_i0 | PRJEB7366 | 16383 | 192 | 1.019108 | 1.95668736 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 59.3 | 2.79e-8 | NR | XP_022099353.1 | 133434 | g15949 | i0 | 48.4 | 13.9375 | 64 | 33 | 100 | 0 | 192 | 1 | 589 | 652 | XP_022099353.1 peregrin-like isoform X3 [Acanthaster planci] | diamond | 2676 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27350481 | 27350481 | PRJEB7366_P_NODE_24883_length_150_cov_1.043478_g24449_i0 | PRJEB7366 | 24883 | 150 | 1.043478 | 1.565217 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 56.6 | 1.3e-7 | NR | XP_063961316.1 | 7653 | g24449 | i0 | 54.2 | 29.5 | 59 | 13 | 90 | 3 | 148 | 14 | 254 | 312 | XP_063961316.1 uncharacterized protein LOC129269699 isoform X13 [Lytechinus pictus] | diamond | 4425 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 27697950 | 27697950 | PRJEB7366_P_NODE_7884_length_306_cov_2.239852_g7450_i0 | PRJEB7366 | 7884 | 306 | 2.239852 | 6.85394712 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52 | 1.58e-5 | NR | XP_033098466.1 | 1529436 | g7450 | i0 | 32.3 | 1.88235294117647 | 96 | 38 | 94.1 | 2 | 288 | 1 | 9 | 77 | XP_033098466.1 fibropellin-1-like, partial [Anneissia japonica] | diamond | 576 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28044820 | 28044820 | PRJEB7366_P_NODE_18365_length_179_cov_1.111111_g17931_i0 | PRJEB7366 | 18365 | 179 | 1.111111 | 1.98888869 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 60.5 | 8.88e-9 | NR | XP_033105774.1 | 1529436 | g17931 | i0 | 54.9 | 0.854748603351955 | 51 | 23 | 85.5 | 0 | 16 | 168 | 3940 | 3990 | XP_033105774.1 uncharacterized protein LOC117108037 [Anneissia japonica] | diamond | 153 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28328958 | 28328958 | PRJEB7366_P_NODE_24166_length_152_cov_2.051282_g23732_i0 | PRJEB7366 | 24166 | 152 | 2.051282 | 3.11794864 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 43.5 | 0.00583 | NR | XP_041455749.1 | 7654 | g23732 | i0 | 50 | 7.18421052631579 | 36 | 18 | 71.1 | 0 | 143 | 36 | 181 | 216 | XP_041455749.1 fibrillin-1-like isoform X1 [Lytechinus variegatus] | diamond | 1092 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28581786 | 28581786 | PRJEB7366_P_NODE_12227_length_231_cov_1.076531_g11793_i0 | PRJEB7366 | 12227 | 231 | 1.076531 | 2.48678661 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 63.9 | 1.05e-9 | NR | XP_030846503.1 | 7668 | g11793 | i0 | 46.8 | 1 | 77 | 39 | 98.7 | 2 | 2 | 229 | 318 | 393 | XP_030846503.1 periodic tryptophan protein 1 homolog [Strongylocentrotus purpuratus] | diamond | 231 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30027071 | 30027071 | PRJEB7366_P_NODE_8411_length_293_cov_1.984496_g7977_i0 | PRJEB7366 | 8411 | 293 | 1.984496 | 5.81457328 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 83.6 | 5.6e-17 | NR | XP_033627836.1 | 7604 | g7977 | i0 | 55.3 | 5.76450511945392 | 85 | 36 | 87 | 1 | 1 | 255 | 179 | 261 | XP_033627836.1 3-oxoacyl-[acyl-carrier-protein] reductase FabG-like [Asterias rubens] | diamond | 1689 | 84.3 | 0.991696322657177 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30287329 | 30287329 | PRJEB7366_P_NODE_23532_length_155_cov_1.000000_g23098_i0 | PRJEB7366 | 23532 | 155 | 1 | 1.55 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 73.6 | 1.51e-13 | NR | XP_022096918.1 | 133434 | g23098 | i0 | 59.6 | 4.76129032258065 | 57 | 17 | 98.7 | 2 | 154 | 2 | 2731 | 2787 | XP_022096918.1 uncharacterized protein LOC110982623 isoform X7 [Acanthaster planci] | diamond | 738 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30879960 | 30879960 | PRJEB7366_P_NODE_11454_length_241_cov_1.165049_g11020_i0 | PRJEB7366 | 11454 | 241 | 1.165049 | 2.80776809 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 84 | 1.08e-16 | NR | XP_041481214.1 | 7654 | g11020 | i0 | 53.2 | 3.93360995850622 | 79 | 37 | 98.3 | 0 | 239 | 3 | 463 | 541 | XP_041481214.1 carnitine O-acetyltransferase-like isoform X2 [Lytechinus variegatus] | diamond | 948 | 84.7 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30887240 | 30887240 | PRJEB7366_P_NODE_18494_length_178_cov_1.398601_g18060_i0 | PRJEB7366 | 18494 | 178 | 1.398601 | 2.48950978 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 91.7 | 9.9e-21 | NR | XP_033635647.1 | 7604 | g18060 | i0 | 67.8 | 8.94943820224719 | 59 | 19 | 99.4 | 0 | 178 | 2 | 93 | 151 | XP_033635647.1 40S ribosomal protein S4, X isoform-like isoform X2 [Asterias rubens] | diamond | 1593 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31202715 | 31202715 | PRJEB7366_P_NODE_8995_length_281_cov_2.414634_g8561_i0 | PRJEB7366 | 8995 | 281 | 2.414634 | 6.78512154 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 85.1 | 4.67e-17 | NR | XP_038075774.1 | 46514 | g8561 | i0 | 46.3 | 0.854092526690391 | 80 | 42 | 84.3 | 1 | 41 | 277 | 260 | 339 | XP_038075774.1 LOW QUALITY PROTEIN: aspartic proteinase A2-like [Patiria miniata] | diamond | 240 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31227444 | 31227444 | PRJEB7366_P_NODE_10135_length_260_cov_1.777778_g9701_i0 | PRJEB7366 | 10135 | 260 | 1.777778 | 4.6222228 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 55.8 | 1.06e-6 | NR | KAJ8049385.1 | 206669 | g9701 | i0 | 34.8 | 1.55769230769231 | 66 | 43 | 76.2 | 0 | 226 | 29 | 314 | 379 | KAJ8049385.1 hypothetical protein HOLleu_02116 [Holothuria leucospilota] | diamond | 405 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31329648 | 31329648 | PRJEB7366_P_NODE_2156_length_663_cov_2.253185_g1795_i0 | PRJEB7366 | 2156 | 663 | 2.253185 | 14.93861655 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 48.5 | 0.0124 | NR | KAJ8044363.1 | 206669 | g1795 | i0 | 34.7 | 0.221719457013575 | 49 | 32 | 22.2 | 0 | 296 | 150 | 304 | 352 | KAJ8044363.1 Galaxin [Holothuria leucospilota] | diamond | 147 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31488083 | 31488083 | PRJEB7366_P_NODE_24276_length_152_cov_1.367521_g23842_i0 | PRJEB7366 | 24276 | 152 | 1.367521 | 2.07863192 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 94.4 | 7.06e-21 | NR | XP_022104771.1 | 133434 | g23842 | i0 | 84 | 4.875 | 50 | 8 | 98.7 | 0 | 151 | 2 | 628 | 677 | XP_022104771.1 2-oxoglutarate dehydrogenase, mitochondrial-like isoform X3 [Acanthaster planci] | diamond | 741 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32152192 | 32152192 | PRJEB7366_P_NODE_20718_length_167_cov_0.878788_g20284_i0 | PRJEB7366 | 20718 | 167 | 0.878788 | 1.46757596 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 48.1 | 1.66e-4 | NR | XP_022103352.1 | 133434 | g20284 | i0 | 46.3 | 1.95808383233533 | 54 | 27 | 97 | 1 | 4 | 165 | 428 | 479 | XP_022103352.1 eukaryotic peptide chain release factor GTP-binding subunit ERF3A-like [Acanthaster planci] | diamond | 327 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32208289 | 32208289 | PRJEB7366_P_NODE_7158_length_325_cov_1.989655_g6724_i0 | PRJEB7366 | 7158 | 325 | 1.989655 | 6.46637875 | root | 1 | Root_unresolved | Root_unresolved | 60.1 | 8.29e-8 | NR | XP_038049618.1 | 46514 | g6724 | i0 | 51 | 0.941538461538462 | 49 | 24 | 45.2 | 0 | 3 | 149 | 7079 | 7127 | XP_038049618.1 uncharacterized protein LOC119723141 [Patiria miniata] | diamond | 306 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32366640 | 32366640 | PRJEB7366_P_NODE_13239_length_219_cov_1.521739_g12805_i0 | PRJEB7366 | 13239 | 219 | 1.521739 | 3.33260841 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 84.7 | 3.61e-17 | NR | XP_063953235.1 | 7653 | g12805 | i0 | 61.4 | 3.9041095890411 | 57 | 22 | 78.1 | 0 | 217 | 47 | 379 | 435 | XP_063953235.1 aminoacylase-1-like isoform X1 [Lytechinus pictus] | diamond | 855 | 85.5 | 0.990643274853801 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 32588020 | 32588020 | PRJEB7366_P_NODE_18019_length_181_cov_1.027397_g17585_i0 | PRJEB7366 | 18019 | 181 | 1.027397 | 1.85958857 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 59.3 | 2.31e-8 | NR | XP_041470552.1 | 7654 | g17585 | i0 | 64.4 | 5.12154696132597 | 45 | 16 | 74.6 | 0 | 47 | 181 | 4 | 48 | XP_041470552.1 protein disulfide-isomerase A6 homolog [Lytechinus variegatus] | diamond | 927 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32682033 | 32682033 | PRJEB7366_P_NODE_21880_length_161_cov_1.904762_g21446_i0 | PRJEB7366 | 21880 | 161 | 1.904762 | 3.06666682 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 43.1 | 0.00907 | NR | XP_041460582.1 | 7654 | g21446 | i0 | 47.2 | 11.5900621118012 | 53 | 26 | 98.8 | 1 | 159 | 1 | 379 | 429 | XP_041460582.1 extended synaptotagmin-2-like [Lytechinus variegatus] | diamond | 1866 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32745348 | 32745348 | PRJEB7366_P_NODE_18820_length_176_cov_1.702128_g18386_i0 | PRJEB7366 | 18820 | 176 | 1.702128 | 2.99574528 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 49.3 | 7.26e-5 | NR | XP_030855152.1 | 7668 | g18386 | i0 | 52.3 | 3.95454545454545 | 44 | 21 | 75 | 0 | 3 | 134 | 295 | 338 | XP_030855152.1 arginase-1 [Strongylocentrotus purpuratus] | diamond | 696 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus |
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);;