contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19555507 | 19555507 | PRJNA432257_S_NODE_40576_length_250_cov_1.028169_g40195_i0 | PRJNA432257 | 40576 | 250 | 1.0281690000000001 | 2.5704225 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.7799999999999994e-24 | NR | CAD8095604.1 | 5886 | g40195 | i0 | 75.8 | 1.464 | 62 | 15 | 74.4 | 0 | 246 | 61 | 246 | 307 | CAD8095604.1 unnamed protein product [Paramecium primaurelia] | diamond | 366 | 103 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 27265532 | 27265532 | PRJNA432257_S_NODE_35783_length_262_cov_2.342222_g35402_i0 | PRJNA432257 | 35783 | 262 | 2.342222 | 6.13662164 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 5.58e-10 | NR | KRW99430.1 | 266149 | g35402 | i0 | 44.6 | 0.744274809160305 | 65 | 36 | 74.4 | 0 | 257 | 63 | 309 | 373 | KRW99430.1 Protein kinase-like domain [Pseudocohnilembus persalinus] | diamond | 195 | 65.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 28244212 | 28244212 | PRJNA432257_S_NODE_61746_length_213_cov_149.409091_g61365_i0 | PRJNA432257 | 61746 | 213 | 149.409091 | 318.24136383 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 4.36e-4 | NR | CDW87668.1 | 5949 | g61365 | i0 | 67.9 | 0.394366197183099 | 28 | 9 | 39.4 | 0 | 40 | 123 | 453 | 480 | CDW87668.1 UNKNOWN [Stylonychia lemnae] | diamond | 84 | 47.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 29128697 | 29128697 | PRJNA432257_S_NODE_51909_length_228_cov_1.607330_g51528_i0 | PRJNA432257 | 51909 | 228 | 1.60733 | 3.6647124 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 3.44e-9 | NR | KRX05854.1 | 266149 | g51528 | i0 | 48.1 | 0.710526315789474 | 54 | 28 | 71.1 | 0 | 226 | 65 | 361 | 414 | KRX05854.1 hypothetical protein PPERSA_03791 [Pseudocohnilembus persalinus] | diamond | 162 | 62.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 29239670 | 29239670 | PRJNA432257_S_NODE_91249_length_183_cov_2.671233_g90868_i0 | PRJNA432257 | 91249 | 183 | 2.671233 | 4.88835639 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 7.46e-10 | NR | KRX10209.1 | 266149 | g90868 | i0 | 69.6 | 1.52459016393443 | 46 | 14 | 75.4 | 0 | 43 | 180 | 1 | 46 | KRX10209.1 hypothetical protein PPERSA_10875 [Pseudocohnilembus persalinus] | diamond | 279 | 60.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 30044129 | 30044129 | PRJNA432257_S_NODE_38371_length_255_cov_6.082569_g37990_i0 | PRJNA432257 | 38371 | 255 | 6.082569 | 15.51055095 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 1.23e-7 | NR | KAL4438919.1 | 5901 | g37990 | i0 | 56.6 | 1.8 | 53 | 22 | 61.2 | 1 | 210 | 55 | 139 | 191 | KAL4438919.1 hypothetical protein ABPG74_016639 [Tetrahymena malaccensis] | diamond | 459 | 57.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 30170472 | 30170472 | PRJNA432257_S_NODE_71752_length_201_cov_84.719512_g71371_i0 | PRJNA432257 | 71752 | 201 | 84.719512 | 170.28621912 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 8.36e-10 | NR | OMJ65684.1 | 5963 | g71371 | i0 | 60 | 1.34328358208955 | 45 | 18 | 67.2 | 0 | 64 | 198 | 1 | 45 | OMJ65684.1 hypothetical protein SteCoe_37785 [Stentor coeruleus] | diamond | 270 | 63.2 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 30455311 | 30455311 | PRJNA432257_S_NODE_51313_length_229_cov_1.432292_g50932_i0 | PRJNA432257 | 51313 | 229 | 1.432292 | 3.27994868 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 7.78e-5 | NR | XP_001022647.2 | 312017 | g50932 | i0 | 40.8 | 1.42794759825328 | 49 | 29 | 64.2 | 0 | 194 | 48 | 130 | 178 | XP_001022647.2 MFS transporter [Tetrahymena thermophila SB210] | diamond | 327 | 50.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30486641 | 30486641 | PRJNA432257_S_NODE_76993_length_196_cov_1.955975_g76612_i0 | PRJNA432257 | 76993 | 196 | 1.955975 | 3.833711 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 4.12e-12 | NR | CAG9318375.1 | 1481888 | g76612 | i0 | 52.5 | 0.903061224489796 | 59 | 28 | 90.3 | 0 | 188 | 12 | 41 | 99 | CAG9318375.1 unnamed protein product [Blepharisma stoltei] | diamond | 177 | 69.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30597625 | 30597625 | PRJNA432257_S_NODE_70553_length_203_cov_1.500000_g70172_i0 | PRJNA432257 | 70553 | 203 | 1.5 | 3.045 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 3.46e-7 | NR | CAD8147233.1 | 43137 | g70172 | i0 | 63.2 | 2.80788177339901 | 38 | 14 | 56.2 | 0 | 198 | 85 | 272 | 309 | CAD8147233.1 unnamed protein product [Paramecium octaurelia] | diamond | 570 | 56.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 30692512 | 30692512 | PRJNA432257_S_NODE_47333_length_236_cov_1.296482_g46952_i0 | PRJNA432257 | 47333 | 236 | 1.296482 | 3.05969752 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 1.01e-29 | NR | CAD8095604.1 | 5886 | g46952 | i0 | 70.5 | 2.97457627118644 | 78 | 23 | 99.2 | 0 | 1 | 234 | 77 | 154 | CAD8095604.1 unnamed protein product [Paramecium primaurelia] | diamond | 702 | 118 | 0.991525423728814 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 30802499 | 30802499 | PRJNA432257_S_NODE_85654_length_188_cov_1.033113_g85273_i0 | PRJNA432257 | 85654 | 188 | 1.033113 | 1.94225244 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 3.75e-15 | NR | CAD8102418.1 | 5886 | g85273 | i0 | 84.8 | 0.734042553191489 | 46 | 7 | 73.4 | 0 | 186 | 49 | 8 | 53 | CAD8102418.1 unnamed protein product [Paramecium primaurelia] | diamond | 138 | 76.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 31086864 | 31086864 | PRJNA432257_S_NODE_10435_length_402_cov_4.419178_g10074_i0 | PRJNA432257 | 10435 | 402 | 4.419178 | 17.76509556 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.0177 | NR | KAL4481405.1 | 2486642 | g10074 | i0 | 47.2 | 0.395522388059701 | 53 | 25 | 39.6 | 2 | 127 | 285 | 607 | 656 | KAL4481405.1 hypothetical protein ABPG72_010558 [Tetrahymena utriculariae] | diamond | 159 | 45.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae | ||
| 31356361 | 31356361 | PRJNA432257_S_NODE_58936_length_217_cov_16.161111_g58555_i0 | PRJNA432257 | 58936 | 217 | 16.161111 | 35.06961087 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00157 | NR | CAD8180050.1 | 43137 | g58555 | i0 | 83.3 | 1.65898617511521 | 24 | 4 | 33.2 | 0 | 184 | 113 | 356 | 379 | CAD8180050.1 unnamed protein product [Paramecium octaurelia] | diamond | 360 | 46.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 31561352 | 31561352 | PRJNA432257_S_NODE_59176_length_217_cov_2.383333_g58795_i0 | PRJNA432257 | 59176 | 217 | 2.383333 | 5.17183261 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.73e-5 | NR | XP_001456937.1 | 5888 | g58795 | i0 | 33.3 | 7.35483870967742 | 69 | 46 | 95.4 | 0 | 209 | 3 | 43 | 111 | XP_001456937.1 uncharacterized protein GSPATT00022712001 [Paramecium tetraurelia] | diamond | 1596 | 51.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 32193930 | 32193930 | PRJNA432257_S_NODE_114138_length_162_cov_1.720000_g113757_i0 | PRJNA432257 | 114138 | 162 | 1.72 | 2.7864 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 4.17e-6 | NR | CAD8095918.1 | 65129 | g113757 | i0 | 55.8 | 0.796296296296296 | 43 | 16 | 79.6 | 1 | 145 | 17 | 99 | 138 | CAD8095918.1 unnamed protein product [Paramecium sonneborni] | diamond | 129 | 52.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 32193932 | 32193932 | PRJNA432257_S_NODE_127178_length_151_cov_1.324561_g126797_i0 | PRJNA432257 | 127178 | 151 | 1.324561 | 2.00008711 | Paramecium aurelia | 5889 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 2.38e-14 | NR | NP_039477.1 | 5889 | g126797 | i0 | 94.4 | 0.71523178807947 | 36 | 2 | 71.5 | 0 | 109 | 2 | 1 | 36 | NP_039477.1 unnamed protein product [Paramecium aurelia] | diamond | 108 | 72 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium aurelia | ||
| 32478895 | 32478895 | PRJNA432257_S_NODE_7719_length_447_cov_96.204878_g7399_i0 | PRJNA432257 | 7719 | 447 | 96.204878 | 430.03580466 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 3.27e-33 | NR | XP_001030428.1 | 312017 | g7399 | i0 | 54.4 | 0.838926174496644 | 125 | 53 | 81.2 | 1 | 364 | 2 | 426 | 550 | XP_001030428.1 ABC transporter family protein [Tetrahymena thermophila SB210] | diamond | 375 | 134 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32715887 | 32715887 | PRJNA432257_S_NODE_33720_length_268_cov_1.649351_g33339_i0 | PRJNA432257 | 33720 | 268 | 1.649351 | 4.42026068 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 2.4e-15 | NR | CDW71975.1 | 5949 | g33339 | i0 | 62.7 | 3.34701492537313 | 51 | 19 | 57.1 | 0 | 248 | 96 | 48 | 98 | CDW71975.1 60s ribosomal protein l26 [Stylonychia lemnae] | diamond | 897 | 77 | 0.990909090909091 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32762416 | 32762416 | PRJNA432257_S_NODE_15540_length_350_cov_782.929712_g15159_i0 | PRJNA432257 | 15540 | 350 | 782.929712 | 2740.253992 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 3.51e-33 | NR | CDW71392.1 | 5949 | g15159 | i0 | 71.6 | 0.694285714285714 | 81 | 23 | 69.4 | 0 | 108 | 350 | 5 | 85 | CDW71392.1 mitochondrial carrier protein [Stylonychia lemnae] | diamond | 243 | 127 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32841741 | 32841741 | PRJNA432257_S_NODE_75860_length_197_cov_2.937500_g75479_i0 | PRJNA432257 | 75860 | 197 | 2.9375 | 5.786875 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.00194 | NR | XP_001031457.1 | 312017 | g75479 | i0 | 36.5 | 1.56852791878173 | 52 | 33 | 79.2 | 0 | 27 | 182 | 30 | 81 | XP_001031457.1 kazal-type proteinase inhibitor 1 [Tetrahymena thermophila SB210] | diamond | 309 | 44.7 | 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);;