RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA682774" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA682774 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
22341957 22341957 PRJNA682774_P_NODE_4938_length_244_cov_2.801170_g4909_i0 PRJNA682774 4938 244 2.80117 6.8348548 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 139 6.76e-37   NR XP_001022267.1 312017 g4909 i0 92.3 0.799180327868853 65 5 79.9 0 1 195 213 277 XP_001022267.1 calcium-dependent kinase [Tetrahymena thermophila SB210] diamond 195 139 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26829116 26829116 PRJNA682774_P_NODE_5421_length_242_cov_0.923077_g5392_i0 PRJNA682774 5421 242 0.923077 2.23384634 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 105 3.0799999999999994e-24   NR XP_001018440.1 312017 g5392 i0 83.6 0.681818181818182 55 9 68.2 0 3 167 1205 1259 XP_001018440.1 hypothetical protein TTHERM_00343950 [Tetrahymena thermophila SB210] diamond 165 105 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27050592 27050592 PRJNA682774_P_NODE_5202_length_243_cov_0.917647_g5173_i0 PRJNA682774 5202 243 0.917647 2.22988221 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 149 2.07e-41   NR XP_001018531.2 312017 g5173 i0 90.9 0.950617283950617 77 7 95.1 0 13 243 1 77 XP_001018531.2 serine carboxypeptidase family protein [Tetrahymena thermophila SB210] diamond 231 149 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27398335 27398335 PRJNA682774_P_NODE_4783_length_245_cov_1.319767_g4754_i0 PRJNA682774 4783 245 1.319767 3.23342915 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 110 1.29e-29   NR 2XZN_Z 5911 g4754 i0 83.9 0.759183673469388 62 10 75.9 0 58 243 1 62 2XZN_Z Chain Z, Rps21e [Tetrahymena thermophila] diamond 186 110 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27430040 27430040 PRJNA682774_P_NODE_4603_length_246_cov_1.260116_g4574_i0 PRJNA682774 4603 246 1.260116 3.09988536 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 53.5 5.76e-6   NR CAD8062869.1 5886 g4574 i0 40.6 1.68292682926829 69 40 84.1 1 246 40 162 229 CAD8062869.1 unnamed protein product [Paramecium primaurelia] diamond 414 53.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27840028 27840028 PRJNA682774_P_NODE_5244_length_243_cov_0.917647_g5215_i0 PRJNA682774 5244 243 0.917647 2.22988221 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 63.9 1.27e-9   NR XP_001025131.1 312017 g5215 i0 59.6 0.580246913580247 47 19 58 0 8 148 1061 1107 XP_001025131.1 E1-E2 ATPase family protein [Tetrahymena thermophila SB210] diamond 141 63.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28818712 28818712 PRJNA682774_P_NODE_4228_length_248_cov_1.914286_g4199_i0 PRJNA682774 4228 248 1.914286 4.74742928 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 88.6 2.99e-18   NR XP_001025513.2 312017 g4199 i0 60.6 0.858870967741935 71 25 82.3 1 39 242 617 687 XP_001025513.2 AT hook motif protein [Tetrahymena thermophila SB210] diamond 213 88.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28945588 28945588 PRJNA682774_P_NODE_2548_length_288_cov_1.088372_g2519_i0 PRJNA682774 2548 288 1.088372 3.13451136 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 174 1.54e-51   NR KAL4497158.1 2486642 g2519 i0 87.4 2.96875 95 12 99 0 286 2 135 229 KAL4497158.1 hypothetical protein ABPG72_019478 [Tetrahymena utriculariae] diamond 855 174 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
29513476 29513476 PRJNA682774_P_NODE_1830_length_331_cov_1.875969_g1801_i0 PRJNA682774 1830 331 1.875969 6.20945739 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 124 6.94e-32   NR XP_001007252.1 312017 g1801 i0 62.1 0.933534743202417 103 38 92.4 1 307 2 1 103 XP_001007252.1 peroxidase, putative [Tetrahymena thermophila SB210] diamond 309 124 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30081968 30081968 PRJNA682774_P_NODE_2492_length_290_cov_1.437788_g2463_i0 PRJNA682774 2492 290 1.437788 4.1695852 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 52 1.1e-5   NR XP_012651583.1 312017 g2463 i0 42.9 1.76896551724138 77 38 78.6 2 27 254 82 153 XP_012651583.1 hypothetical protein TTHERM_000559961 [Tetrahymena thermophila SB210] diamond 513 52 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30303777 30303777 PRJNA682774_P_NODE_3212_length_260_cov_1.251337_g3183_i0 PRJNA682774 3212 260 1.251337 3.2534762 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 50.8 2.88e-5   NR OMJ89086.1 5963 g3183 i0 47.7 0.507692307692308 44 23 50.8 0 138 7 14 57 OMJ89086.1 hypothetical protein SteCoe_8807 [Stentor coeruleus] diamond 132 50.8 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30430056 30430056 PRJNA682774_P_NODE_2033_length_316_cov_1.057613_g2004_i0 PRJNA682774 2033 316 1.057613 3.34205708 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 67.8 1.27e-10   NR XP_001022598.3 312017 g2004 i0 80.4 0.436708860759494 46 9 43.7 0 139 2 146 191 XP_001022598.3 granule lattice protein [Tetrahymena thermophila SB210] diamond 138 67.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30555861 30555861 PRJNA682774_P_NODE_1113_length_410_cov_1.848665_g1084_i0 PRJNA682774 1113 410 1.848665 7.5795265 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 115 8.25e-28   NR KAL4480407.1 5901 g1084 i0 64.7 0.621951219512195 85 30 62.2 0 38 292 139 223 KAL4480407.1 hypothetical protein ABPG74_020923 [Tetrahymena malaccensis] diamond 255 115 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30587507 30587507 PRJNA682774_P_NODE_733_length_503_cov_2.420930_g704_i0 PRJNA682774 733 503 2.42093 12.1772779 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 112 5.15e-28   NR OMJ65919.1 5963 g704 i0 54.5 0.656063618290258 110 50 65.6 0 2 331 14 123 OMJ65919.1 hypothetical protein SteCoe_37428 [Stentor coeruleus] diamond 330 112 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30935313 30935313 PRJNA682774_P_NODE_2474_length_291_cov_1.201835_g2445_i0 PRJNA682774 2474 291 1.201835 3.49733985 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.86e-22   NR XP_001016195.2 312017 g2445 i0 80.4 0.525773195876289 51 10 52.6 0 153 1 1 51 XP_001016195.2 Ctr copper transporter family protein [Tetrahymena thermophila SB210] diamond 153 94.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31030248 31030248 PRJNA682774_P_NODE_715_length_509_cov_2.137615_g686_i0 PRJNA682774 715 509 2.137615 10.88046035 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.03e-9   NR XP_001016890.1 312017 g686 i0 48.2 0.489194499017682 83 37 45.4 3 462 232 1 83 XP_001016890.1 cell surface immobilization antigen SerH6, putative [Tetrahymena thermophila SB210] diamond 249 63.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31093195 31093195 PRJNA682774_P_NODE_4955_length_244_cov_1.479532_g4926_i0 PRJNA682774 4955 244 1.479532 3.61005808 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 157 3.81e-45   NR XP_001008408.1 312017 g4926 i0 93.8 0.983606557377049 80 5 98.4 0 1 240 222 301 XP_001008408.1 zinc-binding dehydrogenase family oxidoreductase [Tetrahymena thermophila SB210] diamond 240 157 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31800333 31800333 PRJNA682774_P_NODE_4297_length_248_cov_0.891429_g4268_i0 PRJNA682774 4297 248 0.891429 2.21074392 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 90.5 3.5e-19   NR XP_001433935.1 5888 g4268 i0 48.8 2.9758064516129 82 42 99.2 0 248 3 118 199 XP_001433935.1 uncharacterized protein GSPATT00035667001 [Paramecium tetraurelia] diamond 738 90.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32211965 32211965 PRJNA682774_P_NODE_658_length_534_cov_1.351410_g629_i0 PRJNA682774 658 534 1.35141 7.2165294 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 253 1.78e-76   NR KAL4454916.1 5901 g629 i0 72.6 2.76404494382022 164 45 92.1 0 498 7 502 665 KAL4454916.1 hypothetical protein ABPG74_006298 [Tetrahymena malaccensis] diamond 1476 253 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32674117 32674117 PRJNA682774_P_NODE_5080_length_244_cov_0.912281_g5051_i0 PRJNA682774 5080 244 0.912281 2.22596564 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 57 3.62e-7   NR KAL4499127.1 2486642 g5051 i0 41.2 1.67213114754098 68 40 83.6 0 241 38 580 647 KAL4499127.1 hypothetical protein ABPG72_017029 [Tetrahymena utriculariae] diamond 408 57 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
32768666 32768666 PRJNA682774_P_NODE_4920_length_245_cov_0.906977_g4891_i0 PRJNA682774 4920 245 0.906977 2.22209365 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00238   NR KAL4454019.1 5901 g4891 i0 46.2 0.477551020408163 39 21 47.8 0 128 244 5275 5313 KAL4454019.1 hypothetical protein ABPG74_003902 [Tetrahymena malaccensis] diamond 117 46.2 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);;