contig_metadata
5 rows where bioproject = "PRJNA683902", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6279466 | 6279466 | PRJNA683902_S_NODE_26745_length_193_cov_1.974359_g26301_i0 | PRJNA683902 | 26745 | 193 | 1.974359 | 3.81051287 | Polycladida | 6163 | Platyhelminthes | Platyhelminthes | 86.1 | 1.64e-12 | NTclustered | gi|1436165593|gb|MH700375.1| | 2291402 | g26301 | i0 | 80.909 | 35.0880829015544 | 110 | 19 | 56 | 2 | 61 | 168 | 216 | 107 | Prosthiostomum sp. ISR011 large subunit ribosomal RNA gene, partial sequence | blastn | 6772 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Prosthiostomidae | Prosthiostomum | Prosthiostomum sp. ISR011 | |
| 13929505 | 13929505 | PRJNA683902_S_NODE_29911_length_179_cov_1.098592_g29467_i0 | PRJNA683902 | 29911 | 179 | 1.098592 | 1.96647968 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 331 | 1.74e-86 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g29467 | i0 | 100 | 100 | 179 | 0 | 100 | 0 | 1 | 179 | 510 | 332 | Schistosoma japonicum unknown mRNA | blastn | 17900 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 16478696 | 16478696 | PRJNA683902_S_NODE_8273_length_570_cov_2.080675_g7862_i0 | PRJNA683902 | 8273 | 570 | 2.080675 | 11.8598475 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 1048 | 0 | NTclustered | gi|60689738|gb|AY915254.1| | 6182 | g7862 | i0 | 99.825 | 100 | 570 | 1 | 100 | 0 | 1 | 570 | 8 | 577 | Schistosoma japonicum clone SJCHGC03884 unknown mRNA | blastn | 57000 | 1048 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 21577889 | 21577889 | PRJNA683902_S_NODE_37277_length_156_cov_2.151261_g36833_i0 | PRJNA683902 | 37277 | 156 | 2.151261 | 3.35596716 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 289 | 9e-74 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g36833 | i0 | 100 | 100 | 156 | 0 | 100 | 0 | 1 | 156 | 183 | 338 | Schistosoma japonicum unknown mRNA | blastn | 15600 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31440979 | 31440979 | PRJNA683902_S_NODE_23996_length_209_cov_1.360465_g23552_i0 | PRJNA683902 | 23996 | 209 | 1.360465 | 2.84337185 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 50.1 | 2.07e-5 | NR | CAL5132835.1 | 300641 | g23552 | i0 | 38.9 | 0.77511961722488 | 54 | 33 | 77.5 | 0 | 206 | 45 | 26 | 79 | CAL5132835.1 unnamed protein product [Calicophoron daubneyi] | diamond | 162 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi |
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);;