RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA700095", 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 · 20 ✖

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA700095 · 20 ✖

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
5012473 5012473 PRJNA700095_P_NODE_32224_length_301_cov_0.929825_g30960_i0 PRJNA700095 32224 301 0.929825 2.79877325 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 540 4.899999999999999e-149   NTclustered gi|1837628855|gb|MN158348.1| 5909 g30960 i0 99.003 95.3023255813954 301 3 100 0 1 301 3041 2741 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 28686 540 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
7061803 7061803 PRJNA700095_P_NODE_39226_length_278_cov_1.200000_g37962_i0 PRJNA700095 39226 278 1.2 3.336 Sathrophilus holtae 692531 SAR_Eukaryotes SAR_Eukaryotes 141 5.310000000000001e-29   NTclustered gi|404425900|gb|JX310029.1| 692531 g37962 i0 76.173 22.0971223021583 277 60 99 6 5 278 1723 1996 Sathrophilus holtae voucher FXP2007102402 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 6143 141 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Cinetochilidae Sathrophilus Sathrophilus holtae
10112746 10112746 PRJNA700095_P_NODE_15108_length_476_cov_1.704715_g13847_i0 PRJNA700095 15108 476 1.704715 8.1144434 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 91.7 4e-18   NR CDW84185.1 5949 g13847 i0 36.7 1.84033613445378 147 90 92.6 1 441 1 281 424 CDW84185.1 ku p70 dna helicase [Stylonychia lemnae] diamond 876 91.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
22360553 22360553 PRJNA700095_P_NODE_69298_length_226_cov_2.823529_g68033_i0 PRJNA700095 69298 226 2.823529 6.38117554 Caryotricha sinica 2652903 SAR_Eukaryotes SAR_Eukaryotes 134 6.980000000000001e-27   NTclustered gi|2328859121|gb|OP828526.1| 2652903 g68033 i0 97.436 36.0176991150442 78 2 35 0 1 78 905 982 Caryotricha sinica isolate LCY2018041109 large subunit ribosomal RNA gene, partial sequence blastn 8140 134 1 Eukaryota Sar   Ciliophora Spirotrichea Kiitrichida Kiitrichidae Caryotricha Caryotricha sinica
22360571 22360571 PRJNA700095_P_NODE_9338_length_640_cov_22.809524_g8122_i0 PRJNA700095 9338 640 22.809524 145.9809536 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 1160 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g8122 i0 99.375 90.4703125 640 4 100 0 1 640 997 1636 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 57901 1160 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
22861689 22861689 PRJNA700095_P_NODE_32058_length_301_cov_5.048246_g30794_i0 PRJNA700095 32058 301 5.048246 15.19522046 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 551 2.2699999999999992e-152   NTclustered gi|300078457|gb|GU187051.1| 858371 g30794 i0 100 99.5548172757475 298 0 99 0 1 298 1306 1603 Vorticella sp. SP-2009-4 18S ribosomal RNA gene, partial sequence blastn 29966 556 0.991007194244604 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. SP-2009-4
24135864 24135864 PRJNA700095_P_NODE_12399_length_541_cov_5.241453_g11148_i0 PRJNA700095 12399 541 5.241453 28.35626073 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 1000 0   NTclustered gi|363412159|gb|JN120233.1| 679523 g11148 i0 100 99.9648798521257 541 0 100 0 1 541 997 457 Vorticella gracilis isolate 88vorc2fwhfixgz4S1S2 18S ribosomal RNA gene, partial sequence blastn 54081 1000 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella gracilis
26861587 26861587 PRJNA700095_P_NODE_24941_length_344_cov_2.730627_g23677_i0 PRJNA700095 24941 344 2.730627 9.39335688 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.62e-6   NR OMJ84219.1 5963 g23677 i0 40.6 1.2906976744186 69 39 59.3 2 110 313 9 76 OMJ84219.1 hypothetical protein SteCoe_14706 [Stentor coeruleus] diamond 444 56.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
27599630 27599630 PRJNA700095_P_NODE_8724_length_668_cov_1.994958_g7534_i0 PRJNA700095 8724 668 1.994958 13.32631944 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 63.5 4.26e-9   NR OMJ69995.1 5963 g7534 i0 37.1 2.64520958083832 70 41 31.4 1 540 331 8 74 OMJ69995.1 hypothetical protein SteCoe_32124 [Stentor coeruleus] diamond 1767 63.9 0.993740219092332 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28072966 28072966 PRJNA700095_P_NODE_37185_length_283_cov_1.457143_g35921_i0 PRJNA700095 37185 283 1.457143 4.12371469 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.5 5.56e-6   NR CAD8158260.1 43138 g35921 i0 35.4 6.13780918727915 96 48 90.1 4 2 256 91 183 CAD8158260.1 unnamed protein product [Paramecium pentaurelia] diamond 1737 53.9 0.992578849721707 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
28125019 28125019 PRJNA700095_P_NODE_20785_length_386_cov_1.306709_g19522_i0 PRJNA700095 20785 386 1.306709 5.04389674 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 55.8 4.44e-6   NR CAG9330210.1 1481888 g19522 i0 30.8 0.909326424870466 117 74 90.9 2 353 3 57 166 CAG9330210.1 unnamed protein product [Blepharisma stoltei] diamond 351 55.8 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
29261489 29261489 PRJNA700095_P_NODE_9609_length_630_cov_2.439856_g8390_i0 PRJNA700095 9609 630 2.439856 15.3710928 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.0338   NR OMJ73086.1 5963 g8390 i0 30.7 0.419047619047619 88 55 41.9 1 64 327 78 159 OMJ73086.1 hypothetical protein SteCoe_28314 [Stentor coeruleus] diamond 264 46.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
29514103 29514103 PRJNA700095_P_NODE_52090_length_250_cov_1.576271_g50826_i0 PRJNA700095 52090 250 1.576271 3.9406775 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.64e-5   NR CAD8136891.1 43137 g50826 i0 39.7 0.696 58 34 69.6 1 250 77 97 153 CAD8136891.1 unnamed protein product [Paramecium octaurelia] diamond 174 50.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
30145611 30145611 PRJNA700095_P_NODE_21412_length_379_cov_1.297386_g20148_i0 PRJNA700095 21412 379 1.297386 4.91709294 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 56.2 3.26e-6   NR KAL4510021.1 2486642 g20148 i0 50 1.85224274406332 48 23 37.2 1 374 234 955 1002 KAL4510021.1 hypothetical protein ABPG72_010214 [Tetrahymena utriculariae] diamond 702 56.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
30883790 30883790 PRJNA700095_P_NODE_28354_length_320_cov_1.230769_g27090_i0 PRJNA700095 28354 320 1.230769 3.9384608 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 133 3.87e-34   NR XP_001007255.1 312017 g27090 i0 56.7 2.925 104 45 97.5 0 318 7 301 404 XP_001007255.1 phosphoesterase family protein [Tetrahymena thermophila SB210] diamond 936 133 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31125020 31125020 PRJNA700095_P_NODE_50815_length_251_cov_3.224719_g49551_i0 PRJNA700095 50815 251 3.224719 8.09404469 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 116 4.22e-28   NR KAL4465295.1 5901 g49551 i0 66.3 1.9840637450199201 83 28 99.2 0 1 249 1079 1161 KAL4465295.1 hypothetical protein ABPG74_002009 [Tetrahymena malaccensis] diamond 498 116 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
31410010 31410010 PRJNA700095_P_NODE_20916_length_384_cov_3.871383_g19652_i0 PRJNA700095 20916 384 3.871383 14.86611072 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 77.4 1.38e-13   NR OMJ75153.1 5963 g19652 i0 57.4 1.53125 68 29 53.1 0 204 1 1 68 OMJ75153.1 hypothetical protein SteCoe_25774 [Stentor coeruleus] diamond 588 77.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31410028 31410028 PRJNA700095_P_NODE_43096_length_268_cov_1.579487_g41832_i0 PRJNA700095 43096 268 1.579487 4.23302516 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 52 2.72e-5   NR CAD8193407.1 43138 g41832 i0 53.8 0.917910447761194 39 18 43.7 0 124 8 351 389 CAD8193407.1 unnamed protein product [Paramecium pentaurelia] diamond 246 52 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
32232779 32232779 PRJNA700095_P_NODE_9538_length_633_cov_2.341071_g8319_i0 PRJNA700095 9538 633 2.341071 14.81897943 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 69.7 7.84e-10   NR CDW74201.1 5949 g8319 i0 39.8 1.27962085308057 83 50 39.3 0 406 158 1735 1817 CDW74201.1 peptidase c19 family protein [Stylonychia lemnae] diamond 810 69.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32769275 32769275 PRJNA700095_P_NODE_52140_length_250_cov_1.429379_g50876_i0 PRJNA700095 52140 250 1.429379 3.5734475 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 57.8 1.94e-7   NR CAD8085695.1 65129 g50876 i0 49.3 0.828 69 33 82.8 1 215 9 122 188 CAD8085695.1 unnamed protein product [Paramecium sonneborni] diamond 207 57.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni

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