RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA380660" 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

  • PRJNA380660 · 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
11880946 11880946 PRJNA380660_P_NODE_3810_length_418_cov_5.578406_g3419_i0 PRJNA380660 3810 418 5.578406 23.31773708 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 182 7.52e-53   NR CDW84941.1 5949 g3419 i0 82.6 2.34688995215311 109 19 78.2 0 418 92 321 429 CDW84941.1 26s protease regulatory subunit 6a [Stylonychia lemnae] diamond 981 182 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27123324 27123324 PRJNA380660_P_NODE_6202_length_305_cov_2.532609_g5802_i0 PRJNA380660 6202 305 2.532609 7.72445745 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 74.3 5.75e-13   NR OMJ78067.1 5963 g5802 i0 49.3 2.67540983606557 67 33 65.9 1 3 203 381 446 OMJ78067.1 hypothetical protein SteCoe_22223 [Stentor coeruleus] diamond 816 74.7 0.994645247657296 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
27391257 27391257 PRJNA380660_P_NODE_8923_length_226_cov_3.573604_g8523_i0 PRJNA380660 8923 226 3.573604 8.07634504 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 56.2 3.48e-8   NR CAD8136753.1 43138 g8523 i0 34.8 0.915929203539823 69 42 87.6 1 198 1 17 85 CAD8136753.1 unnamed protein product [Paramecium pentaurelia] diamond 207 56.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
28702748 28702748 PRJNA380660_P_NODE_8687_length_231_cov_3.262376_g8287_i0 PRJNA380660 8687 231 3.262376 7.53608856 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 65.1 4.39e-10   NR OMJ88878.1 5963 g8287 i0 42.7 2.94805194805195 75 36 97.4 1 225 1 855 922 OMJ88878.1 hypothetical protein SteCoe_9082 [Stentor coeruleus] diamond 681 65.1 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
29822059 29822059 PRJNA380660_P_NODE_6651_length_289_cov_2.142308_g6251_i0 PRJNA380660 6651 289 2.142308 6.19127012 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 54.7 4.14e-6   NR OMJ86545.1 5963 g6251 i0 67.7 1.80622837370242 31 10 32.2 0 182 90 243 273 OMJ86545.1 hypothetical protein SteCoe_11896 [Stentor coeruleus] diamond 522 54.7 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31086098 31086098 PRJNA380660_P_NODE_3855_length_416_cov_2.607235_g3464_i0 PRJNA380660 3855 416 2.607235 10.8460976 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 60.1 1.54e-7   NR CAD8163894.1 43138 g3464 i0 33.7 4.22596153846154 98 61 70.7 2 414 121 136 229 CAD8163894.1 unnamed protein product [Paramecium pentaurelia] diamond 1758 60.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia

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