contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 608303 | 608303 | PRJNA635874_P_NODE_7321_length_528_cov_1.516484_g7175_i0 | PRJNA635874 | 7321 | 528 | 1.516484 | 8.00703552 | Nosema bombycis | 27978 | Fungi | Fungi | 976 | 0 | NTclustered | gi|91178026|gb|DQ445482.1| | 27978 | g7175 | i0 | 100 | 1.6344696969697 | 528 | 0 | 100 | 0 | 1 | 528 | 12755 | 12228 | Nosema bombycis contig 2, partial genomic sequence | blastn | 863 | 976 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 1883772 | 1883772 | PRJNA635874_P_NODE_40922_length_266_cov_1.544041_g40775_i0 | PRJNA635874 | 40922 | 266 | 1.544041 | 4.10714906 | Nosema bombycis | 27978 | Fungi | Fungi | 492 | 1.2099999999999999e-134 | NTclustered | gi|91176518|gb|DQ444466.1| | 27978 | g40775 | i0 | 100 | 1 | 266 | 0 | 100 | 0 | 1 | 266 | 1839 | 1574 | Nosema bombycis retrotransposon Nbr2 complete sequence | blastn | 266 | 492 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 1883857 | 1883857 | PRJNA635874_P_NODE_43842_length_257_cov_2.402174_g43695_i0 | PRJNA635874 | 43842 | 257 | 2.402174 | 6.17358718 | Nosema bombycis | 27978 | Fungi | Fungi | 470 | 5.45e-128 | NTclustered | gi|298569373|gb|GQ851624.1| | 27978 | g43695 | i0 | 99.611 | 1 | 257 | 1 | 100 | 0 | 1 | 257 | 683 | 427 | Nosema bombycis retrotransposon Nbr13, complete sequence | blastn | 257 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 1883914 | 1883914 | PRJNA635874_P_NODE_45922_length_251_cov_1.730337_g45775_i0 | PRJNA635874 | 45922 | 251 | 1.730337 | 4.34314587 | Nosema pernyi | 1112939 | Fungi | Fungi | 387 | 5.489999999999998e-103 | NTclustered | gi|734687701|gb|KJ210761.1| | 1112939 | g45775 | i0 | 94.444 | 1.11553784860558 | 252 | 12 | 100 | 2 | 1 | 251 | 496 | 246 | Nosema pernyi clone 85 thioredoxin reductase mRNA, complete cds | blastn | 280 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema pernyi | |||
| 3157595 | 3157595 | PRJNA635874_P_NODE_11603_length_437_cov_1.593407_g11456_i0 | PRJNA635874 | 11603 | 437 | 1.593407 | 6.96318859 | Nosema bombycis | 27978 | Fungi | Fungi | 802 | 0 | NTclustered | gi|298569373|gb|GQ851624.1| | 27978 | g11456 | i0 | 99.771 | 1.1304347826087 | 437 | 1 | 100 | 0 | 1 | 437 | 2932 | 2496 | Nosema bombycis retrotransposon Nbr13, complete sequence | blastn | 494 | 802 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 3159080 | 3159080 | PRJNA635874_P_NODE_67503_length_243_cov_0.905882_g67356_i0 | PRJNA635874 | 67503 | 243 | 0.905882 | 2.20129326 | Nosema bombycis | 27978 | Fungi | Fungi | 422 | 1.45e-113 | NTclustered | gi|253559534|gb|FJ517650.1| | 27978 | g67356 | i0 | 97.942 | 1 | 243 | 5 | 100 | 0 | 1 | 243 | 1474 | 1232 | Nosema bombycis telomere genomic sequence | blastn | 243 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 3159162 | 3159162 | PRJNA635874_P_NODE_70423_length_242_cov_0.911243_g70276_i0 | PRJNA635874 | 70423 | 242 | 0.911243 | 2.20520806 | Nosema bombycis | 27978 | Fungi | Fungi | 448 | 2.3799999999999995e-121 | NTclustered | gi|91176526|gb|DQ444470.1| | 27978 | g70276 | i0 | 100 | 1 | 242 | 0 | 100 | 0 | 1 | 242 | 1920 | 1679 | Nosema bombycis retrotransposon Nbr6 complete sequence | blastn | 242 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 4435755 | 4435755 | PRJNA635874_P_NODE_62404_length_245_cov_0.895349_g62257_i0 | PRJNA635874 | 62404 | 245 | 0.895349 | 2.19360505 | Nosema bombycis | 27978 | Fungi | Fungi | 392 | 1.15e-104 | NTclustered | gi|2844552582|gb|OR734990.1| | 578461 | g62257 | i0 | 95.51 | 1 | 245 | 11 | 100 | 0 | 1 | 245 | 305 | 61 | Nosema bombycis CQ1 ATP-binding cassette sub-family G member 1.3 (ABCG1.3) mRNA, partial cds | blastn | 245 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 5710835 | 5710835 | PRJNA635874_P_NODE_27845_length_312_cov_0.920502_g27698_i0 | PRJNA635874 | 27845 | 312 | 0.920502 | 2.87196624 | Nosema bombycis | 27978 | Fungi | Fungi | 82.4 | 3.72e-11 | NTclustered | gi|298569370|gb|GQ851621.1| | 27978 | g27698 | i0 | 97.917 | 0.153846153846154 | 48 | 0 | 15 | 1 | 266 | 312 | 996 | 949 | Nosema bombycis retrotransposon Nbr10, complete sequence | blastn | 48 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 5711121 | 5711121 | PRJNA635874_P_NODE_37325_length_277_cov_1.387255_g37178_i0 | PRJNA635874 | 37325 | 277 | 1.387255 | 3.84269635 | Nosema bombycis | 27978 | Fungi | Fungi | 134 | 8.850000000000001e-27 | NTclustered | gi|91178026|gb|DQ445482.1| | 27978 | g37178 | i0 | 82.353 | 0.71841155234657 | 170 | 15 | 61 | 7 | 110 | 277 | 2711 | 2555 | Nosema bombycis contig 2, partial genomic sequence | blastn | 199 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 5711604 | 5711604 | PRJNA635874_P_NODE_57065_length_247_cov_0.885057_g56918_i0 | PRJNA635874 | 57065 | 247 | 0.885057 | 2.18609079 | Nosema bombycis | 27978 | Fungi | Fungi | 446 | 8.759999999999998e-121 | NTclustered | gi|298569373|gb|GQ851624.1| | 27978 | g56918 | i0 | 99.19 | 1 | 247 | 2 | 100 | 0 | 1 | 247 | 2274 | 2028 | Nosema bombycis retrotransposon Nbr13, complete sequence | blastn | 247 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 6258072 | 6258072 | PRJNA635874_P_NODE_33805_length_288_cov_1.432558_g33658_i0 | PRJNA635874 | 33805 | 288 | 1.432558 | 4.12576704 | Nosema | 27977 | Fungi | Fungi | 532 | 7.8e-147 | NTclustered | gi|33414123|gb|AY259631.1| | 27978 | g33658 | i0 | 100 | 84.2743055555556 | 288 | 0 | 100 | 0 | 1 | 288 | 1378 | 1665 | 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 | 24271 | 532 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 6985224 | 6985224 | PRJNA635874_P_NODE_12106_length_429_cov_1.671348_g11959_i0 | PRJNA635874 | 12106 | 429 | 1.671348 | 7.17008292 | Nosema bombycis | 27978 | Fungi | Fungi | 327 | 6.140000000000001e-85 | NTclustered | gi|253559534|gb|FJ517650.1| | 27978 | g11959 | i0 | 93.304 | 0.522144522144522 | 224 | 11 | 52 | 3 | 208 | 429 | 1733 | 1512 | Nosema bombycis telomere genomic sequence | blastn | 224 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 8259915 | 8259915 | PRJNA635874_P_NODE_11587_length_437_cov_1.826923_g11440_i0 | PRJNA635874 | 11587 | 437 | 1.826923 | 7.98365351 | Nosema bombycis | 27978 | Fungi | Fungi | 331 | 4.84e-86 | NTclustered | gi|91176524|gb|DQ444469.1| | 27978 | g11440 | i0 | 87.762 | 0.654462242562929 | 286 | 32 | 65 | 3 | 1 | 285 | 284 | 1 | Nosema bombycis retrotransposon Nbr5 complete sequence | blastn | 286 | 331 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 9535900 | 9535900 | PRJNA635874_P_NODE_35288_length_284_cov_0.767773_g35141_i0 | PRJNA635874 | 35288 | 284 | 0.767773 | 2.18047532 | Nosema bombycis | 27978 | Fungi | Fungi | 202 | 2.459999999999999e-47 | NTclustered | gi|291294401|gb|GQ411186.1| | 27978 | g35141 | i0 | 100 | 0.767605633802817 | 109 | 0 | 38 | 0 | 176 | 284 | 323 | 215 | Nosema bombycis clone 22 transposon Tc1-like, partial sequence | blastn | 218 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 13361069 | 13361069 | PRJNA635874_P_NODE_19811_length_354_cov_1.092527_g19664_i0 | PRJNA635874 | 19811 | 354 | 1.092527 | 3.86754558 | Nosema bombycis | 27978 | Fungi | Fungi | 627 | 4.369999999999999e-175 | NTclustered | gi|298569373|gb|GQ851624.1| | 27978 | g19664 | i0 | 98.588 | 1 | 354 | 5 | 100 | 0 | 1 | 354 | 3240 | 2887 | Nosema bombycis retrotransposon Nbr13, complete sequence | blastn | 354 | 627 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 14636033 | 14636033 | PRJNA635874_P_NODE_26192_length_319_cov_1.056911_g26045_i0 | PRJNA635874 | 26192 | 319 | 1.056911 | 3.37154609 | Nosema bombycis | 27978 | Fungi | Fungi | 87.9 | 8.2e-13 | NTclustered | gi|91178026|gb|DQ445482.1| | 27978 | g26045 | i0 | 100 | 1.26645768025078 | 47 | 0 | 15 | 0 | 273 | 319 | 18101 | 18055 | Nosema bombycis contig 2, partial genomic sequence | blastn | 404 | 87.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 15909863 | 15909863 | PRJNA635874_P_NODE_23153_length_334_cov_1.141762_g23006_i0 | PRJNA635874 | 23153 | 334 | 1.141762 | 3.81348508 | Nosema sp. PX1 | 319079 | Fungi | Fungi | 549 | 9.159999999999997e-152 | NTclustered | gi|62125842|gb|AY960986.1| | 319079 | g23006 | i0 | 96.97 | 64.4700598802395 | 330 | 5 | 99 | 2 | 1 | 330 | 2998 | 2674 | Nosema sp. PX1 large subunit ribosomal RNA gene, internal transcribed spacer, small subunit ribosomal RNA and 5S ribosomal RNA genes, complete sequence | blastn | 21533 | 549 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema sp. PX1 | |||
| 17185892 | 17185892 | PRJNA635874_P_NODE_57894_length_247_cov_0.885057_g57747_i0 | PRJNA635874 | 57894 | 247 | 0.885057 | 2.18609079 | Nosema bombycis | 27978 | Fungi | Fungi | 451 | 1.88e-122 | NTclustered | gi|326578108|gb|HQ291445.1| | 27978 | g57747 | i0 | 99.595 | 2 | 247 | 1 | 100 | 0 | 1 | 247 | 91 | 337 | Nosema bombycis clone NBO_1574g0002 60S ribosomal protein P0 mRNA, complete cds | blastn | 494 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 18460406 | 18460406 | PRJNA635874_P_NODE_72795_length_241_cov_0.916667_g72648_i0 | PRJNA635874 | 72795 | 241 | 0.916667 | 2.20916747 | Nosema bombycis | 27978 | Fungi | Fungi | 435 | 1.84e-117 | NTclustered | gi|298569374|gb|GQ851625.1| | 27978 | g72648 | i0 | 99.17 | 1 | 241 | 2 | 100 | 0 | 1 | 241 | 2219 | 1979 | Nosema bombycis retrotransposon Nbr14, complete sequence | blastn | 241 | 435 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 19733896 | 19733896 | PRJNA635874_P_NODE_30336_length_301_cov_1.350877_g30189_i0 | PRJNA635874 | 30336 | 301 | 1.350877 | 4.06613977 | Nosema bombycis | 27978 | Fungi | Fungi | 394 | 4.04e-105 | NTclustered | gi|326559171|gb|HQ291372.1| | 27978 | g30189 | i0 | 98.649 | 0.737541528239203 | 222 | 3 | 74 | 0 | 80 | 301 | 446 | 225 | Nosema bombycis clone NBO_13g0045 40S ribosomal protein S13 mRNA, partial cds | blastn | 222 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 21009371 | 21009371 | PRJNA635874_P_NODE_22337_length_338_cov_1.524528_g22190_i0 | PRJNA635874 | 22337 | 338 | 1.524528 | 5.15290464 | Nosema bombycis | 27978 | Fungi | Fungi | 619 | 6.969999999999999e-173 | NTclustered | gi|298569373|gb|GQ851624.1| | 27978 | g22190 | i0 | 99.704 | 1 | 338 | 1 | 100 | 0 | 1 | 338 | 1729 | 2066 | Nosema bombycis retrotransposon Nbr13, complete sequence | blastn | 338 | 619 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 21009635 | 21009635 | PRJNA635874_P_NODE_31637_length_296_cov_1.376682_g31490_i0 | PRJNA635874 | 31637 | 296 | 1.376682 | 4.07497872 | Nosema bombycis | 27978 | Fungi | Fungi | 348 | 3.13e-91 | NTclustered | gi|91176522|gb|DQ444468.1| | 27978 | g31490 | i0 | 99.476 | 1.29054054054054 | 191 | 1 | 65 | 0 | 106 | 296 | 229 | 39 | Nosema bombycis retrotransposon Nbr4 complete sequence | blastn | 382 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 22284957 | 22284957 | PRJNA635874_P_NODE_54318_length_248_cov_0.880000_g54171_i0 | PRJNA635874 | 54318 | 248 | 0.88 | 2.1824 | Nosema bombycis | 27978 | Fungi | Fungi | 364 | 2.539999999999999e-96 | NTclustered | gi|298569370|gb|GQ851621.1| | 27978 | g54171 | i0 | 93.145 | 1 | 248 | 17 | 100 | 0 | 1 | 248 | 1313 | 1066 | Nosema bombycis retrotransposon Nbr10, complete sequence | blastn | 248 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 23559707 | 23559707 | PRJNA635874_P_NODE_25459_length_322_cov_1.236948_g25312_i0 | PRJNA635874 | 25459 | 322 | 1.236948 | 3.98297256 | Nosema bombycis | 27978 | Fungi | Fungi | 595 | 1.1099999999999995e-165 | NTclustered | gi|298569374|gb|GQ851625.1| | 27978 | g25312 | i0 | 100 | 1 | 322 | 0 | 100 | 0 | 1 | 322 | 2995 | 3316 | Nosema bombycis retrotransposon Nbr14, complete sequence | blastn | 322 | 595 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 23560085 | 23560085 | PRJNA635874_P_NODE_38319_length_274_cov_1.233831_g38172_i0 | PRJNA635874 | 38319 | 274 | 1.233831 | 3.38069694 | Nosema bombycis | 27978 | Fungi | Fungi | 292 | 1.3599999999999999e-74 | NTclustered | gi|282935457|gb|GQ916562.1| | 27978 | g38172 | i0 | 86.232 | 21.4306569343066 | 276 | 30 | 99 | 7 | 2 | 274 | 388 | 118 | Nosema bombycis MITE NbME4, complete sequence | blastn | 5872 | 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);;