RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1182301" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA1182301 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
2317168 2317168 PRJNA1182301_P_NODE_62662_length_241_cov_1.833333_g62537_i0 PRJNA1182301 62662 241 1.833333 4.41833253 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 100 1.17e-24   NR CAD8113757.1 65129 g62537 i0 77.8 2.31535269709544 63 13 78.4 1 19 207 93 154 CAD8113757.1 unnamed protein product [Paramecium sonneborni] diamond 558 100 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
26977292 26977292 PRJNA1182301_P_NODE_67262_length_228_cov_2.509677_g67137_i0 PRJNA1182301 67262 228 2.509677 5.72206356 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 50.1 8.07e-5   NR XP_001017417.2 312017 g67137 i0 62.9 0.460526315789474 35 13 46.1 0 158 54 1260 1294 XP_001017417.2 ABC transporter family protein [Tetrahymena thermophila SB210] diamond 105 50.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27786491 27786491 PRJNA1182301_P_NODE_19344_length_290_cov_1.276498_g19219_i0 PRJNA1182301 19344 290 1.276498 3.7018442 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 62.4 6.41e-9   NR KAL4483175.1 5901 g19219 i0 66.7 1.30344827586207 42 14 43.4 0 243 118 201 242 KAL4483175.1 hypothetical protein ABPG74_019201 [Tetrahymena malaccensis] diamond 378 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28272186 28272186 PRJNA1182301_P_NODE_42266_length_259_cov_1.655914_g42141_i0 PRJNA1182301 42266 259 1.655914 4.28881726 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 90.5 1.06e-20   NR XP_001018316.1 312017 g42141 i0 97.4 0.451737451737452 39 1 45.2 0 61 177 124 162 XP_001018316.1 hypothetical protein TTHERM_00752170 [Tetrahymena thermophila SB210] diamond 117 90.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28683029 28683029 PRJNA1182301_P_NODE_61347_length_242_cov_1.751479_g61222_i0 PRJNA1182301 61347 242 1.751479 4.23857918 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.05e-6   NR CDW90280.1 5949 g61222 i0 86.2 0.359504132231405 29 4 36 0 240 154 265 293 CDW90280.1 ras-related gtp-binding protein c [Stylonychia lemnae] diamond 87 55.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28840628 28840628 PRJNA1182301_P_NODE_60308_length_243_cov_0.905882_g60183_i0 PRJNA1182301 60308 243 0.905882 2.20129326 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00203   NR XP_012654206.1 312017 g60183 i0 40.3 0.827160493827161 67 25 82.7 1 2 202 105 156 XP_012654206.1 hypothetical protein TTHERM_000599749 [Tetrahymena thermophila SB210] diamond 201 45.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29882888 29882888 PRJNA1182301_P_NODE_68311_length_213_cov_4.842857_g68186_i0 PRJNA1182301 68311 213 4.842857 10.31528541 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 60.1 1.88e-8   NR XP_001022599.2 312017 g68186 i0 85.3 0.47887323943662 34 5 47.9 0 1 102 344 377 XP_001022599.2 granule lattice protein [Tetrahymena thermophila SB210] diamond 102 60.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30325541 30325541 PRJNA1182301_P_NODE_59112_length_244_cov_0.900585_g58987_i0 PRJNA1182301 59112 244 0.900585 2.1974274 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 53.1 7.99e-6   NR XP_001026355.2 312017 g58987 i0 57.9 0.467213114754098 38 16 46.7 0 227 114 1039 1076 XP_001026355.2 cytoplasmic leucyl-tRNA synthetase [Tetrahymena thermophila SB210] diamond 114 53.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30388591 30388591 PRJNA1182301_P_NODE_34933_length_268_cov_2.841026_g34808_i0 PRJNA1182301 34933 268 2.841026 7.61394968 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 78.2 7.94e-15   NR XP_001014927.1 312017 g34808 i0 86.7 0.503731343283582 45 6 50.4 0 2 136 265 309 XP_001014927.1 ADP/ATP transporter on adenylate translocase [Tetrahymena thermophila SB210] diamond 135 78.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30798797 30798797 PRJNA1182301_P_NODE_38674_length_263_cov_3.568421_g38549_i0 PRJNA1182301 38674 263 3.568421 9.38494723 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 136 1.4100000000000001e-36   NR KAL4480407.1 5901 g38549 i0 81.2 2.85171102661597 85 16 97 0 261 7 1 85 KAL4480407.1 hypothetical protein ABPG74_020923 [Tetrahymena malaccensis] diamond 750 136 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
31355414 31355414 PRJNA1182301_P_NODE_35756_length_267_cov_2.360825_g35631_i0 PRJNA1182301 35756 267 2.360825 6.30340275 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 52 2.7e-5   NR CDW72706.1 5949 g35631 i0 39.4 1.35955056179775 66 37 71.9 2 206 15 133 197 CDW72706.1 cysteine proteinase [Stylonychia lemnae] diamond 363 52 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31747276 31747276 PRJNA1182301_P_NODE_18137_length_292_cov_2.054795_g18012_i0 PRJNA1182301 18137 292 2.054795 6.0000014 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 111 3.31e-27   NR KAL4488836.1 2486642 g18012 i0 52.7 1.86986301369863 91 42 93.5 1 16 288 208 297 KAL4488836.1 hypothetical protein ABPG72_016489 [Tetrahymena utriculariae] diamond 546 111 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
31937034 31937034 PRJNA1182301_P_NODE_32977_length_271_cov_1.555556_g32852_i0 PRJNA1182301 32977 271 1.555556 4.21555676 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 102 5.600000000000001e-23   NR XP_001007458.3 312017 g32852 i0 78.2 1.82656826568266 55 12 60.9 0 187 23 1122 1176 XP_001007458.3 Na,H/K antiporter P-type ATPase alpha subunit family protein [Tetrahymena thermophila SB210] diamond 495 102 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);;