RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA669701" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA669701 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
4462918 4462918 PRJNA669701_P_NODE_113284_length_249_cov_2.420455_g112889_i0 PRJNA669701 113284 249 2.420455 6.02693295 Chilodonella hexasticha 1938391 SAR_Eukaryotes SAR_Eukaryotes 372 1.52e-98   NTclustered gi|1389430805|gb|MH341633.1| 1938391 g112889 i0 93.574 29.285140562249 249 16 100 0 1 249 1895 2143 Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence blastn 7292 372 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella hexasticha
5738916 5738916 PRJNA669701_P_NODE_146845_length_229_cov_2.961538_g146450_i0 PRJNA669701 146845 229 2.961538 6.78192202 Colpoda steini 63136 SAR_Eukaryotes SAR_Eukaryotes 424 3.76e-114   NTclustered gi|2041534488|gb|MZ233410.1| 63136 g146450 i0 100 99.5545851528384 229 0 100 0 1 229 266 38 Colpoda steinii isolate 2196 small subunit ribosomal RNA gene, partial sequence blastn 22798 424 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
7014267 7014267 PRJNA669701_P_NODE_35726_length_394_cov_1.919003_g35331_i0 PRJNA669701 35726 394 1.919003 7.56087182 Opercularia sp. 2 2979175 SAR_Eukaryotes SAR_Eukaryotes 440 6.889999999999999e-119   NTclustered gi|2304601488|gb|OP458309.1| 2979175 g35331 i0 87.121 51.9035532994924 396 41 99 9 4 394 221 611 Opercularia sp. 2 large subunit ribosomal RNA gene, partial sequence blastn 20450 440 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Operculariidae Opercularia Opercularia sp. 2
8289565 8289565 PRJNA669701_P_NODE_8327_length_843_cov_7.236364_g7976_i0 PRJNA669701 8327 843 7.236364 61.00254852 Chilodonella hexasticha 1938391 SAR_Eukaryotes SAR_Eukaryotes 1419 0   NTclustered gi|1389430803|gb|MH341631.1| 1938391 g7976 i0 97.041 56.4614472123369 845 22 100 3 1 843 1485 2328 Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence blastn 47597 1419 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella hexasticha
11367757 11367757 PRJNA669701_P_NODE_32309_length_413_cov_11.161765_g31914_i0 PRJNA669701 32309 413 11.161765 46.09808945 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 339 2.72e-88   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g31914 i0 97.949 52.6222760290557 195 4 47 0 1 195 2888 3082 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 21733 339 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
12114510 12114510 PRJNA669701_P_NODE_126290_length_245_cov_3.808140_g125895_i0 PRJNA669701 126290 245 3.80814 9.329943 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 115 2.7800000000000003e-21   NTclustered gi|829192014|ref|XM_012799966.1| 312017 g125895 i0 88.421 1.71428571428571 95 11 39 0 43 137 125 219 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 420 115 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
12115015 12115015 PRJNA669701_P_NODE_36230_length_391_cov_22.930818_g35835_i0 PRJNA669701 36230 391 22.930818 89.65949838 Paramecium caudatum 5885 SAR_Eukaryotes SAR_Eukaryotes 185 3.5299999999999995e-42   NTclustered gi|57158232|dbj|AB195235.1| 5885 g35835 i0 81.385 58.0102301790281 231 39 59 4 45 273 357 129 Paramecium caudatum macronuclear H2A mRNA for histone H2A, complete cds blastn 22682 185 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
14665024 14665024 PRJNA669701_P_NODE_63732_length_308_cov_2.510638_g63337_i0 PRJNA669701 63732 308 2.510638 7.73276504 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 187 7.55e-43   NTclustered gi|331686220|gb|HQ432924.1| 94289 g63337 i0 78.114 30.788961038961 297 63 96 2 13 308 1198 903 Sterkiella histriomuscorum strain 310 heat shock protein 70 (hsp70) gene, complete cds; macronuclear blastn 9483 187 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
15193242 15193242 PRJNA669701_P_NODE_7932_length_864_cov_9.901391_g7586_i0 PRJNA669701 7932 864 9.901391 85.54801824 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 1452 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g7586 i0 96.991 61.5451388888889 864 26 100 0 1 864 924 61 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 53175 1452 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
18488625 18488625 PRJNA669701_P_NODE_78175_length_284_cov_1.459716_g77780_i0 PRJNA669701 78175 284 1.459716 4.14559344 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 508 1.29e-139   NTclustered gi|300676714|gb|GQ377691.1| 151077 g77780 i0 98.944 44.806338028169 284 3 100 0 1 284 353 70 Chilodonella uncinata rps22a (rps22a) mRNA, complete cds blastn 12725 508 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
18488767 18488767 PRJNA669701_P_NODE_88295_length_272_cov_1.537688_g87900_i0 PRJNA669701 88295 272 1.537688 4.18251136 Colpoda steini 63136 SAR_Eukaryotes SAR_Eukaryotes 497 2.67e-136   NTclustered gi|646281697|gb|KJ607915.1| 63136 g87900 i0 99.632 100.632352941176 272 1 100 0 1 272 301 30 Colpoda steinii strain PABBc-29 18S ribosomal RNA gene, partial sequence blastn 27372 497 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
19015661 19015661 PRJNA669701_P_NODE_148835_length_213_cov_4.028571_g148440_i0 PRJNA669701 148835 213 4.028571 8.58085623 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 366 5.89e-97   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g148440 i0 97.653 84.7276995305164 213 5 100 0 1 213 2622 2410 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 18047 366 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
21037990 21037990 PRJNA669701_P_NODE_146717_length_229_cov_5.032051_g146322_i0 PRJNA669701 146717 229 5.032051 11.52339679 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 329 8.43e-86   NTclustered gi|10790|emb|X12767.1| 5908 g146322 i0 92.576 96.353711790393 229 17 100 0 1 229 444 672 Tetrahymena pyriformis alpha-tubulin gene blastn 22065 329 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
22841928 22841928 PRJNA669701_P_NODE_59118_length_317_cov_1.258197_g58723_i0 PRJNA669701 59118 317 1.258197 3.98848449 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 580 3.0599999999999993e-161   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g58723 i0 99.685 98.807570977918 317 1 100 0 1 317 1266 950 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 31322 580 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
24861363 24861363 PRJNA669701_P_NODE_12360_length_678_cov_5.019835_g11978_i0 PRJNA669701 12360 678 5.019835 34.0344813 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.019   NTclustered gi|829186935|ref|XM_001022570.3| 312017 g11978 i0 100 0.0427728613569322 29 0 4 0 291 319 1636 1608 Tetrahymena thermophila SB210 Serine/Threonine kinase domain protein partial mRNA blastn 29 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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