contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26757254 | 26757254 | PRJNA168635_P_NODE_10581_length_253_cov_12.485294_g10166_i0 | PRJNA168635 | 10581 | 253 | 12.485294 | 31.58779382 | Rhizoclosmatium globosum | 329046 | Fungi | Fungi | 60.1 | 6.67e-10 | NR | ORY18463.1 | 329046 | g10166 | i0 | 56.6 | 0.628458498023715 | 53 | 23 | 62.8 | 0 | 22 | 180 | 1 | 53 | ORY18463.1 hypothetical protein BCR33DRAFT_730870 [Rhizoclosmatium globosum] | diamond | 159 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Rhizoclosmatium | Rhizoclosmatium globosum | |
| 27390176 | 27390176 | PRJNA168635_P_NODE_24923_length_169_cov_2.500000_g24507_i0 | PRJNA168635 | 24923 | 169 | 2.5 | 4.225 | Geranomyces variabilis | 109894 | Fungi | Fungi | 43.1 | 0.0104 | NR | KAJ3173729.1 | 109894 | g24507 | i0 | 47.8 | 0.816568047337278 | 46 | 24 | 81.7 | 0 | 20 | 157 | 94 | 139 | KAJ3173729.1 hypothetical protein HDU88_002818 [Geranomyces variabilis] | diamond | 138 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 28052959 | 28052959 | PRJNA168635_P_NODE_19825_length_183_cov_1.477612_g19409_i0 | PRJNA168635 | 19825 | 183 | 1.477612 | 2.70402996 | Cladochytrium replicatum | 109936 | Fungi | Fungi | 42 | 0.033 | NR | KAI8799511.1 | 109936 | g19409 | i0 | 50 | 0.819672131147541 | 50 | 21 | 82 | 1 | 34 | 183 | 870 | 915 | KAI8799511.1 tubulin folding cofactor D C terminal-domain-containing protein [Cladochytrium replicatum] | diamond | 150 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 28134130 | 28134130 | PRJNA168635_P_NODE_25385_length_169_cov_0.866667_g24969_i0 | PRJNA168635 | 25385 | 169 | 0.866667 | 1.46466723 | Caulochytriales | 2231168 | Fungi | Fungi | 46.2 | 8.35e-4 | NR | RKP02328.1 | 1555241 | g24969 | i0 | 83.3 | 0.940828402366864 | 24 | 4 | 42.6 | 0 | 169 | 98 | 715 | 738 | RKP02328.1 hypothetical protein CXG81DRAFT_25021 [Caulochytrium protostelioides] | diamond | 159 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Caulochytriales | Caulochytriaceae | Caulochytrium | Caulochytrium protostelioides | |
| 28955162 | 28955162 | PRJNA168635_P_NODE_27008_length_167_cov_1.347458_g26592_i0 | PRJNA168635 | 27008 | 167 | 1.347458 | 2.25025486 | Spizellomyces | 4815 | Fungi | Fungi | 58.2 | 4.78e-8 | NR | TPX67414.1 | 117820 | g26592 | i0 | 48.1 | 1.94011976047904 | 54 | 28 | 97 | 0 | 3 | 164 | 381 | 434 | TPX67414.1 hypothetical protein SpCBS45565_g03792 [Spizellomyces sp. 'palustris'] | diamond | 324 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces sp. 'palustris' | |
| 31116306 | 31116306 | PRJNA168635_P_NODE_18575_length_187_cov_2.478261_g18159_i0 | PRJNA168635 | 18575 | 187 | 2.478261 | 4.63434807 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 48.5 | 1.6e-4 | NR | KAH6561349.1 | 1357716 | g18159 | i0 | 52.2 | 0.737967914438503 | 46 | 21 | 73.8 | 1 | 47 | 184 | 26 | 70 | KAH6561349.1 hypothetical protein BASA62_009876 [Batrachochytrium salamandrivorans] | diamond | 138 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 31355822 | 31355822 | PRJNA168635_P_NODE_14916_length_208_cov_2.515723_g14500_i0 | PRJNA168635 | 14916 | 208 | 2.515723 | 5.23270384 | root | 1 | Root_unresolved | Root_unresolved | 55.5 | 2.28e-7 | NR | KAJ3045844.1 | 64517 | g14500 | i0 | 49.2 | 1.70192307692308 | 63 | 31 | 90.9 | 1 | 207 | 19 | 96 | 157 | KAJ3045844.1 Histone H2AX [Rhizophlyctis rosea] | diamond | 354 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 31464622 | 31464622 | PRJNA168635_P_NODE_32116_length_162_cov_0.920354_g31700_i0 | PRJNA168635 | 32116 | 162 | 0.920354 | 1.49097348 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 66.2 | 5.9e-11 | NR | KAI9343744.1 | 2211651 | g31700 | i0 | 53.8 | 0.962962962962963 | 52 | 24 | 96.3 | 0 | 2 | 157 | 133 | 184 | KAI9343744.1 U-box domain-containing protein [Zopfochytrium polystomum] | diamond | 156 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 31893366 | 31893366 | PRJNA168635_P_NODE_8637_length_286_cov_4.565401_g8222_i0 | PRJNA168635 | 8637 | 286 | 4.565401 | 13.05704686 | Fungi | 4751 | Fungi | Fungi | 48.5 | 2.51e-5 | NR | TPX52929.1 | 109895 | g8222 | i0 | 65 | 2.55944055944056 | 40 | 14 | 42 | 0 | 280 | 161 | 7 | 46 | TPX52929.1 hypothetical protein PhCBS80983_g06409 [Powellomyces hirtus] | diamond | 732 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 31907202 | 31907202 | PRJNA168635_P_NODE_29017_length_165_cov_0.896552_g28601_i0 | PRJNA168635 | 29017 | 165 | 0.896552 | 1.4793108 | Borealophlyctis nickersoniae | 2735257 | Fungi | Fungi | 42 | 0.0241 | NR | KAJ3281936.1 | 2735257 | g28601 | i0 | 39.6 | 1.94545454545455 | 53 | 28 | 96.4 | 1 | 164 | 6 | 146 | 194 | KAJ3281936.1 protein disulfide-isomerase precursor [Borealophlyctis nickersoniae] | diamond | 321 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Borealophlyctidaceae | Borealophlyctis | Borealophlyctis nickersoniae | |
| 32115015 | 32115015 | PRJNA168635_P_NODE_22498_length_175_cov_1.626984_g22082_i0 | PRJNA168635 | 22498 | 175 | 1.626984 | 2.847222 | Fungi | 4751 | Fungi | Fungi | 76.6 | 7.84e-16 | NR | KAJ3042725.1 | 64517 | g22082 | i0 | 67.2 | 10.68 | 58 | 18 | 99.4 | 1 | 174 | 1 | 13 | 69 | KAJ3042725.1 40S ribosomal protein S23 [Rhizophlyctis rosea] | diamond | 1869 | 77 | 0.994805194805195 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea |
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);;