contig_metadata
11 rows where bioproject = "PRJNA1146029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1033653 | 1033653 | PRJNA1146029_P_NODE_2361_length_559_cov_2.520576_g2086_i0 | PRJNA1146029 | 2361 | 559 | 2.520576 | 14.09001984 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 370 | 1.34e-97 | NTclustered | gi|780036166|ref|XM_786257.4| | 7668 | g2086 | i0 | 78.863 | 96.2611806797853 | 563 | 107 | 99 | 11 | 1 | 557 | 943 | 387 | PREDICTED: Strongylocentrotus purpuratus 60S ribosomal protein L3 (LOC586477), mRNA | blastn | 53810 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 17611272 | 17611272 | PRJNA1146029_P_NODE_1314_length_777_cov_1.944602_g1069_i0 | PRJNA1146029 | 1314 | 777 | 1.944602 | 15.10955754 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 289 | 5.119999999999999e-95 | NR | XP_033118288.1 | 1529436 | g1069 | i0 | 60.4 | 3.64864864864865 | 235 | 93 | 90.7 | 0 | 736 | 32 | 9 | 243 | XP_033118288.1 60S ribosomal protein L7-like isoform X2 [Anneissia japonica] | diamond | 2835 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 18141905 | 18141905 | PRJNA1146029_P_NODE_3035_length_491_cov_1.358852_g2758_i0 | PRJNA1146029 | 3035 | 491 | 1.358852 | 6.67196332 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 63.5 | 2.92e-8 | NR | XP_022107695.1 | 133434 | g2758 | i0 | 73.7 | 0.232179226069246 | 38 | 10 | 23.2 | 0 | 481 | 368 | 980 | 1017 | XP_022107695.1 neurogenic locus notch homolog protein 1-like isoform X2 [Acanthaster planci] | diamond | 114 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 20691574 | 20691574 | PRJNA1146029_P_NODE_16677_length_250_cov_0.870056_g16396_i0 | PRJNA1146029 | 16677 | 250 | 0.870056 | 2.17514 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 163 | 1e-35 | NTclustered | gi|2037954100|ref|XM_041622201.1| | 7654 | g16396 | i0 | 78.571 | 20.016 | 252 | 50 | 100 | 4 | 1 | 250 | 703 | 454 | PREDICTED: Lytechinus variegatus NADH-ubiquinone oxidoreductase 75 kDa subunit, mitochondrial-like (LOC121426059), mRNA | blastn | 5004 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 26785896 | 26785896 | PRJNA1146029_P_NODE_11961_length_278_cov_1.502439_g11680_i0 | PRJNA1146029 | 11961 | 278 | 1.502439 | 4.17678042 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 70.1 | 1.37e-11 | NR | WDP79883.1 | 307972 | g11680 | i0 | 44.4 | 2.62230215827338 | 81 | 45 | 87.4 | 0 | 278 | 36 | 684 | 764 | WDP79883.1 transient receptor potential cation channel subfamily A member 7 [Apostichopus japonicus] | diamond | 729 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27418481 | 27418481 | PRJNA1146029_P_NODE_19543_length_245_cov_1.238372_g19262_i0 | PRJNA1146029 | 19543 | 245 | 1.238372 | 3.0340114 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 43.1 | 0.0286 | NR | XP_041476506.1 | 7654 | g19262 | i0 | 46.8 | 0.575510204081633 | 47 | 20 | 57.6 | 3 | 6 | 146 | 100 | 141 | XP_041476506.1 uncharacterized protein LOC121424795 [Lytechinus variegatus] | diamond | 141 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27564799 | 27564799 | PRJNA1146029_P_NODE_2884_length_504_cov_1.343387_g2607_i0 | PRJNA1146029 | 2884 | 504 | 1.343387 | 6.77067048 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 143 | 3.37e-39 | NR | XP_038060914.1 | 46514 | g2607 | i0 | 45.6 | 7.00595238095238 | 160 | 85 | 94.6 | 2 | 477 | 1 | 4 | 162 | XP_038060914.1 glutathione peroxidase-like [Patiria miniata] | diamond | 3531 | 144 | 0.993055555555556 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30260406 | 30260406 | PRJNA1146029_P_NODE_16352_length_251_cov_0.865169_g16071_i0 | PRJNA1146029 | 16352 | 251 | 0.865169 | 2.17157419 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 115 | 1.46e-27 | NR | XP_033101101.1 | 1529436 | g16071 | i0 | 63.1 | 1.00398406374502 | 84 | 30 | 99.2 | 1 | 3 | 251 | 286 | 369 | XP_033101101.1 cilia- and flagella-associated protein 70-like isoform X1 [Anneissia japonica] | diamond | 252 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30702473 | 30702473 | PRJNA1146029_P_NODE_9514_length_295_cov_2.081081_g9233_i0 | PRJNA1146029 | 9514 | 295 | 2.081081 | 6.13918895 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 46.6 | 0.00248 | NR | XP_038068656.1 | 46514 | g9233 | i0 | 59.5 | 0.854237288135593 | 42 | 17 | 42.7 | 0 | 52 | 177 | 55 | 96 | XP_038068656.1 elongation factor 1-delta-like isoform X2 [Patiria miniata] | diamond | 252 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31196525 | 31196525 | PRJNA1146029_P_NODE_6075_length_357_cov_1.352113_g5797_i0 | PRJNA1146029 | 6075 | 357 | 1.352113 | 4.82704341 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 51.2 | 1.93e-5 | NR | XP_030845209.1 | 7668 | g5797 | i0 | 31.5 | 3.49579831932773 | 111 | 72 | 91.6 | 3 | 328 | 2 | 1 | 109 | XP_030845209.1 uncharacterized protein LOC105439427 [Strongylocentrotus purpuratus] | diamond | 1248 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32315570 | 32315570 | PRJNA1146029_P_NODE_6639_length_344_cov_1.317343_g6361_i0 | PRJNA1146029 | 6639 | 344 | 1.317343 | 4.53165992 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 95.5 | 3.54e-20 | NR | XP_038074569.1 | 46514 | g6361 | i0 | 48.1 | 4.63081395348837 | 108 | 38 | 94.2 | 3 | 327 | 4 | 418 | 507 | XP_038074569.1 dye-decolorizing peroxidase msp1-like [Patiria miniata] | diamond | 1593 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;