contig_metadata
4 rows where bioproject = "PRJNA949785", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8586188 | 8586188 | PRJNA949785_P_NODE_3167_length_660_cov_1.839864_g2986_i0 | PRJNA949785 | 3167 | 660 | 1.839864 | 12.1431024 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 199 | 1.07e-57 | NR | KNE56683.1 | 578462 | g2986 | i0 | 65.9 | 1.26818181818182 | 138 | 47 | 62.7 | 0 | 437 | 24 | 214 | 351 | KNE56683.1 hypothetical protein AMAG_02466 [Allomyces macrogynus ATCC 38327] | diamond | 837 | 199 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 30625679 | 30625679 | PRJNA949785_P_NODE_9413_length_340_cov_1.153558_g9216_i0 | PRJNA949785 | 9413 | 340 | 1.153558 | 3.9220972 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 53.5 | 1.92e-5 | NR | KAJ1509573.1 | 945690 | g9216 | i0 | 39 | 1.44705882352941 | 82 | 47 | 69.7 | 1 | 340 | 104 | 402 | 483 | KAJ1509573.1 hypothetical protein HMI55_007338 [Coelomomyces lativittatus] | diamond | 492 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 32143574 | 32143574 | PRJNA949785_P_NODE_10858_length_313_cov_0.962500_g10661_i0 | PRJNA949785 | 10858 | 313 | 0.9625 | 3.012625 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 53.5 | 8.83e-6 | NR | KAI9142556.1 | 1500003 | g10661 | i0 | 34.3 | 1.91693290734824 | 102 | 64 | 97.8 | 2 | 6 | 311 | 9 | 107 | KAI9142556.1 U3 small nucleolar RNA-associated protein 6-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 600 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32302104 | 32302104 | PRJNA949785_P_NODE_12399_length_289_cov_1.023148_g12202_i0 | PRJNA949785 | 12399 | 289 | 1.023148 | 2.95689772 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 94 | 6.2500000000000006e-21 | NR | KAI9135807.1 | 1500003 | g12202 | i0 | 55.6 | 0.84083044982699 | 81 | 35 | 84.1 | 1 | 252 | 10 | 51 | 130 | KAI9135807.1 hypothetical protein BKA69DRAFT_1108330 [Paraphysoderma sedebokerense] | diamond | 243 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense |
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);;