contig_metadata
11 rows where bioproject = "PRJNA1126198", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4108845 | 4108845 | PRJNA1126198_P_NODE_49144_length_399_cov_2.914110_g48427_i0 | PRJNA1126198 | 49144 | 399 | 2.91411 | 11.6272989 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 128 | 1.46e-33 | NR | XP_038063470.1 | 46514 | g48427 | i0 | 63 | 47.1954887218045 | 119 | 42 | 89.5 | 1 | 364 | 8 | 7 | 123 | XP_038063470.1 60S ribosomal protein L7a-like [Patiria miniata] | diamond | 18831 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 4108857 | 4108857 | PRJNA1126198_P_NODE_5064_length_786_cov_2.504909_g4475_i0 | PRJNA1126198 | 5064 | 786 | 2.504909 | 19.68858474 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 292 | 6.28e-91 | NR | XP_033642011.1 | 7604 | g4475 | i0 | 52.1 | 3.01145038167939 | 267 | 119 | 98.9 | 4 | 786 | 10 | 377 | 642 | XP_033642011.1 methylenetetrahydrofolate reductase-like [Asterias rubens] | diamond | 2367 | 294 | 0.993197278911565 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 9209077 | 9209077 | PRJNA1126198_P_NODE_140108_length_318_cov_1.273469_g139389_i0 | PRJNA1126198 | 140108 | 318 | 1.273469 | 4.04963142 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 1.6899999999999998e-32 | NR | XP_033096589.1 | 1529436 | g139389 | i0 | 62.5 | 2.54716981132075 | 104 | 38 | 98.1 | 1 | 316 | 5 | 4 | 106 | XP_033096589.1 methylmalonyl-CoA epimerase, mitochondrial-like [Anneissia japonica] | diamond | 810 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 12509082 | 12509082 | PRJNA1126198_P_NODE_319910_length_261_cov_1.648936_g319189_i0 | PRJNA1126198 | 319910 | 261 | 1.648936 | 4.30372296 | root | 1 | Root_unresolved | Root_unresolved | 125 | 1.2399999999999998e-31 | NR | XP_030843902.1 | 7668 | g319189 | i0 | 71.4 | 26.5172413793103 | 84 | 24 | 96.6 | 0 | 260 | 9 | 201 | 284 | XP_030843902.1 thymidine phosphorylase [Strongylocentrotus purpuratus] | diamond | 6921 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 20683264 | 20683264 | PRJNA1126198_P_NODE_469897_length_242_cov_0.917160_g469176_i0 | PRJNA1126198 | 469897 | 242 | 0.91716 | 2.2195272 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 132 | 2.56e-36 | NR | XP_038051326.1 | 46514 | g469176 | i0 | 72.5 | 15.8925619834711 | 80 | 22 | 99.2 | 0 | 240 | 1 | 164 | 243 | XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] | diamond | 3846 | 133 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 24507490 | 24507490 | PRJNA1126198_P_NODE_38180_length_422_cov_2.472779_g37467_i0 | PRJNA1126198 | 38180 | 422 | 2.472779 | 10.43512738 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 228 | 6.2899999999999984e-55 | NTclustered | gi|2919360009|ref|XM_071633688.1| | 105358 | g37467 | i0 | 80 | 30.5165876777251 | 310 | 61 | 73 | 1 | 8 | 316 | 85 | 394 | PREDICTED: Diadema antillarum large ribosomal subunit protein uL11-like (LOC139722379), mRNA | blastn | 12878 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28670128 | 28670128 | PRJNA1126198_P_NODE_473387_length_241_cov_2.458333_g472666_i0 | PRJNA1126198 | 473387 | 241 | 2.458333 | 5.92458253 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 49.7 | 8.3e-5 | NR | XP_030834943.1 | 7668 | g472666 | i0 | 54.5 | 1.56846473029046 | 33 | 15 | 41.1 | 0 | 138 | 236 | 46 | 78 | XP_030834943.1 H/ACA ribonucleoprotein complex subunit 1 [Strongylocentrotus purpuratus] | diamond | 378 | 50.1 | 0.992015968063872 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30638878 | 30638878 | PRJNA1126198_P_NODE_445613_length_244_cov_1.274854_g444892_i0 | PRJNA1126198 | 445613 | 244 | 1.274854 | 3.11064376 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 101 | 2.4399999999999999e-23 | NR | XP_038059166.1 | 46514 | g444892 | i0 | 62 | 3.90983606557377 | 79 | 30 | 97.1 | 0 | 1 | 237 | 208 | 286 | XP_038059166.1 LOW QUALITY PROTEIN: fructose-bisphosphate aldolase C-like [Patiria miniata] | diamond | 954 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30796919 | 30796919 | PRJNA1126198_P_NODE_93454_length_348_cov_0.949091_g92736_i0 | PRJNA1126198 | 93454 | 348 | 0.949091 | 3.30283668 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 87.8 | 6.02e-18 | NR | XP_022082127.1 | 133434 | g92736 | i0 | 50 | 0.862068965517241 | 100 | 49 | 86.2 | 1 | 1 | 300 | 209 | 307 | XP_022082127.1 ribosome production factor 2 homolog [Acanthaster planci] | diamond | 300 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31271028 | 31271028 | PRJNA1126198_P_NODE_35815_length_429_cov_1.297753_g35106_i0 | PRJNA1126198 | 35815 | 429 | 1.297753 | 5.56736037 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 168 | 1.0599999999999999e-48 | NR | XP_071492586.1 | 105358 | g35106 | i0 | 66.1 | 2.34965034965035 | 112 | 38 | 78.3 | 0 | 3 | 338 | 190 | 301 | XP_071492586.1 NADH-cytochrome b5 reductase 3-like [Diadema antillarum] | diamond | 1008 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32378278 | 32378278 | PRJNA1126198_P_NODE_126579_length_325_cov_1.968254_g125860_i0 | PRJNA1126198 | 126579 | 325 | 1.968254 | 6.3968255 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 92.8 | 1.86e-19 | NR | XP_033100717.1 | 1529436 | g125860 | i0 | 40.8 | 1.90153846153846 | 103 | 59 | 93.2 | 1 | 13 | 315 | 193 | 295 | XP_033100717.1 eukaryotic translation initiation factor 3 subunit E-like [Anneissia japonica] | diamond | 618 | 92.8 | 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);;