contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA781453" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10966260 | 10966260 | PRJNA781453_P_NODE_11749_length_433_cov_1.283333_g11635_i0 | PRJNA781453 | 11749 | 433 | 1.283333 | 5.55683189 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 270 | 5.61e-81 | NR | KAE9397860.1 | 1447944 | g11635 | i0 | 100 | 1.99538106235566 | 144 | 0 | 99.8 | 0 | 1 | 432 | 1074 | 1217 | KAE9397860.1 pre-mRNA splicing factor [Gymnopus androsaceus JB14] | diamond | 864 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 28032901 | 28032901 | PRJNA781453_P_NODE_9805_length_477_cov_1.633663_g9691_i0 | PRJNA781453 | 9805 | 477 | 1.633663 | 7.79257251 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 276 | 5.209999999999999e-87 | NR | KAE9398844.1 | 1447944 | g9691 | i0 | 90.6 | 1 | 159 | 14 | 99.4 | 1 | 2 | 475 | 220 | 378 | KAE9398844.1 hypothetical protein BT96DRAFT_920598 [Gymnopus androsaceus JB14] | diamond | 477 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 29201138 | 29201138 | PRJNA781453_P_NODE_13309_length_403_cov_2.393939_g13195_i0 | PRJNA781453 | 13309 | 403 | 2.393939 | 9.64757417 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 277 | 1.59e-90 | NR | KAE9409971.1 | 1447944 | g13195 | i0 | 100 | 0.997518610421836 | 134 | 0 | 99.8 | 0 | 402 | 1 | 173 | 306 | KAE9409971.1 hypothetical protein BT96DRAFT_462336 [Gymnopus androsaceus JB14] | diamond | 402 | 277 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 29390562 | 29390562 | PRJNA781453_P_NODE_27329_length_276_cov_1.630542_g27214_i0 | PRJNA781453 | 27329 | 276 | 1.630542 | 4.50029592 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 120 | 2.54e-30 | NR | KAE9409971.1 | 1447944 | g27214 | i0 | 100 | 0.554347826086957 | 51 | 0 | 55.4 | 0 | 2 | 154 | 102 | 152 | KAE9409971.1 hypothetical protein BT96DRAFT_462336 [Gymnopus androsaceus JB14] | diamond | 153 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 29611144 | 29611144 | PRJNA781453_P_NODE_28110_length_272_cov_1.115578_g27995_i0 | PRJNA781453 | 28110 | 272 | 1.115578 | 3.03437216 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 172 | 1.26e-52 | NR | KAE9391144.1 | 1447944 | g27995 | i0 | 100 | 0.992647058823529 | 90 | 0 | 99.3 | 0 | 272 | 3 | 92 | 181 | KAE9391144.1 hypothetical protein BT96DRAFT_959616 [Gymnopus androsaceus JB14] | diamond | 270 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 30243290 | 30243290 | PRJNA781453_P_NODE_15292_length_374_cov_1.750831_g15178_i0 | PRJNA781453 | 15292 | 374 | 1.750831 | 6.54810794 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 114 | 1.36e-28 | NR | XP_025596234.1 | 58919 | g15178 | i0 | 52.1 | 1.77272727272727 | 119 | 56 | 95.5 | 1 | 373 | 17 | 106 | 223 | XP_025596234.1 hypothetical protein FA09DRAFT_340529 [Tilletiopsis washingtonensis] | diamond | 663 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 31602362 | 31602362 | PRJNA781453_P_NODE_19496_length_331_cov_1.445736_g19381_i0 | PRJNA781453 | 19496 | 331 | 1.445736 | 4.78538616 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 218 | 4.08e-63 | NR | KAE9397860.1 | 1447944 | g19381 | i0 | 100 | 62.2205438066465 | 107 | 0 | 97 | 0 | 9 | 329 | 955 | 1061 | KAE9397860.1 pre-mRNA splicing factor [Gymnopus androsaceus JB14] | diamond | 20595 | 218 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus |
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);;