contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1069776" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26877771 | 26877771 | PRJNA1069776_S_NODE_45941_length_162_cov_4.436975_g45627_i0 | PRJNA1069776 | 45941 | 162 | 4.436975 | 7.1878995 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 70.9 | 7.31e-14 | NR | AAX28478.2 | 6182 | g45627 | i0 | 74.5 | 2.53703703703704 | 47 | 11 | 85.2 | 1 | 24 | 161 | 78 | 124 | AAX28478.2 SJCHGC03032 protein, partial [Schistosoma japonicum] | diamond | 411 | 71.6 | 0.990223463687151 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26909205 | 26909205 | PRJNA1069776_S_NODE_5842_length_358_cov_16.076190_g5528_i0 | PRJNA1069776 | 5842 | 358 | 16.07619 | 57.5527602 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 49.7 | 2.62e-5 | NR | ABA40899.1 | 6182 | g5528 | i0 | 59 | 0.326815642458101 | 39 | 14 | 31 | 1 | 98 | 208 | 4 | 42 | ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] | diamond | 117 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27288578 | 27288578 | PRJNA1069776_S_NODE_9123_length_316_cov_4.043956_g8809_i0 | PRJNA1069776 | 9123 | 316 | 4.043956 | 12.77890096 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 95.9 | 8.6e-23 | NR | AAX28478.2 | 6182 | g8809 | i0 | 60.7 | 0.79746835443038 | 84 | 28 | 75 | 1 | 19 | 255 | 11 | 94 | AAX28478.2 SJCHGC03032 protein, partial [Schistosoma japonicum] | diamond | 252 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27699505 | 27699505 | PRJNA1069776_S_NODE_23864_length_218_cov_2.971429_g23550_i0 | PRJNA1069776 | 23864 | 218 | 2.971429 | 6.47771522 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 134 | 2.14e-39 | NR | AAX31108.1 | 6182 | g23550 | i0 | 95.8 | 0.990825688073395 | 72 | 0 | 99.1 | 1 | 3 | 218 | 8 | 76 | AAX31108.1 SJCHGC09823 protein [Schistosoma japonicum] | diamond | 216 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27699507 | 27699507 | PRJNA1069776_S_NODE_41484_length_170_cov_3.023622_g41170_i0 | PRJNA1069776 | 41484 | 170 | 3.023622 | 5.1401574 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 42 | 0.0263 | NR | AAX28387.3 | 6182 | g41170 | i0 | 73.1 | 2.27647058823529 | 26 | 7 | 45.9 | 0 | 82 | 5 | 93 | 118 | AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] | diamond | 387 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28046441 | 28046441 | PRJNA1069776_S_NODE_42945_length_167_cov_5.322581_g42631_i0 | PRJNA1069776 | 42945 | 167 | 5.322581 | 8.88871027 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 72.4 | 1.38e-14 | NR | AAX24812.2 | 6182 | g42631 | i0 | 79.5 | 0.70059880239521 | 39 | 8 | 70.1 | 0 | 163 | 47 | 19 | 57 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 117 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29435449 | 29435449 | PRJNA1069776_S_NODE_41910_length_169_cov_4.571429_g41596_i0 | PRJNA1069776 | 41910 | 169 | 4.571429 | 7.72571501 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 61.6 | 1.51e-10 | NR | AAX30331.2 | 6182 | g41596 | i0 | 70 | 1.66863905325444 | 40 | 12 | 71 | 0 | 2 | 121 | 15 | 54 | AAX30331.2 SJCHGC03022 protein, partial [Schistosoma japonicum] | diamond | 282 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29498834 | 29498834 | PRJNA1069776_S_NODE_32030_length_191_cov_4.750000_g31716_i0 | PRJNA1069776 | 32030 | 191 | 4.75 | 9.0725 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 62.4 | 5.63e-10 | NR | AAX25032.2 | 6182 | g31716 | i0 | 58.9 | 1.71204188481675 | 56 | 23 | 88 | 0 | 14 | 181 | 120 | 175 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 327 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30225295 | 30225295 | PRJNA1069776_S_NODE_16212_length_257_cov_3.168224_g15898_i0 | PRJNA1069776 | 16212 | 257 | 3.168224 | 8.14233568 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 59.3 | 1.96e-8 | NR | AAX25032.2 | 6182 | g15898 | i0 | 58.3 | 1.03891050583658 | 48 | 20 | 56 | 0 | 155 | 12 | 121 | 168 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 267 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30572628 | 30572628 | PRJNA1069776_S_NODE_30633_length_195_cov_3.289474_g30319_i0 | PRJNA1069776 | 30633 | 195 | 3.289474 | 6.4144743 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 80.9 | 9.35e-18 | NR | AAX24812.2 | 6182 | g30319 | i0 | 78.7 | 2.26153846153846 | 47 | 10 | 72.3 | 0 | 193 | 53 | 12 | 58 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 441 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31932173 | 31932173 | PRJNA1069776_S_NODE_34857_length_184_cov_3.404255_g34543_i0 | PRJNA1069776 | 34857 | 184 | 3.404255 | 6.2638292 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 75.9 | 1.58e-15 | NR | AAX25839.2 | 6182 | g34543 | i0 | 66.7 | 0.880434782608696 | 54 | 17 | 88 | 1 | 163 | 2 | 40 | 92 | AAX25839.2 SJCHGC09516 protein, partial [Schistosoma japonicum] | diamond | 162 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32185507 | 32185507 | PRJNA1069776_S_NODE_19678_length_237_cov_2.943299_g19364_i0 | PRJNA1069776 | 19678 | 237 | 2.943299 | 6.97561863 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 56.2 | 2.32e-7 | NR | AAX25032.2 | 6182 | g19364 | i0 | 85.2 | 0.341772151898734 | 27 | 4 | 34.2 | 0 | 67 | 147 | 91 | 117 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 81 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum |
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);;