contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5282362 | 5282362 | PRJNA1063685_S_NODE_37165_length_383_cov_11.445161_g36622_i0 | PRJNA1063685 | 37165 | 383 | 11.445161 | 43.83496663 | Euplotes cf. encysticus | 2994703 | SAR_Eukaryotes | SAR_Eukaryotes | 660 | 0 | NTclustered | gi|2328859141|gb|OP828540.1| | 2994703 | g36622 | i0 | 100 | 87.8407310704961 | 357 | 0 | 93 | 0 | 1 | 357 | 767 | 411 | Euplotes cf. encysticus isolate LCY2016040803 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 33643 | 660 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes cf. encysticus | ||
| 5282547 | 5282547 | PRJNA1063685_S_NODE_57165_length_290_cov_2.894009_g56622_i0 | PRJNA1063685 | 57165 | 290 | 2.894009 | 8.3926261 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 2.8699999999999993e-136 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g56622 | i0 | 97.586 | 49.2137931034483 | 290 | 7 | 100 | 0 | 1 | 290 | 2189 | 1900 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 14272 | 497 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 5282671 | 5282671 | PRJNA1063685_S_NODE_74625_length_240_cov_5.269461_g74082_i0 | PRJNA1063685 | 74625 | 240 | 5.269461 | 12.6467064 | Leptopharynx costatus | 502090 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.9e-92 | NTclustered | gi|558697263|gb|KC832958.1| | 502090 | g74082 | i0 | 99.482 | 60.8708333333333 | 193 | 1 | 80 | 0 | 1 | 193 | 193 | 1 | Leptopharynx costatus 28S ribosomal RNA gene, partial sequence | blastn | 14609 | 351 | 1 | Eukaryota | Sar | Ciliophora | Nassophorea | Microthoracida | Microthoracidae | Leptopharynx | Leptopharynx costatus | ||
| 6115372 | 6115372 | PRJNA1063685_S_NODE_80765_length_199_cov_12.468254_g80222_i0 | PRJNA1063685 | 80765 | 199 | 12.468254 | 24.81182546 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.51e-97 | NTclustered | gi|1233819925|gb|KX516617.1| | 440145 | g80222 | i0 | 100 | 100.29648241206 | 199 | 0 | 100 | 0 | 1 | 199 | 1506 | 1308 | Euplotes encysticus isolate B555 large subunit ribosomal RNA gene, partial sequence | blastn | 19959 | 368 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes encysticus | ||
| 6557844 | 6557844 | PRJNA1063685_S_NODE_79946_length_208_cov_9.696296_g79403_i0 | PRJNA1063685 | 79946 | 208 | 9.696296 | 20.16829568 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 8.01e-41 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g79403 | i0 | 85.632 | 12.7259615384615 | 174 | 21 | 82 | 3 | 1 | 170 | 3155 | 3328 | 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 | 2647 | 180 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 7832093 | 7832093 | PRJNA1063685_S_NODE_25867_length_459_cov_4.461140_g25326_i0 | PRJNA1063685 | 25867 | 459 | 4.46114 | 20.4766326 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 2.62e-14 | NTclustered | gi|829195198|ref|XM_001025389.3| | 312017 | g25326 | i0 | 87.5 | 0.357298474945534 | 80 | 10 | 17 | 0 | 23 | 102 | 371 | 450 | Tetrahymena thermophila SB210 40S ribosomal protein S14 partial mRNA | blastn | 164 | 93.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 7832250 | 7832250 | PRJNA1063685_S_NODE_41487_length_360_cov_7.233449_g40944_i0 | PRJNA1063685 | 41487 | 360 | 7.233449 | 26.0404164 | Metopus es | 392813 | SAR_Eukaryotes | SAR_Eukaryotes | 545 | 1.2799999999999995e-150 | NTclustered | gi|110645073|gb|DQ665935.1| | 392813 | g40944 | i0 | 95.846 | 91.65 | 337 | 14 | 94 | 0 | 24 | 360 | 393 | 729 | Metopus es clone 1 actin gene, partial cds; macronuclear | blastn | 32994 | 545 | 1 | Eukaryota | Sar | Ciliophora | Armophorea | Metopida | Metopidae | Metopus | Metopus es | ||
| 9106937 | 9106937 | PRJNA1063685_S_NODE_13088_length_585_cov_9.777344_g12568_i0 | PRJNA1063685 | 13088 | 585 | 9.777344 | 57.1974624 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 1.49e-57 | NTclustered | gi|2072713056|gb|MH608212.2| | 266149 | g12568 | i0 | 79.758 | 11.191452991453 | 331 | 63 | 56 | 3 | 257 | 585 | 5951 | 5623 | Pseudocohnilembus persalinus mitochondrion | blastn | 6547 | 237 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 9939959 | 9939959 | PRJNA1063685_S_NODE_17008_length_539_cov_29.978541_g16476_i0 | PRJNA1063685 | 17008 | 539 | 29.978541 | 161.58433599 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 929 | 0 | NTclustered | gi|1584439067|gb|MK579316.1| | 5902 | g16476 | i0 | 99.225 | 94.3228200371058 | 516 | 2 | 96 | 2 | 11 | 526 | 10 | 523 | Tetrahymena mimbres isolate XZ9 small subunit ribosomal RNA gene, partial sequence | blastn | 50840 | 935 | 0.993582887700535 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena mimbres | ||
| 11215394 | 11215394 | PRJNA1063685_S_NODE_42269_length_356_cov_6.685512_g41726_i0 | PRJNA1063685 | 42269 | 356 | 6.685512 | 23.80042272 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 538 | 2.1199999999999994e-148 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g41726 | i0 | 96.885 | 19.626404494382 | 321 | 10 | 90 | 0 | 24 | 344 | 1173 | 1493 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 6987 | 538 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11657876 | 11657876 | PRJNA1063685_S_NODE_12690_length_590_cov_24.013540_g12172_i0 | PRJNA1063685 | 12690 | 590 | 24.01354 | 141.679886 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 551 | 4.719999999999998e-152 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g12172 | i0 | 86.398 | 87.471186440678 | 522 | 49 | 85 | 15 | 1 | 504 | 3327 | 3844 | 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 | 51608 | 551 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 12933205 | 12933205 | PRJNA1063685_S_NODE_24651_length_468_cov_33.283544_g24111_i0 | PRJNA1063685 | 24651 | 468 | 33.283544 | 155.76698592 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 780 | 0 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g24111 | i0 | 98.42 | 89.4273504273504 | 443 | 7 | 95 | 0 | 24 | 466 | 960 | 1402 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 41852 | 780 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 15039868 | 15039868 | PRJNA1063685_S_NODE_76252_length_234_cov_2.490683_g75709_i0 | PRJNA1063685 | 76252 | 234 | 2.490683 | 5.82819822 | Cyclidium | 35099 | SAR_Eukaryotes | SAR_Eukaryotes | 433 | 6.41e-117 | NTclustered | gi|1150566195|gb|KX578216.1| | 35100 | g75709 | i0 | 100 | 99.5769230769231 | 234 | 0 | 100 | 0 | 1 | 234 | 343 | 576 | Cyclidium glaucoma isolate SUVRK07 18S ribosomal RNA gene, partial sequence | blastn | 23301 | 433 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 16314352 | 16314352 | PRJNA1063685_S_NODE_36833_length_385_cov_6.612179_g36290_i0 | PRJNA1063685 | 36833 | 385 | 6.612179 | 25.45688915 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 689 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g36290 | i0 | 98.961 | 23.7116883116883 | 385 | 4 | 100 | 0 | 1 | 385 | 1489 | 1873 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 9129 | 689 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 16314394 | 16314394 | PRJNA1063685_S_NODE_43373_length_350_cov_12.259928_g42830_i0 | PRJNA1063685 | 43373 | 350 | 12.259928 | 42.909748 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 595 | 1.22e-165 | NTclustered | gi|2459327249|gb|OQ626843.1| | 5908 | g42830 | i0 | 99.39 | 93.0714285714286 | 328 | 2 | 94 | 0 | 23 | 350 | 459 | 786 | Tetrahymena pyriformis isolate LLH20220320 pop variant pop1 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 | 32575 | 595 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 16756688 | 16756688 | PRJNA1063685_S_NODE_58954_length_283_cov_17.504762_g58411_i0 | PRJNA1063685 | 58954 | 283 | 17.504762 | 49.53847646 | Metopus es | 392813 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.3199999999999998e-124 | NTclustered | gi|110645073|gb|DQ665935.1| | 392813 | g58411 | i0 | 96.085 | 101.618374558304 | 281 | 11 | 99 | 0 | 3 | 283 | 194 | 474 | Metopus es clone 1 actin gene, partial cds; macronuclear | blastn | 28758 | 459 | 1 | Eukaryota | Sar | Ciliophora | Armophorea | Metopida | Metopidae | Metopus | Metopus es | ||
| 18031259 | 18031259 | PRJNA1063685_S_NODE_35915_length_390_cov_43.305994_g35372_i0 | PRJNA1063685 | 35915 | 390 | 43.305994 | 168.8933766 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 549 | 1.0799999999999997e-151 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g35372 | i0 | 94.413 | 41.7179487179487 | 358 | 18 | 92 | 2 | 7 | 363 | 357 | 1 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16270 | 549 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18031341 | 18031341 | PRJNA1063685_S_NODE_45035_length_342_cov_4.241636_g44492_i0 | PRJNA1063685 | 45035 | 342 | 4.241636 | 14.50639512 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 575 | 1.5499999999999994e-159 | NTclustered | gi|111035915|emb|AJ781092.1| | 35100 | g44492 | i0 | 98.471 | 93.9473684210526 | 327 | 3 | 95 | 2 | 17 | 342 | 1 | 326 | Cyclidium glaucoma partial 23S rRNA gene, strain ATCC 30701 | blastn | 32130 | 575 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 20138527 | 20138527 | PRJNA1063685_S_NODE_62656_length_271_cov_2.934343_g62113_i0 | PRJNA1063685 | 62656 | 271 | 2.934343 | 7.95206953 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 2.07e-132 | NTclustered | gi|1233819925|gb|KX516617.1| | 440145 | g62113 | i0 | 98.893 | 101.749077490775 | 271 | 3 | 100 | 0 | 1 | 271 | 969 | 1239 | Euplotes encysticus isolate B555 large subunit ribosomal RNA gene, partial sequence | blastn | 27574 | 484 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes encysticus | ||
| 20580593 | 20580593 | PRJNA1063685_S_NODE_31617_length_417_cov_6.104651_g31075_i0 | PRJNA1063685 | 31617 | 417 | 6.104651 | 25.45639467 | Aristerostoma sp. Assp1 | 767759 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 5.8699999999999996e-95 | NTclustered | gi|296939552|gb|HM246398.1| | 767759 | g31075 | i0 | 83.59 | 16.4148681055156 | 390 | 58 | 93 | 6 | 1 | 388 | 386 | 1 | Aristerostoma sp. Assp1 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 6845 | 361 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Cyrtolophosidida | Cyrtolophosididae | Aristerostoma | Aristerostoma sp. Assp1 | ||
| 20580913 | 20580913 | PRJNA1063685_S_NODE_67197_length_257_cov_12.315217_g66654_i0 | PRJNA1063685 | 67197 | 257 | 12.315217 | 31.65010769 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 3.32e-115 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g66654 | i0 | 99.574 | 86.5252918287938 | 235 | 0 | 91 | 1 | 1 | 234 | 2782 | 2548 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 22237 | 427 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 22688705 | 22688705 | PRJNA1063685_S_NODE_29238_length_434_cov_7.869806_g28696_i0 | PRJNA1063685 | 29238 | 434 | 7.869806 | 34.15495804 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 1.12e-32 | NTclustered | gi|2643596954|gb|PP067626.1| | 5987 | g28696 | i0 | 90.517 | 26.6036866359447 | 116 | 11 | 27 | 0 | 193 | 308 | 3847 | 3732 | Isotricha prostoma isolate 03.MDA03 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 11546 | 154 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha prostoma | ||
| 23131934 | 23131934 | PRJNA1063685_S_NODE_44679_length_344_cov_2.568266_g44136_i0 | PRJNA1063685 | 44679 | 344 | 2.568266 | 8.83483504 | Colpoda inflata | 5980 | SAR_Eukaryotes | SAR_Eukaryotes | 547 | 3.399999999999999e-151 | NTclustered | gi|174166|gb|M98367.1|CLPRRLSA | 5980 | g44136 | i0 | 96.636 | 86.1744186046512 | 327 | 10 | 95 | 1 | 1 | 327 | 329 | 4 | Colpoda inflata large subunit ribosomal RNA, 5' end | blastn | 29644 | 547 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 25238347 | 25238347 | PRJNA1063685_S_NODE_57900_length_287_cov_5.724299_g57357_i0 | PRJNA1063685 | 57900 | 287 | 5.724299 | 16.42873813 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 520 | 6.049999999999999e-143 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g57357 | i0 | 99.303 | 98.1149825783972 | 287 | 2 | 100 | 0 | 1 | 287 | 1771 | 2057 | Colpoda sp. isolate JGP15 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 | 28159 | 520 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. |
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);;