contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1088594 | 1088594 | PRJNA432257_S_NODE_121541_length_155_cov_3.042373_g121160_i0 | PRJNA432257 | 121541 | 155 | 3.042373 | 4.71567815 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 3.23e-68 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g121160 | i0 | 98.065 | 90.0322580645161 | 155 | 3 | 100 | 0 | 1 | 155 | 2903 | 2749 | 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 | 13955 | 270 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 4256929 | 4256929 | PRJNA432257_S_NODE_63464_length_211_cov_22.988506_g63083_i0 | PRJNA432257 | 63464 | 211 | 22.988506 | 48.50574766 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.71e-57 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g63083 | i0 | 90.857 | 83.1279620853081 | 175 | 16 | 83 | 0 | 37 | 211 | 127 | 301 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 17540 | 235 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 5533442 | 5533442 | PRJNA432257_S_NODE_47485_length_235_cov_45.742424_g47104_i0 | PRJNA432257 | 47485 | 235 | 45.742424 | 107.4946964 | Oxytricha trifallax | 1172189 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.22e-24 | NTclustered | gi|6851292|gb|AF192970.1| | 1172189 | g47104 | i0 | 89.796 | 1.71489361702128 | 98 | 10 | 42 | 0 | 97 | 194 | 1456 | 1359 | Oxytricha trifallax histone H4 gene, complete cds | blastn | 403 | 126 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha trifallax | ||
| 13842180 | 13842180 | PRJNA432257_S_NODE_29971_length_279_cov_19.119835_g29590_i0 | PRJNA432257 | 29971 | 279 | 19.119835 | 53.34433965 | root | 1 | Root_unresolved | Root_unresolved | 438 | 1.6899999999999996e-118 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g29590 | i0 | 98.785 | 81.1362007168459 | 247 | 1 | 88 | 2 | 35 | 279 | 2538 | 2784 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 22637 | 438 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 15732924 | 15732924 | PRJNA432257_S_NODE_91373_length_183_cov_2.102740_g90992_i0 | PRJNA432257 | 91373 | 183 | 2.10274 | 3.8480142 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 3.03e-74 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g90992 | i0 | 95.161 | 23.9344262295082 | 186 | 6 | 100 | 1 | 1 | 183 | 3861 | 3676 | 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 | 4380 | 291 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 17666440 | 17666440 | PRJNA432257_S_NODE_72694_length_200_cov_35.558282_g72313_i0 | PRJNA432257 | 72694 | 200 | 35.558282 | 71.116564 | root | 1 | Root_unresolved | Root_unresolved | 370 | 4.22e-98 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g72313 | i0 | 100 | 91.845 | 200 | 0 | 100 | 0 | 1 | 200 | 8115 | 8314 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 18369 | 370 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 19555186 | 19555186 | PRJNA432257_S_NODE_18336_length_331_cov_1486.945578_g17955_i0 | PRJNA432257 | 18336 | 331 | 1486.945578 | 4921.78986318 | Telotrochidium sp. 1 TS-2013 | 1349867 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.6199999999999994e-104 | NTclustered | gi|519419808|gb|KF287648.1| | 1349867 | g17955 | i0 | 90.878 | 87.3504531722054 | 296 | 22 | 89 | 4 | 38 | 330 | 18 | 311 | Telotrochidium sp. 1 TS-2013 large subunit ribosomal RNA gene, partial sequence | blastn | 28913 | 392 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Telotrochidium | Telotrochidium sp. 1 TS-2013 | ||
| 20215009 | 20215009 | PRJNA432257_S_NODE_58896_length_217_cov_25.794444_g58515_i0 | PRJNA432257 | 58896 | 217 | 25.794444 | 55.97394348 | root | 1 | Root_unresolved | Root_unresolved | 337 | 4.72e-88 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g58515 | i0 | 98.942 | 83.6267281105991 | 189 | 0 | 86 | 2 | 1 | 187 | 5398 | 5210 | 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 | 18147 | 337 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 20830962 | 20830962 | PRJNA432257_S_NODE_17337_length_338_cov_2.312292_g16956_i0 | PRJNA432257 | 17337 | 338 | 2.312292 | 7.81554696 | uncultured Uronychia sp. | 2487777 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 2.73e-112 | NTclustered | gi|1516250919|gb|MK177620.1| | 2487777 | g16956 | i0 | 92.256 | 66.4319526627219 | 297 | 20 | 88 | 1 | 42 | 338 | 393 | 100 | Uncultured Uronychia sp. clone DDI141.fa small subunit ribosomal RNA gene, partial sequence | blastn | 22454 | 418 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | uncultured Uronychia sp. | ||||
| 23382260 | 23382260 | PRJNA432257_S_NODE_71819_length_201_cov_36.030488_g71438_i0 | PRJNA432257 | 71819 | 201 | 36.030488 | 72.42128088 | Paramecium caudatum | 5885 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 7.69e-41 | NTclustered | gi|299830252|ref|NC_014262.1| | 5885 | g71438 | i0 | 88.742 | 0.751243781094527 | 151 | 11 | 74 | 6 | 32 | 179 | 26006 | 25859 | Paramecium caudatum mitochondrion, complete genome | blastn | 151 | 180 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium caudatum | ||
| 24040613 | 24040613 | PRJNA432257_S_NODE_69079_length_204_cov_91.113772_g68698_i0 | PRJNA432257 | 69079 | 204 | 91.113772 | 185.87209488 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 1.6799999999999994e-42 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g68698 | i0 | 91.791 | 1.97058823529412 | 134 | 10 | 65 | 1 | 33 | 165 | 3082 | 2949 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 402 | 185 | 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);;