contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27090038 | 27090038 | PRJEB29441_P_NODE_45762_length_162_cov_0.902655_g45321_i0 | PRJEB29441 | 45762 | 162 | 0.902655 | 1.4623011 | Metazoa | 33208 | Chordata | Chordata | 73.6 | 1.64e-13 | NR | PKK17501.1 | 8932 | g45321 | i0 | 67.9 | 19.6111111111111 | 53 | 17 | 98.1 | 0 | 162 | 4 | 296 | 348 | PKK17501.1 chaperonin containing TCP1, subunit 3 (gamma) [Columba livia] | diamond | 3177 | 74.3 | 0.990578734858681 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Columbiformes | Columbidae | Columba | Columba livia | |
| 27633646 | 27633646 | PRJEB29441_P_NODE_38804_length_167_cov_0.864407_g38363_i0 | PRJEB29441 | 38804 | 167 | 0.864407 | 1.44355969 | Camarhynchus parvulus | 87175 | Chordata | Chordata | 41.2 | 0.0448 | NR | XP_030822662.1 | 87175 | g38363 | i0 | 41.5 | 0.952095808383233 | 53 | 21 | 79 | 2 | 31 | 162 | 5 | 56 | XP_030822662.1 mast cell protease 1A-like [Camarhynchus parvulus] | diamond | 159 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Thraupidae | Camarhynchus | Camarhynchus parvulus | |
| 27633648 | 27633648 | PRJEB29441_P_NODE_46104_length_162_cov_0.902655_g45663_i0 | PRJEB29441 | 46104 | 162 | 0.902655 | 1.4623011 | Hypanus sabinus | 79690 | Chordata | Chordata | 44.7 | 0.0027 | NR | XP_059839735.1 | 79690 | g45663 | i0 | 43.2 | 0.814814814814815 | 44 | 25 | 81.5 | 0 | 132 | 1 | 794 | 837 | XP_059839735.1 tubulin polyglutamylase TTLL7 isoform X2 [Hypanus sabinus] | diamond | 132 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 27847898 | 27847898 | PRJEB29441_P_NODE_31324_length_187_cov_1.471014_g30883_i0 | PRJEB29441 | 31324 | 187 | 1.471014 | 2.75079618 | Aves | 8782 | Chordata | Chordata | 63.2 | 1.05e-9 | NR | CAM2108291.1 | 8467 | g30883 | i0 | 61.1 | 5.14973262032086 | 54 | 21 | 86.6 | 0 | 167 | 6 | 39 | 92 | CAM2108291.1 unnamed protein product [Caretta caretta] | diamond | 963 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Caretta | Caretta caretta | ||
| 27980906 | 27980906 | PRJEB29441_P_NODE_40585_length_166_cov_0.871795_g40144_i0 | PRJEB29441 | 40585 | 166 | 0.871795 | 1.4471797 | Polypterus senegalus | 55291 | Chordata | Chordata | 80.5 | 3.66e-16 | NR | KAG2462409.1 | 55291 | g40144 | i0 | 68.1 | 3.45180722891566 | 47 | 15 | 84.9 | 0 | 5 | 145 | 261 | 307 | KAG2462409.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 573 | 80.9 | 0.995055624227441 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28138972 | 28138972 | PRJEB29441_P_NODE_46625_length_161_cov_1.348214_g46184_i0 | PRJEB29441 | 46625 | 161 | 1.348214 | 2.17062454 | Erinaceus europaeus | 9365 | Chordata | Chordata | 43.9 | 0.0048 | NR | XP_060053264.1 | 9365 | g46184 | i0 | 47.5 | 5.14285714285714 | 40 | 19 | 74.5 | 1 | 3 | 122 | 184 | 221 | XP_060053264.1 zinc finger protein 454 isoform X1 [Erinaceus europaeus] | diamond | 828 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Erinaceidae | Erinaceus | Erinaceus europaeus | |
| 28454650 | 28454650 | PRJEB29441_P_NODE_46706_length_161_cov_0.910714_g46265_i0 | PRJEB29441 | 46706 | 161 | 0.910714 | 1.46624954 | Polypterus senegalus | 55291 | Chordata | Chordata | 60.1 | 8.56e-9 | NR | KAG2460242.1 | 55291 | g46265 | i0 | 50.9 | 14.8695652173913 | 57 | 24 | 98.8 | 1 | 2 | 160 | 138 | 194 | KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 2394 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28612378 | 28612378 | PRJEB29441_P_NODE_40327_length_166_cov_0.871795_g39886_i0 | PRJEB29441 | 40327 | 166 | 0.871795 | 1.4471797 | Engystomops pustulosus | 76066 | Chordata | Chordata | 48.1 | 2.77e-5 | NR | KAG8554186.1 | 76066 | g39886 | i0 | 55.6 | 0.813253012048193 | 45 | 20 | 81.3 | 0 | 32 | 166 | 51 | 95 | KAG8554186.1 hypothetical protein GDO81_003707 [Engystomops pustulosus] | diamond | 135 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 29306889 | 29306889 | PRJEB29441_P_NODE_44469_length_163_cov_0.894737_g44028_i0 | PRJEB29441 | 44469 | 163 | 0.894737 | 1.45842131 | Emys orbicularis | 82168 | Chordata | Chordata | 40.4 | 0.0312 | NR | XP_065258075.1 | 82168 | g44028 | i0 | 42.9 | 0.901840490797546 | 49 | 24 | 90.2 | 1 | 2 | 148 | 61 | 105 | XP_065258075.1 myelin and lymphocyte protein isoform X2 [Emys orbicularis] | diamond | 147 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Emydidae | Emys | Emys orbicularis | ||
| 29432936 | 29432936 | PRJEB29441_P_NODE_11110_length_337_cov_1.416667_g10669_i0 | PRJEB29441 | 11110 | 337 | 1.416667 | 4.77416779 | Hypanus sabinus | 79690 | Chordata | Chordata | 60.8 | 4.78e-8 | NR | XP_059823631.1 | 79690 | g10669 | i0 | 46 | 0.445103857566766 | 50 | 27 | 44.5 | 0 | 233 | 84 | 558 | 607 | XP_059823631.1 IQ calmodulin-binding motif-containing protein 1 isoform X1 [Hypanus sabinus] | diamond | 150 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 29685510 | 29685510 | PRJEB29441_P_NODE_20310_length_236_cov_1.534759_g19869_i0 | PRJEB29441 | 20310 | 236 | 1.534759 | 3.62203124 | Lerista edwardsae | 470340 | Chordata | Chordata | 42.4 | 0.0476 | NR | KAJ6657874.1 | 470340 | g19869 | i0 | 40 | 0.76271186440678 | 60 | 36 | 76.3 | 0 | 231 | 52 | 216 | 275 | KAJ6657874.1 hypothetical protein lerEdw1_001794, partial [Lerista edwardsae] | diamond | 180 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Scincidae | Lerista | Lerista edwardsae | |
| 30001830 | 30001830 | PRJEB29441_P_NODE_40931_length_166_cov_0.829060_g40490_i0 | PRJEB29441 | 40931 | 166 | 0.82906 | 1.3762396 | Engystomops pustulosus | 76066 | Chordata | Chordata | 53.5 | 9.72e-8 | NR | KAG8584541.1 | 76066 | g40490 | i0 | 64.3 | 1.51807228915663 | 42 | 15 | 75.9 | 0 | 126 | 1 | 5 | 46 | KAG8584541.1 hypothetical protein GDO81_004655 [Engystomops pustulosus] | diamond | 252 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 30159389 | 30159389 | PRJEB29441_P_NODE_46972_length_161_cov_0.910714_g46531_i0 | PRJEB29441 | 46972 | 161 | 0.910714 | 1.46624954 | Sus scrofa | 9823 | Chordata | Chordata | 44.7 | 0.00257 | NR | XP_020946894.1 | 9823 | g46531 | i0 | 52.8 | 0.987577639751553 | 53 | 24 | 96.9 | 1 | 6 | 161 | 405 | 457 | XP_020946894.1 collagen alpha-2(I) chain-like [Sus scrofa] | diamond | 159 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 30974756 | 30974756 | PRJEB29441_P_NODE_42294_length_164_cov_3.730435_g41853_i0 | PRJEB29441 | 42294 | 164 | 3.730435 | 6.1179134 | Delphinidae | 9726 | Chordata | Chordata | 58.5 | 3.39e-8 | NR | XP_069396403.1 | 9728 | g41853 | i0 | 90.3 | 2.19512195121951 | 31 | 3 | 56.7 | 0 | 164 | 72 | 156 | 186 | XP_069396403.1 collagen alpha-1(I) chain-like, partial [Delphinus delphis] | diamond | 360 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Delphinus | Delphinus delphis | |
| 31265570 | 31265570 | PRJEB29441_P_NODE_20575_length_234_cov_1.513514_g20134_i0 | PRJEB29441 | 20575 | 234 | 1.513514 | 3.54162276 | Staurois parvus | 386267 | Chordata | Chordata | 59.7 | 7.14e-10 | NR | CAI9620946.1 | 386267 | g20134 | i0 | 70.3 | 0.474358974358974 | 37 | 11 | 47.4 | 0 | 39 | 149 | 23 | 59 | CAI9620946.1 unnamed protein product [Staurois parvus] | diamond | 111 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 31360591 | 31360591 | PRJEB29441_P_NODE_43996_length_163_cov_0.894737_g43555_i0 | PRJEB29441 | 43996 | 163 | 0.894737 | 1.45842131 | Staurois parvus | 386267 | Chordata | Chordata | 45.8 | 6.28e-5 | NR | CAI9622433.1 | 386267 | g43555 | i0 | 82.6 | 0.423312883435583 | 23 | 4 | 42.3 | 0 | 95 | 163 | 3 | 25 | CAI9622433.1 unnamed protein product, partial [Staurois parvus] | diamond | 69 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 31392254 | 31392254 | PRJEB29441_P_NODE_11956_length_322_cov_2.531136_g11515_i0 | PRJEB29441 | 11956 | 322 | 2.531136 | 8.15025792 | Engystomops pustulosus | 76066 | Chordata | Chordata | 46.2 | 6.38e-4 | NR | KAG8536220.1 | 76066 | g11515 | i0 | 70.4 | 0.745341614906832 | 27 | 8 | 25.2 | 0 | 242 | 322 | 43 | 69 | KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus] | diamond | 240 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 31487169 | 31487169 | PRJEB29441_P_NODE_10696_length_344_cov_1.884746_g10255_i0 | PRJEB29441 | 10696 | 344 | 1.884746 | 6.48352624 | Ranitomeya imitator | 111125 | Chordata | Chordata | 63.5 | 6.05e-9 | NR | CAJ0933392.1 | 111125 | g10255 | i0 | 62.5 | 0.418604651162791 | 48 | 16 | 40.1 | 1 | 28 | 165 | 53 | 100 | CAJ0933392.1 unnamed protein product [Ranitomeya imitator] | diamond | 144 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 32056328 | 32056328 | PRJEB29441_P_NODE_23098_length_220_cov_1.064327_g22657_i0 | PRJEB29441 | 23098 | 220 | 1.064327 | 2.3415194 | Staurois parvus | 386267 | Chordata | Chordata | 58.9 | 8.67e-10 | NR | CAI9622433.1 | 386267 | g22657 | i0 | 80 | 0.409090909090909 | 30 | 6 | 40.9 | 0 | 23 | 112 | 3 | 32 | CAI9622433.1 unnamed protein product, partial [Staurois parvus] | diamond | 90 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32087996 | 32087996 | PRJEB29441_P_NODE_44298_length_163_cov_0.894737_g43857_i0 | PRJEB29441 | 44298 | 163 | 0.894737 | 1.45842131 | Engystomops pustulosus | 76066 | Chordata | Chordata | 58.9 | 2.37e-8 | NR | KAG8571490.1 | 76066 | g43857 | i0 | 54.7 | 4.85889570552147 | 53 | 23 | 95.7 | 1 | 161 | 6 | 992 | 1044 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 792 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 32144822 | 32144822 | PRJEB29441_P_NODE_44378_length_163_cov_0.894737_g43937_i0 | PRJEB29441 | 44378 | 163 | 0.894737 | 1.45842131 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89.7 | 4.53e-20 | NR | KAE8628049.1 | 8364 | g43937 | i0 | 69.2 | 16.7484662576687 | 52 | 16 | 95.7 | 0 | 1 | 156 | 133 | 184 | KAE8628049.1 hypothetical protein XENTR_v10007283 [Xenopus tropicalis] | diamond | 2730 | 90.1 | 0.995560488346282 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 32436327 | 32436327 | PRJEB29441_P_NODE_46959_length_161_cov_0.910714_g46518_i0 | PRJEB29441 | 46959 | 161 | 0.910714 | 1.46624954 | Stegostoma tigrinum | 3053191 | Chordata | Chordata | 49.7 | 2.17e-5 | NR | XP_059506335.1 | 3053191 | g46518 | i0 | 47.2 | 1.41614906832298 | 53 | 27 | 96.9 | 1 | 5 | 160 | 111 | 163 | XP_059506335.1 uncharacterized protein LOC125456831 isoform X1 [Stegostoma tigrinum] | diamond | 228 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Stegostomatidae | Stegostoma | Stegostoma tigrinum | |
| 32594253 | 32594253 | PRJEB29441_P_NODE_7820_length_414_cov_1.879452_g7381_i0 | PRJEB29441 | 7820 | 414 | 1.879452 | 7.78093128 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 133 | 9.07e-35 | NR | XP_051791274.1 | 27687 | g7381 | i0 | 77.8 | 5.92753623188406 | 90 | 19 | 64.5 | 1 | 380 | 114 | 115 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 2454 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 32688453 | 32688453 | PRJEB29441_P_NODE_28100_length_198_cov_1.100671_g27659_i0 | PRJEB29441 | 28100 | 198 | 1.100671 | 2.17932858 | Staurois parvus | 386267 | Chordata | Chordata | 54.3 | 1.7e-7 | NR | CAI9618505.1 | 386267 | g27659 | i0 | 41.2 | 1.03030303030303 | 68 | 35 | 98.5 | 2 | 3 | 197 | 21 | 86 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 204 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32720102 | 32720102 | PRJEB29441_P_NODE_19880_length_239_cov_1.842105_g19439_i0 | PRJEB29441 | 19880 | 239 | 1.842105 | 4.40263095 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 73.6 | 1.27e-13 | NR | XP_051712873.2 | 9986 | g19439 | i0 | 63.5 | 22.1548117154812 | 63 | 19 | 76.6 | 2 | 183 | 1 | 111 | 171 | XP_051712873.2 large ribosomal subunit protein eL22 isoform X2 [Oryctolagus cuniculus] | diamond | 5295 | 74.3 | 0.990578734858681 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 32839410 | 32839410 | PRJEB29441_P_NODE_44520_length_163_cov_0.894737_g44079_i0 | PRJEB29441 | 44520 | 163 | 0.894737 | 1.45842131 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 1.02e-4 | NR | ELK23646.1 | 225400 | g44079 | i0 | 46.8 | 2.37423312883436 | 47 | 25 | 86.5 | 0 | 21 | 161 | 102 | 148 | ELK23646.1 Ornithine decarboxylase [Myotis davidii] | diamond | 387 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis davidii |
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);;