RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 24 ✖

tax_clade 1

bioproject 1

  • PRJEB64798 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
1402849 1402849 PRJEB64798_P_NODE_231802_length_158_cov_3.376147_g230036_i0 PRJEB64798 231802 158 3.376147 5.33431226 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 91.3 4.95e-20   NR CEO98802.1 37360 g230036 i0 84 21.1898734177215 50 8 94.9 0 152 3 93 142 CEO98802.1 hypothetical protein PBRA_006916 [Plasmodiophora brassicae] diamond 3348 91.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
3954809 3954809 PRJEB64798_P_NODE_31324_length_352_cov_3.036304_g29567_i0 PRJEB64798 31324 352 3.036304 10.68779008 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 143 1.66e-41   NR CEP03461.1 37360 g29567 i0 66.7 3.51136363636364 105 35 89.5 0 317 3 9 113 CEP03461.1 hypothetical protein PBRA_003222 [Plasmodiophora brassicae] diamond 1236 143 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
9056886 9056886 PRJEB64798_P_NODE_8048_length_696_cov_13.786708_g6676_i0 PRJEB64798 8048 696 13.786708 95.95548768 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 214 1.39e-66   NR CEP02281.1 37360 g6676 i0 55.2 0.905172413793103 210 84 89.2 2 33 653 1 203 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 630 214 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27570897 27570897 PRJEB64798_P_NODE_235424_length_157_cov_2.129630_g233658_i0 PRJEB64798 235424 157 2.12963 3.3435191 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 50.1 2.92e-5   NR CEO94323.1 37360 g233658 i0 55.8 1.5477707006369399 43 19 82.2 0 149 21 996 1038 CEO94323.1 hypothetical protein PBRA_000108 [Plasmodiophora brassicae] diamond 243 50.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27658904 27658904 PRJEB64798_P_NODE_241524_length_154_cov_11.590476_g239758_i0 PRJEB64798 241524 154 11.590476 17.84933304 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 77 9.73e-16   NR CEO99638.1 37360 g239758 i0 79.6 2.86363636363636 49 10 95.5 0 7 153 29 77 CEO99638.1 hypothetical protein PBRA_007371 [Plasmodiophora brassicae] diamond 441 77 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27665911 27665911 PRJEB64798_P_NODE_74544_length_223_cov_8.114943_g72779_i0 PRJEB64798 74544 223 8.114943 18.09632289 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 63.9 1.5e-11   NR CEO99669.1 37360 g72779 i0 81 0.565022421524664 42 6 53.8 1 3 122 19 60 CEO99669.1 hypothetical protein PBRA_007402 [Plasmodiophora brassicae] diamond 126 63.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28075952 28075952 PRJEB64798_P_NODE_197365_length_168_cov_2.260504_g195599_i0 PRJEB64798 197365 168 2.260504 3.79764672 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 69.7 3.25e-12   NR MES1919365.1 126728 g195599 i0 58.5 0.946428571428571 53 22 94.6 0 162 4 50 102 MES1919365.1 hypothetical protein [Bonamia ostreae] diamond 159 69.7 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
28732287 28732287 PRJEB64798_P_NODE_241107_length_155_cov_2.094340_g239341_i0 PRJEB64798 241107 155 2.09434 3.246227 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 89 1.01e-20   NR CEP00218.1 37360 g239341 i0 76 5.80645161290323 50 12 96.8 0 150 1 55 104 CEP00218.1 hypothetical protein PBRA_007952 [Plasmodiophora brassicae] diamond 900 89.7 0.992196209587514 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29244380 29244380 PRJEB64798_P_NODE_219129_length_162_cov_4.672566_g217363_i0 PRJEB64798 219129 162 4.672566 7.56955692 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 95.1 9.34e-22   NR CEP02379.1 37360 g217363 i0 84.6 0.962962962962963 52 8 96.3 0 157 2 30 81 CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] diamond 156 95.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29339013 29339013 PRJEB64798_P_NODE_113229_length_209_cov_10.000000_g111463_i0 PRJEB64798 113229 209 10 20.9 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 67 4.69e-11   NR CEO95727.1 37360 g111463 i0 47.1 0.976076555023923 68 36 97.6 0 208 5 139 206 CEO95727.1 hypothetical protein PBRA_004440 [Plasmodiophora brassicae] diamond 204 67 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29622774 29622774 PRJEB64798_P_NODE_248090_length_152_cov_6.932039_g246324_i0 PRJEB64798 248090 152 6.932039 10.53669928 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 62 5.91e-10   NR CEO96142.1 37360 g246324 i0 64.9 0.730263157894737 37 13 73 0 40 150 69 105 CEO96142.1 hypothetical protein PBRA_004832 [Plasmodiophora brassicae] diamond 111 62 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29900614 29900614 PRJEB64798_P_NODE_125811_length_201_cov_3.177632_g124045_i0 PRJEB64798 125811 201 3.177632 6.38704032 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82.8 2.17e-17   NR SPQ98958.1 37360 g124045 i0 73.7 2.61194029850746 57 15 85.1 0 185 15 151 207 SPQ98958.1 unnamed protein product [Plasmodiophora brassicae] diamond 525 82.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30286948 30286948 PRJEB64798_P_NODE_210192_length_165_cov_0.896552_g208426_i0 PRJEB64798 210192 165 0.896552 1.4793108 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 69.7 3.42e-13   NR CEP03912.1 37360 g208426 i0 68.1 1.8 47 15 85.5 0 143 3 45 91 CEP03912.1 hypothetical protein PBRA_003519 [Plasmodiophora brassicae] diamond 297 69.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30633895 30633895 PRJEB64798_P_NODE_193493_length_169_cov_2.658333_g191727_i0 PRJEB64798 193493 169 2.658333 4.49258277 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 76.6 1.55e-14   NR CEO96872.1 37360 g191727 i0 64.8 0.958579881656805 54 18 95.9 1 165 4 297 349 CEO96872.1 hypothetical protein PBRA_005476 [Plasmodiophora brassicae] diamond 162 76.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31076483 31076483 PRJEB64798_P_NODE_152515_length_187_cov_3.608696_g150749_i0 PRJEB64798 152515 187 3.608696 6.74826152 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.51e-16   NR CEP01088.1 37360 g150749 i0 68.3 6.7379679144385 60 19 96.3 0 6 185 66 125 CEP01088.1 hypothetical protein PBRA_008400 [Plasmodiophora brassicae] diamond 1260 79.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31139277 31139277 PRJEB64798_P_NODE_212475_length_164_cov_2.173913_g210709_i0 PRJEB64798 212475 164 2.173913 3.56521732 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.17e-4   NR CEO95889.1 37360 g210709 i0 54.8 0.768292682926829 42 19 76.8 0 35 160 238 279 CEO95889.1 hypothetical protein PBRA_009688, partial [Plasmodiophora brassicae] diamond 126 47.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31202344 31202344 PRJEB64798_P_NODE_201155_length_167_cov_2.152542_g199389_i0 PRJEB64798 201155 167 2.152542 3.59474514 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 75.5 3.77e-14   NR SPR00535.1 37360 g199389 i0 67.3 6.53892215568862 52 17 93.4 0 157 2 485 536 SPR00535.1 unnamed protein product [Plasmodiophora brassicae] diamond 1092 75.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31455952 31455952 PRJEB64798_P_NODE_218196_length_162_cov_12.061947_g216430_i0 PRJEB64798 218196 162 12.061947 19.54035414 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 73.6 8.87e-15   NR CEO97530.1 37360 g216430 i0 70.5 0.814814814814815 44 13 81.5 0 5 136 4 47 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 132 73.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32049917 32049917 PRJEB64798_P_NODE_149938_length_188_cov_7.467626_g148172_i0 PRJEB64798 149938 188 7.467626 14.03913688 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 96.7 4.27e-23   NR AGR03794.1 166267 g148172 i0 75.7 4.46808510638298 70 7 95.7 1 8 187 31 100 AGR03794.1 actin, partial [Spongospora subterranea f. sp. subterranea] diamond 840 96.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Spongospora Spongospora subterranea
32215268 32215268 PRJEB64798_P_NODE_70418_length_230_cov_8.812155_g68653_i0 PRJEB64798 70418 230 8.812155 20.2679565 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0404   NR SYZ47119.1 37360 g68653 i0 45.9 0.482608695652174 37 19 47 1 174 67 161 197 SYZ47119.1 f1867142-5b98-4a1f-a759-0f0a97a3e7da [Plasmodiophora brassicae] diamond 111 42.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32240047 32240047 PRJEB64798_P_NODE_213818_length_164_cov_0.904348_g212052_i0 PRJEB64798 213818 164 0.904348 1.48313072 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 59.3 1.79e-8   NR CEO99471.1 37360 g212052 i0 61.2 2.6890243902439 49 19 89.6 0 159 13 260 308 CEO99471.1 hypothetical protein PBRA_001377 [Plasmodiophora brassicae] diamond 441 59.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32373426 32373426 PRJEB64798_P_NODE_193259_length_169_cov_3.150000_g191493_i0 PRJEB64798 193259 169 3.15 5.3235 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 66.2 6.77e-11   NR CEO96039.1 37360 g191493 i0 57.1 9.37278106508876 49 21 87 0 161 15 577 625 CEO96039.1 hypothetical protein PBRA_004729 [Plasmodiophora brassicae] diamond 1584 66.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32619188 32619188 PRJEB64798_P_NODE_177920_length_175_cov_4.150794_g176154_i0 PRJEB64798 177920 175 4.150794 7.2638895 root 1 Root_unresolved Root_unresolved 41.2 0.0183   NR YP_009350057.1 70186 g176154 i0 51.1 2.00571428571429 45 22 77.1 0 173 39 11 55 YP_009350057.1 hypothetical protein [Spongospora subterranea] diamond 351 41.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Spongospora Spongospora subterranea
32657231 32657231 PRJEB64798_P_NODE_194220_length_169_cov_1.400000_g192454_i0 PRJEB64798 194220 169 1.4 2.366 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 52.4 5.43e-6   NR SPQ98449.1 37360 g192454 i0 64.7 1.20710059171598 34 12 60.4 0 67 168 62 95 SPQ98449.1 unnamed protein product [Plasmodiophora brassicae] diamond 204 52.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae

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