RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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

  • PRJNA1092581 · 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
5299523 5299523 PRJNA1092581_P_NODE_32145_length_487_cov_10.821256_g31613_i0 PRJNA1092581 32145 487 10.821256 52.69951672 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 357 8.99e-94   NTclustered gi|2072713056|gb|MH608212.2| 266149 g31613 i0 81.144 60.6981519507187 472 65 94 18 8 467 38366 37907 Pseudocohnilembus persalinus mitochondrion blastn 29560 357 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
6121542 6121542 PRJNA1092581_P_NODE_52765_length_368_cov_8.654237_g52232_i0 PRJNA1092581 52765 368 8.654237 31.84759216 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 680 0   NTclustered gi|2065561668|gb|MZ540265.1| 44029 g52232 i0 100 99.9402173913043 368 0 100 0 1 368 546 913 Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence blastn 36778 680 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium jenningsi
6575637 6575637 PRJNA1092581_P_NODE_75966_length_298_cov_3.306667_g75433_i0 PRJNA1092581 75966 298 3.306667 9.85386766 uncultured ciliate 187299 SAR_Eukaryotes SAR_Eukaryotes 472 1.7899999999999998e-128   NTclustered gi|2006880679|emb|HG995635.1| 187299 g75433 i0 97.81 56.9429530201342 274 5 92 1 1 273 823 550 uncultured ciliate genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone 2f5efc6c blastn 16969 472 1 Eukaryota Sar   Ciliophora         uncultured ciliate
7849673 7849673 PRJNA1092581_P_NODE_45607_length_401_cov_3.411585_g45074_i0 PRJNA1092581 45607 401 3.411585 13.68045585 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.038   NTclustered gi|829184305|ref|XM_001021590.2| 312017 g45074 i0 100 0.0698254364089776 28 0 7 0 81 108 847 874 Tetrahymena thermophila SB210 tubulin-tyrosine ligase family protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8671838 8671838 PRJNA1092581_P_NODE_70927_length_310_cov_6.367089_g70394_i0 PRJNA1092581 70927 310 6.367089 19.7379759 root 1 Root_unresolved Root_unresolved 523 5.1099999999999986e-144   NTclustered gi|345541658|gb|JN547815.1| 5911 g70394 i0 99.308 76.8709677419355 289 2 93 0 1 289 3812 3524 Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence blastn 23830 523 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8672015 8672015 PRJNA1092581_P_NODE_85387_length_278_cov_2.507317_g84854_i0 PRJNA1092581 85387 278 2.507317 6.97034126 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 195 4.02e-45   NTclustered gi|10816|emb|X04755.1| 5911 g84854 i0 88.679 25.9460431654676 159 18 57 0 23 181 494 652 Tetrahymena DNA for histone H4-II blastn 7213 195 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
11221920 11221920 PRJNA1092581_P_NODE_61549_length_337_cov_6.340909_g61016_i0 PRJNA1092581 61549 337 6.340909 21.36886333 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 623 5.369999999999999e-174   NTclustered gi|1202132933|gb|KY435899.1| 60850 g61016 i0 100 99.9495548961424 337 0 100 0 1 337 42 378 Vorticella convallaria 18S ribosomal RNA gene, partial sequence blastn 33683 623 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella convallaria
14224394 14224394 PRJNA1092581_P_NODE_106912_length_244_cov_1.953216_g106379_i0 PRJNA1092581 106912 244 1.953216 4.76584704 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 154 5.87e-33   NTclustered gi|1004125725|gb|KU761582.1| 153251 g106379 i0 89.516 60.0245901639344 124 10 50 2 2 123 6568 6446 Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence blastn 14646 154 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
16321168 16321168 PRJNA1092581_P_NODE_79193_length_291_cov_2.311927_g78660_i0 PRJNA1092581 79193 291 2.311927 6.72770757 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 377 3.92e-100   NTclustered gi|10805|emb|X52242.1| 5911 g78660 i0 90.034 99.6494845360825 291 29 100 0 1 291 428 138 T.thermophila mRNA for calmodulin blastn 28998 377 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
19322663 19322663 PRJNA1092581_P_NODE_43016_length_414_cov_54.070381_g42483_i0 PRJNA1092581 43016 414 54.070381 223.85137734 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 682 0   NTclustered gi|512134949|gb|JX178908.1| 1295638 g42483 i0 97.964 92.1256038647343 393 8 95 0 1 393 1379 987 Vorticella sp. 4 JG-2011 clone 8 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 38140 682 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
20598684 20598684 PRJNA1092581_P_NODE_70717_length_311_cov_2.731092_g70184_i0 PRJNA1092581 70717 311 2.731092 8.49369612 Limnostrombidium viride 1844090 SAR_Eukaryotes SAR_Eukaryotes 449 8.82e-122   NTclustered gi|1028338869|gb|KU525737.1| 1844090 g70184 i0 99.593 96.6077170418006 246 1 79 0 1 246 246 1 Limnostrombidium viride isolate SW2012122001 28S ribosomal RNA gene, partial sequence blastn 30045 449 1 Eukaryota Sar   Ciliophora Spirotrichea   Strombidiidae Limnostrombidium Limnostrombidium viride
21872549 21872549 PRJNA1092581_P_NODE_110418_length_239_cov_5.969880_g109885_i0 PRJNA1092581 110418 239 5.96988 14.2680132 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 425 1.1e-114   NTclustered gi|220966760|gb|FJ545743.1| 94289 g109885 i0 98.745 102.55230125523 239 3 100 0 1 239 6669 6431 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 24510 425 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
23970695 23970695 PRJNA1092581_P_NODE_44159_length_408_cov_97.143284_g43626_i0 PRJNA1092581 44159 408 97.143284 396.34459872 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 592 1.8699999999999998e-164   NTclustered gi|872105|emb|Z49905.1| 41631 g43626 i0 95.89 80.9313725490196 365 15 89 0 23 387 1 365 Colpoda sp. gene for 28S ribosomal RNA (partial) blastn 33020 592 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
24423396 24423396 PRJNA1092581_P_NODE_65700_length_324_cov_18.282869_g65167_i0 PRJNA1092581 65700 324 18.282869 59.23649556 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 571 1.8899999999999993e-158   NTclustered gi|872105|emb|Z49905.1| 41631 g65167 i0 98.457 97.7222222222222 324 5 100 0 1 324 364 41 Colpoda sp. gene for 28S ribosomal RNA (partial) blastn 31662 571 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.

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