RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA356682" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA356682 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
1072197 1072197 PRJNA356682_P_NODE_21041_length_315_cov_27.830579_g20350_i0 PRJNA356682 21041 315 27.830579 87.66632385 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 577 3.9299999999999986e-160   NTclustered gi|197114643|gb|DQ487201.2| 382706 g20350 i0 99.683 99.4222222222222 315 1 100 0 1 315 1385 1699 Vorticella sp. HCB-2005 18S small subunit ribosomal RNA gene, partial sequence blastn 31318 582 0.991408934707904 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. HCB-2005
2347854 2347854 PRJNA356682_P_NODE_45282_length_239_cov_2.530120_g44591_i0 PRJNA356682 45282 239 2.53012 6.0469868 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 396 8.609999999999997e-106   NTclustered gi|15027629|ref|NC_003029.1| 5911 g44591 i0 96.667 49.9623430962343 240 5 100 3 1 239 32978 33215 Tetrahymena thermophila mitochondrion, complete genome blastn 11941 396 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
4900499 4900499 PRJNA356682_P_NODE_7904_length_498_cov_9.303529_g7215_i0 PRJNA356682 7904 498 9.303529 46.33157442 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 769 0   NTclustered gi|363412159|gb|JN120233.1| 679523 g7215 i0 94.589 100.212851405622 499 24 100 3 1 498 969 473 Vorticella gracilis isolate 88vorc2fwhfixgz4S1S2 18S ribosomal RNA gene, partial sequence blastn 49906 769 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella gracilis
5501137 5501137 PRJNA356682_P_NODE_26745_length_285_cov_1.433962_g26054_i0 PRJNA356682 26745 285 1.433962 4.0867917 Tetrahymena furgasoni 5898 SAR_Eukaryotes SAR_Eukaryotes 527 3.59e-145   NTclustered gi|1268580055|gb|KY218535.1| 5898 g26054 i0 100 56.6385964912281 285 0 100 0 1 285 291 575 Tetrahymena furgasoni isolate 20749-1 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 16142 527 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena furgasoni
6775167 6775167 PRJNA356682_P_NODE_29106_length_275_cov_1.346535_g28415_i0 PRJNA356682 29106 275 1.346535 3.70297125 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 278 3.83e-70   NTclustered gi|829194699|ref|XM_001025224.3| 312017 g28415 i0 87.045 0.898181818181818 247 30 89 2 30 275 359 114 Tetrahymena thermophila SB210 S25 ribosomal protein partial mRNA blastn 247 278 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
10601663 10601663 PRJNA356682_P_NODE_44189_length_241_cov_4.214286_g43498_i0 PRJNA356682 44189 241 4.214286 10.15642926 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 440 3.959999999999999e-119   NTclustered gi|512134943|gb|JX178902.1| 1295638 g43498 i0 99.585 90.2240663900415 241 1 100 0 1 241 1386 1626 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 21744 440 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
11876076 11876076 PRJNA356682_P_NODE_22650_length_306_cov_1.128755_g21959_i0 PRJNA356682 22650 306 1.128755 3.4539903 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 267 9.36e-67   NTclustered gi|3366650|gb|AF031319.1|AF031319 5911 g21959 i0 85.115 0.856209150326797 262 38 86 1 1 262 1316 1056 Tetrahymena thermophila granule lattice protein 3 precursor (GRL3) mRNA, complete cds blastn 262 267 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
14426026 14426026 PRJNA356682_P_NODE_1332_length_1364_cov_5.797057_g896_i0 PRJNA356682 1332 1364 5.797057 79.07185748 Stentor sp. FG-2015 1607897 SAR_Eukaryotes SAR_Eukaryotes 241 2.78e-58   NTclustered gi|759083554|gb|KM222171.1| 1607897 g896 i0 76.2 14.074780058651 521 87 37 28 736 1240 1170 671 Stentor sp. FG-2015 voucher FYB3013041202 large subunit ribosomal RNA gene, partial sequence blastn 19198 241 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor sp. FG-2015
16374563 16374563 PRJNA356682_P_NODE_13153_length_388_cov_3.279365_g12463_i0 PRJNA356682 13153 388 3.279365 12.7239362 Cinetochilum 693930 SAR_Eukaryotes SAR_Eukaryotes 399 1.1499999999999998e-106   NTclustered gi|1494842648|emb|LR025746.1| 187299 g12463 i0 88.957 46.8762886597938 326 33 84 3 1 325 2485 2808 uncultured ciliate genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate 3ZS18 blastn 18188 399 1 Eukaryota Sar   Ciliophora         uncultured ciliate
16374829 16374829 PRJNA356682_P_NODE_31773_length_264_cov_3.068063_g31082_i0 PRJNA356682 31773 264 3.068063 8.09968632 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 374 4.53e-99   NTclustered gi|10804|emb|X56981.1| 5911 g31082 i0 93.281 3.45833333333333 253 17 96 0 12 264 369 117 T.thermophilus gene for 7SL RNA blastn 913 374 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
18923782 18923782 PRJNA356682_P_NODE_29955_length_271_cov_3.338384_g29264_i0 PRJNA356682 29955 271 3.338384 9.04702064 Frontonia 60002 SAR_Eukaryotes SAR_Eukaryotes 344 3.6599999999999997e-90   NTclustered gi|1955372076|gb|MW466719.1| 74487 g29264 i0 89.963 99.1217712177122 269 23 99 4 1 269 1523 1787 Frontonia sp. isolate MUFS1 large subunit ribosomal RNA gene, partial sequence blastn 26862 344 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Frontoniidae Frontonia Frontonia sp.
19523569 19523569 PRJNA356682_P_NODE_36996_length_250_cov_0.870056_g36305_i0 PRJNA356682 36996 250 0.870056 2.17514 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 110 1.32e-19   NTclustered gi|471221216|ref|XM_004027503.1| 5932 g36305 i0 76.147 0.872 218 46 86 5 1 215 249 35 Ichthyophthirius multifiliis myb-like DNA-binding domain protein (IMG5_181360) mRNA, complete cds blastn 218 110 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
21474036 21474036 PRJNA356682_P_NODE_33277_length_259_cov_2.059140_g32586_i0 PRJNA356682 33277 259 2.05914 5.3331726 root 1 Root_unresolved Root_unresolved 472 1.53e-128   NTclustered gi|134285520|gb|EF469201.1| 5932 g32586 i0 99.612 20.0772200772201 258 1 99 0 2 259 386 129 Ichthyophthirius multifiliis strain Wuhan putative manganese superoxide dismutase mRNA, partial cds blastn 5200 473 0.997885835095137 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
22748947 22748947 PRJNA356682_P_NODE_13858_length_379_cov_9.885621_g13168_i0 PRJNA356682 13858 379 9.885621 37.46650359 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 640 6.059999999999999e-179   NTclustered gi|512134943|gb|JX178902.1| 1295638 g13168 i0 97.098 99.7229551451187 379 11 100 0 1 379 2015 1637 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 37795 640 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
23349731 23349731 PRJNA356682_P_NODE_38599_length_248_cov_0.880000_g37908_i0 PRJNA356682 38599 248 0.88 2.1824 Tetrahymena pigmentosa 5907 SAR_Eukaryotes SAR_Eukaryotes 193 1.27e-44   NTclustered gi|114329902|ref|NC_008339.1| 5907 g37908 i0 81.818 29.4677419354839 231 41 93 1 3 233 9311 9540 Tetrahymena pigmentosa mitochondrion, complete genome blastn 7308 193 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pigmentosa
23349902 23349902 PRJNA356682_P_NODE_4619_length_660_cov_51.066440_g3952_i0 PRJNA356682 4619 660 51.06644 337.038504 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 981 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g3952 i0 93.485 91.0075757575758 660 43 100 0 1 660 1655 996 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 60065 981 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011

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