contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1013345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26654724 | 26654724 | PRJNA1013345_P_NODE_18701_length_174_cov_1.866142_g18571_i0 | PRJNA1013345 | 18701 | 174 | 1.866142 | 3.24708708 | Orcinus orca | 9733 | Chordata | Chordata | 48.1 | 1.82e-4 | NR | XP_049565758.1 | 9733 | g18571 | i0 | 51.2 | 1.41379310344828 | 41 | 20 | 70.7 | 0 | 49 | 171 | 229 | 269 | XP_049565758.1 uncharacterized protein LOC125964388 [Orcinus orca] | diamond | 246 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Orcinus | Orcinus orca | |
| 26749568 | 26749568 | PRJNA1013345_P_NODE_4121_length_294_cov_0.716599_g3992_i0 | PRJNA1013345 | 4121 | 294 | 0.716599 | 2.10680106 | Bufotes viridis | 30338 | Chordata | Chordata | 44.7 | 0.0137 | NR | CAK8609802.1 | 30338 | g3992 | i0 | 67.9 | 0.285714285714286 | 28 | 9 | 28.6 | 0 | 209 | 292 | 1 | 28 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 84 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27129233 | 27129233 | PRJNA1013345_P_NODE_21582_length_168_cov_1.685950_g21452_i0 | PRJNA1013345 | 21582 | 168 | 1.68595 | 2.832396 | Polypterus senegalus | 55291 | Chordata | Chordata | 42 | 0.0253 | NR | XP_039606434.1 | 55291 | g21452 | i0 | 80.8 | 31.1071428571429 | 26 | 5 | 46.4 | 0 | 2 | 79 | 92 | 117 | XP_039606434.1 potassium/sodium hyperpolarization-activated cyclic nucleotide-gated channel 1 isoform X2 [Polypterus senegalus] | diamond | 5226 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 27603789 | 27603789 | PRJNA1013345_P_NODE_2864_length_341_cov_4.897959_g2737_i0 | PRJNA1013345 | 2864 | 341 | 4.897959 | 16.70204019 | Bufotes viridis | 30338 | Chordata | Chordata | 45.8 | 0.00899 | NR | CAK8609802.1 | 30338 | g2737 | i0 | 64.5 | 0.483870967741935 | 31 | 11 | 27.3 | 0 | 248 | 340 | 1 | 31 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 165 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27666883 | 27666883 | PRJNA1013345_P_NODE_16924_length_178_cov_1.557252_g16794_i0 | PRJNA1013345 | 16924 | 178 | 1.557252 | 2.77190856 | Bufotes viridis | 30338 | Chordata | Chordata | 43.5 | 0.00804 | NR | CAK8629749.1 | 30338 | g16794 | i0 | 70.4 | 0.455056179775281 | 27 | 8 | 45.5 | 0 | 143 | 63 | 335 | 361 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 81 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27887632 | 27887632 | PRJNA1013345_P_NODE_27005_length_161_cov_2.517544_g26875_i0 | PRJNA1013345 | 27005 | 161 | 2.517544 | 4.05324584 | Phyllostomus discolor | 89673 | Chordata | Chordata | 41.6 | 0.0316 | NR | XP_035869557.1 | 89673 | g26875 | i0 | 35.3 | 0.950310559006211 | 51 | 32 | 95 | 1 | 4 | 156 | 62 | 111 | XP_035869557.1 LOW QUALITY PROTEIN: ubiquitin carboxyl-terminal hydrolase isozyme L5-like [Phyllostomus discolor] | diamond | 153 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 28613941 | 28613941 | PRJNA1013345_P_NODE_2867_length_341_cov_4.204082_g2737_i1 | PRJNA1013345 | 2867 | 341 | 4.204082 | 14.33591962 | Bufotes viridis | 30338 | Chordata | Chordata | 45.8 | 0.00899 | NR | CAK8609802.1 | 30338 | g2737 | i1 | 64.5 | 0.483870967741935 | 31 | 11 | 27.3 | 0 | 248 | 340 | 1 | 31 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 165 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 29403305 | 29403305 | PRJNA1013345_P_NODE_23149_length_165_cov_1.635593_g23019_i0 | PRJNA1013345 | 23149 | 165 | 1.635593 | 2.69872845 | Bufotes viridis | 30338 | Chordata | Chordata | 46.2 | 7.55e-4 | NR | CAK8629749.1 | 30338 | g23019 | i0 | 60.7 | 0.509090909090909 | 28 | 11 | 50.9 | 0 | 27 | 110 | 337 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 84 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 29971666 | 29971666 | PRJNA1013345_P_NODE_11091_length_197_cov_2.993333_g10961_i0 | PRJNA1013345 | 11091 | 197 | 2.993333 | 5.89686601 | Staurois parvus | 386267 | Chordata | Chordata | 53.1 | 2.31e-7 | NR | CAI9540006.1 | 386267 | g10961 | i0 | 56.8 | 0.67005076142132 | 44 | 19 | 67 | 0 | 31 | 162 | 1 | 44 | CAI9540006.1 unnamed protein product, partial [Staurois parvus] | diamond | 132 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30034963 | 30034963 | PRJNA1013345_P_NODE_13091_length_187_cov_1.807143_g12961_i0 | PRJNA1013345 | 13091 | 187 | 1.807143 | 3.37935741 | Canis lupus dingo | 286419 | Chordata | Chordata | 52.4 | 6.74e-6 | NR | XP_048968551.1 | 286419 | g12961 | i0 | 92.6 | 0.433155080213904 | 27 | 2 | 43.3 | 0 | 105 | 185 | 411 | 437 | XP_048968551.1 DNA polymerase iota isoform X7 [Canis lupus dingo] | diamond | 81 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 30153224 | 30153224 | PRJNA1013345_P_NODE_13452_length_186_cov_1.467626_g13322_i0 | PRJNA1013345 | 13452 | 186 | 1.467626 | 2.72978436 | Bufonidae | 8382 | Chordata | Chordata | 47.8 | 3.09e-4 | NR | XP_044141565.1 | 30331 | g13322 | i0 | 39.7 | 4.7741935483871 | 58 | 35 | 93.5 | 0 | 177 | 4 | 338 | 395 | XP_044141565.1 cytidine monophosphate-N-acetylneuraminic acid hydroxylase-like [Bufo gargarizans] | diamond | 888 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo gargarizans | |
| 30603466 | 30603466 | PRJNA1013345_P_NODE_21753_length_168_cov_1.049587_g21623_i0 | PRJNA1013345 | 21753 | 168 | 1.049587 | 1.76330616 | Staurois parvus | 386267 | Chordata | Chordata | 53.1 | 1.62e-7 | NR | CAI9540006.1 | 386267 | g21623 | i0 | 59.1 | 0.785714285714286 | 44 | 18 | 78.6 | 0 | 138 | 7 | 1 | 44 | CAI9540006.1 unnamed protein product, partial [Staurois parvus] | diamond | 132 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30982913 | 30982913 | PRJNA1013345_P_NODE_33014_length_154_cov_7.355140_g32884_i0 | PRJNA1013345 | 33014 | 154 | 7.35514 | 11.3269156 | Bufotes viridis | 30338 | Chordata | Chordata | 42.4 | 0.0148 | NR | CAK8609802.1 | 30338 | g32884 | i0 | 57.6 | 0.642857142857143 | 33 | 14 | 64.3 | 0 | 51 | 149 | 1 | 33 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 99 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31457072 | 31457072 | PRJNA1013345_P_NODE_13776_length_185_cov_1.985507_g13646_i0 | PRJNA1013345 | 13776 | 185 | 1.985507 | 3.67318795 | Pleurodeles waltl | 8319 | Chordata | Chordata | 42.4 | 0.0197 | NR | KAJ1170931.1 | 8319 | g13646 | i0 | 54.2 | 0.778378378378378 | 48 | 20 | 76.2 | 2 | 3 | 143 | 153 | 199 | KAJ1170931.1 hypothetical protein NDU88_002802 [Pleurodeles waltl] | diamond | 144 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 31741468 | 31741468 | PRJNA1013345_P_NODE_29297_length_159_cov_2.017857_g29167_i0 | PRJNA1013345 | 29297 | 159 | 2.017857 | 3.20839263 | Engystomops pustulosus | 76066 | Chordata | Chordata | 45.4 | 1.99e-4 | NR | KAG8536220.1 | 76066 | g29167 | i0 | 46.3 | 1.41509433962264 | 41 | 22 | 77.4 | 0 | 1 | 123 | 38 | 78 | KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus] | diamond | 225 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 32342992 | 32342992 | PRJNA1013345_P_NODE_16839_length_178_cov_2.190840_g16709_i0 | PRJNA1013345 | 16839 | 178 | 2.19084 | 3.8996952 | Bucorvus abyssinicus | 153643 | Chordata | Chordata | 42.7 | 0.00296 | NR | NWR65745.1 | 153643 | g16709 | i0 | 60 | 4.17977528089888 | 30 | 12 | 50.6 | 0 | 175 | 86 | 1 | 30 | NWR65745.1 ZNF22 protein [Bucorvus abyssinicus] | diamond | 744 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Bucerotiformes | Bucorvidae | Bucorvus | Bucorvus abyssinicus |
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);;