contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 606631 | 606631 | PRJNA635874_P_NODE_10421_length_456_cov_1.587467_g10274_i0 | PRJNA635874 | 10421 | 456 | 1.587467 | 7.23884952 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 795 | 0 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g10274 | i0 | 98.879 | 48.4934210526316 | 446 | 4 | 98 | 1 | 12 | 456 | 5 | 450 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 22113 | 795 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 3158295 | 3158295 | PRJNA635874_P_NODE_36563_length_279_cov_2.111650_g36416_i0 | PRJNA635874 | 36563 | 279 | 2.11165 | 5.8915035 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.6899999999999996e-118 | NTclustered | gi|110644972|gb|DQ665918.1| | 151077 | g36416 | i0 | 94.982 | 97.831541218638 | 279 | 14 | 100 | 0 | 1 | 279 | 678 | 400 | Chilodonella uncinata clone 1 beta-tubulin gene, partial cds | blastn | 27295 | 438 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 3705974 | 3705974 | PRJNA635874_P_NODE_26063_length_319_cov_1.792683_g25916_i0 | PRJNA635874 | 26063 | 319 | 1.792683 | 5.71865877 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 7.64e-63 | NTclustered | gi|10805|emb|X52242.1| | 5911 | g25916 | i0 | 86.522 | 62.3699059561129 | 230 | 31 | 72 | 0 | 1 | 230 | 247 | 476 | T.thermophila mRNA for calmodulin | blastn | 19896 | 254 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 5710543 | 5710543 | PRJNA635874_P_NODE_17665_length_369_cov_1.655405_g17518_i0 | PRJNA635874 | 17665 | 369 | 1.655405 | 6.10844445 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 473 | 6.309999999999999e-129 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g17518 | i0 | 93.189 | 53.9756097560976 | 323 | 20 | 87 | 2 | 2 | 323 | 884 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 19917 | 473 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 5710589 | 5710589 | PRJNA635874_P_NODE_1925_length_878_cov_1.996273_g1812_i0 | PRJNA635874 | 1925 | 878 | 1.996273 | 17.52727694 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1478 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g1812 | i0 | 97.039 | 22.4555808656036 | 878 | 26 | 100 | 0 | 1 | 878 | 1123 | 246 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 19716 | 1478 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6258218 | 6258218 | PRJNA635874_P_NODE_43985_length_257_cov_1.521739_g43838_i0 | PRJNA635874 | 43985 | 257 | 1.521739 | 3.91086923 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 8.23e-17 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g43838 | i0 | 95.238 | 0.735408560311284 | 63 | 3 | 25 | 0 | 1 | 63 | 3020 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 189 | 100 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 6986523 | 6986523 | PRJNA635874_P_NODE_59446_length_246_cov_0.890173_g59299_i0 | PRJNA635874 | 59446 | 246 | 0.890173 | 2.18982558 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 3.2300000000000003e-100 | NTclustered | gi|229594318|ref|XM_001030083.3| | 312017 | g59299 | i0 | 94.65 | 0.98780487804878 | 243 | 13 | 99 | 0 | 4 | 246 | 360 | 118 | Tetrahymena thermophila SB210 40S ribosomal protein S3 partial mRNA | blastn | 243 | 377 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8260694 | 8260694 | PRJNA635874_P_NODE_39007_length_272_cov_1.175879_g38860_i0 | PRJNA635874 | 39007 | 272 | 1.175879 | 3.19839088 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.2899999999999997e-104 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g38860 | i0 | 92.647 | 67.7169117647059 | 272 | 20 | 100 | 0 | 1 | 272 | 1095 | 824 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 18419 | 392 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9535987 | 9535987 | PRJNA635874_P_NODE_38428_length_273_cov_2.850000_g38281_i0 | PRJNA635874 | 38428 | 273 | 2.85 | 7.7805 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.489999999999999e-130 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g38281 | i0 | 98.168 | 1 | 273 | 5 | 100 | 0 | 1 | 273 | 456 | 184 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 273 | 477 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 10811991 | 10811991 | PRJNA635874_P_NODE_49629_length_250_cov_0.870056_g49482_i0 | PRJNA635874 | 49629 | 250 | 0.870056 | 2.17514 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 2.12e-47 | NTclustered | gi|1227052606|gb|KY038460.1| | 1640447 | g49482 | i0 | 81.707 | 16.008 | 246 | 41 | 98 | 3 | 7 | 250 | 339 | 96 | Tetmemena sp. Y1 heat shock protein 70 (hsp70) gene, partial cds; macronuclear | blastn | 4002 | 202 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 | ||
| 13361499 | 13361499 | PRJNA635874_P_NODE_34411_length_286_cov_1.446009_g34264_i0 | PRJNA635874 | 34411 | 286 | 1.446009 | 4.13558574 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 1.04e-120 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g34264 | i0 | 94.755 | 26.0874125874126 | 286 | 15 | 100 | 0 | 1 | 286 | 643 | 358 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 7461 | 446 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 14636751 | 14636751 | PRJNA635874_P_NODE_51912_length_249_cov_0.875000_g51765_i0 | PRJNA635874 | 51912 | 249 | 0.875 | 2.17875 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 2.75e-41 | NTclustered | gi|829174585|ref|XM_001033134.3| | 312017 | g51765 | i0 | 85.227 | 0.706827309236948 | 176 | 26 | 71 | 0 | 73 | 248 | 2198 | 2023 | Tetrahymena thermophila SB210 26S proteasome regulatory complex, subunit RPN2 partial mRNA | blastn | 176 | 182 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 18460441 | 18460441 | PRJNA635874_P_NODE_74275_length_235_cov_3.030864_g74128_i0 | PRJNA635874 | 74275 | 235 | 3.030864 | 7.1225304 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 1.83e-102 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g74128 | i0 | 96.17 | 3.61702127659574 | 235 | 9 | 100 | 0 | 1 | 235 | 256 | 22 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 850 | 385 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19733972 | 19733972 | PRJNA635874_P_NODE_32936_length_291_cov_1.412844_g32789_i0 | PRJNA635874 | 32936 | 291 | 1.412844 | 4.11137604 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.8099999999999997e-120 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g32789 | i0 | 94.158 | 1 | 291 | 17 | 100 | 0 | 1 | 291 | 367 | 657 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 291 | 444 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 21010017 | 21010017 | PRJNA635874_P_NODE_44217_length_256_cov_1.683060_g44070_i0 | PRJNA635874 | 44217 | 256 | 1.68306 | 4.3086336 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.76e-25 | NTclustered | gi|829175027|ref|XM_001017808.4| | 312017 | g44070 | i0 | 87.611 | 0.44140625 | 113 | 11 | 44 | 3 | 132 | 243 | 155 | 45 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 113 | 128 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 21556591 | 21556591 | PRJNA635874_P_NODE_54517_length_248_cov_0.880000_g54370_i0 | PRJNA635874 | 54517 | 248 | 0.88 | 2.1824 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.82e-21 | NTclustered | gi|3366652|gb|AF031320.1|AF031320 | 5911 | g54370 | i0 | 75.397 | 2.03225806451613 | 252 | 54 | 100 | 7 | 1 | 248 | 1067 | 820 | Tetrahymena thermophila granule lattice protein 4 precursor (GRL4) mRNA, complete cds | blastn | 504 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 22284474 | 22284474 | PRJNA635874_P_NODE_36518_length_280_cov_0.864734_g36371_i0 | PRJNA635874 | 36518 | 280 | 0.864734 | 2.4212552 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 2.21e-112 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g36371 | i0 | 93.594 | 92.4 | 281 | 16 | 100 | 2 | 1 | 280 | 3184 | 3463 | 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 | 25872 | 418 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 23559403 | 23559403 | PRJNA635874_P_NODE_15419_length_389_cov_1.455696_g15272_i0 | PRJNA635874 | 15419 | 389 | 1.455696 | 5.66265744 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 597 | 3.8099999999999986e-166 | NTclustered | gi|5701724|dbj|AB024694.1| | 5908 | g15272 | i0 | 94.344 | 3.2133676092545 | 389 | 22 | 100 | 0 | 1 | 389 | 635 | 247 | Tetrahymena pyriformis mRNA for 14-3-3 protein, complete cds | blastn | 1250 | 597 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 23560396 | 23560396 | PRJNA635874_P_NODE_50259_length_250_cov_0.870056_g50112_i0 | PRJNA635874 | 50259 | 250 | 0.870056 | 2.17514 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.85e-21 | NTclustered | gi|829192014|ref|XM_012799966.1| | 312017 | g50112 | i0 | 88.421 | 1.68 | 95 | 11 | 38 | 0 | 48 | 142 | 125 | 219 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 420 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 23560644 | 23560644 | PRJNA635874_P_NODE_61699_length_245_cov_0.895349_g61552_i0 | PRJNA635874 | 61699 | 245 | 0.895349 | 2.19360505 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 2.47e-106 | NTclustered | gi|10765|emb|X05195.1| | 5908 | g61552 | i0 | 96.266 | 70.734693877551 | 241 | 9 | 98 | 0 | 1 | 241 | 843 | 1083 | Tetrahymena pyriformis actin gene | blastn | 17330 | 398 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis |
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);;