contig_metadata
8 rows where bioproject = "PRJNA685607" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3217265 | 3217265 | PRJNA685607_P_NODE_63263_length_254_cov_0.812155_g62904_i0 | PRJNA685607 | 63263 | 254 | 0.812155 | 2.0628737 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 139 | 2.09e-38 | NR | XP_011675730.2 | 7668 | g62904 | i0 | 73.5 | 0.980314960629921 | 83 | 22 | 98 | 0 | 253 | 5 | 107 | 189 | XP_011675730.2 cathepsin Z [Strongylocentrotus purpuratus] | diamond | 249 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 13420236 | 13420236 | PRJNA685607_P_NODE_2731_length_954_cov_2.431328_g2465_i0 | PRJNA685607 | 2731 | 954 | 2.431328 | 23.19486912 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 239 | 4.94e-75 | NR | XP_033640423.1 | 7604 | g2465 | i0 | 72.4 | 9.18553459119497 | 170 | 47 | 53.5 | 0 | 40 | 549 | 2 | 171 | XP_033640423.1 60S ribosomal protein L19-like [Asterias rubens] | diamond | 8763 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 23619309 | 23619309 | PRJNA685607_P_NODE_81639_length_246_cov_0.884393_g81280_i0 | PRJNA685607 | 81639 | 246 | 0.884393 | 2.17560678 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|1944844666|ref|XM_038192468.1| | 46514 | g81280 | i0 | 100 | 0.117886178861789 | 29 | 0 | 12 | 0 | 133 | 161 | 3037 | 3065 | PREDICTED: Patiria miniata Golgi-associated kinase 1B-like (LOC119722389), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27335245 | 27335245 | PRJNA685607_P_NODE_62443_length_255_cov_1.269231_g62084_i0 | PRJNA685607 | 62443 | 255 | 1.269231 | 3.23653905 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 68.6 | 3.31e-11 | NR | XP_071486789.1 | 105358 | g62084 | i0 | 44.3 | 1.78823529411765 | 79 | 42 | 90.6 | 1 | 236 | 6 | 147 | 225 | XP_071486789.1 SEC14-like protein 2 [Diadema antillarum] | diamond | 456 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28250647 | 28250647 | PRJNA685607_P_NODE_70986_length_249_cov_0.875000_g70627_i0 | PRJNA685607 | 70986 | 249 | 0.875 | 2.17875 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 69.7 | 4.94e-12 | NR | KAJ8035766.1 | 206669 | g70627 | i0 | 68.3 | 11.9277108433735 | 41 | 13 | 49.4 | 0 | 2 | 124 | 18 | 58 | KAJ8035766.1 LIM and SH3 domain protein 1 [Holothuria leucospilota] | diamond | 2970 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29430368 | 29430368 | PRJNA685607_P_NODE_43829_length_291_cov_1.059633_g43470_i0 | PRJNA685607 | 43829 | 291 | 1.059633 | 3.08353203 | Asteroidea | 7588 | Echinodermata | other_Eukaryota | 62 | 1.07e-8 | NR | XP_033644569.1 | 7604 | g43470 | i0 | 34.7 | 2.02061855670103 | 98 | 57 | 97.9 | 3 | 286 | 2 | 218 | 311 | XP_033644569.1 DNA primase large subunit-like [Asterias rubens] | diamond | 588 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32211994 | 32211994 | PRJNA685607_P_NODE_70598_length_249_cov_0.875000_g70239_i0 | PRJNA685607 | 70598 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 92.8 | 2.44e-20 | NR | KAJ8028803.1 | 206669 | g70239 | i0 | 54.9 | 2.92771084337349 | 82 | 34 | 98.8 | 2 | 246 | 1 | 218 | 296 | KAJ8028803.1 Aminoacyl tRNA synthase complex-interacting multifunctional protein 1 [Holothuria leucospilota] | diamond | 729 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32243889 | 32243889 | PRJNA685607_P_NODE_35578_length_312_cov_1.481172_g35219_i0 | PRJNA685607 | 35578 | 312 | 1.481172 | 4.62125664 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 104 | 1.9e-23 | NR | XP_041481008.1 | 7654 | g35219 | i0 | 54 | 26.1730769230769 | 100 | 45 | 95.2 | 1 | 310 | 14 | 528 | 627 | XP_041481008.1 endoplasmic reticulum chaperone BiP-like [Lytechinus variegatus] | diamond | 8166 | 105 | 0.990476190476191 | 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);;