RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA792582 · 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
27094547 27094547 PRJNA792582_P_NODE_47042_length_258_cov_2.021622_g46228_i0 PRJNA792582 47042 258 2.021622 5.21578476 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 85.9 2.59e-17   NR XP_004036452.1 5932 g46228 i0 59.4 2.02325581395349 64 26 74.4 0 248 57 100 163 XP_004036452.1 MORN repeat protein [Ichthyophthirius multifiliis] diamond 522 85.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27116748 27116748 PRJNA792582_P_NODE_36522_length_287_cov_1.252336_g35708_i0 PRJNA792582 36522 287 1.252336 3.59420432 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 68.9 3.83e-11   NR XP_001011416.1 312017 g35708 i0 41.1 2.97909407665505 95 55 99.3 1 286 2 502 595 XP_001011416.1 LBP/BPI/CETP family, carboxy-terminal domain protein [Tetrahymena thermophila SB210] diamond 855 68.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28105102 28105102 PRJNA792582_P_NODE_52785_length_248_cov_0.880000_g51971_i0 PRJNA792582 52785 248 0.88 2.1824 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 52.4 6.82e-6   NR 2XZN_D 5911 g51971 i0 100 0.604838709677419 25 0 30.2 0 2 76 157 181 2XZN_D Chain D, Ribosomal Protein S4 Containing Protein [Tetrahymena thermophila] diamond 150 52.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28475001 28475001 PRJNA792582_P_NODE_52606_length_248_cov_0.880000_g51792_i0 PRJNA792582 52606 248 0.88 2.1824 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00454   NR XP_001025192.2 312017 g51792 i0 95.2 0.254032258064516 21 1 25.4 0 246 184 308 328 XP_001025192.2 multidrug resistance protein-like transporter family ABC domain protein [Tetrahymena thermophila SB210] diamond 63 45.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28633051 28633051 PRJNA792582_P_NODE_49607_length_251_cov_1.297753_g48793_i0 PRJNA792582 49607 251 1.297753 3.25736003 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 63.5 1.9e-9   NR XP_001032114.1 312017 g48793 i0 46.3 0.645418326693227 54 28 63.3 1 166 8 46 99 XP_001032114.1 ser/thr phosphatase family protein [Tetrahymena thermophila SB210] diamond 162 63.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28664468 28664468 PRJNA792582_P_NODE_54447_length_246_cov_0.890173_g53633_i0 PRJNA792582 54447 246 0.890173 2.18982558 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 109 1.04e-25   NR CDW88360.1 5949 g53633 i0 83.9 0.75609756097561 62 10 75.6 0 59 244 848 909 CDW88360.1 UNKNOWN [Stylonychia lemnae] diamond 186 109 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29169726 29169726 PRJNA792582_P_NODE_42269_length_272_cov_1.160804_g41455_i0 PRJNA792582 42269 272 1.160804 3.15738688 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 137 2.32e-37   NR XP_001011598.2 312017 g41455 i0 74.4 0.992647058823529 90 23 99.3 0 2 271 171 260 XP_001011598.2 60S ribosomal protein L5 [Tetrahymena thermophila SB210] diamond 270 137 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29201299 29201299 PRJNA792582_P_NODE_50889_length_250_cov_0.870056_g50075_i0 PRJNA792582 50889 250 0.870056 2.17514 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 84.3 8.84e-17   NR XP_001006957.1 312017 g50075 i0 66.7 0.792 66 19 79.2 2 51 248 49 111 XP_001006957.1 hypothetical protein TTHERM_00197760 [Tetrahymena thermophila SB210] diamond 198 84.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29485044 29485044 PRJNA792582_P_NODE_49930_length_251_cov_0.865169_g49116_i0 PRJNA792582 49930 251 0.865169 2.17157419 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 81.6 3.03e-16   NR XP_001023543.1 312017 g49116 i0 58 0.824701195219124 69 29 82.5 0 223 17 53 121 XP_001023543.1 short chain dehydrogenase reductase family protein, putative [Tetrahymena thermophila SB210] diamond 207 81.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29611304 29611304 PRJNA792582_P_NODE_52950_length_248_cov_0.880000_g52136_i0 PRJNA792582 52950 248 0.88 2.1824 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 84.7 6.67e-17   NR XP_004032275.1 5932 g52136 i0 52.4 0.991935483870968 82 39 99.2 0 3 248 593 674 XP_004032275.1 hypothetical protein IMG5_125790 [Ichthyophthirius multifiliis] diamond 246 84.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29715193 29715193 PRJNA792582_P_NODE_58570_length_242_cov_0.911243_g57756_i0 PRJNA792582 58570 242 0.911243 2.20520806 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 57.8 1.9e-7   NR XP_001025493.2 312017 g57756 i0 53.1 1.7603305785124 49 23 60.7 0 5 151 307 355 XP_001025493.2 hypothetical protein TTHERM_01364620 [Tetrahymena thermophila SB210] diamond 426 57.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29990657 29990657 PRJNA792582_P_NODE_58411_length_242_cov_0.911243_g57597_i0 PRJNA792582 58411 242 0.911243 2.20520806 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 99 3.43e-22   NR XP_001013093.1 312017 g57597 i0 91.7 0.59504132231405 48 4 59.5 0 144 1 319 366 XP_001013093.1 DegT/DnrJ/EryC1/StrS aminotransferase family protein [Tetrahymena thermophila SB210] diamond 144 99 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30275225 30275225 PRJNA792582_P_NODE_53132_length_248_cov_0.880000_g52318_i0 PRJNA792582 53132 248 0.88 2.1824 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 105 3.34e-24   NR QBH22565.1 282688 g52318 i0 55.2 2.33467741935484 96 27 96.8 1 2 241 75 170 QBH22565.1 E1-E2 ATPase [Philasterides dicentrarchi] diamond 579 105 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
30307066 30307066 PRJNA792582_P_NODE_58552_length_242_cov_0.911243_g57738_i0 PRJNA792582 58552 242 0.911243 2.20520806 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00165   NR XP_001014851.2 312017 g57738 i0 42.3 0.644628099173554 52 29 63.2 1 198 46 871 922 XP_001014851.2 GTPase-activator protein for Ras-like GTPase [Tetrahymena thermophila SB210] diamond 156 46.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30401803 30401803 PRJNA792582_P_NODE_50073_length_251_cov_0.865169_g49259_i0 PRJNA792582 50073 251 0.865169 2.17157419 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 84 1.29e-16   NR XP_001011102.2 312017 g49259 i0 90.7 0.51394422310757 43 4 51.4 0 250 122 789 831 XP_001011102.2 protein kinase [Tetrahymena thermophila SB210] diamond 129 84 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30717158 30717158 PRJNA792582_P_NODE_52014_length_249_cov_0.875000_g51200_i0 PRJNA792582 52014 249 0.875 2.17875 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 58.2 4.75e-8   NR XP_012655284.1 312017 g51200 i0 46.3 0.963855421686747 80 41 96.4 2 241 2 1 78 XP_012655284.1 glutaredoxin-like protein [Tetrahymena thermophila SB210] diamond 240 58.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32677305 32677305 PRJNA792582_P_NODE_55720_length_245_cov_0.895349_g54906_i0 PRJNA792582 55720 245 0.895349 2.19360505 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 53.9 4.52e-6   NR KRX05725.1 266149 g54906 i0 37.2 0.955102040816327 78 48 95.5 1 237 4 21 97 KRX05725.1 WD40-repeat-containing domain [Pseudocohnilembus persalinus] diamond 234 53.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32771897 32771897 PRJNA792582_P_NODE_58040_length_242_cov_1.727811_g57226_i0 PRJNA792582 58040 242 1.727811 4.18130262 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 155 3.8e-42   NR XP_001012338.1 312017 g57226 i0 93.4 0.942148760330578 76 5 94.2 0 14 241 203 278 XP_001012338.1 glycyl-tRNA synthetase protein [Tetrahymena thermophila SB210] diamond 228 155 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32897777 32897777 PRJNA792582_P_NODE_48520_length_254_cov_1.541436_g47706_i0 PRJNA792582 48520 254 1.541436 3.91524744 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.03e-7   NR XP_001033013.2 312017 g47706 i0 86.2 0.34251968503937 29 4 34.3 0 2 88 72 100 XP_001033013.2 DnaJ (Hsp40) family B protein [Tetrahymena thermophila SB210] diamond 87 58.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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