RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA345071" 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

  • PRJNA345071 · 13 ✖

analysis 1

  • blastn · 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
1667949 1667949 PRJNA345071_P_NODE_2902_length_349_cov_0.996377_g2862_i0 PRJNA345071 2902 349 0.996377 3.47735573 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 339 2.2599999999999997e-88   NTclustered gi|829185314|ref|XM_001031847.2| 312017 g2862 i0 87.415 5.3810888252149 294 37 84 0 46 339 720 427 Tetrahymena thermophila SB210 60S ribosomal protein L7 partial mRNA blastn 1878 339 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
2944098 2944098 PRJNA345071_P_NODE_8103_length_251_cov_1.342697_g8063_i0 PRJNA345071 8103 251 1.342697 3.37016947 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 326 1.21e-84   NTclustered gi|471230286|ref|XM_004036375.1| 5932 g8063 i0 90.04 47.9641434262948 251 25 100 0 1 251 902 1152 Ichthyophthirius multifiliis hypothetical protein (IMG5_083250) mRNA, complete cds blastn 12039 326 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
4220675 4220675 PRJNA345071_P_NODE_6704_length_264_cov_1.350785_g6664_i0 PRJNA345071 6704 264 1.350785 3.5660724 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 339 1.65e-88   NTclustered gi|829174395|ref|XM_012797980.1| 312017 g6664 i0 89.773 1.10606060606061 264 27 100 0 1 264 530 267 Tetrahymena thermophila SB210 60S ribosomal protein L18 partial mRNA blastn 292 339 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
14422035 14422035 PRJNA345071_P_NODE_1512_length_448_cov_2.984000_g1472_i0 PRJNA345071 1512 448 2.984 13.36832 Euplotes octocarinatus 2716877 SAR_Eukaryotes SAR_Eukaryotes 712 0   NTclustered gi|9306|emb|X69466.1| 2716877 g1472 i0 95.312 79.109375 448 21 100 0 1 448 108 555 E.octocarinatus gene for alpha-tubulin blastn 35441 712 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes octocarinatus
14422142 14422142 PRJNA345071_P_NODE_6192_length_271_cov_1.575758_g6152_i0 PRJNA345071 6192 271 1.575758 4.27030418 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 322 1.72e-83   NTclustered gi|118352922|ref|XM_001009732.1| 312017 g6152 i0 88.433 0.988929889298893 268 30 99 1 4 271 311 45 Tetrahymena thermophila SB210 Ran-binding protein 2, Ran-binding domain protein partial mRNA blastn 268 322 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
14422188 14422188 PRJNA345071_P_NODE_8172_length_251_cov_0.876404_g8132_i0 PRJNA345071 8172 251 0.876404 2.19977404 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 289 1.59e-73   NTclustered gi|146186088|ref|XM_001032999.2| 312017 g8132 i0 90.741 0.860557768924303 216 20 86 0 28 243 507 292 Tetrahymena thermophila SB210 40S ribosomal protein S7 partial mRNA blastn 216 289 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
16970630 16970630 PRJNA345071_P_NODE_11154_length_231_cov_3.436709_g11114_i0 PRJNA345071 11154 231 3.436709 7.93879779 Euplotes aediculatus 5940 SAR_Eukaryotes SAR_Eukaryotes 427 2.9399999999999998e-115   NTclustered gi|860922|emb|Z49851.1| 5940 g11114 i0 100 93.0995670995671 231 0 100 0 1 231 1145 915 E.aediculatus gene for alpha-tubulin (partial) blastn 21506 427 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes aediculatus
18244890 18244890 PRJNA345071_P_NODE_315_length_826_cov_4.049137_g278_i0 PRJNA345071 315 826 4.049137 33.44587162 Euplotes octocarinatus 2716877 SAR_Eukaryotes SAR_Eukaryotes 1253 0   NTclustered gi|112383582|gb|DQ864704.1| 2716877 g278 i0 94.061 95.4866828087167 825 49 99 0 2 826 1392 568 Euplotes octocarinatus beta2-tubulin (BTUB2) gene, complete cds blastn 78872 1253 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes octocarinatus
18245000 18245000 PRJNA345071_P_NODE_7595_length_253_cov_1.300000_g7555_i0 PRJNA345071 7595 253 1.3 3.289 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 359 1.21e-94   NTclustered gi|118385632|ref|XM_001025944.1| 312017 g7555 i0 92.46 0.99604743083004 252 17 99 2 1 251 897 647 Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA blastn 252 359 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
18245004 18245004 PRJNA345071_P_NODE_7715_length_253_cov_0.866667_g7675_i0 PRJNA345071 7715 253 0.866667 2.19266751 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 281 2.69e-71   NTclustered gi|829192652|ref|XM_001030092.3| 312017 g7675 i0 87.149 1.20948616600791 249 30 98 2 1 248 217 464 Tetrahymena thermophila SB210 40S ribosomal protein S8-2 partial mRNA blastn 306 281 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
19519069 19519069 PRJNA345071_P_NODE_1416_length_461_cov_2.229381_g1376_i0 PRJNA345071 1416 461 2.229381 10.27744641 Euplotes aediculatus 5940 SAR_Eukaryotes SAR_Eukaryotes 835 0   NTclustered gi|860922|emb|Z49851.1| 5940 g1376 i0 99.349 99.5119305856833 461 3 100 0 1 461 327 787 E.aediculatus gene for alpha-tubulin (partial) blastn 45875 835 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes aediculatus
22069860 22069860 PRJNA345071_P_NODE_5978_length_274_cov_1.552239_g5938_i0 PRJNA345071 5978 274 1.552239 4.25313486 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 385 2.18e-102   NTclustered gi|829160572|ref|XM_001012497.3| 312017 g5938 i0 91.971 14.3430656934307 274 22 100 0 1 274 558 285 Tetrahymena thermophila SB210 60S ribosomal protein L10 partial mRNA blastn 3930 385 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
23345383 23345383 PRJNA345071_P_NODE_9459_length_246_cov_1.682081_g9419_i0 PRJNA345071 9459 246 1.682081 4.13791926 Lamtostyla sp. LPJ-2005 331616 SAR_Eukaryotes SAR_Eukaryotes 298 2.5799999999999998e-76   NTclustered gi|67462297|gb|DQ062090.1| 331616 g9419 i0 88.571 75.6829268292683 245 28 99 0 1 245 917 673 Lamtostyla sp. LPJ-2005 heta shock protein 70 mRNA, partial cds; macronuclear blastn 18618 298 1 Eukaryota Sar   Ciliophora Spirotrichea Stichotrichida Amphisiellidae Lamtostyla Lamtostyla sp. LPJ-2005

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