RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJEB75227" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 13 ✖

tax_clade 1

bioproject 1

  • PRJEB75227 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
2685733 2685733 PRJEB75227_P_NODE_6163_length_285_cov_1.004717_g5992_i0 PRJEB75227 6163 285 1.004717 2.86344345 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 140 1.4999999999999998e-39   NR CAG9329179.1 1481888 g5992 i0 70.2 2.96842105263158 94 28 98.9 0 283 2 61 154 CAG9329179.1 unnamed protein product [Blepharisma stoltei] diamond 846 140 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
17987204 17987204 PRJEB75227_P_NODE_3475_length_387_cov_1.863057_g3304_i0 PRJEB75227 3475 387 1.863057 7.21003059 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 186 8.899999999999999e-55   NR OMJ95975.1 5963 g3304 i0 68.8 8.93023255813953 128 38 99.2 1 385 2 5 130 OMJ95975.1 hypothetical protein SteCoe_534 [Stentor coeruleus] diamond 3456 186 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
18847391 18847391 PRJEB75227_P_NODE_6075_length_286_cov_1.145540_g5904_i0 PRJEB75227 6075 286 1.14554 3.2762444 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 103 2.05e-26   NR CDW83169.1 5949 g5904 i0 60.9 5.39160839160839 87 33 90.2 1 284 27 29 115 CDW83169.1 UNKNOWN [Stylonychia lemnae] diamond 1542 103 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
20536560 20536560 PRJEB75227_P_NODE_5617_length_294_cov_1.058824_g5446_i0 PRJEB75227 5617 294 1.058824 3.11294256 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 125 4.869999999999999e-31   NR CAD8088856.1 5886 g5446 i0 76.9 4.26530612244898 78 18 79.6 0 236 3 26 103 CAD8088856.1 unnamed protein product [Paramecium primaurelia] diamond 1254 125 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27539829 27539829 PRJEB75227_P_NODE_9744_length_248_cov_0.891429_g9573_i0 PRJEB75227 9744 248 0.891429 2.21074392 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 72.4 1.23e-12   NR XP_001022217.2 312017 g9573 i0 46.8 0.955645161290323 79 42 95.6 0 239 3 6 84 XP_001022217.2 rhodanese-like domain protein [Tetrahymena thermophila SB210] diamond 237 72.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27571287 27571287 PRJEB75227_P_NODE_5824_length_290_cov_1.267281_g5653_i0 PRJEB75227 5824 290 1.267281 3.6751149 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 142 1.99e-39   NR XP_001020085.3 312017 g5653 i0 71.9 4.96551724137931 96 27 99.3 0 2 289 11 106 XP_001020085.3 serine/threonine protein phosphatase 2A [Tetrahymena thermophila SB210] diamond 1440 142 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27974545 27974545 PRJEB75227_P_NODE_9885_length_248_cov_0.891429_g9714_i0 PRJEB75227 9885 248 0.891429 2.21074392 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62.4 4.86e-9   NR KAL4443128.1 5901 g9714 i0 35.7 3.14516129032258 98 40 90.7 2 245 21 580 677 KAL4443128.1 hypothetical protein ABPG74_002195 [Tetrahymena malaccensis] diamond 780 62.8 0.993630573248408 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28076398 28076398 PRJEB75227_P_NODE_5405_length_300_cov_1.973568_g5234_i0 PRJEB75227 5405 300 1.973568 5.920704 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 107 6.2100000000000006e-27   NR CDW89587.1 5949 g5234 i0 63.9 0.83 83 27 83 1 298 50 108 187 CDW89587.1 UNKNOWN [Stylonychia lemnae] diamond 249 107 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28613278 28613278 PRJEB75227_P_NODE_8207_length_253_cov_0.866667_g8036_i0 PRJEB75227 8207 253 0.866667 2.19266751 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 67 1.25e-10   NR XP_001017498.2 312017 g8036 i0 40 1.87351778656126 80 47 94.9 1 250 11 2747 2825 XP_001017498.2 flagellar associated protein [Tetrahymena thermophila SB210] diamond 474 67 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28858505 28858505 PRJEB75227_P_NODE_10168_length_247_cov_0.896552_g9997_i0 PRJEB75227 10168 247 0.896552 2.21448344 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 115 1.37e-27   NR CAI2387181.1 5936 g9997 i0 70 2.91497975708502 80 24 97.2 0 246 7 135 214 CAI2387181.1 unnamed protein product [Moneuplotes crassus] diamond 720 115 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31076981 31076981 PRJEB75227_P_NODE_10555_length_246_cov_0.901734_g10384_i0 PRJEB75227 10555 246 0.901734 2.21826564 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 86.7 1.29e-17   NR TNV81575.1 5974 g10384 i0 51.9 1.89024390243902 81 39 98.8 0 2 244 207 287 TNV81575.1 hypothetical protein FGO68_gene9974 [Halteria grandinella] diamond 465 86.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
31234701 31234701 PRJEB75227_P_NODE_3315_length_399_cov_1.435583_g3144_i0 PRJEB75227 3315 399 1.435583 5.72797617 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 95.9 2.55e-22   NR CAD8206115.1 43137 g3144 i0 52.6 1.7443609022556399 116 53 86.5 2 398 54 2 116 CAD8206115.1 unnamed protein product [Paramecium octaurelia] diamond 696 95.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
32846869 32846869 PRJEB75227_P_NODE_8360_length_253_cov_0.866667_g8189_i0 PRJEB75227 8360 253 0.866667 2.19266751 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 47 0.00136   NR OMJ71746.1 5963 g8189 i0 35.4 1.77865612648221 79 45 90.1 2 23 250 251 326 OMJ71746.1 hypothetical protein SteCoe_29965 [Stentor coeruleus] diamond 450 47 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus

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