RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA312899" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA312899 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
27769500 27769500 PRJNA312899_P_NODE_32604_length_320_cov_14.107011_g32162_i0 PRJNA312899 32604 320 14.107011 45.1424352 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 59.7 1.77e-8   NR XP_004027231.1 5932 g32162 i0 64.4 0.421875 45 16 42.2 0 8 142 111 155 XP_004027231.1 hypothetical protein IMG5_187300 [Ichthyophthirius multifiliis] diamond 135 59.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27769507 27769507 PRJNA312899_P_NODE_44104_length_266_cov_3.935484_g43662_i0 PRJNA312899 44104 266 3.935484 10.46838744 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 70.1 1.08e-11   NR KRX03809.1 266149 g43662 i0 41.1 1.01503759398496 90 46 93.6 1 253 5 205 294 KRX03809.1 hypothetical protein PPERSA_04604 [Pseudocohnilembus persalinus] diamond 270 70.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
28369095 28369095 PRJNA312899_P_NODE_50566_length_244_cov_6.148718_g50124_i0 PRJNA312899 50566 244 6.148718 15.00287192 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 76.3 5.48e-14   NR CAI2366279.1 5936 g50124 i0 90 0.491803278688525 40 4 49.2 0 3 122 405 444 CAI2366279.1 unnamed protein product [Moneuplotes crassus] diamond 120 76.3 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
29158700 29158700 PRJNA312899_P_NODE_46909_length_256_cov_5.526570_g46467_i0 PRJNA312899 46909 256 5.52657 14.1480192 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 73.2 8.85e-13   NR CAI2369874.1 5936 g46467 i0 41.9 2.015625 86 47 98.4 2 255 4 3593 3677 CAI2369874.1 unnamed protein product [Moneuplotes crassus] diamond 516 73.2 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
29284630 29284630 PRJNA312899_P_NODE_22629_length_394_cov_47.681159_g22187_i0 PRJNA312899 22629 394 47.681159 187.86376646 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 58.2 8.17e-7   NR CAD8073808.1 5886 g22187 i0 35.6 0.685279187817259 90 53 68.5 2 388 119 645 729 CAD8073808.1 unnamed protein product [Paramecium primaurelia] diamond 270 58.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29410998 29410998 PRJNA312899_P_NODE_26709_length_360_cov_21.707395_g26267_i0 PRJNA312899 26709 360 21.707395000000002 78.146622 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 63.5 3.89e-9   NR CAI2378430.1 5936 g26267 i0 56.5 0.766666666666667 46 20 38.3 0 176 39 80 125 CAI2378430.1 unnamed protein product [Moneuplotes crassus] diamond 276 63.5 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
30200445 30200445 PRJNA312899_P_NODE_35992_length_301_cov_16.162698_g35550_i0 PRJNA312899 35992 301 16.162698 48.64972098 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 138 1.7299999999999998e-35   NR XP_001010911.1 312017 g35550 i0 74.7 0.867109634551495 87 22 86.7 0 40 300 766 852 XP_001010911.1 ubiquitin carboxy-terminal hydrolase [Tetrahymena thermophila SB210] diamond 261 138 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30439578 30439578 PRJNA312899_P_NODE_12513_length_534_cov_60.105155_g12084_i0 PRJNA312899 12513 534 60.105155 320.9615277 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 163 3.36e-47   NR XP_001014308.1 312017 g12084 i0 53.2 8.70786516853933 154 71 86.5 1 502 41 55 207 XP_001014308.1 eukaryotic translation initiation factor 5A [Tetrahymena thermophila SB210] diamond 4650 163 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31433087 31433087 PRJNA312899_P_NODE_52016_length_240_cov_1.958115_g51574_i0 PRJNA312899 52016 240 1.958115 4.699476 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0497   NR KAL4465090.1 5901 g51574 i0 57.9 0.475 38 16 47.5 0 185 72 672 709 KAL4465090.1 hypothetical protein ABPG73_022587 [Tetrahymena malaccensis] diamond 114 42.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
31465021 31465021 PRJNA312899_P_NODE_8656_length_641_cov_10.849662_g8269_i0 PRJNA312899 8656 641 10.849662 69.54633342 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 101 4.36e-22   NR XP_001030690.2 312017 g8269 i0 31.6 0.96411856474259 206 133 94.1 4 33 635 54 256 XP_001030690.2 signal recognition particle receptor beta subunit [Tetrahymena thermophila SB210] diamond 618 101 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31591472 31591472 PRJNA312899_P_NODE_40676_length_279_cov_36.730435_g40234_i0 PRJNA312899 40676 279 36.730435 102.47791365 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 67 1.7e-10   NR XP_001017364.2 312017 g40234 i0 66.7 0.612903225806452 57 19 61.3 0 80 250 380 436 XP_001017364.2 hypothetical protein TTHERM_00476560 [Tetrahymena thermophila SB210] diamond 171 67 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31622862 31622862 PRJNA312899_P_NODE_47016_length_256_cov_1.971014_g46574_i0 PRJNA312899 47016 256 1.971014 5.04579584 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.43e-11   NR CDW88269.1 5949 g46574 i0 39.5 1.98046875 86 49 97.3 1 1 249 108 193 CDW88269.1 atpase type 13a2 isoform 3 [Stylonychia lemnae] diamond 507 69.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32034202 32034202 PRJNA312899_P_NODE_25138_length_372_cov_91.126935_g24696_i0 PRJNA312899 25138 372 91.126935 338.9921982 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 103 8.269999999999999e-23   NR KAL4440764.1 5901 g24696 i0 56.2 0.717741935483871 89 39 71.8 0 2 268 2147 2235 KAL4440764.1 hypothetical protein ABPG74_013745 [Tetrahymena malaccensis] diamond 267 103 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32287631 32287631 PRJNA312899_P_NODE_60259_length_217_cov_2.428571_g59817_i0 PRJNA312899 60259 217 2.428571 5.26999907 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 57 2.56e-7   NR OCB06975.1 312017 g59817 i0 49.1 0.788018433179724 57 28 77.4 1 34 201 398 454 OCB06975.1 piggyBac transposase [Tetrahymena thermophila SB210] diamond 171 57 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32477336 32477336 PRJNA312899_P_NODE_88139_length_166_cov_1.743590_g87697_i0 PRJNA312899 88139 166 1.74359 2.8943594 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 68.2 1.36e-11   NR KAL4460894.1 5901 g87697 i0 57.4 3.90361445783133 54 23 97.6 0 164 3 368 421 KAL4460894.1 hypothetical protein ABPG74_016366 [Tetrahymena malaccensis] diamond 648 68.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32823961 32823961 PRJNA312899_P_NODE_29440_length_340_cov_23.481100_g28998_i0 PRJNA312899 29440 340 23.4811 79.83574 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 88.2 1.33e-17   NR KRW99001.1 266149 g28998 i0 64.1 1.08529411764706 64 23 56.5 0 51 242 1312 1375 KRW99001.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 369 88.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus

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