contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA695273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1182583 | 1182583 | PRJNA695273_P_NODE_26681_length_532_cov_5.117647_g25927_i0 | PRJNA695273 | 26681 | 532 | 5.117647 | 27.22588204 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 2.7699999999999998e-89 | NTclustered | gi|822093018|gb|KP313331.1| | 5911 | g25927 | i0 | 79.832 | 58.281954887218 | 476 | 90 | 89 | 6 | 59 | 531 | 569 | 97 | Tetrahymena thermophila isolate 19224-1 translation elongation factor 1 subunit alpha (TEF1a) gene, partial cds; macronuclear | blastn | 31006 | 342 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 4504924 | 4504924 | PRJNA695273_P_NODE_129404_length_250_cov_0.870056_g128646_i0 | PRJNA695273 | 129404 | 250 | 0.870056 | 2.17514 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 9.02e-111 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g128646 | i0 | 96.4 | 27.784 | 250 | 9 | 100 | 0 | 1 | 250 | 609 | 360 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 6946 | 412 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 4505372 | 4505372 | PRJNA695273_P_NODE_148144_length_244_cov_1.801170_g147386_i0 | PRJNA695273 | 148144 | 244 | 1.80117 | 4.3948548 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 2.419999999999999e-116 | NTclustered | gi|759083473|gb|KM222090.1| | 1607889 | g147386 | i0 | 99.576 | 91.1926229508197 | 236 | 1 | 97 | 0 | 1 | 236 | 261 | 496 | Opisthonecta sp. FG-2015 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 | 22251 | 431 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 8332524 | 8332524 | PRJNA695273_P_NODE_9727_length_954_cov_6.875142_g9073_i0 | PRJNA695273 | 9727 | 954 | 6.875142 | 65.58885468 | Tetrahymena paravorax | 5905 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.13e-70 | NTclustered | gi|114329857|ref|NC_008338.1| | 5905 | g9073 | i0 | 76.101 | 5.94129979035639 | 636 | 97 | 66 | 41 | 4 | 629 | 3228 | 2638 | Tetrahymena paravorax mitochondrion, complete genome | blastn | 5668 | 281 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena paravorax | ||
| 8835964 | 8835964 | PRJNA695273_P_NODE_5747_length_1280_cov_3.369511_g5220_i0 | PRJNA695273 | 5747 | 1280 | 3.369511 | 43.1297408 | Pseudocohnilembidae | 35102 | SAR_Eukaryotes | SAR_Eukaryotes | 754 | 0 | NTclustered | gi|2431531581|ref|NC_070360.1| | 153251 | g5220 | i0 | 80.224 | 61.8453125 | 1072 | 156 | 83 | 36 | 11 | 1069 | 6399 | 5371 | Cryptocaryon irritans mitochondrion, complete genome | blastn | 79162 | 754 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 8836308 | 8836308 | PRJNA695273_P_NODE_79127_length_310_cov_8.818565_g78369_i0 | PRJNA695273 | 79127 | 310 | 8.818565 | 27.3375515 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 5.8e-54 | NTclustered | gi|1802599794|gb|MT001203.1| | 41631 | g78369 | i0 | 100 | 83.5354838709677 | 121 | 0 | 82 | 0 | 190 | 310 | 1543 | 1423 | Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence | blastn | 25896 | 224 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 10882399 | 10882399 | PRJNA695273_P_NODE_5209_length_1351_cov_5.304382_g4707_i0 | PRJNA695273 | 5209 | 1351 | 5.304382 | 71.66220082 | Colpoda steini | 63136 | SAR_Eukaryotes | SAR_Eukaryotes | 1707 | 0 | NTclustered | gi|2166921685|gb|OL894853.1| | 63136 | g4707 | i0 | 96.878 | 56.5107327905255 | 1025 | 23 | 76 | 8 | 292 | 1314 | 4 | 1021 | Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 76346 | 1707 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda steini | ||
| 15211642 | 15211642 | PRJNA695273_P_NODE_57732_length_359_cov_5.695804_g56974_i0 | PRJNA695273 | 57732 | 359 | 5.695804 | 20.44793636 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 6.570000000000001e-79 | NTclustered | gi|2209090|gb|AF003089.1|AF003089 | 5919 | g56974 | i0 | 83.041 | 187.757660167131 | 342 | 54 | 95 | 4 | 1 | 340 | 448 | 109 | Tetrahymena vorax ubiquitin mRNA, complete cds | blastn | 67405 | 307 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena vorax | ||
| 16485052 | 16485052 | PRJNA695273_P_NODE_144593_length_245_cov_4.017442_g143835_i0 | PRJNA695273 | 144593 | 245 | 4.017442 | 9.8427329 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.1199999999999994e-119 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g143835 | i0 | 99.184 | 99.7510204081633 | 245 | 2 | 100 | 0 | 1 | 245 | 2691 | 2935 | 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 | 24439 | 442 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 18529074 | 18529074 | PRJNA695273_P_NODE_143595_length_246_cov_0.890173_g142837_i0 | PRJNA695273 | 143595 | 246 | 0.890173 | 2.18982558 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 7.19e-77 | NTclustered | gi|21215210|gb|AF510207.1| | 94289 | g142837 | i0 | 88.618 | 99.6056910569106 | 246 | 28 | 100 | 0 | 1 | 246 | 1326 | 1081 | Sterkiella histriomuscorum beta-tubulin gene, complete cds | blastn | 24503 | 300 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 23630022 | 23630022 | PRJNA695273_P_NODE_146659_length_245_cov_0.895349_g145901_i0 | PRJNA695273 | 146659 | 245 | 0.895349 | 2.19360505 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 7.62e-32 | NTclustered | gi|17432159|emb|AJ251471.1| | 5908 | g145901 | i0 | 85.034 | 0.840816326530612 | 147 | 22 | 60 | 0 | 3 | 149 | 16 | 162 | Tetrahymena pyriformis partial vppa gene for putative proton-translocating inorganic pyrophosphatase, isoform II | blastn | 206 | 150 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 25408524 | 25408524 | PRJNA695273_P_NODE_131620_length_249_cov_1.312500_g130862_i0 | PRJNA695273 | 131620 | 249 | 1.3125 | 3.268125 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.1699999999999999e-104 | NTclustered | gi|358350430|dbj|AB684403.1| | 63136 | g130862 | i0 | 96.667 | 68.3895582329317 | 240 | 1 | 95 | 4 | 14 | 249 | 264 | 28 | Colpoda steinii genes for ITS1, 5.8S rRNA, ITS2, partial and complete sequence | blastn | 17029 | 394 | 0.99492385786802 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda steini |
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);;