contig_metadata
17 rows where bioproject = "PRJNA689790" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7047359 | 7047359 | PRJNA689790_S_NODE_6546_length_233_cov_1.790816_g6431_i0 | PRJNA689790 | 6546 | 233 | 1.790816 | 4.17260128 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 65.8 | 2.68e-6 | NTclustered | gi|1752396283|ref|XM_031000104.1| | 7668 | g6431 | i0 | 100 | 14.1502145922747 | 35 | 0 | 15 | 0 | 1 | 35 | 4457 | 4491 | PREDICTED: Strongylocentrotus purpuratus selenocysteine insertion sequence-binding protein 2-like (LOC584318), mRNA | blastn | 3297 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 9597264 | 9597264 | PRJNA689790_S_NODE_1708_length_505_cov_5.115385_g1599_i0 | PRJNA689790 | 1708 | 505 | 5.115385 | 25.83269425 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 115 | 1.04e-28 | NR | XP_797226.3 | 7668 | g1599 | i0 | 41.8 | 3.47524752475248 | 146 | 83 | 86.7 | 1 | 505 | 68 | 60 | 203 | XP_797226.3 heme-binding protein 2 [Strongylocentrotus purpuratus] | diamond | 1755 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 18520830 | 18520830 | PRJNA689790_S_NODE_8255_length_205_cov_3.202381_g8140_i0 | PRJNA689790 | 8255 | 205 | 3.202381 | 6.56488105 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 134 | 6.2100000000000006e-27 | NTclustered | gi|1944901330|ref|XM_038207541.1| | 46514 | g8140 | i0 | 80.214 | 0.91219512195122 | 187 | 29 | 89 | 7 | 14 | 196 | 691 | 509 | PREDICTED: Patiria miniata 60S ribosomal protein L5-like (LOC119734187), mRNA | blastn | 187 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 19029821 | 19029821 | PRJNA689790_S_NODE_8775_length_199_cov_2.462963_g8660_i0 | PRJNA689790 | 8775 | 199 | 2.462963 | 4.90129637 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 196 | 7.539999999999999e-46 | NTclustered | gi|46909244|gb|AY580216.1| | 7632 | g8660 | i0 | 84.422 | 101.115577889447 | 199 | 31 | 100 | 0 | 1 | 199 | 775 | 577 | Eucidaris tribuloides ATP synthase beta subunit mRNA, partial cds | blastn | 20122 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Cidaroida | Cidaridae | Eucidaris | Eucidaris tribuloides | |
| 24894921 | 24894921 | PRJNA689790_S_NODE_1700_length_506_cov_4.347548_g1592_i0 | PRJNA689790 | 1700 | 506 | 4.347548 | 21.99859288 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 206 | 1.6700000000000001e-63 | NR | XP_033125693.1 | 1529436 | g1592 | i0 | 65.5 | 0.877470355731225 | 148 | 51 | 87.7 | 0 | 4 | 447 | 112 | 259 | XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica] | diamond | 444 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 24894962 | 24894962 | PRJNA689790_S_NODE_5540_length_255_cov_1.963303_g5425_i0 | PRJNA689790 | 5540 | 255 | 1.963303 | 5.00642265 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 123 | 1.68e-32 | NR | XP_033639471.1 | 7604 | g5425 | i0 | 69 | 1.97647058823529 | 84 | 26 | 98.8 | 0 | 253 | 2 | 102 | 185 | XP_033639471.1 isopentenyl-diphosphate Delta-isomerase 1-like [Asterias rubens] | diamond | 504 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 26840951 | 26840951 | PRJNA689790_S_NODE_9921_length_188_cov_1.503311_g9806_i0 | PRJNA689790 | 9921 | 188 | 1.503311 | 2.82622468 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 82.4 | 1.04e-18 | NR | XP_041472041.1 | 7654 | g9806 | i0 | 97.4 | 60.6382978723404 | 38 | 1 | 60.6 | 0 | 2 | 115 | 58 | 95 | XP_041472041.1 protein transport protein Sec61 subunit beta-like [Lytechinus variegatus] | diamond | 11400 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27441722 | 27441722 | PRJNA689790_S_NODE_11443_length_176_cov_1.244604_g11328_i0 | PRJNA689790 | 11443 | 176 | 1.244604 | 2.19050304 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 112 | 5.500000000000001e-30 | NR | XP_063955038.1 | 7653 | g11328 | i0 | 84.5 | 663.375 | 58 | 9 | 98.9 | 0 | 174 | 1 | 73 | 130 | XP_063955038.1 uncharacterized protein LOC135153974 [Lytechinus pictus] | diamond | 116754 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 28325418 | 28325418 | PRJNA689790_S_NODE_8026_length_208_cov_3.333333_g7911_i0 | PRJNA689790 | 8026 | 208 | 3.333333 | 6.93333264 | root | 1 | Root_unresolved | Root_unresolved | 105 | 1.69e-26 | NR | XP_033640423.1 | 7604 | g7911 | i0 | 75.4 | 42.7788461538462 | 69 | 17 | 99.5 | 0 | 208 | 2 | 7 | 75 | XP_033640423.1 60S ribosomal protein L19-like [Asterias rubens] | diamond | 8898 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28945802 | 28945802 | PRJNA689790_S_NODE_7768_length_212_cov_1.451429_g7653_i0 | PRJNA689790 | 7768 | 212 | 1.451429 | 3.07702948 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 73.2 | 3.2e-13 | NR | PIK51386.1 | 307972 | g7653 | i0 | 50.8 | 0.919811320754717 | 65 | 29 | 87.7 | 2 | 188 | 3 | 99 | 163 | PIK51386.1 hypothetical protein BSL78_11708 [Apostichopus japonicus] | diamond | 195 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 29493805 | 29493805 | PRJNA689790_S_NODE_8730_length_200_cov_1.435583_g8615_i0 | PRJNA689790 | 8730 | 200 | 1.435583 | 2.871166 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 112 | 4.75e-28 | NR | XP_041480745.1 | 7654 | g8615 | i0 | 71.2 | 29.7 | 66 | 19 | 99 | 0 | 199 | 2 | 19 | 84 | XP_041480745.1 Y-box factor homolog [Lytechinus variegatus] | diamond | 5940 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29872747 | 29872747 | PRJNA689790_S_NODE_15231_length_156_cov_1.310924_g15116_i0 | PRJNA689790 | 15231 | 156 | 1.310924 | 2.04504144 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 55.8 | 2.76e-7 | NR | XP_041469757.1 | 7654 | g15116 | i0 | 50 | 3.25 | 46 | 23 | 88.5 | 0 | 144 | 7 | 165 | 210 | XP_041469757.1 delta(14)-sterol reductase TM7SF2-like isoform X1 [Lytechinus variegatus] | diamond | 507 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30745869 | 30745869 | PRJNA689790_S_NODE_7034_length_223_cov_5.252688_g6919_i0 | PRJNA689790 | 7034 | 223 | 5.252688 | 11.71349424 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 58.2 | 1.04e-7 | NR | XP_033633035.1 | 7604 | g6919 | i0 | 42.4 | 0.79372197309417 | 59 | 33 | 79.4 | 1 | 209 | 33 | 728 | 785 | XP_033633035.1 uncharacterized protein LOC117294642 isoform X2 [Asterias rubens] | diamond | 177 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31630891 | 31630891 | PRJNA689790_S_NODE_10796_length_181_cov_1.333333_g10681_i0 | PRJNA689790 | 10796 | 181 | 1.333333 | 2.41333273 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 105 | 1.16e-24 | NR | KAJ8047953.1 | 206669 | g10681 | i0 | 80 | 13.7734806629834 | 60 | 12 | 99.4 | 0 | 180 | 1 | 19 | 78 | KAJ8047953.1 Dihydropyrimidinase-related protein 3 [Holothuria leucospilota] | diamond | 2493 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31737203 | 31737203 | PRJNA689790_S_NODE_4717_length_279_cov_2.119835_g4602_i0 | PRJNA689790 | 4717 | 279 | 2.119835 | 5.91433965 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 48.1 | 4.95e-5 | NR | XP_030837588.1 | 7668 | g4602 | i0 | 95.5 | 1.18279569892473 | 22 | 1 | 23.7 | 0 | 279 | 214 | 43 | 64 | XP_030837588.1 stress-associated endoplasmic reticulum protein 2-like [Strongylocentrotus purpuratus] | diamond | 330 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31990364 | 31990364 | PRJNA689790_S_NODE_12738_length_168_cov_1.190840_g12623_i0 | PRJNA689790 | 12738 | 168 | 1.19084 | 2.0006112 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 62.4 | 1.51e-9 | NR | XP_033630784.1 | 7604 | g12623 | i0 | 50.9 | 7.85714285714286 | 55 | 27 | 98.2 | 0 | 167 | 3 | 113 | 167 | XP_033630784.1 60S ribosomal protein L3-like [Asterias rubens] | diamond | 1320 | 62.8 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32232343 | 32232343 | PRJNA689790_S_NODE_7958_length_209_cov_4.337209_g7843_i0 | PRJNA689790 | 7958 | 209 | 4.337209 | 9.06476681 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 40.8 | 0.0348 | NR | KAJ8043773.1 | 206669 | g7843 | i0 | 55.6 | 0.516746411483254 | 36 | 16 | 51.7 | 0 | 203 | 96 | 64 | 99 | KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] | diamond | 108 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota |
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);;