contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJEB3181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12809457 | 12809457 | PRJEB3181_P_NODE_1651_length_513_cov_9.280083_g1484_i0 | PRJEB3181 | 1651 | 513 | 9.280083 | 47.60682579 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 246 | 2.72e-77 | NR | AAY33974.1 | 8667 | g1484 | i0 | 74.1 | 36.0116959064327 | 158 | 40 | 91.8 | 1 | 513 | 43 | 249 | 406 | AAY33974.1 elongation factor 2 [Oxyuranus scutellatus scutellatus] | diamond | 18474 | 247 | 0.995951417004049 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Oxyuranus | Oxyuranus scutellatus | |
| 12809475 | 12809475 | PRJEB3181_P_NODE_2031_length_484_cov_18.390728_g1847_i0 | PRJEB3181 | 2031 | 484 | 18.390728 | 89.01112352 | Metazoa | 33208 | Chordata | Chordata | 220 | 8.709999999999999e-67 | NR | NP_001088028.1 | 8355 | g1847 | i0 | 75.9 | 20.504132231405 | 137 | 33 | 84.9 | 0 | 3 | 413 | 308 | 444 | NP_001088028.1 uncharacterized protein LOC494720 [Xenopus laevis] | diamond | 9924 | 222 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 17907724 | 17907724 | PRJEB3181_S_NODE_2875_length_329_cov_4.625850_g2582_i0 | PRJEB3181 | 2875 | 329 | 4.62585 | 15.2190465 | root | 1 | Root_unresolved | Root_unresolved | 115 | 1.71e-29 | NR | ELK10587.1 | 9402 | g2582 | i0 | 64 | 42.3738601823708 | 86 | 31 | 78.4 | 0 | 327 | 70 | 117 | 202 | ELK10587.1 60S ribosomal protein L22 [Pteropus alecto] | diamond | 13941 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Pteropus | Pteropus alecto | |
| 27064847 | 27064847 | PRJEB3181_P_NODE_6162_length_332_cov_7.109635_g5905_i0 | PRJEB3181 | 6162 | 332 | 7.109635 | 23.6039882 | Equus caballus | 9796 | Chordata | Chordata | 47 | 0.00328 | NR | XP_070092295.1 | 9796 | g5905 | i0 | 38.1 | 0.759036144578313 | 84 | 47 | 75.9 | 2 | 28 | 279 | 447 | 525 | XP_070092295.1 paired box protein Pax-8 isoform X2 [Equus caballus] | diamond | 252 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Equidae | Equus | Equus caballus | |
| 27538938 | 27538938 | PRJEB3181_S_NODE_14284_length_171_cov_3.058824_g13991_i0 | PRJEB3181 | 14284 | 171 | 3.058824 | 5.23058904 | Branchiostoma floridae | 7739 | Chordata | Chordata | 42 | 0.0208 | NR | XP_035674994.1 | 7739 | g13991 | i0 | 62.5 | 1.94736842105263 | 24 | 9 | 42.1 | 0 | 164 | 93 | 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 | |
| 27760190 | 27760190 | PRJEB3181_P_NODE_14544_length_221_cov_2.863158_g14280_i0 | PRJEB3181 | 14544 | 221 | 2.863158 | 6.32757918 | Xenopus tropicalis | 8364 | Chordata | Chordata | 48.9 | 1.84e-4 | NR | KAE8626226.1 | 8364 | g14280 | i0 | 40 | 3.36651583710407 | 60 | 36 | 81.4 | 0 | 3 | 182 | 23 | 82 | KAE8626226.1 hypothetical protein XENTR_v10006553 [Xenopus tropicalis] | diamond | 744 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 28479621 | 28479621 | PRJEB3181_S_NODE_8426_length_217_cov_3.813187_g8133_i0 | PRJEB3181 | 8426 | 217 | 3.813187 | 8.27461579 | Mammalia | 40674 | Chordata | Chordata | 70.5 | 1.3e-13 | NR | XP_035294684.1 | 10029 | g8133 | i0 | 64.2 | 55.6866359447005 | 53 | 19 | 73.3 | 0 | 213 | 55 | 62 | 114 | XP_035294684.1 60S ribosomal protein L23a isoform X2 [Cricetulus griseus] | diamond | 12084 | 71.2 | 0.990168539325843 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 28770191 | 28770191 | PRJEB3181_S_NODE_17807_length_154_cov_1.680672_g17514_i0 | PRJEB3181 | 17807 | 154 | 1.680672 | 2.58823488 | Phodopus roborovskii | 109678 | Chordata | Chordata | 78.2 | 2.56e-17 | NR | CAH7471028.1 | 109678 | g17514 | i0 | 60.8 | 126.954545454545 | 51 | 20 | 99.4 | 0 | 154 | 2 | 1 | 51 | CAH7471028.1 unknown_gene_1596 [Phodopus roborovskii] | diamond | 19551 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Phodopus | Phodopus roborovskii | |
| 29149521 | 29149521 | PRJEB3181_S_NODE_12709_length_181_cov_3.287671_g12416_i0 | PRJEB3181 | 12709 | 181 | 3.287671 | 5.95068451 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 44.7 | 3.75e-4 | NR | 3J0L_X | 9986 | g12416 | i0 | 50 | 0.729281767955801 | 44 | 18 | 66.3 | 2 | 179 | 60 | 19 | 62 | 3J0L_X Chain X, Ribosomal protein S30 [Oryctolagus cuniculus] | diamond | 132 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 29938628 | 29938628 | PRJEB3181_P_NODE_27311_length_153_cov_1.803279_g27046_i0 | PRJEB3181 | 27311 | 153 | 1.803279 | 2.75901687 | Gekko japonicus | 146911 | Chordata | Chordata | 80.1 | 7.18e-16 | NR | XP_015284848.1 | 146911 | g27046 | i0 | 70 | 0.980392156862745 | 50 | 15 | 98 | 0 | 152 | 3 | 50 | 99 | XP_015284848.1 PREDICTED: thioredoxin reductase 3 isoform X1 [Gekko japonicus] | diamond | 150 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Gekkonidae | Gekko | Gekko japonicus | |
| 30096376 | 30096376 | PRJEB3181_S_NODE_7372_length_230_cov_3.887179_g7079_i0 | PRJEB3181 | 7372 | 230 | 3.887179 | 8.9405117 | Sigmodon hispidus | 42415 | Chordata | Chordata | 50.1 | 7.71e-5 | NR | KAL1767697.1 | 42415 | g7079 | i0 | 51.2 | 0.560869565217391 | 43 | 21 | 56.1 | 0 | 3 | 131 | 153 | 195 | KAL1767697.1 ADP-ribosylation factor 3 [Sigmodon hispidus] | diamond | 129 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Sigmodon | Sigmodon hispidus | |
| 30254769 | 30254769 | PRJEB3181_S_NODE_11332_length_191_cov_1.198718_g11039_i0 | PRJEB3181 | 11332 | 191 | 1.198718 | 2.28955138 | Staurois parvus | 386267 | Chordata | Chordata | 42 | 0.00994 | NR | CAI9547784.1 | 386267 | g11039 | i0 | 60 | 0.392670157068063 | 25 | 10 | 39.3 | 0 | 77 | 3 | 5 | 29 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 75 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30381256 | 30381256 | PRJEB3181_P_NODE_18933_length_190_cov_1.169811_g18669_i0 | PRJEB3181 | 18933 | 190 | 1.169811 | 2.2226409 | Lerista edwardsae | 470340 | Chordata | Chordata | 77.8 | 3.28e-15 | NR | KAJ6653748.1 | 470340 | g18669 | i0 | 67.3 | 37.5789473684211 | 55 | 18 | 86.8 | 0 | 189 | 25 | 227 | 281 | KAJ6653748.1 hypothetical protein lerEdw1_008775 [Lerista edwardsae] | diamond | 7140 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Scincidae | Lerista | Lerista edwardsae | |
| 30753486 | 30753486 | PRJEB3181_P_NODE_27314_length_153_cov_1.786885_g27049_i0 | PRJEB3181 | 27314 | 153 | 1.786885 | 2.73393405 | Chordata | 7711 | Chordata | Chordata | 48.9 | 1.99e-5 | NR | XP_035694108.1 | 7739 | g27049 | i0 | 65.6 | 1.25490196078431 | 32 | 11 | 62.7 | 0 | 152 | 57 | 99 | 130 | XP_035694108.1 profilin-1B-like isoform X2 [Branchiostoma floridae] | diamond | 192 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 30854735 | 30854735 | PRJEB3181_P_NODE_12154_length_243_cov_4.485849_g11890_i0 | PRJEB3181 | 12154 | 243 | 4.485849 | 10.90061307 | Petromyzon marinus | 7757 | Chordata | Chordata | 95.5 | 1.9099999999999998e-23 | NR | XP_032801518.1 | 7757 | g11890 | i0 | 91.8 | 5.41975308641975 | 49 | 4 | 60.5 | 0 | 242 | 96 | 56 | 104 | XP_032801518.1 cytochrome c-like [Petromyzon marinus] | diamond | 1317 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 31076068 | 31076068 | PRJEB3181_P_NODE_26435_length_156_cov_1.240000_g26170_i0 | PRJEB3181 | 26435 | 156 | 1.24 | 1.9344 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 46.2 | 6.75e-4 | NR | KAI8514053.1 | 7741 | g26170 | i0 | 48.8 | 0.826923076923077 | 43 | 21 | 82.7 | 1 | 3 | 131 | 370 | 411 | KAI8514053.1 hypothetical protein Bbelb_083770 [Branchiostoma belcheri] | diamond | 129 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31163905 | 31163905 | PRJEB3181_P_NODE_24755_length_162_cov_1.862595_g24490_i0 | PRJEB3181 | 24755 | 162 | 1.862595 | 3.0174039 | Metazoa | 33208 | Chordata | Chordata | 103 | 1.54e-26 | NR | NP_001279315.1 | 7868 | g24490 | i0 | 88.7 | 188.555555555556 | 53 | 6 | 98.1 | 0 | 1 | 159 | 45 | 97 | NP_001279315.1 eukaryotic translation initiation factor 5A-2 [Callorhinchus milii] | diamond | 30546 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 31739878 | 31739878 | PRJEB3181_P_NODE_19577_length_186_cov_2.774194_g19313_i0 | PRJEB3181 | 19577 | 186 | 2.774194 | 5.16000084 | Suncus etruscus | 109475 | Chordata | Chordata | 45.4 | 6.15e-4 | NR | XP_049621617.1 | 109475 | g19313 | i0 | 50 | 0.67741935483871 | 42 | 20 | 66.1 | 1 | 186 | 64 | 46 | 87 | XP_049621617.1 40S ribosomal protein S27-like [Suncus etruscus] | diamond | 126 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 32024824 | 32024824 | PRJEB3181_P_NODE_27978_length_151_cov_1.441667_g27713_i0 | PRJEB3181 | 27978 | 151 | 1.441667 | 2.17691717 | Polypterus senegalus | 55291 | Chordata | Chordata | 66.6 | 3.22e-11 | NR | KAG2460242.1 | 55291 | g27713 | i0 | 64.9 | 29.9403973509934 | 37 | 13 | 73.5 | 0 | 116 | 6 | 247 | 283 | KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 4521 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 32024827 | 32024827 | PRJEB3181_S_NODE_17558_length_155_cov_2.000000_g17265_i0 | PRJEB3181 | 17558 | 155 | 2 | 3.1 | Xenopus laevis | 8355 | Chordata | Chordata | 80.5 | 5.15e-16 | NR | NP_001091127.1 | 8355 | g17265 | i0 | 79.5 | 1.70322580645161 | 44 | 9 | 85.2 | 0 | 2 | 133 | 416 | 459 | NP_001091127.1 uncharacterized protein LOC100036877 [Xenopus laevis] | diamond | 264 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 32814523 | 32814523 | PRJEB3181_P_NODE_6000_length_336_cov_2.626230_g5743_i0 | PRJEB3181 | 6000 | 336 | 2.62623 | 8.8241328 | Lampetra fluviatilis | 7748 | Chordata | Chordata | 74.7 | 1.91e-14 | NR | CAL5932256.1 | 7748 | g5743 | i0 | 58.2 | 1.75 | 98 | 34 | 83.9 | 2 | 331 | 50 | 39 | 133 | CAL5932256.1 unnamed protein product [Lampetra fluviatilis] | diamond | 588 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis |
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);;