RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA789095" and tax_phylum = "Microsporidia"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Microsporidia · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA789095 · 18 ✖

analysis 1

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
26990205 26990205 PRJNA789095_P_NODE_57902_length_268_cov_1.579487_g56568_i0 PRJNA789095 57902 268 1.579487 4.23302516 Dictyocoela roeselum 288439 Fungi Fungi 81.6 1.71e-16   NR KAG0420146.1 288439 g56568 i0 60.3 0.705223880597015 63 25 70.5 0 71 259 75 137 KAG0420146.1 RNA-directed DNA polymerase from mobile element jockey [Dictyocoela roeselum] diamond 189 81.6 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela roeselum
27211562 27211562 PRJNA789095_P_NODE_73362_length_243_cov_1.900000_g72028_i0 PRJNA789095 73362 243 1.9 4.617 Cucumispora dikerogammari 658444 Fungi Fungi 48.1 3.04e-4   NR KAF7684865.1 658444 g72028 i0 60 0.432098765432099 35 14 43.2 0 25 129 157 191 KAF7684865.1 hypothetical protein CDIK_4386, partial [Cucumispora dikerogammari] diamond 105 48.1 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
27527611 27527611 PRJNA789095_P_NODE_24663_length_453_cov_3.463158_g23331_i0 PRJNA789095 24663 453 3.463158 15.68810574 Cucumispora dikerogammari 658444 Fungi Fungi 76.3 7.28e-14   NR KAF7684865.1 658444 g23331 i0 66.7 0.317880794701987 48 16 31.8 0 358 215 115 162 KAF7684865.1 hypothetical protein CDIK_4386, partial [Cucumispora dikerogammari] diamond 144 76.3 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
27591038 27591038 PRJNA789095_P_NODE_82064_length_199_cov_4.111111_g80730_i0 PRJNA789095 82064 199 4.111111 8.18111089 Dictyocoela roeselum 288439 Fungi Fungi 62 6.07e-10   NR KAG0420706.1 288439 g80730 i0 60.9 0.693467336683417 46 18 69.3 0 55 192 104 149 KAG0420706.1 hypothetical protein EQH57_0047 [Dictyocoela roeselum] diamond 138 62 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela roeselum
27780401 27780401 PRJNA789095_P_NODE_17344_length_619_cov_1.058608_g16035_i0 PRJNA789095 17344 619 1.058608 6.55278352 Cucumispora dikerogammari 658444 Fungi Fungi 231 7.379999999999998e-74   NR KAF7684865.1 658444 g16035 i0 55 0.915993537964459 189 84 91.6 1 615 49 13 200 KAF7684865.1 hypothetical protein CDIK_4386, partial [Cucumispora dikerogammari] diamond 567 231 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
27938227 27938227 PRJNA789095_P_NODE_19385_length_560_cov_0.921971_g18061_i0 PRJNA789095 19385 560 0.921971 5.1630376 Dictyocoela muelleri 279532 Fungi Fungi 97.8 2.25e-22   NR KAG0430917.1 279532 g18061 i0 53.3 0.492857142857143 92 43 49.3 0 285 10 44 135 KAG0430917.1 hypothetical protein DMUE_5611 [Dictyocoela muelleri] diamond 276 97.8 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela muelleri
27947405 27947405 PRJNA789095_P_NODE_41225_length_310_cov_4.405063_g39891_i0 PRJNA789095 41225 310 4.405063 13.6556953 Opisthokonta 33154 Fungi Fungi 90.5 2.09e-20   NR KAG0420706.1 288439 g39891 i0 56.3 3.36774193548387 87 30 76.5 1 310 74 54 140 KAG0420706.1 hypothetical protein EQH57_0047 [Dictyocoela roeselum] diamond 1044 90.5 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela roeselum
28033018 28033018 PRJNA789095_P_NODE_49165_length_287_cov_4.761682_g47831_i0 PRJNA789095 49165 287 4.761682 13.66602734 Nosema granulosis 83296 Fungi Fungi 43.9 0.0207   NR KAF9746896.1 83296 g47831 i0 47.8 0.961672473867596 46 24 48.1 0 157 20 86 131 KAF9746896.1 hypothetical protein NGRA_3528, partial [Nosema granulosis] diamond 276 43.9 1 Eukaryota Opisthokonta Fungi Microsporidia     Nosematidae Nosema Nosema granulosis
28033020 28033020 PRJNA789095_P_NODE_58525_length_266_cov_5.611399_g57191_i0 PRJNA789095 58525 266 5.611399 14.92632134 Cucumispora dikerogammari 658444 Fungi Fungi 55.1 1.02e-6   NR KAF7684865.1 658444 g57191 i0 49.1 0.642857142857143 57 27 62 1 181 17 90 146 KAF7684865.1 hypothetical protein CDIK_4386, partial [Cucumispora dikerogammari] diamond 171 55.1 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
28294610 28294610 PRJNA789095_P_NODE_42746_length_310_cov_2.367089_g41412_i0 PRJNA789095 42746 310 2.367089 7.3379759 Nosematidae 27974 Fungi Fungi 61.6 8.53e-10   NR KAF9751304.1 83296 g41412 i0 52 0.967741935483871 50 24 48.4 0 1 150 18 67 KAF9751304.1 hypothetical protein NGRA_3416 [Nosema granulosis] diamond 300 62 0.993548387096774 Eukaryota Opisthokonta Fungi Microsporidia     Nosematidae Nosema Nosema granulosis
28380156 28380156 PRJNA789095_P_NODE_38666_length_323_cov_2.688000_g37332_i0 PRJNA789095 38666 323 2.688 8.68224 Cucumispora dikerogammari 658444 Fungi Fungi 62.4 3.45e-9   NR KAF7684865.1 658444 g37332 i0 53.2 0.436532507739938 47 22 43.7 0 322 182 137 183 KAF7684865.1 hypothetical protein CDIK_4386, partial [Cucumispora dikerogammari] diamond 141 62.4 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
28632996 28632996 PRJNA789095_P_NODE_47747_length_291_cov_1.591743_g46413_i0 PRJNA789095 47747 291 1.591743 4.63197213 Dictyocoela roeselum 288439 Fungi Fungi 149 1.0699999999999999e-43   NR KAG0420706.1 288439 g46413 i0 75.8 1.96907216494845 95 23 97.9 0 287 3 43 137 KAG0420706.1 hypothetical protein EQH57_0047 [Dictyocoela roeselum] diamond 573 149 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela roeselum
29138202 29138202 PRJNA789095_P_NODE_12689_length_823_cov_37.416000_g11481_i0 PRJNA789095 12689 823 37.416 307.93368 Dictyocoela roeselum 288439 Fungi Fungi 58.5 2.78e-6   NR KAG0418235.1 288439 g11481 i0 59.5 0.153098420413123 42 17 15.3 0 697 822 83 124 KAG0418235.1 RNA-directed DNA polymerase from mobile element jockey, partial [Dictyocoela roeselum] diamond 126 58.5 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela roeselum
29327315 29327315 PRJNA789095_P_NODE_67309_length_249_cov_5.522727_g65975_i0 PRJNA789095 67309 249 5.522727 13.75159023 Nosema granulosis 83296 Fungi Fungi 119 1.0699999999999999e-32   NR KAF9756139.1 83296 g65975 i0 76 1.89156626506024 75 18 90.4 0 227 3 1 75 KAF9756139.1 hypothetical protein NGRA_3327 [Nosema granulosis] diamond 471 119 1 Eukaryota Opisthokonta Fungi Microsporidia     Nosematidae Nosema Nosema granulosis
29359048 29359048 PRJNA789095_P_NODE_55469_length_273_cov_2.630000_g54135_i0 PRJNA789095 55469 273 2.63 7.1799 Nosema granulosis 83296 Fungi Fungi 73.9 8.94e-15   NR KAF9756139.1 83296 g54135 i0 70.2 1.02197802197802 47 14 51.6 0 271 131 3 49 KAF9756139.1 hypothetical protein NGRA_3327 [Nosema granulosis] diamond 279 73.9 1 Eukaryota Opisthokonta Fungi Microsporidia     Nosematidae Nosema Nosema granulosis
29421930 29421930 PRJNA789095_P_NODE_68709_length_248_cov_0.885714_g67375_i0 PRJNA789095 68709 248 0.885714 2.19657072 Cucumispora dikerogammari 658444 Fungi Fungi 62.8 3.18e-9   NR KAF7685156.1 658444 g67375 i0 60.8 0.616935483870968 51 20 61.7 0 161 9 74 124 KAF7685156.1 RNA-directed DNA polymerase from mobile element jockey, partial [Cucumispora dikerogammari] diamond 153 62.8 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
29516709 29516709 PRJNA789095_P_NODE_55050_length_274_cov_2.189055_g53716_i0 PRJNA789095 55050 274 2.189055 5.9980107 Dictyocoela roeselum 288439 Fungi Fungi 62 2.66e-9   NR KAG0418178.1 288439 g53716 i0 38.1 0.91970802919708 84 51 92 1 22 273 1 83 KAG0418178.1 hypothetical protein EQH57_0786 [Dictyocoela roeselum] diamond 252 62 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela roeselum
32897712 32897712 PRJNA789095_P_NODE_13080_length_799_cov_39.163912_g11481_i1 PRJNA789095 13080 799 39.163912 312.91965688 Dictyocoela roeselum 288439 Fungi Fungi 58.5 2.56e-6   NR KAG0418235.1 288439 g11481 i1 59.5 0.157697121401752 42 17 15.8 0 127 2 83 124 KAG0418235.1 RNA-directed DNA polymerase from mobile element jockey, partial [Dictyocoela roeselum] diamond 126 58.5 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela roeselum

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