contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA509429" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27550930 | 27550930 | PRJNA509429_P_NODE_51464_length_151_cov_0.982759_g50636_i0 | PRJNA509429 | 51464 | 151 | 0.982759 | 1.48396609 | Staurois parvus | 386267 | Chordata | Chordata | 69.7 | 2.34e-14 | NR | CAI9622145.1 | 386267 | g50636 | i0 | 80 | 0.695364238410596 | 35 | 7 | 69.5 | 0 | 1 | 105 | 10 | 44 | CAI9622145.1 unnamed protein product [Staurois parvus] | diamond | 105 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27772342 | 27772342 | PRJNA509429_P_NODE_34864_length_200_cov_3.690909_g34036_i0 | PRJNA509429 | 34864 | 200 | 3.690909 | 7.381818 | Engystomops pustulosus | 76066 | Chordata | Chordata | 50.1 | 5.57e-5 | NR | KAG8571490.1 | 76066 | g34036 | i0 | 62.9 | 2.595 | 35 | 13 | 52.5 | 0 | 2 | 106 | 1145 | 1179 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 519 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 28024791 | 28024791 | PRJNA509429_P_NODE_41745_length_175_cov_3.107143_g40917_i0 | PRJNA509429 | 41745 | 175 | 3.107143 | 5.43750025 | Bufotes viridis | 30338 | Chordata | Chordata | 43.9 | 0.00587 | NR | CAK8629749.1 | 30338 | g40917 | i0 | 56.7 | 0.514285714285714 | 30 | 13 | 51.4 | 0 | 37 | 126 | 335 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 90 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28213907 | 28213907 | PRJNA509429_P_NODE_29126_length_230_cov_1.384615_g28298_i0 | PRJNA509429 | 29126 | 230 | 1.384615 | 3.1846145 | Engystomops pustulosus | 76066 | Chordata | Chordata | 63.9 | 1.08e-9 | NR | KAG8571490.1 | 76066 | g28298 | i0 | 60 | 8.29565217391304 | 65 | 17 | 73 | 1 | 63 | 230 | 1030 | 1094 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 1908 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 29540130 | 29540130 | PRJNA509429_P_NODE_19350_length_308_cov_5.315018_g18522_i0 | PRJNA509429 | 19350 | 308 | 5.315018 | 16.37025544 | Engystomops pustulosus | 76066 | Chordata | Chordata | 47.4 | 1.96e-4 | NR | KAG8536220.1 | 76066 | g18522 | i0 | 67.9 | 0.818181818181818 | 28 | 9 | 27.3 | 0 | 223 | 306 | 43 | 70 | KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus] | diamond | 252 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 29982360 | 29982360 | PRJNA509429_P_NODE_34791_length_201_cov_1.096386_g33963_i0 | PRJNA509429 | 34791 | 201 | 1.096386 | 2.20373586 | Engystomops pustulosus | 76066 | Chordata | Chordata | 40.8 | 0.0351 | NR | KAG8571038.1 | 76066 | g33963 | i0 | 69.2 | 1.16417910447761 | 26 | 8 | 38.8 | 0 | 79 | 2 | 14 | 39 | KAG8571038.1 hypothetical protein GDO81_011511 [Engystomops pustulosus] | diamond | 234 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 30772416 | 30772416 | PRJNA509429_P_NODE_12334_length_408_cov_2.268097_g11514_i0 | PRJNA509429 | 12334 | 408 | 2.268097 | 9.25383576 | Staurois parvus | 386267 | Chordata | Chordata | 53.5 | 4.3e-6 | NR | CAI9557087.1 | 386267 | g11514 | i0 | 63.9 | 0.529411764705882 | 36 | 11 | 25 | 1 | 258 | 359 | 24 | 59 | CAI9557087.1 unnamed protein product, partial [Staurois parvus] | diamond | 216 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30993497 | 30993497 | PRJNA509429_P_NODE_47454_length_160_cov_0.952000_g46626_i0 | PRJNA509429 | 47454 | 160 | 0.952 | 1.5232 | Engystomops pustulosus | 76066 | Chordata | Chordata | 52.4 | 4.78e-7 | NR | KAG8576659.1 | 76066 | g46626 | i0 | 65 | 0.75 | 40 | 14 | 75 | 0 | 32 | 151 | 50 | 89 | KAG8576659.1 hypothetical protein GDO81_009926 [Engystomops pustulosus] | diamond | 120 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 31372936 | 31372936 | PRJNA509429_P_NODE_36876_length_192_cov_2.713376_g36048_i0 | PRJNA509429 | 36876 | 192 | 2.713376 | 5.20968192 | Bufotes viridis | 30338 | Chordata | Chordata | 44.3 | 0.00548 | NR | CAK8629749.1 | 30338 | g36048 | i0 | 52.8 | 0.5625 | 36 | 17 | 56.3 | 0 | 7 | 114 | 329 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 108 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31657222 | 31657222 | PRJNA509429_P_NODE_36177_length_195_cov_1.500000_g35349_i0 | PRJNA509429 | 36177 | 195 | 1.5 | 2.925 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 50.4 | 3.86e-5 | NR | CAH1271114.1 | 7740 | g35349 | i0 | 59.1 | 1.35384615384615 | 44 | 18 | 67.7 | 0 | 171 | 40 | 509 | 552 | CAH1271114.1 Hypp4563 [Branchiostoma lanceolatum] | diamond | 264 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 32637605 | 32637605 | PRJNA509429_P_NODE_38040_length_188_cov_1.254902_g37212_i0 | PRJNA509429 | 38040 | 188 | 1.254902 | 2.35921576 | Polypterus senegalus | 55291 | Chordata | Chordata | 50.1 | 4.52e-5 | NR | KAG2460242.1 | 55291 | g37212 | i0 | 57.4 | 7.42021276595745 | 47 | 20 | 75 | 0 | 171 | 31 | 180 | 226 | KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 1395 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 32858217 | 32858217 | PRJNA509429_P_NODE_22480_length_278_cov_1.197531_g21652_i0 | PRJNA509429 | 22480 | 278 | 1.197531 | 3.32913618 | Microcaecilia unicolor | 1415580 | Chordata | Chordata | 88.6 | 4.41e-18 | NR | XP_030043888.1 | 1415580 | g21652 | i0 | 45.7 | 3.97122302158273 | 92 | 50 | 99.3 | 0 | 3 | 278 | 8 | 99 | XP_030043888.1 vomeronasal type-2 receptor 26-like [Microcaecilia unicolor] | diamond | 1104 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Siphonopidae | Microcaecilia | Microcaecilia unicolor |
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);;