RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA382357", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA382357 · 15 ✖

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
8056328 8056328 PRJNA382357_P_NODE_157847_length_199_cov_4.079710_g157108_i0 PRJNA382357 157847 199 4.07971 8.1186229 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 274 3.3899999999999997e-69   NTclustered gi|2651357788|gb|PP174303.1| 41631 g157108 i0 94.857 47.3266331658291 175 9 88 0 1 175 3378 3552 Colpoda sp. isolate CIL1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 9418 274 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
10607542 10607542 PRJNA382357_P_NODE_38649_length_368_cov_1.752443_g37910_i0 PRJNA382357 38649 368 1.752443 6.44899024 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 490 6.25e-134   NTclustered gi|2651357788|gb|PP174303.1| 41631 g37910 i0 92.92 55.6576086956522 339 20 98 4 1 337 4028 3692 Colpoda sp. isolate CIL1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 20482 490 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
15706597 15706597 PRJNA382357_P_NODE_45993_length_341_cov_1.553571_g45254_i0 PRJNA382357 45993 341 1.553571 5.29767711 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.032   NTclustered gi|829198867|ref|XM_012800951.1| 312017 g45254 i0 100 0.0821114369501466 28 0 8 0 204 231 338 365 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
22752460 22752460 PRJNA382357_P_NODE_9238_length_680_cov_4.907916_g8545_i0 PRJNA382357 9238 680 4.907916 33.3738288 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 451 5.720000000000001e-122   NTclustered gi|1802599794|gb|MT001203.1| 41631 g8545 i0 98.814 94.3117647058824 253 3 95 0 22 274 1311 1563 Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence blastn 64132 451 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
23354453 23354453 PRJNA382357_P_NODE_106999_length_235_cov_1.281609_g106260_i0 PRJNA382357 106999 235 1.281609 3.01178115 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 80.5 9.66e-11   NTclustered gi|2386233158|ref|XM_001434382.2| 5888 g106260 i0 85.714 0.65531914893617 77 9 33 2 123 199 113 39 Paramecium tetraurelia uncharacterized protein (GSPATT00036153001), mRNA blastn 154 80.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
27534450 27534450 PRJNA382357_P_NODE_21263_length_480_cov_1.286396_g20528_i0 PRJNA382357 21263 480 1.286396 6.1747008 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 83.6 2.81e-15   NR CAI2382949.1 5936 g20528 i0 31.6 8.18125 174 105 100 5 480 1 492 665 CAI2382949.1 unnamed protein product [Moneuplotes crassus] diamond 3927 84.3 0.991696322657177 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
27644000 27644000 PRJNA382357_P_NODE_65744_length_291_cov_1.452174_g65005_i0 PRJNA382357 65744 291 1.452174 4.22582634 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 67 1.9e-10   NR XP_004032250.1 5932 g65005 i0 57.4 0.556701030927835 54 21 55.7 1 102 263 202 253 XP_004032250.1 WD repeat protein [Ichthyophthirius multifiliis] diamond 162 67 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
28149024 28149024 PRJNA382357_P_NODE_116485_length_226_cov_1.575758_g115746_i0 PRJNA382357 116485 226 1.575758 3.56121308 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 57 2.77e-7   NR XP_001019602.2 312017 g115746 i0 70.6 0.451327433628319 34 10 45.1 0 224 123 1439 1472 XP_001019602.2 carrier protein [Tetrahymena thermophila SB210] diamond 102 57 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28260431 28260431 PRJNA382357_P_NODE_2506_length_1153_cov_1.302198_g2011_i0 PRJNA382357 2506 1153 1.302198 15.01434294 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 87.4 3.87e-16   NR KAL4502019.1 5901 g2011 i0 38.1 0.967909800520382 134 76 34.3 3 5 400 19 147 KAL4502019.1 hypothetical protein ABPG73_020156 [Tetrahymena malaccensis] diamond 1116 88.2 0.99092970521542 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30359891 30359891 PRJNA382357_P_NODE_143692_length_207_cov_0.890411_g142953_i0 PRJNA382357 143692 207 0.890411 1.84315077 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 81.6 4.48e-16   NR CAI2386982.1 5936 g142953 i0 85.7 0.608695652173913 42 6 60.9 0 187 62 65 106 CAI2386982.1 unnamed protein product [Moneuplotes crassus] diamond 126 81.6 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
30692258 30692258 PRJNA382357_P_NODE_100133_length_242_cov_1.436464_g99394_i0 PRJNA382357 100133 242 1.436464 3.47624288 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.79e-4   NR ABI23727.1 184062 g99394 i0 37.9 2.16942148760331 58 33 68.2 1 74 238 38 95 ABI23727.1 heat shock protein 70 [Euplotes nobilii] diamond 525 49.7 0.991951710261569 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes nobilii
31054824 31054824 PRJNA382357_P_NODE_16195_length_539_cov_4.012552_g15469_i0 PRJNA382357 16195 539 4.012552 21.62765528 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 183 3.0199999999999996e-54   NR CDW76239.1 5949 g15469 i0 51.1 1.83116883116883 180 80 96.8 4 5 526 80 257 CDW76239.1 UNKNOWN [Stylonychia lemnae] diamond 987 183 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31703919 31703919 PRJNA382357_P_NODE_8637_length_700_cov_1.427230_g7952_i0 PRJNA382357 8637 700 1.42723 9.99061 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.0314   NR CAD8109018.1 65129 g7952 i0 28.3 0.887142857142857 120 75 49.7 4 1 348 338 450 CAD8109018.1 unnamed protein product [Paramecium sonneborni] diamond 621 47.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
31925318 31925318 PRJNA382357_P_NODE_76217_length_273_cov_1.094340_g75478_i0 PRJNA382357 76217 273 1.09434 2.9875482 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00225   NR OMJ79067.1 5963 g75478 i0 31.3 1.98901098901099 48 33 52.7 0 64 207 108 155 OMJ79067.1 hypothetical protein SteCoe_20965 [Stentor coeruleus] diamond 543 47 0.991489361702128 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32635490 32635490 PRJNA382357_P_NODE_118540_length_224_cov_3.000000_g117801_i0 PRJNA382357 118540 224 3 6.72 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 58.5 8.03e-8   NR KRX02935.1 266149 g117801 i0 67.4 0.575892857142857 43 13 56.3 1 128 3 2759 2801 KRX02935.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 129 58.5 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);;