contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 793846 | 793846 | PRJNA799842_P_NODE_161421_length_246_cov_0.890173_g159848_i0 | PRJNA799842 | 161421 | 246 | 0.890173 | 2.18982558 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 180 | 9.77e-41 | NTclustered | gi|470421637|ref|XM_004337366.1| | 1257118 | g159848 | i0 | 79.92 | 1.01219512195122 | 249 | 46 | 100 | 2 | 1 | 246 | 1354 | 1107 | Acanthamoeba castellanii str. Neff zinc finger, C3HC4 type (RING finger) domain containing protein (ACA1_275750), partial mRNA | blastn | 249 | 180 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 4622707 | 4622707 | PRJNA799842_P_NODE_187904_length_241_cov_0.916667_g186331_i0 | PRJNA799842 | 187904 | 241 | 0.916667 | 2.20916747 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 209 | 1.22e-49 | NTclustered | gi|470522062|ref|XM_004353928.1| | 1257118 | g186331 | i0 | 82.573 | 1 | 241 | 38 | 99 | 4 | 1 | 239 | 398 | 160 | Acanthamoeba castellanii str. Neff pyridoxamine 5'phosphate oxidase family superfamily protein (ACA1_170220), partial mRNA | blastn | 241 | 209 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5897458 | 5897458 | PRJNA799842_P_NODE_163805_length_246_cov_0.890173_g162232_i0 | PRJNA799842 | 163805 | 246 | 0.890173 | 2.18982558 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 346 | 9.1e-91 | NTclustered | gi|470419730|ref|XM_004337175.1| | 1257118 | g162232 | i0 | 92.276 | 26.9430894308943 | 246 | 16 | 100 | 2 | 1 | 246 | 139 | 381 | Acanthamoeba castellanii str. Neff nucleoside diphosphate kinase 1, putative (ACA1_218640), partial mRNA | blastn | 6628 | 346 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8447360 | 8447360 | PRJNA799842_P_NODE_188247_length_241_cov_0.916667_g186674_i0 | PRJNA799842 | 188247 | 241 | 0.916667 | 2.20916747 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 285 | 1.96e-72 | NTclustered | gi|470448994|ref|XM_004340172.1| | 1257118 | g186674 | i0 | 88.017 | 1.00414937759336 | 242 | 27 | 100 | 2 | 1 | 241 | 2733 | 2493 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_369320), partial mRNA | blastn | 242 | 285 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22469822 | 22469822 | PRJNA799842_P_NODE_103258_length_287_cov_1.079439_g101685_i0 | PRJNA799842 | 103258 | 287 | 1.079439 | 3.09798993 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 370 | 6.45e-98 | NTclustered | gi|470375882|ref|XM_004333185.1| | 1257118 | g101685 | i0 | 90.141 | 0.989547038327526 | 284 | 28 | 99 | 0 | 4 | 287 | 662 | 379 | Acanthamoeba castellanii str. Neff ubiquitin domain containing protein (ACA1_389410), partial mRNA | blastn | 284 | 370 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 25020276 | 25020276 | PRJNA799842_P_NODE_157440_length_247_cov_0.885057_g155867_i0 | PRJNA799842 | 157440 | 247 | 0.885057 | 2.18609079 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 340 | 4.25e-89 | NTclustered | gi|470383355|ref|XM_004333895.1| | 1257118 | g155867 | i0 | 91.498 | 2 | 247 | 21 | 100 | 0 | 1 | 247 | 1318 | 1564 | Acanthamoeba castellanii str. Neff Lecithin:cholesterol acyltransferase (ACA1_399790), partial mRNA | blastn | 494 | 340 | 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);;