contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 213402 | 213402 | PRJNA1108487_P_NODE_2161_length_461_cov_3.319588_g2095_i0 | PRJNA1108487 | 2161 | 461 | 3.319588 | 15.30330068 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 259 | 2.46e-64 | NTclustered | gi|470420864|ref|XM_004337293.1| | 1257118 | g2095 | i0 | 82.026 | 50.0802603036876 | 306 | 53 | 66 | 2 | 1 | 305 | 328 | 24 | Acanthamoeba castellanii str. Neff Peptidylprolyl cis-trans isomerase (ACA1_221090), partial mRNA | blastn | 23087 | 259 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5316314 | 5316314 | PRJNA1108487_P_NODE_3805_length_353_cov_1.489286_g3739_i0 | PRJNA1108487 | 3805 | 353 | 1.489286 | 5.25717958 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 58.4 | 7.17e-4 | NTclustered | gi|470469416|ref|XM_004341948.1| | 1257118 | g3739 | i0 | 83.077 | 0.18413597733711 | 65 | 9 | 18 | 2 | 216 | 279 | 884 | 821 | Acanthamoeba castellanii str. Neff MORN repeatcontaining protein (ACA1_050500), partial mRNA | blastn | 65 | 58.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6591538 | 6591538 | PRJNA1108487_P_NODE_726_length_758_cov_18.759124_g667_i0 | PRJNA1108487 | 726 | 758 | 18.759124 | 142.19415992 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 344 | 1.12e-89 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g667 | i0 | 79.31 | 61.0488126649077 | 522 | 85 | 67 | 18 | 197 | 707 | 522 | 13 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 46275 | 344 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 15516043 | 15516043 | PRJNA1108487_P_NODE_533_length_875_cov_2.316708_g480_i0 | PRJNA1108487 | 533 | 875 | 2.316708 | 20.271195 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 544 | 1.19e-149 | NTclustered | gi|470510585|ref|XM_004351497.1| | 1257118 | g480 | i0 | 78.207 | 92.2822857142857 | 881 | 170 | 99 | 16 | 6 | 875 | 493 | 1362 | Acanthamoeba castellanii str. Neff transport protein Sec61 alpha subunit, putative (ACA1_149400), partial mRNA | blastn | 80747 | 544 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24439300 | 24439300 | PRJNA1108487_P_NODE_1020_length_652_cov_2.027634_g957_i0 | PRJNA1108487 | 1020 | 652 | 2.027634 | 13.22017368 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 355 | 4.41e-93 | NTclustered | gi|470512227|ref|XM_004352398.1| | 1257118 | g957 | i0 | 78.061 | 75.0061349693252 | 588 | 112 | 89 | 13 | 17 | 597 | 31 | 608 | Acanthamoeba castellanii str. Neff succinyl coenzyme A synthetase alpha subunit (ACA1_359750), partial mRNA | blastn | 48904 | 355 | 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);;