contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA602115" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 575734 | 575734 | PRJNA602115_P_NODE_5981_length_260_cov_1.286432_g5956_i0 | PRJNA602115 | 5981 | 260 | 1.286432 | 3.3447232 | Ursus arctos | 9644 | Chordata | Chordata | 73.6 | 6.63e-13 | NR | XP_057170311.1 | 9644 | g5956 | i0 | 50.6 | 4.03846153846154 | 87 | 36 | 99.2 | 2 | 260 | 3 | 1034 | 1114 | XP_057170311.1 granule associated Rac and RHOG effector protein 1 isoform X1 [Ursus arctos] | diamond | 1050 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ursus | Ursus arctos | |
| 3694374 | 3694374 | PRJNA602115_P_NODE_10763_length_204_cov_0.895105_g10738_i0 | PRJNA602115 | 10763 | 204 | 0.895105 | 1.8260142 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 94.7 | 1.05e-20 | NR | XP_069931346.1 | 9986 | g10738 | i0 | 69.6 | 3.29411764705882 | 56 | 17 | 82.4 | 0 | 36 | 203 | 421 | 476 | XP_069931346.1 peroxisome biogenesis factor 2 isoform X1 [Oryctolagus cuniculus] | diamond | 672 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 12055099 | 12055099 | PRJNA602115_P_NODE_9010_length_209_cov_0.864865_g8985_i0 | PRJNA602115 | 9010 | 209 | 0.864865 | 1.80756785 | Mammalia | 40674 | Chordata | Chordata | 102 | 1.7099999999999998e-23 | NR | BAA25253.1 | 9615 | g8985 | i0 | 61.8 | 47.7846889952153 | 68 | 26 | 97.6 | 0 | 3 | 206 | 1009 | 1076 | BAA25253.1 unnamed protein product [Canis lupus familiaris] | diamond | 9987 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 26921771 | 26921771 | PRJNA602115_P_NODE_5742_length_265_cov_1.254902_g5717_i0 | PRJNA602115 | 5742 | 265 | 1.254902 | 3.3254903 | Branchiostoma floridae | 7739 | Chordata | Chordata | 53.9 | 7.43e-7 | NR | XP_035672348.1 | 7739 | g5717 | i0 | 37 | 0.916981132075472 | 81 | 47 | 87.2 | 1 | 245 | 15 | 28 | 108 | XP_035672348.1 parvalbumin alpha-like [Branchiostoma floridae] | diamond | 243 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 26984947 | 26984947 | PRJNA602115_P_NODE_7842_length_225_cov_1.079268_g7817_i0 | PRJNA602115 | 7842 | 225 | 1.079268 | 2.428353 | Leptonychotes weddellii | 9713 | Chordata | Chordata | 45.4 | 0.00316 | NR | XP_030889778.1 | 9713 | g7817 | i0 | 53.8 | 0.693333333333333 | 52 | 20 | 65.3 | 3 | 161 | 15 | 41 | 91 | XP_030889778.1 collagen alpha-1(XVIII) chain-like [Leptonychotes weddellii] | diamond | 156 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Leptonychotes | Leptonychotes weddellii | |
| 26984948 | 26984948 | PRJNA602115_P_NODE_9642_length_207_cov_0.876712_g9617_i0 | PRJNA602115 | 9642 | 207 | 0.876712 | 1.81479384 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 43.1 | 0.0165 | NR | XP_051684610.1 | 9986 | g9617 | i0 | 85 | 0.289855072463768 | 20 | 3 | 29 | 0 | 87 | 146 | 343 | 362 | XP_051684610.1 CDK5 and ABL1 enzyme substrate 2 isoform X4 [Oryctolagus cuniculus] | diamond | 60 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 27142787 | 27142787 | PRJNA602115_P_NODE_9522_length_207_cov_0.876712_g9497_i0 | PRJNA602115 | 9522 | 207 | 0.876712 | 1.81479384 | Lepus europaeus | 9983 | Chordata | Chordata | 44.3 | 0.0056 | NR | XP_062066945.1 | 9983 | g9497 | i0 | 47.9 | 0.695652173913043 | 48 | 22 | 65.2 | 1 | 60 | 194 | 119 | 166 | XP_062066945.1 uncharacterized protein LOC133773571 isoform X2 [Lepus europaeus] | diamond | 144 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Lepus | Lepus europaeus | |
| 27237922 | 27237922 | PRJNA602115_P_NODE_8783_length_209_cov_0.864865_g8758_i0 | PRJNA602115 | 8783 | 209 | 0.864865 | 1.80756785 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 53.9 | 2.66e-6 | NR | XP_019622429.1 | 7741 | g8758 | i0 | 50 | 1.76555023923445 | 60 | 29 | 84.7 | 1 | 194 | 18 | 170 | 229 | XP_019622429.1 PREDICTED: protein ABHD15-like isoform X2 [Branchiostoma belcheri] | diamond | 369 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 27617164 | 27617164 | PRJNA602115_P_NODE_5384_length_274_cov_1.061033_g5359_i0 | PRJNA602115 | 5384 | 274 | 1.061033 | 2.90723042 | Lepus europaeus | 9983 | Chordata | Chordata | 72.4 | 2.1e-12 | NR | XP_062067949.1 | 9983 | g5359 | i0 | 53.9 | 0.974452554744526 | 89 | 38 | 97.4 | 1 | 274 | 8 | 1712 | 1797 | XP_062067949.1 cardiomyopathy-associated protein 5 [Lepus europaeus] | diamond | 267 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Lepus | Lepus europaeus | |
| 27743607 | 27743607 | PRJNA602115_P_NODE_3904_length_312_cov_1.079681_g3879_i0 | PRJNA602115 | 3904 | 312 | 1.079681 | 3.36860472 | Ochotona princeps | 9978 | Chordata | Chordata | 46.2 | 0.00501 | NR | XP_058534274.1 | 9978 | g3879 | i0 | 75 | 0.230769230769231 | 24 | 6 | 23.1 | 0 | 53 | 124 | 37 | 60 | XP_058534274.1 cyclin-D-binding Myb-like transcription factor 1 isoform X1 [Ochotona princeps] | diamond | 72 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Ochotonidae | Ochotona | Ochotona princeps | |
| 28343231 | 28343231 | PRJNA602115_P_NODE_11526_length_202_cov_0.907801_g11501_i0 | PRJNA602115 | 11526 | 202 | 0.907801 | 1.83375802 | Polypterus senegalus | 55291 | Chordata | Chordata | 56.2 | 3.89e-7 | NR | XP_039613228.1 | 55291 | g11501 | i0 | 36.6 | 3.17821782178218 | 71 | 41 | 99.5 | 1 | 202 | 2 | 839 | 909 | XP_039613228.1 protein mono-ADP-ribosyltransferase PARP14-like [Polypterus senegalus] | diamond | 642 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29164381 | 29164381 | PRJNA602115_P_NODE_6149_length_257_cov_0.979592_g6124_i0 | PRJNA602115 | 6149 | 257 | 0.979592 | 2.51755144 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 43.9 | 0.0178 | NR | XP_069924009.1 | 9986 | g6124 | i0 | 49 | 0.595330739299611 | 51 | 22 | 56 | 2 | 5 | 148 | 1456 | 1505 | XP_069924009.1 xanthine dehydrogenase/oxidase isoform X1 [Oryctolagus cuniculus] | diamond | 153 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 29542961 | 29542961 | PRJNA602115_P_NODE_10850_length_203_cov_1.683099_g10825_i0 | PRJNA602115 | 10850 | 203 | 1.683099 | 3.41669097 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 72.4 | 7.62e-13 | NR | CAD7670123.1 | 34880 | g10825 | i0 | 74.1 | 0.857142857142857 | 58 | 14 | 85.7 | 1 | 201 | 28 | 131 | 187 | CAD7670123.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 174 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 29840507 | 29840507 | PRJNA602115_P_NODE_10891_length_203_cov_0.915493_g10866_i0 | PRJNA602115 | 10891 | 203 | 0.915493 | 1.85845079 | Mammalia | 40674 | Chordata | Chordata | 49.3 | 1.03e-4 | NR | XDA72768.1 | 9940 | g10866 | i0 | 100 | 3 | 23 | 0 | 34 | 0 | 72 | 4 | 50 | 72 | XDA72768.1 hypothetical protein R6Z07_003092 [Ovis aries] | diamond | 609 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 29858728 | 29858728 | PRJNA602115_P_NODE_511_length_813_cov_1.377660_g489_i0 | PRJNA602115 | 511 | 813 | 1.37766 | 11.2003758 | Lepus europaeus | 9983 | Chordata | Chordata | 187 | 5.97e-50 | NR | XP_062059407.1 | 9983 | g489 | i0 | 55.3 | 0.874538745387454 | 237 | 90 | 83.4 | 5 | 787 | 110 | 291 | 522 | XP_062059407.1 nascent polypeptide-associated complex subunit alpha, muscle-specific form-like [Lepus europaeus] | diamond | 711 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Lepus | Lepus europaeus | |
| 30883050 | 30883050 | PRJNA602115_P_NODE_3494_length_327_cov_1.146617_g3469_i0 | PRJNA602115 | 3494 | 327 | 1.146617 | 3.74943759 | Lagomorpha | 9975 | Chordata | Chordata | 58.9 | 2.03e-7 | NR | XP_058524823.1 | 9978 | g3469 | i0 | 49.1 | 1.68807339449541 | 53 | 27 | 48.6 | 0 | 153 | 311 | 621 | 673 | XP_058524823.1 zinc finger protein 33B-like [Ochotona princeps] | diamond | 552 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Ochotonidae | Ochotona | Ochotona princeps | |
| 31090993 | 31090993 | PRJNA602115_P_NODE_2635_length_372_cov_1.311897_g2610_i0 | PRJNA602115 | 2635 | 372 | 1.311897 | 4.88025684 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 80.5 | 1.04e-14 | NR | XP_069924615.1 | 9986 | g2610 | i0 | 50 | 0.806451612903226 | 100 | 50 | 80.6 | 0 | 55 | 354 | 599 | 698 | XP_069924615.1 EH domain-binding protein 1-like protein 1 isoform X2 [Oryctolagus cuniculus] | diamond | 300 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 31343954 | 31343954 | PRJNA602115_P_NODE_5856_length_263_cov_1.089109_g5831_i0 | PRJNA602115 | 5856 | 263 | 1.089109 | 2.86435667 | Cynocephalus volans | 110931 | Chordata | Chordata | 46.2 | 0.00295 | NR | XP_062932423.1 | 110931 | g5831 | i0 | 50.8 | 0.695817490494297 | 61 | 20 | 61.6 | 2 | 76 | 237 | 820 | 877 | XP_062932423.1 nascent polypeptide-associated complex subunit alpha isoform X1 [Cynocephalus volans] | diamond | 183 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Dermoptera | Cynocephalidae | Cynocephalus | Cynocephalus volans | |
| 31705106 | 31705106 | PRJNA602115_P_NODE_11097_length_203_cov_0.901408_g11072_i0 | PRJNA602115 | 11097 | 203 | 0.901408 | 1.82985824 | root | 1 | Root_unresolved | Root_unresolved | 50.8 | 3.11e-5 | NR | XP_069906595.1 | 9986 | g11072 | i0 | 60 | 2.61576354679803 | 45 | 18 | 66.5 | 0 | 201 | 67 | 325 | 369 | XP_069906595.1 LOW QUALITY PROTEIN: LINE-1 retrotransposable element ORF2 protein [Oryctolagus cuniculus] | diamond | 531 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 32229867 | 32229867 | PRJNA602115_P_NODE_9618_length_207_cov_0.876712_g9593_i0 | PRJNA602115 | 9618 | 207 | 0.876712 | 1.81479384 | Ochotona princeps | 9978 | Chordata | Chordata | 56.6 | 7.59e-8 | NR | XP_058535116.1 | 9978 | g9593 | i0 | 57.9 | 1.04347826086957 | 38 | 16 | 55.1 | 0 | 135 | 22 | 116 | 153 | XP_058535116.1 chromatin modification-related protein MEAF6 isoform X1 [Ochotona princeps] | diamond | 216 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Ochotonidae | Ochotona | Ochotona princeps |
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);;