RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA812001" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA812001 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
24176201 24176201 PRJNA812001_P_NODE_96819_length_248_cov_0.880000_g96573_i0 PRJNA812001 96819 248 0.88 2.1824 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 129 2.32e-33   NR ADU54561.1 5885 g96573 i0 76.8 1.98387096774194 82 19 99.2 0 246 1 252 333 ADU54561.1 mitochondrial-type hsp70 1, partial [Paramecium caudatum] diamond 492 129 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
26769410 26769410 PRJNA812001_P_NODE_80101_length_251_cov_0.865169_g79855_i0 PRJNA812001 80101 251 0.865169 2.17157419 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 51.2 4.05e-5   NR CAD8186117.1 43138 g79855 i0 39.5 3.87250996015936 81 46 96.8 1 6 248 62 139 CAD8186117.1 unnamed protein product [Paramecium pentaurelia] diamond 972 51.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
27938806 27938806 PRJNA812001_P_NODE_66645_length_266_cov_1.544041_g66399_i0 PRJNA812001 66645 266 1.544041 4.10714906 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 99.8 4.41e-22   NR XP_001026696.2 312017 g66399 i0 58 0.913533834586466 81 33 91.4 1 254 12 141 220 XP_001026696.2 squalene-tetrahymanol cyclase [Tetrahymena thermophila SB210] diamond 243 99.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29431226 29431226 PRJNA812001_P_NODE_111089_length_245_cov_0.895349_g110843_i0 PRJNA812001 111089 245 0.895349 2.19360505 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 109 1.05e-25   NR TNV85376.1 5974 g110843 i0 72.3 18.3061224489796 65 18 79.6 0 244 50 440 504 TNV85376.1 hypothetical protein FGO68_gene7213 [Halteria grandinella] diamond 4485 110 0.990909090909091 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
29453887 29453887 PRJNA812001_P_NODE_93630_length_248_cov_1.211429_g93384_i0 PRJNA812001 93630 248 1.211429 3.00434392 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 55.8 3.2e-7   NR CAG9315069.1 1481888 g93384 i0 34.2 0.955645161290323 79 52 95.6 0 2 238 12 90 CAG9315069.1 unnamed protein product [Blepharisma stoltei] diamond 237 55.8 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30054112 30054112 PRJNA812001_P_NODE_95991_length_248_cov_0.880000_g95745_i0 PRJNA812001 95991 248 0.88 2.1824 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 105 3.36e-24   NR CAD8169588.1 43137 g95745 i0 60.3 3.84677419354839 78 31 94.4 0 13 246 1358 1435 CAD8169588.1 unnamed protein product [Paramecium octaurelia] diamond 954 105 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
30433783 30433783 PRJNA812001_P_NODE_26833_length_347_cov_1.062044_g26587_i0 PRJNA812001 26833 347 1.062044 3.68529268 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 127 2.98e-34   NR XP_004030147.1 5932 g26587 i0 51.3 0.976945244956772 113 55 97.7 0 339 1 61 173 XP_004030147.1 hypothetical protein IMG5_167050 [Ichthyophthirius multifiliis] diamond 339 127 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30528136 30528136 PRJNA812001_P_NODE_131393_length_241_cov_0.916667_g131147_i0 PRJNA812001 131393 241 0.916667 2.20916747 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 123 1.32e-30   NR CAD8175259.1 43138 g131147 i0 69.6 1.92946058091286 79 24 98.3 0 239 3 376 454 CAD8175259.1 unnamed protein product [Paramecium pentaurelia] diamond 465 123 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
30622837 30622837 PRJNA812001_P_NODE_7273_length_574_cov_4.229541_g7028_i0 PRJNA812001 7273 574 4.229541 24.27756534 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 89 1.15e-19   NR CAI2377036.1 5936 g7028 i0 73.1 0.350174216027875 67 18 35 0 201 1 1 67 CAI2377036.1 unnamed protein product [Moneuplotes crassus] diamond 201 89 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31760987 31760987 PRJNA812001_P_NODE_121617_length_243_cov_0.905882_g121371_i0 PRJNA812001 121617 243 0.905882 2.20129326 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 149 8.83e-44   NR CAI2368921.1 5936 g121371 i0 97.5 0.987654320987654 80 2 98.8 0 2 241 45 124 CAI2368921.1 unnamed protein product [Moneuplotes crassus] diamond 240 149 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
32267442 32267442 PRJNA812001_P_NODE_82298_length_251_cov_0.865169_g82052_i0 PRJNA812001 82298 251 0.865169 2.17157419 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 167 1.66e-48   NR CAI2367898.1 5936 g82052 i0 100 0.99203187250996006 83 0 99.2 0 249 1 166 248 CAI2367898.1 unnamed protein product [Moneuplotes crassus] diamond 249 167 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);;