contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA934332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2185931 | 2185931 | PRJNA934332_P_NODE_2242_length_413_cov_1.850000_g2155_i0 | PRJNA934332 | 2242 | 413 | 1.85 | 7.6405 | Bovidae | 9895 | Chordata | Chordata | 56.2 | 1.52e-6 | NR | XP_061284659.1 | 9906 | g2155 | i0 | 61.2 | 25.271186440678 | 49 | 19 | 35.6 | 0 | 148 | 2 | 57 | 105 | XP_061284659.1 large ribosomal subunit protein uL23-like [Bos javanicus] | diamond | 10437 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos javanicus | |
| 3807448 | 3807448 | PRJNA934332_P_NODE_1323_length_526_cov_0.792494_g1238_i0 | PRJNA934332 | 1323 | 526 | 0.792494 | 4.16851844 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 189 | 9.649999999999999e-54 | NR | XP_034508924.1 | 9646 | g1238 | i0 | 55.9 | 14.6577946768061 | 186 | 70 | 99.2 | 3 | 3 | 524 | 112 | 297 | XP_034508924.1 major vault protein-like, partial [Ailuropoda melanoleuca] | diamond | 7710 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ailuropoda | Ailuropoda melanoleuca | |
| 8563605 | 8563605 | PRJNA934332_P_NODE_6827_length_263_cov_1.215789_g6740_i0 | PRJNA934332 | 6827 | 263 | 1.215789 | 3.19752507 | Metazoa | 33208 | Chordata | Chordata | 108 | 3.18e-27 | NR | XP_004699157.1 | 9371 | g6740 | i0 | 56 | 18.3992395437262 | 91 | 32 | 94.7 | 1 | 6 | 254 | 3 | 93 | XP_004699157.1 ADP/ATP translocase 3, partial [Echinops telfairi] | diamond | 4839 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Tenrecidae | Echinops | Echinops telfairi | ||
| 21657698 | 21657698 | PRJNA934332_P_NODE_1837_length_450_cov_1.681698_g1750_i0 | PRJNA934332 | 1837 | 450 | 1.681698 | 7.567641 | Bovidae | 9895 | Chordata | Chordata | 89 | 7.84e-19 | NR | XP_061284659.1 | 9906 | g1750 | i0 | 65.8 | 26.74 | 73 | 25 | 48.7 | 0 | 232 | 450 | 51 | 123 | XP_061284659.1 large ribosomal subunit protein uL23-like [Bos javanicus] | diamond | 12033 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos javanicus | |
| 23862955 | 23862955 | PRJNA934332_P_NODE_3339_length_351_cov_1.089928_g3252_i0 | PRJNA934332 | 3339 | 351 | 1.089928 | 3.82564728 | Anura | 8342 | Chordata | Chordata | 126 | 6.81e-31 | NR | XP_069815592.1 | 150705 | g3252 | i0 | 54.5 | 5.67521367521368 | 110 | 49 | 94 | 1 | 332 | 3 | 279 | 387 | XP_069815592.1 ATP-dependent translocase ABCB1-like isoform X2 [Dendropsophus ebraccatus] | diamond | 1992 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Dendropsophus | Dendropsophus ebraccatus | |
| 26683666 | 26683666 | PRJNA934332_P_NODE_5381_length_288_cov_1.218605_g5294_i0 | PRJNA934332 | 5381 | 288 | 1.218605 | 3.5095824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.9 | 1.44e-17 | NR | CBY24419.1 | 34765 | g5294 | i0 | 44.3 | 5.04166666666667 | 97 | 52 | 99 | 2 | 2 | 286 | 30 | 126 | CBY24419.1 unnamed protein product [Oikopleura dioica] | diamond | 1452 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 27846154 | 27846154 | PRJNA934332_P_NODE_6744_length_264_cov_1.560209_g6657_i0 | PRJNA934332 | 6744 | 264 | 1.560209 | 4.11895176 | Mus musculus | 10090 | Chordata | Chordata | 68.6 | 4.11e-11 | NR | NP_001403203.1 | 10090 | g6657 | i0 | 34.5 | 7.93181818181818 | 87 | 57 | 98.9 | 0 | 264 | 4 | 853 | 939 | NP_001403203.1 importin-5 isoform 3 [Mus musculus] | diamond | 2094 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27877850 | 27877850 | PRJNA934332_P_NODE_4465_length_312_cov_1.154812_g4378_i0 | PRJNA934332 | 4465 | 312 | 1.154812 | 3.60301344 | Ciona intestinalis | 7719 | Chordata | Chordata | 130 | 9.01e-37 | NR | XP_002128932.1 | 7719 | g4378 | i0 | 70.5 | 8.13461538461539 | 95 | 28 | 91.3 | 0 | 1 | 285 | 31 | 125 | XP_002128932.1 60S ribosomal protein L31 [Ciona intestinalis] | diamond | 2538 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 27909131 | 27909131 | PRJNA934332_P_NODE_11225_length_241_cov_0.916667_g11138_i0 | PRJNA934332 | 11225 | 241 | 0.916667 | 2.20916747 | Xenopus laevis | 8355 | Chordata | Chordata | 42.7 | 0.0303 | NR | OCT99772.1 | 8355 | g11138 | i0 | 42.3 | 0.647302904564315 | 52 | 30 | 64.7 | 0 | 189 | 34 | 39 | 90 | OCT99772.1 hypothetical protein XELAEV_18005553mg [Xenopus laevis] | diamond | 156 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 29148205 | 29148205 | PRJNA934332_P_NODE_5689_length_282_cov_2.875598_g5602_i0 | PRJNA934332 | 5689 | 282 | 2.875598 | 8.10918636 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 1.74e-22 | NR | XP_032831964.1 | 7757 | g5602 | i0 | 53.3 | 6.91489361702128 | 92 | 43 | 97.9 | 0 | 277 | 2 | 272 | 363 | XP_032831964.1 protoheme IX farnesyltransferase, mitochondrial [Petromyzon marinus] | diamond | 1950 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 29337336 | 29337336 | PRJNA934332_P_NODE_6209_length_273_cov_1.710000_g6122_i0 | PRJNA934332 | 6209 | 273 | 1.71 | 4.6683 | Opisthokonta | 33154 | Chordata | Chordata | 57 | 3.22e-7 | NR | XP_019641702.1 | 7741 | g6122 | i0 | 55.2 | 2.73626373626374 | 67 | 30 | 73.6 | 0 | 203 | 3 | 4 | 70 | XP_019641702.1 PREDICTED: 60S ribosomal protein L7-like [Branchiostoma belcheri] | diamond | 747 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 29645571 | 29645571 | PRJNA934332_P_NODE_9010_length_247_cov_0.885057_g8923_i0 | PRJNA934332 | 9010 | 247 | 0.885057 | 2.18609079 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 52 | 2.06e-5 | NR | XP_068099683.1 | 752182 | g8923 | i0 | 33.8 | 0.898785425101215 | 74 | 49 | 89.9 | 0 | 242 | 21 | 143 | 216 | XP_068099683.1 E3 ubiquitin-protein ligase TRIM11-like [Hyperolius riggenbachi] | diamond | 222 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 29930395 | 29930395 | PRJNA934332_P_NODE_9431_length_246_cov_0.890173_g9344_i0 | PRJNA934332 | 9431 | 246 | 0.890173 | 2.18982558 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 89 | 2.11e-18 | NR | XP_066283044.1 | 7740 | g9344 | i0 | 49.3 | 2.85365853658537 | 75 | 38 | 91.5 | 0 | 5 | 229 | 403 | 477 | XP_066283044.1 sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like [Branchiostoma lanceolatum] | diamond | 702 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 29930396 | 29930396 | PRJNA934332_P_NODE_9791_length_245_cov_0.895349_g9704_i0 | PRJNA934332 | 9791 | 245 | 0.895349 | 2.19360505 | Canis lupus dingo | 286419 | Chordata | Chordata | 70.9 | 4.69e-12 | NR | XP_048955576.1 | 286419 | g9704 | i0 | 39.8 | 7.39591836734694 | 88 | 40 | 91.8 | 1 | 245 | 21 | 484 | 571 | XP_048955576.1 LINE-1 retrotransposable element ORF2 protein isoform X1 [Canis lupus dingo] | diamond | 1812 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 30056450 | 30056450 | PRJNA934332_P_NODE_9871_length_245_cov_0.895349_g9784_i0 | PRJNA934332 | 9871 | 245 | 0.895349 | 2.19360505 | Lepus europaeus | 9983 | Chordata | Chordata | 42.7 | 0.0373 | NR | XP_062053589.1 | 9983 | g9784 | i0 | 35.2 | 0.661224489795918 | 54 | 32 | 66.1 | 1 | 173 | 12 | 150 | 200 | XP_062053589.1 uncharacterized protein LOC133763912 [Lepus europaeus] | diamond | 162 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Lepus | Lepus europaeus | |
| 30411497 | 30411497 | PRJNA934332_P_NODE_11153_length_241_cov_0.916667_g11066_i0 | PRJNA934332 | 11153 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 94 | 3.55e-20 | NR | XP_064422227.1 | 7897 | g11066 | i0 | 53.8 | 18.7344398340249 | 80 | 37 | 99.6 | 0 | 2 | 241 | 2555 | 2634 | XP_064422227.1 dynein axonemal heavy chain 1 [Latimeria chalumnae] | diamond | 4515 | 94.4 | 0.995762711864407 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 30916861 | 30916861 | PRJNA934332_P_NODE_4834_length_301_cov_1.350877_g4747_i0 | PRJNA934332 | 4834 | 301 | 1.350877 | 4.06613977 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 149 | 8.949999999999997e-42 | NR | XP_040204293.1 | 8407 | g4747 | i0 | 73.4 | 11.4318936877076 | 94 | 24 | 92.7 | 1 | 21 | 299 | 224 | 317 | XP_040204293.1 cathepsin B [Rana temporaria] | diamond | 3441 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 30916862 | 30916862 | PRJNA934332_P_NODE_8594_length_248_cov_0.880000_g8507_i0 | PRJNA934332 | 8594 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 80.5 | 1.93e-15 | NR | XP_061860370.1 | 57412 | g8507 | i0 | 67.9 | 9.30241935483871 | 56 | 18 | 67.7 | 0 | 2 | 169 | 438 | 493 | XP_061860370.1 lipoamide acyltransferase component of branched-chain alpha-keto acid dehydrogenase complex, mitochondrial [Colius striatus] | diamond | 2307 | 81.3 | 0.990159901599016 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Coliiformes | Coliidae | Colius | Colius striatus | |
| 31288776 | 31288776 | PRJNA934332_P_NODE_8975_length_247_cov_0.885057_g8888_i0 | PRJNA934332 | 8975 | 247 | 0.885057 | 2.18609079 | Bufotes viridis | 30338 | Chordata | Chordata | 50.1 | 9.89e-5 | NR | CAK8629749.1 | 30338 | g8888 | i0 | 73.3 | 0.364372469635628 | 30 | 8 | 36.4 | 0 | 128 | 217 | 335 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 90 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31517468 | 31517468 | PRJNA934332_P_NODE_2336_length_406_cov_2.537538_g2249_i0 | PRJNA934332 | 2336 | 406 | 2.537538 | 10.30240428 | Mammalia | 40674 | Chordata | Chordata | 150 | 2.31e-44 | NR | XP_045851754.1 | 9662 | g2249 | i0 | 80 | 49.8768472906404 | 90 | 18 | 66.5 | 0 | 3 | 272 | 22 | 111 | XP_045851754.1 60S ribosomal protein L10a-like [Meles meles] | diamond | 20250 | 151 | 0.993377483443709 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Meles | Meles meles | |
| 31833443 | 31833443 | PRJNA934332_P_NODE_3497_length_345_cov_0.966912_g3410_i0 | PRJNA934332 | 3497 | 345 | 0.966912 | 3.3358464 | Opisthokonta | 33154 | Chordata | Chordata | 133 | 8.59e-37 | NR | XP_002129675.1 | 7719 | g3410 | i0 | 52.2 | 27.9913043478261 | 113 | 54 | 98.3 | 0 | 1 | 339 | 39 | 151 | XP_002129675.1 GTP-binding protein SAR1b [Ciona intestinalis] | diamond | 9657 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 31984706 | 31984706 | PRJNA934332_P_NODE_6318_length_272_cov_0.974874_g6231_i0 | PRJNA934332 | 6318 | 272 | 0.974874 | 2.65165728 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 106 | 6.06e-26 | NR | XP_019641702.1 | 7741 | g6231 | i0 | 64.8 | 1.94117647058824 | 88 | 31 | 97.1 | 0 | 269 | 6 | 28 | 115 | XP_019641702.1 PREDICTED: 60S ribosomal protein L7-like [Branchiostoma belcheri] | diamond | 528 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 32687218 | 32687218 | PRJNA934332_P_NODE_5700_length_282_cov_1.827751_g5613_i0 | PRJNA934332 | 5700 | 282 | 1.827751 | 5.15425782 | Metazoa | 33208 | Chordata | Chordata | 125 | 7.0000000000000015e-31 | NR | XP_035690270.1 | 7739 | g5613 | i0 | 70.2 | 11.8829787234043 | 94 | 28 | 100 | 0 | 1 | 282 | 558 | 651 | XP_035690270.1 major vault protein-like isoform X5 [Branchiostoma floridae] | diamond | 3351 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 32743423 | 32743423 | PRJNA934332_P_NODE_10600_length_243_cov_0.905882_g10513_i0 | PRJNA934332 | 10600 | 243 | 0.905882 | 2.20129326 | Phallusia mammillata | 59560 | Chordata | Chordata | 43.1 | 0.0261 | NR | CAB3266245.1 | 59560 | g10513 | i0 | 41 | 1.50617283950617 | 61 | 36 | 75.3 | 0 | 6 | 188 | 222 | 282 | CAB3266245.1 solute carrier family 35 member F3-like [Phallusia mammillata] | diamond | 366 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata |
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);;