contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJDB12578" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27000536 | 27000536 | PRJDB12578_S_NODE_104722_length_277_cov_1.947368_g81664_i0 | PRJDB12578 | 104722 | 277 | 1.947368 | 5.39420936 | Suricata suricatta | 37032 | Chordata | Chordata | 43.1 | 0.0412 | NR | XP_029786834.1 | 37032 | g81664 | i0 | 36.4 | 0.714801444043321 | 66 | 34 | 62.8 | 1 | 57 | 230 | 483 | 548 | XP_029786834.1 cohesin subunit SA-2-like [Suricata suricatta] | diamond | 198 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Herpestidae | Suricata | Suricata suricatta | |
| 27285246 | 27285246 | PRJDB12578_S_NODE_117363_length_248_cov_1.804020_g94305_i0 | PRJDB12578 | 117363 | 248 | 1.80402 | 4.4739696 | Myotis daubentonii | 98922 | Chordata | Chordata | 47.8 | 6.85e-4 | NR | XP_059554471.1 | 98922 | g94305 | i0 | 54.3 | 1.05241935483871 | 35 | 16 | 42.3 | 0 | 49 | 153 | 831 | 865 | XP_059554471.1 bromodomain-containing protein 8 isoform X9 [Myotis daubentonii] | diamond | 261 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis daubentonii | |
| 29268488 | 29268488 | PRJDB12578_S_NODE_189669_length_171_cov_1.672131_g166611_i0 | PRJDB12578 | 189669 | 171 | 1.672131 | 2.85934401 | Vespertilionidae | 9431 | Chordata | Chordata | 53.1 | 2.99e-6 | NR | KAF6336799.1 | 51298 | g166611 | i0 | 73.3 | 4.80701754385965 | 30 | 8 | 52.6 | 0 | 4 | 93 | 34 | 63 | KAF6336799.1 hypothetical protein mMyoMyo1_012021 [Myotis myotis] | diamond | 822 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis myotis | |
| 29527153 | 29527153 | PRJDB12578_S_NODE_104470_length_278_cov_1.462882_g81412_i0 | PRJDB12578 | 104470 | 278 | 1.462882 | 4.06681196 | Pelodiscus sinensis | 13735 | Chordata | Chordata | 53.1 | 5.71e-6 | NR | XP_025033872.1 | 13735 | g81412 | i0 | 59 | 0.420863309352518 | 39 | 16 | 42.1 | 0 | 162 | 278 | 74 | 112 | XP_025033872.1 zinc finger MYM-type protein 5-like [Pelodiscus sinensis] | diamond | 117 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Trionychidae | Pelodiscus | Pelodiscus sinensis | ||
| 29589905 | 29589905 | PRJDB12578_S_NODE_157650_length_196_cov_1.061224_g134592_i0 | PRJDB12578 | 157650 | 196 | 1.061224 | 2.07999904 | Phrynocephalus forsythii | 171643 | Chordata | Chordata | 56.6 | 1.36e-7 | NR | KAJ7344823.1 | 171643 | g134592 | i0 | 55 | 9.18367346938776 | 60 | 20 | 87.2 | 3 | 3 | 173 | 96 | 151 | KAJ7344823.1 hypothetical protein JRQ81_000773 [Phrynocephalus forsythii] | diamond | 1800 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Agamidae | Phrynocephalus | Phrynocephalus forsythii | |
| 29906200 | 29906200 | PRJDB12578_S_NODE_125191_length_234_cov_1.486486_g102133_i0 | PRJDB12578 | 125191 | 234 | 1.486486 | 3.47837724 | Hemicordylus capensis | 884348 | Chordata | Chordata | 43.1 | 0.024 | NR | XP_053145196.1 | 884348 | g102133 | i0 | 36.9 | 1.66666666666667 | 65 | 40 | 82.1 | 1 | 41 | 232 | 228 | 292 | XP_053145196.1 dendrin isoform X2 [Hemicordylus capensis] | diamond | 390 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Cordylidae | Hemicordylus | Hemicordylus capensis | |
| 30917256 | 30917256 | PRJDB12578_S_NODE_177834_length_179_cov_1.992308_g154776_i0 | PRJDB12578 | 177834 | 179 | 1.992308 | 3.56623132 | Rhabdornis inornatus | 237438 | Chordata | Chordata | 40.4 | 0.0437 | NR | NXH61994.1 | 237438 | g154776 | i0 | 43.6 | 0.653631284916201 | 39 | 22 | 65.4 | 0 | 42 | 158 | 56 | 94 | NXH61994.1 LYPD3 protein [Rhabdornis inornatus] | diamond | 117 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Rhabdornithidae | Rhabdornis | Rhabdornis inornatus | |
| 31069388 | 31069388 | PRJDB12578_S_NODE_205395_length_165_cov_0.887931_g182337_i0 | PRJDB12578 | 205395 | 165 | 0.887931 | 1.46508615 | Anura | 8342 | Chordata | Chordata | 70.5 | 2.04e-12 | NR | XP_040264739.1 | 8384 | g182337 | i0 | 67.3 | 8 | 55 | 16 | 96.4 | 1 | 161 | 3 | 177 | 231 | XP_040264739.1 zinc finger MYM-type protein 1-like [Bufo bufo] | diamond | 1320 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo bufo | |
| 31644081 | 31644081 | PRJDB12578_S_NODE_84397_length_363_cov_0.863057_g61339_i0 | PRJDB12578 | 84397 | 363 | 0.863057 | 3.13289691 | Bufotes viridis | 30338 | Chordata | Chordata | 45.4 | 0.0148 | NR | CAK8629749.1 | 30338 | g61339 | i0 | 64.7 | 0.28099173553719 | 34 | 12 | 28.1 | 0 | 192 | 91 | 331 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 102 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31897307 | 31897307 | PRJDB12578_S_NODE_79437_length_398_cov_1.653295_g56380_i0 | PRJDB12578 | 79437 | 398 | 1.653295 | 6.5801141 | Mustela nigripes | 77151 | Chordata | Chordata | 50.4 | 3.36e-4 | NR | XP_059238664.1 | 77151 | g56380 | i0 | 75 | 0.422110552763819 | 28 | 7 | 21.1 | 0 | 7 | 90 | 45 | 72 | XP_059238664.1 LOW QUALITY PROTEIN: zinc finger protein 502-like [Mustela nigripes] | diamond | 168 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Mustela | Mustela nigripes | |
| 32781990 | 32781990 | PRJDB12578_S_NODE_111840_length_259_cov_3.061905_g88782_i0 | PRJDB12578 | 111840 | 259 | 3.061905 | 7.93033395 | Ornithorhynchus anatinus | 9258 | Chordata | Chordata | 43.5 | 0.0249 | NR | XP_028912852.1 | 9258 | g88782 | i0 | 32.9 | 2.40926640926641 | 70 | 42 | 75.3 | 1 | 58 | 252 | 657 | 726 | XP_028912852.1 lysosomal alpha-glucosidase isoform X1 [Ornithorhynchus anatinus] | diamond | 624 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Monotremata | Ornithorhynchidae | Ornithorhynchus | Ornithorhynchus anatinus |
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);;