RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1092581" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1092581 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
9945987 9945987 PRJNA1092581_P_NODE_107788_length_243_cov_1.811765_g107255_i0 PRJNA1092581 107788 243 1.811765 4.40258895 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 259 1.2e-64   NTclustered gi|1446202028|gb|MH304759.1| 3075681 g107255 i0 87.179 57.8888888888889 234 22 95 7 14 243 6367 6138 Corallicolida sp. WKK-2018b isolate 2 small subunit ribosomal RNA gene, 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 14067 259 1 Eukaryota Sar   Apicomplexa Conoidasida Corallicolida     Corallicolida sp. WKK-2018b
11221240 11221240 PRJNA1092581_P_NODE_108149_length_242_cov_6.792899_g107616_i0 PRJNA1092581 108149 242 6.792899 16.43881558 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|916415749|ref|XM_013373652.1| 5802 g107616 i0 90.476 2.6900826446281 42 4 17 0 38 79 943 902 Eimeria tenella phosphoglucan, water dikinase protein, putative (ETH_00008190), partial mRNA blastn 651 56.5 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria tenella
23148000 23148000 PRJNA1092581_P_NODE_113299_length_234_cov_8.055901_g112766_i0 PRJNA1092581 113299 234 8.055901 18.85080834 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 300 6.78e-77   NTclustered gi|820695469|tpe|LN714488.1| 572307 g112766 i0 92.417 17.9957264957265 211 15 92 1 25 234 301660 301450 TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome blastn 4211 300 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
24424101 24424101 PRJNA1092581_P_NODE_92700_length_264_cov_12.104712_g92167_i0 PRJNA1092581 92700 264 12.104712 31.95643968 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 355 1.64e-93   NTclustered gi|820695469|tpe|LN714488.1| 572307 g92167 i0 94.737 46.9242424242424 228 12 86 0 19 246 116120 116347 TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome blastn 12388 355 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
25244710 25244710 PRJNA1092581_P_NODE_48680_length_386_cov_4.699681_g48147_i0 PRJNA1092581 48680 386 4.699681 18.14076866 Cryptosporidium 5806 SAR_Eukaryotes SAR_Eukaryotes 226 2.0499999999999995e-54   NTclustered gi|2560612139|gb|OR419798.1| 5807 g48147 i0 84.821 61.7383419689119 224 34 58 0 163 386 5590 5813 Cryptosporidium parvum small subunit ribosomal RNA gene, 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 23831 226 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium parvum

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