contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1188114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 15069861 | 15069861 | PRJNA1188114_P_NODE_8912_length_180_cov_1.167939_g8860_i0 | PRJNA1188114 | 8912 | 180 | 1.167939 | 2.1022902 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 200 | 5.15e-47 | NTclustered | gi|2574169421|gb|OP631025.1| | 385453 | g8860 | i0 | 87.861 | 97.1666666666667 | 173 | 18 | 95 | 3 | 6 | 176 | 979 | 808 | Polyschismium granuliferum strain MM45973 elongation factor 1-alpha (EF1a) gene, partial cds | blastn | 17490 | 200 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Polyschismium | Polyschismium granuliferum | ||
| 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 | |||
| 24546066 | 24546066 | PRJNA1188114_P_NODE_5160_length_203_cov_0.896104_g5108_i0 | PRJNA1188114 | 5160 | 203 | 0.896104 | 1.81909112 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 163 | 7.83e-36 | NTclustered | gi|330792727|ref|XM_003284391.1| | 5786 | g5108 | i0 | 82.447 | 92.7635467980296 | 188 | 31 | 92 | 2 | 1 | 187 | 822 | 1008 | Dictyostelium purpureum elongation factor 1 alpha (DICPUDRAFT_52946), mRNA | blastn | 18831 | 163 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;