RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1148190", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA1148190 · 18 ✖

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
21971186 21971186 PRJNA1148190_P_NODE_347178_length_301_cov_2.105263_g336005_i0 PRJNA1148190 347178 301 2.105263 6.33684163 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 83.6 2.28e-16   NR YP_010227891.1 41456 g336005 i0 75 6.69767441860465 48 12 47.8 0 153 296 337 384 YP_010227891.1 NADH dehydrogenase subunit 7 [Polymyxa betae] diamond 2016 84 0.995238095238095 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Polymyxa Polymyxa betae
26881757 26881757 PRJNA1148190_P_NODE_573721_length_252_cov_1.921788_g562548_i0 PRJNA1148190 573721 252 1.921788 4.84290576 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 50.1 1.09e-4   NR CEP03071.1 37360 g562548 i0 45.2 0.5 42 23 50 0 5 130 382 423 CEP03071.1 hypothetical protein PBRA_009289 [Plasmodiophora brassicae] diamond 126 50.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27071197 27071197 PRJNA1148190_P_NODE_450242_length_276_cov_1.517241_g439069_i0 PRJNA1148190 450242 276 1.517241 4.18758516 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 57 5.21e-7   NR SPQ96899.1 37360 g439069 i0 65.7 1.79347826086957 35 12 38 0 6 110 401 435 SPQ96899.1 unnamed protein product [Plasmodiophora brassicae] diamond 495 57 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27639909 27639909 PRJNA1148190_P_NODE_356704_length_298_cov_1.368889_g345531_i0 PRJNA1148190 356704 298 1.368889 4.07928922 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 50.8 8.72e-5   NR CEP03576.1 37360 g345531 i0 47.6 0.634228187919463 63 31 62.4 2 3 188 232 293 CEP03576.1 hypothetical protein PBRA_009461 [Plasmodiophora brassicae] diamond 189 50.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27735543 27735543 PRJNA1148190_P_NODE_90504_length_567_cov_1.159919_g79366_i0 PRJNA1148190 90504 567 1.159919 6.57674073 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 52 3.82e-4   NR CEP02222.1 37360 g79366 i0 31.2 1.12169312169312 109 58 57.7 4 68 394 132 223 CEP02222.1 hypothetical protein PBRA_002487 [Plasmodiophora brassicae] diamond 636 52 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28270774 28270774 PRJNA1148190_P_NODE_225606_length_358_cov_1.080702_g214436_i0 PRJNA1148190 225606 358 1.080702 3.86891316 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0267   NR MES1921078.1 126728 g214436 i0 31.3 2.32960893854749 96 49 78.8 3 40 321 16 96 MES1921078.1 hypothetical protein [Bonamia ostreae] diamond 834 44.7 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
28302729 28302729 PRJNA1148190_P_NODE_322966_length_310_cov_2.455696_g311793_i0 PRJNA1148190 322966 310 2.455696 7.6126576 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 81.3 1.51e-15   NR CEO94760.1 37360 g311793 i0 83.3 1.41290322580645 48 8 46.5 0 145 2 11 58 CEO94760.1 hypothetical protein PBRA_003573 [Plasmodiophora brassicae] diamond 438 81.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28807239 28807239 PRJNA1148190_P_NODE_112388_length_500_cov_1.508197_g101226_i0 PRJNA1148190 112388 500 1.508197 7.540985 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 70.5 7.67e-11   NR CEO99687.1 37360 g101226 i0 47.7 1.278 65 34 39 0 216 410 201 265 CEO99687.1 hypothetical protein PBRA_007420 [Plasmodiophora brassicae] diamond 639 70.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29459323 29459323 PRJNA1148190_P_NODE_686130_length_246_cov_0.890173_g674957_i0 PRJNA1148190 686130 246 0.890173 2.18982558 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0152   NR CEO97887.1 37360 g674957 i0 37.5 1.4390243902439 56 35 68.3 0 16 183 132 187 CEO97887.1 hypothetical protein PBRA_006001 [Plasmodiophora brassicae] diamond 354 44.3 0.99097065462754 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29597503 29597503 PRJNA1148190_P_NODE_675610_length_246_cov_1.630058_g664437_i0 PRJNA1148190 675610 246 1.630058 4.00994268 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 66.2 5.23e-12   NR CEO97585.1 37360 g664437 i0 63.3 0.597560975609756 49 15 59.8 1 91 237 3 48 CEO97585.1 hypothetical protein PBRA_000931 [Plasmodiophora brassicae] diamond 147 66.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30439009 30439009 PRJNA1148190_P_NODE_663853_length_247_cov_0.885057_g652680_i0 PRJNA1148190 663853 247 0.885057 2.18609079 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.018   NR CEO95723.1 37360 g652680 i0 31.1 2.12550607287449 61 42 74.1 0 206 24 7 67 CEO95723.1 hypothetical protein PBRA_004436 [Plasmodiophora brassicae] diamond 525 42 0.990476190476191 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30482259 30482259 PRJNA1148190_P_NODE_600433_length_250_cov_1.401130_g589260_i0 PRJNA1148190 600433 250 1.40113 3.502825 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.92e-6   NR SPR02116.1 37360 g589260 i0 37.8 0.984 82 47 98.4 2 250 5 885 962 SPR02116.1 unnamed protein product [Plasmodiophora brassicae] diamond 246 55.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31102115 31102115 PRJNA1148190_P_NODE_502495_length_266_cov_1.440415_g491322_i0 PRJNA1148190 502495 266 1.440415 3.8315039 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 67 1e-10   NR SPR00934.1 37360 g491322 i0 60.8 6.54135338345865 51 19 57.5 1 185 33 92 141 SPR00934.1 unnamed protein product [Plasmodiophora brassicae] diamond 1740 67.4 0.99406528189911 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31366511 31366511 PRJNA1148190_P_NODE_176696_length_397_cov_2.030864_g165527_i0 PRJNA1148190 176696 397 2.030864 8.06253008 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 54.7 1.29e-5   NR CEP01554.1 37360 g165527 i0 53.2 0.355163727959698 47 22 35.5 0 46 186 164 210 CEP01554.1 hypothetical protein PBRA_002159 [Plasmodiophora brassicae] diamond 141 54.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31967079 31967079 PRJNA1148190_P_NODE_114598_length_494_cov_5.779097_g103436_i0 PRJNA1148190 114598 494 5.779097 28.54873918 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 82.4 6.9e-17   NR MES1922389.1 126728 g103436 i0 44.7 1.70647773279352 94 50 55.9 1 4 279 19 112 MES1922389.1 hypothetical protein [Bonamia ostreae] diamond 843 82.4 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
32430913 32430913 PRJNA1148190_P_NODE_662539_length_247_cov_0.885057_g651366_i0 PRJNA1148190 662539 247 0.885057 2.18609079 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 64.7 6.87e-10   NR SPQ98687.1 37360 g651366 i0 51.9 1.8582995951417 52 25 63.2 0 3 158 510 561 SPQ98687.1 unnamed protein product [Plasmodiophora brassicae] diamond 459 64.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32538222 32538222 PRJNA1148190_P_NODE_99699_length_535_cov_13.032468_g88544_i0 PRJNA1148190 99699 535 13.032468 69.7237038 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 81.6 2.05e-16   NR MES1922389.1 126728 g88544 i0 44.7 1.57570093457944 94 50 51.6 1 4 279 19 112 MES1922389.1 hypothetical protein [Bonamia ostreae] diamond 843 81.6 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
32789544 32789544 PRJNA1148190_P_NODE_657140_length_247_cov_1.465517_g645967_i0 PRJNA1148190 657140 247 1.465517 3.61982699 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0383   NR SPQ97295.1 37360 g645967 i0 45 0.48582995951417 40 22 48.6 0 191 72 204 243 SPQ97295.1 unnamed protein product [Plasmodiophora brassicae] diamond 120 42.7 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);;