RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA675331", 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 · 17 ✖

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA675331 · 17 ✖

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
647705 647705 PRJNA675331_P_NODE_3961_length_473_cov_1.857500_g3789_i0 PRJNA675331 3961 473 1.8575 8.785975 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 206 4.26e-59   NR SPQ94571.1 37360 g3789 i0 62.4 0.995771670190275 157 59 99.6 0 2 472 306 462 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 471 206 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
2443877 2443877 PRJNA675331_P_NODE_21162_length_246_cov_0.890173_g20990_i0 PRJNA675331 21162 246 0.890173 2.18982558 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 90.9 4.37e-19   NR CEP03425.1 37360 g20990 i0 51.9 0.98780487804878 81 39 98.8 0 1 243 179 259 CEP03425.1 hypothetical protein PBRA_003185 [Plasmodiophora brassicae] diamond 243 90.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
3198603 3198603 PRJNA675331_P_NODE_12763_length_285_cov_1.599057_g12591_i0 PRJNA675331 12763 285 1.599057 4.55731245 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 138 4.64e-39   NR CEO99344.1 37360 g12591 i0 71.4 1.91578947368421 91 25 95.8 1 283 11 38 127 CEO99344.1 hypothetical protein PBRA_001250, partial [Plasmodiophora brassicae] diamond 546 138 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
5751344 5751344 PRJNA675331_P_NODE_4125_length_465_cov_1.178571_g3953_i0 PRJNA675331 4125 465 1.178571 5.48035515 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 241 6.5e-78   NR CEO98386.1 37360 g3953 i0 79.9 0.993548387096774 154 31 99.4 0 2 463 7 160 CEO98386.1 hypothetical protein PBRA_006500 [Plasmodiophora brassicae] diamond 462 241 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
10097217 10097217 PRJNA675331_P_NODE_9488_length_321_cov_1.584677_g9316_i0 PRJNA675331 9488 321 1.584677 5.08681317 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 189 1.46e-58   NR CEO98592.1 37360 g9316 i0 83 1.98130841121495 106 18 99.1 0 319 2 27 132 CEO98592.1 hypothetical protein PBRA_006706 [Plasmodiophora brassicae] diamond 636 189 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
10851751 10851751 PRJNA675331_P_NODE_15229_length_270_cov_1.111675_g15057_i0 PRJNA675331 15229 270 1.111675 3.0015225 Leptophrys sp. 1 LAK-2013 1365646 SAR_Eukaryotes SAR_Eukaryotes 351 2.1799999999999995e-92   NTclustered gi|525031575|gb|KC174718.1| 1365646 g15057 i0 90.602 74.7555555555556 266 23 98 2 1 265 110 374 Leptophrys sp. 1 LAK-2013 heat shock protein 90 (HSP90) gene, partial cds blastn 20184 351 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Leptophrys Leptophrys sp. 1 LAK-2013
26765440 26765440 PRJNA675331_P_NODE_10701_length_306_cov_2.214592_g10529_i0 PRJNA675331 10701 306 2.214592 6.77665152 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 142 5.149999999999999e-37   NR SPQ94571.1 37360 g10529 i0 70.3 1.98039215686275 101 30 99 0 304 2 433 533 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 606 142 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27144734 27144734 PRJNA675331_P_NODE_8762_length_332_cov_1.486486_g8590_i0 PRJNA675331 8762 332 1.486486 4.93513352 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 65.9 7.98e-10   NR CEO95180.1 37360 g8590 i0 34.1 0.822289156626506 91 58 80.4 1 1 267 107 197 CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] diamond 273 65.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28198943 28198943 PRJNA675331_P_NODE_22366_length_244_cov_0.900585_g22194_i0 PRJNA675331 22366 244 0.900585 2.1974274 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 98.2 9.65e-23   NR CEP03599.1 37360 g22194 i0 57.3 5.28688524590164 82 33 98.4 1 3 242 17 98 CEP03599.1 hypothetical protein PBRA_009484 [Plasmodiophora brassicae] diamond 1290 98.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29544885 29544885 PRJNA675331_P_NODE_5210_length_419_cov_1.780347_g5038_i0 PRJNA675331 5210 419 1.780347 7.45965393 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 162 5.849999999999999e-48   NR CEO99768.1 37360 g5038 i0 69.8 0.83054892601432 116 35 83.1 0 398 51 1 116 CEO99768.1 hypothetical protein PBRA_007502 [Plasmodiophora brassicae] diamond 348 162 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30492722 30492722 PRJNA675331_P_NODE_22993_length_243_cov_0.905882_g22821_i0 PRJNA675331 22993 243 0.905882 2.20129326 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 101 9.78e-25   NR CEP01084.1 37360 g22821 i0 64.9 3.80246913580247 77 27 95.1 0 242 12 109 185 CEP01084.1 hypothetical protein PBRA_008396 [Plasmodiophora brassicae] diamond 924 101 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31092987 31092987 PRJNA675331_P_NODE_20895_length_246_cov_0.890173_g20723_i0 PRJNA675331 20895 246 0.890173 2.18982558 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.96e-20   NR CEP00899.1 37360 g20723 i0 56.3 1.96341463414634 80 35 97.6 0 244 5 946 1025 CEP00899.1 hypothetical protein PBRA_008211 [Plasmodiophora brassicae] diamond 483 94.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31630521 31630521 PRJNA675331_P_NODE_11356_length_299_cov_1.075221_g11184_i0 PRJNA675331 11356 299 1.075221 3.21491079 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 92.8 1.69e-21   NR SPQ97426.1 37360 g11184 i0 58.1 12.2508361204013 86 35 85.3 1 44 298 14 99 SPQ97426.1 unnamed protein product [Plasmodiophora brassicae] diamond 3663 92.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31757057 31757057 PRJNA675331_P_NODE_18997_length_250_cov_0.870056_g18825_i0 PRJNA675331 18997 250 0.870056 2.17514 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 63.9 5.77e-11   NR CEP02593.1 37360 g18825 i0 50.8 1.5 63 30 74.4 1 64 249 7 69 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 375 63.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32073492 32073492 PRJNA675331_P_NODE_7098_length_364_cov_1.498282_g6926_i0 PRJNA675331 7098 364 1.498282 5.45374648 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 63.5 7.69e-9   NR SPQ94571.1 37360 g6926 i0 58.7 0.379120879120879 46 19 37.9 0 1 138 688 733 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 138 63.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32136821 32136821 PRJNA675331_P_NODE_19178_length_249_cov_0.875000_g19006_i0 PRJNA675331 19178 249 0.875 2.17875 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 115 5.42e-28   NR SPQ96535.1 37360 g19006 i0 67.1 0.987951807228916 82 27 98.8 0 247 2 125 206 SPQ96535.1 unnamed protein product [Plasmodiophora brassicae] diamond 246 115 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32516672 32516672 PRJNA675331_P_NODE_22559_length_243_cov_1.358824_g22387_i0 PRJNA675331 22559 243 1.358824 3.30194232 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 67 1.01e-10   NR CEP02626.1 37360 g22387 i0 46.8 0.950617283950617 77 41 95.1 0 238 8 226 302 CEP02626.1 hypothetical protein PBRA_002593 [Plasmodiophora brassicae] diamond 231 67 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);;