contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4519897 | 4519897 | PRJNA704949_P_NODE_1704364_length_184_cov_6.096296_g1689025_i0 | PRJNA704949 | 1704364 | 184 | 6.096296 | 11.21718464 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 1.89e-51 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g1689025 | i0 | 89.412 | 75.1086956521739 | 170 | 18 | 92 | 0 | 1 | 170 | 296 | 127 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 13820 | 215 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 12171899 | 12171899 | PRJNA704949_P_NODE_1822530_length_176_cov_1.228346_g1807191_i0 | PRJNA704949 | 1822530 | 176 | 1.228346 | 2.16188896 | Colpoda inflata | 5980 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 1.7199999999999996e-81 | NTclustered | gi|759083543|gb|KM222160.1| | 5980 | g1807191 | i0 | 98.864 | 99.8011363636364 | 176 | 2 | 100 | 0 | 1 | 176 | 16 | 191 | Colpoda inflata voucher SXK2011071402 large subunit ribosomal RNA gene, partial sequence | blastn | 17565 | 315 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 14717678 | 14717678 | PRJNA704949_P_NODE_1338052_length_216_cov_2.491018_g1322714_i0 | PRJNA704949 | 1338052 | 216 | 2.491018 | 5.38059888 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.1e-4 | NTclustered | gi|471221088|ref|XM_004027441.1| | 5932 | g1322714 | i0 | 92.5 | 0.564814814814815 | 40 | 3 | 19 | 0 | 176 | 215 | 1 | 40 | Ichthyophthirius multifiliis hypothetical protein (IMG5_182290) mRNA, complete cds | blastn | 122 | 58.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 18551226 | 18551226 | PRJNA704949_P_NODE_635935_length_339_cov_3.810345_g620610_i0 | PRJNA704949 | 635935 | 339 | 3.810345 | 12.91706955 | Lembadion sp. FG-2015 | 1607877 | SAR_Eukaryotes | SAR_Eukaryotes | 592 | 1.5299999999999996e-164 | NTclustered | gi|759083556|gb|KM222173.1| | 1607877 | g620610 | i0 | 99.088 | 99.2979351032448 | 329 | 3 | 97 | 0 | 11 | 339 | 1 | 329 | Lembadion sp. FG-2015 voucher FYB2013031305 large subunit ribosomal RNA gene, partial sequence | blastn | 33662 | 592 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Lembadionidae | Lembadion | Lembadion sp. FG-2015 | ||
| 18551309 | 18551309 | PRJNA704949_P_NODE_645455_length_337_cov_1.402778_g630129_i0 | PRJNA704949 | 645455 | 337 | 1.402778 | 4.72736186 | Tetrahymena chironomi | 3034767 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 2.6499999999999995e-132 | NTclustered | gi|2459327221|gb|OQ626840.1| | 3034767 | g630129 | i0 | 94.322 | 91.8842729970326 | 317 | 17 | 94 | 1 | 1 | 316 | 815 | 499 | Tetrahymena chironomi isolate LLH20220320 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 | 30965 | 484 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena chironomi | ||
| 22369027 | 22369027 | PRJNA704949_P_NODE_1717638_length_183_cov_4.104478_g1702299_i0 | PRJNA704949 | 1717638 | 183 | 4.104478 | 7.51119474 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 5.009999999999999e-82 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g1702299 | i0 | 97.814 | 95.8251366120219 | 183 | 4 | 100 | 0 | 1 | 183 | 141 | 323 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 17536 | 316 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 23644704 | 23644704 | PRJNA704949_P_NODE_1704659_length_184_cov_3.318519_g1689320_i0 | PRJNA704949 | 1704659 | 184 | 3.318519 | 6.10607496 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 2.34e-80 | NTclustered | gi|90657149|gb|DQ442807.1| | 35100 | g1689320 | i0 | 97.283 | 98.9130434782609 | 184 | 3 | 99 | 2 | 1 | 183 | 356 | 174 | Cyclidium glaucoma isolate ES31 28S ribosomal RNA gene, partial sequence | blastn | 18200 | 311 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 24141283 | 24141283 | PRJNA704949_P_NODE_511939_length_380_cov_9.371601_g496669_i0 | PRJNA704949 | 511939 | 380 | 9.371601 | 35.6120838 | Kyaroikeidae | 2684845 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 8.99e-83 | NTclustered | gi|1784308423|gb|MN830171.1| | 2684848 | g496669 | i0 | 85.621 | 75.4552631578947 | 306 | 42 | 80 | 2 | 1 | 305 | 324 | 20 | Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence | blastn | 28673 | 322 | 0.993788819875776 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Kyaroikeidae | Planilamina | Planilamina ovata | ||
| 24919974 | 24919974 | PRJNA704949_P_NODE_1947540_length_168_cov_3.941176_g1932201_i0 | PRJNA704949 | 1947540 | 168 | 3.941176 | 6.62117568 | uncultured haptorid ciliate | 282486 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 2.99e-14 | NTclustered | gi|2006881212|emb|HG996168.1| | 282486 | g1932201 | i0 | 78.431 | 5.65476190476191 | 153 | 23 | 88 | 9 | 1 | 148 | 680 | 533 | uncultured haptorid ciliate genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone bf5d1542 | blastn | 950 | 91.6 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | uncultured haptorid ciliate | ||||
| 25413955 | 25413955 | PRJNA704949_P_NODE_1771240_length_179_cov_3.838462_g1755901_i0 | PRJNA704949 | 1771240 | 179 | 3.838462 | 6.87084698 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.9300000000000005e-79 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g1755901 | i0 | 99.408 | 85.2011173184357 | 169 | 1 | 94 | 0 | 10 | 178 | 2977 | 3145 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 15251 | 307 | 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);;