contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA352610" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 393919 | 393919 | PRJNA352610_P_NODE_26121_length_250_cov_0.870056_g26060_i0 | PRJNA352610 | 26121 | 250 | 0.870056 | 2.17514 | Encephalitozoon hellem | 27973 | Fungi | Fungi | 150 | 7.799999999999999e-32 | NTclustered | gi|401828121|ref|XM_003888304.1| | 907965 | g26060 | i0 | 87.597 | 5.996 | 129 | 16 | 52 | 0 | 122 | 250 | 1672 | 1800 | Encephalitozoon hellem ATCC 50504 isoleucyl-tRNA synthetase (EHEL_110980), partial mRNA | blastn | 1499 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon hellem | |||
| 8723053 | 8723053 | PRJNA352610_P_NODE_18867_length_288_cov_1.069767_g18806_i0 | PRJNA352610 | 18867 | 288 | 1.069767 | 3.08092896 | Encephalitozoon | 6033 | Fungi | Fungi | 148 | 3.3e-31 | NTclustered | gi|3426080|emb|AJ005581.1| | 6035 | g18806 | i0 | 84.177 | 4.81944444444444 | 158 | 20 | 54 | 5 | 3 | 157 | 5382 | 5537 | Encephalitozoon cuniculi complete rDNA unit (16S, 5.8S, 23S, ITS1 and IGS) | blastn | 1388 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon cuniculi | |||
| 9321944 | 9321944 | PRJNA352610_P_NODE_28328_length_246_cov_1.335260_g28267_i0 | PRJNA352610 | 28328 | 246 | 1.33526 | 3.2847396 | Encephalitozoon romaleae | 571949 | Fungi | Fungi | 183 | 7.549999999999997e-42 | NTclustered | gi|685882362|ref|XM_009267338.1| | 1178016 | g28267 | i0 | 80.242 | 1.00813008130081 | 248 | 45 | 100 | 2 | 1 | 246 | 1112 | 867 | Encephalitozoon romaleae SJ-2008 translation elongation factor 2 partial mRNA | blastn | 248 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon romaleae | |||
| 10597829 | 10597829 | PRJNA352610_P_NODE_7369_length_414_cov_3.237537_g7308_i0 | PRJNA352610 | 7369 | 414 | 3.237537 | 13.40340318 | Microsporidium sp. Loire | 1032359 | Fungi | Fungi | 547 | 4.159999999999998e-151 | NTclustered | gi|333036714|gb|HM566198.1| | 1032359 | g7308 | i0 | 90.431 | 98.536231884058 | 418 | 36 | 100 | 1 | 1 | 414 | 365 | 782 | Microsporidium sp. Loire small subunit ribosomal RNA gene, partial sequence | blastn | 40794 | 547 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. Loire | ||||
| 11872409 | 11872409 | PRJNA352610_P_NODE_21890_length_269_cov_1.178571_g21829_i0 | PRJNA352610 | 21890 | 269 | 1.178571 | 3.17035599 | Encephalitozoon intestinalis | 58839 | Fungi | Fungi | 230 | 1.0599999999999998e-55 | NTclustered | gi|303388206|ref|XM_003072292.1| | 876142 | g21829 | i0 | 82.812 | 3.76208178438662 | 256 | 44 | 95 | 0 | 1 | 256 | 1719 | 1464 | Encephalitozoon intestinalis ATCC 50506 Cdc48-like AAA ATPase (Eint_011160), partial mRNA | blastn | 1012 | 230 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis | |||
| 14422870 | 14422870 | PRJNA352610_P_NODE_6932_length_424_cov_2.094017_g6871_i0 | PRJNA352610 | 6932 | 424 | 2.094017 | 8.87863208 | Microsporidium sp. BTUB6 | 698259 | Fungi | Fungi | 575 | 1.9599999999999994e-159 | NTclustered | gi|272477484|gb|FJ756166.1| | 698259 | g6871 | i0 | 92.252 | 89.4622641509434 | 413 | 20 | 95 | 7 | 22 | 424 | 1 | 411 | Microsporidium sp. BTUB6 small subunit ribosomal RNA gene, partial sequence | blastn | 37932 | 575 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. BTUB6 | ||||
| 15696279 | 15696279 | PRJNA352610_P_NODE_14353_length_321_cov_1.891129_g14292_i0 | PRJNA352610 | 14353 | 321 | 1.891129 | 6.07052409 | Episeptum pseudoinversum | 1966657 | Fungi | Fungi | 86.1 | 2.97e-12 | NTclustered | gi|115501678|gb|DQ864442.1| | 1966657 | g14292 | i0 | 84.27 | 3.27414330218069 | 89 | 12 | 28 | 2 | 72 | 160 | 262 | 176 | Episeptum pseudoinversum isolate 15a large subunit ribosomal RNA gene, partial sequence | blastn | 1051 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Gurleyidae | Episeptum | Episeptum pseudoinversum | |||
| 16971015 | 16971015 | PRJNA352610_P_NODE_1494_length_752_cov_1.515464_g1442_i0 | PRJNA352610 | 1494 | 752 | 1.515464 | 11.39628928 | Vittaforma corneae | 42399 | Fungi | Fungi | 111 | 1.23e-19 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g1442 | i0 | 89.011 | 10.4521276595745 | 91 | 8 | 12 | 2 | 458 | 547 | 1011 | 922 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 7860 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 18245717 | 18245717 | PRJNA352610_P_NODE_6575_length_432_cov_1.417827_g6514_i0 | PRJNA352610 | 6575 | 432 | 1.417827 | 6.12501264 | Encephalitozoon cuniculi | 6035 | Fungi | Fungi | 202 | 3.9099999999999997e-47 | NTclustered | gi|107770704|ref|NM_001040824.1| | 284813 | g6514 | i0 | 75.615 | 2.83796296296296 | 447 | 88 | 99 | 14 | 1 | 429 | 946 | 503 | Encephalitozoon cuniculi GB-M1 uncharacterized protein (ECU02_1100), partial mRNA | blastn | 1226 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon cuniculi | |||
| 20795546 | 20795546 | PRJNA352610_P_NODE_8717_length_388_cov_1.450794_g8656_i0 | PRJNA352610 | 8717 | 388 | 1.450794 | 5.62908072 | Sporanauta perivermis | 1261140 | Fungi | Fungi | 259 | 2.03e-64 | NTclustered | gi|1612564105|gb|MK190414.1| | 1261140 | g8656 | i0 | 83.824 | 0.701030927835051 | 272 | 44 | 70 | 0 | 102 | 373 | 189 | 460 | Sporanauta perivermis polyA-binding protein gene, complete cds | blastn | 272 | 259 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Sporanauta | Sporanauta perivermis | ||||
| 22070574 | 22070574 | PRJNA352610_P_NODE_6718_length_429_cov_1.210674_g6657_i0 | PRJNA352610 | 6718 | 429 | 1.210674 | 5.19379146 | Microsporidium sp. BIOB | 308919 | Fungi | Fungi | 416 | 1.27e-111 | NTclustered | gi|74831882|emb|AJ871391.1| | 308919 | g6657 | i0 | 84.491 | 61.8694638694639 | 432 | 55 | 100 | 10 | 1 | 429 | 879 | 1301 | Microsporidium sp. BIOB partial 16S rRNA gene and ITS1, clone BIOB | blastn | 26542 | 416 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. BIOB | ||||
| 25296710 | 25296710 | PRJNA352610_P_NODE_12520_length_339_cov_0.823308_g12459_i0 | PRJNA352610 | 12520 | 339 | 0.823308 | 2.79101412 | Encephalitozoon | 6033 | Fungi | Fungi | 187 | 8.409999999999998e-43 | NTclustered | gi|449329641|gb|KC513611.1| | 6035 | g12459 | i0 | 76.968 | 2.70796460176991 | 343 | 69 | 99 | 10 | 1 | 338 | 50604 | 50941 | Encephalitozoon cuniculi clone supercont1.9 genomic sequence | blastn | 918 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon cuniculi |
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);;