contig_metadata
6 rows where bioproject = "PRJNA512103" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7488938 | 7488938 | PRJNA512103_P_NODE_28026_length_177_cov_1.148438_g27614_i0 | PRJNA512103 | 28026 | 177 | 1.148438 | 2.03273526 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 289 | 1.05e-73 | NTclustered | gi|209968707|gb|FJ384870.1| | 52061 | g27614 | i0 | 99.371 | 24.1920903954802 | 159 | 1 | 90 | 0 | 10 | 168 | 529 | 687 | Stenostomum leucops isolate K05_55 28S ribosomal RNA gene, partial sequence | blastn | 4282 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 11965068 | 11965068 | PRJNA512103_P_NODE_35010_length_153_cov_2.759615_g34598_i0 | PRJNA512103 | 35010 | 153 | 2.759615 | 4.22221095 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 257 | 2.47e-64 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g34598 | i0 | 98.621 | 13.4575163398693 | 145 | 2 | 95 | 0 | 1 | 145 | 8606 | 8462 | Stenostomum sthenum mitochondrion, complete genome | blastn | 2059 | 257 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 17062773 | 17062773 | PRJNA512103_P_NODE_12174_length_319_cov_1.514815_g11762_i0 | PRJNA512103 | 12174 | 319 | 1.514815 | 4.83225985 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 540 | 5.24e-149 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g11762 | i0 | 99.003 | 87.5360501567398 | 301 | 3 | 94 | 0 | 10 | 310 | 2177 | 1877 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 27924 | 540 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 19612097 | 19612097 | PRJNA512103_P_NODE_27136_length_180_cov_1.206107_g26724_i0 | PRJNA512103 | 27136 | 180 | 1.206107 | 2.1709926 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 292 | 8.26e-75 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g26724 | i0 | 97.661 | 1.86666666666667 | 171 | 3 | 95 | 1 | 10 | 180 | 8844 | 8675 | Stenostomum sthenum mitochondrion, complete genome | blastn | 336 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 29208530 | 29208530 | PRJNA512103_P_NODE_6169_length_562_cov_1.514620_g5770_i0 | PRJNA512103 | 6169 | 562 | 1.51462 | 8.5121644 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 246 | 3.67e-76 | NR | KAL3318419.1 | 1844966 | g5770 | i0 | 72.7 | 7.01423487544484 | 176 | 48 | 94 | 0 | 27 | 554 | 11 | 186 | KAL3318419.1 ATP synthase subunit beta, mitochondrial [Cichlidogyrus casuarinus] | diamond | 3942 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 30187256 | 30187256 | PRJNA512103_P_NODE_20012_length_214_cov_2.163636_g19600_i0 | PRJNA512103 | 20012 | 214 | 2.163636 | 4.63018104 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 59.3 | 2.8e-9 | NR | VDP41943.1 | 6186 | g19600 | i0 | 50 | 3.35046728971963 | 58 | 28 | 81.3 | 1 | 29 | 202 | 34 | 90 | VDP41943.1 unnamed protein product [Schistosoma curassoni] | diamond | 717 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma curassoni |
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);;