contig_metadata
11 rows where bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6513053 | 6513053 | PRJEB673_P_NODE_7246_length_321_cov_1.318182_g6897_i0 | PRJEB673 | 7246 | 321 | 1.318182 | 4.23136422 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 196 | 1.31e-45 | NTclustered | gi|359318420|gb|JN968463.2| | 6161 | g6897 | i0 | 78.71 | 71.0218068535826 | 310 | 55 | 95 | 9 | 10 | 315 | 950 | 648 | Dugesia japonica glucose-regulated protein 78 (grp78) mRNA, complete cds | blastn | 22798 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 7372844 | 7372844 | PRJEB673_P_NODE_6906_length_330_cov_1.220339_g6557_i0 | PRJEB673 | 6906 | 330 | 1.220339 | 4.0271187 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 274 | 6.09e-69 | NTclustered | gi|209968707|gb|FJ384870.1| | 52061 | g6557 | i0 | 100 | 45.6575757575758 | 148 | 0 | 45 | 0 | 183 | 330 | 1373 | 1226 | Stenostomum leucops isolate K05_55 28S ribosomal RNA gene, partial sequence | blastn | 15067 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 10337901 | 10337901 | PRJEB673_P_NODE_10309_length_176_cov_2.780142_g9960_i0 | PRJEB673 | 10309 | 176 | 2.780142 | 4.89304992 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 326 | 7.92e-85 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g9960 | i0 | 100 | 81.0397727272727 | 176 | 0 | 100 | 0 | 1 | 176 | 2341 | 2516 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 14263 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 14163262 | 14163262 | PRJEB673_P_NODE_11492_length_161_cov_0.952381_g11143_i0 | PRJEB673 | 11492 | 161 | 0.952381 | 1.53333341 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|687156761|emb|LN010431.1| | 99802 | g11143 | i0 | 100 | 0.180124223602484 | 29 | 0 | 18 | 0 | 77 | 105 | 11687 | 11715 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0010307 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 15023191 | 15023191 | PRJEB673_P_NODE_12412_length_154_cov_1.008403_g12063_i0 | PRJEB673 | 12412 | 154 | 1.008403 | 1.55294062 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 285 | 1.14e-72 | NTclustered | gi|2866376384|gb|PQ722296.1| | 39377 | g12063 | i0 | 100 | 99.7467532467532 | 154 | 0 | 100 | 0 | 1 | 154 | 1373 | 1526 | Stenostomum sp. (in: flatworms) isolate F8 small subunit ribosomal RNA gene, partial sequence | blastn | 15361 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sp. (in: flatworms) | |||
| 18846976 | 18846976 | PRJEB673_P_NODE_8295_length_288_cov_1.264822_g7946_i0 | PRJEB673 | 8295 | 288 | 1.264822 | 3.64268736 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 514 | 2.83e-141 | NTclustered | gi|209968685|gb|FJ384848.1| | 52061 | g7946 | i0 | 98.955 | 70.8784722222222 | 287 | 3 | 99 | 0 | 2 | 288 | 1017 | 731 | Stenostomum leucops isolate K04_75 28S ribosomal RNA gene, partial sequence | blastn | 20413 | 514 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 25221446 | 25221446 | PRJEB673_P_NODE_6580_length_339_cov_1.315789_g6231_i0 | PRJEB673 | 6580 | 339 | 1.315789 | 4.46052471 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.2 | 1.91e-4 | NTclustered | gi|2224869|gb|U53001.1|DLU53001 | 27895 | g6231 | i0 | 100 | 9.59882005899705 | 32 | 0 | 9 | 0 | 234 | 265 | 80 | 111 | Dendrocoelum lacteum ribosomal RNA large subunit gene, partial sequence | blastn | 3254 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dendrocoelidae | Dendrocoelum | Dendrocoelum lacteum | |
| 27034088 | 27034088 | PRJEB673_P_NODE_12582_length_153_cov_1.016949_g12233_i0 | PRJEB673 | 12582 | 153 | 1.016949 | 1.55593197 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 84.7 | 1.31e-17 | NR | CAH8521076.1 | 57078 | g12233 | i0 | 76 | 3.92156862745098 | 50 | 12 | 98 | 0 | 2 | 151 | 265 | 314 | CAH8521076.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 600 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 28953559 | 28953559 | PRJEB673_P_NODE_11828_length_158_cov_1.300813_g11479_i0 | PRJEB673 | 11828 | 158 | 1.300813 | 2.05528454 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 77.8 | 1.14e-15 | NR | PAA67196.1 | 282301 | g11479 | i0 | 82.7 | 12.7784810126582 | 52 | 9 | 98.7 | 0 | 2 | 157 | 97 | 148 | PAA67196.1 hypothetical protein BOX15_Mlig008787g1, partial [Macrostomum lignano] | diamond | 2019 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29812889 | 29812889 | PRJEB673_P_NODE_4131_length_480_cov_1.943820_g3794_i0 | PRJEB673 | 4131 | 480 | 1.94382 | 9.330336 | Protopolystoma xenopodis | 117903 | Platyhelminthes | Platyhelminthes | 147 | 8.56e-42 | NR | VEL28320.1 | 117903 | g3794 | i0 | 61.5 | 17.96875 | 117 | 45 | 73.1 | 0 | 3 | 353 | 43 | 159 | VEL28320.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 8625 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 31266443 | 31266443 | PRJEB673_P_NODE_8835_length_233_cov_1.207071_g8486_i0 | PRJEB673 | 8835 | 233 | 1.207071 | 2.81247543 | Schistosoma margrebowiei | 48269 | Platyhelminthes | Platyhelminthes | 65.5 | 3.16e-10 | NR | VDP35163.1 | 48269 | g8486 | i0 | 55.6 | 10.1201716738197 | 72 | 32 | 92.7 | 0 | 228 | 13 | 150 | 221 | VDP35163.1 unnamed protein product [Schistosoma margrebowiei] | diamond | 2358 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma margrebowiei |
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);;