contig_metadata
19 rows where bioproject = "PRJNA906294", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4715402 | 4715402 | PRJNA906294_P_NODE_170104_length_286_cov_1.427230_g165988_i0 | PRJNA906294 | 170104 | 286 | 1.42723 | 4.0818778 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 135 | 1.23e-37 | NR | XP_033627614.1 | 7604 | g165988 | i0 | 77.5 | 3.35664335664336 | 80 | 18 | 83.9 | 0 | 241 | 2 | 9 | 88 | XP_033627614.1 GTP-binding nuclear protein Ran-like [Asterias rubens] | diamond | 960 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 18741324 | 18741324 | PRJNA906294_P_NODE_86795_length_463_cov_1.066667_g82681_i0 | PRJNA906294 | 86795 | 463 | 1.066667 | 4.93866821 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|1944932961|ref|XM_038222080.1| | 46514 | g82681 | i0 | 96.97 | 3.07775377969762 | 33 | 1 | 7 | 0 | 66 | 98 | 5120 | 5088 | PREDICTED: Patiria miniata bromodomain and WD repeat-containing protein 3-like (LOC119745602), transcript variant X1, mRNA | blastn | 1425 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 21650887 | 21650887 | PRJNA906294_P_NODE_231617_length_241_cov_0.904762_g227501_i0 | PRJNA906294 | 231617 | 241 | 0.904762 | 2.18047642 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 159 | 1.24e-34 | NTclustered | gi|1944861957|ref|XM_038196751.1| | 46514 | g227501 | i0 | 80.184 | 22.9211618257261 | 217 | 39 | 89 | 4 | 26 | 240 | 1236 | 1022 | PREDICTED: Patiria miniata 26S proteasome regulatory subunit 6A-B (LOC119725354), mRNA | blastn | 5524 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27126237 | 27126237 | PRJNA906294_P_NODE_125482_length_352_cov_1.476703_g121366_i0 | PRJNA906294 | 125482 | 352 | 1.476703 | 5.19799456 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 154 | 9.959999999999997e-43 | NR | XP_033635157.1 | 7604 | g121366 | i0 | 58.3 | 36.0340909090909 | 115 | 48 | 98 | 0 | 3 | 347 | 235 | 349 | XP_033635157.1 pyruvate dehydrogenase E1 component subunit alpha, mitochondrial-like [Asterias rubens] | diamond | 12684 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27221241 | 27221241 | PRJNA906294_P_NODE_220382_length_245_cov_0.877907_g216266_i0 | PRJNA906294 | 220382 | 245 | 0.877907 | 2.15087215 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 47.4 | 8.51e-4 | NR | XP_033636060.1 | 7604 | g216266 | i0 | 35 | 7.64081632653061 | 80 | 43 | 96.7 | 2 | 3 | 239 | 131 | 202 | XP_033636060.1 uncharacterized protein C11orf65 homolog isoform X3 [Asterias rubens] | diamond | 1872 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27435444 | 27435444 | PRJNA906294_P_NODE_208723_length_249_cov_0.863636_g204607_i0 | PRJNA906294 | 208723 | 249 | 0.863636 | 2.15045364 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 60.8 | 1.68e-8 | NR | XP_038070069.1 | 46514 | g204607 | i0 | 43 | 1.8433734939759 | 79 | 41 | 92.8 | 2 | 1 | 231 | 276 | 352 | XP_038070069.1 amine oxidase [flavin-containing] B-like [Patiria miniata] | diamond | 459 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27782630 | 27782630 | PRJNA906294_P_NODE_219264_length_245_cov_0.883721_g215148_i0 | PRJNA906294 | 219264 | 245 | 0.883721 | 2.16511645 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 78.2 | 1.24e-14 | NR | KAJ8027203.1 | 206669 | g215148 | i0 | 50 | 0.955102040816327 | 78 | 35 | 95.5 | 2 | 10 | 243 | 13 | 86 | KAJ8027203.1 hypothetical protein HOLleu_32278 [Holothuria leucospilota] | diamond | 234 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27971889 | 27971889 | PRJNA906294_P_NODE_180525_length_275_cov_1.128713_g176409_i0 | PRJNA906294 | 180525 | 275 | 1.128713 | 3.10396075 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 129 | 1.4799999999999998e-32 | NR | XP_038062242.1 | 46514 | g176409 | i0 | 66.7 | 8.85818181818182 | 90 | 28 | 98.2 | 1 | 271 | 2 | 139 | 226 | XP_038062242.1 fumarate hydratase class I, aerobic-like [Patiria miniata] | diamond | 2436 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28484678 | 28484678 | PRJNA906294_P_NODE_233726_length_230_cov_3.643312_g229610_i0 | PRJNA906294 | 233726 | 230 | 3.643312 | 8.3796176 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 126 | 7.29e-32 | NR | XP_033638734.1 | 7604 | g229610 | i0 | 76.3 | 7.9304347826087 | 76 | 18 | 99.1 | 0 | 3 | 230 | 420 | 495 | XP_033638734.1 inositol-3-phosphate synthase-like [Asterias rubens] | diamond | 1824 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28761217 | 28761217 | PRJNA906294_P_NODE_83507_length_477_cov_1.141089_g79393_i0 | PRJNA906294 | 83507 | 477 | 1.141089 | 5.44299453 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 48.1 | 0.00524 | NR | XP_022094674.1 | 133434 | g79393 | i0 | 32.3 | 0.79874213836478 | 127 | 72 | 79.2 | 5 | 386 | 9 | 193 | 306 | XP_022094674.1 uncharacterized secreted protein ARB_06907-like [Acanthaster planci] | diamond | 381 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 29211010 | 29211010 | PRJNA906294_P_NODE_193369_length_262_cov_1.185185_g189253_i0 | PRJNA906294 | 193369 | 262 | 1.185185 | 3.1051847 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 43.5 | 0.025 | NR | PIK57589.1 | 307972 | g189253 | i0 | 43.4 | 2.43893129770992 | 53 | 28 | 60.7 | 1 | 168 | 10 | 306 | 356 | PIK57589.1 hypothetical protein BSL78_05497 [Apostichopus japonicus] | diamond | 639 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 29455514 | 29455514 | PRJNA906294_P_NODE_122530_length_358_cov_1.564912_g118414_i0 | PRJNA906294 | 122530 | 358 | 1.564912 | 5.60238496 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 84.7 | 2.63e-16 | NR | XP_033629083.1 | 7604 | g118414 | i0 | 51.9 | 1.49162011173184 | 104 | 39 | 83.8 | 3 | 351 | 52 | 354 | 450 | XP_033629083.1 nucleolar protein 58-like [Asterias rubens] | diamond | 534 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30031940 | 30031940 | PRJNA906294_P_NODE_159711_length_298_cov_2.933333_g155595_i0 | PRJNA906294 | 159711 | 298 | 2.933333 | 8.74133234 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.7 | 0.014 | NR | XP_041460009.1 | 7654 | g155595 | i0 | 38.1 | 1.08724832214765 | 63 | 32 | 63.4 | 2 | 195 | 7 | 14 | 69 | XP_041460009.1 UDP-xylose and UDP-N-acetylglucosamine transporter-like [Lytechinus variegatus] | diamond | 324 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30182294 | 30182294 | PRJNA906294_P_NODE_57132_length_638_cov_1.371681_g53085_i0 | PRJNA906294 | 57132 | 638 | 1.371681 | 8.75132478 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 59.3 | 2.81e-6 | NR | XP_038057864.1 | 46514 | g53085 | i0 | 28.2 | 0.851097178683386 | 181 | 81 | 84.6 | 6 | 20 | 559 | 930 | 1062 | XP_038057864.1 sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like isoform X2 [Patiria miniata] | diamond | 543 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30277486 | 30277486 | PRJNA906294_P_NODE_220412_length_245_cov_0.866279_g216296_i0 | PRJNA906294 | 220412 | 245 | 0.866279 | 2.12238355 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 45.1 | 0.0056 | NR | XP_038054686.1 | 46514 | g216296 | i0 | 56.1 | 0.991836734693878 | 41 | 18 | 50.2 | 0 | 243 | 121 | 329 | 369 | XP_038054686.1 uncharacterized protein LOC119726906 [Patiria miniata] | diamond | 243 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31770174 | 31770174 | PRJNA906294_P_NODE_174557_length_281_cov_1.461538_g170441_i0 | PRJNA906294 | 174557 | 281 | 1.461538 | 4.10692178 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 139 | 7.88e-37 | NR | XP_041460907.1 | 7654 | g170441 | i0 | 68.8 | 8.93594306049822 | 93 | 29 | 99.3 | 0 | 1 | 279 | 43 | 135 | XP_041460907.1 tubulin beta chain-like [Lytechinus variegatus] | diamond | 2511 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31984082 | 31984082 | PRJNA906294_P_NODE_96278_length_427_cov_9.409605_g92163_i0 | PRJNA906294 | 96278 | 427 | 9.4096050000000009 | 40.17901335 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 109 | 3.7e-26 | NR | XP_030850438.1 | 7668 | g92163 | i0 | 45.8 | 1.66510538641686 | 118 | 63 | 82.2 | 1 | 424 | 74 | 141 | 258 | XP_030850438.1 40S ribosomal protein S4 [Strongylocentrotus purpuratus] | diamond | 711 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32805551 | 32805551 | PRJNA906294_P_NODE_104200_length_403_cov_1.239394_g100085_i0 | PRJNA906294 | 104200 | 403 | 1.239394 | 4.99475782 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 122 | 9.469999999999999e-32 | NR | XP_022090274.1 | 133434 | g100085 | i0 | 43.5 | 2.0545905707196 | 138 | 74 | 99.8 | 2 | 402 | 1 | 38 | 175 | XP_022090274.1 ribonuclease Oy-like isoform X2 [Acanthaster planci] | diamond | 828 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32868581 | 32868581 | PRJNA906294_P_NODE_225160_length_243_cov_0.894118_g221044_i0 | PRJNA906294 | 225160 | 243 | 0.894118 | 2.17270674 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 58.9 | 7.29e-8 | NR | PIK57828.1 | 307972 | g221044 | i0 | 39.5 | 1 | 81 | 44 | 97.5 | 2 | 5 | 241 | 688 | 765 | PIK57828.1 putative PAX-interacting protein 1 [Apostichopus japonicus] | diamond | 243 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus |
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);;