contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJEB6584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25524691 | 25524691 | PRJEB6584o_S_NODE_23185_length_193_cov_4.651899_g23077_i0 | PRJEB6584 | 23185 | 193 | 4.651899 | 8.97816507 | Opisthokonta | 33154 | Chordata | Chordata | 103 | 2.07e-25 | NR | XP_064419590.1 | 7897 | g23077 | i0 | 84.5 | 79.3678756476684 | 58 | 9 | 90.2 | 0 | 6 | 179 | 170 | 227 | XP_064419590.1 elongation factor 1-beta [Latimeria chalumnae] | diamond | 15318 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 26477527 | 26477527 | PRJEB6584o_S_NODE_3248_length_411_cov_1611.574468_g3140_i0 | PRJEB6584 | 3248 | 411 | 1611.574468 | 6623.57106348 | Anura | 8342 | Chordata | Chordata | 118 | 1.1199999999999999e-28 | NR | CAI9567216.1 | 386267 | g3140 | i0 | 74.7 | 7.89051094890511 | 83 | 21 | 60.6 | 0 | 389 | 141 | 296 | 378 | CAI9567216.1 unnamed protein product [Staurois parvus] | diamond | 3243 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32911956 | 32911956 | PRJEB6584h_S_NODE_73873_length_156_cov_1.322314_g73811_i0 | PRJEB6584 | 73873 | 156 | 1.322314 | 2.06280984 | Scyliorhinus canicula | 7830 | Chordata | Chordata | 92 | 8.379999999999999e-23 | NR | XP_038645752.1 | 7830 | g73811 | i0 | 80.4 | 1.94230769230769 | 51 | 10 | 98.1 | 0 | 2 | 154 | 13 | 63 | XP_038645752.1 acyl-CoA-binding protein [Scyliorhinus canicula] | diamond | 303 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 32922993 | 32922993 | PRJEB6584e_S_NODE_1593_length_218_cov_4.032787_g1578_i0 | PRJEB6584 | 1593 | 218 | 4.032787 | 8.79147566 | Metazoa | 33208 | Chordata | Chordata | 59.3 | 3.79e-8 | NR | XP_021107474.1 | 10181 | g1578 | i0 | 58.5 | 23.697247706422 | 41 | 17 | 56.4 | 0 | 2 | 124 | 222 | 262 | XP_021107474.1 elongation factor 1-gamma isoform X1 [Heterocephalus glaber] | diamond | 5166 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Bathyergidae | Heterocephalus | Heterocephalus glaber | |
| 32923024 | 32923024 | PRJEB6584m_S_NODE_2433_length_154_cov_6.126050_g2421_i0 | PRJEB6584 | 2433 | 154 | 6.12605 | 9.434117 | Artiodactyla | 91561 | Chordata | Chordata | 76.3 | 3.33e-15 | NR | KAB0348711.1 | 9888 | g2421 | i0 | 82 | 22.4025974025974 | 50 | 9 | 97.4 | 0 | 152 | 3 | 93 | 142 | KAB0348711.1 hypothetical protein FD754_013568 [Muntiacus muntjak] | diamond | 3450 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus muntjak | |
| 32957434 | 32957434 | PRJEB6584h_S_NODE_71650_length_157_cov_1.655738_g71588_i0 | PRJEB6584 | 71650 | 157 | 1.655738 | 2.59950866 | Metazoa | 33208 | Chordata | Chordata | 45.1 | 0.00179 | NR | XP_069461531.1 | 8296 | g71588 | i0 | 42 | 8.80891719745223 | 50 | 27 | 95.5 | 1 | 8 | 157 | 173 | 220 | XP_069461531.1 multiple epidermal growth factor-like domains protein 10 isoform X2 [Ambystoma mexicanum] | diamond | 1383 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 32963466 | 32963466 | PRJEB6584h_S_NODE_7930_length_215_cov_5.200000_g7868_i0 | PRJEB6584 | 7930 | 215 | 5.2 | 11.18 | Protopterus annectens | 7888 | Chordata | Chordata | 98.2 | 7.6900000000000005e-22 | NR | XP_043938962.1 | 7888 | g7868 | i0 | 95.9 | 14.0511627906977 | 49 | 2 | 68.4 | 0 | 178 | 32 | 633 | 681 | XP_043938962.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 1 [Protopterus annectens] | diamond | 3021 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 32974519 | 32974519 | PRJEB6584h_S_NODE_3554_length_275_cov_1.775000_g3492_i0 | PRJEB6584 | 3554 | 275 | 1.775 | 4.88125 | Branchiostoma | 7737 | Chordata | Chordata | 48.9 | 5.38e-5 | NR | XP_035679171.1 | 7739 | g3492 | i0 | 82.1 | 10.5054545454545 | 28 | 5 | 30.5 | 0 | 212 | 129 | 75 | 102 | XP_035679171.1 transcription and mRNA export factor ENY2 [Branchiostoma floridae] | diamond | 2889 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 32974522 | 32974522 | PRJEB6584h_S_NODE_7402_length_219_cov_2.336957_g7340_i0 | PRJEB6584 | 7402 | 219 | 2.336957 | 5.11793583 | Metazoa | 33208 | Chordata | Chordata | 43.5 | 0.0103 | NR | KAG8565506.1 | 76066 | g7340 | i0 | 58.3 | 5.17808219178082 | 36 | 13 | 49.3 | 1 | 17 | 124 | 5 | 38 | KAG8565506.1 hypothetical protein GDO81_012882 [Engystomops pustulosus] | diamond | 1134 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 32980518 | 32980518 | PRJEB6584e_S_NODE_315_length_361_cov_8.828221_g300_i0 | PRJEB6584 | 315 | 361 | 8.828221 | 31.86987781 | Pleurodeles waltl | 8319 | Chordata | Chordata | 83.6 | 7.75e-18 | NR | KAJ1178703.1 | 8319 | g300 | i0 | 52.1 | 6 | 73 | 35 | 60.7 | 0 | 310 | 92 | 9 | 81 | KAJ1178703.1 hypothetical protein NDU88_003945 [Pleurodeles waltl] | diamond | 2166 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 32981164 | 32981164 | PRJEB6584p_S_NODE_40395_length_166_cov_3.419847_g40364_i0 | PRJEB6584 | 40395 | 166 | 3.419847 | 5.67694602 | Branchiostoma floridae | 7739 | Chordata | Chordata | 42 | 0.02 | NR | XP_035674994.1 | 7739 | g40364 | i0 | 62.5 | 2.00602409638554 | 24 | 9 | 43.4 | 0 | 160 | 89 | 167 | 190 | XP_035674994.1 tubulin alpha-1 chain-like [Branchiostoma floridae] | diamond | 333 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 33008488 | 33008488 | PRJEB6584d_S_NODE_10827_length_187_cov_1.032895_g10759_i0 | PRJEB6584 | 10827 | 187 | 1.032895 | 1.93151365 | Opisthokonta | 33154 | Chordata | Chordata | 70.5 | 4.55e-13 | NR | CBY23715.1 | 34765 | g10759 | i0 | 56.7 | 12.8021390374332 | 60 | 25 | 94.7 | 1 | 2 | 178 | 126 | 185 | CBY23715.1 unnamed protein product [Oikopleura dioica] | diamond | 2394 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 33008490 | 33008490 | PRJEB6584e_S_NODE_2051_length_201_cov_1.879518_g2036_i0 | PRJEB6584 | 2051 | 201 | 1.879518 | 3.77783118 | Metazoa | 33208 | Chordata | Chordata | 84 | 6.63e-17 | NR | XP_069100182.1 | 8319 | g2036 | i0 | 67.2 | 37.0597014925373 | 67 | 22 | 100 | 0 | 201 | 1 | 626 | 692 | XP_069100182.1 major vault protein [Pleurodeles waltl] | diamond | 7449 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 33008518 | 33008518 | PRJEB6584m_S_NODE_1131_length_193_cov_3.056962_g1119_i0 | PRJEB6584 | 1131 | 193 | 3.056962 | 5.89993666 | Mammalia | 40674 | Chordata | Chordata | 53.5 | 3.07e-6 | NR | XP_025775084.1 | 9696 | g1119 | i0 | 97.5 | 14.1917098445596 | 40 | 1 | 62.2 | 0 | 193 | 74 | 450 | 489 | XP_025775084.1 LOW QUALITY PROTEIN: bromodomain adjacent to zinc finger domain protein 1A [Puma concolor] | diamond | 2739 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Puma | Puma concolor | |
| 33014836 | 33014836 | PRJEB6584o_S_NODE_26244_length_187_cov_4.276316_g26136_i0 | PRJEB6584 | 26244 | 187 | 4.276316 | 7.99671092 | Narcine bancroftii | 1343680 | Chordata | Chordata | 56.6 | 3.67e-8 | NR | XP_069777055.1 | 1343680 | g26136 | i0 | 59.2 | 7.13903743315508 | 49 | 20 | 78.6 | 0 | 6 | 152 | 88 | 136 | XP_069777055.1 large ribosomal subunit protein eL14 [Narcine bancroftii] | diamond | 1335 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Torpediniformes | Narcinidae | Narcine | Narcine bancroftii | |
| 33048758 | 33048758 | PRJEB6584o_S_NODE_14965_length_228_cov_4.538860_g14857_i0 | PRJEB6584 | 14965 | 228 | 4.53886 | 10.3486008 | Petromyzon marinus | 7757 | Chordata | Chordata | 84 | 5.69e-19 | NR | XP_032801518.1 | 7757 | g14857 | i0 | 95.3 | 2.82894736842105 | 43 | 2 | 56.6 | 0 | 3 | 131 | 62 | 104 | XP_032801518.1 cytochrome c-like [Petromyzon marinus] | diamond | 645 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 33059660 | 33059660 | PRJEB6584e_S_NODE_1621_length_217_cov_3.384615_g1606_i0 | PRJEB6584 | 1621 | 217 | 3.384615 | 7.34461455 | Opisthokonta | 33154 | Chordata | Chordata | 68.9 | 6.65e-13 | NR | AFK11590.1 | 7868 | g1606 | i0 | 65.3 | 16.258064516129 | 49 | 17 | 67.7 | 0 | 213 | 67 | 74 | 122 | AFK11590.1 ribosomal protein L22 like 1-like protein [Callorhinchus milii] | diamond | 3528 | 69.3 | 0.994227994227994 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 33059679 | 33059679 | PRJEB6584l_S_NODE_20885_length_161_cov_2.523810_g20733_i0 | PRJEB6584 | 20885 | 161 | 2.52381 | 4.0633341 | Mammalia | 40674 | Chordata | Chordata | 75.9 | 2.53e-14 | NR | XP_004872582.1 | 10181 | g20733 | i0 | 83.7 | 1.84472049689441 | 49 | 8 | 91.3 | 0 | 156 | 10 | 329 | 377 | XP_004872582.1 A-kinase anchor protein 8 [Heterocephalus glaber] | diamond | 297 | 76.6 | 0.990861618798956 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Bathyergidae | Heterocephalus | Heterocephalus glaber | |
| 33065718 | 33065718 | PRJEB6584m_S_NODE_445_length_265_cov_28.334783_g433_i0 | PRJEB6584 | 445 | 265 | 28.334783 | 75.08717495 | Choloepus didactylus | 27675 | Chordata | Chordata | 74.3 | 1.09e-13 | NR | XP_037703436.1 | 27675 | g433 | i0 | 91.3 | 0.520754716981132 | 46 | 4 | 52.1 | 0 | 25 | 162 | 205 | 250 | XP_037703436.1 basic proline-rich protein-like [Choloepus didactylus] | diamond | 138 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pilosa | Megalonychidae | Choloepus | Choloepus didactylus | |
| 33099756 | 33099756 | PRJEB6584e_S_NODE_1350_length_231_cov_3.061224_g1335_i0 | PRJEB6584 | 1350 | 231 | 3.061224 | 7.07142744 | Patagioenas fasciata monilis | 372326 | Chordata | Chordata | 77.8 | 4.36e-16 | NR | OPJ87061.1 | 372326 | g1335 | i0 | 59.6 | 2.02597402597403 | 52 | 21 | 67.5 | 0 | 3 | 158 | 26 | 77 | OPJ87061.1 hypothetical protein AV530_010031 [Patagioenas fasciata monilis] | diamond | 468 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Columbiformes | Columbidae | Patagioenas | Patagioenas fasciata | |
| 33116830 | 33116830 | PRJEB6584h_S_NODE_82831_length_151_cov_1.887931_g82769_i0 | PRJEB6584 | 82831 | 151 | 1.887931 | 2.85077581 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 58.5 | 2.84e-8 | NR | CAK8676643.1 | 159417 | g82769 | i0 | 59.5 | 0.834437086092715 | 42 | 17 | 83.4 | 0 | 151 | 26 | 1164 | 1205 | CAK8676643.1 unnamed protein product [Clavelina lepadiformis] | diamond | 126 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 33116876 | 33116876 | PRJEB6584l_S_NODE_20423_length_162_cov_3.433071_g20271_i0 | PRJEB6584 | 20423 | 162 | 3.433071 | 5.56157502 | Myotis myotis | 51298 | Chordata | Chordata | 54.7 | 9.57e-8 | NR | KAF6385940.1 | 51298 | g20271 | i0 | 92.6 | 0.5 | 27 | 2 | 50 | 0 | 162 | 82 | 53 | 79 | KAF6385940.1 acidic nuclear phosphoprotein 32 family member A [Myotis myotis] | diamond | 81 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis myotis | |
| 33145035 | 33145035 | PRJEB6584e_S_NODE_231_length_397_cov_3.566298_g216_i0 | PRJEB6584 | 231 | 397 | 3.566298 | 14.15820306 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 148 | 4.659999999999998e-42 | NR | XP_035658935.1 | 7739 | g216 | i0 | 70.5 | 16.3299748110831 | 95 | 28 | 71.8 | 0 | 397 | 113 | 29 | 123 | XP_035658935.1 40S ribosomal protein S8-like [Branchiostoma floridae] | diamond | 6483 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 33150966 | 33150966 | PRJEB6584e_S_NODE_2320_length_191_cov_1.538462_g2305_i0 | PRJEB6584 | 2320 | 191 | 1.538462 | 2.93846242 | Branchiostoma floridae | 7739 | Chordata | Chordata | 42 | 0.0273 | NR | XP_035674994.1 | 7739 | g2305 | i0 | 62.5 | 0.37696335078534 | 24 | 9 | 37.7 | 0 | 190 | 119 | 167 | 190 | XP_035674994.1 tubulin alpha-1 chain-like [Branchiostoma floridae] | diamond | 72 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 33151341 | 33151341 | PRJEB6584o_S_NODE_26296_length_187_cov_2.875000_g26188_i0 | PRJEB6584 | 26296 | 187 | 2.875 | 5.37625 | Circaetus pectoralis | 321084 | Chordata | Chordata | 42.4 | 0.025 | NR | NXW18758.1 | 321084 | g26188 | i0 | 48.8 | 0.657754010695187 | 41 | 21 | 65.8 | 0 | 187 | 65 | 651 | 691 | NXW18758.1 CLCN2 protein [Circaetus pectoralis] | diamond | 123 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Accipitriformes | Accipitridae | Circaetus | Circaetus pectoralis | |
| 33167946 | 33167946 | PRJEB6584e_S_NODE_3424_length_164_cov_2.480620_g3409_i0 | PRJEB6584 | 3424 | 164 | 2.48062 | 4.0682168 | Petromyzon marinus | 7757 | Chordata | Chordata | 90.9 | 4.37e-22 | NR | XP_032801518.1 | 7757 | g3409 | i0 | 91.5 | 7.70121951219512 | 47 | 4 | 86 | 0 | 2 | 142 | 58 | 104 | XP_032801518.1 cytochrome c-like [Petromyzon marinus] | diamond | 1263 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 33167961 | 33167961 | PRJEB6584h_S_NODE_46016_length_165_cov_1.992308_g45954_i0 | PRJEB6584 | 46016 | 165 | 1.992308 | 3.2873082 | Xenopus tropicalis | 8364 | Chordata | Chordata | 61.6 | 2.91e-9 | NR | XP_012809139.1 | 8364 | g45954 | i0 | 58.5 | 0.963636363636364 | 53 | 22 | 96.4 | 0 | 7 | 165 | 2745 | 2797 | XP_012809139.1 E3 ubiquitin-protein ligase RNF213 [Xenopus tropicalis] | diamond | 159 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis |
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);;