contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJEB50332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119380 | 119380 | PRJEB50332_P_NODE_11021_length_218_cov_3.095541_g10939_i0 | PRJEB50332 | 11021 | 218 | 3.095541 | 6.74827938 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 2.32e-51 | NTclustered | gi|149394723|gb|EF125705.1| | 151077 | g10939 | i0 | 84.651 | 0.986238532110092 | 215 | 33 | 99 | 0 | 1 | 215 | 182 | 396 | Chilodonella uncinata strain ATCC 50194 caltractin-like protein-like gene, complete sequence; macronuclear | blastn | 215 | 215 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 119445 | 119445 | PRJEB50332_P_NODE_1641_length_435_cov_5.056150_g1560_i0 | PRJEB50332 | 1641 | 435 | 5.05615 | 21.9942525 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 782 | 0 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g1560 | i0 | 99.083 | 52.3011494252874 | 436 | 3 | 100 | 1 | 1 | 435 | 15 | 450 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 22751 | 782 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 1393805 | 1393805 | PRJEB50332_P_NODE_1502_length_451_cov_7.317949_g1421_i0 | PRJEB50332 | 1502 | 451 | 7.317949 | 33.00394999 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 750 | 0 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g1421 | i0 | 96.674 | 54.0820399113082 | 451 | 15 | 100 | 0 | 1 | 451 | 471 | 21 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 24391 | 750 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 3945508 | 3945508 | PRJEB50332_P_NODE_1684_length_430_cov_1.728997_g1603_i0 | PRJEB50332 | 1684 | 430 | 1.728997 | 7.4346871 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 573 | 7.159999999999998e-159 | NTclustered | gi|149394715|gb|EF125697.1| | 151077 | g1603 | i0 | 91.211 | 4.58837209302326 | 421 | 37 | 98 | 0 | 1 | 421 | 372 | 792 | Chilodonella uncinata strain ATCC 50194 serine/threonine protein phosphatase-like gene, complete sequence; macronuclear | blastn | 1973 | 573 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 3945539 | 3945539 | PRJEB50332_P_NODE_2464_length_361_cov_2.470000_g2382_i0 | PRJEB50332 | 2464 | 361 | 2.47 | 8.9167 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 503 | 7.859999999999998e-138 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g2382 | i0 | 91.758 | 22.4404432132964 | 364 | 27 | 100 | 2 | 1 | 361 | 391 | 754 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 8101 | 503 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 3945576 | 3945576 | PRJEB50332_P_NODE_624_length_686_cov_4.438400_g553_i0 | PRJEB50332 | 624 | 686 | 4.4384 | 30.447424 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1118 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g553 | i0 | 96.064 | 44.6253644314869 | 686 | 27 | 100 | 0 | 1 | 686 | 698 | 13 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 30613 | 1118 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 5221904 | 5221904 | PRJEB50332_P_NODE_6205_length_250_cov_4.624339_g6123_i0 | PRJEB50332 | 6205 | 250 | 4.624339 | 11.5608475 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.85e-21 | NTclustered | gi|829192014|ref|XM_012799966.1| | 312017 | g6123 | i0 | 88.421 | 1.68 | 95 | 11 | 38 | 0 | 109 | 203 | 219 | 125 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 420 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 7368789 | 7368789 | PRJEB50332_P_NODE_1586_length_441_cov_4.155263_g1505_i0 | PRJEB50332 | 1586 | 441 | 4.155263 | 18.32470983 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 787 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1505 | i0 | 98.866 | 97.3605442176871 | 441 | 5 | 100 | 0 | 1 | 441 | 2801 | 2361 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 42936 | 787 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 7771858 | 7771858 | PRJEB50332_P_NODE_18627_length_172_cov_8.639640_g18545_i0 | PRJEB50332 | 18627 | 172 | 8.63964 | 14.8601808 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.79e-79 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g18545 | i0 | 98.837 | 66.1046511627907 | 172 | 2 | 100 | 0 | 1 | 172 | 842 | 671 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 11370 | 307 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 9046605 | 9046605 | PRJEB50332_P_NODE_1228_length_492_cov_1.651972_g1147_i0 | PRJEB50332 | 1228 | 492 | 1.651972 | 8.12770224 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 4.02e-127 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g1147 | i0 | 92.378 | 23.5243902439024 | 328 | 25 | 67 | 0 | 3 | 330 | 1330 | 1657 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 11574 | 468 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9046615 | 9046615 | PRJEB50332_P_NODE_128_length_1341_cov_8.072656_g96_i0 | PRJEB50332 | 128 | 1341 | 8.072656 | 108.25431696 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1995 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g96 | i0 | 96.385 | 26.4153616703952 | 1217 | 32 | 91 | 1 | 44 | 1260 | 1 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 35423 | 1995 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12873028 | 12873028 | PRJEB50332_P_NODE_891_length_570_cov_2.738703_g813_i0 | PRJEB50332 | 891 | 570 | 2.738703 | 15.6106071 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 952 | 0 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g813 | i0 | 96.837 | 11 | 569 | 18 | 99 | 0 | 1 | 569 | 166 | 734 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 6270 | 952 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15019092 | 15019092 | PRJEB50332_P_NODE_1772_length_420_cov_4.058496_g1691_i0 | PRJEB50332 | 1772 | 420 | 4.058496 | 17.0456832 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 7.709999999999999e-89 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1691 | i0 | 97.959 | 51.9833333333333 | 196 | 4 | 47 | 0 | 225 | 420 | 3082 | 2887 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 21833 | 340 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 15421733 | 15421733 | PRJEB50332_P_NODE_1193_length_497_cov_8.901376_g1112_i0 | PRJEB50332 | 1193 | 497 | 8.901376 | 44.23983872 | Diplodinium dentatum | 47889 | SAR_Eukaryotes | SAR_Eukaryotes | 904 | 0 | NTclustered | gi|2643596930|gb|PP067602.1| | 47889 | g1112 | i0 | 99.596 | 90.8792756539235 | 495 | 2 | 99 | 0 | 3 | 497 | 3656 | 3162 | Diplodinium dentatum isolate 02.GT15 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 | 45167 | 904 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Diplodinium | Diplodinium dentatum | ||
| 17569144 | 17569144 | PRJEB50332_P_NODE_534_length_738_cov_9.884786_g464_i0 | PRJEB50332 | 534 | 738 | 9.884786 | 72.94972068 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 1103 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g464 | i0 | 96.682 | 55.2140921409214 | 663 | 22 | 90 | 0 | 1 | 663 | 663 | 1 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 40748 | 1103 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17971022 | 17971022 | PRJEB50332_P_NODE_18475_length_190_cov_7.961240_g18393_i0 | PRJEB50332 | 18475 | 190 | 7.96124 | 15.126356 | Ophryoscolex caudatus | 358021 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 5.169999999999999e-92 | NTclustered | gi|2643596957|gb|PP067629.1| | 358021 | g18393 | i0 | 100 | 99.1526315789474 | 189 | 0 | 99 | 0 | 2 | 190 | 2595 | 2783 | Ophryoscolex caudatus isolate 03.MDA15 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 | 18839 | 350 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Ophryoscolex | Ophryoscolex caudatus | ||
| 17971024 | 17971024 | PRJEB50332_P_NODE_18635_length_170_cov_6.082569_g18553_i0 | PRJEB50332 | 18635 | 170 | 6.082569 | 10.3403673 | Dasytricha ruminantium | 40806 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 5.95e-76 | NTclustered | gi|2643596925|gb|PP067597.1| | 40806 | g18553 | i0 | 98.235 | 99 | 170 | 2 | 99 | 1 | 1 | 169 | 2157 | 1988 | Dasytricha ruminantium isolate 07.MDA23 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 | 16830 | 296 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Dasytricha | Dasytricha ruminantium | ||
| 19245106 | 19245106 | PRJEB50332_P_NODE_9076_length_229_cov_5.958333_g8994_i0 | PRJEB50332 | 9076 | 229 | 5.958333 | 13.64458257 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 1.7499999999999995e-112 | NTclustered | gi|1202135013|gb|KY476314.1| | 151077 | g8994 | i0 | 99.563 | 97.1921397379913 | 229 | 1 | 100 | 0 | 1 | 229 | 14 | 242 | Chilodonella uncinata 18S ribosomal RNA gene, partial sequence | blastn | 22257 | 418 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 20117774 | 20117774 | PRJEB50332_P_NODE_1956_length_400_cov_4.548673_g1875_i0 | PRJEB50332 | 1956 | 400 | 4.548673 | 18.194692 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 734 | 0 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g1875 | i0 | 99.75 | 99.995 | 400 | 1 | 100 | 0 | 1 | 400 | 1141 | 1540 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 39998 | 734 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23071393 | 23071393 | PRJEB50332_P_NODE_11399_length_217_cov_1.250000_g11317_i0 | PRJEB50332 | 11399 | 217 | 1.25 | 2.7125 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 3.68e-84 | NTclustered | gi|662862630|gb|KJ000270.1| | 151077 | g11317 | i0 | 93.548 | 7.10599078341014 | 217 | 14 | 100 | 0 | 1 | 217 | 338 | 554 | Chilodonella uncinata strain ATCC PRA-256 clone P7 protein kinase domain containing protein gene, partial cds; macronuclear | blastn | 1542 | 324 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24345296 | 24345296 | PRJEB50332_P_NODE_17680_length_202_cov_0.921986_g17598_i0 | PRJEB50332 | 17680 | 202 | 0.921986 | 1.86241172 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.55e-92 | NTclustered | gi|1710560089|gb|MN207909.1| | 1640447 | g17598 | i0 | 98.02 | 2.64851485148515 | 202 | 4 | 100 | 0 | 1 | 202 | 375 | 174 | Tetmemena sp. Y1 catalase gene, partial cds; macronuclear | blastn | 535 | 351 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 |
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);;