contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA888104" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4690677 | 4690677 | PRJNA888104_P_NODE_20964_length_232_cov_0.895706_g20895_i0 | PRJNA888104 | 20964 | 232 | 0.895706 | 2.07803792 | Magnusiomyces paraingens | 2606893 | Fungi | Fungi | 52.8 | 0.021 | NTclustered | gi|1800254221|ref|XM_031998169.1| | 2606893 | g20895 | i0 | 100 | 0.120689655172414 | 28 | 0 | 12 | 0 | 203 | 230 | 1229 | 1256 | Magnusiomyces paraingens uncharacterized protein (SAPINGB_P003451), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Magnusiomyces | Magnusiomyces paraingens | |
| 9790232 | 9790232 | PRJNA888104_P_NODE_21548_length_231_cov_0.901235_g21479_i0 | PRJNA888104 | 21548 | 231 | 0.901235 | 2.08185285 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 289 | 1.45e-73 | NTclustered | gi|2837732678|ref|XM_069370813.1| | 1052096 | g21479 | i0 | 89.177 | 1 | 231 | 25 | 100 | 0 | 1 | 231 | 1164 | 934 | Cladosporium halotolerans uncharacterized protein (WHR41_02207), partial mRNA | blastn | 231 | 289 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 15269493 | 15269493 | PRJNA888104_P_NODE_6932_length_371_cov_1.559603_g6863_i0 | PRJNA888104 | 6932 | 371 | 1.559603 | 5.78612713 | Paradevriesia | 2881007 | Fungi | Fungi | 658 | 0 | NTclustered | gi|313483002|gb|HQ433007.1| | 175243 | g6863 | i0 | 98.652 | 99.5363881401617 | 371 | 5 | 100 | 0 | 1 | 371 | 327 | 697 | Uncultured Ascomycota clone asc07052 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 36928 | 658 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 18713789 | 18713789 | PRJNA888104_P_NODE_6575_length_380_cov_1.717042_g6506_i0 | PRJNA888104 | 6575 | 380 | 1.717042 | 6.5247596 | Aspergillus campestris | 41068 | Fungi | Fungi | 52.8 | 0.036 | NTclustered | gi|1383817080|ref|XM_024836301.1| | 1392248 | g6506 | i0 | 100 | 0.0736842105263158 | 28 | 0 | 7 | 0 | 73 | 100 | 2805 | 2778 | Aspergillus campestris IBT 28561 VID27-domain-containing protein (P168DRAFT_286214), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus campestris | |
| 21643722 | 21643722 | PRJNA888104_P_NODE_6077_length_394_cov_2.486154_g6008_i0 | PRJNA888104 | 6077 | 394 | 2.486154 | 9.79544676 | Opisthokonta | 33154 | Fungi | Fungi | 728 | 0 | NTclustered | gi|325484983|gb|HQ407432.1| | 5061 | g6008 | i0 | 100 | 99.6725888324873 | 394 | 0 | 100 | 0 | 1 | 394 | 739 | 346 | Aspergillus niger strain B1.Eg mitochondrial citrate synthase precursor, gene, partial cds; nuclear gene for mitochondrial product | blastn | 39271 | 728 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 22539082 | 22539082 | PRJNA888104_P_NODE_21998_length_230_cov_0.906832_g21929_i0 | PRJNA888104 | 21998 | 230 | 0.906832 | 2.0857136 | Alternaria rosae | 1187941 | Fungi | Fungi | 409 | 1.0600000000000001e-109 | NTclustered | gi|2185422105|ref|XM_046175471.1| | 1187941 | g21929 | i0 | 98.696 | 14.2347826086957 | 230 | 3 | 100 | 0 | 1 | 230 | 1049 | 1278 | Alternaria rosae uncharacterized protein (BKA58DRAFT_53228), mRNA | blastn | 3274 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria rosae |
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);;