contig_metadata
11 rows where bioproject = "PRJNA1047551", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 174521 | 174521 | PRJNA1047551_S_NODE_12101_length_156_cov_6.173554_g11974_i0 | PRJNA1047551 | 12101 | 156 | 6.173554 | 9.63074424 | Tokophrya huangmeiensis | 1501436 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 3.31e-58 | NTclustered | gi|636571939|gb|KJ567607.1| | 1501436 | g11974 | i0 | 98.507 | 82.9102564102564 | 134 | 2 | 86 | 0 | 23 | 156 | 927 | 1060 | Tokophrya huangmeiensis small subunit ribosomal RNA gene, partial sequence | blastn | 12934 | 237 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Endogenida | Tokophryidae | Tokophrya | Tokophrya huangmeiensis | ||
| 2725016 | 2725016 | PRJNA1047551_S_NODE_12323_length_155_cov_4.083333_g12196_i0 | PRJNA1047551 | 12323 | 155 | 4.083333 | 6.32916615 | Pseudoblepharisma tenue | 2528046 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 2.57e-49 | NTclustered | gi|2362972807|gb|OP912402.1| | 2528046 | g12196 | i0 | 94.737 | 79.9354838709677 | 133 | 7 | 86 | 0 | 1 | 133 | 2264 | 2132 | Pseudoblepharisma tenue isolate MG01 internal transcribed spacer region, partial sequence | blastn | 12390 | 207 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Pseudoblepharisma | Pseudoblepharisma tenue | ||
| 4001194 | 4001194 | PRJNA1047551_S_NODE_7324_length_187_cov_21.072368_g7197_i0 | PRJNA1047551 | 7324 | 187 | 21.072368 | 39.40532816 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 8.98e-50 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g7197 | i0 | 87.027 | 71.144385026738 | 185 | 24 | 99 | 0 | 1 | 185 | 291 | 107 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 13304 | 209 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 5277408 | 5277408 | PRJNA1047551_S_NODE_3245_length_258_cov_6.591928_g3118_i0 | PRJNA1047551 | 3245 | 258 | 6.591928 | 17.00717424 | Kyaroikeus paracetarius | 2684852 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.79e-25 | NTclustered | gi|1784308422|gb|MN830170.1| | 2684852 | g3118 | i0 | 89.899 | 14.2519379844961 | 99 | 10 | 38 | 0 | 100 | 198 | 99 | 1 | Kyaroikeus paracetarius isolate LJ-I-20170502 large subunit ribosomal RNA gene, partial sequence | blastn | 3677 | 128 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Kyaroikeidae | Kyaroikeus | Kyaroikeus paracetarius | ||
| 12928179 | 12928179 | PRJNA1047551_S_NODE_10051_length_167_cov_5.060606_g9924_i0 | PRJNA1047551 | 10051 | 167 | 5.060606 | 8.45121202 | Planilamina ovata | 2684848 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 1.0299999999999999e-38 | NTclustered | gi|1784308423|gb|MN830171.1| | 2684848 | g9924 | i0 | 85.802 | 69.8802395209581 | 162 | 23 | 97 | 0 | 3 | 164 | 170 | 331 | Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence | blastn | 11670 | 172 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Kyaroikeidae | Planilamina | Planilamina ovata | ||
| 12928461 | 12928461 | PRJNA1047551_S_NODE_9131_length_173_cov_7.746377_g9004_i0 | PRJNA1047551 | 9131 | 173 | 7.746377 | 13.40123221 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.31e-35 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g9004 | i0 | 84.393 | 7.10982658959538 | 173 | 18 | 97 | 9 | 4 | 171 | 275 | 107 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 1230 | 161 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 15037504 | 15037504 | PRJNA1047551_S_NODE_2232_length_302_cov_35.037453_g2105_i0 | PRJNA1047551 | 2232 | 302 | 35.037453 | 105.81310806 | Epistylis | 155142 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 1.14e-100 | NTclustered | gi|759083557|gb|KM222174.1| | 1607876 | g2105 | i0 | 97.727 | 72.0562913907285 | 220 | 5 | 73 | 0 | 83 | 302 | 401 | 182 | Epistylis sp. FG-2015 voucher SZ2011052302 large subunit ribosomal RNA gene, partial sequence | blastn | 21761 | 379 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis sp. FG-2015 | ||
| 18026354 | 18026354 | PRJNA1047551_S_NODE_13775_length_150_cov_1.060870_g13648_i0 | PRJNA1047551 | 13775 | 150 | 1.06087 | 1.591305 | Lembadion sp. FG-2015 | 1607877 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.13e-57 | NTclustered | gi|759083556|gb|KM222173.1| | 1607877 | g13648 | i0 | 95.27 | 0.986666666666667 | 148 | 7 | 99 | 0 | 3 | 150 | 535 | 388 | Lembadion sp. FG-2015 voucher FYB2013031305 large subunit ribosomal RNA gene, partial sequence | blastn | 148 | 235 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Lembadionidae | Lembadion | Lembadion sp. FG-2015 | ||
| 21411865 | 21411865 | PRJNA1047551_S_NODE_3497_length_249_cov_18.247664_g3370_i0 | PRJNA1047551 | 3497 | 249 | 18.247664 | 45.43668336 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 3.46e-60 | NTclustered | gi|1246280602|gb|MF992249.1| | 35107 | g3370 | i0 | 86.087 | 92.3172690763052 | 230 | 29 | 92 | 3 | 22 | 249 | 90 | 318 | Uronema marinum isolate ZZF20170302 large subunit ribosomal RNA gene, partial sequence | blastn | 22987 | 244 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Uronematidae | Uronema | Uronema marinum | ||
| 21411885 | 21411885 | PRJNA1047551_S_NODE_9577_length_170_cov_24.525926_g9450_i0 | PRJNA1047551 | 9577 | 170 | 24.525926 | 41.6940742 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 2.19e-60 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g9450 | i0 | 94.41 | 91.3647058823529 | 161 | 5 | 94 | 3 | 9 | 167 | 2998 | 3156 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 15532 | 244 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 25236159 | 25236159 | PRJNA1047551_S_NODE_4400_length_226_cov_16.696335_g4273_i0 | PRJNA1047551 | 4400 | 226 | 16.696335 | 37.7337171 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 6.37e-92 | NTclustered | gi|6980030|gb|AF223571.1|AF223571 | 5940 | g4273 | i0 | 96.262 | 94.3053097345133 | 214 | 7 | 94 | 1 | 14 | 226 | 731 | 944 | Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 21313 | 350 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes aediculatus |
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);;