contig_metadata
7 rows where bioproject = "PRJNA1092581", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1470541 | 1470541 | PRJNA1092581_P_NODE_119782_length_222_cov_72.174497_g119249_i0 | PRJNA1092581 | 119782 | 222 | 72.174497 | 160.22738334 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 183 | 6.689999999999998e-42 | NTclustered | gi|1752360029|ref|XM_786031.4| | 7668 | g119249 | i0 | 98.095 | 1.9009009009009 | 105 | 2 | 47 | 0 | 22 | 126 | 1135 | 1239 | PREDICTED: Strongylocentrotus purpuratus mitochondrial Rho GTPase 1-A (LOC586242), transcript variant X2, mRNA | blastn | 422 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 9125790 | 9125790 | PRJNA1092581_P_NODE_90428_length_268_cov_65.784615_g89895_i0 | PRJNA1092581 | 90428 | 268 | 65.784615 | 176.3027682 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 104 | 6.68e-18 | NTclustered | gi|1752373223|ref|XM_030990498.1| | 7668 | g89895 | i0 | 89.286 | 0.313432835820896 | 84 | 8 | 31 | 1 | 118 | 200 | 1380 | 1463 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC105447475 (LOC105447475), mRNA | blastn | 84 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 12949264 | 12949264 | PRJNA1092581_P_NODE_103551_length_248_cov_2.520000_g103018_i0 | PRJNA1092581 | 103551 | 248 | 2.52 | 6.2496 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 139 | 3.0899999999999998e-40 | NR | XP_033643204.1 | 7604 | g103018 | i0 | 80.7 | 19.7782258064516 | 83 | 15 | 99.2 | 1 | 3 | 248 | 50 | 132 | XP_033643204.1 iron-sulfur cluster assembly 1 homolog, mitochondrial-like [Asterias rubens] | diamond | 4905 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 24422866 | 24422866 | PRJNA1092581_P_NODE_45100_length_403_cov_10.915152_g44567_i0 | PRJNA1092581 | 45100 | 403 | 10.915152 | 43.98806256 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 78.7 | 6.38e-10 | NTclustered | gi|1834259634|ref|XR_004519136.1| | 7604 | g44567 | i0 | 83.529 | 0.210918114143921 | 85 | 13 | 21 | 1 | 53 | 136 | 147 | 231 | PREDICTED: Asterias rubens uncharacterized LOC117291183 (LOC117291183), ncRNA | blastn | 85 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 25244823 | 25244823 | PRJNA1092581_P_NODE_58580_length_347_cov_3.405109_g58047_i0 | PRJNA1092581 | 58580 | 347 | 3.405109 | 11.81572823 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 172 | 2.42e-38 | NTclustered | gi|1240051417|dbj|LC187283.1| | 7650 | g58047 | i0 | 85.119 | 17.6657060518732 | 168 | 25 | 48 | 0 | 132 | 299 | 248 | 81 | Hemicentrotus pulcherrimus mRNA for calmodulin, complete cds | blastn | 6130 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Hemicentrotus | Hemicentrotus pulcherrimus | |
| 27848499 | 27848499 | PRJNA1092581_P_NODE_78224_length_293_cov_2.790909_g77691_i0 | PRJNA1092581 | 78224 | 293 | 2.790909 | 8.17736337 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.5 | 1.08e-18 | NR | XP_033100310.1 | 1529436 | g77691 | i0 | 42.3 | 5.00682593856655 | 97 | 54 | 99.3 | 1 | 2 | 292 | 292 | 386 | XP_033100310.1 uncharacterized protein LOC117103797 [Anneissia japonica] | diamond | 1467 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32375604 | 32375604 | PRJNA1092581_P_NODE_17259_length_668_cov_11.132773_g16749_i0 | PRJNA1092581 | 17259 | 668 | 11.132773 | 74.36692364 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 92.8 | 1.23e-17 | NR | XP_022082545.1 | 133434 | g16749 | i0 | 31.7 | 0.893712574850299 | 199 | 100 | 86.7 | 6 | 579 | 1 | 33 | 201 | XP_022082545.1 uncharacterized protein LOC110974905 isoform X3 [Acanthaster planci] | diamond | 597 | 92.8 | 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);;