RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 10 ✖

bioproject 1

  • PRJNA1198392 · 10 ✖

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
4151438 4151438 PRJNA1198392_P_NODE_15024_length_255_cov_1.692308_g14883_i0 PRJNA1198392 15024 255 1.692308 4.3153854 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 120 3.4499999999999996e-30   NR CAD8140901.1 43137 g14883 i0 70.2 4.91764705882353 84 25 98.8 0 4 255 140 223 CAD8140901.1 unnamed protein product [Paramecium octaurelia] diamond 1254 121 0.991735537190083 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
7977782 7977782 PRJNA1198392_P_NODE_10607_length_279_cov_1.966019_g10466_i0 PRJNA1198392 10607 279 1.966019 5.48519301 Cyclidium glaucoma 35100 SAR_Eukaryotes SAR_Eukaryotes 508 1.27e-139   NTclustered gi|111035915|emb|AJ781092.1| 35100 g10466 i0 99.64 100.007168458781 278 1 99 0 2 279 342 65 Cyclidium glaucoma partial 23S rRNA gene, strain ATCC 30701 blastn 27902 508 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
10528491 10528491 PRJNA1198392_P_NODE_3229_length_421_cov_1.221264_g3088_i0 PRJNA1198392 3229 421 1.221264 5.14152144 Tetrahymena nigricans 2704176 SAR_Eukaryotes SAR_Eukaryotes 586 8.989999999999997e-163   NTclustered gi|2082965251|gb|MZ827091.1| 2704176 g3088 i0 95.187 91.4394299287411 374 12 95 5 26 398 517 885 Tetrahymena nigricans isolate VB57 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 38496 586 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena nigricans
27376234 27376234 PRJNA1198392_P_NODE_8723_length_288_cov_1.432558_g8582_i0 PRJNA1198392 8723 288 1.432558 4.12576704 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 96.7 5.5600000000000006e-21   NR CDW78256.1 5949 g8582 i0 47.9 3.92708333333333 96 49 99 1 2 286 361 456 CDW78256.1 calcyphosin-like protein [Stylonychia lemnae] diamond 1131 97.4 0.992813141683778 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27420461 27420461 PRJNA1198392_P_NODE_15943_length_251_cov_0.865169_g15802_i0 PRJNA1198392 15943 251 0.865169 2.17157419 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.98e-12   NR KRX09924.1 266149 g15802 i0 42.3 0.932270916334661 78 45 93.2 0 12 245 6 83 KRX09924.1 Ankyrin repeat-containing domain [Pseudocohnilembus persalinus] diamond 234 67.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29207383 29207383 PRJNA1198392_P_NODE_11869_length_273_cov_1.540000_g11728_i0 PRJNA1198392 11869 273 1.54 4.2042 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0108   NR XP_001447424.1 5888 g11728 i0 32.8 1.47252747252747 67 43 73.6 1 230 30 310 374 XP_001447424.1 uncharacterized protein GSPATT00014934001 [Paramecium tetraurelia] diamond 402 44.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
31734792 31734792 PRJNA1198392_P_NODE_17417_length_248_cov_0.880000_g17276_i0 PRJNA1198392 17417 248 0.88 2.1824 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 53.5 2.66e-6   NR XP_001424000.1 5888 g17276 i0 66.7 1.70564516129032 36 12 43.5 0 244 137 151 186 XP_001424000.1 uncharacterized protein GSPATT00027631001 [Paramecium tetraurelia] diamond 423 53.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32190684 32190684 PRJNA1198392_P_NODE_8698_length_288_cov_1.553488_g8557_i0 PRJNA1198392 8698 288 1.553488 4.47404544 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 134 7.04e-38   NR KAL4512583.1 2486642 g8557 i0 71.3 0.979166666666667 94 26 97.9 1 5 286 56 148 KAL4512583.1 hypothetical protein ABPG72_020420 [Tetrahymena utriculariae] diamond 282 134 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
32285860 32285860 PRJNA1198392_P_NODE_16739_length_249_cov_1.750000_g16598_i0 PRJNA1198392 16739 249 1.75 4.3575 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 60.5 6.47e-9   NR XP_004031033.1 5932 g16598 i0 48.3 2.19277108433735 58 30 69.9 0 35 208 79 136 XP_004031033.1 zinc C2H2 type family protein, putative [Ichthyophthirius multifiliis] diamond 546 60.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32620558 32620558 PRJNA1198392_P_NODE_17520_length_248_cov_0.880000_g17379_i0 PRJNA1198392 17520 248 0.88 2.1824 Spirotrichea 33829 SAR_Eukaryotes SAR_Eukaryotes 47.8 4.89e-4   NR CAI2380657.1 5936 g17379 i0 33.3 2.04435483870968 54 36 65.3 0 245 84 157 210 CAI2380657.1 unnamed protein product [Moneuplotes crassus] diamond 507 47.8 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus

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