contig_metadata
8 rows where bioproject = "PRJNA680334" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 649350 | 649350 | PRJNA680334_S_NODE_23161_length_243_cov_4.019048_g22675_i0 | PRJNA680334 | 23161 | 243 | 4.019048 | 9.76628664 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 62.1 | 3.64e-5 | NTclustered | gi|66827724|ref|XM_642125.1| | 352472 | g22675 | i0 | 97.222 | 4.23868312757202 | 36 | 1 | 15 | 0 | 192 | 227 | 203 | 168 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0268308) mRNA, complete cds | blastn | 1030 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 5753318 | 5753318 | PRJNA680334_S_NODE_39285_length_206_cov_18.317919_g38799_i0 | PRJNA680334 | 39285 | 206 | 18.317919 | 37.73491314 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 287 | 4.53e-73 | NTclustered | gi|262262901|gb|FJ766444.1| | 472931 | g38799 | i0 | 92.893 | 44.495145631068 | 197 | 14 | 96 | 0 | 1 | 197 | 1241 | 1437 | Protostelium mycophagum strain BRNFDF05-11A-3 small subunit ribosomal RNA gene, partial sequence | blastn | 9166 | 287 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 26923824 | 26923824 | PRJNA680334_S_NODE_91882_length_158_cov_1.672000_g91396_i0 | PRJNA680334 | 91882 | 158 | 1.672 | 2.64176 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 63.9 | 3.7e-10 | NR | PRP78348.1 | 1890364 | g91396 | i0 | 56.9 | 1.93670886075949 | 51 | 21 | 96.8 | 1 | 5 | 157 | 301 | 350 | PRP78348.1 hypothetical protein PROFUN_11388 [Planoprotostelium fungivorum] | diamond | 306 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27492812 | 27492812 | PRJNA680334_S_NODE_81163_length_164_cov_3.290076_g80677_i0 | PRJNA680334 | 81163 | 164 | 3.290076 | 5.39572464 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 60.8 | 5.06e-9 | NR | PRP81440.1 | 1890364 | g80677 | i0 | 60 | 0.731707317073171 | 40 | 16 | 73.2 | 0 | 164 | 45 | 276 | 315 | PRP81440.1 hypothetical protein PROFUN_10970 [Planoprotostelium fungivorum] | diamond | 120 | 60.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28092623 | 28092623 | PRJNA680334_S_NODE_92705_length_157_cov_4.032258_g92219_i0 | PRJNA680334 | 92705 | 157 | 4.032258 | 6.33064506 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 48.9 | 7.74e-5 | NR | PRP76068.1 | 1890364 | g92219 | i0 | 57.4 | 0.898089171974522 | 47 | 9 | 74.5 | 2 | 129 | 13 | 390 | 433 | PRP76068.1 hypothetical protein PROFUN_01784 [Planoprotostelium fungivorum] | diamond | 141 | 48.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28250362 | 28250362 | PRJNA680334_S_NODE_36306_length_212_cov_2.262570_g35820_i0 | PRJNA680334 | 36306 | 212 | 2.26257 | 4.7966484 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 92 | 7.72e-20 | NR | KAF2070540.1 | 133409 | g35820 | i0 | 57.6 | 0.933962264150943 | 66 | 28 | 93.4 | 0 | 12 | 209 | 293 | 358 | KAF2070540.1 hypothetical protein CYY_008145 [Polysphondylium violaceum] | diamond | 198 | 92 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 29860792 | 29860792 | PRJNA680334_S_NODE_29771_length_225_cov_4.994792_g29285_i0 | PRJNA680334 | 29771 | 225 | 4.994792 | 11.238282 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 48.9 | 1.83e-4 | NR | XP_004337111.1 | 1257118 | g29285 | i0 | 42.9 | 2.21333333333333 | 56 | 28 | 69.3 | 2 | 198 | 43 | 224 | 279 | XP_004337111.1 uncharacterized protein ACA1_215700 [Acanthamoeba castellanii str. Neff] | diamond | 498 | 48.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31061687 | 31061687 | PRJNA680334_S_NODE_79775_length_165_cov_3.053030_g79289_i0 | PRJNA680334 | 79775 | 165 | 3.05303 | 5.0374995 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 44.7 | 0.00262 | NR | PRP88923.1 | 1890364 | g79289 | i0 | 52.5 | 0.727272727272727 | 40 | 19 | 72.7 | 0 | 2 | 121 | 262 | 301 | PRP88923.1 pantothenate synthetase [Planoprotostelium fungivorum] | diamond | 120 | 44.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum |
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);;