RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA704949 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
15217416 15217416 PRJNA704949_P_NODE_30832_length_1426_cov_3.671750_g21707_i0 PRJNA704949 30832 1426 3.67175 52.359155 root 1 Root_unresolved Root_unresolved 402 6.66e-134   NR TNV75101.1 5974 g21707 i0 61.8 1.42426367461431 340 119 69.8 5 148 1143 62 398 TNV75101.1 hypothetical protein FGO68_gene14633 [Halteria grandinella] diamond 2031 406 0.990147783251232 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
26671337 26671337 PRJNA704949_P_NODE_1864081_length_173_cov_1.266129_g1848742_i0 PRJNA704949 1864081 173 1.266129 2.19040317 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 94.7 6.02e-21   NR CDW84965.1 5949 g1848742 i0 95.6 1.57803468208092 45 2 78 0 19 153 63 107 CDW84965.1 serine threonine-protein phosphatase [Stylonychia lemnae] diamond 273 94.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
26734668 26734668 PRJNA704949_P_NODE_2191421_length_158_cov_2.917431_g2176082_i0 PRJNA704949 2191421 158 2.917431 4.60954098 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00337   NR OMJ95733.1 5963 g2176082 i0 43.6 1.25316455696203 39 21 72.2 1 6 119 579 617 OMJ95733.1 hypothetical protein SteCoe_803 [Stentor coeruleus] diamond 198 44.3 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
27335978 27335978 PRJNA704949_P_NODE_1472803_length_203_cov_1.772727_g1457465_i0 PRJNA704949 1472803 203 1.772727 3.59863581 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0305   NR CAD8089767.1 5886 g1457465 i0 43.5 0.679802955665025 46 23 63.5 1 21 149 115 160 CAD8089767.1 unnamed protein product [Paramecium primaurelia] diamond 138 42.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27430832 27430832 PRJNA704949_P_NODE_1251763_length_226_cov_1.446328_g1236426_i0 PRJNA704949 1251763 226 1.446328 3.26870128 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 69.7 9.73e-12   NR CAG9329653.1 1481888 g1236426 i0 50 4.81858407079646 58 29 77 0 213 40 3748 3805 CAG9329653.1 unnamed protein product [Blepharisma stoltei] diamond 1089 69.7 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
27525567 27525567 PRJNA704949_P_NODE_2139503_length_163_cov_0.912281_g2124164_i0 PRJNA704949 2139503 163 0.912281 1.48701803 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 66.2 6.48e-11   NR XP_001014769.2 312017 g2124164 i0 60.8 3.68098159509202 51 20 93.9 0 10 162 96 146 XP_001014769.2 Serine/Threonine kinase domain protein [Tetrahymena thermophila SB210] diamond 600 66.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27999509 27999509 PRJNA704949_P_NODE_51945_length_1060_cov_1.950544_g41235_i0 PRJNA704949 51945 1060 1.950544 20.6757664 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 62.4 2.13e-6   NR CDW76198.1 5949 g41235 i0 41.9 1.04716981132075 74 43 20.9 0 224 3 3812 3885 CDW76198.1 dynein heavy chain axonemal [Stylonychia lemnae] diamond 1110 62.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29703483 29703483 PRJNA704949_P_NODE_1189950_length_233_cov_1.989130_g1174613_i0 PRJNA704949 1189950 233 1.98913 4.6346729 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 58.5 8.78e-8   NR XP_004031127.1 5932 g1174613 i0 42.6 1.55793991416309 68 38 86.3 1 202 2 487 554 XP_004031127.1 hypothetical protein IMG5_146640 [Ichthyophthirius multifiliis] diamond 363 58.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29735130 29735130 PRJNA704949_P_NODE_103190_length_774_cov_2.707586_g90677_i0 PRJNA704949 103190 774 2.707586 20.95671564 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 192 9.78e-59   NR TNV70982.1 5974 g90677 i0 88.9 0.418604651162791 108 12 41.9 0 59 382 1 108 TNV70982.1 hypothetical protein FGO68_gene2163 [Halteria grandinella] diamond 324 192 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
29778087 29778087 PRJNA704949_P_NODE_931311_length_272_cov_1.372197_g915977_i0 PRJNA704949 931311 272 1.3721969999999999 3.73237584 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 81.6 1.11e-15   NR KAL4456083.1 5901 g915977 i0 49.5 2.05147058823529 93 28 96 3 268 8 94 173 KAL4456083.1 hypothetical protein ABPG74_014044 [Tetrahymena malaccensis] diamond 558 81.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29809611 29809611 PRJNA704949_P_NODE_252571_length_530_cov_1.708940_g238008_i0 PRJNA704949 252571 530 1.70894 9.057382 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 71.2 2.85e-11   NR XP_001437851.1 5888 g238008 i0 68.1 1.21132075471698 47 15 26.6 0 508 368 122 168 XP_001437851.1 uncharacterized protein GSPATT00038558001 [Paramecium tetraurelia] diamond 642 71.6 0.994413407821229 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
30051744 30051744 PRJNA704949_P_NODE_998411_length_260_cov_2.734597_g983076_i0 PRJNA704949 998411 260 2.734597 7.1099522 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0136   NR CAG9324295.1 1481888 g983076 i0 40 3.39230769230769 40 23 45 1 62 178 1764 1803 CAG9324295.1 unnamed protein product [Blepharisma stoltei] diamond 882 44.3 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30714812 30714812 PRJNA704949_P_NODE_1315974_length_219_cov_1.223529_g1300637_i0 PRJNA704949 1315974 219 1.223529 2.67952851 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 73.6 5.5e-14   NR OMJ80997.1 5963 g1300637 i0 73.3 0.616438356164384 45 12 61.6 0 160 26 57 101 OMJ80997.1 hypothetical protein SteCoe_18609 [Stentor coeruleus] diamond 135 73.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31474037 31474037 PRJNA704949_P_NODE_750816_length_309_cov_2.000000_g735486_i0 PRJNA704949 750816 309 2 6.18 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 79 1.28e-16   NR KRX02724.1 266149 g735486 i0 42.7 0.864077669902913 89 49 85.4 2 266 3 7 94 KRX02724.1 hypothetical protein PPERSA_01841 [Pseudocohnilembus persalinus] diamond 267 79 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
31737332 31737332 PRJNA704949_P_NODE_1094757_length_246_cov_1.553299_g1079421_i0 PRJNA704949 1094757 246 1.553299 3.82111554 root 1 Root_unresolved Root_unresolved 48.1 4.77e-4   NR OMJ84366.1 5963 g1079421 i0 51.4 2.42682926829268 37 18 45.1 0 238 128 172 208 OMJ84366.1 hypothetical protein SteCoe_14517 [Stentor coeruleus] diamond 597 48.1 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31821456 31821456 PRJNA704949_P_NODE_2020377_length_166_cov_1.589744_g2005038_i0 PRJNA704949 2020377 166 1.589744 2.63897504 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 42 0.0243   NR CAG9329012.1 1481888 g2005038 i0 42.1 1.03012048192771 57 29 97.6 2 3 164 671 726 CAG9329012.1 unnamed protein product [Blepharisma stoltei] diamond 171 42 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32201075 32201075 PRJNA704949_P_NODE_1308678_length_220_cov_1.040936_g1293341_i0 PRJNA704949 1308678 220 1.040936 2.2900592 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 129 1.2199999999999999e-32   NR CDW86092.1 5949 g1293341 i0 92.9 0.954545454545455 70 5 95.5 0 1 210 147 216 CDW86092.1 kinesin motor domain protein [Stylonychia lemnae] diamond 210 129 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32517856 32517856 PRJNA704949_P_NODE_1723499_length_183_cov_1.552239_g1708160_i0 PRJNA704949 1723499 183 1.552239 2.84059737 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 42 0.0311   NR OMJ94238.1 5963 g1708160 i0 44.9 0.80327868852459 49 27 80.3 0 36 182 60 108 OMJ94238.1 hypothetical protein SteCoe_2571 [Stentor coeruleus] diamond 147 42 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32580825 32580825 PRJNA704949_P_NODE_1133479_length_241_cov_1.083333_g1118143_i0 PRJNA704949 1133479 241 1.083333 2.61083253 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.25e-9   NR CAG9319889.1 1481888 g1118143 i0 51.4 0.921161825726141 74 32 88.4 3 15 227 325 397 CAG9319889.1 unnamed protein product [Blepharisma stoltei] diamond 222 63.2 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32643654 32643654 PRJNA704949_P_NODE_350640_length_457_cov_2.294118_g335652_i0 PRJNA704949 350640 457 2.294118 10.48411926 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.5e-6   NR KRW98464.1 266149 g335652 i0 41.1 0.479212253829322 73 43 47.9 0 221 439 489 561 KRW98464.1 hypothetical protein PPERSA_03295 [Pseudocohnilembus persalinus] diamond 219 58.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32769456 32769456 PRJNA704949_P_NODE_1260340_length_225_cov_1.477273_g1245003_i0 PRJNA704949 1260340 225 1.477273 3.32386425 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 76.6 3.37e-14   NR CDW90050.1 5949 g1245003 i0 57.1 1.02666666666667 77 30 98.7 1 2 223 454 530 CDW90050.1 rna polymerase i subunit [Stylonychia lemnae] diamond 231 76.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

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