RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA734348" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA734348 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
19049217 19049217 PRJNA734348_P_NODE_71275_length_268_cov_2.620513_g70577_i0 PRJNA734348 71275 268 2.620513 7.02297484 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 89 1.31e-19   NR CAD8053537.1 65129 g70577 i0 56.6 0.850746268656716 76 33 85.1 0 230 3 118 193 CAD8053537.1 unnamed protein product [Paramecium sonneborni] diamond 228 89 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
26609017 26609017 PRJNA734348_P_NODE_133481_length_241_cov_0.916667_g132783_i0 PRJNA734348 133481 241 0.916667 2.20916747 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.15e-14   NR OMJ79442.1 5963 g132783 i0 64.8 1.95435684647303 54 19 67.2 0 69 230 345 398 OMJ79442.1 hypothetical protein SteCoe_20544 [Stentor coeruleus] diamond 471 78.2 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
26714084 26714084 PRJNA734348_P_NODE_123761_length_243_cov_0.905882_g123063_i0 PRJNA734348 123761 243 0.905882 2.20129326 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 123 3.29e-33   NR CAD8105527.1 5886 g123063 i0 70 2.98765432098765 80 24 98.8 0 2 241 89 168 CAD8105527.1 unnamed protein product [Paramecium primaurelia] diamond 726 124 0.991935483870968 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
26767615 26767615 PRJNA734348_P_NODE_24761_length_394_cov_1.439252_g24066_i0 PRJNA734348 24761 394 1.439252 5.67065288 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00672   NR KAL4512556.1 2486642 g24066 i0 47.7 0.33502538071066 44 23 33.5 0 262 393 127 170 KAL4512556.1 hypothetical protein ABPG72_020393 [Tetrahymena utriculariae] diamond 132 46.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
27052522 27052522 PRJNA734348_P_NODE_132022_length_241_cov_0.916667_g131324_i0 PRJNA734348 132022 241 0.916667 2.20916747 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00306   NR CDW72403.1 5949 g131324 i0 42.4 0.734439834024896 59 34 73.4 0 241 65 824 882 CDW72403.1 wd repeat-containing protein 47 [Stylonychia lemnae] diamond 177 45.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27210288 27210288 PRJNA734348_P_NODE_41562_length_310_cov_2.645570_g40866_i0 PRJNA734348 41562 310 2.64557 8.201267 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 55.1 3.89e-6   NR CAI2385508.1 5936 g40866 i0 56.5 0.9 46 20 44.5 0 173 310 42 87 CAI2385508.1 unnamed protein product [Moneuplotes crassus] diamond 279 55.1 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
27400234 27400234 PRJNA734348_P_NODE_74763_length_265_cov_1.635417_g74065_i0 PRJNA734348 74763 265 1.635417 4.33385505 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 80.9 1.1e-15   NR CDW74217.1 5949 g74065 i0 60.9 3.57735849056604 64 24 71.3 1 4 192 135 198 CDW74217.1 UNKNOWN [Stylonychia lemnae] diamond 948 80.9 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29010755 29010755 PRJNA734348_P_NODE_113648_length_246_cov_0.890173_g112950_i0 PRJNA734348 113648 246 0.890173 2.18982558 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 132 3.5999999999999997e-35   NR OMJ74837.1 5963 g112950 i0 85.9 0.951219512195122 78 11 95.1 0 11 244 153 230 OMJ74837.1 hypothetical protein SteCoe_26140 [Stentor coeruleus] diamond 234 132 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
29136973 29136973 PRJNA734348_P_NODE_92389_length_251_cov_0.865169_g91691_i0 PRJNA734348 92389 251 0.865169 2.17157419 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 60.5 2.36e-8   NR CAD8119713.1 65129 g91691 i0 41 0.932270916334661 78 41 92 2 3 233 186 259 CAD8119713.1 unnamed protein product [Paramecium sonneborni] diamond 234 60.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
29483746 29483746 PRJNA734348_P_NODE_79130_length_261_cov_2.047872_g78432_i0 PRJNA734348 79130 261 2.047872 5.34494592 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00256   NR KRW98814.1 266149 g78432 i0 35.8 1.2183908045977 53 34 60.9 0 9 167 166 218 KRW98814.1 hypothetical protein PPERSA_10585 [Pseudocohnilembus persalinus] diamond 318 46.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29609920 29609920 PRJNA734348_P_NODE_120830_length_244_cov_0.900585_g120132_i0 PRJNA734348 120830 244 0.900585 2.1974274 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 72.8 4.79e-14   NR XP_001023343.2 312017 g120132 i0 51.6 1.53688524590164 64 30 77.5 1 55 243 63 126 XP_001023343.2 hypothetical protein TTHERM_00444800 [Tetrahymena thermophila SB210] diamond 375 72.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30400425 30400425 PRJNA734348_P_NODE_107393_length_247_cov_0.885057_g106695_i0 PRJNA734348 107393 247 0.885057 2.18609079 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 47 0.00126   NR XP_001016174.1 312017 g106695 i0 71 0.376518218623482 31 9 37.7 0 93 1 313 343 XP_001016174.1 Hypothetical protein TTHERM_00820660 [Tetrahymena thermophila SB210] diamond 93 47 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30526345 30526345 PRJNA734348_P_NODE_69453_length_270_cov_1.878173_g68755_i0 PRJNA734348 69453 270 1.878173 5.0710671 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 52 2.57e-5   NR CDW89368.1 5949 g68755 i0 78.8 0.366666666666667 33 7 36.7 0 181 83 266 298 CDW89368.1 UNKNOWN [Stylonychia lemnae] diamond 99 52 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30652571 30652571 PRJNA734348_P_NODE_141253_length_230_cov_3.343949_g140555_i0 PRJNA734348 141253 230 3.343949 7.6910827 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 51.6 2.32e-5   NR XP_001440768.1 5888 g140555 i0 58.8 0.443478260869565 34 14 44.3 0 104 3 260 293 XP_001440768.1 uncharacterized protein GSPATT00009686001 [Paramecium tetraurelia] diamond 102 51.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
30757781 30757781 PRJNA734348_P_NODE_120234_length_244_cov_0.900585_g119536_i0 PRJNA734348 120234 244 0.900585 2.1974274 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 100 1.78e-22   NR CAD8057211.1 5886 g119536 i0 76.7 5.16393442622951 60 14 73.8 0 3 182 477 536 CAD8057211.1 unnamed protein product, partial [Paramecium primaurelia] diamond 1260 101 0.99009900990099 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
31632561 31632561 PRJNA734348_P_NODE_108916_length_247_cov_0.885057_g108218_i0 PRJNA734348 108916 247 0.885057 2.18609079 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00168   NR CDW89408.1 5949 g108218 i0 52.8 0.850202429149798 36 17 43.7 0 245 138 528 563 CDW89408.1 protein serine threonine [Stylonychia lemnae] diamond 210 46.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32170706 32170706 PRJNA734348_P_NODE_148178_length_206_cov_4.308271_g147480_i0 PRJNA734348 148178 206 4.308271 8.87503826 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 55.5 7.63e-7   NR KAL4442387.1 5901 g147480 i0 54.8 0.611650485436893 42 18 61.2 1 24 149 2682 2722 KAL4442387.1 hypothetical protein ABPG74_005728 [Tetrahymena malaccensis] diamond 126 55.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis

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