contig_metadata
14 rows where bioproject = "PRJNA1120771", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1551185 | 1551185 | PRJNA1120771_S_NODE_25342_length_238_cov_1.784615_g24942_i0 | PRJNA1120771 | 25342 | 238 | 1.784615 | 4.2473837 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87.4 | 6.7e-18 | NR | XP_041482839.1 | 7654 | g24942 | i0 | 60.6 | 9.03781512605042 | 71 | 28 | 89.5 | 0 | 237 | 25 | 1382 | 1452 | XP_041482839.1 multidrug resistance-associated protein 5-like isoform X2 [Lytechinus variegatus] | diamond | 2151 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 15056256 | 15056256 | PRJNA1120771_S_NODE_35972_length_204_cov_3.378882_g35572_i0 | PRJNA1120771 | 35972 | 204 | 3.378882 | 6.89291928 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|2707422408|ref|XM_054902275.2| | 7653 | g35572 | i0 | 100 | 0.274509803921569 | 28 | 0 | 14 | 0 | 60 | 87 | 3089 | 3062 | PREDICTED: Lytechinus pictus homeobox protein goosecoid-like (LOC129264401), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 21953352 | 21953352 | PRJNA1120771_S_NODE_15218_length_289_cov_3.182927_g14818_i0 | PRJNA1120771 | 15218 | 289 | 3.182927 | 9.19865903 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 113 | 2.12e-30 | NR | XP_038058372.1 | 46514 | g14818 | i0 | 84.4 | 0.664359861591695 | 64 | 10 | 66.4 | 0 | 221 | 30 | 37 | 100 | XP_038058372.1 protein transport protein Sec61 subunit gamma [Patiria miniata] | diamond | 192 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26785461 | 26785461 | PRJNA1120771_S_NODE_7741_length_367_cov_7.135802_g7341_i0 | PRJNA1120771 | 7741 | 367 | 7.135802 | 26.18839334 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 121 | 3.18e-29 | NR | KAJ8040946.1 | 206669 | g7341 | i0 | 58.2 | 0.801089918256131 | 98 | 40 | 79.3 | 1 | 4 | 294 | 589 | 686 | KAJ8040946.1 Polypyrimidine tract-binding protein 2 [Holothuria leucospilota] | diamond | 294 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 26932805 | 26932805 | PRJNA1120771_S_NODE_35442_length_206_cov_2.668712_g35042_i0 | PRJNA1120771 | 35442 | 206 | 2.668712 | 5.49754672 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 9.89e-4 | NR | XP_054748116.2 | 7653 | g35042 | i0 | 52.2 | 5.12621359223301 | 46 | 20 | 67 | 1 | 34 | 171 | 358 | 401 | XP_054748116.2 amine oxidase [flavin-containing] B-like [Lytechinus pictus] | diamond | 1056 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 27091007 | 27091007 | PRJNA1120771_S_NODE_23222_length_246_cov_7.709360_g22822_i0 | PRJNA1120771 | 23222 | 246 | 7.70936 | 18.9650256 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 80.5 | 1.74e-16 | NR | XP_022085439.1 | 133434 | g22822 | i0 | 69.8 | 2.57317073170732 | 53 | 16 | 64.6 | 0 | 6 | 164 | 153 | 205 | XP_022085439.1 proteasome subunit beta type-6-like isoform X2 [Acanthaster planci] | diamond | 633 | 81.3 | 0.990159901599016 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27891218 | 27891218 | PRJNA1120771_S_NODE_17925_length_272_cov_4.179039_g17525_i0 | PRJNA1120771 | 17925 | 272 | 4.179039 | 11.36698608 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 92.4 | 1.79e-19 | NR | XP_022083175.1 | 133434 | g17525 | i0 | 60.9 | 4.18014705882353 | 69 | 26 | 75 | 1 | 5 | 208 | 657 | 725 | XP_022083175.1 lanosterol synthase-like [Acanthaster planci] | diamond | 1137 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28638608 | 28638608 | PRJNA1120771_S_NODE_27007_length_231_cov_3.239362_g26607_i0 | PRJNA1120771 | 27007 | 231 | 3.239362 | 7.48292622 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 82.4 | 8.4e-18 | NR | PIK44703.1 | 307972 | g26607 | i0 | 58.3 | 2.42857142857143 | 60 | 25 | 77.9 | 0 | 230 | 51 | 92 | 151 | PIK44703.1 Glia maturation factor beta [Apostichopus japonicus] | diamond | 561 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 29028325 | 29028325 | PRJNA1120771_S_NODE_8368_length_358_cov_2.209524_g7968_i0 | PRJNA1120771 | 8368 | 358 | 2.209524 | 7.91009592 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 80.1 | 8.34e-16 | NR | XP_033105873.1 | 1529436 | g7968 | i0 | 46 | 2.12849162011173 | 87 | 41 | 67.9 | 1 | 356 | 114 | 112 | 198 | XP_033105873.1 COMM domain-containing protein 4-like [Anneissia japonica] | diamond | 762 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29154582 | 29154582 | PRJNA1120771_S_NODE_28709_length_226_cov_0.950820_g28309_i0 | PRJNA1120771 | 28709 | 226 | 0.95082 | 2.1488532 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 51.2 | 2.9e-5 | NR | XP_071510262.1 | 105358 | g28309 | i0 | 55.3 | 1.00884955752212 | 38 | 17 | 50.4 | 0 | 224 | 111 | 378 | 415 | XP_071510262.1 UDP-N-acetylglucosamine--dolichyl-phosphate N-acetylglucosaminephosphotransferase-like [Diadema antillarum] | diamond | 228 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29648391 | 29648391 | PRJNA1120771_S_NODE_11630_length_319_cov_1.260870_g11230_i0 | PRJNA1120771 | 11630 | 319 | 1.26087 | 4.0221753 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 76.3 | 1e-14 | NR | XP_033627520.1 | 7604 | g11230 | i0 | 67.3 | 1.97492163009404 | 52 | 17 | 48.9 | 0 | 315 | 160 | 122 | 173 | XP_033627520.1 peptidyl-tRNA hydrolase 2, mitochondrial-like [Asterias rubens] | diamond | 630 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 29690719 | 29690719 | PRJNA1120771_S_NODE_14830_length_292_cov_2.096386_g14430_i0 | PRJNA1120771 | 14830 | 292 | 2.096386 | 6.12144712 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 57.8 | 2.02e-7 | NR | XP_022105289.1 | 133434 | g14430 | i0 | 42 | 0.708904109589041 | 69 | 40 | 70.9 | 0 | 22 | 228 | 153 | 221 | XP_022105289.1 vesicle transport through interaction with t-SNAREs homolog 1B-like [Acanthaster planci] | diamond | 207 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32177570 | 32177570 | PRJNA1120771_S_NODE_3758_length_479_cov_5.488532_g3366_i0 | PRJNA1120771 | 3758 | 479 | 5.488532 | 26.29006828 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 0.0028 | NR | XP_033105394.1 | 1529436 | g3366 | i0 | 33.3 | 1.55323590814196 | 54 | 33 | 33.2 | 2 | 477 | 319 | 603 | 654 | XP_033105394.1 E3 ubiquitin-protein ligase TRIM71-like [Anneissia japonica] | diamond | 744 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32283348 | 32283348 | PRJNA1120771_S_NODE_10399_length_331_cov_5.427083_g9999_i0 | PRJNA1120771 | 10399 | 331 | 5.427083 | 17.96364473 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 60.1 | 7.57e-9 | NR | AFU36096.1 | 307972 | g9999 | i0 | 33.7 | 2.39274924471299 | 89 | 59 | 80.7 | 0 | 7 | 273 | 37 | 125 | AFU36096.1 profilin [Apostichopus japonicus] | diamond | 792 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus |
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);;