contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1111448" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6125913 | 6125913 | PRJNA1111448_S_NODE_82685_length_292_cov_1.913242_g81862_i0 | PRJNA1111448 | 82685 | 292 | 1.913242 | 5.58666664 | Tremellales | 5234 | Fungi | Fungi | 137 | 7.26e-28 | NTclustered | gi|155089195|gb|EU046042.1| | 227714 | g81862 | i0 | 91.919 | 34.5787671232877 | 99 | 7 | 34 | 1 | 189 | 287 | 538 | 441 | Uncultured Tremellales isolate RSEM07_11E internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence | blastn | 10097 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | uncultured Tremellales | |||
| 6596285 | 6596285 | PRJNA1111448_S_NODE_63266_length_322_cov_0.907631_g62443_i0 | PRJNA1111448 | 63266 | 322 | 0.907631 | 2.92257182 | Suillus discolor | 1912936 | Fungi | Fungi | 52.8 | 0.03 | NTclustered | gi|2033180561|ref|XM_041432306.1| | 1912936 | g62443 | i0 | 100 | 0.0869565217391304 | 28 | 0 | 9 | 0 | 267 | 294 | 49 | 76 | Suillus discolor MFS general substrate transporter (F5147DRAFT_604590), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus discolor | |
| 7870195 | 7870195 | PRJNA1111448_S_NODE_116287_length_255_cov_1.208791_g115464_i0 | PRJNA1111448 | 116287 | 255 | 1.208791 | 3.08241705 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g115464 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 1 | 28 | 3 | 30 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 12971141 | 12971141 | PRJNA1111448_S_NODE_103411_length_268_cov_1.184615_g102588_i0 | PRJNA1111448 | 103411 | 268 | 1.184615 | 3.1747682 | Malassezia globosa | 76773 | Fungi | Fungi | 457 | 4.45e-124 | NTclustered | gi|164656866|ref|XM_001729508.1| | 425265 | g102588 | i0 | 98.456 | 3.4589552238806 | 259 | 4 | 97 | 0 | 1 | 259 | 609 | 867 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3104), partial mRNA | blastn | 927 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 16795494 | 16795494 | PRJNA1111448_S_NODE_85314_length_289_cov_1.319444_g84491_i0 | PRJNA1111448 | 85314 | 289 | 1.319444 | 3.81319316 | Suillus bovinus | 48563 | Fungi | Fungi | 154 | 7.13e-33 | NTclustered | gi|2033090892|ref|XM_041454872.1| | 48563 | g84491 | i0 | 83.951 | 5.83044982698962 | 162 | 24 | 56 | 2 | 128 | 288 | 5602 | 5442 | Suillus bovinus uncharacterized protein (EDB93DRAFT_1319216), mRNA | blastn | 1685 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus bovinus | |
| 20619157 | 20619157 | PRJNA1111448_S_NODE_50017_length_348_cov_1.367273_g49194_i0 | PRJNA1111448 | 50017 | 348 | 1.367273 | 4.75811004 | Leucosporidium sp. AY30 | 662878 | Fungi | Fungi | 95.3 | 5.4e-15 | NTclustered | gi|254927417|gb|GQ336996.1| | 662878 | g49194 | i0 | 81.739 | 23.0775862068966 | 115 | 19 | 33 | 2 | 153 | 266 | 5553 | 5440 | Leucosporidium sp. AY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 8031 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium sp. AY30 | |
| 25248954 | 25248954 | PRJNA1111448_S_NODE_138440_length_241_cov_1.375000_g137617_i0 | PRJNA1111448 | 138440 | 241 | 1.375 | 3.31375 | Helicogloeaceae | 2249318 | Fungi | Fungi | 128 | 3.4999999999999997e-25 | NTclustered | gi|514995909|gb|KF061296.1| | 139067 | g137617 | i0 | 97.333 | 33.0331950207469 | 75 | 2 | 31 | 0 | 1 | 75 | 1860 | 1934 | Infundibura adhaerens strain TUB 020326 28S large subunit ribosomal RNA gene, partial sequence | blastn | 7961 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Atractiellomycetes | Atractiellales | Helicogloeaceae | Infundibura | Infundibura adhaerens |
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);;