RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA630162 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
8255894 8255894 PRJNA630162_P_NODE_84887_length_196_cov_2.040816_g83364_i0 PRJNA630162 84887 196 2.040816 3.99999936 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 101 3.8e-26   NR CEO99864.1 37360 g83364 i0 81 0.964285714285714 63 11 96.4 1 189 1 13 74 CEO99864.1 hypothetical protein PBRA_007598 [Plasmodiophora brassicae] diamond 189 101 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
10805860 10805860 PRJNA630162_P_NODE_140529_length_167_cov_0.881356_g139006_i0 PRJNA630162 140529 167 0.881356 1.47186452 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.6 4.26e-14   NR CEP03487.1 37360 g139006 i0 76.5 20.9281437125749 51 12 91.6 0 161 9 67 117 CEP03487.1 hypothetical protein PBRA_009372 [Plasmodiophora brassicae] diamond 3495 73.9 0.995940460081191 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
18454366 18454366 PRJNA630162_P_NODE_45855_length_261_cov_2.070755_g44332_i0 PRJNA630162 45855 261 2.070755 5.40467055 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 110 3.14e-27   NR CEO96095.1 37360 g44332 i0 54.8 0.96551724137931 84 38 96.6 0 5 256 113 196 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 252 110 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
22278951 22278951 PRJNA630162_P_NODE_152518_length_164_cov_0.904348_g150995_i0 PRJNA630162 152518 164 0.904348 1.48313072 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 91.3 1.01e-19   NR CEO96729.1 37360 g150995 i0 80.8 0.951219512195122 52 10 95.1 0 157 2 301 352 CEO96729.1 hypothetical protein PBRA_005333 [Plasmodiophora brassicae] diamond 156 91.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26827810 26827810 PRJNA630162_P_NODE_93181_length_190_cov_1.170213_g91658_i0 PRJNA630162 93181 190 1.170213 2.2234047 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0183   NR SPQ99881.1 37360 g91658 i0 48.8 0.647368421052632 41 20 63.2 1 185 66 336 376 SPQ99881.1 unnamed protein product [Plasmodiophora brassicae] diamond 123 42.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27238638 27238638 PRJNA630162_P_NODE_136383_length_168_cov_0.873950_g134860_i0 PRJNA630162 136383 168 0.87395 1.468236 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 75.1 2.95e-14   NR SPR01615.1 37360 g134860 i0 64.8 2.89285714285714 54 19 96.4 0 162 1 170 223 SPR01615.1 unnamed protein product [Plasmodiophora brassicae] diamond 486 75.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27270272 27270272 PRJNA630162_P_NODE_144823_length_166_cov_0.888889_g143300_i0 PRJNA630162 144823 166 0.888889 1.47555574 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 46.6 5.48e-4   NR CEP03463.1 37360 g143300 i0 55.6 0.650602409638554 36 16 65.1 0 54 161 146 181 CEP03463.1 hypothetical protein PBRA_003221 [Plasmodiophora brassicae] diamond 108 46.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28375502 28375502 PRJNA630162_P_NODE_151606_length_164_cov_0.904348_g150083_i0 PRJNA630162 151606 164 0.904348 1.48313072 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 59.7 1.33e-8   NR SPQ94367.1 37360 g150083 i0 51.9 1.90243902439024 52 25 95.1 0 157 2 3456 3507 SPQ94367.1 unnamed protein product [Plasmodiophora brassicae] diamond 312 59.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29083008 29083008 PRJNA630162_P_NODE_131508_length_169_cov_0.866667_g129985_i0 PRJNA630162 131508 169 0.866667 1.46466723 root 1 Root_unresolved Root_unresolved 83.6 2.91e-18   NR CAB66903.1 41456 g129985 i0 73.7 5.71597633136095 57 11 94.1 1 161 3 14 70 CAB66903.1 glutathione-s-transferase, partial [Polymyxa betae] diamond 966 83.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Polymyxa Polymyxa betae
29272115 29272115 PRJNA630162_P_NODE_148469_length_165_cov_0.896552_g146946_i0 PRJNA630162 148469 165 0.896552 1.4793108 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62.8 1.08e-9   NR SYZ47170.1 37360 g146946 i0 58.5 73.2363636363636 53 22 96.4 0 6 164 371 423 SYZ47170.1 69cc95b5-50ed-46f3-838c-f06c45a666eb [Plasmodiophora brassicae] diamond 12084 63.2 0.993670886075949 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29796207 29796207 PRJNA630162_P_NODE_136531_length_168_cov_0.873950_g135008_i0 PRJNA630162 136531 168 0.87395 1.468236 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.58e-6   NR CEP00115.1 37360 g135008 i0 46.8 0.839285714285714 47 25 83.9 0 162 22 87 133 CEP00115.1 hypothetical protein PBRA_007849 [Plasmodiophora brassicae] diamond 141 53.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29827847 29827847 PRJNA630162_P_NODE_135671_length_168_cov_0.873950_g134148_i0 PRJNA630162 135671 168 0.87395 1.468236 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 47.4 3.04e-4   NR CEP02379.1 37360 g134148 i0 68.6 0.625 35 11 62.5 0 163 59 241 275 CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] diamond 105 47.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29891298 29891298 PRJNA630162_P_NODE_154131_length_163_cov_2.289474_g152608_i0 PRJNA630162 154131 163 2.289474 3.73184262 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87 3e-18   NR SPQ96247.1 37360 g152608 i0 72.5 6.62576687116564 51 14 93.9 0 155 3 388 438 SPQ96247.1 unnamed protein product [Plasmodiophora brassicae] diamond 1080 87 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30270477 30270477 PRJNA630162_P_NODE_114352_length_177_cov_2.179688_g112829_i0 PRJNA630162 114352 177 2.179688 3.85804776 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 72.4 5.47e-13   NR CEP01920.1 37360 g112829 i0 57.6 1 59 25 100 0 1 177 265 323 CEP01920.1 hypothetical protein PBRA_008863, partial [Plasmodiophora brassicae] diamond 177 72.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30315057 30315057 PRJNA630162_P_NODE_126252_length_171_cov_1.827869_g124729_i0 PRJNA630162 126252 171 1.827869 3.12565599 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 90.9 1.86e-20   NR CEO97184.1 37360 g124729 i0 76.8 1.96491228070175 56 13 98.2 0 4 171 176 231 CEO97184.1 hypothetical protein PBRA_000529 [Plasmodiophora brassicae] diamond 336 91.3 0.995618838992333 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30586040 30586040 PRJNA630162_P_NODE_133553_length_168_cov_2.697479_g132030_i0 PRJNA630162 133553 168 2.697479 4.53176472 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 97.1 4.13e-22   NR CEO98710.1 37360 g132030 i0 81.8 1.96428571428571 55 10 98.2 0 167 3 151 205 CEO98710.1 hypothetical protein PBRA_006824 [Plasmodiophora brassicae] diamond 330 97.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30617647 30617647 PRJNA630162_P_NODE_106053_length_182_cov_1.406015_g104530_i0 PRJNA630162 106053 182 1.406015 2.5589473 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 65.1 2.18e-10   NR CEO98004.1 37360 g104530 i0 53.6 0.923076923076923 56 26 92.3 0 10 177 1091 1146 CEO98004.1 hypothetical protein PBRA_006118 [Plasmodiophora brassicae] diamond 168 65.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30649295 30649295 PRJNA630162_P_NODE_92953_length_190_cov_1.333333_g91430_i0 PRJNA630162 92953 190 1.333333 2.5333327 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 57.4 5.04e-9   NR CEP01596.1 37360 g91430 i0 50 0.789473684210526 50 23 77.4 2 185 39 26 74 CEP01596.1 hypothetical protein PBRA_008538 [Plasmodiophora brassicae] diamond 150 57.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31515816 31515816 PRJNA630162_P_NODE_84916_length_196_cov_1.965986_g83393_i0 PRJNA630162 84916 196 1.965986 3.85333256 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 84.7 4.38e-19   NR CEO95161.1 37360 g83393 i0 74.5 28.4081632653061 55 14 84.2 0 31 195 1 55 CEO95161.1 hypothetical protein PBRA_003927 [Plasmodiophora brassicae] diamond 5568 85.1 0.995299647473561 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31819162 31819162 PRJNA630162_P_NODE_91537_length_191_cov_1.183099_g90014_i0 PRJNA630162 91537 191 1.183099 2.25971909 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 47 5.95e-4   NR SPQ96610.1 37360 g90014 i0 46.4 1.75916230366492 56 27 86.4 2 182 18 281 334 SPQ96610.1 unnamed protein product [Plasmodiophora brassicae] diamond 336 47 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32736054 32736054 PRJNA630162_P_NODE_164240_length_160_cov_2.162162_g162717_i0 PRJNA630162 164240 160 2.162162 3.4594592 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 57 1.01e-7   NR CEP01021.1 37360 g162717 i0 57.4 0.88125 47 20 88.1 0 6 146 117 163 CEP01021.1 hypothetical protein PBRA_008333 [Plasmodiophora brassicae] diamond 141 57 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);;