contig_metadata
4 rows where bioproject = "PRJNA526367", tax_clade = "Amoebozoa" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10699897 | 10699897 | PRJNA526367_P_NODE_35509_length_192_cov_3.202797_g35299_i0 | PRJNA526367 | 35509 | 192 | 3.202797 | 6.14937024 | Entamoeba gingivalis | 38877 | Evosea | other_Eukaryota | 326 | 8.82e-85 | NTclustered | gi|2781670152|dbj|LC832224.1| | 38877 | g35299 | i0 | 98.396 | 72.0885416666667 | 187 | 0 | 96 | 2 | 1 | 185 | 697 | 512 | Entamoeba gingivalis ST1-1_human_Ishikawa_H118_2017 gene for 18S ribosomal RNA, partial sequence | blastn | 13841 | 326 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba gingivalis | |||
| 14525142 | 14525142 | PRJNA526367_P_NODE_55132_length_163_cov_1.333333_g54922_i0 | PRJNA526367 | 55132 | 163 | 1.333333 | 2.17333279 | Echinostelium minutum | 300235 | Evosea | other_Eukaryota | 147 | 6.0599999999999996e-31 | NTclustered | gi|381139237|emb|HE655044.1| | 300235 | g54922 | i0 | 90.265 | 62.9570552147239 | 113 | 9 | 69 | 2 | 7 | 118 | 817 | 706 | Echinostelium minutum partial 28S rRNA gene, strain ATCC 22345 | blastn | 10262 | 147 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliales | Echinosteliidae | Echinostelium | Echinostelium minutum | ||
| 18347905 | 18347905 | PRJNA526367_P_NODE_65355_length_151_cov_6.401961_g65145_i0 | PRJNA526367 | 65355 | 151 | 6.401961 | 9.66696111 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 259 | 6.76e-65 | NTclustered | gi|381139266|emb|HE655083.1| | 159720 | g65145 | i0 | 99.301 | 63.2649006622517 | 143 | 1 | 95 | 0 | 2 | 144 | 1235 | 1093 | Fuligo septica partial 28S rRNA gene, isolate Mx-K28 | blastn | 9553 | 259 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 27772578 | 27772578 | PRJNA526367_P_NODE_44084_length_176_cov_3.204724_g43874_i0 | PRJNA526367 | 44084 | 176 | 3.204724 | 5.64031424 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 61.6 | 3.08e-9 | NR | XP_012748522.1 | 1410327 | g43874 | i0 | 60.7 | 2.88068181818182 | 56 | 22 | 95.5 | 0 | 6 | 173 | 228 | 283 | XP_012748522.1 hypothetical protein SAMD00019534_116590, partial [Acytostelium subglobosum LB1] | diamond | 507 | 61.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;