contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1188114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 320134 | 320134 | PRJNA1188114_P_NODE_8561_length_181_cov_1.931818_g8509_i0 | PRJNA1188114 | 8561 | 181 | 1.931818 | 3.49659058 | Cochliopodium actinophorum | 703021 | Discosea | other_Eukaryota | 254 | 3.93e-63 | NTclustered | gi|330902866|gb|JF298259.1| | 703021 | g8509 | i0 | 92.222 | 98.5635359116022 | 180 | 12 | 99 | 2 | 1 | 179 | 960 | 782 | Cochliopodium actinophorum clone 2101 actin gene, partial cds | blastn | 17840 | 254 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium actinophorum | |||
| 4870156 | 4870156 | PRJNA1188114_P_NODE_11584_length_169_cov_1.125000_g11532_i0 | PRJNA1188114 | 11584 | 169 | 1.125 | 1.90125 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 111 | 2.3e-20 | NTclustered | gi|372290523|gb|JQ239425.1| | 5755 | g11532 | i0 | 80.667 | 9.49112426035503 | 150 | 23 | 87 | 6 | 1 | 147 | 867 | 1013 | Acanthamoeba castellanii catalase 1 mRNA, complete cds | blastn | 1604 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19445986 | 19445986 | PRJNA1188114_P_NODE_12796_length_167_cov_0.864407_g12744_i0 | PRJNA1188114 | 12796 | 167 | 0.864407 | 1.44355969 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|470452598|ref|XM_004340584.1| | 1257118 | g12744 | i0 | 94.444 | 0.215568862275449 | 36 | 2 | 22 | 0 | 1 | 36 | 1717 | 1752 | Acanthamoeba castellanii str. Neff Cofactor of BRCA1 (COBRA1) (ACA1_155500), partial mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19446039 | 19446039 | PRJNA1188114_P_NODE_19996_length_161_cov_0.910714_g19944_i0 | PRJNA1188114 | 19996 | 161 | 0.910714 | 1.46624954 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 193 | 7.55e-45 | NTclustered | gi|470504026|ref|XM_004348289.1| | 1257118 | g19944 | i0 | 89.032 | 93.5341614906832 | 155 | 17 | 96 | 0 | 4 | 158 | 946 | 1100 | Acanthamoeba castellanii str. Neff H(+)-transporting atpase family protein (ACA1_022710), partial mRNA | blastn | 15059 | 193 | 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);;