contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJEB12296" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23937991 | 23937991 | PRJEB12296_P_NODE_819_length_162_cov_1.180451_g806_i0 | PRJEB12296 | 819 | 162 | 1.180451 | 1.91233062 | Sterkiella | 94288 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.32e-17 | NTclustered | gi|331686195|gb|HQ432921.1| | 94289 | g806 | i0 | 90.789 | 1.30864197530864 | 76 | 7 | 47 | 0 | 65 | 140 | 1472 | 1397 | Sterkiella histriomuscorum strain BA elongation factor-1 (ef-1) gene, complete cds; macronuclear | blastn | 212 | 102 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 25500798 | 25500798 | PRJEB12296_S_NODE_5113_length_210_cov_2.040000_g5081_i0 | PRJEB12296 | 5113 | 210 | 2.04 | 4.284 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.25e-98 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5081 | i0 | 98.571 | 92.647619047619 | 210 | 3 | 100 | 0 | 1 | 210 | 2113 | 2322 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 19456 | 372 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 25606848 | 25606848 | PRJEB12296_S_NODE_2809_length_262_cov_4172.722467_g2777_i0 | PRJEB12296 | 2809 | 262 | 4172.722467 | 10932.53286354 | root | 1 | Root_unresolved | Root_unresolved | 322 | 1.65e-83 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g2777 | i0 | 94.737 | 77.8664122137405 | 209 | 8 | 79 | 3 | 1 | 206 | 8116 | 8324 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 20401 | 322 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 25743073 | 25743073 | PRJEB12296_S_NODE_18578_length_150_cov_1.391304_g18546_i0 | PRJEB12296 | 18578 | 150 | 1.391304 | 2.086956 | root | 1 | Root_unresolved | Root_unresolved | 272 | 8.609999999999998e-69 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g18546 | i0 | 99.333 | 8 | 150 | 1 | 100 | 0 | 1 | 150 | 4076 | 3927 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 1200 | 272 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 25878833 | 25878833 | PRJEB12296_S_NODE_347_length_505_cov_45.802128_g320_i0 | PRJEB12296 | 347 | 505 | 45.802128 | 231.3007464 | Sessilida | 1974272 | SAR_Eukaryotes | SAR_Eukaryotes | 778 | 0 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g320 | i0 | 97.174 | 82.6891089108911 | 460 | 13 | 91 | 0 | 1 | 460 | 460 | 1 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 41758 | 780 | 0.997435897435897 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 26015245 | 26015245 | PRJEB12296_S_NODE_9020_length_177_cov_9.394366_g8988_i0 | PRJEB12296 | 9020 | 177 | 9.394366 | 16.62802782 | Sessilida | 1974272 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 4.799999999999999e-82 | NTclustered | gi|1251948964|gb|KY675197.1| | 155147 | g8988 | i0 | 98.87 | 99.954802259887 | 177 | 2 | 100 | 0 | 1 | 177 | 1376 | 1200 | Epistylis chrysemydis large subunit ribosomal RNA gene, partial sequence | blastn | 17692 | 316 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis chrysemydis | ||
| 26045149 | 26045149 | PRJEB12296_S_NODE_7549_length_186_cov_1.324503_g7517_i0 | PRJEB12296 | 7549 | 186 | 1.324503 | 2.46357558 | Trithigmostoma cucullulus | 1346499 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 6.61e-81 | NTclustered | gi|759083539|gb|KM222156.1| | 1346499 | g7517 | i0 | 97.79 | 66.0967741935484 | 181 | 4 | 97 | 0 | 6 | 186 | 1366 | 1186 | Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence | blastn | 12294 | 313 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Trithigmostoma | Trithigmostoma cucullulus | ||
| 26181280 | 26181280 | PRJEB12296_S_NODE_630_length_419_cov_61.565104_g600_i0 | PRJEB12296 | 630 | 419 | 61.565104 | 257.95778576 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 2.56e-143 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g600 | i0 | 93.696 | 47.653937947494 | 349 | 20 | 83 | 2 | 41 | 388 | 15 | 362 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 19967 | 521 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 26423199 | 26423199 | PRJEB12296_S_NODE_7367_length_187_cov_6.980263_g7335_i0 | PRJEB12296 | 7367 | 187 | 6.980263 | 13.05309181 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 5.36e-52 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g7335 | i0 | 87.766 | 66.8021390374332 | 188 | 19 | 100 | 3 | 1 | 187 | 2381 | 2565 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 12492 | 217 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 26559195 | 26559195 | PRJEB12296_S_NODE_1928_length_298_cov_4248.292776_g1896_i0 | PRJEB12296 | 1928 | 298 | 4248.292776 | 12659.91247248 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.91e-120 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g1896 | i0 | 98.795 | 74.0234899328859 | 249 | 3 | 84 | 0 | 36 | 284 | 2719 | 2967 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 22059 | 444 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 26559235 | 26559235 | PRJEB12296_S_NODE_5240_length_208_cov_6.358382_g5208_i0 | PRJEB12296 | 5240 | 208 | 6.358382 | 13.22543456 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 7.409999999999998e-96 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5208 | i0 | 98.077 | 83.9855769230769 | 208 | 4 | 100 | 0 | 1 | 208 | 2367 | 2574 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 17469 | 363 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;