contig_metadata
5 rows where bioproject = "PRJNA937226", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2531449 | 2531449 | PRJNA937226_S_NODE_25602_length_168_cov_1.310924_g25475_i0 | PRJNA937226 | 25602 | 168 | 1.310924 | 2.20235232 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 311 | 2.11e-80 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g25475 | i0 | 100 | 100 | 168 | 0 | 100 | 0 | 1 | 168 | 250 | 83 | Schistosoma japonicum unknown mRNA | blastn | 16800 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 6015208 | 6015208 | PRJNA937226_S_NODE_5745_length_293_cov_3.696721_g5618_i0 | PRJNA937226 | 5745 | 293 | 3.696721 | 10.83139253 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 525 | 1.3299999999999994e-144 | NTclustered | gi|1124902734|gb|AY812498.2| | 6182 | g5618 | i0 | 98.976 | 69.061433447099 | 293 | 3 | 100 | 0 | 1 | 293 | 324 | 32 | Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds | blastn | 20235 | 525 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26708114 | 26708114 | PRJNA937226_S_NODE_25581_length_168_cov_1.563025_g25454_i0 | PRJNA937226 | 25581 | 168 | 1.563025 | 2.625882 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 62.8 | 1.36e-10 | NR | AAX30334.2 | 6182 | g25454 | i0 | 76.2 | 2.48214285714286 | 42 | 10 | 75 | 0 | 167 | 42 | 44 | 85 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 417 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28224939 | 28224939 | PRJNA937226_S_NODE_29986_length_156_cov_14.869159_g29859_i0 | PRJNA937226 | 29986 | 156 | 14.869159 | 23.19588804 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 70.1 | 1.2e-13 | NR | AAW27122.1 | 6182 | g29859 | i0 | 93.8 | 0.615384615384615 | 32 | 2 | 61.5 | 0 | 3 | 98 | 18 | 49 | AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] | diamond | 96 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29487944 | 29487944 | PRJNA937226_S_NODE_15650_length_205_cov_1.858974_g15523_i0 | PRJNA937226 | 15650 | 205 | 1.858974 | 3.8108967 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 41.2 | 0.0238 | NR | AAW24818.1 | 6182 | g15523 | i0 | 84 | 0.365853658536585 | 25 | 4 | 36.6 | 0 | 1 | 75 | 65 | 89 | AAW24818.1 SJCHGC04554 protein, partial [Schistosoma japonicum] | diamond | 75 | 41.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);;