contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA645397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4447333 | 4447333 | PRJNA645397_P_NODE_4504_length_250_cov_1.034826_g4431_i0 | PRJNA645397 | 4504 | 250 | 1.034826 | 2.587065 | Malassezia restricta | 76775 | Fungi | Fungi | 403 | 5.43e-108 | NTclustered | gi|1546631533|ref|XM_027627427.1| | 76775 | g4431 | i0 | 99.107 | 1.124 | 224 | 2 | 90 | 0 | 27 | 250 | 1089 | 1312 | Malassezia restricta carbamoyl-phosphate synthase small subunit (MRET_0800), partial mRNA | blastn | 281 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 4987460 | 4987460 | PRJNA645397_P_NODE_10904_length_162_cov_1.601770_g10831_i0 | PRJNA645397 | 10904 | 162 | 1.60177 | 2.5948674 | Basidiomycota | 5204 | Fungi | Fungi | 243 | 7.45e-60 | NTclustered | gi|92111142|gb|DQ459616.1| | 5003 | g10831 | i0 | 99.254 | 82.7160493827161 | 134 | 1 | 83 | 0 | 1 | 134 | 210 | 77 | Sporidiobolus pararoseus isolate C44 18S small subunit ribosomal RNA gene, partial sequence | blastn | 13400 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces pararoseus | |
| 8272830 | 8272830 | PRJNA645397_P_NODE_10487_length_164_cov_0.904348_g10414_i0 | PRJNA645397 | 10487 | 164 | 0.904348 | 1.48313072 | Schizophyllum commune | 5334 | Fungi | Fungi | 224 | 2.74e-54 | NTclustered | gi|10179764|gb|AF249362.1|AF249362 | 5334 | g10414 | i0 | 97.692 | 4.05487804878049 | 130 | 3 | 79 | 0 | 34 | 163 | 8 | 137 | Schizophyllum commune strain 1-82 intergenic spacer 2, partial sequence | blastn | 665 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 10823836 | 10823836 | PRJNA645397_P_NODE_5889_length_215_cov_0.939759_g5816_i0 | PRJNA645397 | 5889 | 215 | 0.939759 | 2.02048185 | Malassezia restricta | 76775 | Fungi | Fungi | 152 | 1.82e-32 | NTclustered | gi|1546632462|ref|XM_027627891.1| | 76775 | g5816 | i0 | 98.824 | 0.395348837209302 | 85 | 1 | 40 | 0 | 131 | 215 | 1917 | 1833 | Malassezia restricta heat shock 70kDa protein 1/2/6/8 (MRET_1264), partial mRNA | blastn | 85 | 152 | 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);;