RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1041773" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA1041773 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
26591748 26591748 PRJNA1041773_P_NODE_103421_length_234_cov_4.913043_g103088_i0 PRJNA1041773 103421 234 4.913043 11.49652062 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 50.8 4.7e-5   NR CDW75723.1 5949 g103088 i0 85.7 0.358974358974359 28 4 35.9 0 5 88 29 56 CDW75723.1 UNKNOWN [Stylonychia lemnae] diamond 84 50.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27540862 27540862 PRJNA1041773_P_NODE_96024_length_243_cov_0.905882_g95691_i0 PRJNA1041773 96024 243 0.905882 2.20129326 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 72 1.82e-12   NR CDW82914.1 5949 g95691 i0 54.2 0.728395061728395 59 27 72.8 0 184 8 1146 1204 CDW82914.1 leucine rich repeat family protein [Stylonychia lemnae] diamond 177 72 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27887961 27887961 PRJNA1041773_P_NODE_32865_length_366_cov_1.051195_g32533_i0 PRJNA1041773 32865 366 1.051195 3.8473737 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 159 1.15e-46   NR KRX03681.1 266149 g32533 i0 62.2 0.975409836065574 119 45 97.5 0 3 359 74 192 KRX03681.1 hypothetical protein PPERSA_10365 [Pseudocohnilembus persalinus] diamond 357 159 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
28100927 28100927 PRJNA1041773_P_NODE_96985_length_243_cov_0.905882_g96652_i0 PRJNA1041773 96985 243 0.905882 2.20129326 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 63.9 1.29e-9   NR CAD8063047.1 5886 g96652 i0 44.3 1.91358024691358 79 41 93.8 1 228 1 119 197 CAD8063047.1 unnamed protein product [Paramecium primaurelia] diamond 465 63.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
28456562 28456562 PRJNA1041773_P_NODE_87326_length_247_cov_0.885057_g86993_i0 PRJNA1041773 87326 247 0.885057 2.18609079 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 65.9 2.94e-10   NR KRW98533.1 266149 g86993 i0 41.4 1.7004048582996 70 38 85 1 7 216 4199 4265 KRW98533.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 420 65.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
28993465 28993465 PRJNA1041773_P_NODE_102128_length_240_cov_2.532934_g101795_i0 PRJNA1041773 102128 240 2.532934 6.0790416 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 62.4 4.31e-9   NR CDW81820.1 5949 g101795 i0 65.9 0.55 44 15 55 0 162 31 22 65 CDW81820.1 UNKNOWN [Stylonychia lemnae] diamond 132 62.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29308827 29308827 PRJNA1041773_P_NODE_78769_length_251_cov_0.865169_g78436_i0 PRJNA1041773 78769 251 0.865169 2.17157419 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 126 1.3199999999999999e-31   NR CDW79563.1 5949 g78436 i0 72.3 0.99203187250996006 83 23 99.2 0 251 3 3427 3509 CDW79563.1 dynein heavy chain family protein [Stylonychia lemnae] diamond 249 126 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29561357 29561357 PRJNA1041773_P_NODE_81870_length_249_cov_0.875000_g81537_i0 PRJNA1041773 81870 249 0.875 2.17875 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00252   NR CDW86285.1 5949 g81537 i0 41.7 0.867469879518072 72 38 81.9 2 46 249 591 662 CDW86285.1 ef hand family protein [Stylonychia lemnae] diamond 216 46.2 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29561359 29561359 PRJNA1041773_P_NODE_93290_length_244_cov_0.900585_g92957_i0 PRJNA1041773 93290 244 0.900585 2.1974274 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 68.6 2.98e-11   NR XP_004037565.1 5932 g92957 i0 45.6 0.836065573770492 68 35 81.1 1 27 224 627 694 XP_004037565.1 neutral sphingomyelinase activation associated factor, putative [Ichthyophthirius multifiliis] diamond 204 68.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30035305 30035305 PRJNA1041773_P_NODE_91771_length_245_cov_0.895349_g91438_i0 PRJNA1041773 91771 245 0.895349 2.19360505 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 104 8.06e-24   NR CAG9315626.1 1481888 g91438 i0 54.8 6.25714285714286 73 33 89.4 0 1 219 444 516 CAG9315626.1 unnamed protein product [Blepharisma stoltei] diamond 1533 104 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30161361 30161361 PRJNA1041773_P_NODE_80552_length_250_cov_0.870056_g80219_i0 PRJNA1041773 80552 250 0.870056 2.17514 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 133 4.92e-34   NR CDW74983.1 5949 g80219 i0 74.7 0.996 83 21 99.6 0 249 1 2094 2176 CDW74983.1 dynein heavy chain [Stylonychia lemnae] diamond 249 133 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31014663 31014663 PRJNA1041773_P_NODE_56315_length_287_cov_1.439252_g55982_i0 PRJNA1041773 56315 287 1.439252 4.13065324 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 73.9 6.91e-13   NR CDW89348.1 5949 g55982 i0 41.1 0.993031358885017 95 56 99.3 0 1 285 466 560 CDW89348.1 k antiporter p-type alpha subunit family protein [Stylonychia lemnae] diamond 285 73.9 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31267532 31267532 PRJNA1041773_P_NODE_96395_length_243_cov_0.905882_g96062_i0 PRJNA1041773 96395 243 0.905882 2.20129326 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 47.8 6.42e-4   NR CDW71246.1 5949 g96062 i0 54.2 0.592592592592593 48 19 59.3 2 241 98 65 109 CDW71246.1 UNKNOWN [Stylonychia lemnae] diamond 144 47.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31362557 31362557 PRJNA1041773_P_NODE_74916_length_254_cov_1.701657_g74583_i0 PRJNA1041773 74916 254 1.701657 4.32220878 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 99 7.27e-22   NR CAD8090783.1 65129 g74583 i0 66.7 0.779527559055118 66 22 78 0 254 57 1013 1078 CAD8090783.1 unnamed protein product [Paramecium sonneborni] diamond 198 99 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
32153293 32153293 PRJNA1041773_P_NODE_80138_length_250_cov_0.870056_g79805_i0 PRJNA1041773 80138 250 0.870056 2.17514 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 53.5 2.01e-6   NR TNV71346.1 5974 g79805 i0 49.3 0.852 71 29 81.6 2 206 3 70 136 TNV71346.1 hypothetical protein FGO68_gene4565 [Halteria grandinella] diamond 213 53.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
32406449 32406449 PRJNA1041773_P_NODE_85219_length_248_cov_0.880000_g84886_i0 PRJNA1041773 85219 248 0.88 2.1824 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 77 3.37e-14   NR AEX87960.1 94289 g84886 i0 46.2 1.1008064516129 91 40 99.2 2 248 3 28 118 AEX87960.1 Otiwi10 [Sterkiella histriomuscorum] diamond 273 77 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
32461701 32461701 PRJNA1041773_P_NODE_94679_length_244_cov_0.900585_g94346_i0 PRJNA1041773 94679 244 0.900585 2.1974274 Sporadotrichida 693921 SAR_Eukaryotes SAR_Eukaryotes 107 6.49e-25   NR CDW88015.1 5949 g94346 i0 64 1.86885245901639 75 27 92.2 0 3 227 147 221 CDW88015.1 inosine triphosphate pyrophosphatase-like [Stylonychia lemnae] diamond 456 107 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32525232 32525232 PRJNA1041773_P_NODE_76539_length_252_cov_1.251397_g76206_i0 PRJNA1041773 76539 252 1.251397 3.15352044 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 54.7 2.71e-6   NR CAD8057213.1 5886 g76206 i0 26.2 11.047619047619 84 62 100 0 252 1 181 264 CAD8057213.1 unnamed protein product, partial [Paramecium primaurelia] diamond 2784 55.1 0.992740471869329 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
32879381 32879381 PRJNA1041773_P_NODE_84380_length_248_cov_0.880000_g84047_i0 PRJNA1041773 84380 248 0.88 2.1824 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 67.8 1.4e-12   NR AAZ23857.1 94289 g84047 i0 67.3 0.592741935483871 49 16 59.3 0 6 152 44 92 AAZ23857.1 ribosomal protein L37 [Sterkiella histriomuscorum] diamond 147 67.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum

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