contig_metadata
8 rows where bioproject = "PRJNA597223" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27111287 | 27111287 | PRJNA597223_P_NODE_18842_length_376_cov_2.909091_g17016_i0 | PRJNA597223 | 18842 | 376 | 2.909091 | 10.93818216 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 167 | 4.08e-49 | NR | RVD90613.1 | 291195 | g17016 | i0 | 98.8 | 0.686170212765957 | 86 | 1 | 68.6 | 0 | 119 | 376 | 1 | 86 | RVD90613.1 hypothetical protein TUBRATIS_29590 [Tubulinosema ratisbonensis] | diamond | 258 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis | |||
| 27364625 | 27364625 | PRJNA597223_P_NODE_72003_length_168_cov_1.060150_g70157_i0 | PRJNA597223 | 72003 | 168 | 1.06015 | 1.781052 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 76.3 | 1.96e-14 | NR | RVD90615.1 | 291195 | g70157 | i0 | 97.4 | 0.696428571428571 | 39 | 1 | 69.6 | 0 | 50 | 166 | 1 | 39 | RVD90615.1 hypothetical protein TUBRATIS_29580, partial [Tubulinosema ratisbonensis] | diamond | 117 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis | |||
| 27680400 | 27680400 | PRJNA597223_P_NODE_20004_length_362_cov_2.119266_g18171_i0 | PRJNA597223 | 20004 | 362 | 2.119266 | 7.67174292 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 258 | 4.7000000000000005e-80 | NR | RVD90501.1 | 291195 | g18171 | i0 | 100 | 0.994475138121547 | 120 | 0 | 99.4 | 0 | 2 | 361 | 363 | 482 | RVD90501.1 hypothetical protein TUBRATIS_31610 [Tubulinosema ratisbonensis] | diamond | 360 | 258 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis | |||
| 28595898 | 28595898 | PRJNA597223_P_NODE_17987_length_387_cov_3.002841_g16166_i0 | PRJNA597223 | 17987 | 387 | 3.002841 | 11.62099467 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 117 | 9.21e-28 | NR | RVD90501.1 | 291195 | g16166 | i0 | 98.3 | 0.457364341085271 | 59 | 1 | 45.7 | 0 | 206 | 382 | 154 | 212 | RVD90501.1 hypothetical protein TUBRATIS_31610 [Tubulinosema ratisbonensis] | diamond | 177 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis | |||
| 30616844 | 30616844 | PRJNA597223_P_NODE_17473_length_394_cov_2.988858_g15656_i0 | PRJNA597223 | 17473 | 394 | 2.988858 | 11.77610052 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 250 | 9.2e-77 | NR | RVD90501.1 | 291195 | g15656 | i0 | 100 | 0.99746192893401 | 131 | 0 | 99.7 | 0 | 1 | 393 | 221 | 351 | RVD90501.1 hypothetical protein TUBRATIS_31610 [Tubulinosema ratisbonensis] | diamond | 393 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis | |||
| 31565417 | 31565417 | PRJNA597223_P_NODE_17476_length_394_cov_2.821727_g15659_i0 | PRJNA597223 | 17476 | 394 | 2.821727 | 11.11760438 | Nosema granulosis | 83296 | Fungi | Fungi | 82.4 | 2.7e-15 | NR | KAF9756187.1 | 83296 | g15659 | i0 | 37.8 | 3.10659898477157 | 127 | 71 | 91.4 | 2 | 5 | 364 | 366 | 491 | KAF9756187.1 Retrovirus-related Pol polyprotein from transposon, partial [Nosema granulosis] | diamond | 1224 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 32514637 | 32514637 | PRJNA597223_P_NODE_67919_length_174_cov_1.589928_g66073_i0 | PRJNA597223 | 67919 | 174 | 1.589928 | 2.76647472 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 127 | 3.67e-33 | NR | RVD90615.1 | 291195 | g66073 | i0 | 98.2 | 0.982758620689655 | 57 | 1 | 98.3 | 0 | 173 | 3 | 42 | 98 | RVD90615.1 hypothetical protein TUBRATIS_29580, partial [Tubulinosema ratisbonensis] | diamond | 171 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis | |||
| 32546173 | 32546173 | PRJNA597223_P_NODE_61879_length_185_cov_1.253333_g60033_i0 | PRJNA597223 | 61879 | 185 | 1.253333 | 2.31866605 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 131 | 7.63e-34 | NR | RVD90501.1 | 291195 | g60033 | i0 | 100 | 0.972972972972973 | 60 | 0 | 97.3 | 0 | 181 | 2 | 566 | 625 | RVD90501.1 hypothetical protein TUBRATIS_31610 [Tubulinosema ratisbonensis] | diamond | 180 | 131 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis |
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);;