contig_metadata
6 rows where bioproject = "PRJNA1137393" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5387884 | 5387884 | PRJNA1137393_P_NODE_26625_length_187_cov_1.137681_g26109_i0 | PRJNA1137393 | 26625 | 187 | 1.137681 | 2.12746347 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 248 | 1.9e-61 | NTclustered | gi|470423287|ref|XM_004337534.1| | 1257118 | g26109 | i0 | 90.957 | 1.00534759358289 | 188 | 11 | 99 | 3 | 3 | 187 | 1743 | 1927 | Acanthamoeba castellanii str. Neff Phosphatidylinositol-3,4,5-trisphosphate 3-phosphatase (ACA1_164180), partial mRNA | blastn | 188 | 248 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9212665 | 9212665 | PRJNA1137393_P_NODE_26768_length_186_cov_51.445255_g26252_i0 | PRJNA1137393 | 26768 | 186 | 51.445255 | 95.6881743 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 91.6 | 3.37e-14 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g26252 | i0 | 100 | 17.5645161290323 | 49 | 0 | 26 | 0 | 1 | 49 | 5161 | 5209 | 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 | 3267 | 91.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14313615 | 14313615 | PRJNA1137393_P_NODE_2452_length_619_cov_18.405263_g1965_i0 | PRJNA1137393 | 2452 | 619 | 18.405263 | 113.92857797 | Mycamoeba gemmipara | 1895019 | Discosea | other_Eukaryota | 872 | 0 | NTclustered | gi|1060138309|gb|KX687875.1| | 1895019 | g1965 | i0 | 92.135 | 65.8578352180937 | 623 | 39 | 100 | 7 | 1 | 619 | 457 | 1073 | Mycamoeba gemmipara small subunit ribosomal RNA gene, partial sequence | blastn | 40766 | 872 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Mycamoeba | Mycamoeba gemmipara | ||||
| 22708999 | 22708999 | PRJNA1137393_P_NODE_8698_length_282_cov_3.120172_g8182_i0 | PRJNA1137393 | 8698 | 282 | 3.120172 | 8.79888504 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 207 | 5.25e-49 | NTclustered | gi|1772960585|gb|MN240294.1| | 5756 | g8182 | i0 | 80.952 | 85.9964539007092 | 273 | 42 | 95 | 9 | 3 | 270 | 687 | 420 | Acanthamoeba sp. voucher OSU-07-101 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 24251 | 209 | 0.990430622009569 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. | |||
| 24510586 | 24510586 | PRJNA1137393_P_NODE_12220_length_239_cov_14.484211_g11704_i0 | PRJNA1137393 | 12220 | 239 | 14.484211 | 34.61726429 | Mycamoeba gemmipara | 1895019 | Discosea | other_Eukaryota | 414 | 2.38e-111 | NTclustered | gi|1060138309|gb|KX687875.1| | 1895019 | g11704 | i0 | 97.908 | 73 | 239 | 5 | 100 | 0 | 1 | 239 | 1204 | 1442 | Mycamoeba gemmipara small subunit ribosomal RNA gene, partial sequence | blastn | 17447 | 414 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Mycamoeba | Mycamoeba gemmipara | ||||
| 30249255 | 30249255 | PRJNA1137393_P_NODE_50492_length_167_cov_0.881356_g49976_i0 | PRJNA1137393 | 50492 | 167 | 0.881356 | 1.47186452 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.4 | 0.0015 | NR | XP_004338155.1 | 1257118 | g49976 | i0 | 44.4 | 1.58083832335329 | 45 | 25 | 80.8 | 0 | 8 | 142 | 70 | 114 | XP_004338155.1 uncharacterized protein ACA1_177500 [Acanthamoeba castellanii str. Neff] | diamond | 264 | 45.4 | 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);;