contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA811237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14837058 | 14837058 | PRJNA811237_S_NODE_6072_length_298_cov_4.807229_g5832_i0 | PRJNA811237 | 6072 | 298 | 4.807229 | 14.32554242 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 103 | 2.74e-26 | NR | XP_014678632.1 | 37621 | g5832 | i0 | 56.5 | 0.855704697986577 | 85 | 37 | 85.6 | 0 | 40 | 294 | 20 | 104 | XP_014678632.1 PREDICTED: thioredoxin-2-like [Priapulus caudatus] | diamond | 255 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 27370664 | 27370664 | PRJNA811237_S_NODE_8203_length_263_cov_0.953271_g7963_i0 | PRJNA811237 | 8203 | 263 | 0.953271 | 2.50710273 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 116 | 4.86e-28 | NR | XP_014680017.1 | 37621 | g7963 | i0 | 61.2 | 1.93916349809886 | 85 | 33 | 97 | 0 | 261 | 7 | 188 | 272 | XP_014680017.1 PREDICTED: neutral ceramidase-like [Priapulus caudatus] | diamond | 510 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 31950725 | 31950725 | PRJNA811237_S_NODE_13817_length_216_cov_1.317365_g13577_i0 | PRJNA811237 | 13817 | 216 | 1.317365 | 2.8455084 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 45.4 | 0.00293 | NR | XP_014675680.1 | 37621 | g13577 | i0 | 40.3 | 1.875 | 62 | 27 | 72.2 | 2 | 201 | 46 | 3 | 64 | XP_014675680.1 PREDICTED: solute carrier family 35 member F6-like isoform X2 [Priapulus caudatus] | diamond | 405 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 32718326 | 32718326 | PRJNA811237_S_NODE_21640_length_184_cov_0.948148_g21400_i0 | PRJNA811237 | 21640 | 184 | 0.948148 | 1.74459232 | Metazoa | 33208 | Priapulida | other_Eukaryota | 42 | 0.0317 | NR | XP_014667187.1 | 37621 | g21400 | i0 | 41.5 | 1.79347826086957 | 53 | 31 | 86.4 | 0 | 170 | 12 | 212 | 264 | XP_014667187.1 PREDICTED: clathrin heavy chain 1-like isoform X1 [Priapulus caudatus] | diamond | 330 | 42 | 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);;