contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA896758" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 872799 | 872799 | PRJNA896758_P_NODE_15561_length_290_cov_1.036866_g15171_i0 | PRJNA896758 | 15561 | 290 | 1.036866 | 3.0069114 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 3.26e-46 | NTclustered | gi|2386260881|ref|XM_001457120.2| | 5888 | g15171 | i0 | 83.028 | 21.2931034482759 | 218 | 37 | 75 | 0 | 71 | 288 | 270 | 53 | Paramecium tetraurelia uncharacterized protein (GSPATT00022933001), mRNA | blastn | 6175 | 198 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 4701342 | 4701342 | PRJNA896758_P_NODE_14284_length_304_cov_1.333333_g13894_i0 | PRJNA896758 | 14284 | 304 | 1.333333 | 4.05333232 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 1.24e-45 | NTclustered | gi|471220695|ref|XM_004027253.1| | 5932 | g13894 | i0 | 82.589 | 0.736842105263158 | 224 | 37 | 73 | 2 | 81 | 303 | 538 | 316 | Ichthyophthirius multifiliis ras oncogene family protein, putative (IMG5_185400) mRNA, complete cds | blastn | 224 | 196 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 9800608 | 9800608 | PRJNA896758_P_NODE_1308_length_1010_cov_3.150480_g1014_i0 | PRJNA896758 | 1308 | 1010 | 3.15048 | 31.819848 | Opisthonecta henneguyi | 6026 | SAR_Eukaryotes | SAR_Eukaryotes | 780 | 0 | NTclustered | gi|4063597|gb|AF056109.1| | 6026 | g1014 | i0 | 81.703 | 67.5346534653465 | 951 | 160 | 93 | 14 | 66 | 1009 | 1232 | 289 | Telotrochidium henneguyii translation elongation factor 1-alpha (TEF1) gene, partial cds | blastn | 68210 | 780 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta henneguyi | ||
| 12351737 | 12351737 | PRJNA896758_P_NODE_11550_length_338_cov_1.615094_g11160_i0 | PRJNA896758 | 11550 | 338 | 1.615094 | 5.45901772 | Rimostrombidium veniliae | 702563 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 1.6699999999999995e-99 | NTclustered | gi|759083337|gb|KM221993.1| | 702563 | g11160 | i0 | 86.686 | 99.7988165680473 | 338 | 45 | 100 | 0 | 1 | 338 | 676 | 1013 | Rimostrombidium veniliae voucher LWW2007042901 alpha-tubulin gene, partial cds | blastn | 33732 | 375 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Choreotrichida | Strobilidiidae | Rimostrombidium | Rimostrombidium veniliae | ||
| 13626545 | 13626545 | PRJNA896758_P_NODE_13351_length_315_cov_1.210744_g12961_i0 | PRJNA896758 | 13351 | 315 | 1.210744 | 3.8138435999999998 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.68e-39 | NTclustered | gi|10145|emb|X16019.1| | 5949 | g12961 | i0 | 81.166 | 12.4031746031746 | 223 | 38 | 70 | 4 | 1 | 221 | 524 | 304 | S.lemnae histone H4 gene (clone H4g) | blastn | 3907 | 176 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 13626550 | 13626550 | PRJNA896758_P_NODE_14491_length_301_cov_1.688596_g14101_i0 | PRJNA896758 | 14491 | 301 | 1.688596 | 5.08267396 | uncultured Peritrichia | 282477 | SAR_Eukaryotes | SAR_Eukaryotes | 556 | 4.87e-154 | NTclustered | gi|1354561742|gb|MH023111.1| | 282477 | g14101 | i0 | 100 | 100.441860465116 | 301 | 0 | 100 | 0 | 1 | 301 | 330 | 30 | Uncultured Peritrichia clone OTU698 small subunit ribosomal RNA gene, partial sequence | blastn | 30233 | 556 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | uncultured Peritrichia | |||||
| 14900711 | 14900711 | PRJNA896758_P_NODE_12892_length_320_cov_1.510121_g12502_i0 | PRJNA896758 | 12892 | 320 | 1.510121 | 4.8323872 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 520 | 6.849999999999999e-143 | NTclustered | gi|3550265|gb|AF079840.1|AF079840 | 5963 | g12502 | i0 | 97.403 | 5.15625 | 308 | 3 | 95 | 4 | 1 | 304 | 307 | 1 | Stentor coeruleus G protein alpha GS-like subunit mRNA, partial cds | blastn | 1650 | 520 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 15271866 | 15271866 | PRJNA896758_P_NODE_3512_length_613_cov_3.335185_g3131_i0 | PRJNA896758 | 3512 | 613 | 3.335185 | 20.44468405 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 691 | 0 | NTclustered | gi|9756|emb|Z11763.1| | 5947 | g3131 | i0 | 87.667 | 86.3572593800979 | 600 | 66 | 97 | 7 | 18 | 613 | 1536 | 941 | O.granulifera gene for alpha-tubulin | blastn | 52937 | 691 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha granulifera | ||
| 18724279 | 18724279 | PRJNA896758_P_NODE_19615_length_262_cov_2.433862_g19225_i0 | PRJNA896758 | 19615 | 262 | 2.433862 | 6.37671844 | Uroleptus gallina | 57513 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 2.1299999999999995e-82 | NTclustered | gi|21215215|gb|AF510209.1| | 57513 | g19225 | i0 | 88.636 | 95.5381679389313 | 264 | 26 | 100 | 4 | 1 | 262 | 971 | 710 | Uroleptus gallina beta-tubulin gene, complete cds | blastn | 25031 | 318 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Urostylida | Urostylidae | Uroleptus | Uroleptus gallina | ||
| 19999510 | 19999510 | PRJNA896758_P_NODE_9256_length_375_cov_1.122517_g8866_i0 | PRJNA896758 | 9256 | 375 | 1.122517 | 4.20943875 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 9.12e-63 | NTclustered | gi|74834194|emb|CR933372.1| | 5888 | g8866 | i0 | 80.226 | 33.5226666666667 | 354 | 56 | 93 | 11 | 10 | 356 | 1038 | 692 | Cytosol-type hsp70, Paramecium tetraurelia macronuclear gene | blastn | 12571 | 254 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 20370262 | 20370262 | PRJNA896758_P_NODE_17436_length_277_cov_1.887255_g17046_i0 | PRJNA896758 | 17436 | 277 | 1.887255 | 5.22769635 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 8.539999999999999e-52 | NTclustered | gi|310869|gb|L18892.1| | 5911 | g17046 | i0 | 84.545 | 66.8483754512635 | 220 | 32 | 79 | 2 | 16 | 234 | 283 | 501 | Tetrahymena thermophila histone H2A.X (H2A.X) gene, complete cds; macronuclear | blastn | 18517 | 217 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila |
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);;