RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA816047 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
25632727 25632727 PRJNA816047a_S_NODE_36017_length_346_cov_1.644689_g33357_i0 PRJNA816047 36017 346 1.644689 5.69062394 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 289 2.29e-73   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g33357 i0 98.182 53.1878612716763 165 3 48 0 172 336 3082 2918 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 18403 289 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
25863527 25863527 PRJNA816047a_S_NODE_20595_length_446_cov_9.739946_g17946_i0 PRJNA816047 20595 446 9.739946 43.44015916 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 305 3e-78   NTclustered gi|11466252|ref|NC_000862.1| 5908 g17946 i0 84.326 62.6300448430493 319 42 70 7 91 404 774 1089 Tetrahymena pyriformis mitochondrion, complete genome blastn 27933 305 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
25869769 25869769 PRJNA816047b_S_NODE_22123_length_345_cov_2.779412_g19811_i0 PRJNA816047 22123 345 2.779412 9.5889714 Cyclidium glaucoma 35100 SAR_Eukaryotes SAR_Eukaryotes 616 9.229999999999999e-172   NTclustered gi|111035915|emb|AJ781092.1| 35100 g19811 i0 99.702 95.936231884058 336 1 97 0 1 336 338 3 Cyclidium glaucoma partial 23S rRNA gene, strain ATCC 30701 blastn 33098 616 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
26282105 26282105 PRJNA816047d_S_NODE_131982_length_229_cov_3.505682_g130147_i0 PRJNA816047 131982 229 3.505682 8.02801178 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 159 1.1699999999999999e-34   NTclustered gi|471226551|ref|XM_004032261.1| 5932 g130147 i0 84.906 46.4541484716157 159 22 69 2 1 158 638 481 Ichthyophthirius multifiliis ATP synthase alpha subunit precursor, putative (IMG5_124890) mRNA, complete cds blastn 10638 159 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
26544063 26544063 PRJNA816047a_S_NODE_21656_length_436_cov_3.305785_g19006_i0 PRJNA816047 21656 436 3.305785 14.4132226 Coleps hirtus 60000 SAR_Eukaryotes SAR_Eukaryotes 632 1.1799999999999995e-176   NTclustered gi|2026535536|gb|MW929305.1| 60000 g19006 i0 99.148 80.6215596330275 352 1 80 1 21 370 2261 2612 Coleps hirtus strain AG Berninger/Pickham Uni Salzburg small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 35151 632 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida Colepidae Coleps Coleps hirtus
26551247 26551247 PRJNA816047b_S_NODE_34456_length_287_cov_3.509346_g32144_i0 PRJNA816047 34456 287 3.509346 10.07182302 Coleps hirtus 60000 SAR_Eukaryotes SAR_Eukaryotes 510 3.64e-140   NTclustered gi|2026535536|gb|MW929305.1| 60000 g32144 i0 98.951 100.567944250871 286 1 99 1 4 287 2545 2260 Coleps hirtus strain AG Berninger/Pickham Uni Salzburg small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 28863 510 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida Colepidae Coleps Coleps hirtus

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