contig_metadata
12 rows where bioproject = "PRJNA1214993", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6708070 | 6708070 | PRJNA1214993_P_NODE_13386_length_302_cov_1.139738_g13200_i0 | PRJNA1214993 | 13386 | 302 | 1.139738 | 3.44200876 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 167 | 9.619999999999998e-37 | NTclustered | gi|1752368967|ref|XM_030988646.1| | 7668 | g13200 | i0 | 77.228 | 63.8576158940397 | 303 | 57 | 98 | 10 | 6 | 302 | 335 | 631 | PREDICTED: Strongylocentrotus purpuratus 60S ribosomal protein L10a (LOC586056), transcript variant X1, mRNA | blastn | 19285 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 9973491 | 9973491 | PRJNA1214993_P_NODE_11328_length_327_cov_1.511811_g11142_i0 | PRJNA1214993 | 11328 | 327 | 1.511811 | 4.94362197 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 141 | 6.38e-29 | NTclustered | gi|2707407387|ref|XM_054893500.2| | 7653 | g11142 | i0 | 88.235 | 3.52293577981651 | 119 | 12 | 36 | 2 | 19 | 136 | 581 | 464 | PREDICTED: Lytechinus pictus serine/threonine-protein phosphatase 4 catalytic subunit (LOC129254953), mRNA | blastn | 1152 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 19456409 | 19456409 | PRJNA1214993_P_NODE_24376_length_245_cov_0.895349_g24190_i0 | PRJNA1214993 | 24376 | 245 | 0.895349 | 2.19360505 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 453 | 5.1900000000000006e-123 | NTclustered | gi|2656634086|gb|PP178709.1| | 307972 | g24190 | i0 | 100 | 60.3102040816327 | 245 | 0 | 100 | 0 | 1 | 245 | 9600 | 9356 | Apostichopus japonicus isolate FJPT mitochondrion, complete genome | blastn | 14776 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27452101 | 27452101 | PRJNA1214993_P_NODE_23523_length_246_cov_0.901734_g23337_i0 | PRJNA1214993 | 23523 | 246 | 0.901734 | 2.21826564 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 92.4 | 5.59e-22 | NR | PIK60842.1 | 307972 | g23337 | i0 | 61.4 | 7.31707317073171 | 83 | 29 | 97.6 | 1 | 1 | 240 | 25 | 107 | PIK60842.1 putative ras-related protein [Apostichopus japonicus] | diamond | 1800 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27597166 | 27597166 | PRJNA1214993_P_NODE_7964_length_384_cov_0.974277_g7778_i0 | PRJNA1214993 | 7964 | 384 | 0.974277 | 3.74122368 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 130 | 2.06e-33 | NR | KAJ8037066.1 | 206669 | g7778 | i0 | 58.1 | 7 | 105 | 44 | 82 | 0 | 384 | 70 | 266 | 370 | KAJ8037066.1 putative pyruvate dehydrogenase E1 component subunit alpha, mitochondrial [Holothuria leucospilota] | diamond | 2688 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27881135 | 27881135 | PRJNA1214993_P_NODE_25285_length_243_cov_0.917647_g25099_i0 | PRJNA1214993 | 25285 | 243 | 0.917647 | 2.22988221 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 103 | 1.58e-25 | NR | PIK36082.1 | 307972 | g25099 | i0 | 61.7 | 4.97530864197531 | 81 | 29 | 100 | 1 | 243 | 1 | 8 | 86 | PIK36082.1 putative endoplasmic reticulum resident protein 29-like, partial [Apostichopus japonicus] | diamond | 1209 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 28620292 | 28620292 | PRJNA1214993_P_NODE_26407_length_238_cov_2.163636_g26221_i0 | PRJNA1214993 | 26407 | 238 | 2.163636 | 5.14945368 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 75.1 | 6.98e-15 | NR | XP_001178621.1 | 7668 | g26221 | i0 | 52.2 | 0.84453781512605 | 67 | 32 | 84.5 | 0 | 4 | 204 | 57 | 123 | XP_001178621.1 prefoldin subunit 5 [Strongylocentrotus purpuratus] | diamond | 201 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29188681 | 29188681 | PRJNA1214993_P_NODE_26289_length_242_cov_0.911243_g26103_i0 | PRJNA1214993 | 26289 | 242 | 0.911243 | 2.20520806 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 110 | 4.23e-27 | NR | XP_033637698.1 | 7604 | g26103 | i0 | 64.5 | 5.52892561983471 | 76 | 27 | 94.2 | 0 | 13 | 240 | 1 | 76 | XP_033637698.1 LOW QUALITY PROTEIN: dehydrogenase/reductase SDR family member 12-like [Asterias rubens] | diamond | 1338 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31146500 | 31146500 | PRJNA1214993_P_NODE_5355_length_462_cov_2.771208_g5170_i0 | PRJNA1214993 | 5355 | 462 | 2.771208 | 12.80298096 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 44.7 | 0.0306 | NR | XP_033625053.1 | 7604 | g5170 | i0 | 33.3 | 0.928571428571429 | 75 | 42 | 44.8 | 2 | 66 | 272 | 84 | 156 | XP_033625053.1 antistasin-like [Asterias rubens] | diamond | 429 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32095751 | 32095751 | PRJNA1214993_P_NODE_16638_length_274_cov_1.552239_g16452_i0 | PRJNA1214993 | 16638 | 274 | 1.552239 | 4.25313486 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 61.6 | 7.22e-9 | NR | XP_033640070.1 | 7604 | g16452 | i0 | 48.1 | 0.843065693430657 | 77 | 34 | 84.3 | 1 | 241 | 11 | 3 | 73 | XP_033640070.1 enkurin-like [Asterias rubens] | diamond | 231 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32254341 | 32254341 | PRJNA1214993_P_NODE_11378_length_326_cov_2.019763_g11192_i0 | PRJNA1214993 | 11378 | 326 | 2.019763 | 6.58442738 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 62 | 4.11e-9 | NR | XP_033108205.1 | 1529436 | g11192 | i0 | 38.5 | 1.6840490797546 | 96 | 55 | 88.3 | 2 | 12 | 299 | 1 | 92 | XP_033108205.1 translocon-associated protein subunit beta-like [Anneissia japonica] | diamond | 549 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32885150 | 32885150 | PRJNA1214993_P_NODE_6080_length_435_cov_1.624309_g5895_i0 | PRJNA1214993 | 6080 | 435 | 1.624309 | 7.06574415 | Paelopatides sp. YL-2 | 2219783 | Echinodermata | other_Eukaryota | 180 | 3.3799999999999985e-55 | NR | AWT62728.1 | 2219783 | g5895 | i0 | 65.2 | 9.43448275862069 | 135 | 46 | 93.1 | 1 | 407 | 3 | 5 | 138 | AWT62728.1 copper-zinc superoxide dismutase [Paelopatides sp. YL-2018] | diamond | 4104 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Synallactidae | Paelopatides | Paelopatides sp. YL-2018 |
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);;