contig_metadata
6 rows where bioproject = "PRJEB65329" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11197229 | 11197229 | PRJEB65329_S_NODE_12669_length_187_cov_4.373418_g12507_i0 | PRJEB65329 | 12669 | 187 | 4.373418 | 8.17829166 | Opisthokonta | 33154 | Fungi | Fungi | 58.4 | 3.44e-4 | NTclustered | gi|2325054217|ref|XM_051746181.1| | 936130 | g12507 | i0 | 100 | 2.58288770053476 | 31 | 0 | 17 | 0 | 157 | 187 | 842 | 812 | Pisolithus orientalis uncharacterized protein (F5J12DRAFT_842939), mRNA | blastn | 483 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Pisolithaceae | Pisolithus | Pisolithus orientalis | |
| 12472853 | 12472853 | PRJEB65329_S_NODE_12830_length_186_cov_2.350318_g12668_i0 | PRJEB65329 | 12830 | 186 | 2.350318 | 4.37159148 | Eukaryota | 2759 | Fungi | Fungi | 344 | 2.34e-90 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12668 | i0 | 100 | 97.8817204301075 | 186 | 0 | 100 | 0 | 1 | 186 | 1652 | 1467 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 18206 | 344 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17571770 | 17571770 | PRJEB65329_S_NODE_13014_length_184_cov_2.954839_g12852_i0 | PRJEB65329 | 13014 | 184 | 2.954839 | 5.43690376 | Opisthokonta | 33154 | Fungi | Fungi | 340 | 2.99e-89 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g12852 | i0 | 100 | 100 | 184 | 0 | 100 | 0 | 1 | 184 | 228 | 411 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 18400 | 340 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21396049 | 21396049 | PRJEB65329_S_NODE_16657_length_159_cov_2.700000_g16495_i0 | PRJEB65329 | 16657 | 159 | 2.7 | 4.293 | Malassezia | 55193 | Fungi | Fungi | 294 | 1.98e-75 | NTclustered | gi|915512619|gb|KP825402.1| | 76775 | g16495 | i0 | 100 | 98.7169811320755 | 159 | 0 | 100 | 0 | 1 | 159 | 178 | 20 | Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence | blastn | 15696 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24356060 | 24356060 | PRJEB65329_S_NODE_7280_length_272_cov_4.427984_g7118_i0 | PRJEB65329 | 7280 | 272 | 4.427984 | 12.04411648 | Rhodonia placenta | 104341 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|1372285726|ref|XM_024482125.1| | 670580 | g7118 | i0 | 94.444 | 0.338235294117647 | 36 | 2 | 13 | 0 | 1 | 36 | 916 | 881 | Postia placenta MAD-698-R-SB12 hypothetical protein (POSPLADRAFT_1066951), mRNA | blastn | 92 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Adustoporiaceae | Rhodonia | Rhodonia placenta | |
| 27191830 | 27191830 | PRJEB65329_S_NODE_15182_length_168_cov_2.079137_g15020_i0 | PRJEB65329 | 15182 | 168 | 2.079137 | 3.49295016 | Mixia osmundae IAM 14324 | 764103 | Fungi | Fungi | 73.9 | 1.37e-13 | NR | XP_014565237.1 | 764103 | g15020 | i0 | 56.4 | 8.35714285714286 | 55 | 24 | 98.2 | 0 | 4 | 168 | 90 | 144 | XP_014565237.1 uncharacterized protein L969DRAFT_97070 [Mixia osmundae IAM 14324] | diamond | 1404 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Mixiomycetes | Mixiales | Mixiaceae | Mixia | Mixia osmundae |
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);;