contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA591000" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 564959 | 564959 | PRJNA591000_P_NODE_11661_length_421_cov_4.469388_g5081_i1 | PRJNA591000 | 11661 | 421 | 4.469388 | 18.81612348 | Malassezia restricta | 76775 | Fungi | Fungi | 756 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5081 | i1 | 99.518 | 98.0356294536817 | 415 | 2 | 99 | 0 | 7 | 421 | 1528 | 1942 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 41273 | 756 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 564966 | 564966 | PRJNA591000_P_NODE_1741_length_950_cov_12.136808_g1260_i0 | PRJNA591000 | 1741 | 950 | 12.136808 | 115.299676 | Malassezia globosa | 76773 | Fungi | Fungi | 1218 | 0 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g1260 | i0 | 96.735 | 65.7421052631579 | 735 | 16 | 88 | 5 | 219 | 950 | 2487 | 1758 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 62455 | 1218 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 5668670 | 5668670 | PRJNA591000_P_NODE_2545_length_839_cov_14.365432_g1260_i1 | PRJNA591000 | 2545 | 839 | 14.365432 | 120.52597448 | Malassezia globosa | 76773 | Fungi | Fungi | 1415 | 0 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g1260 | i1 | 97.15 | 74.150178784267 | 842 | 16 | 100 | 5 | 1 | 839 | 2487 | 1651 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 62212 | 1415 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 11341962 | 11341962 | PRJNA591000_P_NODE_12229_length_415_cov_1.217617_g10643_i0 | PRJNA591000 | 12229 | 415 | 1.217617 | 5.05311055 | Malassezia | 55193 | Fungi | Fungi | 198 | 4.84e-46 | NTclustered | gi|52631075|gb|AY745725.1| | 55194 | g10643 | i0 | 100 | 35.1759036144578 | 107 | 0 | 40 | 0 | 1 | 107 | 1060 | 954 | Malassezia furfur isolate AFTOL-ID 855 25S large subunit ribosomal RNA gene, partial sequence | blastn | 14598 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 13318904 | 13318904 | PRJNA591000_P_NODE_16431_length_163_cov_1.768657_g14825_i0 | PRJNA591000 | 16431 | 163 | 1.768657 | 2.88291091 | Malassezia globosa | 76773 | Fungi | Fungi | 302 | 1.22e-77 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g14825 | i0 | 100 | 52.9447852760736 | 163 | 0 | 100 | 0 | 1 | 163 | 544 | 706 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 8630 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 20265131 | 20265131 | PRJNA591000_P_NODE_1696_length_959_cov_2.927957_g1221_i0 | PRJNA591000 | 1696 | 959 | 2.927957 | 28.07910763 | Malassezia | 55193 | Fungi | Fungi | 845 | 0 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g1221 | i0 | 99.783 | 38.9134515119917 | 460 | 1 | 84 | 0 | 185 | 644 | 1391 | 932 | Malassezia restricta mitochondrion, complete genome | blastn | 37318 | 845 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 22815809 | 22815809 | PRJNA591000_P_NODE_2118_length_892_cov_3.446118_g1221_i1 | PRJNA591000 | 2118 | 892 | 3.446118 | 30.73937256 | Malassezia | 55193 | Fungi | Fungi | 845 | 0 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g1221 | i1 | 99.783 | 46.6412556053812 | 460 | 1 | 98 | 0 | 249 | 708 | 932 | 1391 | Malassezia restricta mitochondrion, complete genome | blastn | 41604 | 845 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;