RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA193544" 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

  • PRJNA193544 · 5 ✖

analysis 1

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
1640678 1640678 PRJNA193544_S_NODE_2882_length_163_cov_3.089552_g2867_i0 PRJNA193544 2882 163 3.089552 5.03596976 Anthozoaphila gnarlus 2783686 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|2887157058|gb|PQ871572.1| 2783686 g2867 i0 96.97 20.0920245398773 33 1 20 0 1 33 1608 1576 Anthozoaphila gnarlus isolate GZ30 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 3275 56.5 1 Eukaryota Sar   Apicomplexa Conoidasida Corallicolida Corallicolidae Anthozoaphila Anthozoaphila gnarlus
1640701 1640701 PRJNA193544_S_NODE_842_length_266_cov_16400.451477_g827_i0 PRJNA193544 842 266 16400.451477 43625.20092882 Selenidium orientale 672925 SAR_Eukaryotes SAR_Eukaryotes 111 3.96e-20   NTclustered gi|1730679297|gb|MN381956.1| 672925 g827 i0 83.2 3.94360902255639 125 18 47 3 70 193 3728 3850 Selenidium orientale isolate AK2 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 1049 111 1 Eukaryota Sar   Apicomplexa Conoidasida Archigregarinorida Selenidiidae Selenidium Selenidium orientale
13808632 13808632 PRJNA193544_S_NODE_111_length_465_cov_14.130734_g98_i0 PRJNA193544 111 465 14.130734 65.7079131 Eimeria 5800 SAR_Eukaryotes SAR_Eukaryotes 159 2.5899999999999993e-34   NTclustered gi|324022089|gb|GU593706.1| 162632 g98 i0 97.826 19.8795698924731 92 2 20 0 1 92 1287 1378 Eimeria papillata strain Miska1 28S ribosomal RNA gene, partial sequence blastn 9244 159 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria papillata
18217578 18217578 PRJNA193544_S_NODE_1835_length_198_cov_20851.165680_g1820_i0 PRJNA193544 1835 198 20851.16568 41285.3080464 uncultured Eimeriidae 404735 SAR_Eukaryotes SAR_Eukaryotes 220 4.45e-53   NTclustered gi|166084191|gb|EF024714.1| 404735 g1820 i0 91.018 84.7171717171717 167 9 83 4 34 198 1443 1281 Eimeriidae environmental sample clone Elev_18S_1204 18S ribosomal RNA gene, partial sequence blastn 16774 220 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae   uncultured Eimeriidae
22732014 22732014 PRJNA193544_S_NODE_498_length_317_cov_13.315972_g483_i0 PRJNA193544 498 317 13.315972 42.21163124 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 139 2.22e-28   NTclustered gi|1976646300|ref|XR_005506384.1| 5851 g483 i0 88.793 36.788643533123 116 9 36 4 26 139 2235 2348 Plasmodium knowlesi strain H 28S ribosomal RNA (PKNH_1001000), rRNA blastn 11662 139 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium knowlesi

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