contig_metadata
12 rows where bioproject = "PRJDB4470", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9509 | 9509 | PRJDB4470_P_NODE_41681_length_333_cov_7.957746_g40529_i0 | PRJDB4470 | 41681 | 333 | 7.957746 | 26.49929418 | Encephalitozoon romaleae | 571949 | Fungi | Fungi | 82.4 | 4e-11 | NTclustered | gi|210076707|gb|FJ026013.1| | 571949 | g40529 | i0 | 97.872 | 0.141141141141141 | 47 | 1 | 14 | 0 | 254 | 300 | 615 | 569 | Encephalitozoon sp. SJ-2008 16S small subunit ribosomal RNA gene, partial sequence; 16S-23S internal transcribed spacer, complete sequence; and 23S large subunit ribosomal RNA gene, partial sequence | blastn | 47 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon romaleae | |||
| 7661701 | 7661701 | PRJDB4470_P_NODE_30747_length_413_cov_1.285714_g29602_i0 | PRJDB4470 | 30747 | 413 | 1.285714 | 5.30999882 | Microsporidium sp. Loire | 1032359 | Fungi | Fungi | 763 | 0 | NTclustered | gi|333036714|gb|HM566198.1| | 1032359 | g29602 | i0 | 100 | 94.8523002421308 | 413 | 0 | 100 | 0 | 1 | 413 | 333 | 745 | Microsporidium sp. Loire small subunit ribosomal RNA gene, partial sequence | blastn | 39174 | 763 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. Loire | ||||
| 8936842 | 8936842 | PRJDB4470_P_NODE_86488_length_188_cov_1.424460_g85333_i0 | PRJDB4470 | 86488 | 188 | 1.42446 | 2.6779848 | Vittaforma corneae | 42399 | Fungi | Fungi | 108 | 3.39e-19 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g85333 | i0 | 95.522 | 37.936170212766 | 67 | 3 | 36 | 0 | 122 | 188 | 922 | 988 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 7132 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 28327226 | 28327226 | PRJDB4470_P_NODE_118246_length_163_cov_0.912281_g117091_i0 | PRJDB4470 | 118246 | 163 | 0.912281 | 1.48701803 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 107 | 1.73e-25 | NR | KRH92949.1 | 146866 | g117091 | i0 | 100 | 0.975460122699387 | 53 | 0 | 97.5 | 0 | 3 | 161 | 143 | 195 | KRH92949.1 hypothetical protein M153_1976000584 [Pseudoloma neurophilia] | diamond | 159 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29243100 | 29243100 | PRJDB4470_P_NODE_70989_length_218_cov_1.662722_g69834_i0 | PRJDB4470 | 70989 | 218 | 1.662722 | 3.62473396 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 104 | 1.87e-24 | NR | KRH93141.1 | 146866 | g69834 | i0 | 81 | 0.86697247706422 | 63 | 7 | 86.7 | 1 | 218 | 30 | 323 | 380 | KRH93141.1 hypothetical protein M153_14260002472 [Pseudoloma neurophilia] | diamond | 189 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29306071 | 29306071 | PRJDB4470_P_NODE_107189_length_166_cov_0.888889_g106034_i0 | PRJDB4470 | 107189 | 166 | 0.888889 | 1.47555574 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 78.2 | 6.51e-17 | NR | KRH92920.1 | 146866 | g106034 | i0 | 100 | 0.686746987951807 | 38 | 0 | 68.7 | 0 | 114 | 1 | 1 | 38 | KRH92920.1 RNA polymerase II transcription initiation factor TFIIA, large chain [Pseudoloma neurophilia] | diamond | 114 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30001041 | 30001041 | PRJDB4470_P_NODE_61551_length_245_cov_1.051020_g60396_i0 | PRJDB4470 | 61551 | 245 | 1.05102 | 2.574999 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 144 | 1.57e-41 | NR | KRH93999.1 | 146866 | g60396 | i0 | 98.7 | 0.942857142857143 | 77 | 1 | 94.3 | 0 | 3 | 233 | 54 | 130 | KRH93999.1 hypothetical protein M153_4420006276 [Pseudoloma neurophilia] | diamond | 231 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30126985 | 30126985 | PRJDB4470_P_NODE_122592_length_162_cov_0.920354_g121437_i0 | PRJDB4470 | 122592 | 162 | 0.920354 | 1.49097348 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 99.8 | 8.039999999999999e-23 | NR | KRH93110.1 | 146866 | g121437 | i0 | 100 | 0.981481481481482 | 53 | 0 | 98.1 | 0 | 161 | 3 | 302 | 354 | KRH93110.1 6-phosphogluconate dehydrogenase [Pseudoloma neurophilia] | diamond | 159 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31138024 | 31138024 | PRJDB4470_P_NODE_70455_length_219_cov_2.835294_g69300_i0 | PRJDB4470 | 70455 | 219 | 2.835294 | 6.20929386 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 79.7 | 1.81e-17 | NR | KRH92854.1 | 146866 | g69300 | i0 | 98.6 | 0.986301369863014 | 72 | 1 | 98.6 | 0 | 3 | 218 | 14 | 85 | KRH92854.1 hypothetical protein M153_24230001712 [Pseudoloma neurophilia] | diamond | 216 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31359807 | 31359807 | PRJDB4470_P_NODE_114556_length_164_cov_0.904348_g113401_i0 | PRJDB4470 | 114556 | 164 | 0.904348 | 1.48313072 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 101 | 2.68e-23 | NR | KRH95220.1 | 146866 | g113401 | i0 | 98.1 | 0.969512195121951 | 53 | 1 | 97 | 0 | 163 | 5 | 185 | 237 | KRH95220.1 hypothetical protein M153_2100052583 [Pseudoloma neurophilia] | diamond | 159 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32624684 | 32624684 | PRJDB4470_P_NODE_101180_length_169_cov_0.866667_g100025_i0 | PRJDB4470 | 101180 | 169 | 0.866667 | 1.46466723 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 112 | 3.5400000000000003e-29 | NR | KRH94118.1 | 146866 | g100025 | i0 | 100 | 0.994082840236686 | 56 | 0 | 99.4 | 0 | 1 | 168 | 35 | 90 | KRH94118.1 20S proteasome, regulatory subunit beta type PSMB5/PSMB8/PRE2 [Pseudoloma neurophilia] | diamond | 168 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32719302 | 32719302 | PRJDB4470_P_NODE_82100_length_195_cov_1.424658_g80945_i0 | PRJDB4470 | 82100 | 195 | 1.424658 | 2.7780831 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 134 | 1.5399999999999998e-35 | NR | KRH93141.1 | 146866 | g80945 | i0 | 98.4 | 0.984615384615385 | 64 | 1 | 98.5 | 0 | 2 | 193 | 13 | 76 | KRH93141.1 hypothetical protein M153_14260002472 [Pseudoloma neurophilia] | diamond | 192 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia |
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);;