RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA437204", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 20 ✖

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA437204 · 20 ✖

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
2982234 2982234 PRJNA437204_P_NODE_105803_length_246_cov_0.890173_g105504_i0 PRJNA437204 105803 246 0.890173 2.18982558 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 99 2.8e-25   NR CEO99669.1 37360 g105504 i0 86.7 1.51219512195122 60 6 70.7 1 239 66 1 60 CEO99669.1 hypothetical protein PBRA_007402 [Plasmodiophora brassicae] diamond 372 99 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
9360997 9360997 PRJNA437204_P_NODE_59688_length_281_cov_2.000000_g59389_i0 PRJNA437204 59688 281 2 5.62 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 119 4.779999999999999e-31   NR CEO96711.1 37360 g59389 i0 72.6 11.7437722419929 84 21 89.7 1 254 3 1 82 CEO96711.1 hypothetical protein PBRA_005315 [Plasmodiophora brassicae] diamond 3300 120 0.991666666666667 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
11910453 11910453 PRJNA437204_P_NODE_112070_length_244_cov_0.900585_g111771_i0 PRJNA437204 112070 244 0.900585 2.1974274 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 106 3.9600000000000006e-27   NR SPQ93437.1 37360 g111771 i0 70.8 3.5655737704918 72 21 88.5 0 242 27 76 147 SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] diamond 870 106 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
15736122 15736122 PRJNA437204_P_NODE_8733_length_568_cov_1.583838_g8437_i0 PRJNA437204 8733 568 1.583838 8.99619984 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 251 5.61e-81   NR CEO96095.1 37360 g8437 i0 66.7 0.903169014084507 171 57 90.3 0 3 515 8 178 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 513 251 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
22109433 22109433 PRJNA437204_P_NODE_53738_length_292_cov_2.109589_g53439_i0 PRJNA437204 53738 292 2.109589 6.15999988 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 167 7.46e-51   NR CEO97530.1 37360 g53439 i0 86.3 0.976027397260274 95 13 97.6 0 288 4 36 130 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 285 167 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
23384747 23384747 PRJNA437204_P_NODE_39879_length_325_cov_0.932540_g39580_i0 PRJNA437204 39879 325 0.93254 3.030755 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 170 1.03e-51   NR CEP00218.1 37360 g39580 i0 74.3 10.7815384615385 109 26 98.8 1 1 321 55 163 CEP00218.1 hypothetical protein PBRA_007952 [Plasmodiophora brassicae] diamond 3504 170 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26934058 26934058 PRJNA437204_P_NODE_38162_length_329_cov_1.734375_g37863_i0 PRJNA437204 38162 329 1.734375 5.70609375 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 139 4.0699999999999997e-38   NR SPQ93792.1 37360 g37863 i0 70.8 8.38905775075988 96 27 87.5 1 298 11 157 251 SPQ93792.1 unnamed protein product [Plasmodiophora brassicae] diamond 2760 139 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27503243 27503243 PRJNA437204_P_NODE_101683_length_246_cov_1.780347_g101384_i0 PRJNA437204 101683 246 1.780347 4.37965362 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 104 1.1e-26   NR SPQ94272.1 37360 g101384 i0 70 1.92682926829268 80 24 97.6 0 1 240 22 101 SPQ94272.1 unnamed protein product [Plasmodiophora brassicae] diamond 474 104 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28418911 28418911 PRJNA437204_P_NODE_13486_length_478_cov_1.980247_g13187_i0 PRJNA437204 13486 478 1.980247 9.46558066 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 137 1.72e-38   NR CEP00946.1 37360 g13187 i0 56.4 6.45188284518828 117 51 73.4 0 49 399 3 119 CEP00946.1 hypothetical protein PBRA_008258 [Plasmodiophora brassicae] diamond 3084 137 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28781070 28781070 PRJNA437204_P_NODE_60307_length_280_cov_1.700483_g60008_i0 PRJNA437204 60307 280 1.700483 4.7613524 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 130 2.69e-36   NR CEO96284.1 37360 g60008 i0 64.4 6.86785714285714 90 32 96.4 0 277 8 1 90 CEO96284.1 hypothetical protein PBRA_004955 [Plasmodiophora brassicae] diamond 1923 130 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29223431 29223431 PRJNA437204_P_NODE_125389_length_241_cov_0.916667_g125090_i0 PRJNA437204 125389 241 0.916667 2.20916747 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 67 8.08e-11   NR SPQ97473.1 37360 g125090 i0 51.6 4.21991701244813 64 30 78.4 1 44 232 75 138 SPQ97473.1 unnamed protein product [Plasmodiophora brassicae] diamond 1017 67 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29523841 29523841 PRJNA437204_P_NODE_66610_length_270_cov_1.390863_g66311_i0 PRJNA437204 66610 270 1.390863 3.7553301 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 121 9.989999999999999e-32   NR CEO98920.1 37360 g66311 i0 59.6 1.97777777777778 89 36 98.9 0 3 269 46 134 CEO98920.1 hypothetical protein PBRA_007034 [Plasmodiophora brassicae] diamond 534 121 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29918087 29918087 PRJNA437204_P_NODE_82751_length_251_cov_0.865169_g82452_i0 PRJNA437204 82751 251 0.865169 2.17157419 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87.4 7.72e-18   NR CEO97114.1 37360 g82452 i0 43.9 6.70517928286853 82 46 98 0 1 246 159 240 CEO97114.1 hypothetical protein PBRA_005718 [Plasmodiophora brassicae] diamond 1683 87.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30423808 30423808 PRJNA437204_P_NODE_16553_length_442_cov_2.021680_g16254_i0 PRJNA437204 16553 442 2.02168 8.9358256 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 99 9.45e-24   NR CEP02593.1 37360 g16254 i0 59.3 0.549773755656109 81 33 55 0 441 199 22 102 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 243 99 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30724135 30724135 PRJNA437204_P_NODE_84054_length_250_cov_1.203390_g83755_i0 PRJNA437204 84054 250 1.20339 3.008475 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.6 1.74e-13   NR CEO98920.1 37360 g83755 i0 60 6 50 20 60 0 96 245 176 225 CEO98920.1 hypothetical protein PBRA_007034 [Plasmodiophora brassicae] diamond 1500 73.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31561437 31561437 PRJNA437204_P_NODE_60496_length_280_cov_1.425121_g60197_i0 PRJNA437204 60496 280 1.425121 3.9903388 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 70.9 7.1e-12   NR SPR01590.1 37360 g60197 i0 39.2 1.58571428571429 74 44 79.3 1 272 51 355 427 SPR01590.1 unnamed protein product [Plasmodiophora brassicae] diamond 444 70.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31687710 31687710 PRJNA437204_P_NODE_37157_length_332_cov_1.752896_g36858_i0 PRJNA437204 37157 332 1.752896 5.81961472 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 70.1 1.13e-11   NR CEP02733.1 37360 g36858 i0 48 2.60240963855422 75 37 66 1 3 221 192 266 CEP02733.1 hypothetical protein PBRA_002700 [Plasmodiophora brassicae] diamond 864 70.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32715910 32715910 PRJNA437204_P_NODE_72660_length_261_cov_1.228723_g72361_i0 PRJNA437204 72660 261 1.228723 3.20696703 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 119 2.72e-32   NR CEP03461.1 37360 g72361 i0 67.9 7.72413793103448 84 27 96.6 0 8 259 12 95 CEP03461.1 hypothetical protein PBRA_003222 [Plasmodiophora brassicae] diamond 2016 120 0.991666666666667 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32747367 32747367 PRJNA437204_P_NODE_6040_length_655_cov_4.721649_g5748_i0 PRJNA437204 6040 655 4.721649 30.92680095 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 202 5.92e-62   NR CEP02281.1 37360 g5748 i0 53.8 2.87175572519084 208 89 95.3 2 644 21 1 201 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 1881 202 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32825521 32825521 PRJNA437204_P_NODE_103440_length_246_cov_0.890173_g103141_i0 PRJNA437204 103440 246 0.890173 2.18982558 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 104 4.31e-27   NR CEP02593.1 37360 g103141 i0 65.4 0.98780487804878 81 28 98.8 0 245 3 11 91 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 243 104 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);;