RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA1092581", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA1092581 · 16 ✖

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
4023582 4023582 PRJNA1092581_P_NODE_44024_length_409_cov_5.964286_g43491_i0 PRJNA1092581 44024 409 5.964286 24.39392974 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 156 7.2e-43   NR CEO98766.1 37360 g43491 i0 83.9 1.36430317848411 93 15 68.2 0 10 288 332 424 CEO98766.1 hypothetical protein PBRA_006880 [Plasmodiophora brassicae] diamond 558 156 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
7848345 7848345 PRJNA1092581_P_NODE_10787_length_827_cov_12.135279_g10339_i0 PRJNA1092581 10787 827 12.135279 100.35875733 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 294 6.98e-97   NR CEP02495.1 37360 g10339 i0 68.3 13.7085852478839 199 63 72.2 0 806 210 44 242 CEP02495.1 hypothetical protein PBRA_009079 [Plasmodiophora brassicae] diamond 11337 295 0.996610169491525 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
12949628 12949628 PRJNA1092581_P_NODE_11951_length_791_cov_2.994429_g11484_i0 PRJNA1092581 11951 791 2.994429 23.68593339 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 273 1.1800000000000002e-79   NR CEO98004.1 37360 g11484 i0 57.1 0.830594184576485 219 91 83.1 1 790 134 4352 4567 CEO98004.1 hypothetical protein PBRA_006118 [Plasmodiophora brassicae] diamond 657 273 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
12949941 12949941 PRJNA1092581_P_NODE_17931_length_656_cov_120.084048_g17416_i0 PRJNA1092581 17931 656 120.084048 787.75135488 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 375 3.199999999999999e-130   NR CEO96142.1 37360 g17416 i0 96.8 0.859756097560976 188 6 86 0 638 75 17 204 CEO96142.1 hypothetical protein PBRA_004832 [Plasmodiophora brassicae] diamond 564 375 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
16774097 16774097 PRJNA1092581_P_NODE_4574_length_1150_cov_10.053853_g4311_i0 PRJNA1092581 4574 1150 10.053853 115.6193095 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 368 1.14e-123   NR CEO96095.1 37360 g4311 i0 62.4 0.714782608695652 274 103 71.5 0 1076 255 1 274 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 822 368 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26782925 26782925 PRJNA1092581_P_NODE_70521_length_311_cov_8.168067_g69988_i0 PRJNA1092581 70521 311 8.168067 25.40268837 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 139 8.42e-38   NR CEO99397.1 37360 g69988 i0 69.2 1.81350482315113 91 28 87.8 0 308 36 183 273 CEO99397.1 hypothetical protein PBRA_001303 [Plasmodiophora brassicae] diamond 564 139 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26940916 26940916 PRJNA1092581_P_NODE_77102_length_295_cov_9.819820_g76569_i0 PRJNA1092581 77102 295 9.81982 28.968469 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87.4 6.46e-19   NR CEO96604.1 37360 g76569 i0 53.7 0.833898305084746 82 36 83.4 1 21 266 124 203 CEO96604.1 hypothetical protein PBRA_005213 [Plasmodiophora brassicae] diamond 246 87.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28772801 28772801 PRJNA1092581_P_NODE_100547_length_252_cov_2.458101_g100014_i0 PRJNA1092581 100547 252 2.458101 6.19441452 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 174 3.95e-53   NR CEP01765.1 37360 g100014 i0 100 0.988095238095238 83 0 98.8 0 2 250 125 207 CEP01765.1 hypothetical protein PBRA_008707 [Plasmodiophora brassicae] diamond 249 174 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29332657 29332657 PRJNA1092581_P_NODE_119149_length_224_cov_10.503311_g118616_i0 PRJNA1092581 119149 224 10.503311 23.52741664 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.1e-7   NR SPR00082.1 37360 g118616 i0 43.3 1.71428571428571 67 35 89.7 1 2 202 1750 1813 SPR00082.1 unnamed protein product [Plasmodiophora brassicae] diamond 384 58.5 0.994871794871795 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30004469 30004469 PRJNA1092581_P_NODE_117171_length_228_cov_3.780645_g116638_i0 PRJNA1092581 117171 228 3.780645 8.6198706 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 141 6.9199999999999995e-37   NR SPQ95612.1 37360 g116638 i0 100 0.894736842105263 68 0 89.5 0 23 226 1219 1286 SPQ95612.1 unnamed protein product [Plasmodiophora brassicae] diamond 204 141 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30193838 30193838 PRJNA1092581_P_NODE_20172_length_619_cov_6.652015_g19653_i0 PRJNA1092581 20172 619 6.652015 41.17597285 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 134 1.5099999999999999e-32   NR SPQ95420.1 37360 g19653 i0 65.7 0.494345718901454 102 35 49.4 0 605 300 617 718 SPQ95420.1 unnamed protein product [Plasmodiophora brassicae] diamond 306 134 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30762763 30762763 PRJNA1092581_P_NODE_31434_length_493_cov_9.035714_g30902_i0 PRJNA1092581 31434 493 9.035714 44.54607002 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 150 4.359999999999999e-43   NR SPQ98117.1 37360 g30902 i0 81 2.55578093306288 84 16 51.1 0 471 220 63 146 SPQ98117.1 unnamed protein product [Plasmodiophora brassicae] diamond 1260 150 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31481387 31481387 PRJNA1092581_P_NODE_99676_length_253_cov_4.155556_g99143_i0 PRJNA1092581 99676 253 4.155556 10.51355668 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 50.4 6.36e-6   NR CEP00565.1 37360 g99143 i0 68.8 5.26482213438735 32 10 37.9 0 21 116 45 76 CEP00565.1 hypothetical protein PBRA_001619 [Plasmodiophora brassicae] diamond 1332 50.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31584724 31584724 PRJNA1092581_P_NODE_20596_length_612_cov_11.035250_g20075_i0 PRJNA1092581 20596 612 11.03525 67.53573 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 176 7.75e-51   NR SPQ93792.1 37360 g20075 i0 62 1.38725490196078 142 53 69.6 1 12 437 157 297 SPQ93792.1 unnamed protein product [Plasmodiophora brassicae] diamond 849 176 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31616148 31616148 PRJNA1092581_P_NODE_105676_length_245_cov_5.953488_g105143_i0 PRJNA1092581 105676 245 5.953488 14.5860456 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.2e-6   NR MES1919607.1 126728 g105143 i0 47.7 1.53061224489796 44 23 53.9 0 101 232 190 233 MES1919607.1 Zinc-binding domain present in Lin-11, Isl-1, Mec-3 [Bonamia ostreae] diamond 375 55.5 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
32628144 32628144 PRJNA1092581_P_NODE_46600_length_396_cov_2.811146_g46067_i0 PRJNA1092581 46600 396 2.811146 11.13213816 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 202 3.57e-57   NR SPQ95612.1 37360 g46067 i0 100 0.909090909090909 120 0 90.9 0 395 36 1285 1404 SPQ95612.1 unnamed protein product [Plasmodiophora brassicae] diamond 360 202 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);;