contig_metadata
6 rows where bioproject = "PRJNA603943", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5681297 | 5681297 | PRJNA603943_P_NODE_51345_length_255_cov_1.241758_g51153_i0 | PRJNA603943 | 51345 | 255 | 1.241758 | 3.1664829 | Linderina pennispora | 61395 | Fungi | Fungi | 198 | 2.81e-46 | NTclustered | gi|2028313324|ref|XM_040886323.1| | 61395 | g51153 | i0 | 82.479 | 34.0470588235294 | 234 | 33 | 90 | 7 | 1 | 230 | 1201 | 1430 | Linderina pennispora putative proline--tRNA ligase C19C7.06 (DL89DRAFT_264615), mRNA | blastn | 8682 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 13331365 | 13331365 | PRJNA603943_P_NODE_4391_length_712_cov_1.589984_g4213_i0 | PRJNA603943 | 4391 | 712 | 1.589984 | 11.32068608 | Linderina pennispora | 61395 | Fungi | Fungi | 89.8 | 5.43e-13 | NTclustered | gi|2028323728|ref|XM_040889815.1| | 61395 | g4213 | i0 | 93.333 | 8.13904494382022 | 60 | 4 | 8 | 0 | 1 | 60 | 599 | 658 | Linderina pennispora 60S ribosomal protein l10a (DL89DRAFT_285288), partial mRNA | blastn | 5795 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 15171206 | 15171206 | PRJNA603943_P_NODE_14852_length_430_cov_1.725490_g14660_i0 | PRJNA603943 | 14852 | 430 | 1.72549 | 7.419607 | Eukaryota | 2759 | Fungi | Fungi | 160 | 4.919999999999999e-46 | NR | KAJ1677308.1 | 68401 | g14660 | i0 | 57.6 | 1.96744186046512 | 139 | 59 | 97 | 0 | 13 | 429 | 4 | 142 | KAJ1677308.1 ribosomal protein P0 (A0) (L10E), partial [Spiromyces aspiralis] | diamond | 846 | 161 | 0.993788819875776 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 23529441 | 23529441 | PRJNA603943_P_NODE_30959_length_325_cov_1.222222_g30767_i0 | PRJNA603943 | 30959 | 325 | 1.222222 | 3.9722215 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 63.5 | 2.19e-10 | NR | KAI8865972.1 | 304332 | g30767 | i0 | 51.6 | 1.14461538461538 | 64 | 27 | 55.4 | 2 | 305 | 126 | 19 | 82 | KAI8865972.1 putative high-mobility group non-histone chromosomal protein [Ramicandelaber brevisporus] | diamond | 372 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus | ||
| 28356405 | 28356405 | PRJNA603943_P_NODE_32686_length_318_cov_1.620408_g32494_i0 | PRJNA603943 | 32686 | 318 | 1.620408 | 5.15289744 | Fungi | 4751 | Fungi | Fungi | 105 | 2.47e-24 | NR | KAK9763238.1 | 34480 | g32494 | i0 | 65.8 | 4.23584905660377 | 79 | 27 | 74.5 | 0 | 317 | 81 | 204 | 282 | KAK9763238.1 cystathionine beta-synthase [Basidiobolus ranarum] | diamond | 1347 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 30269819 | 30269819 | PRJNA603943_P_NODE_51112_length_255_cov_2.351648_g50920_i0 | PRJNA603943 | 51112 | 255 | 2.351648 | 5.9967024 | Syncephalis plumigaleata | 1851185 | Fungi | Fungi | 55.8 | 1.95e-7 | NR | KAI8055824.1 | 1851185 | g50920 | i0 | 79.3 | 0.682352941176471 | 29 | 6 | 34.1 | 0 | 3 | 89 | 112 | 140 | KAI8055824.1 50S ribosomal protein L30e-like protein [Syncephalis plumigaleata] | diamond | 174 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis plumigaleata |
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);;