contig_metadata
14 rows where bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12124042 | 12124042 | PRJNA674308_P_NODE_32250_length_178_cov_1.612403_g32015_i0 | PRJNA674308 | 32250 | 178 | 1.612403 | 2.87007734 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 96.7 | 1.07e-21 | NR | XP_071491403.1 | 105358 | g32015 | i0 | 74.6 | 0.99438202247191 | 59 | 15 | 99.4 | 0 | 1 | 177 | 275 | 333 | XP_071491403.1 rab GDP dissociation inhibitor beta-like [Diadema antillarum] | diamond | 177 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 26618864 | 26618864 | PRJNA674308_P_NODE_33821_length_174_cov_1.640000_g33586_i0 | PRJNA674308 | 33821 | 174 | 1.64 | 2.8536 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.9 | 2.96e-8 | NR | XP_038060559.1 | 46514 | g33586 | i0 | 39.7 | 4 | 58 | 34 | 100 | 1 | 174 | 1 | 1396 | 1452 | XP_038060559.1 uncharacterized protein LOC119731463 isoform X1 [Patiria miniata] | diamond | 696 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27409970 | 27409970 | PRJNA674308_P_NODE_1003_length_1003_cov_3.920335_g855_i0 | PRJNA674308 | 1003 | 1003 | 3.920335 | 39.32096005 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 187 | 4.94e-53 | NR | XP_041457912.1 | 7654 | g855 | i0 | 39.2 | 5.21335992023928 | 250 | 136 | 72.4 | 6 | 146 | 871 | 37 | 278 | XP_041457912.1 uncharacterized protein LOC121410105 [Lytechinus variegatus] | diamond | 5229 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28420322 | 28420322 | PRJNA674308_P_NODE_53946_length_162_cov_0.920354_g53711_i0 | PRJNA674308 | 53946 | 162 | 0.920354 | 1.49097348 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 59.7 | 1.32e-8 | NR | XP_041469757.1 | 7654 | g53711 | i0 | 45.1 | 2.83333333333333 | 51 | 25 | 88.9 | 1 | 4 | 147 | 178 | 228 | XP_041469757.1 delta(14)-sterol reductase TM7SF2-like isoform X1 [Lytechinus variegatus] | diamond | 459 | 60.1 | 0.993344425956739 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28502968 | 28502968 | PRJNA674308_P_NODE_227_length_1837_cov_2.865213_g179_i0 | PRJNA674308 | 227 | 1837 | 2.865213 | 52.63396281 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 180 | 3.2e-45 | NR | XP_038074569.1 | 46514 | g179 | i0 | 28.5 | 1.72945019052803 | 527 | 275 | 84.3 | 17 | 1577 | 30 | 32 | 467 | XP_038074569.1 dye-decolorizing peroxidase msp1-like [Patiria miniata] | diamond | 3177 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28514892 | 28514892 | PRJNA674308_P_NODE_16567_length_238_cov_2.153439_g16332_i0 | PRJNA674308 | 16567 | 238 | 2.153439 | 5.12518482 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 95.9 | 7.02e-21 | NR | XP_041472457.1 | 7654 | g16332 | i0 | 52.6 | 14.7478991596639 | 78 | 37 | 98.3 | 0 | 5 | 238 | 325 | 402 | XP_041472457.1 AP-2 complex subunit alpha-2-like isoform X4 [Lytechinus variegatus] | diamond | 3510 | 96.7 | 0.991726990692865 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29651085 | 29651085 | PRJNA674308_P_NODE_10730_length_292_cov_0.847737_g10495_i0 | PRJNA674308 | 10730 | 292 | 0.847737 | 2.47539204 | root | 1 | Root_unresolved | Root_unresolved | 64.7 | 1.15e-9 | NR | XP_011664132.1 | 7668 | g10495 | i0 | 38.6 | 9.01027397260274 | 101 | 56 | 99.7 | 4 | 291 | 1 | 79 | 177 | XP_011664132.1 short-chain dehydrogenase TIC 32, chloroplastic [Strongylocentrotus purpuratus] | diamond | 2631 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30871618 | 30871618 | PRJNA674308_P_NODE_20494_length_218_cov_0.899408_g20259_i0 | PRJNA674308 | 20494 | 218 | 0.899408 | 1.96070944 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 45.8 | 0.00221 | NR | XP_071491518.1 | 105358 | g20259 | i0 | 39.6 | 0.729357798165138 | 53 | 31 | 72.9 | 1 | 161 | 3 | 454 | 505 | XP_071491518.1 uncharacterized protein [Diadema antillarum] | diamond | 159 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31092846 | 31092846 | PRJNA674308_P_NODE_1835_length_740_cov_4.622287_g1629_i0 | PRJNA674308 | 1835 | 740 | 4.622287 | 34.2049238 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 49.7 | 0.00508 | NR | XP_041457912.1 | 7654 | g1629 | i0 | 34.8 | 0.372972972972973 | 92 | 57 | 37.3 | 3 | 11 | 286 | 210 | 298 | XP_041457912.1 uncharacterized protein LOC121410105 [Lytechinus variegatus] | diamond | 276 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31262765 | 31262765 | PRJNA674308_P_NODE_18515_length_227_cov_1.752809_g18280_i0 | PRJNA674308 | 18515 | 227 | 1.752809 | 3.97887643 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 79.3 | 2.65e-15 | NR | XP_030835141.1 | 7668 | g18280 | i0 | 54.7 | 4.95594713656388 | 75 | 34 | 99.1 | 0 | 225 | 1 | 244 | 318 | XP_030835141.1 ATPase family AAA domain-containing protein 1 [Strongylocentrotus purpuratus] | diamond | 1125 | 80.1 | 0.990012484394507 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31598987 | 31598987 | PRJNA674308_P_NODE_39736_length_168_cov_0.873950_g39501_i0 | PRJNA674308 | 39736 | 168 | 0.87395 | 1.468236 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 45.1 | 0.00165 | NR | XP_041485914.1 | 7654 | g39501 | i0 | 46 | 0.892857142857143 | 50 | 20 | 89.3 | 1 | 163 | 14 | 19 | 61 | XP_041485914.1 S-crystallin SL11-like [Lytechinus variegatus] | diamond | 150 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31725215 | 31725215 | PRJNA674308_P_NODE_4077_length_475_cov_1.624413_g3843_i0 | PRJNA674308 | 4077 | 475 | 1.624413 | 7.71596175 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 64.3 | 1.09e-8 | NR | XP_022106438.1 | 133434 | g3843 | i0 | 38.4 | 1.15578947368421 | 73 | 37 | 46.1 | 2 | 257 | 475 | 67 | 131 | XP_022106438.1 uncharacterized protein LOC110987731 [Acanthaster planci] | diamond | 549 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32496704 | 32496704 | PRJNA674308_P_NODE_15499_length_246_cov_1.055838_g15264_i0 | PRJNA674308 | 15499 | 246 | 1.055838 | 2.59736148 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 48.1 | 4.99e-4 | NR | XP_033624518.1 | 7604 | g15264 | i0 | 36.2 | 3.64634146341463 | 58 | 34 | 70.7 | 1 | 174 | 1 | 236 | 290 | XP_033624518.1 ras guanyl-releasing protein 3-like [Asterias rubens] | diamond | 897 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32642169 | 32642169 | PRJNA674308_P_NODE_1680_length_776_cov_2.496561_g1480_i0 | PRJNA674308 | 1680 | 776 | 2.496561 | 19.37331336 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 64.3 | 6.94e-8 | NR | XP_003731874.2 | 7668 | g1480 | i0 | 26.8 | 0.80798969072165 | 209 | 108 | 79.3 | 7 | 153 | 767 | 41 | 208 | XP_003731874.2 uncharacterized protein LOC100893574 [Strongylocentrotus purpuratus] | diamond | 627 | 64.3 | 1 | 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);;