contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA721440" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26798830 | 26798830 | PRJNA721440_S_NODE_3281_length_314_cov_5.479245_g3155_i0 | PRJNA721440 | 3281 | 314 | 5.479245 | 17.2048293 | Ciona intestinalis | 7719 | Chordata | Chordata | 74.3 | 6.84e-13 | NR | XP_002120963.1 | 7719 | g3155 | i0 | 62.2 | 0.429936305732484 | 45 | 17 | 43 | 0 | 213 | 79 | 565 | 609 | XP_002120963.1 alpha-amylase 2-like [Ciona intestinalis] | diamond | 135 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 27178294 | 27178294 | PRJNA721440_S_NODE_12602_length_188_cov_1.122302_g12476_i0 | PRJNA721440 | 12602 | 188 | 1.122302 | 2.10992776 | Branchiostoma floridae | 7739 | Chordata | Chordata | 48.5 | 1.62e-4 | NR | XP_035681117.1 | 7739 | g12476 | i0 | 43.3 | 1.91489361702128 | 60 | 34 | 95.7 | 0 | 187 | 8 | 13 | 72 | XP_035681117.1 cytochrome P450 7B1-like [Branchiostoma floridae] | diamond | 360 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 27241633 | 27241633 | PRJNA721440_S_NODE_6743_length_237_cov_1.835106_g6617_i0 | PRJNA721440 | 6743 | 237 | 1.835106 | 4.34920122 | Staurois parvus | 386267 | Chordata | Chordata | 53.5 | 7.58e-7 | NR | CAI9557087.1 | 386267 | g6617 | i0 | 63.9 | 0.911392405063291 | 36 | 11 | 43 | 1 | 43 | 144 | 24 | 59 | CAI9557087.1 unnamed protein product, partial [Staurois parvus] | diamond | 216 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27283789 | 27283789 | PRJNA721440_S_NODE_7223_length_231_cov_0.857143_g7097_i0 | PRJNA721440 | 7223 | 231 | 0.857143 | 1.98000033 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.4 | 5.82e-6 | NR | XDB47465.1 | 9925 | g7097 | i0 | 89.3 | 5.50649350649351 | 28 | 3 | 36.4 | 0 | 3 | 86 | 159 | 186 | XDB47465.1 hypothetical protein ABFV05_001081 [Capra hircus] | diamond | 1272 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 27442042 | 27442042 | PRJNA721440_S_NODE_13543_length_183_cov_1.604478_g13417_i0 | PRJNA721440 | 13543 | 183 | 1.604478 | 2.93619474 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 97.1 | 1.85e-24 | NR | XP_053557215.1 | 8345 | g13417 | i0 | 78.3 | 3.91803278688525 | 60 | 13 | 98.4 | 0 | 2 | 181 | 5 | 64 | XP_053557215.1 succinyl-CoA:3-ketoacid coenzyme A transferase 1, mitochondrial-like [Bombina bombina] | diamond | 717 | 97.8 | 0.992842535787321 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 28483754 | 28483754 | PRJNA721440_S_NODE_3886_length_293_cov_7.549180_g3760_i0 | PRJNA721440 | 3886 | 293 | 7.54918 | 22.1190974 | root | 1 | Root_unresolved | Root_unresolved | 117 | 4.3000000000000004e-30 | NR | XP_051712873.2 | 9986 | g3760 | i0 | 66.3 | 41.518771331058 | 95 | 28 | 95.2 | 2 | 12 | 290 | 111 | 203 | XP_051712873.2 large ribosomal subunit protein eL22 isoform X2 [Oryctolagus cuniculus] | diamond | 12165 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 29041772 | 29041772 | PRJNA721440_S_NODE_7288_length_230_cov_1.889503_g7162_i0 | PRJNA721440 | 7288 | 230 | 1.889503 | 4.3458569 | Arvicanthis niloticus | 61156 | Chordata | Chordata | 42.4 | 0.0431 | NR | XP_034374341.1 | 61156 | g7162 | i0 | 36.1 | 0.795652173913043 | 61 | 36 | 75.7 | 1 | 229 | 56 | 430 | 490 | XP_034374341.1 carcinoembryonic antigen-related cell adhesion molecule 20 [Arvicanthis niloticus] | diamond | 183 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Arvicanthis | Arvicanthis niloticus | |
| 29136571 | 29136571 | PRJNA721440_S_NODE_20229_length_160_cov_5.765766_g20103_i0 | PRJNA721440 | 20229 | 160 | 5.765766 | 9.2252256 | Columba guinea | 135627 | Chordata | Chordata | 100 | 7.539999999999999e-23 | NR | KAK2511043.1 | 135627 | g20103 | i0 | 72.6 | 3 | 62 | 8 | 99.4 | 1 | 1 | 159 | 84 | 145 | KAK2511043.1 Copa [Columba guinea] | diamond | 480 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Columbiformes | Columbidae | Columba | Columba guinea | |
| 29515001 | 29515001 | PRJNA721440_S_NODE_3770_length_297_cov_2.895161_g3644_i0 | PRJNA721440 | 3770 | 297 | 2.895161 | 8.59862817 | Branchiostoma belcheri tsingtauense | 155462 | Chordata | Chordata | 77 | 5.17e-15 | NR | AAM18076.1 | 155462 | g3644 | i0 | 63.2 | 0.575757575757576 | 57 | 21 | 57.6 | 0 | 296 | 126 | 130 | 186 | AAM18076.1 peroxiredoxin V protein [Branchiostoma belcheri tsingtauense] | diamond | 171 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 29525768 | 29525768 | PRJNA721440_S_NODE_17550_length_167_cov_3.635593_g17424_i0 | PRJNA721440 | 17550 | 167 | 3.635593 | 6.07144031 | Metazoa | 33208 | Chordata | Chordata | 45.4 | 0.0015 | NR | XP_051782102.1 | 27687 | g17424 | i0 | 55 | 3.8622754491018 | 40 | 18 | 71.9 | 0 | 35 | 154 | 219 | 258 | XP_051782102.1 uncharacterized protein K02A2.6-like [Erpetoichthys calabaricus] | diamond | 645 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 29894248 | 29894248 | PRJNA721440_S_NODE_21091_length_156_cov_2.841121_g20965_i0 | PRJNA721440 | 21091 | 156 | 2.841121 | 4.43214876 | Amblyraja radiata | 386614 | Chordata | Chordata | 71.6 | 7.19e-13 | NR | XP_032877958.1 | 386614 | g20965 | i0 | 73.5 | 4.73076923076923 | 49 | 13 | 94.2 | 0 | 5 | 151 | 431 | 479 | XP_032877958.1 LOW QUALITY PROTEIN: uncharacterized protein LOC116973759, partial [Amblyraja radiata] | diamond | 738 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Amblyraja | Amblyraja radiata | |
| 30273525 | 30273525 | PRJNA721440_S_NODE_11112_length_197_cov_2.783784_g10986_i0 | PRJNA721440 | 11112 | 197 | 2.783784 | 5.48405448 | Geotrypetes seraphini | 260995 | Chordata | Chordata | 45.8 | 0.00169 | NR | XP_033798662.1 | 260995 | g10986 | i0 | 46 | 3.79187817258883 | 63 | 34 | 95.9 | 0 | 6 | 194 | 1009 | 1071 | XP_033798662.1 cilia- and flagella-associated protein 43 isoform X1 [Geotrypetes seraphini] | diamond | 747 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Dermophiidae | Geotrypetes | Geotrypetes seraphini | |
| 30305289 | 30305289 | PRJNA721440_S_NODE_15692_length_173_cov_4.612903_g15566_i0 | PRJNA721440 | 15692 | 173 | 4.612903 | 7.98032219 | Styela clava | 7725 | Chordata | Chordata | 73.6 | 3.2e-14 | NR | XP_039273615.1 | 7725 | g15566 | i0 | 59.6 | 0.988439306358382 | 57 | 23 | 98.8 | 0 | 3 | 173 | 80 | 136 | XP_039273615.1 protein CREG1-like [Styela clava] | diamond | 171 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 30747224 | 30747224 | PRJNA721440_S_NODE_6814_length_236_cov_2.181818_g6688_i0 | PRJNA721440 | 6814 | 236 | 2.181818 | 5.14909048 | Amblyraja radiata | 386614 | Chordata | Chordata | 42.4 | 0.0456 | NR | XP_032896191.1 | 386614 | g6688 | i0 | 45.8 | 0.610169491525424 | 48 | 25 | 61 | 1 | 233 | 90 | 214 | 260 | XP_032896191.1 ribosomal L1 domain-containing protein 1 [Amblyraja radiata] | diamond | 144 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Amblyraja | Amblyraja radiata | |
| 31284267 | 31284267 | PRJNA721440_S_NODE_11855_length_192_cov_3.244755_g11729_i0 | PRJNA721440 | 11855 | 192 | 3.244755 | 6.2299296 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 70.5 | 2.38e-12 | NR | XP_051791274.1 | 27687 | g11729 | i0 | 73.5 | 3.828125 | 49 | 12 | 75 | 1 | 171 | 28 | 156 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 735 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 31315985 | 31315985 | PRJNA721440_S_NODE_12395_length_189_cov_1.878571_g12269_i0 | PRJNA721440 | 12395 | 189 | 1.878571 | 3.55049919 | Phyllostomus discolor | 89673 | Chordata | Chordata | 42 | 0.0337 | NR | XP_035869557.1 | 89673 | g12269 | i0 | 48.6 | 0.587301587301587 | 37 | 18 | 58.7 | 1 | 152 | 42 | 66 | 101 | XP_035869557.1 LOW QUALITY PROTEIN: ubiquitin carboxyl-terminal hydrolase isozyme L5-like [Phyllostomus discolor] | diamond | 111 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 31569297 | 31569297 | PRJNA721440_S_NODE_12296_length_189_cov_11.628571_g12170_i0 | PRJNA721440 | 12296 | 189 | 11.628571 | 21.97799919 | Phallusia mammillata | 59560 | Chordata | Chordata | 77.4 | 9.15e-15 | NR | CAB3252815.1 | 59560 | g12170 | i0 | 54.8 | 2.93650793650794 | 62 | 28 | 98.4 | 0 | 188 | 3 | 305 | 366 | CAB3252815.1 3-hydroxyisobutyryl-CoA hydrolase, mitochondrial [Phallusia mammillata] | diamond | 555 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 31611237 | 31611237 | PRJNA721440_S_NODE_4516_length_277_cov_1.802632_g4390_i0 | PRJNA721440 | 4516 | 277 | 1.802632 | 4.99329064 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0411 | NR | XP_009857558.1 | 7719 | g4390 | i0 | 33.3 | 1.84115523465704 | 84 | 45 | 91 | 2 | 269 | 18 | 203 | 275 | XP_009857558.1 TBC1 domain family member 9 [Ciona intestinalis] | diamond | 510 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 31663788 | 31663788 | PRJNA721440_S_NODE_16597_length_170_cov_1.438017_g16471_i0 | PRJNA721440 | 16597 | 170 | 1.438017 | 2.4446289 | Ranitomeya imitator | 111125 | Chordata | Chordata | 47.4 | 3.26e-4 | NR | CAJ0941415.1 | 111125 | g16471 | i0 | 50.9 | 1.90588235294118 | 55 | 27 | 97.1 | 0 | 3 | 167 | 614 | 668 | CAJ0941415.1 unnamed protein product [Ranitomeya imitator] | diamond | 324 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 31758782 | 31758782 | PRJNA721440_S_NODE_5817_length_250_cov_8.064677_g5691_i0 | PRJNA721440 | 5817 | 250 | 8.064677 | 20.1616925 | Gekko japonicus | 146911 | Chordata | Chordata | 72 | 1.99e-12 | NR | XP_015284848.1 | 146911 | g5691 | i0 | 66 | 1.212 | 50 | 17 | 60 | 0 | 250 | 101 | 60 | 109 | XP_015284848.1 PREDICTED: thioredoxin reductase 3 isoform X1 [Gekko japonicus] | diamond | 303 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Gekkonidae | Gekko | Gekko japonicus | |
| 31853615 | 31853615 | PRJNA721440_S_NODE_8037_length_221_cov_30.825581_g7911_i0 | PRJNA721440 | 8037 | 221 | 30.825581 | 68.12453401 | Staurois parvus | 386267 | Chordata | Chordata | 51.6 | 1.43e-5 | NR | CAI9536211.1 | 386267 | g7911 | i0 | 51.8 | 2.04977375565611 | 56 | 20 | 66.5 | 3 | 175 | 29 | 170 | 225 | CAI9536211.1 unnamed protein product [Staurois parvus] | diamond | 453 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 31885243 | 31885243 | PRJNA721440_S_NODE_10717_length_200_cov_1.331126_g10591_i0 | PRJNA721440 | 10717 | 200 | 1.331126 | 2.662252 | Polypterus senegalus | 55291 | Chordata | Chordata | 47.4 | 4.79e-4 | NR | KAG2466651.1 | 55291 | g10591 | i0 | 61.8 | 0.51 | 34 | 13 | 51 | 0 | 198 | 97 | 305 | 338 | KAG2466651.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 102 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 32275703 | 32275703 | PRJNA721440_S_NODE_5838_length_250_cov_2.064677_g5712_i0 | PRJNA721440 | 5838 | 250 | 2.064677 | 5.1616925 | Chordata | 7711 | Chordata | Chordata | 43.5 | 0.0185 | NR | XP_035676453.1 | 7739 | g5712 | i0 | 31.3 | 2.352 | 64 | 40 | 75.6 | 2 | 3 | 191 | 181 | 241 | XP_035676453.1 cyclin-Q-like isoform X2 [Branchiostoma floridae] | diamond | 588 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 32486681 | 32486681 | PRJNA721440_S_NODE_14019_length_181_cov_1.075758_g13893_i0 | PRJNA721440 | 14019 | 181 | 1.075758 | 1.94712198 | Athene cunicularia | 194338 | Chordata | Chordata | 43.9 | 0.00661 | NR | XP_026702274.1 | 194338 | g13893 | i0 | 34.5 | 1.92265193370166 | 58 | 33 | 87.8 | 2 | 1 | 159 | 1446 | 1503 | XP_026702274.1 cullin-9 isoform X5 [Athene cunicularia] | diamond | 348 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Strigiformes | Strigidae | Athene | Athene cunicularia | |
| 32780532 | 32780532 | PRJNA721440_S_NODE_7480_length_228_cov_1.351955_g7354_i0 | PRJNA721440 | 7480 | 228 | 1.351955 | 3.0824574 | Metazoa | 33208 | Chordata | Chordata | 47 | 9.52e-4 | NR | XP_069787031.1 | 1343680 | g7354 | i0 | 39.1 | 4.52631578947368 | 69 | 42 | 90.8 | 0 | 212 | 6 | 200 | 268 | XP_069787031.1 ribosomal oxygenase 1 isoform X6 [Narcine bancroftii] | diamond | 1032 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Torpediniformes | Narcinidae | Narcine | Narcine bancroftii |
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);;