contig_metadata
8 rows where bioproject = "PRJEB36940", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5159143 | 5159143 | PRJEB36940_P_NODE_4205_length_416_cov_4.463557_g4076_i0 | PRJEB36940 | 4205 | 416 | 4.463557 | 18.56839712 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 165 | 2.57e-49 | NR | KNE66505.1 | 578462 | g4076 | i0 | 65.1 | 7.31971153846154 | 126 | 43 | 90.9 | 1 | 39 | 416 | 34 | 158 | KNE66505.1 hypothetical protein AMAG_11639 [Allomyces macrogynus ATCC 38327] | diamond | 3045 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 6435009 | 6435009 | PRJEB36940_P_NODE_4206_length_416_cov_4.154519_g4077_i0 | PRJEB36940 | 4206 | 416 | 4.154519 | 17.28279904 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 187 | 7.41e-58 | NR | KAI9139274.1 | 1500003 | g4077 | i0 | 66.9 | 1.91105769230769 | 130 | 43 | 93.8 | 0 | 27 | 416 | 4 | 133 | KAI9139274.1 ribosomal L18ae/LX protein domain-containing protein [Paraphysoderma sedebokerense] | diamond | 795 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 14084957 | 14084957 | PRJEB36940_P_NODE_10012_length_277_cov_0.941176_g9883_i0 | PRJEB36940 | 10012 | 277 | 0.941176 | 2.60705752 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 73.9 | 6e-13 | NR | KAI9144030.1 | 1500003 | g9883 | i0 | 43.5 | 0.996389891696751 | 92 | 51 | 99.6 | 1 | 2 | 277 | 340 | 430 | KAI9144030.1 hypothetical protein BKA69DRAFT_902986 [Paraphysoderma sedebokerense] | diamond | 276 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 14085098 | 14085098 | PRJEB36940_P_NODE_5252_length_373_cov_0.970000_g5123_i0 | PRJEB36940 | 5252 | 373 | 0.97 | 3.6181 | root | 1 | Root_unresolved | Root_unresolved | 152 | 9.959999999999998e-42 | NR | KNE68474.1 | 578462 | g5123 | i0 | 62 | 17.5335120643432 | 121 | 45 | 97.3 | 1 | 3 | 365 | 115 | 234 | KNE68474.1 hypothetical protein AMAG_12651 [Allomyces macrogynus ATCC 38327] | diamond | 6540 | 153 | 0.993464052287582 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 17566839 | 17566839 | PRJEB36940_P_NODE_8754_length_293_cov_1.281818_g8625_i0 | PRJEB36940 | 8754 | 293 | 1.281818 | 3.75572674 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 172 | 3.54e-51 | NR | KAI9139197.1 | 1500003 | g8625 | i0 | 81.4 | 4.96587030716724 | 97 | 18 | 99.3 | 0 | 292 | 2 | 20 | 116 | KAI9139197.1 F-actin-capping protein subunit beta [Paraphysoderma sedebokerense] | diamond | 1455 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 30279943 | 30279943 | PRJEB36940_P_NODE_13632_length_248_cov_1.445714_g13503_i0 | PRJEB36940 | 13632 | 248 | 1.445714 | 3.58537072 | Blastocladiomycota | 451459 | Fungi | Fungi | 135 | 1.46e-36 | NR | KAI9159578.1 | 1313167 | g13503 | i0 | 85.4 | 11.9032258064516 | 82 | 12 | 99.2 | 0 | 246 | 1 | 183 | 264 | KAI9159578.1 hypothetical protein H9P43_008918 [Blastocladiella emersonii ATCC 22665] | diamond | 2952 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31107439 | 31107439 | PRJEB36940_P_NODE_9015_length_289_cov_2.620370_g8886_i0 | PRJEB36940 | 9015 | 289 | 2.62037 | 7.5728693 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 120 | 1.5999999999999998e-32 | NR | KNE65393.1 | 578462 | g8886 | i0 | 74 | 4.87889273356401 | 77 | 20 | 79.9 | 0 | 231 | 1 | 2 | 78 | KNE65393.1 hypothetical protein AMAG_11027 [Allomyces macrogynus ATCC 38327] | diamond | 1410 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32151379 | 32151379 | PRJEB36940_P_NODE_13938_length_247_cov_2.431034_g13809_i0 | PRJEB36940 | 13938 | 247 | 2.431034 | 6.00465398 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 50.8 | 4.11e-5 | NR | KAI9182903.1 | 1313167 | g13809 | i0 | 52.1 | 0.582995951417004 | 48 | 19 | 53.4 | 1 | 2 | 133 | 188 | 235 | KAI9182903.1 40S ribosomal protein S3 [Blastocladiella emersonii ATCC 22665] | diamond | 144 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii |
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);;