contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA597223" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18421113 | 18421113 | PRJNA597223_P_NODE_47635_length_203_cov_1.875000_g45789_i0 | PRJNA597223 | 47635 | 203 | 1.875 | 3.80625 | Chordata | 7711 | Chordata | Chordata | 117 | 2.41e-29 | NR | XP_028915693.1 | 9258 | g45789 | i0 | 100 | 47.2610837438424 | 57 | 0 | 84.2 | 0 | 203 | 33 | 211 | 267 | XP_028915693.1 LOW QUALITY PROTEIN: methyl-CpG-binding domain protein 2 [Ornithorhynchus anatinus] | diamond | 9594 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Monotremata | Ornithorhynchidae | Ornithorhynchus | Ornithorhynchus anatinus | |
| 26744681 | 26744681 | PRJNA597223_P_NODE_80281_length_157_cov_2.385246_g78435_i0 | PRJNA597223 | 80281 | 157 | 2.385246 | 3.74483622 | Anura | 8342 | Chordata | Chordata | 50.8 | 1.64e-5 | NR | XP_053568816.1 | 8345 | g78435 | i0 | 51 | 2.67515923566879 | 51 | 25 | 97.5 | 0 | 2 | 154 | 694 | 744 | XP_053568816.1 LOW QUALITY PROTEIN: dynein axonemal heavy chain 11-like [Bombina bombina] | diamond | 420 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 26858732 | 26858732 | PRJNA597223_S_NODE_1121_length_268_cov_2.816594_g1064_i0 | PRJNA597223 | 1121 | 268 | 2.816594 | 7.54847192 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 74.7 | 1.75e-13 | NR | XP_051791274.1 | 27687 | g1064 | i0 | 74.5 | 3.42537313432836 | 51 | 12 | 56 | 1 | 39 | 188 | 156 | 206 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 918 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 27206001 | 27206001 | PRJNA597223_P_NODE_52322_length_192_cov_3.273885_g50476_i0 | PRJNA597223 | 52322 | 192 | 3.273885 | 6.2858592 | Polypterus senegalus | 55291 | Chordata | Chordata | 59.7 | 1.95e-8 | NR | XP_039602201.1 | 55291 | g50476 | i0 | 60.9 | 4.328125 | 46 | 18 | 71.9 | 0 | 44 | 181 | 787 | 832 | XP_039602201.1 uncharacterized protein K02A2.6-like [Polypterus senegalus] | diamond | 831 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28153913 | 28153913 | PRJNA597223_P_NODE_80665_length_157_cov_1.442623_g78819_i0 | PRJNA597223 | 80665 | 157 | 1.442623 | 2.26491811 | Pleurodeles waltl | 8319 | Chordata | Chordata | 41.6 | 0.0125 | NR | KAJ1093452.1 | 8319 | g78819 | i0 | 38 | 6.40127388535032 | 50 | 31 | 95.5 | 0 | 155 | 6 | 20 | 69 | KAJ1093452.1 hypothetical protein NDU88_006553, partial [Pleurodeles waltl] | diamond | 1005 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 28564204 | 28564204 | PRJNA597223_P_NODE_52707_length_192_cov_1.222930_g50861_i0 | PRJNA597223 | 52707 | 192 | 1.22293 | 2.3480256 | Dendropsophus ebraccatus | 150705 | Chordata | Chordata | 85.5 | 1.62e-17 | NR | XP_069840942.1 | 150705 | g50861 | i0 | 55.6 | 4.921875 | 63 | 28 | 98.4 | 0 | 190 | 2 | 1893 | 1955 | XP_069840942.1 uncharacterized protein [Dendropsophus ebraccatus] | diamond | 945 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Dendropsophus | Dendropsophus ebraccatus | |
| 28627531 | 28627531 | PRJNA597223_P_NODE_32427_length_260_cov_4.226667_g30581_i0 | PRJNA597223 | 32427 | 260 | 4.226667 | 10.9893342 | Chionomys nivalis | 269649 | Chordata | Chordata | 55.5 | 4.43e-8 | NR | XP_057619686.1 | 269649 | g30581 | i0 | 69.7 | 0.761538461538461 | 33 | 10 | 38.1 | 0 | 229 | 131 | 4 | 36 | XP_057619686.1 humanin-like protein [Chionomys nivalis] | diamond | 198 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Chionomys | Chionomys nivalis | |
| 28690646 | 28690646 | PRJNA597223_P_NODE_3127_length_970_cov_6.031016_g2218_i0 | PRJNA597223 | 3127 | 970 | 6.031016 | 58.5008552 | Naja naja | 35670 | Chordata | Chordata | 52 | 0.00171 | NR | KAG8140109.1 | 35670 | g2218 | i0 | 29.2 | 0.371134020618557 | 120 | 80 | 36.5 | 2 | 583 | 936 | 92 | 208 | KAG8140109.1 hypothetical protein E2320_002859 [Naja naja] | diamond | 360 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Naja | Naja naja | |
| 29385188 | 29385188 | PRJNA597223_P_NODE_48709_length_200_cov_2.666667_g46863_i0 | PRJNA597223 | 48709 | 200 | 2.666667 | 5.333334 | Staurois parvus | 386267 | Chordata | Chordata | 41.2 | 0.00669 | NR | CAI9622433.1 | 386267 | g46863 | i0 | 75 | 0.3 | 20 | 5 | 30 | 0 | 199 | 140 | 13 | 32 | CAI9622433.1 unnamed protein product, partial [Staurois parvus] | diamond | 60 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29542833 | 29542833 | PRJNA597223_P_NODE_31390_length_266_cov_4.359307_g29544_i0 | PRJNA597223 | 31390 | 266 | 4.359307 | 11.59575662 | Bufotes viridis | 30338 | Chordata | Chordata | 80.5 | 3.02e-16 | NR | CAK8641430.1 | 30338 | g29544 | i0 | 54 | 2.26691729323308 | 87 | 38 | 97 | 2 | 5 | 262 | 129 | 214 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 603 | 81.3 | 0.990159901599016 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 29637289 | 29637289 | PRJNA597223_P_NODE_1950_length_1219_cov_4.576014_g1195_i1 | PRJNA597223 | 1950 | 1219 | 4.576014 | 55.78161066 | Xenopus tropicalis | 8364 | Chordata | Chordata | 227 | 7.92e-62 | NR | XP_017945114.2 | 8364 | g1195 | i1 | 42.3 | 4.35602953240361 | 291 | 161 | 70.1 | 3 | 1207 | 353 | 1133 | 1422 | XP_017945114.2 uncharacterized protein LOC108644811 [Xenopus tropicalis] | diamond | 5310 | 227 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 30111388 | 30111388 | PRJNA597223_P_NODE_88512_length_150_cov_1.652174_g86666_i0 | PRJNA597223 | 88512 | 150 | 1.652174 | 2.478261 | Bos mutus | 72004 | Chordata | Chordata | 49.3 | 6.03e-6 | NR | ELR54977.1 | 72004 | g86666 | i0 | 66.7 | 0.66 | 33 | 11 | 66 | 0 | 100 | 2 | 47 | 79 | ELR54977.1 hypothetical protein M91_10675, partial [Bos mutus] | diamond | 99 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos mutus | |
| 30440865 | 30440865 | PRJNA597223_P_NODE_24413_length_317_cov_4.081560_g22569_i0 | PRJNA597223 | 24413 | 317 | 4.08156 | 12.9385452 | root | 1 | Root_unresolved | Root_unresolved | 85.1 | 1.2e-16 | NR | XP_042201887.1 | 7868 | g22569 | i0 | 41.9 | 3.72870662460568 | 105 | 60 | 98.4 | 1 | 1 | 312 | 643 | 747 | XP_042201887.1 uncharacterized protein LOC121851863 [Callorhinchus milii] | diamond | 1182 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 30585210 | 30585210 | PRJNA597223_P_NODE_4853_length_792_cov_3.980185_g3662_i0 | PRJNA597223 | 4853 | 792 | 3.980185 | 31.5230652 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 217 | 2.45e-60 | NR | KAI8503986.1 | 7741 | g3662 | i0 | 44.3 | 12.5681818181818 | 237 | 128 | 89.8 | 1 | 82 | 792 | 880 | 1112 | KAI8503986.1 Leucine-rich repeat-containing protein 63 [Branchiostoma belcheri] | diamond | 9954 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 30743333 | 30743333 | PRJNA597223_P_NODE_2014_length_1195_cov_4.759483_g1195_i2 | PRJNA597223 | 2014 | 1195 | 4.759483 | 56.87582185 | Xenopus tropicalis | 8364 | Chordata | Chordata | 214 | 1.52e-57 | NR | XP_017945114.2 | 8364 | g1195 | i2 | 41.6 | 1.43598326359833 | 286 | 160 | 70.3 | 3 | 4 | 843 | 1138 | 1422 | XP_017945114.2 uncharacterized protein LOC108644811 [Xenopus tropicalis] | diamond | 1716 | 214 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 30838117 | 30838117 | PRJNA597223_P_NODE_12834_length_475_cov_2.990909_g11085_i0 | PRJNA597223 | 12834 | 475 | 2.990909 | 14.20681775 | Bufotes viridis | 30338 | Chordata | Chordata | 65.1 | 2.02e-9 | NR | CAK8641430.1 | 30338 | g11085 | i0 | 52.3 | 0.631578947368421 | 65 | 29 | 40.4 | 2 | 2 | 193 | 157 | 220 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 300 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 30869677 | 30869677 | PRJNA597223_P_NODE_30374_length_273_cov_2.214286_g28528_i0 | PRJNA597223 | 30374 | 273 | 2.214286 | 6.04500078 | Xenopus laevis | 8355 | Chordata | Chordata | 108 | 2.38e-25 | NR | XP_041419736.1 | 8355 | g28528 | i0 | 65 | 1.85714285714286 | 80 | 28 | 87.9 | 0 | 243 | 4 | 50 | 129 | XP_041419736.1 uncharacterized protein LOC121393946 [Xenopus laevis] | diamond | 507 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 31216869 | 31216869 | PRJNA597223_P_NODE_2015_length_1195_cov_4.658621_g1195_i3 | PRJNA597223 | 2015 | 1195 | 4.658621 | 55.67052095 | Xenopus tropicalis | 8364 | Chordata | Chordata | 222 | 4.53e-60 | NR | XP_017945114.2 | 8364 | g1195 | i3 | 42.4 | 2.13389121338912 | 290 | 152 | 70.3 | 4 | 4 | 843 | 1138 | 1422 | XP_017945114.2 uncharacterized protein LOC108644811 [Xenopus tropicalis] | diamond | 2550 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 31312102 | 31312102 | PRJNA597223_P_NODE_1835_length_1251_cov_4.421875_g1195_i0 | PRJNA597223 | 1835 | 1251 | 4.421875 | 55.31765625 | Xenopus tropicalis | 8364 | Chordata | Chordata | 222 | 7.94e-60 | NR | XP_017945114.2 | 8364 | g1195 | i0 | 42.4 | 2.03836930455636 | 290 | 152 | 67.1 | 4 | 4 | 843 | 1138 | 1422 | XP_017945114.2 uncharacterized protein LOC108644811 [Xenopus tropicalis] | diamond | 2550 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 31863042 | 31863042 | PRJNA597223_P_NODE_55057_length_189_cov_2.207792_g53211_i0 | PRJNA597223 | 55057 | 189 | 2.207792 | 4.17272688 | root | 1 | Root_unresolved | Root_unresolved | 125 | 1.7199999999999995e-31 | NR | XP_030109804.2 | 10090 | g53211 | i0 | 100 | 8.85714285714286 | 62 | 0 | 98.4 | 0 | 188 | 3 | 55 | 116 | XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus] | diamond | 1674 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 32084698 | 32084698 | PRJNA597223_P_NODE_9398_length_567_cov_3.849624_g7789_i0 | PRJNA597223 | 9398 | 567 | 3.849624 | 21.82736808 | Chordata | 7711 | Chordata | Chordata | 155 | 5.53e-40 | NR | XP_061431776.1 | 7753 | g7789 | i0 | 45.5 | 3.76719576719577 | 178 | 96 | 93.7 | 1 | 34 | 564 | 529 | 706 | XP_061431776.1 uncharacterized protein LOC133357699, partial [Lethenteron reissneri] | diamond | 2136 | 156 | 0.993589743589744 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lethenteron | Lethenteron reissneri | |
| 32324831 | 32324831 | PRJNA597223_S_NODE_4219_length_160_cov_2.049587_g4162_i0 | PRJNA597223 | 4219 | 160 | 2.049587 | 3.2793392 | Ovis aries | 9940 | Chordata | Chordata | 42.7 | 0.0119 | NR | XDA78294.1 | 9940 | g4162 | i0 | 42 | 0.9375 | 50 | 28 | 91.9 | 1 | 152 | 6 | 951 | 1000 | XDA78294.1 hypothetical protein R6Z07_008474 [Ovis aries] | diamond | 150 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 32369704 | 32369704 | PRJNA597223_S_NODE_2539_length_193_cov_1.428571_g2482_i0 | PRJNA597223 | 2539 | 193 | 1.428571 | 2.75714203 | Equus | 9789 | Chordata | Chordata | 43.1 | 0.0137 | NR | XP_070132068.1 | 9796 | g2482 | i0 | 52 | 1.55440414507772 | 50 | 23 | 77.7 | 1 | 191 | 42 | 155 | 203 | XP_070132068.1 clathrin heavy chain 2 isoform X1 [Equus caballus] | diamond | 300 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Equidae | Equus | Equus caballus | |
| 32671914 | 32671914 | PRJNA597223_P_NODE_29400_length_279_cov_3.327869_g27554_i0 | PRJNA597223 | 29400 | 279 | 3.327869 | 9.28475451 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 96.7 | 6.46e-21 | NR | CAH1225323.1 | 7740 | g27554 | i0 | 47.3 | 3.91397849462366 | 91 | 48 | 97.8 | 0 | 278 | 6 | 263 | 353 | CAH1225323.1 NYNRIN [Branchiostoma lanceolatum] | diamond | 1092 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 32829499 | 32829499 | PRJNA597223_P_NODE_18100_length_385_cov_7.811429_g16278_i0 | PRJNA597223 | 18100 | 385 | 7.811429 | 30.07400165 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.5 | 0.0307 | NR | KAG2471189.1 | 55291 | g16278 | i0 | 57.1 | 0.272727272727273 | 35 | 15 | 27.3 | 0 | 189 | 293 | 92 | 126 | KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 105 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus |
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);;