contig_metadata
4 rows where bioproject = "PRJNA453567", tax_kingdom = "Fungi" and tax_phylum = "Cryptomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14470450 | 14470450 | PRJNA453567_P_NODE_1972_length_820_cov_2.560664_g1820_i0 | PRJNA453567 | 1972 | 820 | 2.560664 | 20.9974448 | Eukaryota | 2759 | Fungi | Fungi | 407 | 1.97e-141 | NR | EPZ33659.1 | 988480 | g1820 | i0 | 77.2 | 7.40853658536585 | 250 | 57 | 91.5 | 0 | 14 | 763 | 1 | 250 | EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55] | diamond | 6075 | 409 | 0.995110024449878 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28812677 | 28812677 | PRJNA453567_P_NODE_11608_length_273_cov_1.322034_g11371_i0 | PRJNA453567 | 11608 | 273 | 1.322034 | 3.60915282 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 142 | 2.14e-40 | NR | EPZ35724.1 | 988480 | g11371 | i0 | 76.1 | 0.967032967032967 | 88 | 21 | 96.7 | 0 | 9 | 272 | 122 | 209 | EPZ35724.1 Adenylate kinase [Rozella allomycis CSF55] | diamond | 264 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30234090 | 30234090 | PRJNA453567_P_NODE_16912_length_218_cov_1.055249_g16675_i0 | PRJNA453567 | 16912 | 218 | 1.055249 | 2.3004428200000002 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 42.4 | 0.0372 | NR | RKP20251.1 | 988480 | g16675 | i0 | 34.5 | 0.756880733944954 | 55 | 34 | 75.7 | 1 | 32 | 196 | 216 | 268 | RKP20251.1 hypothetical protein ROZALSC1DRAFT_28243 [Rozella allomycis CSF55] | diamond | 165 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 31229579 | 31229579 | PRJNA453567_P_NODE_18995_length_203_cov_3.753012_g18758_i0 | PRJNA453567 | 18995 | 203 | 3.753012 | 7.61861436 | Eukaryota | 2759 | Fungi | Fungi | 76.3 | 9.34e-15 | NR | EPZ34692.1 | 988480 | g18758 | i0 | 63.9 | 4.3448275862069 | 61 | 21 | 88.7 | 1 | 182 | 3 | 190 | 250 | EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55] | diamond | 882 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis |
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);;