contig_metadata
11 rows where bioproject = "PRJNA640143" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17187785 | 17187785 | PRJNA640143_S_NODE_2014_length_537_cov_13.906000_g1866_i0 | PRJNA640143 | 2014 | 537 | 13.906 | 74.67522 | Epistylis sp. 8 | 2979171 | SAR_Eukaryotes | SAR_Eukaryotes | 869 | 0 | NTclustered | gi|2304601484|gb|OP458305.1| | 2979171 | g1866 | i0 | 98.2 | 76.7281191806331 | 500 | 4 | 92 | 1 | 34 | 528 | 54 | 553 | Epistylis sp. 8 large subunit ribosomal RNA gene, partial sequence | blastn | 41203 | 869 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis sp. 8 | ||
| 23562359 | 23562359 | PRJNA640143_S_NODE_16059_length_217_cov_286.694444_g15849_i0 | PRJNA640143 | 16059 | 217 | 286.694444 | 622.12694348 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.37e-58 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g15849 | i0 | 93.293 | 3.21658986175115 | 164 | 8 | 75 | 2 | 17 | 178 | 3769 | 3607 | Colpoda sp. isolate CIL1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 698 | 239 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 30049232 | 30049232 | PRJNA640143_S_NODE_28491_length_163_cov_2.166667_g28281_i0 | PRJNA640143 | 28491 | 163 | 2.166667 | 3.53166721 | Paramecium pentaurelia | 43138 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.023 | NR | CAD8157753.1 | 43138 | g28281 | i0 | 59.5 | 0.680981595092024 | 37 | 14 | 66.3 | 1 | 158 | 51 | 402 | 438 | CAD8157753.1 unnamed protein product [Paramecium pentaurelia] | diamond | 111 | 42 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 30251647 | 30251647 | PRJNA640143_S_NODE_22572_length_185_cov_3.175676_g22362_i0 | PRJNA640143 | 22572 | 185 | 3.175676 | 5.8750006 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.00933 | NR | XP_001029693.3 | 312017 | g22362 | i0 | 58.1 | 1.00540540540541 | 31 | 13 | 50.3 | 0 | 108 | 16 | 115 | 145 | XP_001029693.3 hypothetical protein TTHERM_01345750 [Tetrahymena thermophila SB210] | diamond | 186 | 43.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30965867 | 30965867 | PRJNA640143_S_NODE_21554_length_189_cov_12.348684_g21344_i0 | PRJNA640143 | 21554 | 189 | 12.348684 | 23.33901276 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 3.4e-5 | NR | XP_001014693.1 | 312017 | g21344 | i0 | 52.4 | 0.666666666666667 | 42 | 20 | 66.7 | 0 | 151 | 26 | 272 | 313 | XP_001014693.1 membrane bound O-acyltransferase, MBOAT protein [Tetrahymena thermophila SB210] | diamond | 126 | 50.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31060751 | 31060751 | PRJNA640143_S_NODE_12655_length_244_cov_1.884058_g12445_i0 | PRJNA640143 | 12655 | 244 | 1.884058 | 4.59710152 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 3.32e-7 | NR | XP_001010339.2 | 312017 | g12445 | i0 | 44.6 | 0.688524590163934 | 56 | 31 | 68.9 | 0 | 170 | 3 | 4 | 59 | XP_001010339.2 actin [Tetrahymena thermophila SB210] | diamond | 168 | 57 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31566648 | 31566648 | PRJNA640143_S_NODE_5376_length_356_cov_4.056426_g5166_i0 | PRJNA640143 | 5376 | 356 | 4.056426 | 14.44087656 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 6.59e-14 | NR | XP_004035636.1 | 5932 | g5166 | i0 | 56.3 | 1.07865168539326 | 64 | 28 | 53.9 | 0 | 327 | 136 | 361 | 424 | XP_004035636.1 major facilitator superfamily protein, putative [Ichthyophthirius multifiliis] | diamond | 384 | 77.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 31598228 | 31598228 | PRJNA640143_S_NODE_14536_length_228_cov_8.523560_g14326_i0 | PRJNA640143 | 14536 | 228 | 8.52356 | 19.4337168 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 2.44e-11 | NR | XP_004030454.1 | 5932 | g14326 | i0 | 62 | 0.657894736842105 | 50 | 19 | 65.8 | 0 | 69 | 218 | 701 | 750 | XP_004030454.1 hypothetical protein IMG5_160550 [Ichthyophthirius multifiliis] | diamond | 150 | 68.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 31989995 | 31989995 | PRJNA640143_S_NODE_6218_length_334_cov_2.771044_g6008_i0 | PRJNA640143 | 6218 | 334 | 2.771044 | 9.25528696 | Sporadotrichida | 693921 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 0.00135 | NR | CDW86352.1 | 5949 | g6008 | i0 | 27.6 | 2.20958083832335 | 123 | 66 | 95.2 | 3 | 13 | 330 | 111 | 227 | CDW86352.1 wd40 repeat-containing protein [Stylonychia lemnae] | diamond | 738 | 48.5 | 0.991752577319588 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32578933 | 32578933 | PRJNA640143_S_NODE_8059_length_299_cov_2.423664_g7849_i0 | PRJNA640143 | 8059 | 299 | 2.423664 | 7.24675536 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 1.7e-13 | NR | XP_001016366.2 | 312017 | g7849 | i0 | 54.1 | 1.48494983277592 | 74 | 34 | 74.2 | 0 | 32 | 253 | 157 | 230 | XP_001016366.2 kinesin motor catalytic domain protein [Tetrahymena thermophila SB210] | diamond | 444 | 75.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32673041 | 32673041 | PRJNA640143_S_NODE_10220_length_270_cov_1.360515_g10010_i0 | PRJNA640143 | 10220 | 270 | 1.360515 | 3.6733905 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 2.57e-22 | NR | XP_001023309.1 | 312017 | g10010 | i0 | 74.6 | 0.7 | 63 | 16 | 70 | 0 | 230 | 42 | 333 | 395 | XP_001023309.1 S-adenosylmethionine synthetase protein [Tetrahymena thermophila SB210] | diamond | 189 | 99.4 | 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);;