RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA438687 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
435242 435242 PRJNA438687_S_NODE_1061_length_371_cov_10.604167_g971_i0 PRJNA438687 1061 371 10.604167 39.34145957 Polymyxa graminis 70182 SAR_Eukaryotes SAR_Eukaryotes 501 2.909999999999999e-137   NTclustered gi|15088520|gb|AF310898.1|AF310898 70182 g971 i0 90.981 90.3369272237197 377 27 100 5 1 371 379 4 Polymyxa graminis 18S small subunit ribosomal RNA gene, partial sequence blastn 33515 501 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Polymyxa Polymyxa graminis
9363341 9363341 PRJNA438687_S_NODE_4768_length_203_cov_6.083333_g4678_i0 PRJNA438687 4768 203 6.083333 12.34916599 Woronina pythii 1484336 SAR_Eukaryotes SAR_Eukaryotes 303 4.42e-78   NTclustered gi|1031965309|gb|KX011114.1| 1484336 g4678 i0 93.627 97.3497536945813 204 11 100 2 1 203 4175 3973 Woronina pythii isolate PD0236 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 19762 303 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Woronina Woronina pythii
10639149 10639149 PRJNA438687_S_NODE_2369_length_288_cov_5.525692_g2279_i0 PRJNA438687 2369 288 5.525692 15.91399296 uncultured Plasmodiophoridae 243295 SAR_Eukaryotes SAR_Eukaryotes 483 7.969999999999997e-132   NTclustered gi|607252038|gb|KF111217.1| 243295 g2279 i0 97.193 97.1631944444444 285 8 99 0 1 285 442 726 Uncultured plasmodiophorid clone PD0477 18S ribosomal RNA gene, partial sequence blastn 27983 483 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida     uncultured Plasmodiophoridae
10639192 10639192 PRJNA438687_S_NODE_4169_length_217_cov_8.302198_g4079_i0 PRJNA438687 4169 217 8.302198 18.01576966 Spongospora sp. HH-2014 1483711 SAR_Eukaryotes SAR_Eukaryotes 368 1.68e-97   NTclustered gi|605052146|gb|KJ150290.1| 1483711 g4079 i0 97.664 61.4423963133641 214 5 99 0 4 217 4053 3840 Spongospora sp. HH-2014 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 13333 368 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Spongospora Spongospora sp. HH-2014
11914071 11914071 PRJNA438687_S_NODE_5330_length_191_cov_10.141026_g5240_i0 PRJNA438687 5330 191 10.141026 19.36935966 Woronina pythii 1484336 SAR_Eukaryotes SAR_Eukaryotes 219 1.5299999999999999e-52   NTclustered gi|1031965309|gb|KX011114.1| 1484336 g5240 i0 87.565 74.0994764397906 193 18 99 5 1 190 3812 4001 Woronina pythii isolate PD0236 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 14153 219 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Woronina Woronina pythii
13188932 13188932 PRJNA438687_S_NODE_1451_length_337_cov_4.536424_g1361_i0 PRJNA438687 1451 337 4.536424 15.28774888 Spongospora subterranea 70186 SAR_Eukaryotes SAR_Eukaryotes 568 2.5499999999999993e-157   NTclustered gi|15088521|gb|AF310899.1|AF310899 166267 g1361 i0 97.033 88.813056379822 337 10 100 0 1 337 358 22 Spongospora subterranea f. sp. subterranea 18S small subunit ribosomal RNA gene, partial sequence blastn 29930 568 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Spongospora Spongospora subterranea
22111959 22111959 PRJNA438687_S_NODE_4338_length_213_cov_6.028090_g4248_i0 PRJNA438687 4338 213 6.02809 12.8398317 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 215 2.26e-51   NTclustered gi|1031965310|gb|KX011115.1| 37360 g4248 i0 100 51.3990610328638 116 0 54 0 38 153 7784 7899 Plasmodiophora brassicae isolate AT 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 10948 215 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
23387558 23387558 PRJNA438687_S_NODE_6719_length_168_cov_4.541353_g6629_i0 PRJNA438687 6719 168 4.541353 7.62947304 Spongospora sp. HH-2014 1483711 SAR_Eukaryotes SAR_Eukaryotes 311 2.11e-80   NTclustered gi|605052146|gb|KJ150290.1| 1483711 g6629 i0 100 71.6071428571429 168 0 100 0 1 168 2315 2482 Spongospora sp. HH-2014 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 12030 311 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Spongospora Spongospora sp. HH-2014

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);;