RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA737474 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
25580809 25580809 PRJNA737474f_S_NODE_5801_length_874_cov_64.594257_g5274_i0 PRJNA737474 5801 874 64.594257 564.55380618 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 387 2.13e-102   NTclustered gi|10792|emb|X12768.1| 5908 g5274 i0 85.372 41.5903890160183 376 52 43 3 463 836 1450 1076 Tetrahymena pyriformis beta-tubulin gene 1 (beta-TT1) blastn 36350 387 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
25586774 25586774 PRJNA737474g_S_NODE_335305_length_249_cov_1.244318_g334011_i0 PRJNA737474 335305 249 1.244318 3.09835182 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.023   NTclustered gi|829191702|ref|XM_001023866.2| 312017 g334011 i0 100 0.112449799196787 28 0 11 0 215 242 2263 2290 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
25710498 25710498 PRJNA737474d_S_NODE_9762_length_494_cov_7.534442_g9183_i0 PRJNA737474 9762 494 7.534442 37.22014348 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.004   NTclustered gi|118347797|ref|XM_001007375.1| 312017 g9183 i0 96.97 0.0668016194331984 33 1 7 0 371 403 1947 1915 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 33 56.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
25844883 25844883 PRJNA737474d_S_NODE_17611_length_365_cov_7.417808_g17017_i0 PRJNA737474 17611 365 7.417808 27.0749992 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 451 2.92e-122   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g17017 i0 93.709 27.6630136986301 302 17 82 2 65 365 370 70 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 10097 451 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
25845032 25845032 PRJNA737474d_S_NODE_20291_length_339_cov_3.169173_g19697_i0 PRJNA737474 20291 339 3.169173 10.74349647 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 296 1.34e-75   NTclustered gi|11466252|ref|NC_000862.1| 5908 g19697 i0 86.545 75.9262536873156 275 30 80 6 68 338 774 1045 Tetrahymena pyriformis mitochondrion, complete genome blastn 25739 296 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
26034669 26034669 PRJNA737474b_S_NODE_47660_length_237_cov_7.030488_g46621_i0 PRJNA737474 47660 237 7.030488 16.66225656 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 396 8.529999999999997e-106   NTclustered gi|2065561668|gb|MZ540265.1| 44029 g46621 i0 100 88.8565400843882 214 0 90 0 22 235 669 882 Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence blastn 21059 396 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium jenningsi
26035100 26035100 PRJNA737474c_S_NODE_18324_length_283_cov_3.171429_g17493_i0 PRJNA737474 18324 283 3.171429 8.97514407 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 512 9.97e-141   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g17493 i0 99.293 98.1872791519435 283 2 100 0 1 283 2341 2059 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 27787 512 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
26169902 26169902 PRJNA737474b_S_NODE_12645_length_450_cov_62754.867374_g11610_i0 PRJNA737474 12645 450 62754.867374 282396.903183 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 532 1.28e-146   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g11610 i0 96.296 44.7711111111111 324 12 72 0 1 324 113 436 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 20147 532 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
26252813 26252813 PRJNA737474c_S_NODE_8494_length_377_cov_6.651316_g7663_i0 PRJNA737474 8494 377 6.651316 25.07546132 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 411 5.139999999999999e-110   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g7663 i0 94.118 63.2254641909814 272 13 87 3 84 353 437 167 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 23836 411 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
26442661 26442661 PRJNA737474b_S_NODE_43895_length_247_cov_2.189655_g42856_i0 PRJNA737474 43895 247 2.189655 5.40844785 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 171 5.91e-38   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g42856 i0 97.03 2.12955465587045 101 3 41 0 10 110 2982 3082 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 526 171 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
26442774 26442774 PRJNA737474b_S_NODE_48527_length_232_cov_3.893082_g47488_i0 PRJNA737474 48527 232 3.893082 9.03195024 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 379 8.379999999999998e-101   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g47488 i0 98.598 91.8706896551724 214 3 92 0 19 232 2570 2783 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 21314 379 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
26524722 26524722 PRJNA737474c_S_NODE_7320_length_402_cov_2.352584_g6489_i0 PRJNA737474 7320 402 2.352584 9.45738768 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 361 5.64e-95   NTclustered gi|217404|dbj|D10521.1|TETCALW 5908 g6489 i0 84.958 85.7114427860697 359 50 89 3 42 398 481 125 Tetrahymena pyriformis mRNA for calmodulin, complete cds blastn 34456 361 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
26532174 26532174 PRJNA737474f_S_NODE_304280_length_234_cov_4.192547_g303602_i0 PRJNA737474 304280 234 4.192547 9.81055998 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.021   NTclustered gi|829191702|ref|XM_001023866.2| 312017 g303602 i0 100 0.11965811965812 28 0 12 0 19 46 2263 2290 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26541914 26541914 PRJNA737474g_S_NODE_66624_length_370_cov_2.373737_g65330_i0 PRJNA737474 66624 370 2.373737 8.7828269 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 150 1.2099999999999999e-31   NTclustered gi|217404|dbj|D10521.1|TETCALW 5908 g65330 i0 84.177 6.9 158 21 42 4 199 354 466 311 Tetrahymena pyriformis mRNA for calmodulin, complete cds blastn 2553 150 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis

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