contig_metadata
12 rows where bioproject = "PRJEB76780", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15441204 | 15441204 | PRJEB76780_P_NODE_13633_length_227_cov_2.090909_g13533_i0 | PRJEB76780 | 13633 | 227 | 2.090909 | 4.74636343 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 209 | 1.13e-49 | NTclustered | gi|1826668185|ref|XM_033265809.1| | 1529436 | g13533 | i0 | 83.26 | 53.3788546255507 | 227 | 38 | 100 | 0 | 1 | 227 | 490 | 264 | PREDICTED: Anneissia japonica ras-like GTP-binding protein Rho1 (LOC117120737), transcript variant X3, mRNA | blastn | 12117 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 19264286 | 19264286 | PRJEB76780_P_NODE_1876_length_607_cov_3.387640_g1777_i0 | PRJEB76780 | 1876 | 607 | 3.38764 | 20.5629748 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 142 | 1.06e-38 | NR | XP_022088490.1 | 133434 | g1777 | i0 | 47.1 | 10.2899505766063 | 189 | 88 | 87.5 | 2 | 47 | 577 | 15 | 203 | XP_022088490.1 40S ribosomal protein S7-like isoform X1 [Acanthaster planci] | diamond | 6246 | 143 | 0.993006993006993 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 19264289 | 19264289 | PRJEB76780_P_NODE_2176_length_562_cov_5.394683_g2076_i0 | PRJEB76780 | 2176 | 562 | 5.394683 | 30.31811846 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 164 | 4.9799999999999993e-48 | NR | XP_033123568.1 | 1529436 | g2076 | i0 | 63 | 1.36120996441281 | 127 | 47 | 67.8 | 0 | 421 | 41 | 55 | 181 | XP_033123568.1 60S ribosomal protein L23a-like [Anneissia japonica] | diamond | 765 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 21815460 | 21815460 | PRJEB76780_P_NODE_1378_length_705_cov_5.256329_g1284_i0 | PRJEB76780 | 1378 | 705 | 5.256329 | 37.05711945 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 273 | 1.03e-89 | NR | PIK55330.1 | 307972 | g1284 | i0 | 60.1 | 37.0553191489362 | 218 | 85 | 92.8 | 1 | 19 | 672 | 1 | 216 | PIK55330.1 Ribosomal protein L10a [Apostichopus japonicus] | diamond | 26124 | 273 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 23090672 | 23090672 | PRJEB76780_P_NODE_12339_length_246_cov_0.895954_g12239_i0 | PRJEB76780 | 12339 | 246 | 0.895954 | 2.20404684 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 143 | 2.27e-39 | NR | PIK54960.1 | 307972 | g12239 | i0 | 76.8 | 1 | 82 | 19 | 100 | 0 | 246 | 1 | 153 | 234 | PIK54960.1 putative isocitrate dehydrogenase [Apostichopus japonicus] | diamond | 246 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 26748928 | 26748928 | PRJEB76780_P_NODE_4361_length_390_cov_0.886435_g4261_i0 | PRJEB76780 | 4361 | 390 | 0.886435 | 3.4570965 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 73.2 | 4.48e-12 | NR | XP_033098395.1 | 1529436 | g4261 | i0 | 32 | 0.961538461538462 | 125 | 81 | 93.8 | 2 | 23 | 388 | 745 | 868 | XP_033098395.1 RRP12-like protein isoform X1 [Anneissia japonica] | diamond | 375 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26907660 | 26907660 | PRJEB76780_P_NODE_11702_length_248_cov_0.891429_g11602_i0 | PRJEB76780 | 11702 | 248 | 0.891429 | 2.21074392 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 50.8 | 5.44e-5 | NR | XP_038058599.1 | 46514 | g11602 | i0 | 43.1 | 1.83870967741935 | 72 | 41 | 87.1 | 0 | 28 | 243 | 322 | 393 | XP_038058599.1 meiosis-specific nuclear structural protein 1-like [Patiria miniata] | diamond | 456 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27002389 | 27002389 | PRJEB76780_P_NODE_9882_length_258_cov_1.356757_g9782_i0 | PRJEB76780 | 9882 | 258 | 1.356757 | 3.50043306 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 86.7 | 1.04e-17 | NR | XP_030855190.1 | 7668 | g9782 | i0 | 78.4 | 1.62790697674419 | 51 | 11 | 59.3 | 0 | 155 | 3 | 58 | 108 | XP_030855190.1 NAD-dependent protein deacetylase sirtuin-2 isoform X2 [Strongylocentrotus purpuratus] | diamond | 420 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27413756 | 27413756 | PRJEB76780_P_NODE_10383_length_253_cov_0.866667_g10283_i0 | PRJEB76780 | 10383 | 253 | 0.866667 | 2.19266751 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 45.8 | 0.00351 | NR | XP_041474675.1 | 7654 | g10283 | i0 | 34.8 | 1.05533596837945 | 89 | 43 | 91.3 | 5 | 233 | 3 | 39 | 124 | XP_041474675.1 uncharacterized protein LOC121423414 isoform X1 [Lytechinus variegatus] | diamond | 267 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31955022 | 31955022 | PRJEB76780_P_NODE_6117_length_326_cov_1.849802_g6017_i0 | PRJEB76780 | 6117 | 326 | 1.849802 | 6.03035452 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 55.8 | 2.6e-6 | NR | XP_033646781.1 | 7604 | g6017 | i0 | 51 | 4.0398773006135 | 49 | 23 | 45.1 | 1 | 319 | 173 | 306 | 353 | XP_033646781.1 stabilin-2-like isoform X2 [Asterias rubens] | diamond | 1317 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32437302 | 32437302 | PRJEB76780_P_NODE_1419_length_695_cov_1.127010_g1325_i0 | PRJEB76780 | 1419 | 695 | 1.12701 | 7.8327195 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 62.4 | 3.9e-7 | NR | XP_022098801.1 | 133434 | g1325 | i0 | 48.3 | 0.768345323741007 | 58 | 29 | 24.6 | 1 | 694 | 524 | 341 | 398 | XP_022098801.1 stabilin-2-like isoform X2 [Acanthaster planci] | diamond | 534 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32468918 | 32468918 | PRJEB76780_P_NODE_4499_length_383_cov_2.264516_g4399_i0 | PRJEB76780 | 4499 | 383 | 2.264516 | 8.67309628 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 159 | 2.3e-44 | NR | XP_022090854.1 | 133434 | g4399 | i0 | 60 | 3.79895561357702 | 125 | 49 | 97.9 | 1 | 379 | 5 | 147 | 270 | XP_022090854.1 alternative oxidase, mitochondrial-like [Acanthaster planci] | diamond | 1455 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci |
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);;