contig_metadata
11 rows where bioproject = "PRJNA474911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1722386 | 1722386 | PRJNA474911_P_NODE_3822_length_302_cov_1.327801_g3695_i0 | PRJNA474911 | 3822 | 302 | 1.327801 | 4.00995902 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|1160559030|ref|XM_020577619.1| | 670386 | g3695 | i0 | 100 | 0.0927152317880795 | 28 | 0 | 9 | 0 | 236 | 263 | 514 | 541 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 1722399 | 1722399 | PRJNA474911_P_NODE_8062_length_202_cov_1.361702_g7935_i0 | PRJNA474911 | 8062 | 202 | 1.361702 | 2.75063804 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 368 | 1.54e-97 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g7935 | i0 | 100 | 16.6435643564356 | 199 | 0 | 99 | 0 | 1 | 199 | 6756 | 6954 | Acanthamoeba castellanii 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 | 3362 | 368 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5551286 | 5551286 | PRJNA474911_P_NODE_6405_length_220_cov_1.207547_g6278_i0 | PRJNA474911 | 6405 | 220 | 1.207547 | 2.6566034 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 261 | 2.97e-65 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g6278 | i0 | 89.048 | 4.65 | 210 | 23 | 95 | 0 | 1 | 210 | 432 | 223 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 1023 | 261 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 8100720 | 8100720 | PRJNA474911_P_NODE_7607_length_205_cov_0.888889_g7480_i0 | PRJNA474911 | 7607 | 205 | 0.888889 | 1.82222245 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 303 | 4.48e-78 | NTclustered | gi|470416173|ref|XM_004336808.1| | 1257118 | g7480 | i0 | 93.659 | 1 | 205 | 10 | 100 | 1 | 1 | 205 | 307 | 106 | Acanthamoeba castellanii str. Neff HMGL family domain containing protein (ACA1_130190), partial mRNA | blastn | 205 | 303 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8100721 | 8100721 | PRJNA474911_P_NODE_7847_length_204_cov_0.895105_g7720_i0 | PRJNA474911 | 7847 | 204 | 0.895105 | 1.8260142 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 235 | 1.65e-57 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g7720 | 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 | ||
| 14476199 | 14476199 | PRJNA474911_P_NODE_8012_length_203_cov_0.901408_g7885_i0 | PRJNA474911 | 8012 | 203 | 0.901408 | 1.82985824 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 161 | 2.82e-35 | NTclustered | gi|470457305|ref|XM_004341077.1| | 1257118 | g7885 | i0 | 93.578 | 0.812807881773399 | 109 | 6 | 81 | 1 | 96 | 203 | 296 | 404 | Acanthamoeba castellanii str. Neff mitochondrial carnitineacylcarnitine carrier protein (ACA1_236290), partial mRNA | blastn | 165 | 161 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 17024897 | 17024897 | PRJNA474911_P_NODE_3454_length_322_cov_1.164751_g3328_i0 | PRJNA474911 | 3454 | 322 | 1.164751 | 3.75049822 | Rhizomastix varia | 1745347 | Evosea | other_Eukaryota | 327 | 4.48e-85 | NTclustered | gi|944556463|gb|KP343611.1| | 1745347 | g3328 | i0 | 85.22 | 99.3478260869565 | 318 | 47 | 99 | 0 | 5 | 322 | 696 | 379 | Rhizomastix varia strain FBAN clone 2 actin gene, partial cds | blastn | 31990 | 327 | 1 | Eukaryota | Amoebozoa | Evosea | Rhizomastix | Rhizomastix varia | |||||
| 17024899 | 17024899 | PRJNA474911_P_NODE_5574_length_239_cov_1.078652_g5447_i0 | PRJNA474911 | 5574 | 239 | 1.078652 | 2.57797828 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 315 | 2.48e-81 | NTclustered | gi|1042160913|dbj|LC102263.1| | 931554 | g5447 | i0 | 90.377 | 91.6485355648536 | 239 | 23 | 100 | 0 | 1 | 239 | 449 | 211 | Copromyxa protea gene for actin, partial cds, strain: LUM_cl4 | blastn | 21904 | 315 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 19573414 | 19573414 | PRJNA474911_P_NODE_7296_length_207_cov_0.876712_g7169_i0 | PRJNA474911 | 7296 | 207 | 0.876712 | 1.81479384 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 377 | 2.63e-100 | NTclustered | gi|470450828|ref|XM_004340382.1| | 1257118 | g7169 | i0 | 99.517 | 76.43961352657 | 207 | 1 | 100 | 0 | 1 | 207 | 943 | 737 | Acanthamoeba castellanii str. Neff elongation factor 1alpha, somatic form, putative (ACA1_138040), partial mRNA | blastn | 15823 | 377 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24048995 | 24048995 | PRJNA474911_P_NODE_7359_length_207_cov_0.876712_g7232_i0 | PRJNA474911 | 7359 | 207 | 0.876712 | 1.81479384 | root | 1 | Root_unresolved | Root_unresolved | 381 | 2.0299999999999995e-101 | NTclustered | gi|909719646|gb|KT185626.1| | 5755 | g7232 | i0 | 100 | 57.6183574879227 | 206 | 0 | 99 | 0 | 2 | 207 | 3749 | 3954 | Acanthamoeba castellanii 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11927 | 381 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24673737 | 24673737 | PRJNA474911_P_NODE_5220_length_249_cov_2.037234_g5093_i0 | PRJNA474911 | 5220 | 249 | 2.037234 | 5.07271266 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 401 | 1.9399999999999993e-107 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g5093 | i0 | 95.984 | 26.5381526104418 | 249 | 6 | 100 | 2 | 1 | 249 | 7799 | 7555 | Acanthamoeba castellanii 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 | 6608 | 401 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;