contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA811237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2084463 | 2084463 | PRJNA811237_S_NODE_14462_length_212_cov_2.503067_g14222_i0 | PRJNA811237 | 14462 | 212 | 2.503067 | 5.30650204 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 342 | 9.879999999999999e-90 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g14222 | i0 | 95.775 | 3.00471698113208 | 213 | 8 | 100 | 1 | 1 | 212 | 3704 | 3916 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 637 | 342 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 8461844 | 8461844 | PRJNA811237_S_NODE_26847_length_168_cov_1.705882_g26607_i0 | PRJNA811237 | 26847 | 168 | 1.705882 | 2.86588176 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 159 | 8.08e-35 | NTclustered | gi|2124403222|ref|XM_044685950.1| | 51637 | g26607 | i0 | 85.526 | 5.31547619047619 | 152 | 22 | 90 | 0 | 17 | 168 | 650 | 499 | Naegleria lovaniensis uncharacterized protein (C9374_010409), partial mRNA | blastn | 893 | 159 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 9736815 | 9736815 | PRJNA811237_S_NODE_10728_length_236_cov_2.502674_g10488_i0 | PRJNA811237 | 10728 | 236 | 2.502674 | 5.90631064 | Percolomonas cosmopolitus | 63605 | Heterolobosea | other_Eukaryota | 289 | 1.48e-73 | NTclustered | gi|33089879|gb|AY283748.1| | 63605 | g10488 | i0 | 89.474 | 99.2881355932203 | 228 | 24 | 97 | 0 | 9 | 236 | 493 | 266 | Percolomonas cosmopolitus isolate Gym67_1 actin gene, partial cds | blastn | 23432 | 289 | 1 | Eukaryota | Discoba | Heterolobosea | Percolomonadidae | Percolomonas | Percolomonas cosmopolitus | ||||
| 11012734 | 11012734 | PRJNA811237_S_NODE_36409_length_155_cov_2.613208_g36169_i0 | PRJNA811237 | 36409 | 155 | 2.613208 | 4.0504724 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 73.1 | 9.78e-9 | NTclustered | gi|2119438032|ref|XM_044694250.1| | 51637 | g36169 | i0 | 92.157 | 1.23225806451613 | 51 | 4 | 33 | 0 | 68 | 118 | 480 | 430 | Naegleria lovaniensis uncharacterized protein (C9374_004594), partial mRNA | blastn | 191 | 73.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 17387171 | 17387171 | PRJNA811237_S_NODE_33654_length_162_cov_1.327434_g33414_i0 | PRJNA811237 | 33654 | 162 | 1.327434 | 2.15044308 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 128 | 2.18e-25 | NTclustered | gi|2119420720|ref|XM_044689986.1| | 51637 | g33414 | i0 | 80.864 | 95.4074074074074 | 162 | 31 | 100 | 0 | 1 | 162 | 899 | 1060 | Naegleria lovaniensis uncharacterized protein (C9374_014042), partial mRNA | blastn | 15456 | 128 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 19075233 | 19075233 | PRJNA811237_S_NODE_31335_length_164_cov_0.886957_g31095_i0 | PRJNA811237 | 31335 | 164 | 0.886957 | 1.45460948 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 302 | 1.23e-77 | NTclustered | gi|89148133|gb|DQ388519.1| | 373143 | g31095 | i0 | 100 | 25.6524390243902 | 163 | 0 | 99 | 0 | 2 | 164 | 306 | 468 | Heterolobosea sp. BA 16S small subunit ribosomal RNA gene, partial sequence; and His-Cys box homing endonuclease gene, complete cds | blastn | 4207 | 303 | 0.996699669966997 | Eukaryota | Discoba | Heterolobosea | Heterolobosea sp. BA | ||||||
| 19935411 | 19935411 | PRJNA811237_S_NODE_17356_length_199_cov_2.313333_g17116_i0 | PRJNA811237 | 17356 | 199 | 2.313333 | 4.60353267 | Acrasis rosea | 43695 | Heterolobosea | other_Eukaryota | 204 | 4.51e-48 | NTclustered | gi|12083876|gb|AF190771.1|AF190771 | 43695 | g17116 | i0 | 86.813 | 69.5628140703518 | 182 | 24 | 91 | 0 | 1 | 182 | 579 | 760 | Acrasis rosea elongation factor 1 alpha (tef1) gene, partial cds | blastn | 13843 | 204 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis rosea | ||||
| 23761383 | 23761383 | PRJNA811237_S_NODE_30499_length_165_cov_0.879310_g30259_i0 | PRJNA811237 | 30499 | 165 | 0.87931 | 1.4508615 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 300 | 4.46e-77 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g30259 | i0 | 99.394 | 53.9939393939394 | 165 | 1 | 100 | 0 | 1 | 165 | 2662 | 2826 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 8909 | 300 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. |
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);;