contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1120586" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1550369 | 1550369 | PRJNA1120586_P_NODE_18202_length_309_cov_1.579167_g18011_i0 | PRJNA1120586 | 18202 | 309 | 1.579167 | 4.87962603 | Nosema bombycis | 27978 | Fungi | Fungi | 521 | 1.8299999999999998e-143 | NTclustered | gi|326578128|gb|HQ291455.1| | 27978 | g18011 | i0 | 97.087 | 2 | 309 | 9 | 100 | 0 | 1 | 309 | 325 | 17 | Nosema bombycis clone NBO_28g0076 60S ribosomal protein L8 mRNA, complete cds | blastn | 618 | 521 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 1550413 | 1550413 | PRJNA1120586_P_NODE_21082_length_294_cov_1.182222_g20891_i0 | PRJNA1120586 | 21082 | 294 | 1.182222 | 3.47573268 | Nosema bombycis | 27978 | Fungi | Fungi | 483 | 8.159999999999997e-132 | NTclustered | gi|326578136|gb|HQ291459.1| | 27978 | g20891 | i0 | 96.259 | 1 | 294 | 11 | 100 | 0 | 1 | 294 | 328 | 35 | Nosema bombycis clone NBO_4g0015 60S ribosomal protein L15 mRNA, complete cds | blastn | 294 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 1550682 | 1550682 | PRJNA1120586_P_NODE_37422_length_240_cov_2.081871_g37231_i0 | PRJNA1120586 | 37422 | 240 | 2.081871 | 4.9964904 | Nosema bombycis | 27978 | Fungi | Fungi | 272 | 1.52e-68 | NTclustered | gi|157382911|gb|EF683103.1| | 27978 | g37231 | i0 | 87.607 | 0.975 | 234 | 29 | 98 | 0 | 7 | 240 | 415 | 648 | Nosema bombycis spore wall protein (HSWP3) gene, complete cds | blastn | 234 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 3578991 | 3578991 | PRJNA1120586_P_NODE_30283_length_260_cov_1.198953_g30092_i0 | PRJNA1120586 | 30283 | 260 | 1.198953 | 3.1172778 | Nosema | 27977 | Fungi | Fungi | 453 | 5.5600000000000005e-123 | NTclustered | gi|33414123|gb|AY259631.1| | 27978 | g30092 | i0 | 98.819 | 89.6384615384615 | 254 | 3 | 98 | 0 | 1 | 254 | 1086 | 1339 | 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 | 23306 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 7929090 | 7929090 | PRJNA1120586_P_NODE_40447_length_235_cov_0.867470_g40256_i0 | PRJNA1120586 | 40447 | 235 | 0.86747 | 2.0385545 | Nosema bombycis | 27978 | Fungi | Fungi | 278 | 3.19e-70 | NTclustered | gi|2496127037|gb|ON211441.1| | 27978 | g40256 | i0 | 88.085 | 2 | 235 | 27 | 99 | 1 | 2 | 235 | 291 | 57 | Nosema bombycis strain CQ1 ricin B lectin-like protein (RBL24) mRNA, complete cds | blastn | 470 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 9204209 | 9204209 | PRJNA1120586_P_NODE_43728_length_232_cov_0.883436_g43537_i0 | PRJNA1120586 | 43728 | 232 | 0.883436 | 2.04957152 | Nosema bombycis | 27978 | Fungi | Fungi | 396 | 8.319999999999995e-106 | NTclustered | gi|237861295|gb|FJ416150.1| | 27978 | g43537 | i0 | 97.414 | 1 | 232 | 6 | 100 | 0 | 1 | 232 | 536 | 305 | Nosema bombycis 40S ribosomal protein S3 gene, complete cds | blastn | 232 | 396 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 11754264 | 11754264 | PRJNA1120586_P_NODE_13530_length_342_cov_1.106227_g13339_i0 | PRJNA1120586 | 13530 | 342 | 1.106227 | 3.78329634 | Nosema bombycis | 27978 | Fungi | Fungi | 305 | 2.25e-78 | NTclustered | gi|1189432511|gb|KY636450.1| | 27978 | g13339 | i0 | 82.825 | 2.07017543859649 | 361 | 42 | 100 | 9 | 1 | 342 | 162 | 521 | Nosema bombycis polar tube protein 1 mRNA, complete cds | blastn | 708 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 14304609 | 14304609 | PRJNA1120586_P_NODE_14192_length_336_cov_1.917603_g14001_i0 | PRJNA1120586 | 14192 | 336 | 1.917603 | 6.44314608 | Microsporidium sp. TB-2M-H1 | 227447 | Fungi | Fungi | 555 | 1.9799999999999998e-153 | NTclustered | gi|29691977|dbj|AB107592.1| | 227447 | g14001 | i0 | 96.429 | 20.7261904761905 | 336 | 12 | 100 | 0 | 1 | 336 | 619 | 284 | Microsporidium sp. TB-2M-H1 gene for putative spore surface protein, partial cds | blastn | 6964 | 555 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. TB-2M-H1 | ||||
| 14304743 | 14304743 | PRJNA1120586_P_NODE_23312_length_284_cov_1.316279_g23121_i0 | PRJNA1120586 | 23312 | 284 | 1.316279 | 3.73823236 | Nosema bombycis | 27978 | Fungi | Fungi | 492 | 1.2999999999999999e-134 | NTclustered | gi|212292368|gb|EU848486.1| | 27978 | g23121 | i0 | 97.887 | 2 | 284 | 6 | 100 | 0 | 1 | 284 | 99 | 382 | Nosema bombycis histone H3_1 gene, complete cds | blastn | 568 | 492 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 14304935 | 14304935 | PRJNA1120586_P_NODE_34352_length_248_cov_1.608939_g34161_i0 | PRJNA1120586 | 34352 | 248 | 1.608939 | 3.99016872 | Nosema bombycis | 27978 | Fungi | Fungi | 375 | 1.1699999999999999e-99 | NTclustered | gi|326559183|gb|HQ291378.1| | 27978 | g34161 | i0 | 96.875 | 1.80645161290323 | 224 | 7 | 90 | 0 | 25 | 248 | 363 | 140 | Nosema bombycis clone NBO_18g0032 40S ribosomal protein S17 mRNA, complete cds | blastn | 448 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 15056176 | 15056176 | PRJNA1120586_P_NODE_54992_length_206_cov_4.043796_g54801_i0 | PRJNA1120586 | 54992 | 206 | 4.043796 | 8.33021976 | Nosematidae | 27974 | Fungi | Fungi | 375 | 9.41e-100 | NTclustered | gi|1845193528|gb|MT510144.1| | 27978 | g54801 | i0 | 99.515 | 100 | 206 | 1 | 100 | 0 | 1 | 206 | 799 | 594 | Nosema bombycis strain GNL6 small subunit ribosomal RNA gene, partial sequence | blastn | 20600 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 16853557 | 16853557 | PRJNA1120586_P_NODE_47654_length_229_cov_1.350000_g47463_i0 | PRJNA1120586 | 47654 | 229 | 1.35 | 3.0915 | Nosema bombycis | 27978 | Fungi | Fungi | 374 | 3.8399999999999996e-99 | NTclustered | gi|326559141|gb|HQ291357.1| | 27978 | g47463 | i0 | 96.07 | 3 | 229 | 9 | 100 | 0 | 1 | 229 | 292 | 64 | Nosema bombycis clone NBO_10g0072 40S ribosomal protein S8-B mRNA, complete cds | blastn | 687 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 18127890 | 18127890 | PRJNA1120586_P_NODE_39635_length_235_cov_1.493976_g39444_i0 | PRJNA1120586 | 39635 | 235 | 1.493976 | 3.5108436 | Nosema mylitta | 885908 | Fungi | Fungi | 379 | 8.509999999999998e-101 | NTclustered | gi|2562262790|gb|OP313697.1| | 885908 | g39444 | i0 | 95.745 | 2.74468085106383 | 235 | 10 | 100 | 0 | 1 | 235 | 36 | 270 | Nosema mylitta clone NmPolyAS1 putative polyadenylate-binding protein mRNA, partial cds | blastn | 645 | 379 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema mylitta | |||
| 21952510 | 21952510 | PRJNA1120586_P_NODE_11178_length_367_cov_1.798658_g10987_i0 | PRJNA1120586 | 11178 | 367 | 1.798658 | 6.60107486 | Nosema bombycis | 27978 | Fungi | Fungi | 368 | 3.05e-97 | NTclustered | gi|157382909|gb|EF683102.1| | 27978 | g10987 | i0 | 85.014 | 1 | 367 | 49 | 99 | 6 | 4 | 367 | 559 | 196 | Nosema bombycis hypothetical spore wall protein (HSWP2) gene, complete cds | blastn | 367 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 24501940 | 24501940 | PRJNA1120586_P_NODE_30120_length_260_cov_1.931937_g29929_i0 | PRJNA1120586 | 30120 | 260 | 1.931937 | 5.0230362 | Nosema bombycis | 27978 | Fungi | Fungi | 292 | 1.28e-74 | NTclustered | gi|1189432511|gb|KY636450.1| | 27978 | g29929 | i0 | 88 | 2.91923076923077 | 250 | 27 | 95 | 1 | 14 | 260 | 918 | 669 | Nosema bombycis polar tube protein 1 mRNA, complete cds | blastn | 759 | 292 | 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);;