contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA681822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 655250 | 655250 | PRJNA681822_P_NODE_408121_length_249_cov_0.875000_g406632_i0 | PRJNA681822 | 408121 | 249 | 0.875 | 2.17875 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 7.659999999999998e-42 | NTclustered | gi|47176500|gb|AY618080.1| | 94289 | g406632 | i0 | 80.08 | 13.570281124498 | 251 | 46 | 100 | 4 | 1 | 249 | 297 | 545 | Sterkiella histriomuscorum clone UGC1O0003_N08_R genomic sequence | blastn | 3379 | 183 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 1930811 | 1930811 | PRJNA681822_P_NODE_360422_length_257_cov_2.021739_g358933_i0 | PRJNA681822 | 360422 | 257 | 2.021739 | 5.19586923 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 8.35e-7 | NTclustered | gi|116294932|gb|EF014343.1| | 5908 | g358933 | i0 | 83.562 | 0.284046692607004 | 73 | 11 | 28 | 1 | 144 | 215 | 146 | 74 | Tetrahymena pyriformis RNase P gene, complete sequence | blastn | 73 | 67.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 3202594 | 3202594 | PRJNA681822_P_NODE_130723_length_358_cov_1.080702_g129236_i0 | PRJNA681822 | 130723 | 358 | 1.080702 | 3.86891316 | Uronema marinum | 35107 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 5.29e-50 | NTclustered | gi|1464314795|ref|NC_039174.1| | 35107 | g129236 | i0 | 77.562 | 2.82960893854749 | 361 | 73 | 99 | 7 | 1 | 357 | 30477 | 30121 | Uronema marinum mitochondrion, complete genome | blastn | 1013 | 211 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Uronematidae | Uronema | Uronema marinum | ||
| 7032553 | 7032553 | PRJNA681822_P_NODE_289806_length_277_cov_1.132353_g288317_i0 | PRJNA681822 | 289806 | 277 | 1.132353 | 3.13661781 | Metopus es | 392813 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 7.899999999999999e-107 | NTclustered | gi|110645073|gb|DQ665935.1| | 392813 | g288317 | i0 | 92.754 | 99.7906137184115 | 276 | 20 | 99 | 0 | 2 | 277 | 344 | 619 | Metopus es clone 1 actin gene, partial cds; macronuclear | blastn | 27642 | 399 | 1 | Eukaryota | Sar | Ciliophora | Armophorea | Metopida | Metopidae | Metopus | Metopus es | ||
| 7032786 | 7032786 | PRJNA681822_P_NODE_309606_length_271_cov_3.671717_g308117_i0 | PRJNA681822 | 309606 | 271 | 3.671717 | 9.95035307 | Eufolliculina uhligi | 46026 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.46e-14 | NTclustered | gi|6469590|gb|AF122022.1|AF122022 | 46026 | g308117 | i0 | 77.64 | 2.35793357933579 | 161 | 30 | 58 | 4 | 114 | 271 | 650 | 493 | Eufolliculina uhligi clone EuT11 unknown mRNA | blastn | 639 | 93.5 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Folliculinidae | Eufolliculina | Eufolliculina uhligi | ||
| 8305283 | 8305283 | PRJNA681822_P_NODE_14307_length_1008_cov_17.710160_g13250_i0 | PRJNA681822 | 14307 | 1008 | 17.71016 | 178.5184128 | Tetrahymena paravorax | 5905 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.2e-70 | NTclustered | gi|114329857|ref|NC_008338.1| | 5905 | g13250 | i0 | 76.101 | 5.86607142857143 | 636 | 97 | 62 | 41 | 61 | 686 | 3228 | 2638 | Tetrahymena paravorax mitochondrion, complete genome | blastn | 5913 | 281 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena paravorax | ||
| 10098707 | 10098707 | PRJNA681822_P_NODE_171088_length_326_cov_1.877470_g169600_i0 | PRJNA681822 | 171088 | 326 | 1.87747 | 6.1205522 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 2.0999999999999997e-88 | NTclustered | gi|21215215|gb|AF510209.1| | 57513 | g169600 | i0 | 86.032 | 98.1319018404908 | 315 | 44 | 97 | 0 | 4 | 318 | 528 | 214 | Uroleptus gallina beta-tubulin gene, complete cds | blastn | 31991 | 339 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Urostylida | Urostylidae | Uroleptus | Uroleptus gallina | ||
| 12135498 | 12135498 | PRJNA681822_P_NODE_463290_length_243_cov_0.905882_g461800_i0 | PRJNA681822 | 463290 | 243 | 0.905882 | 2.20129326 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.48e-98 | NTclustered | gi|347439271|gb|JN111984.1| | 151077 | g461800 | i0 | 94.239 | 94.59670781893 | 243 | 14 | 100 | 0 | 1 | 243 | 432 | 190 | Chilodonella uncinata strain USA_SC2 clone SP1 beta tubulin (btub) gene, partial cds; macronuclear | blastn | 22987 | 372 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12136544 | 12136544 | PRJNA681822_P_NODE_7830_length_1357_cov_15.675234_g7026_i0 | PRJNA681822 | 7830 | 1357 | 15.675234 | 212.71292538 | Colpoda steini | 63136 | SAR_Eukaryotes | SAR_Eukaryotes | 1707 | 0 | NTclustered | gi|2166921685|gb|OL894853.1| | 63136 | g7026 | i0 | 96.878 | 56.2652910832719 | 1025 | 23 | 75 | 8 | 44 | 1066 | 1021 | 4 | Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 76352 | 1707 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda steini | ||
| 14682660 | 14682660 | PRJNA681822_P_NODE_255932_length_285_cov_1.410377_g254443_i0 | PRJNA681822 | 255932 | 285 | 1.410377 | 4.01957445 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.72e-120 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g254443 | i0 | 94.737 | 61.8 | 285 | 15 | 100 | 0 | 1 | 285 | 375 | 91 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 17613 | 444 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 16473085 | 16473085 | PRJNA681822_P_NODE_267973_length_282_cov_1.473684_g266484_i0 | PRJNA681822 | 267973 | 282 | 1.473684 | 4.15578888 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 1.7499999999999998e-103 | NTclustered | gi|2058296|emb|X94348.1| | 41631 | g266484 | i0 | 92.029 | 97.1099290780142 | 276 | 22 | 98 | 0 | 1 | 276 | 427 | 702 | Colpoda sp. gene encoding for alpha-tubulin, partial | blastn | 27385 | 388 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 16474152 | 16474152 | PRJNA681822_S_NODE_1093_length_200_cov_2.608187_g1068_i0 | PRJNA681822 | 1093 | 200 | 2.608187 | 5.216374 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 4.22e-98 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g1068 | i0 | 100 | 95.725 | 200 | 0 | 100 | 0 | 1 | 200 | 619 | 818 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 19145 | 370 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 18508560 | 18508560 | PRJNA681822_P_NODE_50615_length_524_cov_1.514412_g49156_i0 | PRJNA681822 | 50615 | 524 | 1.514412 | 7.93551888 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 918 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g49156 | i0 | 98.282 | 80.8015267175573 | 524 | 9 | 100 | 0 | 1 | 524 | 2007 | 1484 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 42340 | 918 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 19781885 | 19781885 | PRJNA681822_P_NODE_377076_length_252_cov_1.720670_g375587_i0 | PRJNA681822 | 377076 | 252 | 1.72067 | 4.3360884 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 3.41e-80 | NTclustered | gi|9837417|gb|AF287229.1| | 5908 | g375587 | i0 | 89.243 | 96.6904761904762 | 251 | 24 | 99 | 3 | 4 | 252 | 1106 | 857 | Tetrahymena pyriformis heat shock protein 90 (HSP81) gene, partial cds | blastn | 24366 | 311 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 20297727 | 20297727 | PRJNA681822_S_NODE_1916_length_156_cov_2.771654_g1891_i0 | PRJNA681822 | 1916 | 156 | 2.771654 | 4.32378024 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 1.95e-70 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g1891 | i0 | 98.718 | 99.8012820512821 | 156 | 2 | 100 | 0 | 1 | 156 | 1395 | 1240 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 15569 | 278 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 24123264 | 24123264 | PRJNA681822_P_NODE_8819_length_1278_cov_9.325311_g7960_i0 | PRJNA681822 | 8819 | 1278 | 9.325311 | 119.17747458 | Pseudocohnilembidae | 35102 | SAR_Eukaryotes | SAR_Eukaryotes | 747 | 0 | NTclustered | gi|2431531581|ref|NC_070360.1| | 153251 | g7960 | i0 | 80.502 | 61.8701095461659 | 1036 | 150 | 80 | 33 | 249 | 1272 | 5371 | 6366 | Cryptocaryon irritans mitochondrion, complete genome | blastn | 79070 | 752 | 0.993351063829787 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans |
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);;