contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26333216 | 26333216 | PRJEB20058_P_NODE_195735_length_259_cov_5.888889_g192911_i0 | PRJEB20058 | 195735 | 259 | 5.888889 | 15.25222251 | Syncephalis pseudoplumigaleata | 1712513 | Fungi | Fungi | 121 | 1.9e-32 | NR | RKP27899.1 | 1712513 | g192911 | i0 | 90.8 | 6.04633204633205 | 65 | 6 | 75.3 | 0 | 24 | 218 | 119 | 183 | RKP27899.1 ribosomal protein S13 [Syncephalis pseudoplumigaleata] | diamond | 1566 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis pseudoplumigaleata | |
| 26335810 | 26335810 | PRJEB20058_P_NODE_3463_length_2535_cov_91.410671_g2806_i0 | PRJEB20058 | 3463 | 2535 | 91.410671 | 2317.26050985 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 604 | 7.44e-203 | NR | ORX94701.1 | 1314790 | g2806 | i0 | 50.2 | 16.2449704142012 | 638 | 277 | 75 | 8 | 1920 | 19 | 122 | 722 | ORX94701.1 AAA-domain-containing protein [Basidiobolus meristosporus CBS 931.73] | diamond | 41181 | 604 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 32910806 | 32910806 | PRJEB20058_P_NODE_177953_length_278_cov_4.119816_g175130_i0 | PRJEB20058 | 177953 | 278 | 4.119816 | 11.45308848 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 50.8 | 5.2e-5 | NR | ORY04734.1 | 1314790 | g175130 | i0 | 52.7 | 1.44604316546763 | 55 | 23 | 57.2 | 2 | 277 | 119 | 135 | 188 | ORY04734.1 Snf7-domain-containing protein [Basidiobolus meristosporus CBS 931.73] | diamond | 402 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 32945736 | 32945736 | PRJEB20058_P_NODE_67458_length_508_cov_4.635347_g64689_i0 | PRJEB20058 | 67458 | 508 | 4.635347 | 23.54756276 | Entomophthora muscae | 34485 | Fungi | Fungi | 173 | 3.369999999999999e-52 | NR | KAJ9051930.1 | 34485 | g64689 | i0 | 78.4 | 0.572834645669291 | 97 | 20 | 57.3 | 1 | 505 | 215 | 57 | 152 | KAJ9051930.1 hypothetical protein DSO57_1039253 [Entomophthora muscae] | diamond | 291 | 173 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 32962507 | 32962507 | PRJEB20058_P_NODE_205202_length_252_cov_12.759162_g202378_i0 | PRJEB20058 | 205202 | 252 | 12.759162 | 32.15308824 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 64.7 | 3.83e-11 | NR | ORY05216.1 | 1314790 | g202378 | i0 | 80.6 | 0.428571428571429 | 36 | 7 | 42.9 | 0 | 128 | 235 | 55 | 90 | ORY05216.1 transcription initiation Spt4 [Basidiobolus meristosporus CBS 931.73] | diamond | 108 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 32979086 | 32979086 | PRJEB20058_P_NODE_116091_length_372_cov_3.173633_g113276_i0 | PRJEB20058 | 116091 | 372 | 3.173633 | 11.80591476 | Neoconidiobolus thromboides FSU 785 | 1314799 | Fungi | Fungi | 78.2 | 5.19e-16 | NR | KAI9293980.1 | 1314799 | g113276 | i0 | 74.1 | 0.975806451612903 | 58 | 15 | 46.8 | 0 | 338 | 165 | 3 | 60 | KAI9293980.1 putative mismatch base pair and cruciform DNA recognition protein Hmp1 [Neoconidiobolus thromboides FSU 785] | diamond | 363 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 32991553 | 32991553 | PRJEB20058_P_NODE_74563_length_481_cov_14.826190_g71786_i0 | PRJEB20058 | 74563 | 481 | 14.82619 | 71.3139739 | Coemansia | 4863 | Fungi | Fungi | 99.4 | 4.76e-22 | NR | PIA17314.1 | 763665 | g71786 | i0 | 53.3 | 1.65280665280665 | 92 | 41 | 57.4 | 1 | 415 | 140 | 133 | 222 | PIA17314.1 RNA-binding domain-containing protein [Coemansia reversa NRRL 1564] | diamond | 795 | 100 | 0.994 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia reversa | |
| 33025445 | 33025445 | PRJEB20058_P_NODE_128420_length_348_cov_31.731707_g125601_i0 | PRJEB20058 | 128420 | 348 | 31.731707 | 110.42634036 | Zoopagomycota | 1913638 | Fungi | Fungi | 154 | 9.29e-46 | NR | KAK9763929.1 | 34480 | g125601 | i0 | 78.4 | 5.82758620689655 | 97 | 21 | 83.6 | 0 | 325 | 35 | 36 | 132 | KAK9763929.1 60S ribosomal protein L18, variant 2 [Basidiobolus ranarum] | diamond | 2028 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 33031117 | 33031117 | PRJEB20058_P_NODE_63260_length_526_cov_4.417204_g60498_i0 | PRJEB20058 | 63260 | 526 | 4.417204 | 23.23449304 | Dispira parvispora | 1520584 | Fungi | Fungi | 65.1 | 2.85e-10 | NR | KAJ1962306.1 | 1520584 | g60498 | i0 | 43.4 | 0.433460076045627 | 76 | 43 | 43.3 | 0 | 166 | 393 | 7 | 82 | KAJ1962306.1 hypothetical protein IWQ62_003571, partial [Dispira parvispora] | diamond | 228 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira parvispora | |
| 33081155 | 33081155 | PRJEB20058_P_NODE_104358_length_397_cov_3.250000_g101550_i0 | PRJEB20058 | 104358 | 397 | 3.25 | 12.9025 | Entomophthora muscae | 34485 | Fungi | Fungi | 192 | 1.16e-53 | NR | KAJ9070725.1 | 34485 | g101550 | i0 | 96.7 | 0.687657430730479 | 91 | 3 | 68.8 | 0 | 12 | 284 | 2480 | 2570 | KAJ9070725.1 pre-mRNA-splicing factor 8 [Entomophthora muscae] | diamond | 273 | 192 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 33115684 | 33115684 | PRJEB20058_P_NODE_177767_length_278_cov_9.940092_g174944_i0 | PRJEB20058 | 177767 | 278 | 9.940092 | 27.63345576 | Massospora cicadina | 348617 | Fungi | Fungi | 47.4 | 0.00111 | NR | KAI0233906.1 | 348617 | g174944 | i0 | 54.3 | 1.00359712230216 | 35 | 16 | 37.8 | 0 | 22 | 126 | 205 | 239 | KAI0233906.1 hypothetical protein L0F63_001448 [Massospora cicadina] | diamond | 279 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Massospora | Massospora cicadina | |
| 33132934 | 33132934 | PRJEB20058_P_NODE_191735_length_263_cov_5.247525_g188911_i0 | PRJEB20058 | 191735 | 263 | 5.247525 | 13.80099075 | Entomophthora muscae | 34485 | Fungi | Fungi | 117 | 3.51e-28 | NR | KAJ9075803.1 | 34485 | g188911 | i0 | 71.6 | 1.84790874524715 | 81 | 21 | 92.4 | 1 | 10 | 252 | 645 | 723 | KAJ9075803.1 alpha-1,4-glucan branching enzyme [Entomophthora muscae] | diamond | 486 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 33133445 | 33133445 | PRJEB20058_P_NODE_59031_length_545_cov_32.599174_g56276_i0 | PRJEB20058 | 59031 | 545 | 32.599174 | 177.6654983 | Neoconidiobolus thromboides FSU 785 | 1314799 | Fungi | Fungi | 56.2 | 3.49e-7 | NR | KAI9290807.1 | 1314799 | g56276 | i0 | 54.5 | 0.572477064220184 | 55 | 23 | 30.3 | 1 | 92 | 256 | 1 | 53 | KAI9290807.1 hypothetical protein K502DRAFT_297933, partial [Neoconidiobolus thromboides FSU 785] | diamond | 312 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides |
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);;