contig_metadata
8 rows where bioproject = "PRJNA416866", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2970362 | 2970362 | PRJNA416866_P_NODE_5963_length_267_cov_1.276699_g5819_i0 | PRJNA416866 | 5963 | 267 | 1.276699 | 3.40878633 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 176 | 1.4e-51 | NR | AAP88974.1 | 5775 | g5819 | i0 | 89.9 | 1 | 89 | 9 | 100 | 0 | 267 | 1 | 93 | 181 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 267 | 176 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 4246694 | 4246694 | PRJNA416866_P_NODE_1524_length_564_cov_1.882704_g1384_i0 | PRJNA416866 | 1524 | 564 | 1.882704 | 10.61845056 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 258 | 4.21e-85 | NR | AFX73058.1 | 160823 | g1384 | i0 | 82.5 | 1.70212765957447 | 160 | 28 | 85.1 | 0 | 48 | 527 | 1 | 160 | AFX73058.1 14-3-3 protein, partial [Chaos carolinense] | diamond | 960 | 258 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 6186815 | 6186815 | PRJNA416866_P_NODE_8345_length_223_cov_1.975309_g8201_i0 | PRJNA416866 | 8345 | 223 | 1.975309 | 4.40493907 | Chaos | 160821 | Tubulinea | other_Eukaryota | 353 | 4.849999999999999e-93 | NTclustered | gi|17902587|emb|AJ314606.1| | 160822 | g8201 | i0 | 95.872 | 96.7443946188341 | 218 | 9 | 98 | 0 | 6 | 223 | 1132 | 1349 | Chaos nobile partial 16S rRNA gene, strain CCAP 1511/2 | blastn | 21574 | 353 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos nobile | ||
| 10623527 | 10623527 | PRJNA416866_P_NODE_309_length_1277_cov_2.953125_g242_i0 | PRJNA416866 | 309 | 1277 | 2.953125 | 37.71140625 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1044 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g242 | i0 | 81.62 | 2.85356303837118 | 1284 | 215 | 99 | 19 | 9 | 1277 | 1293 | 16 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 3644 | 1044 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 14448543 | 14448543 | PRJNA416866_P_NODE_432_length_1120_cov_2.827195_g242_i1 | PRJNA416866 | 432 | 1120 | 2.827195 | 31.664584 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 885 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g242 | i1 | 81.041 | 2.97678571428571 | 1134 | 196 | 100 | 17 | 1 | 1120 | 16 | 1144 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 3334 | 885 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 14448551 | 14448551 | PRJNA416866_P_NODE_8212_length_225_cov_1.560976_g8068_i0 | PRJNA416866 | 8212 | 225 | 1.560976 | 3.512196 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 202 | 1.88e-47 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g8068 | i0 | 85.354 | 10.2044444444444 | 198 | 26 | 88 | 3 | 1 | 198 | 301 | 107 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 2296 | 202 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 18935216 | 18935216 | PRJNA416866_P_NODE_2955_length_393_cov_1.418675_g2812_i0 | PRJNA416866 | 2955 | 393 | 1.418675 | 5.57539275 | Chaos | 160821 | Tubulinea | other_Eukaryota | 207 | 7.58e-49 | NTclustered | gi|17902587|emb|AJ314606.1| | 160822 | g2812 | i0 | 87.778 | 17.2315521628499 | 180 | 18 | 58 | 4 | 217 | 393 | 942 | 1120 | Chaos nobile partial 16S rRNA gene, strain CCAP 1511/2 | blastn | 6772 | 207 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos nobile | ||
| 20821369 | 20821369 | PRJNA416866_P_NODE_11057_length_204_cov_0.895105_g10913_i0 | PRJNA416866 | 11057 | 204 | 0.895105 | 1.8260142 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 235 | 1.65e-57 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g10913 | i0 | 89.785 | 80.0343137254902 | 186 | 16 | 90 | 3 | 5 | 188 | 1327 | 1511 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16327 | 235 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae |
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);;