RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA429937", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA429937 · 15 ✖

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
4253961 4253961 PRJNA429937_P_NODE_5664_length_1461_cov_3.968575_g3329_i0 PRJNA429937 5664 1461 3.968575 57.98088075 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 742 5.02e-261   NR CEO96270.1 37360 g3329 i0 86.7 0.864476386036961 421 55 86.2 1 1274 15 418 838 CEO96270.1 hypothetical protein PBRA_004941 [Plasmodiophora brassicae] diamond 1263 742 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
8080653 8080653 PRJNA429937_P_NODE_73947_length_387_cov_7.793296_g51969_i0 PRJNA429937 73947 387 7.793296 30.16005552 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 335 3.2799999999999987e-87   NTclustered gi|1031965310|gb|KX011115.1| 37360 g51969 i0 97.938 47.8682170542636 194 3 50 1 194 387 7899 7707 Plasmodiophora brassicae isolate AT 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 18525 335 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
10631198 10631198 PRJNA429937_P_NODE_73949_length_387_cov_7.717877_g51971_i0 PRJNA429937 73949 387 7.717877 29.86818399 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 329 1.52e-85   NTclustered gi|1031965310|gb|KX011115.1| 37360 g51971 i0 97.423 39.1421188630491 194 4 50 1 1 194 7707 7899 Plasmodiophora brassicae isolate AT 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 15148 329 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
13180812 13180812 PRJNA429937_P_NODE_6251_length_1402_cov_4.053897_g3329_i1 PRJNA429937 6251 1402 4.053897 56.83563594 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 742 2.29e-261   NR CEO96270.1 37360 g3329 i1 86.7 0.900855920114123 421 55 89.9 1 129 1388 418 838 CEO96270.1 hypothetical protein PBRA_004941 [Plasmodiophora brassicae] diamond 1263 742 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27075690 27075690 PRJNA429937_P_NODE_13782_length_986_cov_12.272727_g8147_i0 PRJNA429937 13782 986 12.272727 121.00908822 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.96e-15   NR SPQ98550.1 37360 g8147 i0 56 0.276876267748479 91 19 27.7 2 496 224 819 888 SPQ98550.1 unnamed protein product [Plasmodiophora brassicae] diamond 273 89.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27707983 27707983 PRJNA429937_P_NODE_17564_length_878_cov_3.512367_g6985_i1 PRJNA429937 17564 878 3.512367 30.83858226 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 264 3.13e-76   NR SPQ98950.1 37360 g6985 i1 53.3 0.826879271070615 242 112 82.7 1 850 125 6739 6979 SPQ98950.1 unnamed protein product [Plasmodiophora brassicae] diamond 726 264 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28591680 28591680 PRJNA429937_P_NODE_107547_length_281_cov_2.448413_g84927_i0 PRJNA429937 107547 281 2.448413 6.88004053 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 102 8.86e-25   NR CEO96912.1 37360 g84927 i0 56.3 0.928825622775801 87 36 90.7 1 281 27 136 222 CEO96912.1 hypothetical protein PBRA_005516 [Plasmodiophora brassicae] diamond 261 102 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29822744 29822744 PRJNA429937_P_NODE_22551_length_774_cov_3.335570_g13405_i0 PRJNA429937 22551 774 3.33557 25.8173118 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 115 7.15e-25   NR CEP00142.1 37360 g13405 i0 59.3 0.875968992248062 113 41 42.2 2 310 636 4108 4219 CEP00142.1 hypothetical protein PBRA_007876 [Plasmodiophora brassicae] diamond 678 115 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30044054 30044054 PRJNA429937_P_NODE_63191_length_432_cov_3.203474_g42861_i0 PRJNA429937 63191 432 3.203474 13.83900768 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 202 1.13e-57   NR CEO96270.1 37360 g42861 i0 73.8 0.979166666666667 141 37 97.9 0 428 6 210 350 CEO96270.1 hypothetical protein PBRA_004941 [Plasmodiophora brassicae] diamond 423 202 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30297380 30297380 PRJNA429937_P_NODE_24472_length_742_cov_3.131837_g14621_i0 PRJNA429937 24472 742 3.131837 23.23823054 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 210 8.48e-59   NR CEO96269.1 37360 g14621 i0 87.5 0.905660377358491 112 14 45.3 0 727 392 108 219 CEO96269.1 hypothetical protein PBRA_004940 [Plasmodiophora brassicae] diamond 672 210 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30392153 30392153 PRJNA429937_P_NODE_48333_length_511_cov_3.645228_g13405_i1 PRJNA429937 48333 511 3.645228 18.62711508 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 122 1.6499999999999999e-28   NR CEP00142.1 37360 g13405 i1 58.4 1.46771037181996 125 47 71 2 11 373 4096 4219 CEP00142.1 hypothetical protein PBRA_007876 [Plasmodiophora brassicae] diamond 750 122 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30455213 30455213 PRJNA429937_P_NODE_1933_length_2154_cov_5.864941_g1156_i0 PRJNA429937 1933 2154 5.864941 126.33082914 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 803 3.0500000000000003e-282   NR CEO96688.1 37360 g1156 i0 61.2 0.917827298050139 659 244 90.7 7 11 1963 66 720 CEO96688.1 hypothetical protein PBRA_005292 [Plasmodiophora brassicae] diamond 1977 803 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31466333 31466333 PRJNA429937_P_NODE_100036_length_302_cov_3.128205_g77426_i0 PRJNA429937 100036 302 3.128205 9.4471791 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 107 1.51e-24   NR CEP00142.1 37360 g77426 i0 50 1.90728476821192 96 48 95.4 0 294 7 4003 4098 CEP00142.1 hypothetical protein PBRA_007876 [Plasmodiophora brassicae] diamond 576 107 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32542113 32542113 PRJNA429937_P_NODE_9619_length_1163_cov_8.536155_g5661_i0 PRJNA429937 9619 1163 8.536155 99.27548265 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 109 2.37e-22   NR CEO96157.1 37360 g5661 i0 36.5 0.430782459157352 167 97 40.8 2 1089 616 288 454 CEO96157.1 hypothetical protein PBRA_004847 [Plasmodiophora brassicae] diamond 501 109 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32636168 32636168 PRJNA429937_P_NODE_11880_length_1058_cov_3.004859_g6985_i0 PRJNA429937 11880 1058 3.004859 31.79140822 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 263 4.83e-75   NR SPQ98950.1 37360 g6985 i0 53.1 0.683364839319471 241 112 68.3 1 29 751 6739 6978 SPQ98950.1 unnamed protein product [Plasmodiophora brassicae] diamond 723 263 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);;