contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1240805" and tax_phylum = "Heterolobosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 349329 | 349329 | PRJNA1240805_P_NODE_5181_length_200_cov_12.741722_g5132_i0 | PRJNA1240805 | 5181 | 200 | 12.741722 | 25.483444 | Heterolobosea sp. | 1892890 | Heterolobosea | other_Eukaryota | 187 | 4.57e-43 | NTclustered | gi|1059971677|gb|KT892699.1| | 1892890 | g5132 | i0 | 85.876 | 54.835 | 177 | 24 | 88 | 1 | 1 | 176 | 1821 | 1645 | Heterolobosea sp. strain LPG3 18S ribosomal RNA gene, partial sequence | blastn | 10967 | 187 | 1 | Eukaryota | Discoba | Heterolobosea | Heterolobosea sp. | ||||||
| 1624146 | 1624146 | PRJNA1240805_P_NODE_7042_length_173_cov_4.153226_g6993_i0 | PRJNA1240805 | 7042 | 173 | 4.153226 | 7.18508098 | Neovahlkampfia damariscottae | 166956 | Heterolobosea | other_Eukaryota | 71.3 | 4.01e-8 | NTclustered | gi|2874368068|gb|PQ819792.1| | 166956 | g6993 | i0 | 100 | 0.445086705202312 | 38 | 0 | 22 | 0 | 120 | 157 | 229 | 192 | Neovahlkampfia damariscottae strain CCAP:1588/7 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 77 | 71.3 | 1 | Eukaryota | Discoba | Heterolobosea | Neovahlkampfiidae | Neovahlkampfia | Neovahlkampfia damariscottae | ||||
| 10553488 | 10553488 | PRJNA1240805_P_NODE_3109_length_265_cov_3.115741_g3060_i0 | PRJNA1240805 | 3109 | 265 | 3.115741 | 8.25671365 | Parafumarolamoeba stagnalis | 2872509 | Heterolobosea | other_Eukaryota | 313 | 1.01e-80 | NTclustered | gi|2086087549|gb|MZ919148.1| | 2872509 | g3060 | i0 | 93.81 | 2.37358490566038 | 210 | 10 | 78 | 3 | 59 | 265 | 657 | 866 | Parafumarolamoeba stagnalis small subunit ribosomal RNA gene, partial sequence | blastn | 629 | 313 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Parafumarolamoeba | Parafumarolamoeba stagnalis | ||||
| 10553526 | 10553526 | PRJNA1240805_P_NODE_6149_length_184_cov_7.014815_g6100_i0 | PRJNA1240805 | 6149 | 184 | 7.014815 | 12.9072596 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 106 | 1.19e-18 | NTclustered | gi|290988613|ref|XM_002676947.1| | 5762 | g6100 | i0 | 85.859 | 0.53804347826087 | 99 | 14 | 54 | 0 | 63 | 161 | 654 | 556 | Naegleria gruberi rho family small GTPase (NAEGRDRAFT_79812), mRNA | blastn | 99 | 106 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 22026220 | 22026220 | PRJNA1240805_P_NODE_5878_length_188_cov_10.244604_g5829_i0 | PRJNA1240805 | 5878 | 188 | 10.244604 | 19.25985552 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 254 | 4.12e-63 | NTclustered | gi|290989781|ref|XM_002677470.1| | 5762 | g5829 | i0 | 94.512 | 0.872340425531915 | 164 | 9 | 87 | 0 | 25 | 188 | 936 | 1099 | Naegleria gruberi DEAD/DEAH box helicase (NAEGRDRAFT_83135), mRNA | blastn | 164 | 254 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi |
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);;