contig_metadata
20 rows where bioproject = "PRJNA416866", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 419640 | 419640 | PRJNA416866_P_NODE_9841_length_208_cov_0.870748_g9697_i0 | PRJNA416866 | 9841 | 208 | 0.870748 | 1.81115584 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 6.28e-32 | NTclustered | gi|471233821|ref|XM_004039041.1| | 5932 | g9697 | i0 | 80.829 | 17.9038461538462 | 193 | 35 | 92 | 2 | 14 | 205 | 852 | 1043 | Ichthyophthirius multifiliis hypothetical protein (IMG5_034130) mRNA, complete cds | blastn | 3724 | 150 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 1694456 | 1694456 | PRJNA416866_P_NODE_2322_length_449_cov_5.332474_g2179_i0 | PRJNA416866 | 2322 | 449 | 5.332474 | 23.94280826 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 813 | 0 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g2179 | i0 | 99.332 | 68.6926503340757 | 449 | 3 | 100 | 0 | 1 | 449 | 3541 | 3989 | 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 | 30843 | 813 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 3634604 | 3634604 | PRJNA416866_P_NODE_4983_length_293_cov_2.336207_g4839_i0 | PRJNA416866 | 4983 | 293 | 2.336207 | 6.84508651 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 3.21e-66 | NTclustered | gi|194245783|gb|EU828456.1| | 5888 | g4839 | i0 | 84.477 | 56.9249146757679 | 277 | 33 | 93 | 8 | 22 | 293 | 3305 | 3034 | Paramecium tetraurelia large subunit ribosomal RNA gene, complete sequence | blastn | 16679 | 265 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 5523413 | 5523413 | PRJNA416866_P_NODE_7805_length_231_cov_2.488235_g7661_i0 | PRJNA416866 | 7805 | 231 | 2.488235 | 5.74782285 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 2.9599999999999995e-110 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g7661 | i0 | 98.701 | 100.251082251082 | 231 | 3 | 100 | 0 | 1 | 231 | 3052 | 2822 | 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 | 23158 | 411 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 7461718 | 7461718 | PRJNA416866_P_NODE_8346_length_223_cov_1.969136_g8202_i0 | PRJNA416866 | 8346 | 223 | 1.969136 | 4.39117328 | Uronematidae | 35105 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 7.88e-111 | NTclustered | gi|406609852|dbj|AB749127.1| | 187299 | g8202 | i0 | 100 | 100.340807174888 | 223 | 0 | 100 | 0 | 1 | 223 | 1511 | 1289 | Uncultured ciliate gene for 18S ribosomal RNA, partial sequence, clone: Cn-St.5-78 | blastn | 22376 | 412 | 1 | Eukaryota | Sar | Ciliophora | uncultured ciliate | ||||||
| 8736636 | 8736636 | PRJNA416866_P_NODE_4247_length_320_cov_1.320463_g4104_i0 | PRJNA416866 | 4247 | 320 | 1.320463 | 4.2254816 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 4.81e-44 | NR | CDW82785.1 | 5949 | g4104 | i0 | 71.7 | 13.875 | 106 | 30 | 99.4 | 0 | 319 | 2 | 4 | 109 | CDW82785.1 40s ribosomal protein [Stylonychia lemnae] | diamond | 4440 | 151 | 0.993377483443709 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 12562472 | 12562472 | PRJNA416866_P_NODE_3170_length_377_cov_1.920886_g3027_i0 | PRJNA416866 | 3170 | 377 | 1.920886 | 7.24174022 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 630 | 3.629999999999999e-176 | NTclustered | gi|2354193480|gb|OP896969.1| | 2006707 | g3027 | i0 | 96.817 | 90.763925729443 | 377 | 12 | 100 | 0 | 1 | 377 | 830 | 1206 | Philasterida sp. strain tDaCF9_52 large subunit ribosomal RNA gene, partial sequence | blastn | 34218 | 634 | 0.993690851735016 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasterida sp. | ||||
| 14448538 | 14448538 | PRJNA416866_P_NODE_3532_length_355_cov_2.289116_g3389_i0 | PRJNA416866 | 3532 | 355 | 2.289116 | 8.1263618 | Cyclidium sp. MMP-2020a | 2704628 | SAR_Eukaryotes | SAR_Eukaryotes | 634 | 2.6199999999999992e-177 | NTclustered | gi|2009899914|gb|MW785065.1| | 2704628 | g3389 | i0 | 98.873 | 67.701408450704207 | 355 | 4 | 100 | 0 | 1 | 355 | 833 | 479 | Cyclidium sp. MMP-2020a isolate SM20191018 large subunit ribosomal RNA gene, partial sequence | blastn | 24034 | 634 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium sp. MMP-2020a | ||
| 18271276 | 18271276 | PRJNA416866_P_NODE_12275_length_179_cov_5.220339_g12131_i0 | PRJNA416866 | 12275 | 179 | 5.220339 | 9.34440681 | Prodiscocephalus orientalis | 2652905 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 5.38e-12 | NTclustered | gi|2328859132|gb|OP828533.1| | 2652905 | g12131 | i0 | 77.931 | 33.9217877094972 | 145 | 24 | 79 | 6 | 31 | 171 | 1663 | 1523 | Prodiscocephalus orientalis isolate LCY2018050403 large subunit ribosomal RNA gene, partial sequence | blastn | 6072 | 84.2 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Discocephalidae | Prodiscocephalus | Prodiscocephalus orientalis | ||
| 18271299 | 18271299 | PRJNA416866_P_NODE_5995_length_266_cov_1.560976_g5851_i0 | PRJNA416866 | 5995 | 266 | 1.560976 | 4.15219616 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.24e-114 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5851 | i0 | 95.489 | 15.6052631578947 | 266 | 12 | 100 | 0 | 1 | 266 | 304 | 39 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 4151 | 425 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18935228 | 18935228 | PRJNA416866_P_NODE_6615_length_253_cov_1.578125_g6471_i0 | PRJNA416866 | 6615 | 253 | 1.578125 | 3.99265625 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.5099999999999996e-118 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g6471 | i0 | 98.016 | 74.102766798419 | 252 | 5 | 99 | 0 | 1 | 252 | 1646 | 1897 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 18748 | 438 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 19545484 | 19545484 | PRJNA416866_P_NODE_4436_length_313_cov_1.257937_g4293_i0 | PRJNA416866 | 4436 | 313 | 1.257937 | 3.93734281 | Caryotricha minuta | 1004043 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 2.7499999999999996e-47 | NTclustered | gi|759083508|gb|KM222125.1| | 1004043 | g4293 | i0 | 85.204 | 23.6198083067093 | 196 | 29 | 63 | 0 | 114 | 309 | 1283 | 1088 | Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence | blastn | 7393 | 202 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Kiitrichida | Kiitrichidae | Caryotricha | Caryotricha minuta | ||
| 21485469 | 21485469 | PRJNA416866_P_NODE_4777_length_301_cov_1.041667_g4633_i0 | PRJNA416866 | 4777 | 301 | 1.041667 | 3.13541767 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 551 | 2.2699999999999992e-152 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g4633 | i0 | 99.668 | 99.8272425249169 | 301 | 1 | 100 | 0 | 1 | 301 | 1535 | 1235 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 30048 | 551 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24035531 | 24035531 | PRJNA416866_P_NODE_8859_length_216_cov_1.535484_g8715_i0 | PRJNA416866 | 8859 | 216 | 1.535484 | 3.31664544 | Colpodidae | 5978 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 5.909999999999999e-107 | NTclustered | gi|2067012198|gb|MZ557838.1| | 5980 | g8715 | i0 | 100 | 100.111111111111 | 216 | 0 | 100 | 0 | 1 | 216 | 336 | 121 | Colpoda inflata isolate ZL20210414 small subunit ribosomal RNA gene, partial sequence | blastn | 21624 | 399 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 25309882 | 25309882 | PRJNA416866_P_NODE_10260_length_206_cov_1.800000_g10116_i0 | PRJNA416866 | 10260 | 206 | 1.8 | 3.708 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 2.62e-100 | NTclustered | gi|2067012198|gb|MZ557838.1| | 5980 | g10116 | i0 | 100 | 99.0291262135922 | 204 | 0 | 99 | 0 | 3 | 206 | 1067 | 864 | Colpoda inflata isolate ZL20210414 small subunit ribosomal RNA gene, partial sequence | blastn | 20400 | 377 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 26617383 | 26617383 | PRJNA416866_P_NODE_9581_length_209_cov_0.864865_g9437_i0 | PRJNA416866 | 9581 | 209 | 0.864865 | 1.80756785 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 2.55e-8 | NR | CAI2363781.1 | 5936 | g9437 | i0 | 44.6 | 1.60765550239234 | 56 | 30 | 80.4 | 1 | 3 | 170 | 2183 | 2237 | CAI2363781.1 unnamed protein product [Moneuplotes crassus] | diamond | 336 | 59.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 26839291 | 26839291 | PRJNA416866_P_NODE_1181_length_652_cov_2.583756_g1044_i0 | PRJNA416866 | 1181 | 652 | 2.583756 | 16.84608912 | Spirotrichea | 33829 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 4.72e-5 | NR | CAI2365810.1 | 5936 | g1044 | i0 | 41.9 | 0.579754601226994 | 62 | 35 | 28.5 | 1 | 435 | 620 | 62 | 122 | CAI2365810.1 unnamed protein product [Moneuplotes crassus] | diamond | 378 | 55.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 26980604 | 26980604 | PRJNA416866_P_NODE_1522_length_564_cov_2.147117_g1382_i0 | PRJNA416866 | 1522 | 564 | 2.147117 | 12.10973988 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 2.93e-65 | NR | OMJ65538.1 | 5963 | g1382 | i0 | 61.8 | 2.03191489361702 | 191 | 57 | 98.4 | 5 | 562 | 8 | 52 | 232 | OMJ65538.1 hypothetical protein SteCoe_38039 [Stentor coeruleus] | diamond | 1146 | 213 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 28465305 | 28465305 | PRJNA416866_P_NODE_11326_length_203_cov_0.901408_g11182_i0 | PRJNA416866 | 11326 | 203 | 0.901408 | 1.82985824 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 2.48e-6 | NR | KRX05637.1 | 266149 | g11182 | i0 | 65.7 | 0.517241379310345 | 35 | 12 | 51.7 | 0 | 13 | 117 | 204 | 238 | KRX05637.1 hypothetical protein PPERSA_09777 [Pseudocohnilembus persalinus] | diamond | 105 | 53.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 31466249 | 31466249 | PRJNA416866_P_NODE_4796_length_300_cov_1.606695_g4652_i0 | PRJNA416866 | 4796 | 300 | 1.606695 | 4.820085 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 1.28e-20 | NR | CAG9318382.1 | 1481888 | g4652 | i0 | 73.9 | 0.46 | 46 | 12 | 46 | 0 | 1 | 138 | 90 | 135 | CAG9318382.1 unnamed protein product [Blepharisma stoltei] | diamond | 138 | 91.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei |
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);;