contig_metadata
11 rows where bioproject = "PRJEB3181" and tax_phylum = "Microsporidia"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8983203 | 8983203 | PRJEB3181_S_NODE_2988_length_324_cov_71.432526_g2695_i0 | PRJEB3181 | 2988 | 324 | 71.432526 | 231.44138424 | Microsporidia sp. | 1984797 | Fungi | Fungi | 497 | 3.25e-136 | NTclustered | gi|1390157737|gb|MF374896.1| | 1984797 | g2695 | i0 | 99.273 | 84.2253086419753 | 275 | 2 | 85 | 0 | 1 | 275 | 33 | 307 | Microsporidia sp. isolate Q2-DKR-U 18S ribosomal RNA gene, partial sequence | blastn | 27289 | 497 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidia sp. | |||||
| 8983289 | 8983289 | PRJEB3181_S_NODE_9548_length_205_cov_30.005882_g9255_i0 | PRJEB3181 | 9548 | 205 | 30.005882 | 61.5120581 | Vittaforma corneae | 42399 | Fungi | Fungi | 233 | 5.96e-57 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g9255 | i0 | 87.745 | 1.44878048780488 | 204 | 19 | 98 | 4 | 1 | 201 | 203 | 3 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 297 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 10258803 | 10258803 | PRJEB3181_S_NODE_13569_length_175_cov_5.378571_g13276_i0 | PRJEB3181 | 13569 | 175 | 5.378571 | 9.41249925 | Microsporidium sp. BPAR15 PAR1 | 698187 | Fungi | Fungi | 318 | 1.32e-82 | NTclustered | gi|272477435|gb|FJ756117.1| | 698187 | g13276 | i0 | 99.429 | 100.302857142857 | 175 | 1 | 100 | 0 | 1 | 175 | 239 | 65 | Microsporidium sp. BPAR15 PAR1 small subunit ribosomal RNA gene, partial sequence | blastn | 17553 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. BPAR15 PAR1 | ||||
| 10258868 | 10258868 | PRJEB3181_S_NODE_3349_length_312_cov_1249.545126_g3056_i0 | PRJEB3181 | 3349 | 312 | 1249.545126 | 3898.58079312 | Vittaforma corneae | 42399 | Fungi | Fungi | 353 | 7.139999999999998e-93 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g3056 | i0 | 91.255 | 21.2788461538462 | 263 | 18 | 84 | 4 | 52 | 312 | 886 | 627 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 6639 | 353 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 11534309 | 11534309 | PRJEB3181_S_NODE_3590_length_304_cov_17424.944238_g3297_i0 | PRJEB3181 | 3590 | 304 | 17424.944238 | 52971.83048352 | Vittaforma corneae | 42399 | Fungi | Fungi | 228 | 4.3899999999999985e-55 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g3297 | i0 | 84.082 | 16.1875 | 245 | 30 | 79 | 7 | 64 | 304 | 369 | 130 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 4921 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 11534311 | 11534311 | PRJEB3181_S_NODE_4050_length_292_cov_126.918288_g3757_i0 | PRJEB3181 | 4050 | 292 | 126.918288 | 370.60140096 | Vittaforma corneae | 42399 | Fungi | Fungi | 235 | 2.5e-57 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g3757 | i0 | 84.553 | 13.3287671232877 | 246 | 28 | 83 | 8 | 51 | 292 | 369 | 130 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 3892 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 12467987 | 12467987 | PRJEB3181_S_NODE_4430_length_283_cov_4.173387_g4137_i0 | PRJEB3181 | 4430 | 283 | 4.173387 | 11.81068521 | Vittaforma | 42398 | Fungi | Fungi | 507 | 4.64e-139 | NTclustered | gi|38489197|gb|AY375043.1| | 255593 | g4137 | i0 | 100 | 95.6325088339223 | 274 | 0 | 97 | 0 | 1 | 274 | 491 | 218 | Vittaforma-like parasite isolate 5830 small subunit ribosomal RNA gene, partial sequence | blastn | 27064 | 507 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma-like parasite isolate 5830 | |||
| 14084325 | 14084325 | PRJEB3181_S_NODE_1192_length_439_cov_3.680693_g911_i0 | PRJEB3181 | 1192 | 439 | 3.680693 | 16.15824227 | Vittaforma corneae | 42399 | Fungi | Fungi | 473 | 7.64e-129 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g911 | i0 | 86.261 | 4.12756264236902 | 444 | 51 | 100 | 9 | 1 | 439 | 1406 | 968 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 1812 | 473 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 17907505 | 17907505 | PRJEB3181_P_NODE_10495_length_262_cov_2.658009_g10231_i0 | PRJEB3181 | 10495 | 262 | 2.658009 | 6.96398358 | Vittaforma corneae | 42399 | Fungi | Fungi | 189 | 1.7499999999999996e-43 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g10231 | i0 | 87.425 | 1 | 167 | 17 | 63 | 4 | 93 | 258 | 267 | 104 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 262 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 21732881 | 21732881 | PRJEB3181_S_NODE_5678_length_256_cov_19.895928_g5385_i0 | PRJEB3181 | 5678 | 256 | 19.895928 | 50.93357568 | Microsporidium sp. LVPEI.SMW V3S1-FR | 1734473 | Fungi | Fungi | 398 | 2.5899999999999997e-106 | NTclustered | gi|937656209|gb|KR303710.1| | 1734473 | g5385 | i0 | 96.653 | 94.02734375 | 239 | 8 | 93 | 0 | 1 | 239 | 726 | 964 | Microsporidium sp. LVPEI.SMW V3S1-FR small subunit ribosomal RNA gene, partial sequence | blastn | 24071 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. LVPEI.SMW V3S1-FR | ||||
| 24281994 | 24281994 | PRJEB3181_S_NODE_9640_length_204_cov_28.692308_g9347_i0 | PRJEB3181 | 9640 | 204 | 28.692308 | 58.53230832 | Vittaforma corneae | 42399 | Fungi | Fungi | 239 | 1.27e-58 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g9347 | i0 | 88.06 | 1.45098039215686 | 201 | 24 | 99 | 0 | 1 | 201 | 203 | 3 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 296 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae |
Advanced export
JSON shape: default, array, newline-delimited
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);;