RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA983848" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA983848 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
2244647 2244647 PRJNA983848_P_NODE_45002_length_538_cov_3.449462_g39136_i0 PRJNA983848 45002 538 3.449462 18.55810556 root 1 Root_unresolved Root_unresolved 317 9.339999999999998e-107   NR CAD8081379.1 5886 g39136 i0 94.2 44.7379182156134 156 9 87 0 70 537 1 156 CAD8081379.1 unnamed protein product [Paramecium primaurelia] diamond 24069 317 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
25194263 25194263 PRJNA983848_P_NODE_156140_length_244_cov_0.912281_g150257_i0 PRJNA983848 156140 244 0.912281 2.22596564 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 124 8.729999999999998e-31   NR KRX08195.1 266149 g150257 i0 70.4 2.98770491803279 81 24 99.6 0 1 243 289 369 KRX08195.1 hypothetical protein PPERSA_12350 [Pseudocohnilembus persalinus] diamond 729 124 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
26868345 26868345 PRJNA983848_P_NODE_41501_length_581_cov_1.694882_g35658_i0 PRJNA983848 41501 581 1.694882 9.84726442 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 53.5 3.1e-5   NR CDW86772.1 5949 g35658 i0 44.6 0.428571428571429 83 37 41.3 3 7 246 63 139 CDW86772.1 UNKNOWN [Stylonychia lemnae] diamond 249 53.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27279311 27279311 PRJNA983848_P_NODE_85223_length_333_cov_1.734615_g79340_i0 PRJNA983848 85223 333 1.734615 5.77626795 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 88.2 1.25e-17   NR CAG9311321.1 1481888 g79340 i0 41.7 2.73873873873874 103 57 92.8 2 323 15 322 421 CAG9311321.1 unnamed protein product [Blepharisma stoltei] diamond 912 88.2 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30152489 30152489 PRJNA983848_P_NODE_143712_length_250_cov_0.881356_g137829_i0 PRJNA983848 143712 250 0.881356 2.20339 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.53e-10   NR CAG9333366.1 1481888 g137829 i0 38.6 3.984 83 51 99.6 0 250 2 370 452 CAG9333366.1 unnamed protein product [Blepharisma stoltei] diamond 996 66.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32839030 32839030 PRJNA983848_P_NODE_121980_length_271_cov_1.373737_g116097_i0 PRJNA983848 121980 271 1.373737 3.72282727 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 123 1.81e-33   NR CAG9318382.1 1481888 g116097 i0 74.6 0.785977859778598 71 18 78.6 0 264 52 64 134 CAG9318382.1 unnamed protein product [Blepharisma stoltei] diamond 213 123 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei

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