RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA473641 · 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
8098009 8098009 PRJNA473641_P_NODE_16907_length_251_cov_2.022472_g16824_i0 PRJNA473641 16907 251 2.022472 5.07640472 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 87.8 8.42e-21   NR CAD8069261.1 5886 g16824 i0 70.3 2.28286852589641 64 19 76.5 0 28 219 1 64 CAD8069261.1 unnamed protein product [Paramecium primaurelia] diamond 573 87.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
26727579 26727579 PRJNA473641_P_NODE_17761_length_250_cov_1.926554_g17678_i0 PRJNA473641 17761 250 1.926554 4.816385 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 48.9 5.87e-5   NR KAL4426775.1 5901 g17678 i0 42 0.6 50 28 60 1 155 6 55 103 KAL4426775.1 hypothetical protein ABPG74_006572 [Tetrahymena malaccensis] diamond 150 48.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
26949523 26949523 PRJNA473641_P_NODE_22702_length_245_cov_0.895349_g22619_i0 PRJNA473641 22702 245 0.895349 2.19360505 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 88.2 1.71e-18   NR KRX03899.1 266149 g22619 i0 60.6 1.61632653061224 66 25 79.6 1 243 49 230 295 KRX03899.1 Protein kinase-like domain [Pseudocohnilembus persalinus] diamond 396 88.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
28307984 28307984 PRJNA473641_P_NODE_23366_length_244_cov_0.900585_g23283_i0 PRJNA473641 23366 244 0.900585 2.1974274 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 166 9.52e-50   NR BAF38023.1 153251 g23283 i0 97.5 0.983606557377049 80 2 98.4 0 242 3 39 118 BAF38023.1 elongation factor-1 alpha isoform-3, partial [Cryptocaryon irritans] diamond 240 166 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
29129067 29129067 PRJNA473641_P_NODE_4629_length_419_cov_2.312139_g4546_i0 PRJNA473641 4629 419 2.312139 9.68786241 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.0168   NR XP_004036836.1 5932 g4546 i0 44.2 0.372315035799523 52 29 37.2 0 50 205 20 71 XP_004036836.1 nucleosome assembly protein, putative [Ichthyophthirius multifiliis] diamond 156 45.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29760150 29760150 PRJNA473641_P_NODE_16171_length_258_cov_0.935135_g16088_i0 PRJNA473641 16171 258 0.935135 2.4126483 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00268   NR XP_004037463.1 5932 g16088 i0 39.7 0.674418604651163 58 34 66.3 1 258 88 367 424 XP_004037463.1 hypothetical protein IMG5_051550 [Ichthyophthirius multifiliis] diamond 174 46.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30013127 30013127 PRJNA473641_P_NODE_2851_length_508_cov_2.581609_g2768_i0 PRJNA473641 2851 508 2.581609 13.11457372 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 96.7 5.36e-22   NR XP_001023601.1 312017 g2768 i0 77.4 0.720472440944882 62 13 36.6 1 241 56 89 149 XP_001023601.1 tubulin polymerization-promoting family protein [Tetrahymena thermophila SB210] diamond 366 96.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30597716 30597716 PRJNA473641_P_NODE_5153_length_401_cov_2.009146_g5070_i0 PRJNA473641 5153 401 2.009146 8.05667546 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.07e-21   NR CDW83169.1 5949 g5070 i0 45.8 1.54114713216958 107 58 80 0 362 42 9 115 CDW83169.1 UNKNOWN [Stylonychia lemnae] diamond 618 94.4 0.991525423728813 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30834468 30834468 PRJNA473641_P_NODE_21674_length_246_cov_0.890173_g21591_i0 PRJNA473641 21674 246 0.890173 2.18982558 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 87.8 1.98e-19   NR KRX00193.1 266149 g21591 i0 60.6 1.59756097560976 66 25 79.3 1 1 195 102 167 KRX00193.1 Zinc-binding ribosomal protein [Pseudocohnilembus persalinus] diamond 393 87.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30992536 30992536 PRJNA473641_P_NODE_5934_length_380_cov_1.469055_g5851_i0 PRJNA473641 5934 380 1.469055 5.582409 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 192 3.38e-57   NR XP_001448309.1 5888 g5851 i0 87.5 33.1026315789474 104 13 82.1 0 68 379 258 361 XP_001448309.1 uncharacterized protein GSPATT00015771001 [Paramecium tetraurelia] diamond 12579 192 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
31103278 31103278 PRJNA473641_P_NODE_20835_length_247_cov_0.885057_g20752_i0 PRJNA473641 20835 247 0.885057 2.18609079 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 112 1.18e-26   NR AAG00568.1 5888 g20752 i0 79.1 12.2064777327935 67 14 81.4 0 3 203 407 473 AAG00568.1 heat shock protein 90, partial [Paramecium tetraurelia] diamond 3015 113 0.991150442477876 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
31483080 31483080 PRJNA473641_P_NODE_2256_length_560_cov_5.334702_g2174_i0 PRJNA473641 2256 560 5.334702 29.8743312 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 196 1.2e-60   NR XP_001025866.1 312017 g2174 i0 59.1 2.61964285714286 164 66 87.9 1 527 36 6 168 XP_001025866.1 translationally-controlled tumor-like protein [Tetrahymena thermophila SB210] diamond 1467 197 0.99492385786802 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31498465 31498465 PRJNA473641_P_NODE_24636_length_242_cov_0.911243_g24553_i0 PRJNA473641 24636 242 0.911243 2.20520806 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 100 4.419999999999999e-23   NR XP_004030844.1 5932 g24553 i0 67.6 1.83471074380165 74 24 91.7 0 2 223 100 173 XP_004030844.1 hypothetical protein IMG5_152090 [Ichthyophthirius multifiliis] diamond 444 100 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31735696 31735696 PRJNA473641_P_NODE_737_length_886_cov_4.313653_g672_i0 PRJNA473641 737 886 4.313653 38.21896558 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 61.6 1.1e-6   NR CAD8044952.1 5886 g672 i0 39.7 0.85665914221219 63 36 21.3 1 47 235 132 192 CAD8044952.1 unnamed protein product [Paramecium primaurelia] diamond 759 61.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
32131171 32131171 PRJNA473641_P_NODE_19998_length_248_cov_0.880000_g19915_i0 PRJNA473641 19998 248 0.88 2.1824 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.22e-7   NR XP_004027169.1 5932 g19915 i0 68.8 0.786290322580645 32 10 38.7 0 123 218 39 70 XP_004027169.1 hypothetical protein IMG5_188500 [Ichthyophthirius multifiliis] diamond 195 58.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32257907 32257907 PRJNA473641_P_NODE_10338_length_312_cov_1.221757_g10255_i0 PRJNA473641 10338 312 1.221757 3.81188184 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 59.7 8.38e-8   NR KRW99699.1 266149 g10255 i0 65.9 0.423076923076923 44 15 42.3 0 59 190 294 337 KRW99699.1 hypothetical protein PPERSA_03500 [Pseudocohnilembus persalinus] diamond 132 59.7 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);;