contig_metadata
14 rows where bioproject = "PRJNA1035005", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12922533 | 12922533 | PRJNA1035005_P_NODE_35451_length_275_cov_1.930693_g35045_i0 | PRJNA1035005 | 35451 | 275 | 1.930693 | 5.30940575 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|1826622945|ref|XR_004444679.1| | 1529436 | g35045 | i0 | 100 | 0.101818181818182 | 28 | 0 | 10 | 0 | 16 | 43 | 553 | 526 | PREDICTED: Anneissia japonica uncharacterized LOC117103909 (LOC117103909), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27572270 | 27572270 | PRJNA1035005_P_NODE_76644_length_245_cov_0.906977_g76238_i0 | PRJNA1035005 | 76644 | 245 | 0.906977 | 2.22209365 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 69.3 | 6.26e-12 | NR | KAJ8042686.1 | 206669 | g76238 | i0 | 46.8 | 0.942857142857143 | 77 | 40 | 94.3 | 1 | 242 | 12 | 17 | 92 | KAJ8042686.1 60S ribosomal protein L6 [Holothuria leucospilota] | diamond | 231 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27690992 | 27690992 | PRJNA1035005_P_NODE_65184_length_249_cov_0.886364_g64778_i0 | PRJNA1035005 | 65184 | 249 | 0.886364 | 2.20704636 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 104 | 8.499999999999999e-24 | NR | XP_033634554.1 | 7604 | g64778 | i0 | 60 | 10.7469879518072 | 80 | 32 | 96.4 | 0 | 244 | 5 | 608 | 687 | XP_033634554.1 elongation factor-like GTPase 1 [Asterias rubens] | diamond | 2676 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27911367 | 27911367 | PRJNA1035005_P_NODE_12545_length_340_cov_1.460674_g12140_i0 | PRJNA1035005 | 12545 | 340 | 1.460674 | 4.9662916 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 167 | 1.13e-46 | NR | KAJ8035209.1 | 206669 | g12140 | i0 | 71.2 | 7.72058823529412 | 111 | 32 | 97.9 | 0 | 1 | 333 | 271 | 381 | KAJ8035209.1 Cystathionine beta-synthase [Holothuria leucospilota] | diamond | 2625 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28140883 | 28140883 | PRJNA1035005_P_NODE_21945_length_293_cov_2.313636_g21539_i0 | PRJNA1035005 | 21945 | 293 | 2.313636 | 6.77895348 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 91.7 | 1.32e-20 | NR | XP_041471633.1 | 7654 | g21539 | i0 | 49.5 | 0.993174061433447 | 97 | 48 | 99.3 | 1 | 292 | 2 | 4 | 99 | XP_041471633.1 quinone reductase-like [Lytechinus variegatus] | diamond | 291 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28488047 | 28488047 | PRJNA1035005_P_NODE_4707_length_491_cov_1.906699_g4307_i0 | PRJNA1035005 | 4707 | 491 | 1.906699 | 9.36189209 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 60.5 | 3.07e-7 | NR | XP_038074569.1 | 46514 | g4307 | i0 | 26.8 | 0.959266802443992 | 157 | 98 | 90.4 | 4 | 6 | 449 | 41 | 189 | XP_038074569.1 dye-decolorizing peroxidase msp1-like [Patiria miniata] | diamond | 471 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28930002 | 28930002 | PRJNA1035005_P_NODE_2928_length_649_cov_1.368056_g2539_i0 | PRJNA1035005 | 2928 | 649 | 1.368056 | 8.87868344 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 115 | 9.83e-26 | NR | KAJ8019731.1 | 206669 | g2539 | i0 | 35.8 | 0.993836671802773 | 215 | 124 | 97.1 | 9 | 3 | 632 | 1015 | 1220 | KAJ8019731.1 A disintegrin and metalloproteinase with thrombospondin motifs 20 [Holothuria leucospilota] | diamond | 645 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29308781 | 29308781 | PRJNA1035005_P_NODE_85489_length_242_cov_0.923077_g85083_i0 | PRJNA1035005 | 85489 | 242 | 0.923077 | 2.23384634 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 61.6 | 7.91e-9 | NR | PIK52582.1 | 307972 | g85083 | i0 | 49 | 1.21487603305785 | 49 | 25 | 60.7 | 0 | 3 | 149 | 35 | 83 | PIK52582.1 hypothetical protein BSL78_10524 [Apostichopus japonicus] | diamond | 294 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 30098255 | 30098255 | PRJNA1035005_P_NODE_67092_length_248_cov_1.411429_g66686_i0 | PRJNA1035005 | 67092 | 248 | 1.411429 | 3.50034392 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 82.8 | 3.1e-16 | NR | XP_041455728.1 | 7654 | g66686 | i0 | 46.9 | 2.89112903225806 | 81 | 37 | 90.7 | 2 | 225 | 1 | 486 | 566 | XP_041455728.1 piggyBac transposable element-derived protein 4-like [Lytechinus variegatus] | diamond | 717 | 83.6 | 0.990430622009569 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30161311 | 30161311 | PRJNA1035005_P_NODE_47652_length_260_cov_1.251337_g47246_i0 | PRJNA1035005 | 47652 | 260 | 1.251337 | 3.2534762 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 65.9 | 8.21e-11 | NR | XP_033630533.1 | 7604 | g47246 | i0 | 51.4 | 1.58076923076923 | 70 | 33 | 79.6 | 1 | 207 | 1 | 2 | 71 | XP_033630533.1 apolipoprotein D-like [Asterias rubens] | diamond | 411 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31290963 | 31290963 | PRJNA1035005_P_NODE_16135_length_316_cov_2.481481_g15729_i0 | PRJNA1035005 | 16135 | 316 | 2.481481 | 7.84147996 | root | 1 | Root_unresolved | Root_unresolved | 114 | 6.08e-28 | NR | XP_041463380.1 | 7654 | g15729 | i0 | 59.4 | 2.98101265822785 | 106 | 41 | 98.7 | 1 | 3 | 314 | 230 | 335 | XP_041463380.1 aqualysin-1-like [Lytechinus variegatus] | diamond | 942 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31394146 | 31394146 | PRJNA1035005_P_NODE_60196_length_251_cov_0.876404_g59790_i0 | PRJNA1035005 | 60196 | 251 | 0.876404 | 2.19977404 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 51.6 | 3.06e-5 | NR | XP_071492921.1 | 105358 | g59790 | i0 | 45.6 | 0.681274900398406 | 57 | 31 | 68.1 | 0 | 171 | 1 | 443 | 499 | XP_071492921.1 calcyphosin-2-like [Diadema antillarum] | diamond | 171 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32525222 | 32525222 | PRJNA1035005_P_NODE_3199_length_613_cov_6.235185_g2809_i0 | PRJNA1035005 | 3199 | 613 | 6.235185 | 38.22168405 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 153 | 5.23e-44 | NR | XP_033632396.1 | 7604 | g2809 | i0 | 66.1 | 4.05709624796085 | 118 | 40 | 57.7 | 0 | 532 | 179 | 5 | 122 | XP_033632396.1 60S ribosomal protein L31-like [Asterias rubens] | diamond | 2487 | 154 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32596105 | 32596105 | PRJNA1035005_P_NODE_22620_length_292_cov_1.424658_g22214_i0 | PRJNA1035005 | 22620 | 292 | 1.424658 | 4.16000136 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 48.1 | 8.32e-4 | NR | XP_041458312.1 | 7654 | g22214 | i0 | 50 | 0.513698630136986 | 50 | 22 | 48.3 | 1 | 31 | 171 | 212 | 261 | XP_041458312.1 uncharacterized protein KIAA1958-like [Lytechinus variegatus] | diamond | 150 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus |
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);;