contig_metadata
7 rows where bioproject = "PRJNA529924" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3054237 | 3054237 | PRJNA529924_P_NODE_2323_length_314_cov_4.547368_g2149_i0 | PRJNA529924 | 2323 | 314 | 4.547368 | 14.27873552 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 159 | 1.68e-34 | NTclustered | gi|1116517974|gb|AY485340.2| | 6183 | g2149 | i0 | 90.756 | 46.8821656050955 | 119 | 11 | 38 | 0 | 196 | 314 | 227 | 109 | Schistosoma mansoni ubiquitin mRNA, partial cds | blastn | 14721 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 4330214 | 4330214 | PRJNA529924_P_NODE_604_length_814_cov_3.510828_g484_i0 | PRJNA529924 | 604 | 814 | 3.510828 | 28.57813992 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 1201 | 0 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g484 | i0 | 98.957 | 21.1830466830467 | 671 | 7 | 82 | 0 | 144 | 814 | 1 | 671 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 17243 | 1201 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 11981972 | 11981972 | PRJNA529924_P_NODE_2230_length_325_cov_4.692568_g2056_i0 | PRJNA529924 | 2230 | 325 | 4.692568 | 15.250846 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 159 | 1.75e-34 | NTclustered | gi|1116517974|gb|AY485340.2| | 6183 | g2056 | i0 | 90.756 | 45.2953846153846 | 119 | 11 | 37 | 0 | 1 | 119 | 109 | 227 | Schistosoma mansoni ubiquitin mRNA, partial cds | blastn | 14721 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 17080574 | 17080574 | PRJNA529924_P_NODE_4714_length_164_cov_1.444444_g4540_i0 | PRJNA529924 | 4714 | 164 | 1.444444 | 2.36888816 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 56.5 | 0.001 | NTclustered | gi|56759117|gb|AY815967.1| | 6182 | g4540 | i0 | 94.444 | 0.219512195121951 | 36 | 2 | 22 | 0 | 129 | 164 | 821 | 786 | Schistosoma japonicum SJCHGC02224 protein mRNA, complete cds | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23455426 | 23455426 | PRJNA529924_P_NODE_4839_length_158_cov_2.093023_g4665_i0 | PRJNA529924 | 4839 | 158 | 2.093023 | 3.30697634 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 121 | 3.5299999999999995e-23 | NTclustered | gi|2318754094|ref|XM_051212442.1| | 6185 | g4665 | i0 | 81.046 | 61.7215189873418 | 153 | 27 | 96 | 2 | 3 | 154 | 353 | 202 | Schistosoma haematobium uncharacterized protein (MS3_00004515), mRNA | blastn | 9752 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 30850918 | 30850918 | PRJNA529924_P_NODE_3894_length_198_cov_2.213018_g3720_i0 | PRJNA529924 | 3894 | 198 | 2.213018 | 4.38177564 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 51.6 | 1.26e-5 | NR | CAI2735247.1 | 6189 | g3720 | i0 | 77.4 | 1.03030303030303 | 31 | 5 | 47 | 1 | 154 | 62 | 1 | 29 | CAI2735247.1 unnamed protein product [Schistosoma spindalis] | diamond | 204 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma spindalis | |
| 32005862 | 32005862 | PRJNA529924_P_NODE_2138_length_336_cov_5.664495_g1964_i0 | PRJNA529924 | 2138 | 336 | 5.664495 | 19.0327032 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 94 | 7.85e-23 | NR | PAA52392.1 | 282301 | g1964 | i0 | 84 | 2.78571428571429 | 50 | 8 | 44.6 | 0 | 47 | 196 | 1 | 50 | PAA52392.1 hypothetical protein BOX15_Mlig007628g1 [Macrostomum lignano] | diamond | 936 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano |
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);;