contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax_phylum = "Priapulida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1111187 | 1111187 | PRJNA520845_P_NODE_128381_length_329_cov_3.515625_g126882_i0 | PRJNA520845 | 128381 | 329 | 3.515625 | 11.56640625 | Metazoa | 33208 | Priapulida | other_Eukaryota | 150 | 4.59e-44 | NR | XP_014672972.1 | 37621 | g126882 | i0 | 77.4 | 14.8085106382979 | 93 | 21 | 84.8 | 0 | 35 | 313 | 1 | 93 | XP_014672972.1 PREDICTED: 60S ribosomal protein L12-like [Priapulus caudatus] | diamond | 4872 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 15139296 | 15139296 | PRJNA520845_P_NODE_141272_length_314_cov_1.821577_g139773_i0 | PRJNA520845 | 141272 | 314 | 1.821577 | 5.71975178 | Metazoa | 33208 | Priapulida | other_Eukaryota | 138 | 1.21e-35 | NR | XP_014679368.1 | 37621 | g139773 | i0 | 64.4 | 67.5668789808917 | 104 | 37 | 99.4 | 0 | 313 | 2 | 263 | 366 | XP_014679368.1 PREDICTED: polyadenylate-binding protein 4-like [Priapulus caudatus] | diamond | 21216 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 27425156 | 27425156 | PRJNA520845_P_NODE_239823_length_246_cov_0.890173_g238324_i0 | PRJNA520845 | 239823 | 246 | 0.890173 | 2.18982558 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 44.7 | 0.00807 | NR | XP_014664866.1 | 37621 | g238324 | i0 | 38.9 | 0.658536585365854 | 54 | 33 | 65.9 | 0 | 2 | 163 | 144 | 197 | XP_014664866.1 PREDICTED: protein phosphatase 1 regulatory subunit 37-like [Priapulus caudatus] | diamond | 162 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 28119432 | 28119432 | PRJNA520845_P_NODE_113405_length_350_cov_1.090253_g111906_i0 | PRJNA520845 | 113405 | 350 | 1.090253 | 3.8158855 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 60.8 | 5.75e-8 | NR | XP_014671853.1 | 37621 | g111906 | i0 | 54.3 | 1.70571428571429 | 46 | 21 | 39.4 | 0 | 18 | 155 | 304 | 349 | XP_014671853.1 PREDICTED: delta-like protein D isoform X2 [Priapulus caudatus] | diamond | 597 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 28403710 | 28403710 | PRJNA520845_P_NODE_206006_length_257_cov_1.086957_g204507_i0 | PRJNA520845 | 206006 | 257 | 1.086957 | 2.79347949 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 68.6 | 3.37e-11 | NR | XP_014677075.1 | 37621 | g204507 | i0 | 50 | 0.88715953307393 | 76 | 37 | 87.5 | 1 | 237 | 13 | 200 | 275 | XP_014677075.1 PREDICTED: cytoplasmic dynein 1 light intermediate chain 2-like [Priapulus caudatus] | diamond | 228 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 29950993 | 29950993 | PRJNA520845_P_NODE_93711_length_384_cov_0.971061_g92212_i0 | PRJNA520845 | 93711 | 384 | 0.971061 | 3.72887424 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 63.2 | 1.26e-8 | NR | XP_014665309.1 | 37621 | g92212 | i0 | 30.1 | 1.984375 | 133 | 80 | 98.4 | 4 | 379 | 2 | 30 | 156 | XP_014665309.1 PREDICTED: spindle assembly abnormal protein 6 homolog [Priapulus caudatus] | diamond | 762 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 30519602 | 30519602 | PRJNA520845_P_NODE_209573_length_254_cov_1.276243_g208074_i0 | PRJNA520845 | 209573 | 254 | 1.276243 | 3.24165722 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 66.2 | 2.23e-10 | NR | XP_014670796.1 | 37621 | g208074 | i0 | 53.2 | 1.46456692913386 | 62 | 26 | 69.7 | 1 | 179 | 3 | 560 | 621 | XP_014670796.1 PREDICTED: uncharacterized protein LOC106811606 [Priapulus caudatus] | diamond | 372 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 31088287 | 31088287 | PRJNA520845_P_NODE_154135_length_300_cov_2.035242_g152636_i0 | PRJNA520845 | 154135 | 300 | 2.035242 | 6.105726 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 108 | 3.38e-26 | NR | XP_014666477.1 | 37621 | g152636 | i0 | 67.1 | 0.73 | 73 | 24 | 73 | 0 | 3 | 221 | 147 | 219 | XP_014666477.1 PREDICTED: 40S ribosomal protein SA-like [Priapulus caudatus] | diamond | 219 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus |
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);;