contig_metadata
21 rows where bioproject = "PRJNA508758", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 484422 | 484422 | PRJNA508758_P_NODE_2241_length_1705_cov_8.155025_g1949_i0 | PRJNA508758 | 2241 | 1705 | 8.155025 | 139.04317625 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 231 | 1.25e-64 | NR | XP_022102187.1 | 133434 | g1949 | i0 | 37.7 | 0.658064516129032 | 374 | 197 | 64.2 | 8 | 109 | 1203 | 17 | 363 | XP_022102187.1 membrane-associated tyrosine- and threonine-specific cdc2-inhibitory kinase-like [Acanthaster planci] | diamond | 1122 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 1759722 | 1759722 | PRJNA508758_P_NODE_33842_length_352_cov_1.627240_g32794_i0 | PRJNA508758 | 33842 | 352 | 1.62724 | 5.7278848 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 137 | 8.93e-28 | NTclustered | gi|1944827475|ref|XM_038210196.1| | 46514 | g32794 | i0 | 90.385 | 12.0568181818182 | 104 | 10 | 30 | 0 | 249 | 352 | 550 | 447 | PREDICTED: Patiria miniata calmodulin (LOC119736170), mRNA | blastn | 4244 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 5588220 | 5588220 | PRJNA508758_P_NODE_2385_length_1654_cov_8.647059_g1949_i1 | PRJNA508758 | 2385 | 1654 | 8.647059 | 143.02235586 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 238 | 2.8399999999999998e-67 | NR | XP_022102187.1 | 133434 | g1949 | i1 | 39.5 | 0.647521160822249 | 357 | 197 | 63.1 | 8 | 109 | 1152 | 17 | 363 | XP_022102187.1 membrane-associated tyrosine- and threonine-specific cdc2-inhibitory kinase-like [Acanthaster planci] | diamond | 1071 | 238 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 14513873 | 14513873 | PRJNA508758_P_NODE_8652_length_752_cov_2.266568_g7721_i0 | PRJNA508758 | 8652 | 752 | 2.266568 | 17.04459136 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 1175 | 0 | NTclustered | gi|1826640151|ref|XM_033252220.1| | 1529436 | g7721 | i0 | 94.855 | 15.9654255319149 | 758 | 30 | 100 | 2 | 1 | 752 | 969 | 215 | PREDICTED: Anneissia japonica tigger transposable element-derived protein 4-like (LOC117109799), mRNA | blastn | 12006 | 1175 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 19610422 | 19610422 | PRJNA508758_P_NODE_21676_length_431_cov_2.734637_g20629_i0 | PRJNA508758 | 21676 | 431 | 2.734637 | 11.78628547 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.042 | NTclustered | gi|1944816250|ref|XM_038206001.1| | 46514 | g20629 | i0 | 100 | 0.0649651972157773 | 28 | 0 | 6 | 0 | 367 | 394 | 2323 | 2350 | PREDICTED: Patiria miniata uncharacterized LOC119732441 (LOC119732441), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26792398 | 26792398 | PRJNA508758_P_NODE_61041_length_275_cov_3.079208_g59993_i0 | PRJNA508758 | 61041 | 275 | 3.079208 | 8.467822 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 79 | 1.04e-14 | NR | XP_022107482.1 | 133434 | g59993 | i0 | 62.3 | 3.65454545454545 | 53 | 20 | 57.8 | 0 | 39 | 197 | 685 | 737 | XP_022107482.1 mitogen-activated protein kinase-binding protein 1-like isoform X2 [Acanthaster planci] | diamond | 1005 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27123855 | 27123855 | PRJNA508758_P_NODE_9282_length_716_cov_2.727838_g8333_i0 | PRJNA508758 | 9282 | 716 | 2.727838 | 19.53132008 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 82.4 | 7.2e-14 | NR | XP_071476292.1 | 105358 | g8333 | i0 | 37.1 | 1.00977653631285 | 116 | 73 | 48.6 | 0 | 676 | 329 | 267 | 382 | XP_071476292.1 uncharacterized protein [Diadema antillarum] | diamond | 723 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27772324 | 27772324 | PRJNA508758_P_NODE_7184_length_860_cov_2.377382_g6331_i0 | PRJNA508758 | 7184 | 860 | 2.377382 | 20.4454852 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 353 | 7.779999999999998e-115 | NR | PIK55727.1 | 307972 | g6331 | i0 | 58.2 | 0.959302325581395 | 275 | 115 | 95.9 | 0 | 825 | 1 | 164 | 438 | PIK55727.1 hypothetical protein BSL78_07387 [Apostichopus japonicus] | diamond | 825 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 28766209 | 28766209 | PRJNA508758_P_NODE_38087_length_336_cov_1.045627_g37039_i0 | PRJNA508758 | 38087 | 336 | 1.045627 | 3.51330672 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 70.1 | 2.86e-11 | NR | XP_063956696.1 | 7653 | g37039 | i0 | 40.8 | 11.1964285714286 | 98 | 56 | 85.7 | 1 | 6 | 293 | 1098 | 1195 | XP_063956696.1 uncharacterized protein LOC135154469 [Lytechinus pictus] | diamond | 3762 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 29003922 | 29003922 | PRJNA508758_P_NODE_15368_length_521_cov_1.517857_g14330_i0 | PRJNA508758 | 15368 | 521 | 1.517857 | 7.90803497 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 53.5 | 7.09e-5 | NR | XP_063966137.1 | 7653 | g14330 | i0 | 39.7 | 0.449136276391555 | 78 | 43 | 44.3 | 2 | 238 | 8 | 77 | 151 | XP_063966137.1 uncharacterized protein LOC135156777 [Lytechinus pictus] | diamond | 234 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 29129970 | 29129970 | PRJNA508758_P_NODE_14449_length_540_cov_4.381156_g13426_i0 | PRJNA508758 | 14449 | 540 | 4.381156 | 23.6582424 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 172 | 5.37e-46 | NR | KAJ8026909.1 | 206669 | g13426 | i0 | 53 | 19.1833333333333 | 168 | 68 | 92.2 | 2 | 500 | 3 | 431 | 589 | KAJ8026909.1 hypothetical protein HOLleu_31873 [Holothuria leucospilota] | diamond | 10359 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29982345 | 29982345 | PRJNA508758_P_NODE_66091_length_266_cov_0.953368_g65043_i0 | PRJNA508758 | 66091 | 266 | 0.953368 | 2.53595888 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 50.8 | 6.76e-5 | NR | XP_033121729.1 | 1529436 | g65043 | i0 | 52.5 | 0.451127819548872 | 40 | 19 | 45.1 | 0 | 120 | 1 | 252 | 291 | XP_033121729.1 LOW QUALITY PROTEIN: ankyrin repeat and BTB/POZ domain-containing protein 1-like [Anneissia japonica] | diamond | 120 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30108658 | 30108658 | PRJNA508758_P_NODE_28532_length_379_cov_1.346405_g27484_i0 | PRJNA508758 | 28532 | 379 | 1.346405 | 5.10287495 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 68.6 | 1.48e-11 | NR | XP_038077397.1 | 46514 | g27484 | i0 | 40.8 | 3.26912928759894 | 98 | 57 | 76.8 | 1 | 54 | 344 | 20 | 117 | XP_038077397.1 tigger transposable element-derived protein 4-like [Patiria miniata] | diamond | 1239 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30298759 | 30298759 | PRJNA508758_P_NODE_4852_length_1106_cov_4.176186_g4256_i0 | PRJNA508758 | 4852 | 1106 | 4.176186 | 46.18861716 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 167 | 1.9199999999999998e-42 | NR | XP_787078.3 | 7668 | g4256 | i0 | 43.2 | 1.34538878842676 | 243 | 126 | 63.5 | 5 | 122 | 823 | 332 | 571 | XP_787078.3 sodium-dependent multivitamin transporter [Strongylocentrotus purpuratus] | diamond | 1488 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30361933 | 30361933 | PRJNA508758_P_NODE_392_length_3321_cov_3.520320_g328_i0 | PRJNA508758 | 392 | 3321 | 3.52032 | 116.9098272 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 102 | 1.12e-17 | NR | KAJ8038071.1 | 206669 | g328 | i0 | 23.5 | 0.402890695573622 | 446 | 303 | 38.6 | 17 | 6 | 1286 | 1980 | 2406 | KAJ8038071.1 Neurogenic locus notch-like protein 1 [Holothuria leucospilota] | diamond | 1338 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30961902 | 30961902 | PRJNA508758_P_NODE_85314_length_243_cov_0.905882_g84266_i0 | PRJNA508758 | 85314 | 243 | 0.905882 | 2.20129326 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 70.5 | 6.1e-12 | NR | KAJ8042837.1 | 206669 | g84266 | i0 | 54.8 | 2.2962962962963 | 62 | 26 | 76.5 | 1 | 241 | 56 | 472 | 531 | KAJ8042837.1 T-complex protein 1 subunit zeta [Holothuria leucospilota] | diamond | 558 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31261644 | 31261644 | PRJNA508758_P_NODE_58055_length_282_cov_1.105263_g57007_i0 | PRJNA508758 | 58055 | 282 | 1.105263 | 3.11684166 | root | 1 | Root_unresolved | Root_unresolved | 87.8 | 8.59e-18 | NR | PIK46281.1 | 307972 | g57007 | i0 | 50 | 7.1063829787234 | 82 | 41 | 87.2 | 0 | 248 | 3 | 819 | 900 | PIK46281.1 putative transposon Ty3-I Gag-Pol polyprotein [Apostichopus japonicus] | diamond | 2004 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31341096 | 31341096 | PRJNA508758_P_NODE_20516_length_444_cov_1.719677_g19469_i0 | PRJNA508758 | 20516 | 444 | 1.719677 | 7.63536588 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 164 | 9.98e-44 | NR | XP_063962087.1 | 7653 | g19469 | i0 | 53.3 | 1.02702702702703 | 152 | 66 | 99.3 | 1 | 444 | 4 | 718 | 869 | XP_063962087.1 uncharacterized protein LOC135155782 [Lytechinus pictus] | diamond | 456 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 31720638 | 31720638 | PRJNA508758_P_NODE_34757_length_348_cov_1.949091_g33709_i0 | PRJNA508758 | 34757 | 348 | 1.949091 | 6.78283668 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 70.1 | 3.33e-11 | NR | XP_038072722.1 | 46514 | g33709 | i0 | 60 | 0.775862068965517 | 45 | 18 | 38.8 | 0 | 2 | 136 | 520 | 564 | XP_038072722.1 fibrillin-2-like isoform X1 [Patiria miniata] | diamond | 270 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31815476 | 31815476 | PRJNA508758_P_NODE_13397_length_567_cov_1.277328_g12383_i0 | PRJNA508758 | 13397 | 567 | 1.277328 | 7.24244976 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 60.1 | 7.47e-7 | NR | XP_022085069.1 | 133434 | g12383 | i0 | 54.1 | 0.968253968253968 | 61 | 28 | 32.3 | 0 | 2 | 184 | 338 | 398 | XP_022085069.1 LIM/homeobox protein Lhx9-like [Acanthaster planci] | diamond | 549 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32669219 | 32669219 | PRJNA508758_P_NODE_24180_length_409_cov_1.086310_g23132_i0 | PRJNA508758 | 24180 | 409 | 1.08631 | 4.4430079 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 146 | 1.0399999999999998e-37 | NR | XP_038077304.1 | 46514 | g23132 | i0 | 72.4 | 15.6968215158924 | 98 | 27 | 71.9 | 0 | 408 | 115 | 484 | 581 | XP_038077304.1 uncharacterized protein LOC119745152 [Patiria miniata] | diamond | 6420 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;