RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1196438" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA1196438 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
18175014 18175014 PRJNA1196438_P_NODE_64075_length_253_cov_0.866667_g63648_i0 PRJNA1196438 64075 253 0.866667 2.19266751 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 67.4 8.58e-11   NR CAD8091707.1 65129 g63648 i0 40.9 1.10276679841897 93 42 98.4 3 251 3 341 430 CAD8091707.1 unnamed protein product [Paramecium sonneborni] diamond 279 67.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
26819507 26819507 PRJNA1196438_P_NODE_65021_length_252_cov_0.871508_g64594_i0 PRJNA1196438 65021 252 0.871508 2.19620016 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.35e-6   NR CDW80548.1 5949 g64594 i0 37 1.95238095238095 92 41 100 2 252 1 290 372 CDW80548.1 UNKNOWN [Stylonychia lemnae] diamond 492 55.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
26945837 26945837 PRJNA1196438_P_NODE_76062_length_242_cov_0.923077_g75635_i0 PRJNA1196438 76062 242 0.923077 2.23384634 Euplotes aediculatus 5940 SAR_Eukaryotes SAR_Eukaryotes 82 2.75e-16   NR QTT61050.1 5940 g75635 i0 71.9 0.706611570247934 57 16 70.7 0 62 232 282 338 QTT61050.1 hypothetical protein [Euplotes aediculatus] diamond 171 82 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes aediculatus
28083090 28083090 PRJNA1196438_P_NODE_33285_length_299_cov_3.101770_g32859_i0 PRJNA1196438 33285 299 3.10177 9.2742923 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0277   NR XP_001032992.3 312017 g32859 i0 70 0.301003344481605 30 9 30.1 0 25 114 26 55 XP_001032992.3 C2 domain protein [Tetrahymena thermophila SB210] diamond 90 43.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28481034 28481034 PRJNA1196438_P_NODE_26706_length_301_cov_5.508772_g26280_i0 PRJNA1196438 26706 301 5.508772 16.58140372 Euplotidae 100127 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0382   NR ACX30945.1 74792 g26280 i0 54 0.996677740863787 50 23 49.8 0 151 300 336 385 ACX30945.1 cytochrome b [Moneuplotes minuta] diamond 300 43.9 0.990888382687927 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes minuta
29459511 29459511 PRJNA1196438_P_NODE_82270_length_229_cov_2.589744_g81843_i0 PRJNA1196438 82270 229 2.589744 5.93051376 root 1 Root_unresolved Root_unresolved 48.5 2.74e-4   NR CDW74993.1 5949 g81843 i0 69.7 6.05240174672489 33 10 43.2 0 127 225 145 177 CDW74993.1 arsenical pump-driving atpase [Stylonychia lemnae] diamond 1386 48.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29819564 29819564 PRJNA1196438_P_NODE_68171_length_249_cov_0.886364_g67744_i0 PRJNA1196438 68171 249 0.886364 2.20704636 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 72 1.98e-12   NR CDW76481.1 5949 g67744 i0 81.4 0.518072289156627 43 8 51.8 0 181 53 274 316 CDW76481.1 tpr domain containing protein [Stylonychia lemnae] diamond 129 72 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29883148 29883148 PRJNA1196438_P_NODE_82331_length_229_cov_2.243590_g81904_i0 PRJNA1196438 82331 229 2.24359 5.1378211 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.0018600000000000001   NR XP_001022969.2 312017 g81904 i0 52.9 0.668122270742358 51 24 66.8 0 173 21 1744 1794 XP_001022969.2 hypothetical protein TTHERM_00348140 [Tetrahymena thermophila SB210] diamond 153 46.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31241429 31241429 PRJNA1196438_P_NODE_74955_length_243_cov_0.917647_g74528_i0 PRJNA1196438 74955 243 0.917647 2.22988221 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 79.7 3.36e-15   NR ABY59948.1 5911 g74528 i0 51.3 1.97530864197531 80 39 98.8 0 241 2 288 367 ABY59948.1 cytochrome P450 monooxygenase CYP5001A1 [Tetrahymena thermophila] diamond 480 79.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31494754 31494754 PRJNA1196438_P_NODE_78736_length_236_cov_4.325153_g78309_i0 PRJNA1196438 78736 236 4.325153 10.20736108 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 86.3 1.56e-17   NR XP_001448247.1 5888 g78309 i0 89.4 62.7330508474576 47 5 59.7 0 235 95 44 90 XP_001448247.1 uncharacterized protein GSPATT00015709001 [Paramecium tetraurelia] diamond 14805 86.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
31558091 31558091 PRJNA1196438_P_NODE_79836_length_234_cov_2.894410_g79409_i0 PRJNA1196438 79836 234 2.89441 6.7729194 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.5e-6   NR CDW77142.1 5949 g79409 i0 57.1 0.717948717948718 56 21 70.5 2 195 31 41 94 CDW77142.1 UNKNOWN [Stylonychia lemnae] diamond 168 55.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31810908 31810908 PRJNA1196438_P_NODE_45377_length_280_cov_2.536232_g44950_i0 PRJNA1196438 45377 280 2.536232 7.1014496 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 106 1.5499999999999998e-24   NR CAI2361196.1 5936 g44950 i0 59.1 0.942857142857143 88 36 94.3 0 266 3 344 431 CAI2361196.1 unnamed protein product [Moneuplotes crassus] diamond 264 106 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
32664523 32664523 PRJNA1196438_P_NODE_76300_length_242_cov_0.923077_g75873_i0 PRJNA1196438 76300 242 0.923077 2.23384634 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 75.5 7.46e-14   NR CAI2374586.1 5936 g75873 i0 83.7 0.607438016528926 49 8 60.7 0 162 16 1 49 CAI2374586.1 unnamed protein product [Moneuplotes crassus] diamond 147 75.5 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);;