contig_metadata
11 rows where bioproject = "PRJNA851399" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 839602 | 839602 | PRJNA851399_P_NODE_9521_length_259_cov_4.257143_g9068_i0 | PRJNA851399 | 9521 | 259 | 4.257143 | 11.02600037 | Physarum vernum | 742165 | Evosea | other_Eukaryota | 460 | 3.3099999999999997e-125 | NTclustered | gi|1864351418|gb|MT704253.1| | 742165 | g9068 | i0 | 98.837 | 68.8185328185328 | 258 | 3 | 99 | 0 | 2 | 259 | 1 | 258 | Physarum vernum voucher sc30823 small subunit ribosomal RNA gene, partial sequence | blastn | 17824 | 460 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum vernum | ||
| 2114731 | 2114731 | PRJNA851399_P_NODE_24602_length_168_cov_1.277311_g24149_i0 | PRJNA851399 | 24602 | 168 | 1.277311 | 2.14588248 | Badhamia macrocarpa | 385456 | Evosea | other_Eukaryota | 270 | 3.5799999999999998e-68 | NTclustered | gi|2317681365|gb|OP650732.1| | 385456 | g24149 | i0 | 95.808 | 68.3630952380952 | 167 | 7 | 99 | 0 | 2 | 168 | 756 | 590 | Badhamia macrocarpa strain MA-Fungi 90864 small subunit ribosomal RNA gene, partial sequence | blastn | 11485 | 270 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Badhamia | Badhamia macrocarpa | ||
| 5942407 | 5942407 | PRJNA851399_P_NODE_17045_length_185_cov_3.191176_g16592_i0 | PRJNA851399 | 17045 | 185 | 3.191176 | 5.9036756 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 207 | 3.19e-49 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g16592 | i0 | 91.391 | 61.572972972973 | 151 | 11 | 82 | 2 | 35 | 185 | 5361 | 5213 | Mucilago crustacea 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11391 | 207 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 10162342 | 10162342 | PRJNA851399_P_NODE_12968_length_211_cov_0.938272_g12515_i0 | PRJNA851399 | 12968 | 211 | 0.938272 | 1.97975392 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 390 | 3.459999999999999e-104 | NTclustered | gi|1996291000|gb|MW689486.1| | 5756 | g12515 | i0 | 100 | 100 | 211 | 0 | 100 | 0 | 1 | 211 | 27 | 237 | Acanthamoeba sp. isolate IWS79 small subunit ribosomal RNA gene, partial sequence | blastn | 21100 | 390 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. | |||
| 16142360 | 16142360 | PRJNA851399_P_NODE_6433_length_370_cov_1.429907_g5981_i0 | PRJNA851399 | 6433 | 370 | 1.429907 | 5.2906559 | Physarum rigidum | 385469 | Evosea | other_Eukaryota | 348 | 4.0100000000000003e-91 | NTclustered | gi|2738858413|gb|PP860885.1| | 385469 | g5981 | i0 | 84.367 | 80.5621621621622 | 371 | 41 | 99 | 14 | 2 | 369 | 84 | 440 | Physarum rigidum strain Ri6 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 29808 | 348 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum rigidum | ||
| 19085437 | 19085437 | PRJNA851399_P_NODE_2155_length_791_cov_13.128032_g1830_i0 | PRJNA851399 | 2155 | 791 | 13.128032 | 103.84273312 | Physariida | 5789 | Evosea | other_Eukaryota | 632 | 2.229999999999999e-176 | NTclustered | gi|90968164|emb|AM231296.1| | 290853 | g1830 | i0 | 90.121 | 66.9494310998736 | 496 | 36 | 91 | 11 | 304 | 791 | 1797 | 1307 | Lepidoderma carestianum partial 18S rRNA gene, isolate K18 | blastn | 52957 | 632 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Lepidoderma | Lepidoderma carestianum | ||
| 23791863 | 23791863 | PRJNA851399_P_NODE_79_length_2821_cov_10.611833_g52_i0 | PRJNA851399 | 79 | 2821 | 10.611833 | 299.35980893 | Amoebozoa sp. | 1892891 | Root_unresolved | Root_unresolved | 1768 | 0 | NTclustered | gi|2651357787|gb|PP174302.1| | 1892891 | g52 | i0 | 85.731 | 24.6178660049628 | 1731 | 181 | 60 | 49 | 1 | 1705 | 3217 | 4907 | Amoebozoa sp. isolate 2M small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 69447 | 1768 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. | |||||||
| 23791869 | 23791869 | PRJNA851399_P_NODE_8799_length_276_cov_1.568282_g8346_i0 | PRJNA851399 | 8799 | 276 | 1.568282 | 4.32845832 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 237 | 6.53e-58 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g8346 | i0 | 82.836 | 6.8731884057971 | 268 | 43 | 97 | 3 | 1 | 267 | 7072 | 6807 | Mucilago crustacea 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1897 | 237 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 24185587 | 24185587 | PRJNA851399_P_NODE_4639_length_475_cov_7.748826_g4193_i0 | PRJNA851399 | 4639 | 475 | 7.748826 | 36.8069235 | Didymium | 5792 | Evosea | other_Eukaryota | 606 | 7.869999999999996e-169 | NTclustered | gi|34979685|gb|AY321111.1| | 246608 | g4193 | i0 | 89.813 | 95.7642105263158 | 481 | 37 | 100 | 10 | 1 | 475 | 1249 | 1723 | Didymium sp. E2/8 small subunit ribosomal RNA gene, partial sequence | blastn | 45488 | 606 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium sp. E2/8 | ||
| 29139515 | 29139515 | PRJNA851399_P_NODE_37529_length_162_cov_0.902655_g37076_i0 | PRJNA851399 | 37529 | 162 | 0.902655 | 1.4623011 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 47.8 | 2.1e-4 | NR | XP_004335984.1 | 1257118 | g37076 | i0 | 53.7 | 0.759259259259259 | 41 | 19 | 75.9 | 0 | 125 | 3 | 923 | 963 | XP_004335984.1 ubiquitin domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 123 | 47.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31382310 | 31382310 | PRJNA851399_P_NODE_28256_length_166_cov_0.871795_g27803_i0 | PRJNA851399 | 28256 | 166 | 0.871795 | 1.4471797 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 65.1 | 1.73e-10 | NR | XP_012757426.1 | 1410327 | g27803 | i0 | 41.8 | 3.92168674698795 | 55 | 32 | 99.4 | 0 | 166 | 2 | 214 | 268 | XP_012757426.1 hypothetical protein SAMD00019534_026740 [Acytostelium subglobosum LB1] | diamond | 651 | 65.1 | 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);;