RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJEB4632", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 20 ✖

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJEB4632 · 20 ✖

analysis 1

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
2611500 2611500 PRJEB4632_P_NODE_363_length_373_cov_4.116667_g325_i0 PRJEB4632 363 373 4.116667 15.35516791 Wilbertia typica 655661 SAR_Eukaryotes SAR_Eukaryotes 377 5.15e-100   NTclustered gi|404425902|gb|JX310031.1| 655661 g325 i0 87.202 75.3190348525469 336 37 90 2 38 373 2544 2215 Wilbertia typica voucher PXM20100628 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 28094 377 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Eurystomatellidae Wilbertia Wilbertia typica
5163914 5163914 PRJEB4632_P_NODE_645_length_273_cov_2.690000_g607_i0 PRJEB4632 645 273 2.69 7.3437 Cyclidium glaucoma 35100 SAR_Eukaryotes SAR_Eukaryotes 375 1.3099999999999998e-99   NTclustered gi|91093105|gb|DQ442827.1| 35100 g607 i0 91.636 83.7655677655678 275 18 100 5 1 273 648 377 Cyclidium glaucoma isolate ES2 18S ribosomal RNA gene, partial sequence blastn 22868 375 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
5163921 5163921 PRJEB4632_P_NODE_825_length_248_cov_1.611429_g787_i0 PRJEB4632 825 248 1.611429 3.99634392 Paramecium putrinum 122938 SAR_Eukaryotes SAR_Eukaryotes 459 1.13e-124   NTclustered gi|519419882|gb|KF287722.1| 122938 g787 i0 100 6.38306451612903 248 0 100 0 1 248 556 309 Paramecium putrinum isolate put large subunit ribosomal RNA gene, partial sequence blastn 1583 459 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium putrinum
6093183 6093183 PRJEB4632_P_NODE_1025_length_230_cov_8.694268_g987_i0 PRJEB4632 1025 230 8.694268 19.9968164 Vorticellidae 85904 SAR_Eukaryotes SAR_Eukaryotes 420 4.89e-113   NTclustered gi|309253768|gb|HM852985.1| 168244 g987 i0 99.567 100.434782608696 231 0 100 1 1 230 134 364 Carchesium polypinum isolate CRC14 small subunit ribosomal RNA gene, partial sequence blastn 23100 420 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Carchesium Carchesium polypinum
8988730 8988730 PRJEB4632_P_NODE_168_length_593_cov_9.025000_g130_i0 PRJEB4632 168 593 9.025 53.51825 Carchesium polypinum 168244 SAR_Eukaryotes SAR_Eukaryotes 1035 0   NTclustered gi|237502287|gb|FJ810383.1| 168244 g130 i0 98.962 88.2934232715008 578 6 97 0 1 578 434 1011 Carchesium polypinum isolate NR18 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 52358 1035 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Carchesium Carchesium polypinum
10264389 10264389 PRJEB4632_P_NODE_1029_length_230_cov_2.554140_g991_i0 PRJEB4632 1029 230 2.55414 5.874522 Campanella sp. 1 2979180 SAR_Eukaryotes SAR_Eukaryotes 392 1.07e-104   NTclustered gi|2304601473|gb|OP458294.1| 2979180 g991 i0 97.391 95.8521739130435 230 6 100 0 1 230 104 333 Campanella sp. 1 large subunit ribosomal RNA gene, partial sequence blastn 22046 392 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Campanella Campanella sp. 1
11539789 11539789 PRJEB4632_P_NODE_1010_length_233_cov_3.600000_g972_i0 PRJEB4632 1010 233 3.6 8.388 Epistylis cambari 3044357 SAR_Eukaryotes SAR_Eukaryotes 165 2.57e-36   NTclustered gi|2500396601|gb|OQ924985.1| 3044357 g972 i0 79.916 5.86695278969957 239 36 100 10 1 233 326 558 Epistylis cambari isolate WT2021061102 large subunit ribosomal RNA gene, partial sequence blastn 1367 165 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis cambari
11539790 11539790 PRJEB4632_P_NODE_1030_length_230_cov_2.235669_g992_i0 PRJEB4632 1030 230 2.235669 5.1420387 Aspidisca lynceus 2035364 SAR_Eukaryotes SAR_Eukaryotes 425 1.05e-114   NTclustered gi|2328859120|gb|OP828525.1| 2035364 g992 i0 100 16.6391304347826 230 0 100 0 1 230 1664 1435 Aspidisca lynceus isolate LCY2015101602 large subunit ribosomal RNA gene, partial sequence blastn 3827 425 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Aspidiscidae Aspidisca Aspidisca lynceus
12469116 12469116 PRJEB4632_P_NODE_170_length_592_cov_3.398844_g132_i0 PRJEB4632 170 592 3.398844 20.12115648 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 944 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g132 i0 95.439 50.2956081081081 592 27 100 0 1 592 648 57 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 29775 944 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
12469118 12469118 PRJEB4632_P_NODE_350_length_383_cov_10.170968_g312_i0 PRJEB4632 350 383 10.170968 38.95480744 Carchesium 168243 SAR_Eukaryotes SAR_Eukaryotes 702 0   NTclustered gi|309253768|gb|HM852985.1| 168244 g312 i0 99.739 100.161879895561 383 1 100 0 1 383 940 558 Carchesium polypinum isolate CRC14 small subunit ribosomal RNA gene, partial sequence blastn 38362 702 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Carchesium Carchesium polypinum
12815023 12815023 PRJEB4632_P_NODE_471_length_321_cov_4.129032_g433_i0 PRJEB4632 471 321 4.129032 13.25419272 Chilodonella hexasticha 1938391 SAR_Eukaryotes SAR_Eukaryotes 505 1.9199999999999995e-138   NTclustered gi|1389430805|gb|MH341633.1| 1938391 g433 i0 95.016 54.0934579439252 321 16 100 0 1 321 1916 2236 Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence blastn 17364 505 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella hexasticha
15363793 15363793 PRJEB4632_P_NODE_653_length_271_cov_4.474747_g615_i0 PRJEB4632 653 271 4.474747 12.12656437 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 470 5.79e-128   NTclustered gi|1837628855|gb|MN158348.1| 5909 g615 i0 98.141 98.6346863468635 269 5 99 0 3 271 4482 4214 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 26730 470 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
15363794 15363794 PRJEB4632_P_NODE_673_length_267_cov_4.974227_g635_i0 PRJEB4632 673 267 4.974227 13.28118609 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 412 9.73e-111   NTclustered gi|10782|emb|X54004.1| 5908 g635 i0 94.424 48.6554307116105 269 13 100 2 1 267 3007 3275 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 12991 412 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
16638349 16638349 PRJEB4632_P_NODE_354_length_378_cov_3.836066_g316_i0 PRJEB4632 354 378 3.836066 14.50032948 Aspidisca lynceus 2035364 SAR_Eukaryotes SAR_Eukaryotes 678 0   NTclustered gi|2328859120|gb|OP828525.1| 2035364 g316 i0 98.942 57.9550264550265 378 4 100 0 1 378 48 425 Aspidisca lynceus isolate LCY2015101602 large subunit ribosomal RNA gene, partial sequence blastn 21907 678 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Aspidiscidae Aspidisca Aspidisca lynceus
16638352 16638352 PRJEB4632_P_NODE_514_length_310_cov_3.206751_g476_i0 PRJEB4632 514 310 3.206751 9.9409281 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 512 1.11e-140   NTclustered gi|1837628855|gb|MN158348.1| 5909 g476 i0 96.452 58.0258064516129 310 11 100 0 1 310 5037 5346 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 17988 512 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
21392122 21392122 PRJEB4632_P_NODE_1077_length_209_cov_5.220588_g1039_i0 PRJEB4632 1077 209 5.220588 10.91102892 Vorticellidae 85904 SAR_Eukaryotes SAR_Eukaryotes 381 2.0599999999999996e-101   NTclustered gi|2304601474|gb|OP458295.1| 168244 g1039 i0 99.522 99.6602870813397 209 1 100 0 1 209 1394 1186 Carchesium polypinum large subunit ribosomal RNA gene, partial sequence blastn 20829 381 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Carchesium Carchesium polypinum
22666934 22666934 PRJEB4632_P_NODE_1038_length_228_cov_3.638710_g1000_i0 PRJEB4632 1038 228 3.63871 8.2962588 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 399 6.299999999999999e-107   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g1000 i0 98.246 75.6008771929825 228 4 100 0 1 228 1670 1897 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 17237 399 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
22666935 22666935 PRJEB4632_P_NODE_1078_length_209_cov_4.764706_g1040_i0 PRJEB4632 1078 209 4.764706 9.95823554 Carchesium 168243 SAR_Eukaryotes SAR_Eukaryotes 387 4.42e-103   NTclustered gi|309253774|gb|HM852991.1| 168244 g1040 i0 100 99.9952153110048 209 0 100 0 1 209 1381 1589 Carchesium polypinum isolate NR16 small subunit ribosomal RNA gene, partial sequence blastn 20899 387 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Carchesium Carchesium polypinum
23013535 23013535 PRJEB4632_P_NODE_359_length_375_cov_6.410596_g321_i0 PRJEB4632 359 375 6.410596 24.039735 Cyclidium glaucoma 35100 SAR_Eukaryotes SAR_Eukaryotes 466 1.08e-126   NTclustered gi|90657135|gb|DQ442793.1| 35100 g321 i0 89.646 93.432 367 37 98 1 9 375 463 98 Cyclidium glaucoma isolate ES7 28S ribosomal RNA gene, partial sequence blastn 35037 466 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
23013547 23013547 PRJEB4632_S_NODE_219_length_152_cov_2.606838_g217_i0 PRJEB4632 219 152 2.606838 3.96239376 Dexiostoma campyla 5927 SAR_Eukaryotes SAR_Eukaryotes 224 2.4899999999999994e-54   NTclustered gi|174196|gb|M98366.1|CPDRRLSA 5927 g217 i0 100 80.3026315789474 121 0 80 0 1 121 245 365 Colpidium campylum large subunit ribosomal RNA, 5' end blastn 12206 224 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Turaniellidae Dexiostoma Dexiostoma campyla

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