RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA436017 · 12 ✖

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
7467165 7467165 PRJNA436017_P_NODE_2966_length_544_cov_3.072978_g2693_i0 PRJNA436017 2966 544 3.072978 16.71700032 Gromia 35216 SAR_Eukaryotes SAR_Eukaryotes 195 8.4e-45   NTclustered gi|21489383|emb|AJ457812.1| 35217 g2693 i0 83.256 32.8419117647059 215 33 39 2 20 231 526 312 Gromia oviformis partial 18S rRNA gene, country Reunion blastn 17866 195 1 Eukaryota Sar   Endomyxa   Gromiida Gromiidae Gromia Gromia oviformis
14459769 14459769 PRJNA436017_P_NODE_5152_length_401_cov_2.541209_g4856_i0 PRJNA436017 5152 401 2.541209 10.19024809 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 163 1.08e-46   NR CEO97280.1 37360 g4856 i0 62.1 5.88778054862843 132 49 98.8 1 396 1 81 211 CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] diamond 2361 163 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
15733221 15733221 PRJNA436017_P_NODE_11993_length_245_cov_2.245192_g11695_i0 PRJNA436017 11993 245 2.245192 5.5007204 Phytomyxea 2779609 SAR_Eukaryotes SAR_Eukaryotes 95.9 2.25e-23   NR SYZ47136.1 37360 g11695 i0 63 10.7387755102041 73 26 89.4 1 6 224 50 121 SYZ47136.1 ab16c95a-03d5-49c9-97d0-94a95f8a6b5f-CDS [Plasmodiophora brassicae] diamond 2631 95.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26807536 26807536 PRJNA436017_P_NODE_3621_length_491_cov_2.376652_g3338_i0 PRJNA436017 3621 491 2.376652 11.66936132 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 150 1.04e-38   NR SPQ94571.1 37360 g3338 i0 54.1 8.93890020366599 146 66 88.6 1 9 443 487 632 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 4389 151 0.993377483443709 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27123555 27123555 PRJNA436017_P_NODE_23062_length_170_cov_1.172932_g22764_i0 PRJNA436017 23062 170 1.172932 1.9939844 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 66.6 4.08e-11   NR SPQ99938.1 37360 g22764 i0 60 11.7352941176471 55 22 97.1 0 2 166 249 303 SPQ99938.1 unnamed protein product [Plasmodiophora brassicae] diamond 1995 66.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27138670 27138670 PRJNA436017_P_NODE_2362_length_616_cov_1.892919_g2111_i0 PRJNA436017 2362 616 1.892919 11.66038104 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 96.3 6.17e-22   NR CEP02593.1 37360 g2111 i0 54.3 0.457792207792208 94 43 45.8 0 72 353 11 104 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 282 96.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27581288 27581288 PRJNA436017_P_NODE_16624_length_202_cov_1.406061_g16326_i0 PRJNA436017 16624 202 1.406061 2.84024322 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 76.6 1.07e-14   NR CEP01486.1 37360 g16326 i0 64.2 0.787128712871287 53 19 78.7 0 200 42 239 291 CEP01486.1 hypothetical protein PBRA_002092 [Plasmodiophora brassicae] diamond 159 76.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28166191 28166191 PRJNA436017_P_NODE_3525_length_498_cov_2.223427_g3244_i0 PRJNA436017 3525 498 2.223427 11.07266646 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 171 1.72e-51   NR CEO96284.1 37360 g3244 i0 58.5 6.93975903614458 142 59 85.5 0 476 51 1 142 CEO96284.1 hypothetical protein PBRA_004955 [Plasmodiophora brassicae] diamond 3456 171 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28370637 28370637 PRJNA436017_P_NODE_24606_length_164_cov_2.149606_g24308_i0 PRJNA436017 24606 164 2.149606 3.52535384 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0324   NR CEO98446.1 37360 g24308 i0 44.6 1.02439024390244 56 27 95.1 2 161 6 65 120 CEO98446.1 hypothetical protein PBRA_006560 [Plasmodiophora brassicae] diamond 168 41.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28450473 28450473 PRJNA436017_P_NODE_8726_length_296_cov_2.281853_g8428_i0 PRJNA436017 8726 296 2.281853 6.75428488 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 130 9.87e-37   NR CEO94766.1 37360 g8428 i0 68.4 9.71959459459459 95 30 96.3 0 1 285 4 98 CEO94766.1 hypothetical protein PBRA_003579 [Plasmodiophora brassicae] diamond 2877 130 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29696458 29696458 PRJNA436017_P_NODE_9150_length_288_cov_1.856574_g8852_i0 PRJNA436017 9150 288 1.856574 5.34693312 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 104 1.09e-25   NR CEO96604.1 37360 g8852 i0 65.8 2.52083333333333 76 26 79.2 0 287 60 104 179 CEO96604.1 hypothetical protein PBRA_005213 [Plasmodiophora brassicae] diamond 726 104 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30629201 30629201 PRJNA436017_P_NODE_5973_length_367_cov_1.878788_g5677_i0 PRJNA436017 5973 367 1.878788 6.89515196 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82 2.7e-15   NR CEO96359.1 37360 g5677 i0 52.9 6.86648501362398 70 33 57.2 0 366 157 774 843 CEO96359.1 hypothetical protein PBRA_005030 [Plasmodiophora brassicae] diamond 2520 82 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);;