contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJEB2925" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1300302 | 1300302 | PRJEB2925_P_NODE_10702_length_346_cov_2.668810_g9429_i0 | PRJEB2925 | 10702 | 346 | 2.66881 | 9.2340826 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 112 | 3.0800000000000004e-27 | NR | XP_052036980.1 | 10129 | g9429 | i0 | 60.7 | 5.58381502890173 | 107 | 42 | 92.8 | 0 | 337 | 17 | 198 | 304 | XP_052036980.1 60S ribosomal protein L35 [Apodemus sylvaticus] | diamond | 1932 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus sylvaticus | |
| 3852289 | 3852289 | PRJEB2925_P_NODE_5704_length_557_cov_2.101533_g4638_i0 | PRJEB2925 | 5704 | 557 | 2.101533 | 11.70553881 | Protopterus annectens | 7888 | Chordata | Chordata | 112 | 4.1e-25 | NR | XP_043942230.1 | 7888 | g4638 | i0 | 51 | 0.78096947935368 | 145 | 61 | 72.7 | 1 | 555 | 151 | 608 | 752 | XP_043942230.1 major vault protein [Protopterus annectens] | diamond | 435 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 10228821 | 10228821 | PRJEB2925_P_NODE_11569_length_323_cov_2.055556_g10294_i0 | PRJEB2925 | 11569 | 323 | 2.055556 | 6.63944588 | Metazoa | 33208 | Chordata | Chordata | 152 | 2.47e-41 | NR | XP_038650316.1 | 7830 | g10294 | i0 | 79.6 | 17.359133126935 | 93 | 5 | 73.4 | 1 | 1 | 237 | 377 | 469 | XP_038650316.1 histone-binding protein RBBP4 isoform X1 [Scyliorhinus canicula] | diamond | 5607 | 153 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 10228834 | 10228834 | PRJEB2925_P_NODE_12529_length_301_cov_4.030075_g11252_i0 | PRJEB2925 | 12529 | 301 | 4.030075 | 12.13052575 | Opisthokonta | 33154 | Chordata | Chordata | 145 | 1.83e-41 | NR | KAJ8777644.1 | 9764 | g11252 | i0 | 70.8 | 33.2491694352159 | 96 | 28 | 95.7 | 0 | 12 | 299 | 61 | 156 | KAJ8777644.1 hypothetical protein J1605_014297 [Eschrichtius robustus] | diamond | 10008 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 26780153 | 26780153 | PRJEB2925_P_NODE_15961_length_248_cov_4.924883_g14683_i0 | PRJEB2925 | 15961 | 248 | 4.924883 | 12.21370984 | Xenopus laevis | 8355 | Chordata | Chordata | 111 | 7.68e-27 | NR | NP_001091345.1 | 8355 | g14683 | i0 | 71.2 | 0.883064516129032 | 73 | 21 | 88.3 | 0 | 248 | 30 | 49 | 121 | NP_001091345.1 uncharacterized protein LOC100037184 [Xenopus laevis] | diamond | 219 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 27406240 | 27406240 | PRJEB2925_P_NODE_9623_length_379_cov_2.113372_g8352_i0 | PRJEB2925 | 9623 | 379 | 2.113372 | 8.00967988 | root | 1 | Root_unresolved | Root_unresolved | 69.7 | 5.11e-11 | NR | XP_040296147.1 | 8384 | g8352 | i0 | 51.5 | 4.14775725593668 | 66 | 28 | 51.5 | 3 | 202 | 8 | 11 | 73 | XP_040296147.1 serine protease 33-like [Bufo bufo] | diamond | 1572 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo bufo | |
| 27728630 | 27728630 | PRJEB2925_P_NODE_14944_length_262_cov_1.665198_g13666_i0 | PRJEB2925 | 14944 | 262 | 1.665198 | 4.36281876 | Capra hircus | 9925 | Chordata | Chordata | 53.1 | 1.07e-5 | NR | XP_017900969.1 | 9925 | g13666 | i0 | 63.6 | 0.629770992366412 | 55 | 20 | 63 | 0 | 205 | 41 | 587 | 641 | XP_017900969.1 PREDICTED: fibroin heavy chain-like, partial [Capra hircus] | diamond | 165 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 27823157 | 27823157 | PRJEB2925_P_NODE_13124_length_290_cov_2.760784_g11847_i0 | PRJEB2925 | 13124 | 290 | 2.760784 | 8.0062736 | Scyliorhinus canicula | 7830 | Chordata | Chordata | 47.8 | 1.53e-4 | NR | XP_038646025.1 | 7830 | g11847 | i0 | 65.7 | 4.48965517241379 | 35 | 12 | 36.2 | 0 | 270 | 166 | 42 | 76 | XP_038646025.1 60S ribosomal protein L39-like [Scyliorhinus canicula] | diamond | 1302 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 28138958 | 28138958 | PRJEB2925_P_NODE_10425_length_353_cov_273.896226_g9153_i0 | PRJEB2925 | 10425 | 353 | 273.896226 | 966.85367778 | Bufotes viridis | 30338 | Chordata | Chordata | 46.2 | 0.00708 | NR | CAK8629749.1 | 30338 | g9153 | i0 | 51.2 | 0.688385269121813 | 43 | 21 | 36.5 | 0 | 69 | 197 | 322 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 243 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28864855 | 28864855 | PRJEB2925_P_NODE_17108_length_224_cov_62.603175_g15830_i0 | PRJEB2925 | 17108 | 224 | 62.603175 | 140.231112 | Bufotes viridis | 30338 | Chordata | Chordata | 52.4 | 1.12e-5 | NR | CAK8629749.1 | 30338 | g15830 | i0 | 51.2 | 0.575892857142857 | 43 | 21 | 57.6 | 0 | 69 | 197 | 322 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 129 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28921414 | 28921414 | PRJEB2925_P_NODE_17128_length_223_cov_3.505319_g15850_i0 | PRJEB2925 | 17128 | 223 | 3.505319 | 7.81686137 | Mammalia | 40674 | Chordata | Chordata | 67 | 1.58e-11 | NR | DAA15291.1 | 9913 | g15850 | i0 | 60.6 | 18.6457399103139 | 66 | 26 | 88.8 | 0 | 198 | 1 | 77 | 142 | DAA15291.1 TPA: hypothetical protein BOS_23236 [Bos taurus] | diamond | 4158 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 29528058 | 29528058 | PRJEB2925_P_NODE_16970_length_229_cov_7.345361_g15692_i0 | PRJEB2925 | 16970 | 229 | 7.345361 | 16.82087669 | Bufotes viridis | 30338 | Chordata | Chordata | 46.6 | 0.00128 | NR | CAK8629749.1 | 30338 | g15692 | i0 | 79.2 | 0.314410480349345 | 24 | 5 | 31.4 | 0 | 110 | 39 | 335 | 358 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 72 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 30064737 | 30064737 | PRJEB2925_P_NODE_13052_length_291_cov_8.914062_g11775_i0 | PRJEB2925 | 13052 | 291 | 8.914062 | 25.93992042 | Bufotes viridis | 30338 | Chordata | Chordata | 49.7 | 2.29e-4 | NR | CAK8629749.1 | 30338 | g11775 | i0 | 66.7 | 0.917525773195876 | 33 | 11 | 34 | 0 | 288 | 190 | 331 | 363 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 267 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 30121394 | 30121394 | PRJEB2925_P_NODE_11872_length_316_cov_1.597865_g10597_i0 | PRJEB2925 | 11872 | 316 | 1.597865 | 5.0492534 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57.8 | 5.06e-8 | NR | 3J0L_S | 9986 | g10597 | i0 | 87.9 | 0.626582278481013 | 33 | 4 | 31.3 | 0 | 2 | 100 | 41 | 73 | 3J0L_S Chain S, Ribosomal protein S15 [Oryctolagus cuniculus] | diamond | 198 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 31012704 | 31012704 | PRJEB2925_P_NODE_15975_length_248_cov_2.652582_g14697_i0 | PRJEB2925 | 15975 | 248 | 2.652582 | 6.57840336 | Apodemus sylvaticus | 10129 | Chordata | Chordata | 56.6 | 4.53e-7 | NR | XP_052024752.1 | 10129 | g14697 | i0 | 78 | 2.47983870967742 | 41 | 9 | 49.6 | 0 | 2 | 124 | 226 | 266 | XP_052024752.1 LOW QUALITY PROTEIN: serine/arginine repetitive matrix protein 1-like [Apodemus sylvaticus] | diamond | 615 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus sylvaticus | |
| 32176621 | 32176621 | PRJEB2925_P_NODE_13078_length_291_cov_2.031250_g11801_i0 | PRJEB2925 | 13078 | 291 | 2.03125 | 5.9109375 | Metazoa | 33208 | Chordata | Chordata | 48.1 | 7.39e-4 | NR | XP_035681971.1 | 7739 | g11801 | i0 | 60.6 | 0.597938144329897 | 33 | 12 | 33 | 1 | 127 | 222 | 37 | 69 | XP_035681971.1 integumentary mucin C.1-like [Branchiostoma floridae] | diamond | 174 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 32594245 | 32594245 | PRJEB2925_P_NODE_17480_length_199_cov_115.713415_g16202_i0 | PRJEB2925 | 17480 | 199 | 115.713415 | 230.26969585 | Bufotes viridis | 30338 | Chordata | Chordata | 44.3 | 0.0057 | NR | CAK8629749.1 | 30338 | g16202 | i0 | 73.1 | 0.391959798994975 | 26 | 7 | 39.2 | 0 | 158 | 81 | 335 | 360 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 78 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 32619087 | 32619087 | PRJEB2925_P_NODE_6760_length_496_cov_7.787419_g5607_i0 | PRJEB2925 | 6760 | 496 | 7.787419 | 38.62559824 | Chordata | 7711 | Chordata | Chordata | 194 | 3.2e-60 | NR | KAK9406484.1 | 8729 | g5607 | i0 | 67.1 | 60.3447580645161 | 146 | 44 | 86.5 | 2 | 470 | 42 | 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 |
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);;