contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA493234" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5558255 | 5558255 | PRJNA493234_S_NODE_9765_length_313_cov_1.525000_g9672_i0 | PRJNA493234 | 9765 | 313 | 1.525 | 4.77325 | Myotis myotis | 51298 | Chordata | Chordata | 103 | 1.19e-25 | NR | KAF6324851.1 | 51298 | g9672 | i0 | 53.8 | 3.9297124600639 | 104 | 48 | 99.7 | 0 | 312 | 1 | 34 | 137 | KAF6324851.1 hypothetical protein mMyoMyo1_008305 [Myotis myotis] | diamond | 1230 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis myotis | |
| 27092413 | 27092413 | PRJNA493234_S_NODE_482_length_698_cov_1.923200_g393_i0 | PRJNA493234 | 482 | 698 | 1.9232 | 13.423936 | Chiroptera | 9397 | Chordata | Chordata | 50.1 | 0.002 | NR | KAF6402188.1 | 9407 | g393 | i0 | 58.3 | 0.502865329512894 | 36 | 15 | 15.5 | 0 | 411 | 304 | 145 | 180 | KAF6402188.1 hypothetical protein HJG63_016008 [Rousettus aegyptiacus] | diamond | 351 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 27139268 | 27139268 | PRJNA493234_S_NODE_2682_length_425_cov_1.349432_g2589_i0 | PRJNA493234 | 2682 | 425 | 1.349432 | 5.735086 | Myotis myotis | 51298 | Chordata | Chordata | 93.2 | 3.01e-21 | NR | KAF6355233.1 | 51298 | g2589 | i0 | 47.1 | 3.67764705882353 | 104 | 55 | 73.4 | 0 | 360 | 49 | 5 | 108 | KAF6355233.1 hypothetical protein mMyoMyo1_011422 [Myotis myotis] | diamond | 1563 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis myotis | |
| 27708693 | 27708693 | PRJNA493234_S_NODE_384_length_758_cov_1.486131_g300_i0 | PRJNA493234 | 384 | 758 | 1.486131 | 11.26487298 | Rhinolophus ferrumequinum | 59479 | Chordata | Chordata | 58.5 | 5.29e-7 | NR | KAF6364674.1 | 59479 | g300 | i0 | 54.2 | 0.189973614775726 | 48 | 22 | 19 | 0 | 758 | 615 | 69 | 116 | KAF6364674.1 hypothetical protein mRhiFer1_009807 [Rhinolophus ferrumequinum] | diamond | 144 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Rhinolophidae | Rhinolophus | Rhinolophus ferrumequinum | |
| 27771575 | 27771575 | PRJNA493234_S_NODE_15044_length_272_cov_1.000000_g14951_i0 | PRJNA493234 | 15044 | 272 | 1 | 2.72 | Equus quagga | 89248 | Chordata | Chordata | 47.8 | 6.36e-4 | NR | XP_046505175.1 | 89248 | g14951 | i0 | 67.6 | 0.375 | 34 | 11 | 37.5 | 0 | 191 | 90 | 140 | 173 | XP_046505175.1 uncharacterized protein LOC124232253 [Equus quagga] | diamond | 102 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Equidae | Equus | Equus quagga | |
| 29507894 | 29507894 | PRJNA493234_S_NODE_20190_length_245_cov_1.075581_g20097_i0 | PRJNA493234 | 20190 | 245 | 1.075581 | 2.63517345 | Crocuta crocuta | 9678 | Chordata | Chordata | 77.8 | 4.81e-16 | NR | KAF0870498.1 | 9678 | g20097 | i0 | 52.2 | 1.6530612244898 | 69 | 33 | 84.5 | 0 | 5 | 211 | 11 | 79 | KAF0870498.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 405 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 30771701 | 30771701 | PRJNA493234_S_NODE_15074_length_271_cov_3.242424_g14981_i0 | PRJNA493234 | 15074 | 271 | 3.242424 | 8.78696904 | Bos mutus | 72004 | Chordata | Chordata | 92.4 | 1.49e-19 | NR | MXQ89774.1 | 72004 | g14981 | i0 | 100 | 0.44280442804428 | 40 | 0 | 44.3 | 0 | 116 | 235 | 71 | 110 | MXQ89774.1 hypothetical protein [Bos mutus] | diamond | 120 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos mutus | |
| 31245484 | 31245484 | PRJNA493234_S_NODE_19155_length_249_cov_0.863636_g19062_i0 | PRJNA493234 | 19155 | 249 | 0.863636 | 2.15045364 | Lynx pardinus | 191816 | Chordata | Chordata | 51.6 | 9.53e-6 | NR | VFV18845.1 | 191816 | g19062 | i0 | 42.4 | 0.795180722891566 | 66 | 35 | 75.9 | 1 | 197 | 9 | 20 | 85 | VFV18845.1 Hypothetical predicted protein [Lynx pardinus] | diamond | 198 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Lynx | Lynx pardinus | |
| 32888890 | 32888890 | PRJNA493234_S_NODE_18040_length_253_cov_0.866667_g17947_i0 | PRJNA493234 | 18040 | 253 | 0.866667 | 2.19266751 | Capra hircus | 9925 | Chordata | Chordata | 97.8 | 1.84e-21 | NR | XDB62825.1 | 9925 | g17947 | i0 | 73.1 | 0.794466403162055 | 67 | 16 | 77.1 | 1 | 199 | 5 | 1415 | 1481 | XDB62825.1 hypothetical protein ABFV05_016441 [Capra hircus] | diamond | 201 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus |
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);;