contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA576995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 560816 | 560816 | PRJNA576995_P_NODE_29741_length_279_cov_2.242718_g29149_i0 | PRJNA576995 | 29741 | 279 | 2.242718 | 6.25718322 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 176 | 1.46e-39 | NTclustered | gi|290991132|ref|XM_002678144.1| | 5762 | g29149 | i0 | 78.388 | 2.40143369175627 | 273 | 57 | 97 | 2 | 6 | 277 | 17 | 288 | Naegleria gruberi ribosomal protein L3 (NAEGRDRAFT_79448), mRNA | blastn | 670 | 176 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 561061 | 561061 | PRJNA576995_P_NODE_6341_length_638_cov_2.447788_g5760_i0 | PRJNA576995 | 6341 | 638 | 2.447788 | 15.61688744 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 573 | 1.0899999999999996e-158 | NTclustered | gi|290996126|ref|XM_002680588.1| | 5762 | g5760 | i0 | 84.37 | 90.7351097178683 | 595 | 81 | 92 | 10 | 50 | 638 | 28 | 616 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_55154), mRNA | blastn | 57889 | 573 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 561157 | 561157 | PRJNA576995_P_NODE_9921_length_492_cov_1.787589_g9330_i0 | PRJNA576995 | 9921 | 492 | 1.787589 | 8.79493788 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 865 | 0 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g9330 | i0 | 98.374 | 25.9126016260163 | 492 | 8 | 100 | 0 | 1 | 492 | 3628 | 4119 | Allovahlkampfia sp. isolate P10 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 | 12749 | 865 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 3688374 | 3688374 | PRJNA576995_P_NODE_38543_length_247_cov_0.885057_g37951_i0 | PRJNA576995 | 38543 | 247 | 0.885057 | 2.18609079 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 65.8 | 2.87e-6 | NTclustered | gi|38606345|gb|AY376153.1| | 5762 | g37951 | i0 | 97.368 | 6.61943319838057 | 38 | 1 | 15 | 0 | 20 | 57 | 1011 | 1048 | Naegleria gruberi isolate 7860 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 1635 | 65.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 6938755 | 6938755 | PRJNA576995_P_NODE_23706_length_313_cov_1.283333_g23114_i0 | PRJNA576995 | 23706 | 313 | 1.283333 | 4.01683229 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 573 | 5.049999999999998e-159 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g23114 | i0 | 99.681 | 55.9105431309904 | 313 | 1 | 100 | 0 | 1 | 313 | 2910 | 2598 | Allovahlkampfia sp. isolate P10 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 | 17500 | 573 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 8213789 | 8213789 | PRJNA576995_P_NODE_25967_length_300_cov_1.017621_g25375_i0 | PRJNA576995 | 25967 | 300 | 1.017621 | 3.052863 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 549 | 8.119999999999997e-152 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g25375 | i0 | 99.667 | 3.13 | 300 | 1 | 100 | 0 | 1 | 300 | 3238 | 3537 | Allovahlkampfia sp. isolate P10 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 | 939 | 549 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 12039948 | 12039948 | PRJNA576995_P_NODE_39430_length_246_cov_0.890173_g38838_i0 | PRJNA576995 | 39430 | 246 | 0.890173 | 2.18982558 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 320 | 5.52e-83 | NTclustered | gi|290974165|ref|XM_002669771.1| | 5762 | g38838 | i0 | 90.204 | 0.995934959349594 | 245 | 24 | 99 | 0 | 2 | 246 | 56 | 300 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_59838), mRNA | blastn | 245 | 320 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13314816 | 13314816 | PRJNA576995_P_NODE_34251_length_253_cov_1.333333_g33659_i0 | PRJNA576995 | 34251 | 253 | 1.333333 | 3.37333249 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 355 | 1.56e-93 | NTclustered | gi|290991471|ref|XM_002678313.1| | 5762 | g33659 | i0 | 93.004 | 4.80632411067194 | 243 | 17 | 96 | 0 | 9 | 251 | 341 | 583 | Naegleria gruberi 60S ribosomal protein L38 (NAEGRDRAFT_66493), partial mRNA | blastn | 1216 | 355 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13314900 | 13314900 | PRJNA576995_P_NODE_42491_length_242_cov_0.911243_g41899_i0 | PRJNA576995 | 42491 | 242 | 0.911243 | 2.20520806 | Vahlkampfia avara | 74082 | Heterolobosea | other_Eukaryota | 448 | 2.3799999999999995e-121 | NTclustered | gi|2874368078|gb|PQ819802.1| | 74082 | g41899 | i0 | 100 | 57.6446280991736 | 242 | 0 | 100 | 0 | 1 | 242 | 1606 | 1365 | Vahlkampfia avara strain CCAP 1588/1A small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 13950 | 448 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Vahlkampfia | Vahlkampfia avara | ||||
| 15863586 | 15863586 | PRJNA576995_P_NODE_43473_length_241_cov_0.916667_g42881_i0 | PRJNA576995 | 43473 | 241 | 0.916667 | 2.20916747 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 324 | 4.16e-84 | NTclustered | gi|290988076|ref|XM_002676702.1| | 5762 | g42881 | i0 | 90.871 | 2 | 241 | 22 | 100 | 0 | 1 | 241 | 264 | 24 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_68050), partial mRNA | blastn | 482 | 324 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 17138596 | 17138596 | PRJNA576995_P_NODE_7574_length_575_cov_1.669323_g6988_i0 | PRJNA576995 | 7574 | 575 | 1.669323 | 9.59860725 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 979 | 0 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g6988 | i0 | 97.391 | 16.8365217391304 | 575 | 15 | 100 | 0 | 1 | 575 | 2031 | 2605 | Allovahlkampfia sp. isolate P10 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 | 9681 | 979 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 24786934 | 24786934 | PRJNA576995_P_NODE_31680_length_269_cov_1.494898_g31088_i0 | PRJNA576995 | 31680 | 269 | 1.494898 | 4.02127562 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 436 | 5.819999999999999e-118 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g31088 | i0 | 95.911 | 29.1672862453532 | 269 | 11 | 100 | 0 | 1 | 269 | 4368 | 4100 | Allovahlkampfia sp. isolate P10 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 | 7846 | 436 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. |
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);;