RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA893346 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
2143796 2143796 PRJNA893346_P_NODE_35222_length_248_cov_0.880000_g34732_i0 PRJNA893346 35222 248 0.88 2.1824 Trichodina sp. 3 2979178 SAR_Eukaryotes SAR_Eukaryotes 265 2.6499999999999997e-66   NTclustered gi|2304601492|gb|OP458313.1| 2979178 g34732 i0 90.547 70.1612903225806 201 17 81 2 10 209 1590 1789 Trichodina sp. 3 large subunit ribosomal RNA gene, partial sequence blastn 17400 265 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina sp. 3
2144036 2144036 PRJNA893346_P_NODE_902_length_1595_cov_4.073587_g740_i0 PRJNA893346 902 1595 4.073587 64.97371265 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.046   NTclustered gi|829186935|ref|XM_001022570.3| 312017 g740 i0 100 0.0181818181818182 29 0 2 0 1169 1197 1636 1608 Tetrahymena thermophila SB210 Serine/Threonine kinase domain protein partial mRNA blastn 29 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
3418918 3418918 PRJNA893346_P_NODE_25823_length_298_cov_1.368889_g25333_i0 PRJNA893346 25823 298 1.368889 4.07928922 Metaurostylopsis cheni 881313 SAR_Eukaryotes SAR_Eukaryotes 93.5 1.63e-14   NTclustered gi|404425856|gb|JQ424849.1| 881313 g25333 i0 78.767 19.6845637583893 146 25 49 5 135 280 160 299 Metaurostylopsis cheni voucher CXM08060901 28S ribosomal RNA gene, partial sequence blastn 5866 93.5 1 Eukaryota Sar   Ciliophora Spirotrichea Urostylida Urostylidae Metaurostylopsis Metaurostylopsis cheni
4696935 4696935 PRJNA893346_P_NODE_39344_length_242_cov_0.911243_g38854_i0 PRJNA893346 39344 242 0.911243 2.20520806 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 333 6.949999999999999e-87   NTclustered gi|3341414|emb|X94349.1| 41631 g38854 i0 92.017 93.5495867768595 238 17 98 2 1 237 480 716 Colpoda sp. gene encoding for beta-tubulin, partial blastn 22639 333 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
5971429 5971429 PRJNA893346_P_NODE_26245_length_295_cov_1.765766_g25755_i0 PRJNA893346 26245 295 1.765766 5.2090097 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 235 2.53e-57   NTclustered gi|829150968|ref|XM_001010768.3| 312017 g25755 i0 82.836 14.6542372881356 268 41 91 4 29 295 11 274 Tetrahymena thermophila SB210 peptidyl-prolyl cis-trans isomerase, cyclophilin-type protein partial mRNA blastn 4323 235 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
5971632 5971632 PRJNA893346_P_NODE_34105_length_250_cov_0.870056_g33615_i0 PRJNA893346 34105 250 0.870056 2.17514 Eudiplodinium maggii 47892 SAR_Eukaryotes SAR_Eukaryotes 255 1.61e-63   NTclustered gi|92790165|emb|AJ965268.1| 47892 g33615 i0 85.425 141.224 247 34 98 2 1 246 333 578 Eudiplodinium maggii partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) blastn 35306 255 1 Eukaryota Sar   Ciliophora Litostomatea Entodiniomorphida Ophryoscolecidae Eudiplodinium Eudiplodinium maggii
9796104 9796104 PRJNA893346_P_NODE_26948_length_291_cov_0.922018_g26458_i0 PRJNA893346 26948 291 0.922018 2.68307238 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 405 1.7999999999999997e-108   NTclustered gi|10793|emb|X12769.1| 5908 g26458 i0 91.753 97.7903780068729 291 24 100 0 1 291 431 141 Tetrahymena pyriformis beta-tubulin gene 2 (beta-TT2) blastn 28457 405 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
11071784 11071784 PRJNA893346_P_NODE_27809_length_285_cov_1.801887_g27319_i0 PRJNA893346 27809 285 1.801887 5.13537795 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 145 4.2199999999999995e-30   NTclustered gi|47176078|gb|AY617658.1| 94289 g27319 i0 79.803 2.31578947368421 203 37 70 3 15 214 645 444 Sterkiella histriomuscorum clone UGC1O0004_A14_R genomic sequence blastn 660 145 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
19094774 19094774 PRJNA893346_P_NODE_23895_length_312_cov_1.933054_g23405_i0 PRJNA893346 23895 312 1.933054 6.03112848 Sessilida 1974272 SAR_Eukaryotes SAR_Eukaryotes 372 1.97e-98   NTclustered gi|759083413|gb|KM222031.1| 240170 g23405 i0 88.217 97.6474358974359 314 33 100 4 1 312 681 370 Zoothamnopsis sinica voucher JDD04092801 alpha-tubulin gene, partial cds blastn 30466 372 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Zoothamnidae Zoothamnopsis Zoothamnopsis sinica
21270347 21270347 PRJNA893346_P_NODE_38237_length_243_cov_1.111765_g37747_i0 PRJNA893346 38237 243 1.111765 2.70158895 Polyplastron multivesiculatum 47894 SAR_Eukaryotes SAR_Eukaryotes 230 9.43e-56   NTclustered gi|92790169|emb|AJ965270.1| 47894 g37747 i0 83.884 128.020576131687 242 37 99 2 3 243 263 23 Polyplastron multivesiculatum partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) blastn 31109 230 1 Eukaryota Sar   Ciliophora Litostomatea Entodiniomorphida Ophryoscolecidae Polyplastron Polyplastron multivesiculatum
23820571 23820571 PRJNA893346_P_NODE_34419_length_249_cov_1.312500_g33929_i0 PRJNA893346 34419 249 1.3125 3.268125 Trichodina heterodentata 300408 SAR_Eukaryotes SAR_Eukaryotes 361 3.3e-95   NTclustered gi|148466409|gb|EF569680.1| 300408 g33929 i0 92.771 99.1204819277108 249 18 100 0 1 249 1104 856 Trichodina heterodentata alpha-tubulin gene, partial cds blastn 24681 361 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina heterodentata

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