RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA561212", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 17 ✖

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA561212 · 17 ✖

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
25357034 25357034 PRJNA561212_P_NODE_25360_length_243_cov_0.917647_g25149_i0 PRJNA561212 25360 243 0.917647 2.22988221 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 140 1.21e-36   NR CEO96268.1 37360 g25149 i0 85.7 105.592592592593 77 11 95.1 0 4 234 332 408 CEO96268.1 hypothetical protein PBRA_004939 [Plasmodiophora brassicae] diamond 25659 141 0.99290780141844 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27141924 27141924 PRJNA561212_P_NODE_13782_length_301_cov_1.302632_g13571_i0 PRJNA561212 13782 301 1.302632 3.92092232 Gromia oviformis 35217 SAR_Eukaryotes SAR_Eukaryotes 89.7 4.82e-19   NR AAQ75374.1 35217 g13571 i0 47.4 5.78073089700997 97 49 94.7 1 293 9 72 168 AAQ75374.1 actin, partial [Gromia oviformis] diamond 1740 89.7 1 Eukaryota Sar   Endomyxa   Gromiida Gromiidae Gromia Gromia oviformis
27268682 27268682 PRJNA561212_P_NODE_14443_length_295_cov_0.972973_g14232_i0 PRJNA561212 14443 295 0.972973 2.87027035 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 70.9 7.73e-12   NR CEO99582.1 37360 g14232 i0 44.4 0.915254237288136 90 38 87.5 3 33 290 138 219 CEO99582.1 hypothetical protein PBRA_007315 [Plasmodiophora brassicae] diamond 270 70.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27395386 27395386 PRJNA561212_P_NODE_8263_length_381_cov_3.977273_g8052_i0 PRJNA561212 8263 381 3.977273 15.15341013 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 42 0.0405   NR CEO95196.1 37360 g8052 i0 35.1 0.606299212598425 77 42 56.7 3 361 146 2 75 CEO95196.1 hypothetical protein PBRA_003962 [Plasmodiophora brassicae] diamond 231 42 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27521367 27521367 PRJNA561212_P_NODE_10023_length_349_cov_0.818841_g9812_i0 PRJNA561212 10023 349 0.818841 2.85775509 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 66.2 4.18e-10   NR CEO99915.1 37360 g9812 i0 51 0.438395415472779 51 25 43.8 0 341 189 180 230 CEO99915.1 hypothetical protein PBRA_007649 [Plasmodiophora brassicae] diamond 153 66.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27868633 27868633 PRJNA561212_P_NODE_2565_length_686_cov_3.187602_g2361_i0 PRJNA561212 2565 686 3.187602 21.86694972 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.47e-13   NR CEO99915.1 37360 g2361 i0 44.1 0.446064139941691 102 51 42.9 4 380 87 68 167 CEO99915.1 hypothetical protein PBRA_007649 [Plasmodiophora brassicae] diamond 306 79.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28089738 28089738 PRJNA561212_P_NODE_7365_length_405_cov_1.030120_g7154_i0 PRJNA561212 7365 405 1.03012 4.171986 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00502   NR SPR01585.1 37360 g7154 i0 28.1 1.8962962962963 128 77 89.6 6 18 380 443 562 SPR01585.1 unnamed protein product [Plasmodiophora brassicae] diamond 768 47.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28577308 28577308 PRJNA561212_P_NODE_6467_length_433_cov_1.858333_g6256_i0 PRJNA561212 6467 433 1.858333 8.04658189 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 148 3.79e-41   NR CEO95994.1 37360 g6256 i0 56.8 2.79214780600462 132 54 91.5 1 38 433 29 157 CEO95994.1 hypothetical protein PBRA_004684 [Plasmodiophora brassicae] diamond 1209 149 0.993288590604027 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29051105 29051105 PRJNA561212_P_NODE_2588_length_682_cov_1.558292_g2384_i0 PRJNA561212 2588 682 1.558292 10.62755144 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 190 3.95e-56   NR CEO98446.1 37360 g2384 i0 52.1 4.29325513196481 211 96 92.4 3 640 11 17 223 CEO98446.1 hypothetical protein PBRA_006560 [Plasmodiophora brassicae] diamond 2928 190 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29668150 29668150 PRJNA561212_P_NODE_13830_length_301_cov_0.951754_g13619_i0 PRJNA561212 13830 301 0.951754 2.86477954 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 91.3 1.53e-19   NR CEP03906.1 37360 g13619 i0 46.9 1.92358803986711 96 43 95.7 1 295 8 109 196 CEP03906.1 hypothetical protein PBRA_003513 [Plasmodiophora brassicae] diamond 579 91.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29826257 29826257 PRJNA561212_P_NODE_6851_length_421_cov_1.040230_g6640_i0 PRJNA561212 6851 421 1.04023 4.3793683 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 168 6.98e-49   NR CEP01961.1 37360 g6640 i0 60 0.961995249406176 135 54 96.2 0 411 7 51 185 CEP01961.1 hypothetical protein PBRA_002226 [Plasmodiophora brassicae] diamond 405 168 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30535315 30535315 PRJNA561212_P_NODE_9573_length_356_cov_1.268551_g9362_i0 PRJNA561212 9573 356 1.268551 4.51604156 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 65.1 1.96e-9   NR CEO94610.1 37360 g9362 i0 38.4 2.81460674157303 86 53 72.5 0 268 11 422 507 CEO94610.1 hypothetical protein PBRA_000395, partial [Plasmodiophora brassicae] diamond 1002 65.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31533028 31533028 PRJNA561212_P_NODE_18296_length_266_cov_1.108808_g18085_i0 PRJNA561212 18296 266 1.108808 2.94942928 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 48.9 3.34e-4   NR CEO99849.1 37360 g18085 i0 49.1 0.642857142857143 57 27 64.3 1 10 180 52 106 CEO99849.1 hypothetical protein PBRA_007583 [Plasmodiophora brassicae] diamond 171 48.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31754215 31754215 PRJNA561212_P_NODE_9117_length_364_cov_1.573883_g8906_i0 PRJNA561212 9117 364 1.573883 5.72893412 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 50.8 2.18e-4   NR SPQ96039.1 37360 g8906 i0 49.1 0.873626373626374 53 27 43.7 0 362 204 1430 1482 SPQ96039.1 unnamed protein product [Plasmodiophora brassicae] diamond 318 50.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31912397 31912397 PRJNA561212_P_NODE_2597_length_680_cov_2.299835_g2393_i0 PRJNA561212 2597 680 2.299835 15.638878 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 88.2 7.9e-17   NR CEO99915.1 37360 g2393 i0 46.4 0.485294117647059 110 55 47.6 2 653 330 172 279 CEO99915.1 hypothetical protein PBRA_007649 [Plasmodiophora brassicae] diamond 330 88.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31957910 31957910 PRJNA561212_P_NODE_6017_length_449_cov_3.507979_g5806_i0 PRJNA561212 6017 449 3.507979 15.75082571 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.23e-14   NR CEO95994.1 37360 g5806 i0 55.9 1.25612472160356 93 41 62.1 0 20 298 189 281 CEO95994.1 hypothetical protein PBRA_004684 [Plasmodiophora brassicae] diamond 564 79.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32545474 32545474 PRJNA561212_P_NODE_19339_length_258_cov_1.610811_g19128_i0 PRJNA561212 19339 258 1.610811 4.15589238 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 78.2 8.49e-15   NR SPQ96630.1 37360 g19128 i0 61.5 3.32558139534884 65 22 75.6 2 245 51 75 136 SPQ96630.1 unnamed protein product [Plasmodiophora brassicae] diamond 858 78.2 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);;