contig_metadata
24 rows where bioproject = "PRJNA773247", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10135727 | 10135727 | PRJNA773247_P_NODE_5768_length_724_cov_2.371736_g5688_i0 | PRJNA773247 | 5768 | 724 | 2.371736 | 17.17136864 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 201 | 1.9499999999999994e-55 | NR | CAI2378285.1 | 5936 | g5688 | i0 | 69.9 | 0.56353591160221 | 136 | 37 | 54.7 | 1 | 714 | 319 | 364 | 499 | CAI2378285.1 unnamed protein product [Moneuplotes crassus] | diamond | 408 | 201 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 26831859 | 26831859 | PRJNA773247_P_NODE_24941_length_281_cov_1.350962_g24857_i0 | PRJNA773247 | 24941 | 281 | 1.350962 | 3.79620322 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 151 | 4.82e-44 | NR | CAI2380618.1 | 5936 | g24857 | i0 | 74.7 | 0.97153024911032 | 91 | 23 | 97.2 | 0 | 275 | 3 | 91 | 181 | CAI2380618.1 unnamed protein product [Moneuplotes crassus] | diamond | 273 | 151 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 26895331 | 26895331 | PRJNA773247_P_NODE_26541_length_271_cov_1.166667_g26457_i0 | PRJNA773247 | 26541 | 271 | 1.166667 | 3.16166757 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 4.66e-11 | NR | TNV81256.1 | 5974 | g26457 | i0 | 41.5 | 0.719557195571956 | 65 | 37 | 72 | 1 | 247 | 53 | 19 | 82 | TNV81256.1 hypothetical protein FGO68_gene539 [Halteria grandinella] | diamond | 195 | 63.9 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 27116334 | 27116334 | PRJNA773247_P_NODE_26882_length_269_cov_1.178571_g26798_i0 | PRJNA773247 | 26882 | 269 | 1.178571 | 3.17035599 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 2.61e-10 | NR | CAI2366190.1 | 5936 | g26798 | i0 | 46.4 | 0.769516728624535 | 69 | 34 | 77 | 1 | 63 | 269 | 129 | 194 | CAI2366190.1 unnamed protein product [Moneuplotes crassus] | diamond | 207 | 66.2 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 27717170 | 27717170 | PRJNA773247_P_NODE_9984_length_499_cov_0.903756_g9901_i0 | PRJNA773247 | 9984 | 499 | 0.903756 | 4.50974244 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.1599999999999999e-47 | NR | CAI2374497.1 | 5936 | g9901 | i0 | 81.2 | 0.607214428857715 | 101 | 19 | 60.7 | 0 | 304 | 2 | 48 | 148 | CAI2374497.1 unnamed protein product [Moneuplotes crassus] | diamond | 303 | 167 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 28001079 | 28001079 | PRJNA773247_P_NODE_16325_length_363_cov_9.720690_g16241_i0 | PRJNA773247 | 16325 | 363 | 9.72069 | 35.2861047 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 2.45e-34 | NR | OMJ94993.1 | 5963 | g16241 | i0 | 54.8 | 2.03305785123967 | 124 | 52 | 99.2 | 2 | 362 | 3 | 698 | 821 | OMJ94993.1 hypothetical protein SteCoe_1686 [Stentor coeruleus] | diamond | 738 | 136 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 28443082 | 28443082 | PRJNA773247_P_NODE_2146_length_1361_cov_3.854814_g2100_i0 | PRJNA773247 | 2146 | 1361 | 3.854814 | 52.46401854 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 286 | 1.3099999999999998e-88 | NR | CDW75405.1 | 5949 | g2100 | i0 | 80 | 0.352681851579721 | 160 | 32 | 35.3 | 0 | 620 | 141 | 232 | 391 | CDW75405.1 cysteine protease [Stylonychia lemnae] | diamond | 480 | 286 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28569169 | 28569169 | PRJNA773247_P_NODE_7527_length_601_cov_5.914773_g7444_i0 | PRJNA773247 | 7527 | 601 | 5.914773 | 35.54778573 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 2.16e-12 | NR | CDW89303.1 | 5949 | g7444 | i0 | 48.9 | 0.439267886855241 | 88 | 45 | 43.9 | 0 | 557 | 294 | 36 | 123 | CDW89303.1 dual specificity protein phosphatase cdc14a [Stylonychia lemnae] | diamond | 264 | 76.6 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 29200857 | 29200857 | PRJNA773247_P_NODE_13149_length_417_cov_2.895349_g13066_i0 | PRJNA773247 | 13149 | 417 | 2.895349 | 12.07360533 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 4.7800000000000003e-91 | NR | CAI2371662.1 | 5936 | g13066 | i0 | 90.6 | 1 | 139 | 13 | 100 | 0 | 417 | 1 | 112 | 250 | CAI2371662.1 unnamed protein product [Moneuplotes crassus] | diamond | 417 | 278 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 29232389 | 29232389 | PRJNA773247_P_NODE_21489_length_307_cov_1.393162_g21405_i0 | PRJNA773247 | 21489 | 307 | 1.393162 | 4.27700734 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 3.05e-42 | NR | CAD8066426.1 | 5886 | g21405 | i0 | 74.2 | 0.947882736156352 | 97 | 25 | 94.8 | 0 | 17 | 307 | 31 | 127 | CAD8066426.1 unnamed protein product [Paramecium primaurelia] | diamond | 291 | 147 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 29390303 | 29390303 | PRJNA773247_P_NODE_31449_length_248_cov_3.017143_g31365_i0 | PRJNA773247 | 31449 | 248 | 3.017143 | 7.48251464 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 2.25e-11 | NR | OMJ87843.1 | 5963 | g31365 | i0 | 46.2 | 0.943548387096774 | 78 | 42 | 94.4 | 0 | 10 | 243 | 1 | 78 | OMJ87843.1 hypothetical protein SteCoe_10323 [Stentor coeruleus] | diamond | 234 | 68.9 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 29547832 | 29547832 | PRJNA773247_P_NODE_32610_length_246_cov_0.890173_g32526_i0 | PRJNA773247 | 32610 | 246 | 0.890173 | 2.18982558 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 6.100000000000001e-28 | NR | CAI2381730.1 | 5936 | g32526 | i0 | 59.3 | 0.98780487804878 | 81 | 33 | 98.8 | 0 | 2 | 244 | 3 | 83 | CAI2381730.1 unnamed protein product [Moneuplotes crassus] | diamond | 243 | 108 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 29737229 | 29737229 | PRJNA773247_P_NODE_28710_length_259_cov_1.198925_g28626_i0 | PRJNA773247 | 28710 | 259 | 1.198925 | 3.10521575 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 2.1499999999999998e-24 | NR | CAD8066426.1 | 5886 | g28626 | i0 | 62.2 | 2.57142857142857 | 74 | 28 | 85.7 | 0 | 1 | 222 | 125 | 198 | CAD8066426.1 unnamed protein product [Paramecium primaurelia] | diamond | 666 | 100 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 30125818 | 30125818 | PRJNA773247_P_NODE_21872_length_304_cov_0.987013_g21788_i0 | PRJNA773247 | 21872 | 304 | 0.987013 | 3.00051952 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 164 | 1.3999999999999998e-44 | NR | XP_001423830.1 | 5888 | g21788 | i0 | 89 | 2.69407894736842 | 91 | 10 | 89.8 | 0 | 1 | 273 | 685 | 775 | XP_001423830.1 uncharacterized protein GSPATT00004526001 [Paramecium tetraurelia] | diamond | 819 | 164 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 30274757 | 30274757 | PRJNA773247_P_NODE_29832_length_253_cov_1.222222_g29748_i0 | PRJNA773247 | 29832 | 253 | 1.222222 | 3.09222166 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 9.95e-18 | NR | CDW85399.1 | 5949 | g29748 | i0 | 51.9 | 1.76679841897233 | 81 | 38 | 96 | 1 | 252 | 10 | 143 | 222 | CDW85399.1 UNKNOWN [Stylonychia lemnae] | diamond | 447 | 86.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30338174 | 30338174 | PRJNA773247_P_NODE_8692_length_545_cov_8.862288_g8609_i0 | PRJNA773247 | 8692 | 545 | 8.862288 | 48.2994696 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 1.72e-9 | NR | CDW82626.1 | 5949 | g8609 | i0 | 32.5 | 1.31009174311927 | 120 | 79 | 65.5 | 2 | 538 | 182 | 1580 | 1698 | CDW82626.1 u5 small nuclear ribonucleoprotein 200 kda helicase [Stylonychia lemnae] | diamond | 714 | 67.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30780004 | 30780004 | PRJNA773247_P_NODE_1594_length_1564_cov_35.478873_g1562_i0 | PRJNA773247 | 1594 | 1564 | 35.478873 | 554.88957372 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 6.1e-32 | NR | CAI2363286.1 | 5936 | g1562 | i0 | 37.7 | 0.544757033248082 | 284 | 153 | 50.3 | 5 | 739 | 1524 | 269 | 550 | CAI2363286.1 unnamed protein product [Moneuplotes crassus] | diamond | 852 | 140 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30843316 | 30843316 | PRJNA773247_P_NODE_27374_length_266_cov_1.471503_g27290_i0 | PRJNA773247 | 27374 | 266 | 1.471503 | 3.91419798 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 6.670000000000001e-26 | NR | CDW85399.1 | 5949 | g27290 | i0 | 62.2 | 0.924812030075188 | 82 | 31 | 92.5 | 0 | 19 | 264 | 2 | 83 | CDW85399.1 UNKNOWN [Stylonychia lemnae] | diamond | 246 | 108 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31033101 | 31033101 | PRJNA773247_P_NODE_6515_length_668_cov_1.826891_g6433_i0 | PRJNA773247 | 6515 | 668 | 1.826891 | 12.20363188 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 273 | 4.7899999999999995e-84 | NR | CAI2358834.1 | 5936 | g6433 | i0 | 71.7 | 0.839820359281437 | 187 | 53 | 84 | 0 | 106 | 666 | 166 | 352 | CAI2358834.1 unnamed protein product [Moneuplotes crassus] | diamond | 561 | 273 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 31095896 | 31095896 | PRJNA773247_P_NODE_9435_length_517_cov_4.641892_g9352_i0 | PRJNA773247 | 9435 | 517 | 4.641892 | 23.99858164 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 1.69e-19 | NR | CAI2377847.1 | 5936 | g9352 | i0 | 40.8 | 0.568665377176016 | 98 | 58 | 56.9 | 0 | 138 | 431 | 110 | 207 | CAI2377847.1 unnamed protein product [Moneuplotes crassus] | diamond | 294 | 92.4 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 31443771 | 31443771 | PRJNA773247_P_NODE_7136_length_624_cov_3.047187_g7053_i0 | PRJNA773247 | 7136 | 624 | 3.047187 | 19.01444688 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 286 | 2.16e-92 | NR | CDW90382.1 | 5949 | g7053 | i0 | 72.7 | 0.899038461538462 | 187 | 51 | 89.9 | 0 | 42 | 602 | 161 | 347 | CDW90382.1 actin-like protein [Stylonychia lemnae] | diamond | 561 | 286 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31981411 | 31981411 | PRJNA773247_P_NODE_29478_length_254_cov_3.685083_g29394_i0 | PRJNA773247 | 29478 | 254 | 3.685083 | 9.36011082 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 2.87e-16 | NR | CAI2366190.1 | 5936 | g29394 | i0 | 66.7 | 0.637795275590551 | 54 | 18 | 63.8 | 0 | 1 | 162 | 194 | 247 | CAI2366190.1 unnamed protein product [Moneuplotes crassus] | diamond | 162 | 82.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32623513 | 32623513 | PRJNA773247_P_NODE_33180_length_244_cov_5.076023_g33096_i0 | PRJNA773247 | 33180 | 244 | 5.076023 | 12.385496120000001 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0107 | NR | XP_004031297.1 | 5932 | g33096 | i0 | 45.2 | 2.0655737704918 | 42 | 23 | 51.6 | 0 | 205 | 80 | 178 | 219 | XP_004031297.1 kelch motif family protein, putative [Ichthyophthirius multifiliis] | diamond | 504 | 44.7 | 0.991051454138702 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 32676882 | 32676882 | PRJNA773247_P_NODE_35720_length_234_cov_3.409938_g35636_i0 | PRJNA773247 | 35720 | 234 | 3.409938 | 7.97925492 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 1.92e-26 | NR | OMJ65795.1 | 5963 | g35636 | i0 | 69.2 | 1 | 78 | 24 | 100 | 0 | 1 | 234 | 567 | 644 | OMJ65795.1 hypothetical protein SteCoe_37615 [Stentor coeruleus] | diamond | 234 | 111 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus |
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);;