contig_metadata
10 rows where bioproject = "PRJNA1111448", tax_clade = "Opisthokonta" 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 | |
| 18069193 | 18069193 | PRJNA1111448_S_NODE_131055_length_245_cov_1.343023_g130232_i0 | PRJNA1111448 | 131055 | 245 | 1.343023 | 3.29040635 | Amylostereum chailletii | 55340 | Fungi | Fungi | 132 | 5.34e-38 | NR | KAI0315037.1 | 55340 | g130232 | i0 | 84.9 | 8.04489795918367 | 73 | 11 | 89.4 | 0 | 242 | 24 | 24 | 96 | KAI0315037.1 60S ribosomal protein L37, partial [Amylostereum chailletii] | diamond | 1971 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Amylostereum | Amylostereum chailletii | |
| 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 | |
| 29278195 | 29278195 | PRJNA1111448_S_NODE_130789_length_245_cov_1.546512_g129966_i0 | PRJNA1111448 | 130789 | 245 | 1.546512 | 3.7889544 | Mycena galopus ATCC 62 | 41248 | Fungi | Fungi | 42 | 0.047 | NR | KAF8200597.1 | 1314675 | g129966 | i0 | 40.5 | 0.514285714285714 | 42 | 25 | 51.4 | 0 | 54 | 179 | 19 | 60 | KAF8200597.1 hypothetical protein K438DRAFT_1758801 [Mycena galopus ATCC 62051] | diamond | 126 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galopus | |
| 29341586 | 29341586 | PRJNA1111448_S_NODE_36689_length_384_cov_5.247588_g35866_i0 | PRJNA1111448 | 36689 | 384 | 5.247588 | 20.15073792 | Rhizoctonia solani | 456999 | Fungi | Fungi | 124 | 2.98e-33 | NR | KAF8709163.1 | 456999 | g35866 | i0 | 51.7 | 6.421875 | 116 | 56 | 90.6 | 0 | 16 | 363 | 51 | 166 | KAF8709163.1 TCTP family, partial [Rhizoctonia solani] | diamond | 2466 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani |
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);;