contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1105232" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2763280 | 2763280 | PRJNA1105232_S_NODE_16743_length_164_cov_0.904348_g16527_i0 | PRJNA1105232 | 16743 | 164 | 0.904348 | 1.48313072 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 167 | 4.689999999999999e-37 | NTclustered | gi|290986471|ref|XM_002675902.1| | 5762 | g16527 | i0 | 86.275 | 12.4939024390244 | 153 | 21 | 93 | 0 | 6 | 158 | 835 | 987 | Naegleria gruberi 26S proteosome subunit P45 (NAEGRDRAFT_37071), partial mRNA | blastn | 2049 | 167 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 4039361 | 4039361 | PRJNA1105232_S_NODE_2284_length_358_cov_4.207120_g2068_i0 | PRJNA1105232 | 2284 | 358 | 4.20712 | 15.0614896 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 150 | 1.1699999999999998e-31 | NTclustered | gi|290987009|ref|XM_002676170.1| | 5762 | g2068 | i0 | 77.174 | 5.32402234636872 | 276 | 52 | 76 | 9 | 86 | 357 | 1490 | 1222 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_68607), partial mRNA | blastn | 1906 | 150 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 6590672 | 6590672 | PRJNA1105232_S_NODE_18606_length_153_cov_2.538462_g18390_i0 | PRJNA1105232 | 18606 | 153 | 2.538462 | 3.88384686 | soil amoeba AND9 | 328341 | Heterolobosea | other_Eukaryota | 239 | 8.96e-59 | NTclustered | gi|65306218|gb|AY965861.1| | 328341 | g18390 | i0 | 94.771 | 99.9673202614379 | 153 | 8 | 100 | 0 | 1 | 153 | 1490 | 1338 | Soil amoeba AND9 18S ribosomal RNA gene, partial sequence | blastn | 15295 | 239 | 1 | Eukaryota | Discoba | Heterolobosea | soil amoeba AND9 | ||||||
| 7865290 | 7865290 | PRJNA1105232_S_NODE_13487_length_178_cov_1.193798_g13271_i0 | PRJNA1105232 | 13487 | 178 | 1.193798 | 2.12496044 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 108 | 3.17e-19 | NTclustered | gi|2119442003|ref|XM_044695421.1| | 51637 | g13271 | i0 | 79.355 | 0.870786516853933 | 155 | 30 | 87 | 2 | 3 | 156 | 956 | 1109 | Naegleria lovaniensis uncharacterized protein (C9374_005648), partial mRNA | blastn | 155 | 108 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 10416003 | 10416003 | PRJNA1105232_S_NODE_1509_length_417_cov_14.858696_g1294_i0 | PRJNA1105232 | 1509 | 417 | 14.858696 | 61.96076232 | Neovahlkampfia nana | 1869201 | Heterolobosea | other_Eukaryota | 388 | 2.6899999999999996e-103 | NTclustered | gi|1042160970|dbj|LC126929.1| | 1869201 | g1294 | i0 | 87.464 | 80.8609112709832 | 343 | 35 | 81 | 6 | 1 | 336 | 1746 | 2087 | Neovahlkampfia nana gene for 18S ribosomal RNA, partial sequence, isolate: I_13 | blastn | 33719 | 388 | 1 | Eukaryota | Discoba | Heterolobosea | Neovahlkampfiidae | Neovahlkampfia | Neovahlkampfia nana | ||||
| 10416032 | 10416032 | PRJNA1105232_S_NODE_3569_length_303_cov_4.944882_g3353_i0 | PRJNA1105232 | 3569 | 303 | 4.944882 | 14.98299246 | Stephanopogon apogon | 238758 | Heterolobosea | other_Eukaryota | 185 | 2.6699999999999994e-42 | NTclustered | gi|302026188|gb|GQ377679.1| | 238758 | g3353 | i0 | 80.972 | 2.87458745874587 | 247 | 35 | 80 | 8 | 63 | 303 | 530 | 290 | Stephanopogon apogon HSP90 gene, partial cds | blastn | 871 | 185 | 1 | Eukaryota | Discoba | Heterolobosea | Stephanopogonidae | Stephanopogon | Stephanopogon apogon | ||||
| 16789734 | 16789734 | PRJNA1105232_S_NODE_294_length_883_cov_2.719424_g115_i0 | PRJNA1105232 | 294 | 883 | 2.719424 | 24.01251392 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 248 | 1.06e-60 | NTclustered | gi|38606347|gb|AY376155.1| | 51637 | g115 | i0 | 82.818 | 25.4518686296716 | 291 | 36 | 42 | 12 | 221 | 507 | 971 | 691 | Naegleria lovaniensis isolate 7372 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 22474 | 248 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 22697370 | 22697370 | PRJNA1105232_S_NODE_358_length_786_cov_20.074627_g174_i0 | PRJNA1105232 | 358 | 786 | 20.074627 | 157.78656822 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 368 | 6.89e-97 | NTclustered | gi|65306218|gb|AY965861.1| | 328341 | g174 | i0 | 94.191 | 38.236641221374 | 241 | 14 | 31 | 0 | 1 | 241 | 501 | 741 | Soil amoeba AND9 18S ribosomal RNA gene, partial sequence | blastn | 30054 | 370 | 0.994594594594595 | Eukaryota | Discoba | Heterolobosea | soil amoeba AND9 | ||||||
| 23164846 | 23164846 | PRJNA1105232_S_NODE_1379_length_431_cov_7.727749_g1165_i0 | PRJNA1105232 | 1379 | 431 | 7.727749 | 33.30659819 | Neovahlkampfia damariscottae | 166956 | Heterolobosea | other_Eukaryota | 150 | 1.43e-31 | NTclustered | gi|2874368068|gb|PQ819792.1| | 166956 | g1165 | i0 | 89.916 | 3.60092807424594 | 119 | 8 | 27 | 3 | 315 | 431 | 394 | 510 | Neovahlkampfia damariscottae strain CCAP:1588/7 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 1552 | 150 | 1 | Eukaryota | Discoba | Heterolobosea | Neovahlkampfiidae | Neovahlkampfia | Neovahlkampfia damariscottae |
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);;