contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA888821" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2138152 | 2138152 | PRJNA888821_P_NODE_23602_length_301_cov_121.232456_g23520_i0 | PRJNA888821 | 23602 | 301 | 121.232456 | 364.90969256 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 75.9 | 1.85e-14 | NR | CAD7688991.1 | 34880 | g23520 | i0 | 56.7 | 2.69102990033223 | 90 | 36 | 88.7 | 2 | 267 | 1 | 99 | 186 | CAD7688991.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 810 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 22539737 | 22539737 | PRJNA888821_P_NODE_37538_length_245_cov_0.895349_g37455_i0 | PRJNA888821 | 37538 | 245 | 0.895349 | 2.19360505 | Mus musculus | 10090 | Chordata | Chordata | 80.5 | 1.71e-15 | NR | EDL00544.1 | 10090 | g37455 | i0 | 72 | 4.89795918367347 | 50 | 14 | 61.2 | 0 | 243 | 94 | 332 | 381 | EDL00544.1 mCG142377, partial [Mus musculus] | diamond | 1200 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 28381922 | 28381922 | PRJNA888821_P_NODE_37146_length_246_cov_0.890173_g37063_i0 | PRJNA888821 | 37146 | 246 | 0.890173 | 2.18982558 | Grus japonensis | 30415 | Chordata | Chordata | 104 | 1.47e-25 | NR | GAB0201193.1 | 30415 | g37063 | i0 | 71.6 | 0.98780487804878 | 81 | 23 | 98.8 | 0 | 3 | 245 | 138 | 218 | GAB0201193.1 mannose-P-dolichol utilization defect 1 protein [Grus japonensis] | diamond | 243 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Gruiformes | Gruidae | Grus | Grus japonensis | |
| 28666233 | 28666233 | PRJNA888821_P_NODE_22327_length_308_cov_1.144681_g22245_i0 | PRJNA888821 | 22327 | 308 | 1.144681 | 3.52561748 | Gallus gallus | 9031 | Chordata | Chordata | 73.6 | 2.41e-14 | NR | CAB94241.1 | 9031 | g22245 | i0 | 50 | 0.74025974025974 | 76 | 38 | 74 | 0 | 235 | 8 | 1 | 76 | CAB94241.1 cytochrome b, partial [Gallus gallus] | diamond | 228 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 28863318 | 28863318 | PRJNA888821_P_NODE_38808_length_242_cov_1.384615_g38725_i0 | PRJNA888821 | 38808 | 242 | 1.384615 | 3.3507683 | Squamata | 8509 | Chordata | Chordata | 106 | 4.17e-28 | NR | AAC83212.1 | 63339 | g38725 | i0 | 91.1 | 160.425619834711 | 56 | 5 | 69.4 | 0 | 237 | 70 | 30 | 85 | AAC83212.1 cytochrome b, partial [Chalcides sexlineatus] | diamond | 38823 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Scincidae | Chalcides | Chalcides sexlineatus | |
| 29076729 | 29076729 | PRJNA888821_P_NODE_46848_length_215_cov_6.823944_g46765_i0 | PRJNA888821 | 46848 | 215 | 6.823944 | 14.6714796 | Ascaphus truei | 8439 | Chordata | Chordata | 41.2 | 0.0225 | NR | MEE6492174.1 | 8439 | g46765 | i0 | 44.1 | 0.474418604651163 | 34 | 19 | 47.4 | 0 | 45 | 146 | 49 | 82 | MEE6492174.1 hypothetical protein [Ascaphus truei] | diamond | 102 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 30940302 | 30940302 | PRJNA888821_P_NODE_29114_length_274_cov_1.383085_g29032_i0 | PRJNA888821 | 29114 | 274 | 1.383085 | 3.7896529 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 51.2 | 6.52e-6 | NR | CAI9154811.1 | 3082113 | g29032 | i0 | 82.1 | 0.306569343065693 | 28 | 5 | 30.7 | 0 | 273 | 190 | 73 | 100 | CAI9154811.1 unnamed protein product [Rangifer tarandus platyrhynchus] | diamond | 84 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 31129379 | 31129379 | PRJNA888821_P_NODE_38855_length_242_cov_0.911243_g38772_i0 | PRJNA888821 | 38855 | 242 | 0.911243 | 2.20520806 | Aquarana catesbeiana | 8400 | Chordata | Chordata | 115 | 9.56e-28 | NR | PIO38716.1 | 8400 | g38772 | i0 | 70 | 0.991735537190083 | 80 | 24 | 99.2 | 0 | 240 | 1 | 71 | 150 | PIO38716.1 hypothetical protein AB205_0103790, partial [Aquarana catesbeiana] | diamond | 240 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Aquarana | Aquarana catesbeiana | |
| 32426702 | 32426702 | PRJNA888821_P_NODE_36579_length_247_cov_0.885057_g36496_i0 | PRJNA888821 | 36579 | 247 | 0.885057 | 2.18609079 | Pelobates cultripes | 61616 | Chordata | Chordata | 60.8 | 1.6e-8 | NR | CAH2282881.1 | 61616 | g36496 | i0 | 100 | 1.26315789473684 | 26 | 0 | 31.6 | 0 | 239 | 162 | 944 | 969 | CAH2282881.1 nucleolar GTP-binding 1 [Pelobates cultripes] | diamond | 312 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pelobatidae | Pelobates | Pelobates cultripes |
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);;