contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA942359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 923158 | 923158 | PRJNA942359_P_NODE_9401_length_287_cov_1.093458_g9286_i0 | PRJNA942359 | 9401 | 287 | 1.093458 | 3.13822446 | Nosema bombycis | 27978 | Fungi | Fungi | 470 | 6.18e-128 | NTclustered | gi|157382911|gb|EF683103.1| | 27978 | g9286 | i0 | 96.167 | 1 | 287 | 11 | 100 | 0 | 1 | 287 | 327 | 41 | Nosema bombycis spore wall protein (HSWP3) gene, complete cds | blastn | 287 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 2198272 | 2198272 | PRJNA942359_P_NODE_1642_length_605_cov_2.492481_g1532_i0 | PRJNA942359 | 1642 | 605 | 2.492481 | 15.07951005 | Microsporidium sp. Loire | 1032359 | Fungi | Fungi | 822 | 0 | NTclustered | gi|333036714|gb|HM566198.1| | 1032359 | g1532 | i0 | 91.162 | 94.7702479338843 | 611 | 47 | 100 | 4 | 1 | 605 | 198 | 807 | Microsporidium sp. Loire small subunit ribosomal RNA gene, partial sequence | blastn | 57336 | 822 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. Loire | ||||
| 2198444 | 2198444 | PRJNA942359_P_NODE_6262_length_337_cov_1.140152_g6147_i0 | PRJNA942359 | 6262 | 337 | 1.140152 | 3.84231224 | Nosema bombycis | 27978 | Fungi | Fungi | 568 | 2.5499999999999993e-157 | NTclustered | gi|157382909|gb|EF683102.1| | 27978 | g6147 | i0 | 97.033 | 1 | 337 | 10 | 100 | 0 | 1 | 337 | 655 | 319 | Nosema bombycis hypothetical spore wall protein (HSWP2) gene, complete cds | blastn | 337 | 568 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 4751459 | 4751459 | PRJNA942359_P_NODE_3984_length_405_cov_1.409639_g3869_i0 | PRJNA942359 | 3984 | 405 | 1.409639 | 5.70903795 | Glugea eda | 2529233 | Fungi | Fungi | 117 | 1.36e-21 | NTclustered | gi|1581445003|gb|MK568064.1| | 2529233 | g3869 | i0 | 87.619 | 4.68148148148148 | 105 | 8 | 25 | 5 | 261 | 362 | 1547 | 1445 | Glugea eda voucher Yanbu-Saudi-LM-2017 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 1896 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugea | Glugea eda | |||
| 7301217 | 7301217 | PRJNA942359_P_NODE_7106_length_320_cov_1.570850_g6991_i0 | PRJNA942359 | 7106 | 320 | 1.57085 | 5.02672 | Nosema bombycis | 27978 | Fungi | Fungi | 592 | 1.4299999999999996e-164 | NTclustered | gi|340764464|gb|HQ881497.1| | 27978 | g6991 | i0 | 100 | 3 | 320 | 0 | 100 | 0 | 1 | 320 | 44 | 363 | Nosema bombycis strain CQ1 spore wall protein 5 mRNA, complete cds | blastn | 960 | 592 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 8576003 | 8576003 | PRJNA942359_P_NODE_4647_length_380_cov_2.420195_g4532_i0 | PRJNA942359 | 4647 | 380 | 2.420195 | 9.196741 | Nosema bombycis | 27978 | Fungi | Fungi | 652 | 0 | NTclustered | gi|326578132|gb|HQ291457.1| | 27978 | g4532 | i0 | 97.889 | 0.997368421052632 | 379 | 5 | 99 | 2 | 2 | 380 | 657 | 282 | Nosema bombycis clone NBO_3g0006 60S ribosomal protein L6 mRNA, partial cds | blastn | 379 | 652 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 9850952 | 9850952 | PRJNA942359_P_NODE_16668_length_247_cov_0.965517_g16553_i0 | PRJNA942359 | 16668 | 247 | 0.965517 | 2.38482699 | Nosema bombycis | 27978 | Fungi | Fungi | 435 | 1.9e-117 | NTclustered | gi|157382913|gb|EF683104.1| | 27978 | g16553 | i0 | 98.381 | 1 | 247 | 4 | 100 | 0 | 1 | 247 | 874 | 1120 | Nosema bombycis hypothetical spore wall protein (HSWP4) gene, complete cds | blastn | 247 | 435 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 11126737 | 11126737 | PRJNA942359_P_NODE_6569_length_331_cov_0.906977_g6454_i0 | PRJNA942359 | 6569 | 331 | 0.906977 | 3.00209387 | Nosema bombycis | 27978 | Fungi | Fungi | 601 | 2.4699999999999994e-167 | NTclustered | gi|340764466|gb|HQ881498.1| | 27978 | g6454 | i0 | 99.396 | 18 | 331 | 2 | 100 | 0 | 1 | 331 | 664 | 334 | Nosema bombycis strain CQ1 polar tube protein 2 mRNA, complete cds | blastn | 5958 | 601 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 11126743 | 11126743 | PRJNA942359_P_NODE_6889_length_324_cov_1.721116_g6774_i0 | PRJNA942359 | 6889 | 324 | 1.721116 | 5.57641584 | Nosema bombycis | 27978 | Fungi | Fungi | 577 | 4.0599999999999986e-160 | NTclustered | gi|212292364|gb|EU848484.1| | 27978 | g6774 | i0 | 98.765 | 2.78086419753086 | 324 | 4 | 100 | 0 | 1 | 324 | 388 | 65 | Nosema bombycis histone H2B gene, complete cds | blastn | 901 | 577 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 12402223 | 12402223 | PRJNA942359_P_NODE_5070_length_367_cov_1.527211_g4955_i0 | PRJNA942359 | 5070 | 367 | 1.527211 | 5.60486437 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 678 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g4955 | i0 | 100 | 98.5613079019074 | 367 | 0 | 100 | 0 | 1 | 367 | 893 | 1259 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 36172 | 678 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 12402274 | 12402274 | PRJNA942359_P_NODE_7450_length_314_cov_1.385892_g7335_i0 | PRJNA942359 | 7450 | 314 | 1.385892 | 4.35170088 | Nosema bombycis | 27978 | Fungi | Fungi | 544 | 3.98e-150 | NTclustered | gi|157382911|gb|EF683103.1| | 27978 | g7335 | i0 | 98.077 | 0.993630573248408 | 312 | 6 | 99 | 0 | 1 | 312 | 328 | 639 | Nosema bombycis spore wall protein (HSWP3) gene, complete cds | blastn | 312 | 544 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 17501081 | 17501081 | PRJNA942359_P_NODE_13454_length_252_cov_1.692737_g13339_i0 | PRJNA942359 | 13454 | 252 | 1.692737 | 4.26569724 | Nosema bombycis | 27978 | Fungi | Fungi | 455 | 1.49e-123 | NTclustered | gi|326561244|gb|HQ291386.1| | 27978 | g13339 | i0 | 99.206 | 122.924603174603 | 252 | 2 | 100 | 0 | 1 | 252 | 266 | 15 | Nosema bombycis clone NBO_367g0007 40S ribosomal protein S31 mRNA, partial cds | blastn | 30977 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 17836287 | 17836287 | PRJNA942359_P_NODE_7114_length_320_cov_1.279352_g6999_i0 | PRJNA942359 | 7114 | 320 | 1.279352 | 4.0939264 | Nosema | 27977 | Fungi | Fungi | 592 | 1.4299999999999996e-164 | NTclustered | gi|33414123|gb|AY259631.1| | 27978 | g6999 | i0 | 100 | 85.015625 | 320 | 0 | 100 | 0 | 1 | 320 | 1370 | 1689 | Nosema bombycis large subunit ribosomal RNA gene, internal transcribed spacer, small subunit ribosomal RNA gene, intergenic spacer region, and 5S ribosomal RNA gene, complete sequence | blastn | 27205 | 592 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 20385128 | 20385128 | PRJNA942359_P_NODE_5196_length_363_cov_1.224138_g5081_i0 | PRJNA942359 | 5196 | 363 | 1.224138 | 4.44362094 | Nosema | 27977 | Fungi | Fungi | 665 | 0 | NTclustered | gi|33414123|gb|AY259631.1| | 27978 | g5081 | i0 | 99.725 | 95.9504132231405 | 363 | 1 | 100 | 0 | 1 | 363 | 713 | 1075 | Nosema bombycis large subunit ribosomal RNA gene, internal transcribed spacer, small subunit ribosomal RNA gene, intergenic spacer region, and 5S ribosomal RNA gene, complete sequence | blastn | 34830 | 665 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 22936534 | 22936534 | PRJNA942359_P_NODE_10298_length_278_cov_1.131707_g10183_i0 | PRJNA942359 | 10298 | 278 | 1.131707 | 3.14614546 | Nosematidae | 27974 | Fungi | Fungi | 514 | 2.7199999999999996e-141 | NTclustered | gi|1845193512|gb|MT510128.1| | 27978 | g10183 | i0 | 100 | 100 | 278 | 0 | 100 | 0 | 1 | 278 | 501 | 778 | Nosema bombycis strain GNB3 small subunit ribosomal RNA gene, partial sequence | blastn | 27800 | 514 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 25485370 | 25485370 | PRJNA942359_P_NODE_12340_length_258_cov_1.264865_g12225_i0 | PRJNA942359 | 12340 | 258 | 1.264865 | 3.2633517 | Endoreticulatus | 42400 | Fungi | Fungi | 466 | 7.08e-127 | NTclustered | gi|63095238|gb|AY960111.1| | 262393 | g12225 | i0 | 99.225 | 4 | 258 | 2 | 100 | 0 | 1 | 258 | 608 | 865 | Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence | blastn | 1032 | 466 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. CHW-2004 Taiwan | ||||
| 25485408 | 25485408 | PRJNA942359_P_NODE_20660_length_228_cov_2.490323_g20545_i0 | PRJNA942359 | 20660 | 228 | 2.490323 | 5.67793644 | Nosematidae | 27974 | Fungi | Fungi | 422 | 1.34e-113 | NTclustered | gi|170282854|gb|EU350380.1| | 27978 | g20545 | i0 | 100 | 100 | 228 | 0 | 100 | 0 | 1 | 228 | 420 | 193 | Nosema bombycis clone 9 small subunit ribosomal RNA, partial sequence; small subunit ribosomal RNA-5S ribosomal RNA intergenic spacer, complete sequence; and 5S ribosomal RNA, partial sequence | blastn | 22800 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis |
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);;