contig_metadata
8 rows where bioproject = "PRJEB12237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20658 | 20658 | PRJEB12237_P_NODE_11661_length_154_cov_1.008403_g11465_i0 | PRJEB12237 | 11661 | 154 | 1.008403 | 1.55294062 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 63.9 | 5.84e-6 | NTclustered | gi|2919453208|ref|XR_011710916.1| | 105358 | g11465 | i0 | 95 | 0.25974025974026 | 40 | 2 | 26 | 0 | 114 | 153 | 3072 | 3033 | PREDICTED: Diadema antillarum uncharacterized lncRNA (LOC139730312), ncRNA | blastn | 40 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 7672900 | 7672900 | PRJEB12237_P_NODE_5627_length_250_cov_2.251163_g5431_i0 | PRJEB12237 | 5627 | 250 | 2.251163 | 5.6279075 | Molpadia musculus complex sp. AKM-2016 | 1902941 | Echinodermata | other_Eukaryota | 128 | 3.66e-25 | NTclustered | gi|1160550733|gb|KX856889.1| | 1902941 | g5431 | i0 | 98.611 | 26.048 | 72 | 1 | 29 | 0 | 97 | 168 | 444 | 515 | Molpadia musculus complex sp. AKM-2016 voucher SIO:BIC:E5295 28S ribosomal RNA gene, partial sequence | blastn | 6512 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Molpadida | Molpadiidae | Molpadia | Molpadia musculus complex sp. AKM-2016 | |
| 8947663 | 8947663 | PRJEB12237_P_NODE_3068_length_389_cov_2.290960_g2872_i0 | PRJEB12237 | 3068 | 389 | 2.29096 | 8.9118344 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 84.2 | 1.32e-11 | NTclustered | gi|1834301632|ref|XM_033770905.1| | 7604 | g2872 | i0 | 94.444 | 0.25706940874036 | 54 | 3 | 14 | 0 | 336 | 389 | 1418 | 1365 | PREDICTED: Asterias rubens tubulin beta chain-like (LOC117289675), transcript variant X2, mRNA | blastn | 100 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 15322880 | 15322880 | PRJEB12237_P_NODE_7073_length_213_cov_1.471910_g6877_i0 | PRJEB12237 | 7073 | 213 | 1.47191 | 3.1351683 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 94.7 | 3.34e-21 | NR | XP_030829336.1 | 7668 | g6877 | i0 | 64.8 | 1 | 71 | 25 | 100 | 0 | 1 | 213 | 185 | 255 | XP_030829336.1 cathepsin L1 [Strongylocentrotus purpuratus] | diamond | 213 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 15322884 | 15322884 | PRJEB12237_P_NODE_7933_length_196_cov_2.354037_g7737_i0 | PRJEB12237 | 7933 | 196 | 2.354037 | 4.61391252 | Paracentrotus lividus | 7656 | Echinodermata | other_Eukaryota | 180 | 7.45e-41 | NTclustered | gi|37287386|gb|AY388462.1| | 7656 | g7737 | i0 | 84.153 | 20.8265306122449 | 183 | 29 | 93 | 0 | 5 | 187 | 397 | 215 | Paracentrotus lividus neural alfa2 tubulin (Talfa2) mRNA, complete cds | blastn | 4082 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Echinidae | Paracentrotus | Paracentrotus lividus | |
| 26621433 | 26621433 | PRJEB12237_P_NODE_7361_length_207_cov_0.930233_g7165_i0 | PRJEB12237 | 7361 | 207 | 0.930233 | 1.92558231 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 89.7 | 6.46e-19 | NR | XP_041472457.1 | 7654 | g7165 | i0 | 56.7 | 4.85507246376812 | 67 | 29 | 97.1 | 0 | 5 | 205 | 325 | 391 | XP_041472457.1 AP-2 complex subunit alpha-2-like isoform X4 [Lytechinus variegatus] | diamond | 1005 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27437785 | 27437785 | PRJEB12237_P_NODE_7583_length_202_cov_1.437126_g7387_i0 | PRJEB12237 | 7583 | 202 | 1.437126 | 2.90299452 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.2 | 3.8e-7 | NR | XP_041473105.1 | 7654 | g7387 | i0 | 48.1 | 3.2970297029703 | 54 | 27 | 78.7 | 1 | 1 | 159 | 485 | 538 | XP_041473105.1 eukaryotic translation initiation factor 3 subunit L-like [Lytechinus variegatus] | diamond | 666 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31676362 | 31676362 | PRJEB12237_P_NODE_11977_length_151_cov_1.948276_g11781_i0 | PRJEB12237 | 11977 | 151 | 1.948276 | 2.94189676 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 61.2 | 2.31e-10 | NR | KAJ8022446.1 | 206669 | g11781 | i0 | 76.3 | 3.03973509933775 | 38 | 9 | 75.5 | 0 | 117 | 4 | 1 | 38 | KAJ8022446.1 60S ribosomal protein L34 [Holothuria leucospilota] | diamond | 459 | 61.2 | 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);;