contig_metadata
12 rows where bioproject = "PRJNA1005695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2703758 | 2703758 | PRJNA1005695_P_NODE_30963_length_268_cov_2.000000_g30111_i0 | PRJNA1005695 | 30963 | 268 | 2 | 5.36 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|2707414840|ref|XM_064099171.1| | 7653 | g30111 | i0 | 100 | 0.626865671641791 | 28 | 0 | 10 | 0 | 6 | 33 | 1485 | 1458 | PREDICTED: Lytechinus pictus uncharacterized LOC129261136 (LOC129261136), transcript variant X2, mRNA | blastn | 168 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 15456244 | 15456244 | PRJNA1005695_P_NODE_37293_length_247_cov_2.689655_g36441_i0 | PRJNA1005695 | 37293 | 247 | 2.689655 | 6.64344785 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 60.2 | 1.33e-4 | NTclustered | gi|1826642534|ref|XM_033253480.1| | 1529436 | g36441 | i0 | 89.362 | 0.57085020242915 | 47 | 5 | 19 | 0 | 200 | 246 | 2040 | 1994 | PREDICTED: Anneissia japonica serine/threonine-protein kinase DCLK1-like (LOC117110710), transcript variant X2, mRNA | blastn | 141 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 19279133 | 19279133 | PRJNA1005695_P_NODE_33776_length_256_cov_1.612022_g32924_i0 | PRJNA1005695 | 33776 | 256 | 1.612022 | 4.12677632 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|1229180385|ref|XM_022248042.1| | 133434 | g32924 | i0 | 100 | 0.2265625 | 29 | 0 | 11 | 0 | 211 | 239 | 9159 | 9187 | PREDICTED: Acanthaster planci ubiquitin carboxyl-terminal hydrolase 32-like (LOC110986285), transcript variant X2, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 25227420 | 25227420 | PRJNA1005695_P_NODE_6580_length_613_cov_1.681481_g5751_i0 | PRJNA1005695 | 6580 | 613 | 1.681481 | 10.30747853 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 171 | 1.05e-49 | NR | XP_071510808.1 | 105358 | g5751 | i0 | 58.4 | 3.0685154975530202 | 178 | 64 | 85.6 | 3 | 527 | 3 | 1 | 171 | XP_071510808.1 large ribosomal subunit protein uL30-like isoform X2 [Diadema antillarum] | diamond | 1881 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 26971047 | 26971047 | PRJNA1005695_P_NODE_30282_length_271_cov_2.010101_g29430_i0 | PRJNA1005695 | 30282 | 271 | 2.010101 | 5.44737371 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 70.5 | 8.77e-12 | NR | XP_033125333.1 | 1529436 | g29430 | i0 | 47 | 0.730627306273063 | 66 | 35 | 73.1 | 0 | 200 | 3 | 493 | 558 | XP_033125333.1 protein arginine N-methyltransferase 5-like [Anneissia japonica] | diamond | 198 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27097633 | 27097633 | PRJNA1005695_P_NODE_18222_length_354_cov_1.950178_g17370_i0 | PRJNA1005695 | 18222 | 354 | 1.950178 | 6.90363012 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 121 | 3e-29 | NR | XP_041461568.1 | 7654 | g17370 | i0 | 63.5 | 1.63559322033898 | 96 | 35 | 81.4 | 0 | 292 | 5 | 1297 | 1392 | XP_041461568.1 transcriptional regulator ATRX homolog isoform X2 [Lytechinus variegatus] | diamond | 579 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27343362 | 27343362 | PRJNA1005695_P_NODE_23043_length_313_cov_1.300000_g22191_i0 | PRJNA1005695 | 23043 | 313 | 1.3 | 4.069 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 86.7 | 3.18e-17 | NR | XP_022082410.1 | 133434 | g22191 | i0 | 56 | 7.11182108626198 | 75 | 32 | 71.9 | 1 | 308 | 84 | 477 | 550 | XP_022082410.1 ribosome biogenesis protein bop1-A-like isoform X2 [Acanthaster planci] | diamond | 2226 | 87.4 | 0.991990846681922 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 29016911 | 29016911 | PRJNA1005695_P_NODE_20548_length_333_cov_1.176923_g19696_i0 | PRJNA1005695 | 20548 | 333 | 1.176923 | 3.91915359 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 102 | 3.2799999999999995e-23 | NR | PIK37603.1 | 307972 | g19696 | i0 | 57.6 | 1.48648648648649 | 85 | 31 | 72.1 | 1 | 240 | 1 | 107 | 191 | PIK37603.1 Rabggtb protein [Apostichopus japonicus] | diamond | 495 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 29591967 | 29591967 | PRJNA1005695_P_NODE_38870_length_244_cov_1.730994_g38018_i0 | PRJNA1005695 | 38870 | 244 | 1.730994 | 4.22362536 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 58.5 | 1.02e-7 | NR | KAJ8039100.1 | 206669 | g38018 | i0 | 48.8 | 1.40163934426229 | 41 | 21 | 50.4 | 0 | 236 | 114 | 481 | 521 | KAJ8039100.1 Protein crumbs [Holothuria leucospilota] | diamond | 342 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31835918 | 31835918 | PRJNA1005695_P_NODE_35117_length_252_cov_0.871508_g34265_i0 | PRJNA1005695 | 35117 | 252 | 0.871508 | 2.19620016 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 62.8 | 3.7e-9 | NR | XP_033123521.1 | 1529436 | g34265 | i0 | 58.7 | 3.71428571428571 | 46 | 19 | 54.8 | 0 | 252 | 115 | 170 | 215 | XP_033123521.1 vacuolar protein sorting-associated protein 33A-like [Anneissia japonica] | diamond | 936 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31955082 | 31955082 | PRJNA1005695_P_NODE_32197_length_263_cov_1.363158_g31345_i0 | PRJNA1005695 | 32197 | 263 | 1.363158 | 3.58510554 | root | 1 | Root_unresolved | Root_unresolved | 100 | 3.34e-24 | NR | PIK53513.1 | 307972 | g31345 | i0 | 61.2 | 2.88593155893536 | 85 | 33 | 97 | 0 | 257 | 3 | 41 | 125 | PIK53513.1 hypothetical protein BSL78_09607 [Apostichopus japonicus] | diamond | 759 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 32121007 | 32121007 | PRJNA1005695_P_NODE_20278_length_335_cov_1.786260_g19426_i0 | PRJNA1005695 | 20278 | 335 | 1.78626 | 5.983971 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 46.2 | 0.00618 | NR | XP_033114538.1 | 1529436 | g19426 | i0 | 42.6 | 1.62089552238806 | 61 | 32 | 51.9 | 1 | 179 | 6 | 116 | 176 | XP_033114538.1 methionine aminopeptidase 2-like [Anneissia japonica] | diamond | 543 | 46.2 | 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);;