contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27120026 | 27120026 | PRJNA946307_P_NODE_95162_length_186_cov_2.510949_g94288_i0 | PRJNA946307 | 95162 | 186 | 2.510949 | 4.67036514 | Chrysochloris asiatica | 185453 | Chordata | Chordata | 45.4 | 0.00137 | NR | XP_006878228.1 | 185453 | g94288 | i0 | 54.4 | 0.919354838709677 | 57 | 21 | 91.9 | 2 | 2 | 172 | 103 | 154 | XP_006878228.1 PREDICTED: LOW QUALITY PROTEIN: putative uncharacterized protein encoded by RNF165-IT1-like [Chrysochloris asiatica] | diamond | 171 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chrysochloridae | Chrysochloris | Chrysochloris asiatica | ||
| 27278433 | 27278433 | PRJNA946307_P_NODE_90743_length_188_cov_2.503597_g89869_i0 | PRJNA946307 | 90743 | 188 | 2.503597 | 4.70676236 | Vulpes lagopus | 494514 | Chordata | Chordata | 42.7 | 0.0182 | NR | XP_041596778.1 | 494514 | g89869 | i0 | 51.4 | 1.11702127659574 | 35 | 17 | 55.9 | 0 | 115 | 11 | 43 | 77 | XP_041596778.1 cationic amino acid transporter 3 isoform X2 [Vulpes lagopus] | diamond | 210 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Vulpes | Vulpes lagopus | |
| 27562364 | 27562364 | PRJNA946307_P_NODE_74764_length_197_cov_5.594595_g73890_i0 | PRJNA946307 | 74764 | 197 | 5.594595 | 11.02135215 | Pomatorhinus ruficollis | 932028 | Chordata | Chordata | 40.8 | 0.012 | NR | NXY38567.1 | 932028 | g73890 | i0 | 40 | 0.685279187817259 | 45 | 27 | 68.5 | 0 | 193 | 59 | 1 | 45 | NXY38567.1 GLL9 protein [Pomatorhinus ruficollis] | diamond | 135 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Timaliidae | Pomatorhinus | Pomatorhinus ruficollis | |
| 27594258 | 27594258 | PRJNA946307_P_NODE_161624_length_162_cov_0.920354_g160750_i0 | PRJNA946307 | 161624 | 162 | 0.920354 | 1.49097348 | Engystomops pustulosus | 76066 | Chordata | Chordata | 39.3 | 0.0402 | NR | KAG8541121.1 | 76066 | g160750 | i0 | 68.2 | 0.407407407407407 | 22 | 7 | 40.7 | 0 | 96 | 31 | 22 | 43 | KAG8541121.1 hypothetical protein GDO81_029672 [Engystomops pustulosus] | diamond | 66 | 39.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 27689325 | 27689325 | PRJNA946307_P_NODE_99904_length_184_cov_2.111111_g99030_i0 | PRJNA946307 | 99904 | 184 | 2.111111 | 3.88444424 | Phrynocephalus forsythii | 171643 | Chordata | Chordata | 41.2 | 0.0343 | NR | KAJ7310350.1 | 171643 | g99030 | i0 | 94.1 | 0.277173913043478 | 17 | 1 | 27.7 | 0 | 133 | 183 | 21 | 37 | KAJ7310350.1 hypothetical protein JRQ81_007259 [Phrynocephalus forsythii] | diamond | 51 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Agamidae | Phrynocephalus | Phrynocephalus forsythii | |
| 27695864 | 27695864 | PRJNA946307_P_NODE_79664_length_194_cov_3.172414_g78790_i0 | PRJNA946307 | 79664 | 194 | 3.172414 | 6.15448316 | Mammalia | 40674 | Chordata | Chordata | 48.1 | 1.38e-4 | NR | XP_045853368.1 | 9662 | g78790 | i0 | 46.3 | 1.22164948453608 | 41 | 22 | 63.4 | 0 | 191 | 69 | 100 | 140 | XP_045853368.1 60S acidic ribosomal protein P1-like [Meles meles] | diamond | 237 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Meles | Meles meles | |
| 27815428 | 27815428 | PRJNA946307_P_NODE_82464_length_192_cov_2.643357_g81590_i0 | PRJNA946307 | 82464 | 192 | 2.643357 | 5.07524544 | Dasypus novemcinctus | 9361 | Chordata | Chordata | 44.3 | 0.00562 | NR | XP_004446998.1 | 9361 | g81590 | i0 | 41.8 | 0.859375 | 55 | 27 | 78.1 | 1 | 19 | 168 | 362 | 416 | XP_004446998.1 dendrin [Dasypus novemcinctus] | diamond | 165 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Cingulata | Dasypodidae | Dasypus | Dasypus novemcinctus | |
| 27815438 | 27815438 | PRJNA946307_P_NODE_95544_length_186_cov_2.058394_g94670_i0 | PRJNA946307 | 95544 | 186 | 2.058394 | 3.82861284 | Crocuta crocuta | 9678 | Chordata | Chordata | 41.2 | 0.00844 | NR | KAF0877179.1 | 9678 | g94670 | i0 | 65.5 | 0.467741935483871 | 29 | 10 | 46.8 | 0 | 95 | 181 | 31 | 59 | KAF0877179.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 87 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 28446797 | 28446797 | PRJNA946307_P_NODE_144086_length_166_cov_1.666667_g143212_i0 | PRJNA946307 | 144086 | 166 | 1.666667 | 2.76666722 | Enhydra lutris kenyoni | 391180 | Chordata | Chordata | 42.7 | 0.0134 | NR | XP_022372638.1 | 391180 | g143212 | i0 | 46.7 | 0.813253012048193 | 45 | 21 | 75.9 | 1 | 139 | 14 | 2 | 46 | XP_022372638.1 LOW QUALITY PROTEIN: mesothelin-like [Enhydra lutris kenyoni] | diamond | 135 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Enhydra | Enhydra lutris | |
| 28636254 | 28636254 | PRJNA946307_P_NODE_100947_length_184_cov_1.251852_g100073_i0 | PRJNA946307 | 100947 | 184 | 1.251852 | 2.30340768 | Engystomops pustulosus | 76066 | Chordata | Chordata | 47.4 | 3.35e-5 | NR | KAG8584541.1 | 76066 | g100073 | i0 | 53.8 | 0.847826086956522 | 52 | 24 | 84.8 | 0 | 11 | 166 | 1 | 52 | KAG8584541.1 hypothetical protein GDO81_004655 [Engystomops pustulosus] | diamond | 156 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 28888572 | 28888572 | PRJNA946307_P_NODE_135388_length_169_cov_0.866667_g134514_i0 | PRJNA946307 | 135388 | 169 | 0.866667 | 1.46466723 | Eubucco bourcierii | 91767 | Chordata | Chordata | 43.5 | 0.0074400000000000004 | NR | NXF94556.1 | 91767 | g134514 | i0 | 40.6 | 2.89349112426035 | 64 | 19 | 79.9 | 2 | 145 | 11 | 336 | 399 | NXF94556.1 PRDM5 protein [Eubucco bourcierii] | diamond | 489 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Piciformes | Ramphastidae | Eubucco | Eubucco bourcierii | |
| 29015264 | 29015264 | PRJNA946307_P_NODE_163848_length_161_cov_3.258929_g162974_i0 | PRJNA946307 | 163848 | 161 | 3.258929 | 5.24687569 | Ciona intestinalis | 7719 | Chordata | Chordata | 42 | 0.0231 | NR | XP_002126864.1 | 7719 | g162974 | i0 | 54.3 | 0.652173913043478 | 35 | 16 | 65.2 | 0 | 18 | 122 | 359 | 393 | XP_002126864.1 protein RCC2 homolog [Ciona intestinalis] | diamond | 105 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 29141450 | 29141450 | PRJNA946307_P_NODE_139009_length_167_cov_2.966102_g138135_i0 | PRJNA946307 | 139009 | 167 | 2.966102 | 4.95339034 | Meles meles | 9662 | Chordata | Chordata | 41.2 | 0.0481 | NR | XP_045881491.1 | 9662 | g138135 | i0 | 58.3 | 0.646706586826347 | 36 | 14 | 62.9 | 1 | 61 | 165 | 307 | 342 | XP_045881491.1 LOW QUALITY PROTEIN: uncharacterized protein LOC123954405 [Meles meles] | diamond | 108 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Meles | Meles meles | |
| 29463269 | 29463269 | PRJNA946307_P_NODE_126010_length_172_cov_3.073171_g125136_i0 | PRJNA946307 | 126010 | 172 | 3.073171 | 5.28585412 | Passeriformes | 9126 | Chordata | Chordata | 48.5 | 1.32e-4 | NR | XP_050835264.1 | 9135 | g125136 | i0 | 60 | 3.01744186046512 | 35 | 14 | 61 | 0 | 154 | 50 | 506 | 540 | XP_050835264.1 2'-5'-oligoadenylate synthase 1-like isoform X1 [Serinus canaria] | diamond | 519 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Serinus | Serinus canaria | |
| 30000649 | 30000649 | PRJNA946307_P_NODE_105791_length_181_cov_3.583333_g104917_i0 | PRJNA946307 | 105791 | 181 | 3.583333 | 6.48583273 | Chordata | 7711 | Chordata | Chordata | 75.9 | 2.65e-14 | NR | NP_001083793.1 | 8355 | g104917 | i0 | 92.5 | 54.4309392265193 | 40 | 3 | 66.3 | 0 | 55 | 174 | 84 | 123 | NP_001083793.1 protein arginine N-methyltransferase 1-A [Xenopus laevis] | diamond | 9852 | 76.3 | 0.99475753604194 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 30380023 | 30380023 | PRJNA946307_P_NODE_106092_length_181_cov_2.840909_g105218_i0 | PRJNA946307 | 106092 | 181 | 2.840909 | 5.14204529 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.5 | 2.67e-19 | NR | KFR01876.1 | 128390 | g105218 | i0 | 64.2 | 5.25414364640884 | 53 | 19 | 87.8 | 0 | 15 | 173 | 7 | 59 | KFR01876.1 putative cytosolic iron-sulfur protein assembly protein CIAO1, partial [Nipponia nippon] | diamond | 951 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Pelecaniformes | Threskiornithidae | Nipponia | Nipponia nippon | |
| 30727164 | 30727164 | PRJNA946307_P_NODE_52674_length_210_cov_3.000000_g51800_i0 | PRJNA946307 | 52674 | 210 | 3 | 6.3 | Metazoa | 33208 | Chordata | Chordata | 49.3 | 1.23e-4 | NR | EMP34760.1 | 8469 | g51800 | i0 | 44.2 | 2.97142857142857 | 43 | 23 | 61.4 | 1 | 10 | 138 | 738 | 779 | EMP34760.1 Multiple epidermal growth factor-like domains protein 10 [Chelonia mydas] | diamond | 624 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Chelonia | Chelonia mydas | ||
| 30815272 | 30815272 | PRJNA946307_P_NODE_149514_length_165_cov_0.896552_g148640_i0 | PRJNA946307 | 149514 | 165 | 0.896552 | 1.4793108 | Sousa chinensis | 103600 | Chordata | Chordata | 50.1 | 3.48e-5 | NR | TEA38950.1 | 103600 | g148640 | i0 | 57.5 | 0.727272727272727 | 40 | 17 | 72.7 | 0 | 129 | 10 | 443 | 482 | TEA38950.1 hypothetical protein DBR06_SOUSAS1710029 [Sousa chinensis] | diamond | 120 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Sousa | Sousa chinensis | |
| 31162540 | 31162540 | PRJNA946307_P_NODE_119355_length_175_cov_2.809524_g118481_i0 | PRJNA946307 | 119355 | 175 | 2.809524 | 4.916667 | Felis catus | 9685 | Chordata | Chordata | 47.8 | 2.52e-4 | NR | XP_044894023.1 | 9685 | g118481 | i0 | 83.3 | 0.411428571428571 | 24 | 4 | 41.1 | 0 | 124 | 53 | 222 | 245 | XP_044894023.1 basic salivary proline-rich protein 3-like [Felis catus] | diamond | 72 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Felis | Felis catus | |
| 31447487 | 31447487 | PRJNA946307_P_NODE_142636_length_166_cov_4.811966_g141762_i0 | PRJNA946307 | 142636 | 166 | 4.811966 | 7.98786356 | Staurois parvus | 386267 | Chordata | Chordata | 53.1 | 1.49e-7 | NR | CAI9540006.1 | 386267 | g141762 | i0 | 61.7 | 0.849397590361446 | 47 | 18 | 84.9 | 0 | 21 | 161 | 1 | 47 | CAI9540006.1 unnamed protein product, partial [Staurois parvus] | diamond | 141 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 31447508 | 31447508 | PRJNA946307_P_NODE_167416_length_158_cov_3.146789_g166542_i0 | PRJNA946307 | 167416 | 158 | 3.146789 | 4.97192662 | Neopelma chrysocephalum | 114329 | Chordata | Chordata | 41.2 | 0.042 | NR | XP_027558588.1 | 114329 | g166542 | i0 | 45.5 | 0.835443037974684 | 44 | 20 | 79.7 | 2 | 135 | 10 | 845 | 886 | XP_027558588.1 agrin [Neopelma chrysocephalum] | diamond | 132 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Pipridae | Neopelma | Neopelma chrysocephalum | |
| 31826825 | 31826825 | PRJNA946307_P_NODE_119977_length_175_cov_1.960317_g119103_i0 | PRJNA946307 | 119977 | 175 | 1.960317 | 3.43055475 | Eschrichtius robustus | 9764 | Chordata | Chordata | 67.8 | 2.19e-11 | NR | KAJ8791820.1 | 9764 | g119103 | i0 | 66.7 | 0.771428571428571 | 45 | 15 | 77.1 | 0 | 148 | 14 | 186 | 230 | KAJ8791820.1 hypothetical protein J1605_020542 [Eschrichtius robustus] | diamond | 135 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 31890260 | 31890260 | PRJNA946307_P_NODE_172737_length_153_cov_3.480769_g171863_i0 | PRJNA946307 | 172737 | 153 | 3.480769 | 5.32557657 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 50.8 | 1.48e-5 | NR | KAI8493380.1 | 7741 | g171863 | i0 | 71.4 | 0.549019607843137 | 28 | 8 | 54.9 | 0 | 152 | 69 | 3 | 30 | KAI8493380.1 hypothetical protein Bbelb_287770 [Branchiostoma belcheri] | diamond | 84 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 32111813 | 32111813 | PRJNA946307_P_NODE_150918_length_164_cov_4.069565_g150044_i0 | PRJNA946307 | 150918 | 164 | 4.069565 | 6.6740866 | Sus scrofa | 9823 | Chordata | Chordata | 62 | 2.02e-9 | NR | XP_020946894.1 | 9823 | g150044 | i0 | 63.8 | 1.75609756097561 | 47 | 17 | 86 | 0 | 22 | 162 | 690 | 736 | XP_020946894.1 collagen alpha-2(I) chain-like [Sus scrofa] | diamond | 288 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 32206762 | 32206762 | PRJNA946307_P_NODE_150998_length_164_cov_3.713043_g150124_i0 | PRJNA946307 | 150998 | 164 | 3.713043 | 6.08939052 | Bos mutus | 72004 | Chordata | Chordata | 52 | 6.89e-6 | NR | MXQ88326.1 | 72004 | g150124 | i0 | 96.3 | 0.49390243902439 | 27 | 1 | 49.4 | 0 | 83 | 163 | 372 | 398 | MXQ88326.1 hypothetical protein [Bos mutus] | diamond | 81 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos mutus |
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);;