contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 381090 | 381090 | PRJNA315314_S_NODE_7261_length_299_cov_4.759259_g6940_i0 | PRJNA315314 | 7261 | 299 | 4.759259 | 14.23018441 | Austropuccinia psidii | 181123 | Fungi | Fungi | 124 | 1.4299999999999996e-34 | NR | MBW0489473.1 | 1389203 | g6940 | i0 | 86.2 | 2.01672240802676 | 65 | 9 | 65.2 | 0 | 298 | 104 | 20 | 84 | MBW0489473.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 603 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 1065348 | 1065348 | PRJNA315314_S_NODE_26721_length_163_cov_1.014925_g26400_i0 | PRJNA315314 | 26721 | 163 | 1.014925 | 1.65432775 | Russulales | 452342 | Fungi | Fungi | 107 | 2.13e-25 | NR | XP_007307949.1 | 721885 | g26400 | i0 | 88.7 | 9.88343558282209 | 53 | 6 | 97.5 | 0 | 163 | 5 | 126 | 178 | XP_007307949.1 isoleucine-tRNA ligase [Stereum hirsutum FP-91666 SS1] | diamond | 1611 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Stereum | Stereum hirsutum | |
| 1655634 | 1655634 | PRJNA315314_S_NODE_2362_length_514_cov_8.412371_g2063_i0 | PRJNA315314 | 2362 | 514 | 8.412371 | 43.23958694 | Trametes meyenii | 526243 | Fungi | Fungi | 239 | 7.29e-78 | NR | KAI0646293.1 | 526243 | g2063 | i0 | 82.5 | 16.6926070038911 | 154 | 23 | 88.1 | 3 | 509 | 57 | 23 | 175 | KAI0646293.1 ribosomal protein S11-domain-containing protein [Trametes meyenii] | diamond | 8580 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes meyenii | |
| 4208231 | 4208231 | PRJNA315314_S_NODE_5444_length_344_cov_9.155556_g5123_i0 | PRJNA315314 | 5444 | 344 | 9.155556 | 31.49511264 | Eukaryota | 2759 | Fungi | Fungi | 106 | 9.79e-28 | NR | KAF9787047.1 | 56493 | g5123 | i0 | 83.9 | 19.5174418604651 | 62 | 10 | 54.1 | 0 | 83 | 268 | 7 | 68 | KAF9787047.1 40S ribosomal protein S28 [Thelephora terrestris] | diamond | 6714 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Thelephorales | Thelephoraceae | Thelephora | Thelephora terrestris | |
| 8033958 | 8033958 | PRJNA315314_S_NODE_14467_length_215_cov_2.059140_g14146_i0 | PRJNA315314 | 14467 | 215 | 2.05914 | 4.427151 | Marasmius | 34448 | Fungi | Fungi | 94.4 | 5.13e-21 | NR | KAJ8076880.1 | 585030 | g14146 | i0 | 60.9 | 1.92558139534884 | 69 | 27 | 96.3 | 0 | 211 | 5 | 223 | 291 | KAJ8076880.1 Nuclear SAM-dependent mono-and asymmetric methyltransferase [Marasmius tenuissimus] | diamond | 414 | 94.7 | 0.996832101372756 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius tenuissimus | |
| 9308725 | 9308725 | PRJNA315314_S_NODE_15708_length_206_cov_4246.870056_g15387_i0 | PRJNA315314 | 15708 | 206 | 4246.870056 | 8748.55231536 | Fungi | 4751 | Fungi | Fungi | 113 | 4.19e-30 | NR | XP_021873467.1 | 4999 | g15387 | i0 | 82 | 4.4126213592233 | 61 | 11 | 88.8 | 0 | 183 | 1 | 30 | 90 | XP_021873467.1 cyclophilin A [Kockovaella imperatae] | diamond | 909 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Kockovaella | Kockovaella imperatae | |
| 10584768 | 10584768 | PRJNA315314_S_NODE_2889_length_465_cov_10.068807_g2573_i0 | PRJNA315314 | 2889 | 465 | 10.068807 | 46.819952549999996 | Opisthokonta | 33154 | Fungi | Fungi | 144 | 7.36e-40 | NR | XP_052947206.1 | 4972 | g2573 | i0 | 59.7 | 24.1935483870968 | 144 | 49 | 92.3 | 3 | 2 | 430 | 100 | 235 | XP_052947206.1 structural constituent of ribosome [Dioszegia hungarica] | diamond | 11250 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 26631217 | 26631217 | PRJNA315314_S_NODE_29581_length_156_cov_1.448819_g29260_i0 | PRJNA315314 | 29581 | 156 | 1.448819 | 2.26015764 | Dacryopinax primogenitus | 1858805 | Fungi | Fungi | 44.7 | 0.00137 | NR | XP_040632926.1 | 1858805 | g29260 | i0 | 55.6 | 1.78846153846154 | 45 | 20 | 86.5 | 0 | 148 | 14 | 12 | 56 | XP_040632926.1 translationally-controlled tumor protein [Dacryopinax primogenitus] | diamond | 279 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Dacrymycetes | Dacrymycetales | Dacrymycetaceae | Dacryopinax | Dacryopinax primogenitus | |
| 26916144 | 26916144 | PRJNA315314_S_NODE_32462_length_150_cov_2.008264_g32141_i0 | PRJNA315314 | 32462 | 150 | 2.008264 | 3.012396 | Rhizoctonia solani AG-1 IB | 1108050 | Fungi | Fungi | 46.2 | 7.89e-5 | NR | CEL54683.1 | 1108050 | g32141 | i0 | 51.3 | 0.78 | 39 | 19 | 78 | 0 | 5 | 121 | 38 | 76 | CEL54683.1 hypothetical protein RSOLAG1IB_07217 [Rhizoctonia solani AG-1 IB] | diamond | 117 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 27028608 | 27028608 | PRJNA315314_S_NODE_32302_length_150_cov_3.264463_g31981_i0 | PRJNA315314 | 32302 | 150 | 3.264463 | 4.8966945 | Agaricomycetes | 155619 | Fungi | Fungi | 81.3 | 1.01e-16 | NR | KAI0309062.1 | 55340 | g31981 | i0 | 70.2 | 17.08 | 47 | 14 | 94 | 0 | 10 | 150 | 13 | 59 | KAI0309062.1 40S ribosomal protein S2 [Amylostereum chailletii] | diamond | 2562 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Amylostereum | Amylostereum chailletii | |
| 27439798 | 27439798 | PRJNA315314_S_NODE_28423_length_158_cov_3.565891_g28102_i0 | PRJNA315314 | 28423 | 158 | 3.565891 | 5.63410778 | Agaricomycetes | 155619 | Fungi | Fungi | 100 | 9.68e-26 | NR | CAE7213997.1 | 456999 | g28102 | i0 | 80.8 | 11.7911392405063 | 52 | 10 | 98.7 | 0 | 157 | 2 | 30 | 81 | CAE7213997.1 unnamed protein product [Rhizoctonia solani] | diamond | 1863 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 27706525 | 27706525 | PRJNA315314_S_NODE_10164_length_254_cov_2.488889_g9843_i0 | PRJNA315314 | 10164 | 254 | 2.488889 | 6.32177806 | Calocera viscosa TUFC12733 | 1330018 | Fungi | Fungi | 78.6 | 1.05e-14 | NR | KZP01337.1 | 1330018 | g9843 | i0 | 47.4 | 3.70866141732283 | 76 | 38 | 87.4 | 1 | 224 | 3 | 656 | 731 | KZP01337.1 actin cross-linking [Calocera viscosa TUFC12733] | diamond | 942 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Dacrymycetes | Dacrymycetales | Dacrymycetaceae | Calocera | Calocera viscosa | |
| 28481455 | 28481455 | PRJNA315314_S_NODE_1706_length_596_cov_11.867725_g1439_i0 | PRJNA315314 | 1706 | 596 | 11.867725 | 70.731641 | Eukaryota | 2759 | Fungi | Fungi | 130 | 9.409999999999999e-35 | NR | KAK4333401.1 | 5286 | g1439 | i0 | 42.4 | 11.0738255033557 | 170 | 92 | 84.1 | 4 | 578 | 78 | 1 | 167 | KAK4333401.1 Translationally-controlled tumor protein-like protein [Rhodotorula toruloides] | diamond | 6600 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 31292465 | 31292465 | PRJNA315314_S_NODE_1835_length_573_cov_12.397059_g1565_i0 | PRJNA315314 | 1835 | 573 | 12.397059 | 71.03514807 | Tremellales | 5234 | Fungi | Fungi | 106 | 1.1e-25 | NR | XP_052946076.1 | 4972 | g1565 | i0 | 43.4 | 4.24607329842932 | 136 | 75 | 71.2 | 1 | 567 | 160 | 6 | 139 | XP_052946076.1 ribosomal protein L14-domain-containing protein, partial [Dioszegia hungarica] | diamond | 2433 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 31559911 | 31559911 | PRJNA315314_S_NODE_3396_length_433_cov_10.428218_g3076_i0 | PRJNA315314 | 3396 | 433 | 10.428218 | 45.15418394 | Tilletia horrida | 155126 | Fungi | Fungi | 52.4 | 7.72e-5 | NR | KAK0536965.1 | 155126 | g3076 | i0 | 40.7 | 0.748267898383372 | 108 | 59 | 74.1 | 3 | 322 | 2 | 12 | 115 | KAK0536965.1 60S ribosomal protein L6 [Tilletia horrida] | diamond | 324 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia horrida |
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);;