contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax_phylum = "Hemichordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26950626 | 26950626 | PRJNA520845_P_NODE_78702_length_418_cov_3.582609_g77203_i0 | PRJNA520845 | 78702 | 418 | 3.582609 | 14.97530562 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 157 | 5.92e-46 | NR | XP_002741821.1 | 10224 | g77203 | i0 | 71.2 | 47.7631578947368 | 104 | 30 | 74.6 | 0 | 314 | 3 | 12 | 115 | XP_002741821.1 PREDICTED: 60S ribosomal protein L11-like [Saccoglossus kowalevskii] | diamond | 19965 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 27740971 | 27740971 | PRJNA520845_P_NODE_196424_length_265_cov_0.927083_g194925_i0 | PRJNA520845 | 196424 | 265 | 0.927083 | 2.45676995 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 123 | 2.3e-30 | NR | XP_006816599.1 | 10224 | g194925 | i0 | 67 | 0.99622641509434 | 88 | 26 | 99.6 | 1 | 2 | 265 | 416 | 500 | XP_006816599.1 PREDICTED: LOW QUALITY PROTEIN: thimet oligopeptidase-like [Saccoglossus kowalevskii] | diamond | 264 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 27835241 | 27835241 | PRJNA520845_P_NODE_214324_length_251_cov_0.865169_g212825_i0 | PRJNA520845 | 214324 | 251 | 0.865169 | 2.17157419 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 65.1 | 5.54e-10 | NR | XP_070540415.1 | 63121 | g212825 | i0 | 40.5 | 0.944223107569721 | 79 | 45 | 94.4 | 1 | 2 | 238 | 696 | 772 | XP_070540415.1 protein-glucosylgalactosylhydroxylysine glucosidase-like [Ptychodera flava] | diamond | 237 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 27976939 | 27976939 | PRJNA520845_P_NODE_201665_length_260_cov_1.641711_g200166_i0 | PRJNA520845 | 201665 | 260 | 1.641711 | 4.2684486 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 134 | 2.27e-38 | NR | XP_070581486.1 | 63121 | g200166 | i0 | 75.6 | 39.0230769230769 | 86 | 21 | 99.2 | 0 | 2 | 259 | 34 | 119 | XP_070581486.1 late histone H2A.2.2-like [Ptychodera flava] | diamond | 10146 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 28450781 | 28450781 | PRJNA520845_P_NODE_195106_length_266_cov_1.191710_g193607_i0 | PRJNA520845 | 195106 | 266 | 1.19171 | 3.1699486 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 70.5 | 5.55e-13 | NR | XP_006820804.1 | 10224 | g193607 | i0 | 56.7 | 2.03007518796993 | 60 | 24 | 67.7 | 2 | 265 | 86 | 93 | 150 | XP_006820804.1 PREDICTED: ras-related protein Rab-7a-like [Saccoglossus kowalevskii] | diamond | 540 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 29066836 | 29066836 | PRJNA520845_P_NODE_105648_length_362_cov_1.290657_g104149_i0 | PRJNA520845 | 105648 | 362 | 1.290657 | 4.67217834 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 69.3 | 1.88e-11 | NR | XP_070535390.1 | 63121 | g104149 | i0 | 52.2 | 0.74585635359116 | 90 | 38 | 73.8 | 2 | 346 | 80 | 20 | 105 | XP_070535390.1 chromatin target of PRMT1 protein-like isoform X2 [Ptychodera flava] | diamond | 270 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 29303084 | 29303084 | PRJNA520845_P_NODE_71809_length_438_cov_2.747945_g70310_i0 | PRJNA520845 | 71809 | 438 | 2.747945 | 12.0359991 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 193 | 6.070000000000001e-59 | NR | XP_006821611.1 | 10224 | g70310 | i0 | 62.9 | 42.2260273972603 | 143 | 51 | 97.9 | 1 | 6 | 434 | 13 | 153 | XP_006821611.1 PREDICTED: 40S ribosomal protein S3a-like [Saccoglossus kowalevskii] | diamond | 18495 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 30440318 | 30440318 | PRJNA520845_P_NODE_257753_length_243_cov_0.905882_g256254_i0 | PRJNA520845 | 257753 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 72.4 | 1.38e-12 | NR | XP_006811167.1 | 10224 | g256254 | i0 | 82.1 | 1.44444444444444 | 39 | 7 | 48.1 | 0 | 1 | 117 | 1277 | 1315 | XP_006811167.1 PREDICTED: splicing factor 3B subunit 1-like [Saccoglossus kowalevskii] | diamond | 351 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 32732571 | 32732571 | PRJNA520845_P_NODE_207400_length_255_cov_2.659341_g205901_i0 | PRJNA520845 | 207400 | 255 | 2.659341 | 6.78131955 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 108 | 4.15e-25 | NR | XP_006812505.1 | 10224 | g205901 | i0 | 63.1 | 0.988235294117647 | 84 | 31 | 98.8 | 0 | 254 | 3 | 1567 | 1650 | XP_006812505.1 PREDICTED: bifunctional glutamate/proline--tRNA ligase-like [Saccoglossus kowalevskii] | diamond | 252 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 32873563 | 32873563 | PRJNA520845_P_NODE_168520_length_287_cov_1.079439_g167021_i0 | PRJNA520845 | 168520 | 287 | 1.079439 | 3.09798993 | Opisthokonta | 33154 | Hemichordata | other_Eukaryota | 86.3 | 1.9e-17 | NR | XP_070542938.1 | 63121 | g167021 | i0 | 52.3 | 10.6202090592334 | 88 | 40 | 92 | 2 | 265 | 2 | 70 | 155 | XP_070542938.1 alpha-methylacyl-CoA racemase-like [Ptychodera flava] | diamond | 3048 | 86.7 | 0.995386389850058 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava |
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);;