RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA1146029" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 22 ✖

tax_clade 1

bioproject 1

  • PRJNA1146029 · 22 ✖

analysis 1

  • blastn · 22 ✖

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
289956 289956 PRJNA1146029_P_NODE_10881_length_285_cov_1.386792_g10600_i0 PRJNA1146029 10881 285 1.386792 3.9523572 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 259 1.45e-64   NTclustered gi|829197694|ref|XM_001029851.3| 312017 g10600 i0 84.133 1.47017543859649 271 39 94 4 13 281 789 521 Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA blastn 419 259 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
290218 290218 PRJNA1146029_P_NODE_5841_length_363_cov_1.593103_g5563_i0 PRJNA1146029 5841 363 1.593103 5.78296389 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 455 2.2500000000000003e-123   NTclustered gi|829157134|ref|XM_001011598.2| 312017 g5563 i0 89.256 1.26997245179063 363 39 100 0 1 363 516 154 Tetrahymena thermophila SB210 60S ribosomal protein L5 partial mRNA blastn 461 455 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
1033683 1033683 PRJNA1146029_P_NODE_9321_length_298_cov_1.711111_g9040_i0 PRJNA1146029 9321 298 1.711111 5.09911078 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 424 5.09e-114   NTclustered gi|315570298|tpg|BK007911.1| 5911 g9040 i0 95.472 1.77852348993289 265 12 89 0 1 265 519 783 TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS4e mRNA, complete cds blastn 530 424 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
3584141 3584141 PRJNA1146029_P_NODE_8383_length_313_cov_0.962500_g8102_i0 PRJNA1146029 8383 313 0.9625 3.012625 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 147 1.31e-30   NTclustered gi|759083543|gb|KM222160.1| 5980 g8102 i0 87.023 41.2300319488818 131 16 42 1 21 150 1078 1208 Colpoda inflata voucher SXK2011071402 large subunit ribosomal RNA gene, partial sequence blastn 12905 148 0.993243243243243 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda inflata
5393198 5393198 PRJNA1146029_P_NODE_11005_length_284_cov_1.620853_g10724_i0 PRJNA1146029 11005 284 1.620853 4.60322252 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 363 1.07e-95   NTclustered gi|829145790|ref|XM_001009990.3| 312017 g10724 i0 91.603 0.922535211267606 262 22 92 0 23 284 1 262 Tetrahymena thermophila SB210 40S ribosomal protein S5 partial mRNA blastn 262 363 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
5393254 5393254 PRJNA1146029_P_NODE_14545_length_261_cov_1.228723_g14264_i0 PRJNA1146029 14545 261 1.228723 3.20696703 Pseudocohnilembus hargisi 223571 SAR_Eukaryotes SAR_Eukaryotes 436 5.619999999999999e-118   NTclustered gi|390988054|gb|JN885122.1| 223571 g14264 i0 97.638 99.7318007662835 254 6 97 0 1 254 254 1 Pseudocohnilembus hargisi isolate JJM2010031301 large subunit ribsomal RNA gene, partial sequence blastn 26030 436 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus hargisi
5393431 5393431 PRJNA1146029_P_NODE_4825_length_394_cov_1.199377_g4547_i0 PRJNA1146029 4825 394 1.199377 4.72554538 Telotrochidium matiense 455295 SAR_Eukaryotes SAR_Eukaryotes 300 1.22e-76   NTclustered gi|21898545|gb|AY101355.1| 455295 g4547 i0 83.385 24.2030456852792 325 52 82 2 40 363 12 335 Opisthonecta matiensis actin II gene, partial cds blastn 9536 300 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Telotrochidium Telotrochidium matiense
9218094 9218094 PRJNA1146029_P_NODE_17568_length_249_cov_0.875000_g17287_i0 PRJNA1146029 17568 249 0.875 2.17875 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 257 4.45e-64   NTclustered gi|56607107|gb|AY825246.1| 5908 g17287 i0 85.542 1 249 32 99 4 3 249 94 340 Tetrahymena pyriformis translation elongation factor 1B gamma subunit mRNA, partial cds blastn 249 257 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
9218189 9218189 PRJNA1146029_P_NODE_2908_length_502_cov_1.358974_g2631_i0 PRJNA1146029 2908 502 1.358974 6.8220494800000004 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 721 0   NTclustered gi|220966760|gb|FJ545743.1| 94289 g2631 i0 93.429 68.9203187250996 487 30 97 2 1 486 5546 6031 Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear blastn 34598 721 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
11236925 11236925 PRJNA1146029_P_NODE_5669_length_367_cov_10.013605_g5391_i0 PRJNA1146029 5669 367 10.013605 36.74993035 Cyclidium 35099 SAR_Eukaryotes SAR_Eukaryotes 673 0   NTclustered gi|1173728643|gb|KY886366.1| 35100 g5391 i0 99.728 100.441416893733 367 1 100 0 1 367 1254 1620 Cyclidium glaucoma isolate AP4 small subunit ribosomal RNA gene, partial sequence blastn 36862 673 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
11768870 11768870 PRJNA1146029_P_NODE_4730_length_397_cov_3.694444_g4452_i0 PRJNA1146029 4730 397 3.694444 14.66694268 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 695 0   NTclustered gi|2651357788|gb|PP174303.1| 41631 g4452 i0 98.237 97.6221662468514 397 7 100 0 1 397 2282 1886 Colpoda sp. isolate CIL1 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 38756 695 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
11768937 11768937 PRJNA1146029_P_NODE_870_length_960_cov_17.683202_g667_i0 PRJNA1146029 870 960 17.683202 169.7587392 Cyclidium glaucoma 35100 SAR_Eukaryotes SAR_Eukaryotes 1463 0   NTclustered gi|2624480847|gb|OR865348.1| 35100 g667 i0 94.283 69.9416666666667 962 45 100 7 1 960 521 1474 Cyclidium glaucoma isolate LLH20220320 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 67144 1463 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
13043778 13043778 PRJNA1146029_P_NODE_1891_length_634_cov_1.372549_g1621_i0 PRJNA1146029 1891 634 1.372549 8.70196066 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 966 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g1621 i0 94.304 62.9132492113565 632 34 99 2 4 634 658 28 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 39887 966 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
13043844 13043844 PRJNA1146029_P_NODE_2691_length_522_cov_1.033408_g2414_i0 PRJNA1146029 2691 522 1.033408 5.39438976 Pseudodiophrys nigricans 1071522 SAR_Eukaryotes SAR_Eukaryotes 67.6 1.83e-6   NTclustered gi|342161083|gb|JF694048.1| 1071522 g2414 i0 72.766 7.97892720306513 235 50 45 8 1 235 1269 1489 Pseudodiophrys nigricans voucher JJM08060501 28S ribosomal RNA gene, partial sequence blastn 4165 67.6 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Uronychiidae Pseudodiophrys Pseudodiophrys nigricans
15593181 15593181 PRJNA1146029_P_NODE_9973_length_290_cov_1.419355_g9692_i0 PRJNA1146029 9973 290 1.419355 4.1161295 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 375 1.4e-99   NTclustered gi|118379397|ref|XM_001022864.1| 312017 g9692 i0 90 1 290 29 100 0 1 290 33 322 Tetrahymena thermophila SB210 60S ribosomal protein L13 partial mRNA blastn 290 375 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
16867323 16867323 PRJNA1146029_P_NODE_4354_length_412_cov_3.244838_g4076_i0 PRJNA1146029 4354 412 3.244838 13.36873256 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 756 0   NTclustered gi|2651357788|gb|PP174303.1| 41631 g4076 i0 99.757 88.7839805825243 412 1 100 0 1 412 3837 3426 Colpoda sp. isolate CIL1 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 36579 756 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
16867350 16867350 PRJNA1146029_P_NODE_6354_length_350_cov_11.794224_g6076_i0 PRJNA1146029 6354 350 11.794224 41.279784 Cyclidium glaucoma 35100 SAR_Eukaryotes SAR_Eukaryotes 634 2.5799999999999996e-177   NTclustered gi|1173728643|gb|KY886366.1| 35100 g6076 i0 99.429 97.8771428571429 350 1 100 1 1 350 371 23 Cyclidium glaucoma isolate AP4 small subunit ribosomal RNA gene, partial sequence blastn 34257 634 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
19416362 19416362 PRJNA1146029_P_NODE_9796_length_291_cov_3.105505_g9515_i0 PRJNA1146029 9796 291 3.105505 9.03701955 Ancistrum crassum 880990 SAR_Eukaryotes SAR_Eukaryotes 466 8.12e-127   NTclustered gi|514076835|gb|KF256825.1| 880990 g9515 i0 95.548 94.0343642611684 292 11 100 2 1 291 970 1260 Ancistrum crassum isolate FXP2009031601 large subunit ribosomal RNA gene, partial sequence blastn 27364 466 1 Eukaryota Sar   Ciliophora Oligohymenophorea Thigmotrichida Ancistridae Ancistrum Ancistrum crassum
20691568 20691568 PRJNA1146029_P_NODE_16117_length_251_cov_0.865169_g15836_i0 PRJNA1146029 16117 251 0.865169 2.17157419 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 370 5.53e-98   NTclustered gi|118385632|ref|XM_001025944.1| 312017 g15836 i0 93.227 1 251 17 100 0 1 251 44 294 Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA blastn 251 370 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
22710579 22710579 PRJNA1146029_P_NODE_9278_length_299_cov_1.022124_g8997_i0 PRJNA1146029 9278 299 1.022124 3.05615076 Colpodidae 5978 SAR_Eukaryotes SAR_Eukaryotes 553 6.25e-153   NTclustered gi|2067012198|gb|MZ557838.1| 5980 g8997 i0 100 99.876254180602 299 0 100 0 1 299 53 351 Colpoda inflata isolate ZL20210414 small subunit ribosomal RNA gene, partial sequence blastn 29863 553 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda inflata
23242378 23242378 PRJNA1146029_P_NODE_12719_length_273_cov_1.910000_g12438_i0 PRJNA1146029 12719 273 1.91 5.2143 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 230 1.0799999999999998e-55   NTclustered gi|3366656|gb|AF031322.1|AF031322 5911 g12438 i0 88.66 1.42490842490842 194 15 70 7 5 195 1393 1204 Tetrahymena thermophila granule lattice protein 7 precursor (GRL7) mRNA, complete cds blastn 389 230 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
23242412 23242412 PRJNA1146029_P_NODE_14519_length_261_cov_1.329787_g14238_i0 PRJNA1146029 14519 261 1.329787 3.47074407 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 372 1.61e-98   NTclustered gi|301014695|gb|GQ377692.1| 151077 g14238 i0 92.337 89.8659003831418 261 20 100 0 1 261 371 111 Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence blastn 23455 372 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata

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