RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA1174207" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA1174207 · 21 ✖

analysis 1

  • blastn · 21 ✖

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
1040409 1040409 PRJNA1174207_P_NODE_14861_length_376_cov_0.927393_g14332_i0 PRJNA1174207 14861 376 0.927393 3.48699768 Litostomatea 5988 SAR_Eukaryotes SAR_Eukaryotes 207 7.22e-49   NTclustered gi|2643596927|gb|PP067599.1| 40806 g14332 i0 92.414 40.6382978723404 145 11 39 0 1 145 4602 4458 Dasytricha ruminantium isolate SAG3_0_NT_5349 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 15280 207 1 Eukaryota Sar   Ciliophora Litostomatea Vestibuliferida Isotrichidae Dasytricha Dasytricha ruminantium
4142906 4142906 PRJNA1174207_P_NODE_6684_length_635_cov_10.503559_g6165_i0 PRJNA1174207 6684 635 10.503559 66.69759965 Opercularia sp. 2 2979175 SAR_Eukaryotes SAR_Eukaryotes 765 0   NTclustered gi|2304601488|gb|OP458309.1| 2979175 g6165 i0 88.712 65.407874015748 629 68 99 3 1 627 628 1 Opercularia sp. 2 large subunit ribosomal RNA gene, partial sequence blastn 41534 765 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Operculariidae Opercularia Opercularia sp. 2
4868803 4868803 PRJNA1174207_P_NODE_4004_length_883_cov_10.250617_g3547_i0 PRJNA1174207 4004 883 10.250617 90.51294811 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 1485 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g3547 i0 97.052 65.519818799547 882 26 99 0 2 883 920 39 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 57854 1485 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
7418283 7418283 PRJNA1174207_P_NODE_15426_length_367_cov_2.445578_g14897_i0 PRJNA1174207 15426 367 2.445578 8.97527126 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 673 0   NTclustered gi|1837628855|gb|MN158348.1| 5909 g14897 i0 99.728 98.7820163487738 367 1 100 0 1 367 2635 3001 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 36253 673 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
8693554 8693554 PRJNA1174207_P_NODE_26307_length_280_cov_1.487923_g25778_i0 PRJNA1174207 26307 280 1.487923 4.1661844 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 111 4.2e-20   NTclustered gi|3366652|gb|AF031320.1|AF031320 5911 g25778 i0 89.655 0.621428571428571 87 9 31 0 47 133 1019 1105 Tetrahymena thermophila granule lattice protein 4 precursor (GRL4) mRNA, complete cds blastn 174 111 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
11243791 11243791 PRJNA1174207_P_NODE_20169_length_315_cov_6.962810_g19640_i0 PRJNA1174207 20169 315 6.96281 21.9328515 root 1 Root_unresolved Root_unresolved 483 8.819999999999997e-132   NTclustered gi|345541658|gb|JN547815.1| 5911 g19640 i0 94.304 91.3142857142857 316 16 100 2 1 315 2211 2525 Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence blastn 28764 483 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
13793750 13793750 PRJNA1174207_P_NODE_15071_length_372_cov_4.983278_g14542_i0 PRJNA1174207 15071 372 4.983278 18.53779416 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 680 0   NTclustered gi|1172880852|gb|KY864168.1| 5909 g14542 i0 99.73 99.7365591397849 371 1 99 0 1 371 595 965 Tetrahymena rostrata isolate TR 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 37102 686 0.991253644314869 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
15618154 15618154 PRJNA1174207_P_NODE_14373_length_383_cov_2.270968_g13844_i0 PRJNA1174207 14373 383 2.270968 8.69780744 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 425 1.87e-114   NTclustered gi|161087246|gb|EU185635.1| 5932 g13844 i0 90.274 39.6997389033943 329 26 85 5 60 383 2661 2334 Ichthyophthirius multifiliis 28S ribosomal RNA gene, partial sequence blastn 15205 425 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
16892616 16892616 PRJNA1174207_P_NODE_23174_length_295_cov_1.279279_g22645_i0 PRJNA1174207 23174 295 1.279279 3.77387305 Cyclidium glaucoma 35100 SAR_Eukaryotes SAR_Eukaryotes 545 1.03e-150   NTclustered gi|111035915|emb|AJ781092.1| 35100 g22645 i0 100 99.864406779661 295 0 100 0 1 295 315 21 Cyclidium glaucoma partial 23S rRNA gene, strain ATCC 30701 blastn 29460 545 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
16893066 16893066 PRJNA1174207_P_NODE_7354_length_596_cov_5.868069_g6833_i0 PRJNA1174207 7354 596 5.868069 34.97369124 Tetrahymena nigricans 2704176 SAR_Eukaryotes SAR_Eukaryotes 791 0   NTclustered gi|2082965251|gb|MZ827091.1| 2704176 g6833 i0 90.864 66.489932885906 602 38 100 12 1 596 1076 486 Tetrahymena nigricans isolate VB57 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 39628 791 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena nigricans
17618244 17618244 PRJNA1174207_P_NODE_16314_length_355_cov_3.500000_g15785_i0 PRJNA1174207 16314 355 3.5 12.425 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 235 3.11e-57   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g15785 i0 97.122 1.17464788732394 139 4 39 0 1 139 2944 3082 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 417 235 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
18167225 18167225 PRJNA1174207_P_NODE_26895_length_277_cov_2.784314_g26366_i0 PRJNA1174207 26895 277 2.784314 7.71254978 Cardiostomatella vermiformis 311390 SAR_Eukaryotes SAR_Eukaryotes 204 6.65e-48   NTclustered gi|404425895|gb|JX310024.1| 311390 g26366 i0 81.25 40.5631768953069 256 45 91 2 25 277 1116 861 Cardiostomatella vermiformis voucher FXP2007101002 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 11236 204 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Loxocephalidae Cardiostomatella Cardiostomatella vermiformis
18892292 18892292 PRJNA1174207_P_NODE_39935_length_243_cov_0.905882_g39406_i0 PRJNA1174207 39935 243 0.905882 2.20129326 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 122 1.6499999999999995e-23   NTclustered gi|603435|gb|S72098.1| 36767 g39406 i0 90.426 12.201646090535 94 8 38 1 1 93 1209 1302 Euplotes focardii beta-tubulin gene, complete cds blastn 2965 122 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes focardii
19441941 19441941 PRJNA1174207_P_NODE_42276_length_236_cov_2.098160_g41747_i0 PRJNA1174207 42276 236 2.09816 4.9516576 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 233 7.039999999999999e-57   NTclustered gi|1004125725|gb|KU761582.1| 153251 g41747 i0 97.101 55.4025423728814 138 4 58 0 71 208 6361 6224 Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence blastn 13075 233 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
20166944 20166944 PRJNA1174207_P_NODE_27796_length_274_cov_1.174129_g27267_i0 PRJNA1174207 27796 274 1.174129 3.21711346 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 387 6.07e-103   NTclustered gi|315570294|tpg|BK007909.1| 5911 g27267 i0 92.279 2.23722627737226 272 21 99 0 2 273 355 626 TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS2e mRNA, complete cds blastn 613 387 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
20716683 20716683 PRJNA1174207_P_NODE_11357_length_445_cov_2.040323_g10831_i0 PRJNA1174207 11357 445 2.040323 9.07943735 Miamiensis avidus 279580 SAR_Eukaryotes SAR_Eukaryotes 183 1.46e-41   NTclustered gi|1360785898|gb|MH064355.1| 279580 g10831 i0 79.926 35.4786516853933 269 39 59 12 2 265 1916 1658 Miamiensis avidus voucher 2017SHK large subunit ribosomal RNA gene, partial sequence blastn 15788 183 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Glauconematidae Miamiensis Miamiensis avidus
21442553 21442553 PRJNA1174207_P_NODE_28237_length_272_cov_1.201005_g27708_i0 PRJNA1174207 28237 272 1.201005 3.2667336 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 172 1.84e-38   NTclustered gi|10813|emb|X05544.1| 5911 g27708 i0 90.226 5.48897058823529 133 12 49 1 140 272 604 473 Tetrahymena thermophila gene for histone H2B-2 from macronucleus blastn 1493 172 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
21442674 21442674 PRJNA1174207_P_NODE_39377_length_243_cov_4.205882_g38848_i0 PRJNA1174207 39377 243 4.205882 10.22029326 root 1 Root_unresolved Root_unresolved 438 1.4399999999999996e-118   NTclustered gi|345541658|gb|JN547815.1| 5911 g38848 i0 99.177 72.1810699588477 243 2 100 0 1 243 3510 3752 Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence blastn 17540 438 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
21992270 21992270 PRJNA1174207_P_NODE_30478_length_262_cov_4.328042_g29949_i0 PRJNA1174207 30478 262 4.328042 11.33947004 Opercularia sp. 2 2979175 SAR_Eukaryotes SAR_Eukaryotes 455 1.56e-123   NTclustered gi|2304601488|gb|OP458309.1| 2979175 g29949 i0 98.084 98.530534351145 261 5 99 0 2 262 1440 1180 Opercularia sp. 2 large subunit ribosomal RNA gene, partial sequence blastn 25815 455 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Operculariidae Opercularia Opercularia sp. 2
24541394 24541394 PRJNA1174207_P_NODE_16900_length_348_cov_1.400000_g16371_i0 PRJNA1174207 16900 348 1.4 4.872 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 291 6.42e-74   NTclustered gi|3366650|gb|AF031319.1|AF031319 5911 g16371 i0 86.029 0.781609195402299 272 37 78 1 77 348 1056 1326 Tetrahymena thermophila granule lattice protein 3 precursor (GRL3) mRNA, complete cds blastn 272 291 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
24541630 24541630 PRJNA1174207_P_NODE_29560_length_266_cov_2.145078_g29031_i0 PRJNA1174207 29560 266 2.145078 5.70590748 Tetrahymena sp. KGE15 1200497 SAR_Eukaryotes SAR_Eukaryotes 481 2.62e-131   NTclustered gi|523704203|emb|HE861887.1| 1200497 g29031 i0 99.248 100.296992481203 266 2 100 0 1 266 612 347 Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 blastn 26679 481 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena sp. KGE15

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