contig_metadata
8 rows where bioproject = "PRJNA1025141" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1437620 | 1437620 | PRJNA1025141_P_NODE_8042_length_277_cov_1.122549_g7981_i0 | PRJNA1025141 | 8042 | 277 | 1.122549 | 3.10946073 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 346 | 1.04e-90 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g7981 | i0 | 89.17 | 18.5956678700361 | 277 | 30 | 100 | 0 | 1 | 277 | 554 | 278 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 5151 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 11641381 | 11641381 | PRJNA1025141_P_NODE_2990_length_473_cov_1.477500_g2929_i0 | PRJNA1025141 | 2990 | 473 | 1.4775 | 6.988575 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 154 | 2.52e-43 | NR | CAH8437807.1 | 39320 | g2929 | i0 | 81.5 | 4.76321353065539 | 92 | 17 | 58.4 | 0 | 3 | 278 | 172 | 263 | CAH8437807.1 unnamed protein product [Heterobilharzia americana] | diamond | 2253 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 12916574 | 12916574 | PRJNA1025141_P_NODE_751_length_930_cov_2.996499_g707_i0 | PRJNA1025141 | 751 | 930 | 2.996499 | 27.8674407 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 393 | 7.659999999999998e-135 | NR | CAX83046.1 | 6182 | g707 | i0 | 76.2 | 39.9354838709677 | 248 | 59 | 80 | 0 | 7 | 750 | 1 | 248 | CAX83046.1 60S ribosomal protein L8, partial [Schistosoma japonicum] | diamond | 37140 | 395 | 0.994936708860759 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18014728 | 18014728 | PRJNA1025141_P_NODE_855_length_877_cov_1.451493_g808_i0 | PRJNA1025141 | 855 | 877 | 1.451493 | 12.72959361 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 179 | 6.45e-51 | NR | CAH8559497.1 | 57078 | g808 | i0 | 43.1 | 3.72177879133409 | 276 | 141 | 91.3 | 7 | 73 | 873 | 14 | 282 | CAH8559497.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 3264 | 180 | 0.994444444444444 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 27446109 | 27446109 | PRJNA1025141_P_NODE_10263_length_249_cov_0.875000_g10202_i0 | PRJNA1025141 | 10263 | 249 | 0.875 | 2.17875 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 66.6 | 1.53e-10 | NR | PAA93605.1 | 282301 | g10202 | i0 | 43.5 | 0.831325301204819 | 69 | 39 | 83.1 | 0 | 249 | 43 | 376 | 444 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 207 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28645783 | 28645783 | PRJNA1025141_P_NODE_10167_length_249_cov_0.875000_g10106_i0 | PRJNA1025141 | 10167 | 249 | 0.875 | 2.17875 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 63.2 | 1.45e-9 | NR | PAA84922.1 | 282301 | g10106 | i0 | 50 | 0.602409638554217 | 50 | 23 | 57.8 | 1 | 144 | 1 | 121 | 170 | PAA84922.1 hypothetical protein BOX15_Mlig016820g2 [Macrostomum lignano] | diamond | 150 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28898107 | 28898107 | PRJNA1025141_P_NODE_6588_length_311_cov_1.605042_g6527_i0 | PRJNA1025141 | 6588 | 311 | 1.605042 | 4.99168062 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 138 | 3.38e-37 | NR | PAA58179.1 | 282301 | g6527 | i0 | 62.4 | 1.94855305466238 | 101 | 36 | 95.5 | 1 | 309 | 13 | 196 | 296 | PAA58179.1 hypothetical protein BOX15_Mlig030029g2 [Macrostomum lignano] | diamond | 606 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30880177 | 30880177 | PRJNA1025141_P_NODE_9134_length_255_cov_1.087912_g9073_i0 | PRJNA1025141 | 9134 | 255 | 1.087912 | 2.7741756 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 100 | 6.61e-23 | NR | TNN11026.1 | 6182 | g9073 | i0 | 65.8 | 15.6117647058824 | 73 | 25 | 85.9 | 0 | 245 | 27 | 107 | 179 | TNN11026.1 Lysosomal protective protein isoform 1 [Schistosoma japonicum] | diamond | 3981 | 101 | 0.99009900990099 | 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);;