RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1005695 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27595895 27595895 PRJNA1005695_P_NODE_13824_length_411_cov_2.186391_g12972_i0 PRJNA1005695 13824 411 2.186391 8.98606701 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 159 1.21e-46   NR CDW89718.1 5949 g12972 i0 55.9 13.8978102189781 136 60 99.3 0 411 4 32 167 CDW89718.1 60s ribosomal protein l16 [Stylonychia lemnae] diamond 5712 159 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29869112 29869112 PRJNA1005695_P_NODE_29691_length_274_cov_1.552239_g28839_i0 PRJNA1005695 29691 274 1.552239 4.25313486 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 54.7 3.13e-6   NR AAR04353.1 5911 g28839 i0 30.9 6.43795620437956 81 52 85.4 2 251 18 73 152 AAR04353.1 putative MAPK [Tetrahymena thermophila] diamond 1764 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30880068 30880068 PRJNA1005695_P_NODE_8914_length_523_cov_1.706667_g8067_i0 PRJNA1005695 8914 523 1.706667 8.92586841 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 124 7.379999999999999e-31   NR CAG9325519.1 1481888 g8067 i0 43 1.60611854684512 172 78 98.7 3 517 2 74 225 CAG9325519.1 unnamed protein product [Blepharisma stoltei] diamond 840 125 0.992 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32752798 32752798 PRJNA1005695_P_NODE_41160_length_233_cov_2.862500_g40308_i0 PRJNA1005695 41160 233 2.8625 6.669625 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 47 7.47e-4   NR OMJ83359.1 5963 g40308 i0 33.9 1.55793991416309 59 39 76 0 14 190 73 131 OMJ83359.1 hypothetical protein SteCoe_15763 [Stentor coeruleus] diamond 363 47 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32902629 32902629 PRJNA1005695_P_NODE_29660_length_274_cov_1.995025_g28808_i0 PRJNA1005695 29660 274 1.995025 5.4663685 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 83.2 5.33e-18   NR CAI2382075.1 5936 g28808 i0 68.8 2.12408759124088 64 18 67.9 1 189 4 1 64 CAI2382075.1 unnamed protein product [Moneuplotes crassus] diamond 582 83.2 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus

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