RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA719595" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA719595 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
18561270 18561270 PRJNA719595_P_NODE_5255_length_279_cov_2.150485_g5220_i0 PRJNA719595 5255 279 2.150485 5.99985315 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 138 1.88e-39   NR XP_004040146.1 5932 g5220 i0 79.7 2.55913978494624 79 16 84.9 0 238 2 2 80 XP_004040146.1 hypothetical protein IMG5_000700 [Ichthyophthirius multifiliis] diamond 714 138 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
26767187 26767187 PRJNA719595_P_NODE_9181_length_243_cov_0.917647_g9146_i0 PRJNA719595 9181 243 0.917647 2.22988221 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 68.2 4.04e-11   NR XP_004029934.1 5932 g9146 i0 46.1 1.76543209876543 76 32 84 2 40 243 1 75 XP_004029934.1 hypothetical protein IMG5_169980 [Ichthyophthirius multifiliis] diamond 429 68.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
26956959 26956959 PRJNA719595_P_NODE_8542_length_246_cov_0.901734_g8507_i0 PRJNA719595 8542 246 0.901734 2.21826564 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.59e-18   NR XP_001019311.2 312017 g8507 i0 57.5 0.890243902439024 73 29 89 1 1 219 937 1007 XP_001019311.2 calcium-translocating P-type ATPase, PMCA-type protein [Tetrahymena thermophila SB210] diamond 219 89.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29010382 29010382 PRJNA719595_P_NODE_8748_length_245_cov_0.906977_g8713_i0 PRJNA719595 8748 245 0.906977 2.22209365 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 75.5 9.83e-14   NR XP_004030152.1 5932 g8713 i0 55.9 3.44081632653061 68 28 83.3 1 234 31 27 92 XP_004030152.1 serine carboxypeptidase family protein, putative [Ichthyophthirius multifiliis] diamond 843 75.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29830851 29830851 PRJNA719595_P_NODE_6551_length_253_cov_0.866667_g6516_i0 PRJNA719595 6551 253 0.866667 2.19266751 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 102 5.75e-23   NR XP_001030011.1 312017 g6516 i0 53 0.984189723320158 83 39 98.4 0 5 253 351 433 XP_001030011.1 cation channel family protein [Tetrahymena thermophila SB210] diamond 249 102 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29988901 29988901 PRJNA719595_P_NODE_7551_length_249_cov_0.886364_g7516_i0 PRJNA719595 7551 249 0.886364 2.20704636 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 104 9.6e-25   NR KRX09446.1 266149 g7516 i0 58.8 0.963855421686747 80 33 96.4 0 3 242 103 182 KRX09446.1 hypothetical protein PPERSA_00725 [Pseudocohnilembus persalinus] diamond 240 104 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30715470 30715470 PRJNA719595_P_NODE_7134_length_251_cov_0.876404_g7099_i0 PRJNA719595 7134 251 0.876404 2.19977404 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.62e-18   NR XP_001007813.2 312017 g7099 i0 50 0.932270916334661 78 39 93.2 0 249 16 366 443 XP_001007813.2 Serine/Threonine kinase domain protein [Tetrahymena thermophila SB210] diamond 234 89.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30810324 30810324 PRJNA719595_P_NODE_4374_length_302_cov_1.703057_g4339_i0 PRJNA719595 4374 302 1.703057 5.14323214 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 103 3e-25   NR KRX05597.1 266149 g4339 i0 54.5 1.00331125827815 101 42 99.3 2 302 3 1 98 KRX05597.1 Ribosomal protein L6, alpha-beta domain [Pseudocohnilembus persalinus] diamond 303 103 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
31569277 31569277 PRJNA719595_P_NODE_6956_length_251_cov_0.876404_g6921_i0 PRJNA719595 6956 251 0.876404 2.19977404 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 118 1.28e-29   NR CAD8164998.1 43137 g6921 i0 68.8 2.86852589641434 80 25 95.6 0 242 3 12 91 CAD8164998.1 unnamed protein product [Paramecium octaurelia] diamond 720 118 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
32833226 32833226 PRJNA719595_P_NODE_9300_length_242_cov_0.923077_g9265_i0 PRJNA719595 9300 242 0.923077 2.23384634 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 65.1 4.94e-10   NR CDW89939.1 5949 g9265 i0 39.2 0.979338842975207 79 36 97.9 1 237 1 403 469 CDW89939.1 transducin beta-like protein 3 [Stylonychia lemnae] diamond 237 65.1 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);;