contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA640350" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3707300 | 3707300 | PRJNA640350_P_NODE_22243_length_205_cov_4.551136_g22082_i0 | PRJNA640350 | 22243 | 205 | 4.551136 | 9.3298288 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 379 | 7.229999999999999e-101 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g22082 | i0 | 100 | 99.7170731707317 | 205 | 0 | 100 | 0 | 1 | 205 | 1858 | 1654 | Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 20442 | 379 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 4983836 | 4983836 | PRJNA640350_P_NODE_18104_length_246_cov_4.165899_g17943_i0 | PRJNA640350 | 18104 | 246 | 4.165899 | 10.24811154 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 455 | 1.4500000000000002e-123 | NTclustered | gi|2351569|gb|U80057.1|NAU80057 | 5764 | g17943 | i0 | 100 | 100 | 246 | 0 | 100 | 0 | 1 | 246 | 1017 | 1262 | Naegleria andersoni 18S ribosomal RNA gene, partial sequence | blastn | 24600 | 455 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria andersoni | ||||
| 10814678 | 10814678 | PRJNA640350_P_NODE_28809_length_176_cov_1.564626_g28648_i0 | PRJNA640350 | 28809 | 176 | 1.564626 | 2.75374176 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 169 | 1.4099999999999998e-37 | NTclustered | gi|291001644|ref|XM_002683343.1| | 5762 | g28648 | i0 | 84.571 | 3.55113636363636 | 175 | 21 | 98 | 6 | 1 | 172 | 646 | 817 | Naegleria gruberi ribosomal protein S5 (NAEGRDRAFT_55960), mRNA | blastn | 625 | 169 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 11359006 | 11359006 | PRJNA640350_P_NODE_16789_length_271_cov_8.049587_g16628_i0 | PRJNA640350 | 16789 | 271 | 8.049587 | 21.81438077 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 435 | 2.11e-117 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g16628 | i0 | 95.572 | 10.3874538745387 | 271 | 12 | 100 | 0 | 1 | 271 | 5451 | 5721 | Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 2815 | 435 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 15913279 | 15913279 | PRJNA640350_P_NODE_22133_length_206_cov_2.887006_g21972_i0 | PRJNA640350 | 22133 | 206 | 2.887006 | 5.94723236 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 300 | 5.82e-77 | NTclustered | gi|290988433|ref|XM_002676880.1| | 5762 | g21972 | i0 | 95.263 | 25.6116504854369 | 190 | 7 | 92 | 2 | 18 | 206 | 1374 | 1186 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82621), mRNA | blastn | 5276 | 300 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 15913306 | 15913306 | PRJNA640350_P_NODE_24973_length_190_cov_3.173913_g24812_i0 | PRJNA640350 | 24973 | 190 | 3.173913 | 6.0304347 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 324 | 3.13e-84 | NTclustered | gi|290983673|ref|XM_002674507.1| | 5762 | g24812 | i0 | 97.368 | 23.3210526315789 | 190 | 5 | 100 | 0 | 1 | 190 | 2293 | 2104 | Naegleria gruberi translation elongation factor 2 (NAEGRDRAFT_56254), mRNA | blastn | 4431 | 324 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 21012803 | 21012803 | PRJNA640350_P_NODE_22157_length_206_cov_2.463277_g21996_i0 | PRJNA640350 | 22157 | 206 | 2.463277 | 5.07435062 | Naegleria andersoni | 5764 | Heterolobosea | other_Eukaryota | 359 | 9.47e-95 | NTclustered | gi|4321709|gb|AF058283.1|AF058283 | 5764 | g21996 | i0 | 98.058 | 88.0145631067961 | 206 | 4 | 100 | 0 | 1 | 206 | 899 | 694 | Naegleria andersoni elongation factor 1 alpha (tef1) gene, partial cds | blastn | 18131 | 359 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria andersoni | ||||
| 22287430 | 22287430 | PRJNA640350_P_NODE_16998_length_266_cov_4.907173_g16837_i0 | PRJNA640350 | 16998 | 266 | 4.907173 | 13.05308018 | Naegleria jamiesoni | 36335 | Heterolobosea | other_Eukaryota | 377 | 3.53e-100 | NTclustered | gi|2351573|gb|U80061.1|NJU80061 | 36335 | g16837 | i0 | 92.481 | 88.5112781954887 | 266 | 17 | 99 | 3 | 1 | 264 | 1009 | 745 | Naegleria jamiesoni 18S ribosomal RNA gene, partial sequence | blastn | 23544 | 377 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria jamiesoni |
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);;