contig_metadata
9 rows where bioproject = "PRJNA1123309", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 278103 | 278103 | PRJNA1123309_P_NODE_15181_length_396_cov_2.114551_g14802_i0 | PRJNA1123309 | 15181 | 396 | 2.114551 | 8.37362196 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 693 | 0 | NTclustered | gi|753176482|gb|KM821047.2| | 79327 | g14802 | i0 | 100 | 19.4141414141414 | 375 | 0 | 95 | 0 | 1 | 375 | 13322 | 12948 | Schmidtea mediterranea mitochondrion, complete genome | blastn | 7688 | 693 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 7931484 | 7931484 | PRJNA1123309_P_NODE_55447_length_248_cov_0.891429_g55067_i0 | PRJNA1123309 | 55447 | 248 | 0.891429 | 2.21074392 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 340 | 4.27e-89 | NTclustered | gi|21307911|gb|AY067278.1| | 79327 | g55067 | i0 | 93.636 | 0.887096774193548 | 220 | 12 | 88 | 2 | 2 | 219 | 420 | 639 | Schmidtea mediterranea clone hsp70 unknown mRNA sequence | blastn | 220 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 9206560 | 9206560 | PRJNA1123309_P_NODE_62728_length_244_cov_0.912281_g62348_i0 | PRJNA1123309 | 62728 | 244 | 0.912281 | 2.22596564 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 124 | 2.02e-33 | NR | VEL10592.1 | 117903 | g62348 | i0 | 70.1 | 5.66803278688525 | 77 | 23 | 94.7 | 0 | 231 | 1 | 95 | 171 | VEL10592.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 1383 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 18130250 | 18130250 | PRJNA1123309_P_NODE_52375_length_250_cov_0.881356_g51995_i0 | PRJNA1123309 | 52375 | 250 | 0.881356 | 2.20339 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 267 | 7.43e-67 | NTclustered | gi|1122821607|gb|AY067141.2| | 79327 | g51995 | i0 | 100 | 0.576 | 144 | 0 | 58 | 0 | 17 | 160 | 425 | 282 | Schmidtea mediterranea clone HB.19.4g unknown mRNA sequence | blastn | 144 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 24504407 | 24504407 | PRJNA1123309_P_NODE_49700_length_252_cov_0.871508_g49320_i0 | PRJNA1123309 | 49700 | 252 | 0.871508 | 2.19620016 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 342 | 1.21e-89 | NTclustered | gi|21308966|gb|AY068333.1| | 79327 | g49320 | i0 | 97.938 | 0.76984126984127 | 194 | 4 | 77 | 0 | 59 | 252 | 45 | 238 | Schmidtea mediterranea clone H.31.6e(T3) unknown mRNA sequence | blastn | 194 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 26932832 | 26932832 | PRJNA1123309_P_NODE_47982_length_253_cov_0.866667_g47602_i0 | PRJNA1123309 | 47982 | 253 | 0.866667 | 2.19266751 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 82.4 | 1.68e-17 | NR | PAA92643.1 | 282301 | g47602 | i0 | 58.7 | 2.31225296442688 | 63 | 26 | 74.7 | 0 | 197 | 9 | 2 | 64 | PAA92643.1 hypothetical protein BOX15_Mlig022705g1 [Macrostomum lignano] | diamond | 585 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27628260 | 27628260 | PRJNA1123309_P_NODE_8884_length_504_cov_1.064965_g8511_i0 | PRJNA1123309 | 8884 | 504 | 1.064965 | 5.3674236 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.8 | 1.04e-5 | NR | VZI22467.1 | 99802 | g8511 | i0 | 27.3 | 5.94047619047619 | 128 | 85 | 76.2 | 3 | 120 | 503 | 139 | 258 | VZI22467.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 2994 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 31702878 | 31702878 | PRJNA1123309_P_NODE_41277_length_267_cov_1.829897_g40897_i0 | PRJNA1123309 | 41277 | 267 | 1.829897 | 4.88582499 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 94.4 | 3.58e-20 | NR | VDL17052.1 | 6216 | g40897 | i0 | 55.6 | 3.61797752808989 | 81 | 36 | 91 | 0 | 11 | 253 | 1538 | 1618 | VDL17052.1 unnamed protein product [Hymenolepis diminuta] | diamond | 966 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 31808591 | 31808591 | PRJNA1123309_P_NODE_30057_length_297_cov_0.995536_g29677_i0 | PRJNA1123309 | 30057 | 297 | 0.995536 | 2.95674192 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 77.8 | 4.51e-15 | NR | CAL5130763.1 | 300641 | g29677 | i0 | 35.9 | 0.929292929292929 | 92 | 59 | 92.9 | 0 | 1 | 276 | 122 | 213 | CAL5130763.1 unnamed protein product [Calicophoron daubneyi] | diamond | 276 | 77.8 | 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);;