contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3179263 | 3179263 | PRJNA662254_P_NODE_57583_length_245_cov_0.895349_g56932_i0 | PRJNA662254 | 57583 | 245 | 0.895349 | 2.19360505 | Stephanopogon apogon | 238758 | Heterolobosea | other_Eukaryota | 233 | 7.36e-57 | NTclustered | gi|160337332|gb|EF455760.1| | 238758 | g56932 | i0 | 84.082 | 42.734693877551 | 245 | 35 | 99 | 3 | 1 | 243 | 861 | 1103 | Stephanopogon apogon alpha-tubulin (atub) gene, partial cds | blastn | 10470 | 233 | 1 | Eukaryota | Discoba | Heterolobosea | Stephanopogonidae | Stephanopogon | Stephanopogon apogon | ||||
| 10832439 | 10832439 | PRJNA662254_P_NODE_45509_length_251_cov_0.865169_g44858_i0 | PRJNA662254 | 45509 | 251 | 0.865169 | 2.17157419 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 202 | 2.13e-47 | NTclustered | gi|290991818|ref|XM_002678486.1| | 5762 | g44858 | i0 | 81.275 | 30.8725099601594 | 251 | 45 | 99 | 2 | 1 | 250 | 437 | 686 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_60529), partial mRNA | blastn | 7749 | 202 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 18480619 | 18480619 | PRJNA662254_P_NODE_28075_length_312_cov_3.217573_g27424_i0 | PRJNA662254 | 28075 | 312 | 3.217573 | 10.03882776 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 248 | 3.47e-61 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g27424 | i0 | 91.257 | 56.1634615384615 | 183 | 15 | 59 | 1 | 129 | 311 | 2921 | 3102 | Allovahlkampfia sp. isolate S28D2 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 | 17523 | 248 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 22305534 | 22305534 | PRJNA662254_P_NODE_31638_length_295_cov_2.067568_g30987_i0 | PRJNA662254 | 31638 | 295 | 2.067568 | 6.0993256 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 204 | 7.139999999999998e-48 | NTclustered | gi|2119449339|ref|XM_044698046.1| | 51637 | g30987 | i0 | 79.655 | 12.4135593220339 | 290 | 53 | 97 | 6 | 3 | 289 | 287 | 1 | Naegleria lovaniensis uncharacterized protein (C9374_008016), partial mRNA | blastn | 3662 | 204 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 23581001 | 23581001 | PRJNA662254_P_NODE_49679_length_249_cov_0.875000_g49028_i0 | PRJNA662254 | 49679 | 249 | 0.875 | 2.17875 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 78.7 | 3.72e-10 | NTclustered | gi|290996503|ref|XM_002680776.1| | 5762 | g49028 | i0 | 76.744 | 0.931726907630522 | 172 | 20 | 64 | 14 | 91 | 249 | 205 | 369 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_64074), partial mRNA | blastn | 232 | 78.7 | 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);;