contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA870096" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 849627 | 849627 | PRJNA870096_S_NODE_129301_length_157_cov_1.166667_g127637_i0 | PRJNA870096 | 129301 | 157 | 1.166667 | 1.83166719 | Malassezia restricta | 76775 | Fungi | Fungi | 291 | 2.52e-74 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g127637 | i0 | 100 | 90.2484076433121 | 157 | 0 | 100 | 0 | 1 | 157 | 3069 | 3225 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 14169 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 850110 | 850110 | PRJNA870096_S_NODE_41581_length_275_cov_1.737069_g39917_i0 | PRJNA870096 | 41581 | 275 | 1.737069 | 4.77693975 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.025 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g39917 | i0 | 100 | 0.101818181818182 | 28 | 0 | 10 | 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 | |
| 1237245 | 1237245 | PRJNA870096_S_NODE_14021_length_489_cov_4.051570_g12385_i0 | PRJNA870096 | 14021 | 489 | 4.05157 | 19.8121773 | Pucciniales | 5258 | Fungi | Fungi | 56.5 | 0.004 | NTclustered | gi|1714236393|ref|NC_044121.1| | 181123 | g12385 | i0 | 100 | 2.59918200408998 | 30 | 0 | 6 | 0 | 1 | 30 | 43838 | 43867 | Austropuccinia psidii isolate MF-1 mitochondrion, complete genome | blastn | 1271 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 2125455 | 2125455 | PRJNA870096_S_NODE_43242_length_269_cov_2.309735_g41578_i0 | PRJNA870096 | 43242 | 269 | 2.309735 | 6.21318715 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.025 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g41578 | i0 | 100 | 0.104089219330855 | 28 | 0 | 10 | 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 | |
| 3401486 | 3401486 | PRJNA870096_S_NODE_91443_length_184_cov_1.361702_g89779_i0 | PRJNA870096 | 91443 | 184 | 1.361702 | 2.50553168 | Kwoniella dejecticola | 324770 | Fungi | Fungi | 100 | 5.52e-17 | NTclustered | gi|2746401313|ref|XM_065968846.1| | 1296121 | g89779 | i0 | 85.417 | 5.59239130434783 | 96 | 14 | 52 | 0 | 1 | 96 | 1002 | 1097 | Kwoniella dejecticola CBS 10117 valine-tRNA ligase (I303_103797), partial mRNA | blastn | 1029 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dejecticola | |
| 3789276 | 3789276 | PRJNA870096_S_NODE_81743_length_194_cov_1.589404_g80079_i0 | PRJNA870096 | 81743 | 194 | 1.589404 | 3.08344376 | Agaricus | 5340 | Fungi | Fungi | 76.8 | 9.94e-10 | NTclustered | gi|597975714|ref|XM_007328424.1| | 597362 | g80079 | i0 | 85.915 | 0.731958762886598 | 71 | 10 | 37 | 0 | 121 | 191 | 212 | 282 | Agaricus bisporus var. burnettii JB137-S8 uncharacterized protein (AGABI1DRAFT_112627), mRNA | blastn | 142 | 76.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 5952767 | 5952767 | PRJNA870096_S_NODE_118845_length_163_cov_1.600000_g117181_i0 | PRJNA870096 | 118845 | 163 | 1.6 | 2.608 | Cryptococcus gattii | 37769 | Fungi | Fungi | 108 | 2.86e-19 | NTclustered | gi|321248884|ref|XM_003191226.1| | 367775 | g117181 | i0 | 84.906 | 2.60122699386503 | 106 | 16 | 65 | 0 | 1 | 106 | 764 | 869 | Cryptococcus gattii WM276 protein arginine n-methyltransferase, putative (CGB_A2590W), partial mRNA | blastn | 424 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus gattii | |
| 7228068 | 7228068 | PRJNA870096_S_NODE_20686_length_398_cov_9.360563_g19028_i0 | PRJNA870096 | 20686 | 398 | 9.360563 | 37.25504074 | Cantharellus anzutake | 1750568 | Fungi | Fungi | 89.8 | 2.91e-13 | NTclustered | gi|1956423846|ref|XM_039059075.1| | 1750568 | g19028 | i0 | 80.328 | 0.306532663316583 | 122 | 20 | 30 | 3 | 221 | 340 | 2516 | 2397 | Cantharellus anzutake P-loop containing nucleoside triphosphate hydrolase protein (EI90DRAFT_3041215), mRNA | blastn | 122 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Hydnaceae | Cantharellus | Cantharellus anzutake | |
| 8503360 | 8503360 | PRJNA870096_S_NODE_66687_length_214_cov_12.304094_g65023_i0 | PRJNA870096 | 66687 | 214 | 12.304094 | 26.33076116 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.019 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g65023 | i0 | 94.286 | 0.163551401869159 | 35 | 1 | 16 | 1 | 180 | 214 | 36 | 3 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 12329620 | 12329620 | PRJNA870096_S_NODE_75950_length_201_cov_1.518987_g74286_i0 | PRJNA870096 | 75950 | 201 | 1.518987 | 3.05316387 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.017 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g74286 | i0 | 100 | 0.139303482587065 | 28 | 0 | 14 | 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 | |
| 19976731 | 19976731 | PRJNA870096_S_NODE_45396_length_262_cov_3.173516_g43732_i0 | PRJNA870096 | 45396 | 262 | 3.173516 | 8.31461192 | Meira miltonrushii | 1280837 | Fungi | Fungi | 52.8 | 0.024 | NTclustered | gi|1418865157|ref|XM_025502216.1| | 1280837 | g43732 | i0 | 100 | 0.106870229007634 | 28 | 0 | 11 | 0 | 106 | 133 | 1465 | 1438 | Meira miltonrushii eukaryotic translation initiation factor 5 (FA14DRAFT_34049), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 19976959 | 19976959 | PRJNA870096_S_NODE_64156_length_219_cov_1.090909_g62492_i0 | PRJNA870096 | 64156 | 219 | 1.090909 | 2.38909071 | Puccinia striiformis | 27350 | Fungi | Fungi | 158 | 3.99e-34 | NTclustered | gi|2234896941|ref|XM_047949413.1| | 168172 | g62492 | i0 | 80.952 | 44.2602739726027 | 210 | 31 | 95 | 8 | 1 | 207 | 424 | 627 | Puccinia striiformis f. sp. tritici uncharacterized protein (Pst134EA_018985), mRNA | blastn | 9693 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis |
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);;