contig_metadata
21 rows where bioproject = "PRJNA983848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2244647 | 2244647 | PRJNA983848_P_NODE_45002_length_538_cov_3.449462_g39136_i0 | PRJNA983848 | 45002 | 538 | 3.449462 | 18.55810556 | root | 1 | Root_unresolved | Root_unresolved | 317 | 9.339999999999998e-107 | NR | CAD8081379.1 | 5886 | g39136 | i0 | 94.2 | 44.7379182156134 | 156 | 9 | 87 | 0 | 70 | 537 | 1 | 156 | CAD8081379.1 unnamed protein product [Paramecium primaurelia] | diamond | 24069 | 317 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 4796372 | 4796372 | PRJNA983848_P_NODE_166424_length_224_cov_17.761589_g160541_i0 | PRJNA983848 | 166424 | 224 | 17.761589 | 39.78595936 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.52e-16 | NTclustered | gi|1004125725|gb|KU761582.1| | 153251 | g160541 | i0 | 83.178 | 0.955357142857143 | 107 | 18 | 48 | 0 | 115 | 221 | 56 | 162 | Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence | blastn | 214 | 99 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 4799372 | 4799372 | PRJNA983848_P_NODE_99464_length_303_cov_216.400000_g93581_i0 | PRJNA983848 | 99464 | 303 | 216.4 | 655.692 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.84e-123 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g93581 | i0 | 93.75 | 35.2112211221122 | 304 | 17 | 100 | 2 | 1 | 303 | 61 | 363 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 10669 | 455 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 6070317 | 6070317 | PRJNA983848_P_NODE_126365_length_265_cov_3.890625_g120482_i0 | PRJNA983848 | 126365 | 265 | 3.890625 | 10.31015625 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 3.44e-115 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g120482 | i0 | 95.833 | 6.1622641509434 | 264 | 11 | 99 | 0 | 2 | 265 | 325 | 62 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1633 | 427 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 7343937 | 7343937 | PRJNA983848_P_NODE_101206_length_300_cov_320.515419_g95323_i0 | PRJNA983848 | 101206 | 300 | 320.515419 | 961.546257 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 8.41e-127 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g95323 | i0 | 94.667 | 23.01 | 300 | 16 | 100 | 0 | 1 | 300 | 686 | 387 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 6903 | 466 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 9896613 | 9896613 | PRJNA983848_P_NODE_167408_length_205_cov_4.151515_g161525_i0 | PRJNA983848 | 167408 | 205 | 4.151515 | 8.51060575 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.3599999999999997e-99 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g161525 | i0 | 99.512 | 10.3707317073171 | 205 | 1 | 100 | 0 | 1 | 205 | 3066 | 3270 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 2126 | 374 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 9897048 | 9897048 | PRJNA983848_P_NODE_30048_length_806_cov_120.245566_g24511_i0 | PRJNA983848 | 30048 | 806 | 120.245566 | 969.17926196 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 1375 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g24511 | i0 | 97.631 | 54.4032258064516 | 802 | 17 | 99 | 2 | 2 | 802 | 2297 | 1497 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 43849 | 1375 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 9899364 | 9899364 | PRJNA983848_P_NODE_91428_length_319_cov_1.743902_g85545_i0 | PRJNA983848 | 91428 | 319 | 1.743902 | 5.56304738 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 4.38e-95 | NTclustered | gi|347439269|gb|JN111982.1| | 151077 | g85545 | i0 | 87.188 | 13.4043887147335 | 320 | 37 | 100 | 3 | 1 | 319 | 348 | 32 | Chilodonella uncinata strain USA_WH small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 4276 | 361 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12750807 | 12750807 | PRJNA983848_P_NODE_59350_length_425_cov_206.747159_g53469_i0 | PRJNA983848 | 59350 | 425 | 206.747159 | 878.67542575 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 1.75e-60 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g53469 | i0 | 97.887 | 1.70823529411765 | 142 | 3 | 33 | 0 | 37 | 178 | 2941 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 726 | 246 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 13720816 | 13720816 | PRJNA983848_P_NODE_130291_length_261_cov_1.654255_g124408_i0 | PRJNA983848 | 130291 | 261 | 1.654255 | 4.31760555 | Ancistrum crassum | 880990 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 4.57e-84 | NTclustered | gi|514076835|gb|KF256825.1| | 880990 | g124408 | i0 | 89.655 | 9.96168582375479 | 261 | 18 | 99 | 8 | 3 | 261 | 1775 | 1522 | Ancistrum crassum isolate FXP2009031601 large subunit ribosomal RNA gene, partial sequence | blastn | 2600 | 324 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Thigmotrichida | Ancistridae | Ancistrum | Ancistrum crassum | ||
| 22646913 | 22646913 | PRJNA983848_P_NODE_54718_length_454_cov_110.753281_g48839_i0 | PRJNA983848 | 54718 | 454 | 110.753281 | 502.81989574 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 749 | 0 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g48839 | i0 | 97.494 | 88.3193832599119 | 439 | 10 | 97 | 1 | 16 | 454 | 3237 | 3674 | 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 | 40097 | 749 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 22949214 | 22949214 | PRJNA983848_P_NODE_103018_length_297_cov_9.424107_g97135_i0 | PRJNA983848 | 103018 | 297 | 9.424107 | 27.98959779 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 549 | 8.029999999999997e-152 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g97135 | i0 | 100 | 99.6430976430976 | 297 | 0 | 100 | 0 | 1 | 297 | 326 | 30 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 29594 | 549 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 23920341 | 23920341 | PRJNA983848_P_NODE_146319_length_248_cov_4.228571_g140436_i0 | PRJNA983848 | 146319 | 248 | 4.228571 | 10.48685608 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 2.4499999999999996e-121 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g140436 | i0 | 99.194 | 100.979838709677 | 248 | 2 | 100 | 0 | 1 | 248 | 1610 | 1857 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 25043 | 448 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 25193876 | 25193876 | PRJNA983848_P_NODE_144400_length_249_cov_4.181818_g138517_i0 | PRJNA983848 | 144400 | 249 | 4.181818 | 10.41272682 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 6.840000000000001e-122 | NTclustered | gi|90657156|gb|DQ442814.1| | 35100 | g138517 | i0 | 99.197 | 12.3373493975904 | 249 | 2 | 100 | 0 | 1 | 249 | 425 | 673 | Cyclidium glaucoma isolate ES39 28S ribosomal RNA gene, partial sequence | blastn | 3072 | 449 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 25194263 | 25194263 | PRJNA983848_P_NODE_156140_length_244_cov_0.912281_g150257_i0 | PRJNA983848 | 156140 | 244 | 0.912281 | 2.22596564 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 8.729999999999998e-31 | NR | KRX08195.1 | 266149 | g150257 | i0 | 70.4 | 2.98770491803279 | 81 | 24 | 99.6 | 0 | 1 | 243 | 289 | 369 | KRX08195.1 hypothetical protein PPERSA_12350 [Pseudocohnilembus persalinus] | diamond | 729 | 124 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 25196626 | 25196626 | PRJNA983848_P_NODE_71880_length_371_cov_2.493289_g65997_i0 | PRJNA983848 | 71880 | 371 | 2.493289 | 9.25010219 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 649 | 0 | NTclustered | gi|821392666|gb|KR005626.1| | 1654720 | g65997 | i0 | 100 | 50.1428571428571 | 351 | 0 | 95 | 0 | 1 | 351 | 107 | 457 | Chilodonella piscicola 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; macronuclear | blastn | 18603 | 649 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 25497935 | 25497935 | PRJNA983848_P_NODE_124800_length_267_cov_2.551546_g118917_i0 | PRJNA983848 | 124800 | 267 | 2.551546 | 6.81262782 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.81e-33 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g118917 | i0 | 85.526 | 2.53558052434457 | 152 | 19 | 56 | 3 | 91 | 240 | 101 | 251 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 677 | 156 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 26868345 | 26868345 | PRJNA983848_P_NODE_41501_length_581_cov_1.694882_g35658_i0 | PRJNA983848 | 41501 | 581 | 1.694882 | 9.84726442 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 3.1e-5 | NR | CDW86772.1 | 5949 | g35658 | i0 | 44.6 | 0.428571428571429 | 83 | 37 | 41.3 | 3 | 7 | 246 | 63 | 139 | CDW86772.1 UNKNOWN [Stylonychia lemnae] | diamond | 249 | 53.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27279311 | 27279311 | PRJNA983848_P_NODE_85223_length_333_cov_1.734615_g79340_i0 | PRJNA983848 | 85223 | 333 | 1.734615 | 5.77626795 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 1.25e-17 | NR | CAG9311321.1 | 1481888 | g79340 | i0 | 41.7 | 2.73873873873874 | 103 | 57 | 92.8 | 2 | 323 | 15 | 322 | 421 | CAG9311321.1 unnamed protein product [Blepharisma stoltei] | diamond | 912 | 88.2 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30152489 | 30152489 | PRJNA983848_P_NODE_143712_length_250_cov_0.881356_g137829_i0 | PRJNA983848 | 143712 | 250 | 0.881356 | 2.20339 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.53e-10 | NR | CAG9333366.1 | 1481888 | g137829 | i0 | 38.6 | 3.984 | 83 | 51 | 99.6 | 0 | 250 | 2 | 370 | 452 | CAG9333366.1 unnamed protein product [Blepharisma stoltei] | diamond | 996 | 66.6 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 32839030 | 32839030 | PRJNA983848_P_NODE_121980_length_271_cov_1.373737_g116097_i0 | PRJNA983848 | 121980 | 271 | 1.373737 | 3.72282727 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 1.81e-33 | NR | CAG9318382.1 | 1481888 | g116097 | i0 | 74.6 | 0.785977859778598 | 71 | 18 | 78.6 | 0 | 264 | 52 | 64 | 134 | CAG9318382.1 unnamed protein product [Blepharisma stoltei] | diamond | 213 | 123 | 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);;