RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA781196 · 17 ✖

analysis 1

  • blastn · 17 ✖

tax_kingdom 0

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
759275 759275 PRJNA781196_P_NODE_38901_length_286_cov_1.910798_g38524_i0 PRJNA781196 38901 286 1.910798 5.46488228 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 398 2.9499999999999994e-106   NTclustered gi|118360339|ref|XM_001013407.1| 312017 g38524 i0 93.309 2.51748251748252 269 18 94 0 2 270 125 393 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 720 398 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
2486814 2486814 PRJNA781196_P_NODE_58182_length_248_cov_0.891429_g57805_i0 PRJNA781196 58182 248 0.891429 2.21074392 root 1 Root_unresolved Root_unresolved 231 2.68e-56   NTclustered gi|159993|gb|M34540.1|PARCAM 5888 g57805 i0 83.468 53.1774193548387 248 41 100 0 1 248 541 294 P.tetraurelia calmodulin gene, complete cds blastn 13188 231 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
4587218 4587218 PRJNA781196_P_NODE_15244_length_422_cov_2.650430_g14867_i0 PRJNA781196 15244 422 2.65043 11.1848146 Oxytricha granulifera 5947 SAR_Eukaryotes SAR_Eukaryotes 553 9.139999999999999e-153   NTclustered gi|21215206|gb|AF510205.1| 5947 g14867 i0 90.284 97.6374407582938 422 41 100 0 1 422 1440 1019 Oxytricha granulifera beta-tubulin gene, complete cds blastn 41203 553 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha granulifera
4587768 4587768 PRJNA781196_P_NODE_5204_length_675_cov_1.553156_g4841_i0 PRJNA781196 5204 675 1.553156 10.483803 Vorticella microstoma 77619 SAR_Eukaryotes SAR_Eukaryotes 965 0   NTclustered gi|21429685|gb|AY101350.1| 77619 g4841 i0 95.38 84.2237037037037 606 28 90 0 70 675 7 612 Vorticella microstoma alpha-tubulin gene, partial cds blastn 56851 965 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella microstoma
5862689 5862689 PRJNA781196_P_NODE_34525_length_301_cov_2.070175_g34148_i0 PRJNA781196 34525 301 2.070175 6.23122675 Eudiplodinium maggii 47892 SAR_Eukaryotes SAR_Eukaryotes 274 5.49e-69   NTclustered gi|92790165|emb|AJ965268.1| 47892 g34148 i0 83.224 173.837209302326 304 45 100 6 1 301 43 343 Eudiplodinium maggii partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) blastn 52325 274 1 Eukaryota Sar   Ciliophora Litostomatea Entodiniomorphida Ophryoscolecidae Eudiplodinium Eudiplodinium maggii
7138156 7138156 PRJNA781196_P_NODE_51586_length_252_cov_0.871508_g51209_i0 PRJNA781196 51586 252 0.871508 2.19620016 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 309 1.23e-79   NTclustered gi|146161228|ref|XM_971777.2| 312017 g51209 i0 90.87 1.48809523809524 230 21 91 0 1 230 230 1 Tetrahymena thermophila SB210 ribosomal protein L11, amine-terminal domain protein partial mRNA blastn 375 309 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8412222 8412222 PRJNA781196_P_NODE_24627_length_347_cov_1.135036_g24250_i0 PRJNA781196 24627 347 1.135036 3.93857492 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 564 3.41e-156   NTclustered gi|829187607|ref|XM_001011429.3| 312017 g24250 i0 96.221 12.5129682997118 344 13 99 0 1 344 7 350 Tetrahymena thermophila SB210 40S ribosomal protein S23 partial mRNA blastn 4342 564 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8864334 8864334 PRJNA781196_P_NODE_29167_length_324_cov_1.227092_g28790_i0 PRJNA781196 29167 324 1.227092 3.97577808 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 91.6 6.45e-14   NTclustered gi|10824|emb|X53988.1| 5911 g28790 i0 75.115 2.00925925925926 217 43 65 8 105 315 755 544 T.thermophila Icr-A gene for initiation and co-stimulation factor-A blastn 651 91.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
10963125 10963125 PRJNA781196_P_NODE_20489_length_374_cov_0.833887_g20112_i0 PRJNA781196 20489 374 0.833887 3.11873738 Caryotricha minuta 1004043 SAR_Eukaryotes SAR_Eukaryotes 209 2e-49   NTclustered gi|759083508|gb|KM222125.1| 1004043 g20112 i0 94.161 38.9331550802139 137 8 37 0 70 206 1284 1148 Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence blastn 14561 209 1 Eukaryota Sar   Ciliophora Spirotrichea Kiitrichida Kiitrichidae Caryotricha Caryotricha minuta
16061797 16061797 PRJNA781196_P_NODE_37893_length_289_cov_2.740741_g37516_i0 PRJNA781196 37893 289 2.740741 7.92074149 Opisthonecta henneguyi 6026 SAR_Eukaryotes SAR_Eukaryotes 409 1.38e-109   NTclustered gi|4063597|gb|AF056109.1| 6026 g37516 i0 92.334 37.5432525951557 287 22 99 0 1 287 915 1201 Telotrochidium henneguyii translation elongation factor 1-alpha (TEF1) gene, partial cds blastn 10850 409 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta henneguyi
18610990 18610990 PRJNA781196_P_NODE_44335_length_269_cov_1.193878_g43958_i0 PRJNA781196 44335 269 1.193878 3.21153182 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 139 1.84e-28   NTclustered gi|2386237590|ref|XM_001441612.2| 5888 g43958 i0 78.182 0.817843866171004 220 46 81 2 2 220 329 111 Paramecium tetraurelia uncharacterized protein (GSPATT00038985001), mRNA blastn 220 139 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
23711931 23711931 PRJNA781196_P_NODE_23579_length_352_cov_2.777778_g23202_i0 PRJNA781196 23579 352 2.777778 9.77777856 Euplotes eurystomus 5941 SAR_Eukaryotes SAR_Eukaryotes 239 2.38e-58   NTclustered gi|159037|gb|M57231.1|EUPUBQP 5941 g23202 i0 85.59 96.0426136363636 229 31 65 2 6 233 169 396 Euplotes eurystomus macronuclear polyubiquitin, complete cds blastn 33807 239 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes eurystomus
23712345 23712345 PRJNA781196_P_NODE_52639_length_251_cov_1.494382_g52262_i0 PRJNA781196 52639 251 1.494382 3.75089882 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.023   NTclustered gi|829161497|ref|XM_001010499.2| 312017 g52262 i0 100 0.111553784860558 28 0 11 0 101 128 1231 1204 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
24162968 24162968 PRJNA781196_P_NODE_4819_length_699_cov_2.623003_g3079_i1 PRJNA781196 4819 699 2.623003 18.33479097 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 396 2.799999999999999e-105   NTclustered gi|10805|emb|X52242.1| 5911 g3079 i1 83.333 16.3304721030043 432 68 62 4 192 621 459 30 T.thermophila mRNA for calmodulin blastn 11415 396 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
24985521 24985521 PRJNA781196_P_NODE_21520_length_366_cov_2.556314_g21143_i0 PRJNA781196 21520 366 2.556314 9.35610924 Vorticella microstoma 77619 SAR_Eukaryotes SAR_Eukaryotes 649 0   NTclustered gi|21429685|gb|AY101350.1| 77619 g21143 i0 98.634 99.620218579235 366 5 100 0 1 366 576 941 Vorticella microstoma alpha-tubulin gene, partial cds blastn 36461 649 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella microstoma
24986203 24986203 PRJNA781196_P_NODE_64280_length_244_cov_0.912281_g63903_i0 PRJNA781196 64280 244 0.912281 2.22596564 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 385 1.91e-102   NTclustered gi|56607109|gb|AY825247.1| 5908 g63903 i0 95.122 1.97131147540984 246 9 99 1 1 243 301 546 Tetrahymena pyriformis translation elongation factor 1B alpha subunit mRNA, partial cds blastn 481 385 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
25438186 25438186 PRJNA781196_P_NODE_68260_length_216_cov_13.090909_g67883_i0 PRJNA781196 68260 216 13.090909 28.27636344 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 399 5.909999999999999e-107   NTclustered gi|2065561668|gb|MZ540265.1| 44029 g67883 i0 100 100.00462962963 216 0 100 0 1 216 1367 1582 Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence blastn 21601 399 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium jenningsi

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;