contig_metadata
11 rows where 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 | ||||
| 9118628 | 9118628 | PRJNA1074408_S_NODE_6188_length_187_cov_1.000000_g6058_i0 | PRJNA1074408 | 6188 | 187 | 1 | 1.87 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 90.9 | 1.66e-19 | NR | KAL0487879.1 | 1008807 | g6058 | i0 | 56.5 | 0.994652406417112 | 62 | 27 | 99.5 | 0 | 186 | 1 | 387 | 448 | KAL0487879.1 protein disulfide-isomerase [Acrasis kona] | diamond | 186 | 90.9 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 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 | ||||
| 27257077 | 27257077 | PRJNA1074408_S_NODE_3463_length_248_cov_1.170732_g3333_i0 | PRJNA1074408 | 3463 | 248 | 1.170732 | 2.90341536 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 121 | 4.25e-33 | NR | KAL0486596.1 | 1008807 | g3333 | i0 | 74.4 | 0.991935483870968 | 82 | 21 | 99.2 | 0 | 2 | 247 | 32 | 113 | KAL0486596.1 ribosomal protein L26 [Acrasis kona] | diamond | 246 | 121 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28898901 | 28898901 | PRJNA1074408_S_NODE_9248_length_155_cov_1.285714_g9118_i0 | PRJNA1074408 | 9248 | 155 | 1.285714 | 1.9928567 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 90.9 | 4.7400000000000006e-21 | NR | KAL0480790.1 | 1008807 | g9118 | i0 | 86.3 | 1.9741935483871 | 51 | 7 | 98.7 | 0 | 153 | 1 | 99 | 149 | KAL0480790.1 ribosomal protein L19 [Acrasis kona] | diamond | 306 | 90.9 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona |
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);;