contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJDB4470" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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);;