contig_metadata
13 rows where bioproject = "PRJNA949785", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20059904 | 20059904 | PRJNA949785_P_NODE_4316_length_550_cov_2.100629_g4121_i0 | PRJNA949785 | 4316 | 550 | 2.100629 | 11.5534595 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 137 | 2.45e-34 | NR | XP_033096287.1 | 1529436 | g4121 | i0 | 46.6 | 5.70545454545455 | 148 | 79 | 80.7 | 0 | 106 | 549 | 40 | 187 | XP_033096287.1 3-phosphoinositide-dependent protein kinase 1-like isoform X2 [Anneissia japonica] | diamond | 3138 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27373495 | 27373495 | PRJNA949785_P_NODE_17763_length_244_cov_1.625731_g17566_i0 | PRJNA949785 | 17763 | 244 | 1.625731 | 3.96678364 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 77.8 | 1.68e-14 | NR | XP_071490613.1 | 105358 | g17566 | i0 | 42.9 | 1.89344262295082 | 77 | 44 | 94.7 | 0 | 232 | 2 | 193 | 269 | XP_071490613.1 tyrosine-protein kinase yes-like [Diadema antillarum] | diamond | 462 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27721022 | 27721022 | PRJNA949785_P_NODE_5124_length_498_cov_1.247059_g4927_i0 | PRJNA949785 | 5124 | 498 | 1.247059 | 6.21035382 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 91.3 | 7.18e-18 | NR | XP_038049599.1 | 46514 | g4927 | i0 | 33.3 | 2.71084337349398 | 150 | 98 | 89.8 | 2 | 1 | 447 | 14 | 162 | XP_038049599.1 transportin-1-like isoform X1 [Patiria miniata] | diamond | 1350 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27783877 | 27783877 | PRJNA949785_P_NODE_18884_length_241_cov_1.136905_g18687_i0 | PRJNA949785 | 18884 | 241 | 1.136905 | 2.73994105 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 74.7 | 1.89e-13 | NR | KAJ8023417.1 | 206669 | g18687 | i0 | 55.1 | 3.69709543568465 | 69 | 31 | 85.9 | 0 | 240 | 34 | 257 | 325 | KAJ8023417.1 O-phosphoseryl-tRNA(Sec) selenium transferase [Holothuria leucospilota] | diamond | 891 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28383571 | 28383571 | PRJNA949785_P_NODE_2066_length_823_cov_2.112000_g1907_i0 | PRJNA949785 | 2066 | 823 | 2.112 | 17.38176 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 162 | 1.2499999999999996e-43 | NR | PIK33849.1 | 307972 | g1907 | i0 | 32.3 | 1.87363304981774 | 257 | 164 | 93.3 | 2 | 768 | 1 | 59 | 306 | PIK33849.1 putative differentially expressed in FDCP 8-like [Apostichopus japonicus] | diamond | 1542 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 28390140 | 28390140 | PRJNA949785_P_NODE_7486_length_394_cov_1.190031_g7289_i0 | PRJNA949785 | 7486 | 394 | 1.190031 | 4.68872214 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 95.5 | 1.25e-20 | NR | XP_030846403.1 | 7668 | g7289 | i0 | 44.9 | 3.33502538071066 | 107 | 58 | 80.7 | 1 | 77 | 394 | 29 | 135 | XP_030846403.1 CCR4-NOT transcription complex subunit 9 [Strongylocentrotus purpuratus] | diamond | 1314 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28674427 | 28674427 | PRJNA949785_P_NODE_6447_length_431_cov_3.441341_g6250_i0 | PRJNA949785 | 6447 | 431 | 3.441341 | 14.83217971 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 104 | 1.45e-25 | NR | XP_041481392.1 | 7654 | g6250 | i0 | 43 | 3.87006960556845 | 142 | 76 | 95.4 | 3 | 431 | 21 | 4 | 145 | XP_041481392.1 endothelial differentiation-related factor 1-like [Lytechinus variegatus] | diamond | 1668 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28768979 | 28768979 | PRJNA949785_P_NODE_1847_length_874_cov_9.094881_g1697_i0 | PRJNA949785 | 1847 | 874 | 9.094881 | 79.48925994 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 110 | 1.6000000000000002e-23 | NR | XP_033644141.1 | 7604 | g1697 | i0 | 32.9 | 2.51945080091533 | 243 | 153 | 80.3 | 6 | 20 | 721 | 187 | 428 | XP_033644141.1 tetraspanin-5-like [Asterias rubens] | diamond | 2202 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 29173119 | 29173119 | PRJNA949785_P_NODE_14069_length_267_cov_4.061856_g13872_i0 | PRJNA949785 | 14069 | 267 | 4.061856 | 10.84515552 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 129 | 3.08e-36 | NR | PIK39441.1 | 307972 | g13872 | i0 | 64.7 | 7.64044943820225 | 85 | 30 | 95.5 | 0 | 257 | 3 | 19 | 103 | PIK39441.1 putative DNA-directed RNA polymerase II subunit RPB9-like isoform X1 [Apostichopus japonicus] | diamond | 2040 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 29835949 | 29835949 | PRJNA949785_P_NODE_9671_length_335_cov_1.175573_g9474_i0 | PRJNA949785 | 9671 | 335 | 1.175573 | 3.93816955 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 65.1 | 1.63e-9 | NR | XP_022112058.1 | 133434 | g9474 | i0 | 32.7 | 9.51940298507463 | 101 | 68 | 90.4 | 0 | 333 | 31 | 873 | 973 | XP_022112058.1 vacuolar protein sorting-associated protein 8 homolog isoform X1 [Acanthaster planci] | diamond | 3189 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30405097 | 30405097 | PRJNA949785_P_NODE_18313_length_243_cov_0.905882_g18116_i0 | PRJNA949785 | 18313 | 243 | 0.905882 | 2.20129326 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 46.2 | 0.00225 | NR | XP_071506066.1 | 105358 | g18116 | i0 | 36.5 | 1.19753086419753 | 63 | 33 | 69.1 | 1 | 9 | 176 | 214 | 276 | XP_071506066.1 death-associated protein kinase 1-like [Diadema antillarum] | diamond | 291 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31415952 | 31415952 | PRJNA949785_P_NODE_12416_length_288_cov_2.716279_g12219_i0 | PRJNA949785 | 12416 | 288 | 2.716279 | 7.82288352 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 88.2 | 6.34e-18 | NR | XP_022106049.1 | 133434 | g12219 | i0 | 48.9 | 1.83333333333333 | 88 | 45 | 91.7 | 0 | 3 | 266 | 433 | 520 | XP_022106049.1 mitochondrial-processing peptidase subunit alpha-like [Acanthaster planci] | diamond | 528 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32907779 | 32907779 | PRJNA949785_P_NODE_1100_length_1115_cov_11.087332_g992_i0 | PRJNA949785 | 1100 | 1115 | 11.087332 | 123.6237518 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 196 | 8.12e-56 | NR | KAJ8036487.1 | 206669 | g992 | i0 | 35.9 | 4.2457399103139 | 323 | 193 | 83.4 | 6 | 1028 | 99 | 11 | 332 | KAJ8036487.1 Cathepsin L [Holothuria leucospilota] | diamond | 4734 | 196 | 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);;