contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJEB12237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18837398 | 18837398 | PRJEB12237_P_NODE_3455_length_357_cov_2.723602_g3259_i0 | PRJEB12237 | 3455 | 357 | 2.723602 | 9.72325914 | Opisthokonta | 33154 | Chordata | Chordata | 84.7 | 5.23e-19 | NR | XP_025872417.1 | 9627 | g3259 | i0 | 63.8 | 6.89075630252101 | 58 | 21 | 48.7 | 0 | 18 | 191 | 11 | 68 | XP_025872417.1 60S ribosomal protein L39-like, partial [Vulpes vulpes] | diamond | 2460 | 85.5 | 0.990643274853801 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Vulpes | Vulpes vulpes | |
| 21697414 | 21697414 | PRJEB12237_P_NODE_5918_length_242_cov_1.120773_g5722_i0 | PRJEB12237 | 5918 | 242 | 1.120773 | 2.71227066 | Metazoa | 33208 | Chordata | Chordata | 142 | 3.24e-37 | NR | NP_990699.2 | 9031 | g5722 | i0 | 81.3 | 18.8305785123967 | 80 | 15 | 99.2 | 0 | 3 | 242 | 687 | 766 | NP_990699.2 elongation factor 2 [Gallus gallus] | diamond | 4557 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 22662543 | 22662543 | PRJEB12237_P_NODE_4978_length_276_cov_2.278008_g4782_i0 | PRJEB12237 | 4978 | 276 | 2.278008 | 6.28730208 | Opisthokonta | 33154 | Chordata | Chordata | 82 | 2.35e-18 | NR | XP_065766518.1 | 9886 | g4782 | i0 | 68.5 | 32.5 | 54 | 17 | 58.7 | 0 | 255 | 94 | 15 | 68 | XP_065766518.1 large ribosomal subunit protein eL39-like [Muntiacus reevesi] | diamond | 8970 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 23937939 | 23937939 | PRJEB12237_P_NODE_1759_length_542_cov_2.258383_g1576_i0 | PRJEB12237 | 1759 | 542 | 2.258383 | 12.24043586 | Metazoa | 33208 | Chordata | Chordata | 173 | 2.73e-50 | NR | MEE6458116.1 | 8439 | g1576 | i0 | 77 | 35.9114391143911 | 113 | 26 | 62.5 | 0 | 539 | 201 | 144 | 256 | MEE6458116.1 hypothetical protein [Ascaphus truei] | diamond | 19464 | 174 | 0.994252873563218 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 26741397 | 26741397 | PRJEB12237_P_NODE_11701_length_153_cov_2.025424_g11505_i0 | PRJEB12237 | 11701 | 153 | 2.025424 | 3.09889872 | Metazoa | 33208 | Chordata | Chordata | 90.9 | 4.7400000000000006e-21 | NR | NP_001279746.1 | 7868 | g11505 | i0 | 82.4 | 154 | 51 | 9 | 100 | 0 | 153 | 1 | 110 | 160 | NP_001279746.1 ras-related protein Rab-1A [Callorhinchus milii] | diamond | 23562 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 27910906 | 27910906 | PRJEB12237_P_NODE_10905_length_160_cov_1.280000_g10709_i0 | PRJEB12237 | 10905 | 160 | 1.28 | 2.048 | Opisthokonta | 33154 | Chordata | Chordata | 68.9 | 4.05e-13 | NR | XP_026366764.4 | 9644 | g10709 | i0 | 62.5 | 9.65625 | 48 | 18 | 90 | 0 | 16 | 159 | 68 | 115 | XP_026366764.4 60S ribosomal protein L26-like 1 [Ursus arctos] | diamond | 1545 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ursus | Ursus arctos | |
| 27942806 | 27942806 | PRJEB12237_P_NODE_3065_length_389_cov_4.169492_g2869_i0 | PRJEB12237 | 3065 | 389 | 4.169492 | 16.21932388 | Metazoa | 33208 | Chordata | Chordata | 127 | 9.39e-34 | NR | CBY23026.1 | 34765 | g2869 | i0 | 62 | 50.6760925449871 | 100 | 38 | 77.1 | 0 | 2 | 301 | 112 | 211 | CBY23026.1 unnamed protein product [Oikopleura dioica] | diamond | 19713 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 28075214 | 28075214 | PRJEB12237_P_NODE_9865_length_170_cov_1.370370_g9669_i0 | PRJEB12237 | 9865 | 170 | 1.37037 | 2.329629 | Styela clava | 7725 | Chordata | Chordata | 79 | 2.38e-15 | NR | XP_039248684.1 | 7725 | g9669 | i0 | 58.9 | 2.94705882352941 | 56 | 21 | 95.3 | 1 | 166 | 5 | 376 | 431 | XP_039248684.1 methylenetetrahydrofolate reductase-like [Styela clava] | diamond | 501 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 28100442 | 28100442 | PRJEB12237_P_NODE_6885_length_217_cov_1.532967_g6689_i0 | PRJEB12237 | 6885 | 217 | 1.532967 | 3.32653839 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.8 | 7.49e-10 | NR | XP_002129681.1 | 7719 | g6689 | i0 | 50.7 | 16.63133640553 | 71 | 35 | 98.2 | 0 | 215 | 3 | 94 | 164 | XP_002129681.1 40S ribosomal protein S8 [Ciona intestinalis] | diamond | 3609 | 63.2 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 28605792 | 28605792 | PRJEB12237_P_NODE_1987_length_507_cov_3.360169_g1800_i0 | PRJEB12237 | 1987 | 507 | 3.360169 | 17.03605683 | Chordata | 7711 | Chordata | Chordata | 194 | 3.7299999999999997e-60 | NR | KAK9406484.1 | 8729 | g1800 | i0 | 67.1 | 59.0355029585799 | 146 | 44 | 84.6 | 2 | 481 | 53 | 38 | 182 | KAK9406484.1 hypothetical protein NXF25_005258 [Crotalus adamanteus] | diamond | 29931 | 195 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus adamanteus | |
| 28826539 | 28826539 | PRJEB12237_P_NODE_6128_length_236_cov_1.194030_g5932_i0 | PRJEB12237 | 6128 | 236 | 1.19403 | 2.8179108 | Testudines | 8459 | Chordata | Chordata | 58.2 | 1.22e-7 | NR | TFK16005.1 | 55544 | g5932 | i0 | 50 | 2.74576271186441 | 54 | 27 | 68.6 | 0 | 236 | 75 | 238 | 291 | TFK16005.1 zinc finger CCCH domain-containing protein 14 [Platysternon megacephalum] | diamond | 648 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Platysternidae | Platysternon | Platysternon megacephalum | ||
| 28896134 | 28896134 | PRJEB12237_P_NODE_9808_length_171_cov_1.169118_g9612_i0 | PRJEB12237 | 9808 | 171 | 1.169118 | 1.99919178 | Protopterus annectens | 7888 | Chordata | Chordata | 53.1 | 3e-6 | NR | XP_043911632.1 | 7888 | g9612 | i0 | 50.9 | 1 | 57 | 27 | 100 | 1 | 1 | 171 | 205 | 260 | XP_043911632.1 dual specificity protein phosphatase 5 [Protopterus annectens] | diamond | 171 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 28927791 | 28927791 | PRJEB12237_P_NODE_10608_length_163_cov_0.890625_g10412_i0 | PRJEB12237 | 10608 | 163 | 0.890625 | 1.45171875 | Trachemys scripta elegans | 31138 | Chordata | Chordata | 75.9 | 1.58e-15 | NR | XP_034639018.1 | 31138 | g10412 | i0 | 73.9 | 13.8588957055215 | 46 | 12 | 84.7 | 0 | 147 | 10 | 21 | 66 | XP_034639018.1 LOW QUALITY PROTEIN: nucleoside diphosphate kinase 3 [Trachemys scripta elegans] | diamond | 2259 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Emydidae | Trachemys | Trachemys scripta | ||
| 29590543 | 29590543 | PRJEB12237_P_NODE_9370_length_176_cov_1.418440_g9174_i0 | PRJEB12237 | 9370 | 176 | 1.41844 | 2.4964544 | Tachyglossus aculeatus | 9261 | Chordata | Chordata | 43.1 | 0.0113 | NR | XP_038610549.1 | 9261 | g9174 | i0 | 41.8 | 0.9375 | 55 | 28 | 86.9 | 2 | 168 | 16 | 518 | 572 | XP_038610549.1 semaphorin-4C isoform X1 [Tachyglossus aculeatus] | diamond | 165 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Monotremata | Tachyglossidae | Tachyglossus | Tachyglossus aculeatus | |
| 29868781 | 29868781 | PRJEB12237_P_NODE_9531_length_174_cov_1.230216_g9335_i0 | PRJEB12237 | 9531 | 174 | 1.230216 | 2.14057584 | Opisthokonta | 33154 | Chordata | Chordata | 105 | 8.08e-26 | NR | XP_066280419.1 | 7740 | g9335 | i0 | 93 | 74.4310344827586 | 57 | 4 | 98.3 | 0 | 4 | 174 | 125 | 181 | XP_066280419.1 calmodulin isoform X2 [Branchiostoma lanceolatum] | diamond | 12951 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 29969768 | 29969768 | PRJEB12237_P_NODE_12171_length_150_cov_1.373913_g11975_i0 | PRJEB12237 | 12171 | 150 | 1.373913 | 2.0608695 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 68.6 | 8e-12 | NR | XP_068133607.1 | 752182 | g11975 | i0 | 59.2 | 4.9 | 49 | 20 | 98 | 0 | 148 | 2 | 270 | 318 | XP_068133607.1 WD repeat-containing protein 1 [Hyperolius riggenbachi] | diamond | 735 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 30222499 | 30222499 | PRJEB12237_P_NODE_3092_length_387_cov_2.568182_g2896_i0 | PRJEB12237 | 3092 | 387 | 2.568182 | 9.93886434 | Petromyzon marinus | 7757 | Chordata | Chordata | 70.9 | 2.44e-11 | NR | XP_032815971.1 | 7757 | g2896 | i0 | 40 | 2.55813953488372 | 110 | 56 | 79.1 | 3 | 374 | 69 | 278 | 385 | XP_032815971.1 indian hedgehog protein-like [Petromyzon marinus] | diamond | 990 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 30374686 | 30374686 | PRJEB12237_P_NODE_9192_length_178_cov_1.678322_g8996_i0 | PRJEB12237 | 9192 | 178 | 1.678322 | 2.98741316 | Anura | 8342 | Chordata | Chordata | 63.2 | 9.75e-10 | NR | XP_040186749.1 | 8407 | g8996 | i0 | 50 | 4.82022471910112 | 58 | 28 | 96.1 | 1 | 177 | 7 | 92 | 149 | XP_040186749.1 protein disulfide-isomerase isoform X2 [Rana temporaria] | diamond | 858 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 30753414 | 30753414 | PRJEB12237_P_NODE_6274_length_232_cov_1.015228_g6078_i0 | PRJEB12237 | 6274 | 232 | 1.015228 | 2.35532896 | Mammalia | 40674 | Chordata | Chordata | 95.1 | 2.72e-21 | NR | XP_015992385.2 | 9407 | g6078 | i0 | 63.5 | 59.2758620689655 | 63 | 23 | 81.5 | 0 | 232 | 44 | 260 | 322 | XP_015992385.2 40S ribosomal protein S4, X isoform isoform X1 [Rousettus aegyptiacus] | diamond | 13752 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 31391981 | 31391981 | PRJEB12237_P_NODE_5336_length_261_cov_1.592920_g5140_i0 | PRJEB12237 | 5336 | 261 | 1.59292 | 4.1575212 | Gracilinanus agilis | 191870 | Chordata | Chordata | 103 | 1.05e-25 | NR | XP_044512975.1 | 191870 | g5140 | i0 | 55.8 | 24.5287356321839 | 86 | 38 | 98.9 | 0 | 259 | 2 | 64 | 149 | XP_044512975.1 GTP:AMP phosphotransferase AK3, mitochondrial isoform X2 [Gracilinanus agilis] | diamond | 6402 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Didelphimorphia | Didelphidae | Gracilinanus | Gracilinanus agilis | |
| 31701802 | 31701802 | PRJEB12237_P_NODE_6357_length_229_cov_4.474227_g6161_i0 | PRJEB12237 | 6357 | 229 | 4.474227 | 10.24597983 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 101 | 1.05e-25 | NR | XP_002128932.1 | 7719 | g6161 | i0 | 69.9 | 5.43668122270742 | 73 | 22 | 95.6 | 0 | 1 | 219 | 53 | 125 | XP_002128932.1 60S ribosomal protein L31 [Ciona intestinalis] | diamond | 1245 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 32018122 | 32018122 | PRJEB12237_P_NODE_11658_length_154_cov_1.067227_g11462_i0 | PRJEB12237 | 11658 | 154 | 1.067227 | 1.64352958 | Anura | 8342 | Chordata | Chordata | 67 | 3.02e-11 | NR | KAG9494486.1 | 57060 | g11462 | i0 | 56.9 | 30.7987012987013 | 51 | 22 | 99.4 | 0 | 1 | 153 | 144 | 194 | KAG9494486.1 hypothetical protein GDO78_002024 [Eleutherodactylus coqui] | diamond | 4743 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Eleutherodactylidae | Eleutherodactylus | Eleutherodactylus coqui | |
| 32271412 | 32271412 | PRJEB12237_P_NODE_5758_length_246_cov_2.606635_g5562_i0 | PRJEB12237 | 5758 | 246 | 2.606635 | 6.4123221 | Opisthokonta | 33154 | Chordata | Chordata | 45.8 | 8.58e-4 | NR | XP_040600932.1 | 10036 | g5562 | i0 | 50 | 2.59756097560976 | 32 | 16 | 39 | 0 | 5 | 100 | 69 | 100 | XP_040600932.1 60S ribosomal protein L37-like [Mesocricetus auratus] | diamond | 639 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Mesocricetus | Mesocricetus auratus | |
| 32404238 | 32404238 | PRJEB12237_P_NODE_9699_length_172_cov_1.167883_g9503_i0 | PRJEB12237 | 9699 | 172 | 1.167883 | 2.00875876 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 50.8 | 2.01e-5 | NR | XP_066300029.1 | 7740 | g9503 | i0 | 39.4 | 1.15116279069767 | 66 | 29 | 97.7 | 3 | 172 | 5 | 462 | 526 | XP_066300029.1 tyrosinase-like [Branchiostoma lanceolatum] | diamond | 198 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 32530918 | 32530918 | PRJEB12237_P_NODE_9779_length_171_cov_1.470588_g9583_i0 | PRJEB12237 | 9779 | 171 | 1.470588 | 2.51470548 | Jaculus jaculus | 51337 | Chordata | Chordata | 78.6 | 3.25e-15 | NR | XP_004650623.2 | 51337 | g9583 | i0 | 62.5 | 11.7719298245614 | 56 | 21 | 98.2 | 0 | 169 | 2 | 468 | 523 | XP_004650623.2 thioredoxin reductase 1, cytoplasmic isoform X1 [Jaculus jaculus] | diamond | 2013 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Dipodidae | Jaculus | Jaculus jaculus | |
| 32776406 | 32776406 | PRJEB12237_P_NODE_11940_length_152_cov_1.025641_g11744_i0 | PRJEB12237 | 11940 | 152 | 1.025641 | 1.55897432 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.00421 | NR | XP_069817389.1 | 150705 | g11744 | i0 | 48.8 | 6.27631578947368 | 41 | 21 | 80.9 | 0 | 29 | 151 | 307 | 347 | XP_069817389.1 serine/threonine-protein kinase Chk2 isoform X5 [Dendropsophus ebraccatus] | diamond | 954 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Dendropsophus | Dendropsophus ebraccatus |
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);;