contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601383 | 601383 | PRJNA630162_P_NODE_108281_length_180_cov_10.412214_g106758_i0 | PRJNA630162 | 108281 | 180 | 10.412214 | 18.7419852 | Myriotrochus sp. AKM-2016 | 1902928 | Echinodermata | other_Eukaryota | 180 | 6.71e-41 | NTclustered | gi|1160550711|gb|KX856867.1| | 1902928 | g106758 | i0 | 88.079 | 83.8777777777778 | 151 | 18 | 84 | 0 | 1 | 151 | 413 | 563 | Myriotrochus sp. AKM-2016 voucher NIWA:37812 28S ribosomal RNA gene, partial sequence | blastn | 15098 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Apodida | Myriotrochidae | Myriotrochus | Myriotrochus sp. AKM-2016 | |
| 10807046 | 10807046 | PRJNA630162_P_NODE_97409_length_187_cov_1.724638_g95886_i0 | PRJNA630162 | 97409 | 187 | 1.724638 | 3.22507306 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 128 | 2.59e-25 | NTclustered | gi|2919565827|ref|XM_071625415.1| | 105358 | g95886 | i0 | 91.489 | 46.4866310160428 | 94 | 6 | 49 | 1 | 96 | 187 | 1300 | 1207 | PREDICTED: Diadema antillarum actin, cytoskeletal (LOC139713710), mRNA | blastn | 8693 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 12081777 | 12081777 | PRJNA630162_P_NODE_50250_length_249_cov_1.015000_g48727_i0 | PRJNA630162 | 50250 | 249 | 1.015 | 2.52735 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 172 | 1.66e-38 | NTclustered | gi|2037931621|ref|XM_041597485.1| | 7654 | g48727 | i0 | 86.538 | 62.3253012048193 | 156 | 21 | 63 | 0 | 10 | 165 | 313 | 158 | PREDICTED: Lytechinus variegatus histone H3, embryonic (LOC121406474), mRNA | blastn | 15519 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 18454348 | 18454348 | PRJNA630162_P_NODE_44895_length_264_cov_2.260465_g43372_i0 | PRJNA630162 | 44895 | 264 | 2.260465 | 5.9676276 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 67.6 | 8.61e-7 | NTclustered | gi|1752380844|ref|XM_030993632.1| | 7668 | g43372 | i0 | 90.196 | 0.193181818181818 | 51 | 5 | 19 | 0 | 156 | 206 | 293 | 243 | PREDICTED: Strongylocentrotus purpuratus mucin-2-like (LOC115927571), mRNA | blastn | 51 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 21004017 | 21004017 | PRJNA630162_P_NODE_130957_length_169_cov_1.450000_g129434_i0 | PRJNA630162 | 130957 | 169 | 1.45 | 2.4505 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 80.5 | 6.47e-11 | NTclustered | gi|1752345938|ref|XR_004062932.1| | 7668 | g129434 | i0 | 94.34 | 37.7869822485207 | 53 | 2 | 31 | 1 | 102 | 154 | 58 | 7 | PREDICTED: Strongylocentrotus purpuratus U2 spliceosomal RNA (LOC115917722), ncRNA | blastn | 6386 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 22278585 | 22278585 | PRJNA630162_P_NODE_115038_length_177_cov_1.453125_g113515_i0 | PRJNA630162 | 115038 | 177 | 1.453125 | 2.57203125 | Leiaster glaber | 545793 | Echinodermata | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|525531079|gb|KC512791.1| | 545793 | g113515 | i0 | 100 | 0.163841807909605 | 29 | 0 | 16 | 0 | 92 | 120 | 663 | 635 | Leiaster glaber 18S ribosomal RNA gene, partial sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Ophidiasteridae | Leiaster | Leiaster glaber | |
| 22279389 | 22279389 | PRJNA630162_P_NODE_38678_length_286_cov_12.586498_g37155_i0 | PRJNA630162 | 38678 | 286 | 12.586498 | 35.99738428 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 174 | 5.41e-39 | NTclustered | gi|11494220|gb|AF212171.1|AF212171 | 7668 | g37155 | i0 | 91.935 | 46.8881118881119 | 124 | 10 | 43 | 0 | 158 | 281 | 2885 | 2762 | Strongylocentrotus purpuratus internal transcribed spacer 2, and 28S ribosomal RNA gene, partial sequence | blastn | 13410 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 24828872 | 24828872 | PRJNA630162_P_NODE_73920_length_209_cov_2.037500_g72397_i0 | PRJNA630162 | 73920 | 209 | 2.0375 | 4.258375 | Psychropotes longicauda | 55639 | Echinodermata | other_Eukaryota | 71.3 | 5.06e-8 | NTclustered | gi|2370359|emb|Z80946.1| | 55639 | g72397 | i0 | 93.617 | 15.3684210526316 | 47 | 3 | 22 | 0 | 7 | 53 | 26 | 72 | P.longicauda partial 28S rRNA gene | blastn | 3212 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Elasipodida | Psychropotidae | Psychropotes | Psychropotes longicauda |
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);;