contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1054617" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26623710 | 26623710 | PRJNA1054617_S_NODE_4161_length_262_cov_1.260274_g4073_i0 | PRJNA1054617 | 4161 | 262 | 1.260274 | 3.30191788 | Petaurus breviceps papuanus | 3040969 | Chordata | Chordata | 53.1 | 1.04e-5 | NR | XP_068961427.1 | 3040969 | g4073 | i0 | 46.3 | 1.23664122137405 | 54 | 29 | 61.8 | 0 | 208 | 47 | 776 | 829 | XP_068961427.1 centromere protein C isoform X8 [Petaurus breviceps papuanus] | diamond | 324 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Diprotodontia | Petauridae | Petaurus | Petaurus breviceps | |
| 27129729 | 27129729 | PRJNA1054617_S_NODE_13482_length_161_cov_3.694915_g13394_i0 | PRJNA1054617 | 13482 | 161 | 3.694915 | 5.94881315 | Ranitomeya imitator | 111125 | Chordata | Chordata | 41.2 | 0.0437 | NR | CAJ0961913.1 | 111125 | g13394 | i0 | 58.1 | 2.31055900621118 | 31 | 13 | 57.8 | 0 | 161 | 69 | 783 | 813 | CAJ0961913.1 unnamed protein product [Ranitomeya imitator] | diamond | 372 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 27446413 | 27446413 | PRJNA1054617_S_NODE_10083_length_183_cov_0.985714_g9995_i0 | PRJNA1054617 | 10083 | 183 | 0.985714 | 1.80385662 | Bos mutus | 72004 | Chordata | Chordata | 52.4 | 1.8e-6 | NR | MXQ86104.1 | 72004 | g9995 | i0 | 90.9 | 0.360655737704918 | 22 | 2 | 36.1 | 0 | 68 | 3 | 98 | 119 | MXQ86104.1 hypothetical protein [Bos mutus] | diamond | 66 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos mutus | |
| 27477702 | 27477702 | PRJNA1054617_S_NODE_8623_length_195_cov_1.210526_g8535_i0 | PRJNA1054617 | 8623 | 195 | 1.210526 | 2.3605257 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 64.3 | 4.94e-10 | NR | XP_036086947.1 | 9407 | g8535 | i0 | 67.4 | 0.707692307692308 | 46 | 15 | 70.8 | 0 | 141 | 4 | 88 | 133 | XP_036086947.1 uncharacterized protein LOC118610799 [Rousettus aegyptiacus] | diamond | 138 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 28614436 | 28614436 | PRJNA1054617_S_NODE_11507_length_173_cov_1.061538_g11419_i0 | PRJNA1054617 | 11507 | 173 | 1.061538 | 1.83646074 | Varanus komodoensis | 61221 | Chordata | Chordata | 55.1 | 2.5e-7 | NR | KAF7248239.1 | 61221 | g11419 | i0 | 77.8 | 0.936416184971098 | 27 | 6 | 46.8 | 0 | 4 | 84 | 1 | 27 | KAF7248239.1 Syntaxin-18 [Varanus komodoensis] | diamond | 162 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Varanidae | Varanus | Varanus komodoensis | |
| 28803614 | 28803614 | PRJNA1054617_S_NODE_13188_length_163_cov_1.150000_g13100_i0 | PRJNA1054617 | 13188 | 163 | 1.15 | 1.8745 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 40.8 | 0.0294 | NR | CAI9172259.1 | 3082113 | g13100 | i0 | 54.1 | 0.680981595092024 | 37 | 17 | 68.1 | 0 | 51 | 161 | 93 | 129 | CAI9172259.1 unnamed protein product [Rangifer tarandus platyrhynchus] | diamond | 111 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 29719222 | 29719222 | PRJNA1054617_S_NODE_6630_length_217_cov_1.488506_g6542_i0 | PRJNA1054617 | 6630 | 217 | 1.488506 | 3.23005802 | Chiroxiphia lanceolata | 296741 | Chordata | Chordata | 43.5 | 0.0139 | NR | XP_032563442.1 | 296741 | g6542 | i0 | 34.9 | 1.72811059907834 | 63 | 31 | 81.6 | 2 | 9 | 185 | 135 | 191 | XP_032563442.1 TNF receptor-associated factor 4 isoform X1 [Chiroxiphia lanceolata] | diamond | 375 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Pipridae | Chiroxiphia | Chiroxiphia lanceolata | |
| 30635472 | 30635472 | PRJNA1054617_S_NODE_15113_length_154_cov_2.378378_g15025_i0 | PRJNA1054617 | 15113 | 154 | 2.378378 | 3.66270212 | Eschrichtius robustus | 9764 | Chordata | Chordata | 45.4 | 1.51e-4 | NR | KAJ8794285.1 | 9764 | g15025 | i0 | 77.3 | 0.798701298701299 | 22 | 5 | 42.9 | 0 | 66 | 1 | 30 | 51 | KAJ8794285.1 hypothetical protein J1605_003242 [Eschrichtius robustus] | diamond | 123 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 31299225 | 31299225 | PRJNA1054617_S_NODE_9775_length_185_cov_1.471831_g9687_i0 | PRJNA1054617 | 9775 | 185 | 1.471831 | 2.72288735 | Myxine glutinosa | 7769 | Chordata | Chordata | 51.2 | 1.72e-5 | NR | XP_067977669.1 | 7769 | g9687 | i0 | 65.9 | 1.37837837837838 | 41 | 12 | 63.2 | 1 | 28 | 144 | 281 | 321 | XP_067977669.1 ubiquitin carboxyl-terminal hydrolase 42-like [Myxine glutinosa] | diamond | 255 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 31678685 | 31678685 | PRJNA1054617_S_NODE_5517_length_233_cov_3.415789_g5429_i0 | PRJNA1054617 | 5517 | 233 | 3.415789 | 7.95878837 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.9 | 0.0113 | NR | XP_039600642.1 | 55291 | g5429 | i0 | 61.3 | 1.17167381974249 | 31 | 12 | 39.9 | 0 | 231 | 139 | 202 | 232 | XP_039600642.1 E3 SUMO-protein ligase ZBED1-like [Polypterus senegalus] | diamond | 273 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31702305 | 31702305 | PRJNA1054617_S_NODE_9417_length_188_cov_1.268966_g9329_i0 | PRJNA1054617 | 9417 | 188 | 1.268966 | 2.38565608 | Mammalia | 40674 | Chordata | Chordata | 43.5 | 0.00699 | NR | KAF6366527.1 | 59472 | g9329 | i0 | 64 | 10.4042553191489 | 25 | 9 | 39.9 | 0 | 130 | 56 | 36 | 60 | KAF6366527.1 hypothetical protein mPipKuh1_009929 [Pipistrellus kuhlii] | diamond | 1956 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Pipistrellus | Pipistrellus kuhlii | |
| 31805282 | 31805282 | PRJNA1054617_S_NODE_6277_length_222_cov_1.027933_g6189_i0 | PRJNA1054617 | 6277 | 222 | 1.027933 | 2.28201126 | Eschrichtius robustus | 9764 | Chordata | Chordata | 48.9 | 1.24e-4 | NR | XP_068401777.1 | 9764 | g6189 | i0 | 71.4 | 0.472972972972973 | 35 | 10 | 47.3 | 0 | 146 | 42 | 169 | 203 | XP_068401777.1 proline-rich protein HaeIII subfamily 1-like [Eschrichtius robustus] | diamond | 105 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 32153395 | 32153395 | PRJNA1054617_S_NODE_4938_length_244_cov_1.825871_g4850_i0 | PRJNA1054617 | 4938 | 244 | 1.825871 | 4.45512524 | Myxine glutinosa | 7769 | Chordata | Chordata | 93.6 | 4.96e-20 | NR | XP_067965260.1 | 7769 | g4850 | i0 | 66.7 | 0.885245901639344 | 72 | 12 | 73.8 | 1 | 238 | 59 | 227 | 298 | XP_067965260.1 protein FAM83B-like [Myxine glutinosa] | diamond | 216 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 32406560 | 32406560 | PRJNA1054617_S_NODE_13999_length_159_cov_1.586207_g13911_i0 | PRJNA1054617 | 13999 | 159 | 1.586207 | 2.52206913 | Manis javanica | 9974 | Chordata | Chordata | 46.2 | 7.32e-4 | NR | KAI5934349.1 | 9974 | g13911 | i0 | 63.3 | 2.15094339622642 | 30 | 11 | 56.6 | 0 | 67 | 156 | 479 | 508 | KAI5934349.1 LINE-1 retrotransposable element ORF2 protein [Manis javanica] | diamond | 342 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis javanica | |
| 32816537 | 32816537 | PRJNA1054617_S_NODE_4300_length_258_cov_2.153488_g4212_i0 | PRJNA1054617 | 4300 | 258 | 2.153488 | 5.55599904 | Kogia breviceps | 27615 | Chordata | Chordata | 53.5 | 6.74e-6 | NR | XP_066874417.1 | 27615 | g4212 | i0 | 68.8 | 1.31395348837209 | 32 | 10 | 37.2 | 0 | 156 | 61 | 17 | 48 | XP_066874417.1 branched-chain-amino-acid aminotransferase, mitochondrial isoform X3 [Kogia breviceps] | diamond | 339 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Physeteridae | Kogia | Kogia breviceps | |
| 32879508 | 32879508 | PRJNA1054617_S_NODE_11360_length_174_cov_1.038168_g11272_i0 | PRJNA1054617 | 11360 | 174 | 1.038168 | 1.80641232 | Crocuta crocuta | 9678 | Chordata | Chordata | 53.5 | 1.64e-6 | NR | KAF0871064.1 | 9678 | g11272 | i0 | 70 | 0.689655172413793 | 40 | 12 | 69 | 0 | 131 | 12 | 47 | 86 | KAF0871064.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 120 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta |
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);;