contig_metadata
12 rows where bioproject = "PRJNA1160211" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7962515 | 7962515 | PRJNA1160211_S_NODE_150667_length_374_cov_0.933555_g149434_i0 | PRJNA1160211 | 150667 | 374 | 0.933555 | 3.4914957 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 80.5 | 1.63e-10 | NTclustered | gi|2037969038|ref|XM_041596501.1| | 7654 | g149434 | i0 | 75.41 | 2.77272727272727 | 183 | 35 | 47 | 7 | 196 | 372 | 505 | 327 | PREDICTED: Lytechinus variegatus late histone H2A.2.2-like (LOC121405574), mRNA | blastn | 1037 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 9237711 | 9237711 | PRJNA1160211_S_NODE_210148_length_299_cov_10.075221_g208915_i0 | PRJNA1160211 | 210148 | 299 | 10.075221 | 30.12491079 | Encope aberrans | 39301 | Echinodermata | other_Eukaryota | 58.4 | 5.98e-4 | NTclustered | gi|665628|emb|Z37126.1| | 39301 | g208915 | i0 | 97.059 | 4.80936454849498 | 34 | 1 | 11 | 0 | 1 | 34 | 290 | 323 | E.aberrans gene for 18S ribosomal RNA | blastn | 1438 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Clypeasteroida | Mellitidae | Encope | Encope aberrans | |
| 13063923 | 13063923 | PRJNA1160211_S_NODE_293571_length_226_cov_4.529412_g292338_i0 | PRJNA1160211 | 293571 | 226 | 4.529412 | 10.23647112 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|2037964455|ref|XM_041627755.1| | 7654 | g292338 | i0 | 100 | 1.36283185840708 | 28 | 0 | 12 | 0 | 37 | 64 | 8202 | 8229 | PREDICTED: Lytechinus variegatus uncharacterized LOC121430484 (LOC121430484), transcript variant X3, mRNA | blastn | 308 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 18161745 | 18161745 | PRJNA1160211_S_NODE_257595_length_256_cov_1.038251_g256362_i0 | PRJNA1160211 | 257595 | 256 | 1.038251 | 2.65792256 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1826658637|ref|XM_033261216.1| | 1529436 | g256362 | i0 | 88.889 | 2.0078125 | 45 | 5 | 18 | 0 | 147 | 191 | 1130 | 1086 | PREDICTED: Anneissia japonica late histone H2A.2.2-like (LOC117117037), mRNA | blastn | 514 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 18161852 | 18161852 | PRJNA1160211_S_NODE_277715_length_244_cov_0.865497_g276482_i0 | PRJNA1160211 | 277715 | 244 | 0.865497 | 2.11181268 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 58.4 | 4.73e-4 | NTclustered | gi|1834271394|ref|XM_033781795.1| | 7604 | g276482 | i0 | 100 | 0.127049180327869 | 31 | 0 | 13 | 0 | 125 | 155 | 1206 | 1176 | PREDICTED: Asterias rubens motile sperm domain-containing protein 1-like (LOC117298507), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27166684 | 27166684 | PRJNA1160211_S_NODE_267662_length_249_cov_0.914773_g266429_i0 | PRJNA1160211 | 267662 | 249 | 0.914773 | 2.27778477 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 130 | 6.23e-36 | NR | XP_033099893.1 | 1529436 | g266429 | i0 | 73.2 | 0.987951807228916 | 82 | 22 | 98.8 | 0 | 248 | 3 | 93 | 174 | XP_033099893.1 uncharacterized protein LOC117103443 [Anneissia japonica] | diamond | 246 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27704187 | 27704187 | PRJNA1160211_S_NODE_273264_length_246_cov_0.971098_g272031_i0 | PRJNA1160211 | 273264 | 246 | 0.971098 | 2.38890108 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 120 | 1.27e-29 | NR | XP_030834486.1 | 7668 | g272031 | i0 | 71.3 | 6.85365853658537 | 80 | 23 | 97.6 | 0 | 241 | 2 | 405 | 484 | XP_030834486.1 uncharacterized protein LOC115921289 [Strongylocentrotus purpuratus] | diamond | 1686 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27830088 | 27830088 | PRJNA1160211_S_NODE_209964_length_300_cov_1.096916_g208731_i0 | PRJNA1160211 | 209964 | 300 | 1.096916 | 3.290748 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 108 | 4.07e-25 | NR | KAJ8046701.1 | 206669 | g208731 | i0 | 56.6 | 0.99 | 99 | 43 | 99 | 0 | 298 | 2 | 1059 | 1157 | KAJ8046701.1 RNA-directed DNA polymerase from mobile element jockey [Holothuria leucospilota] | diamond | 297 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28303740 | 28303740 | PRJNA1160211_S_NODE_275146_length_245_cov_1.087209_g273913_i0 | PRJNA1160211 | 275146 | 245 | 1.087209 | 2.66366205 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 117 | 2.05e-28 | NR | XP_071482577.1 | 105358 | g273913 | i0 | 66.3 | 3.93061224489796 | 80 | 27 | 98 | 0 | 4 | 243 | 532 | 611 | XP_071482577.1 uncharacterized protein [Diadema antillarum] | diamond | 963 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29648742 | 29648742 | PRJNA1160211_S_NODE_18110_length_723_cov_20.698462_g17146_i0 | PRJNA1160211 | 18110 | 723 | 20.698462 | 149.64988026 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 52.8 | 7.4e-4 | NR | XP_063959288.1 | 7653 | g17146 | i0 | 52.5 | 2.39004149377593 | 59 | 21 | 23.2 | 3 | 703 | 536 | 1133 | 1187 | XP_063959288.1 sortilin-related receptor-like [Lytechinus pictus] | diamond | 1728 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 30040415 | 30040415 | PRJNA1160211_S_NODE_279111_length_243_cov_0.905882_g277878_i0 | PRJNA1160211 | 279111 | 243 | 0.905882 | 2.20129326 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 112 | 3.4400000000000003e-29 | NR | PIK50568.1 | 307972 | g277878 | i0 | 70.9 | 1.95061728395062 | 79 | 23 | 97.5 | 0 | 241 | 5 | 45 | 123 | PIK50568.1 reverse transcriptase [Apostichopus japonicus] | diamond | 474 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 32789941 | 32789941 | PRJNA1160211_S_NODE_176680_length_339_cov_0.872180_g175447_i0 | PRJNA1160211 | 176680 | 339 | 0.87218 | 2.9566902 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 117 | 1.41e-30 | NR | XP_033099893.1 | 1529436 | g175447 | i0 | 59.2 | 0.911504424778761 | 103 | 42 | 91.2 | 0 | 30 | 338 | 18 | 120 | XP_033099893.1 uncharacterized protein LOC117103443 [Anneissia japonica] | diamond | 309 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica |
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);;