contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1074408" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1465578 | 1465578 | PRJNA1074408_S_NODE_2722_length_278_cov_6.110638_g2592_i0 | PRJNA1074408 | 2722 | 278 | 6.110638 | 16.98757364 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 464 | 2.77e-126 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g2592 | i0 | 96.774 | 50.5431654676259 | 279 | 7 | 100 | 2 | 1 | 278 | 2764 | 3041 | 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 | 14051 | 464 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 5293820 | 5293820 | PRJNA1074408_S_NODE_1045_length_435_cov_2.982143_g915_i0 | PRJNA1074408 | 1045 | 435 | 2.982143 | 12.97232205 | Allovahlkampfia sp. SG-2014c | 1445708 | Heterolobosea | other_Eukaryota | 749 | 0 | NTclustered | gi|574484036|gb|KF547915.1| | 1445708 | g915 | i0 | 97.701 | 91.5402298850575 | 435 | 10 | 100 | 0 | 1 | 435 | 853 | 1287 | Allovahlkampfia sp. SG-2014c 18S ribosomal RNA gene, partial sequence | blastn | 39820 | 749 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. SG-2014c | ||||
| 5293852 | 5293852 | PRJNA1074408_S_NODE_945_length_453_cov_3.297561_g815_i0 | PRJNA1074408 | 945 | 453 | 3.297561 | 14.93795133 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 809 | 0 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g815 | i0 | 98.896 | 87.682119205298 | 453 | 5 | 100 | 0 | 1 | 453 | 3512 | 3060 | 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 | 39720 | 809 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 6568917 | 6568917 | PRJNA1074408_S_NODE_4746_length_212_cov_5.745562_g4616_i0 | PRJNA1074408 | 4746 | 212 | 5.745562 | 12.18059144 | Allovahlkampfia sp. SG-2014c | 1445708 | Heterolobosea | other_Eukaryota | 381 | 2.0899999999999994e-101 | NTclustered | gi|574484036|gb|KF547915.1| | 1445708 | g4616 | i0 | 99.057 | 25.2122641509434 | 212 | 2 | 100 | 0 | 1 | 212 | 452 | 241 | Allovahlkampfia sp. SG-2014c 18S ribosomal RNA gene, partial sequence | blastn | 5345 | 381 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. SG-2014c | ||||
| 9944686 | 9944686 | PRJNA1074408_S_NODE_4148_length_227_cov_3.885870_g4018_i0 | PRJNA1074408 | 4148 | 227 | 3.88587 | 8.8209249 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 167 | 6.9199999999999995e-37 | NTclustered | gi|2031946985|emb|OD958550.1| | 5763 | g4018 | i0 | 80.617 | 30.3612334801762 | 227 | 34 | 100 | 5 | 1 | 227 | 3228 | 3012 | Naegleria fowleri Karachi_NF001 strain | blastn | 6892 | 167 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 10394274 | 10394274 | PRJNA1074408_S_NODE_289_length_727_cov_5.086257_g198_i0 | PRJNA1074408 | 289 | 727 | 5.086257 | 36.97708839 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 1129 | 0 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g198 | i0 | 94.78 | 18.5103163686382 | 728 | 33 | 100 | 5 | 1 | 727 | 4553 | 3830 | 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 | 13457 | 1129 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 14219701 | 14219701 | PRJNA1074408_S_NODE_1812_length_337_cov_4.397959_g1682_i0 | PRJNA1074408 | 1812 | 337 | 4.397959 | 14.82112183 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 457 | 5.7699999999999985e-124 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g1682 | i0 | 91.15 | 19.9287833827893 | 339 | 27 | 100 | 3 | 1 | 337 | 2422 | 2085 | 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 | 6716 | 457 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 16767924 | 16767924 | PRJNA1074408_S_NODE_1434_length_378_cov_2.579104_g1304_i0 | PRJNA1074408 | 1434 | 378 | 2.579104 | 9.74901312 | Allovahlkampfia sp. strain SO/1P | 500012 | Heterolobosea | other_Eukaryota | 669 | 0 | NTclustered | gi|529154115|gb|EU266548.2| | 500012 | g1304 | i0 | 98.681 | 69.6984126984127 | 379 | 1 | 100 | 4 | 1 | 378 | 543 | 918 | Allovahlkampfia sp. strain SO/1P small subunit ribosomal RNA gene, complete sequence | blastn | 26346 | 669 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. strain SO/1P |
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);;