contig_metadata
10 rows where bioproject = "PRJNA591000" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2414019 | 2414019 | PRJNA591000_P_NODE_3622_length_749_cov_4.630556_g2820_i0 | PRJNA591000 | 3622 | 749 | 4.630556 | 34.68286444 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 739 | 0 | NTclustered | gi|38606345|gb|AY376153.1| | 5762 | g2820 | i0 | 95.662 | 42.1361815754339 | 461 | 19 | 82 | 1 | 277 | 736 | 364 | 824 | Naegleria gruberi isolate 7860 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 31560 | 739 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 6943095 | 6943095 | PRJNA591000_P_NODE_14346_length_390_cov_1.573407_g12748_i0 | PRJNA591000 | 14346 | 390 | 1.573407 | 6.1362873 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 158 | 7.6799999999999995e-34 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g12748 | i0 | 97.802 | 1.74102564102564 | 91 | 2 | 39 | 0 | 19 | 109 | 667 | 757 | Naegleria gruberi mitochondrion, complete genome | blastn | 679 | 158 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 8791427 | 8791427 | PRJNA591000_P_NODE_2387_length_857_cov_27.387681_g1784_i0 | PRJNA591000 | 2387 | 857 | 27.387681 | 234.71242617 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 806 | 0 | NTclustered | gi|2351573|gb|U80061.1|NJU80061 | 36335 | g1784 | i0 | 98.886 | 93.3127187864644 | 449 | 5 | 95 | 0 | 387 | 835 | 1421 | 1869 | Naegleria jamiesoni 18S ribosomal RNA gene, partial sequence | blastn | 79969 | 806 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria jamiesoni | ||||
| 11341966 | 11341966 | PRJNA591000_P_NODE_16529_length_159_cov_5.184615_g14923_i0 | PRJNA591000 | 16529 | 159 | 5.184615 | 8.24353785 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 215 | 1.59e-51 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g14923 | i0 | 93.151 | 9.84276729559748 | 146 | 10 | 92 | 0 | 14 | 159 | 5719 | 5574 | 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 | 1565 | 215 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 11341967 | 11341967 | PRJNA591000_P_NODE_3709_length_743_cov_1.109244_g2893_i0 | PRJNA591000 | 3709 | 743 | 1.109244 | 8.24168292 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 270 | 1.89e-67 | NTclustered | gi|38606345|gb|AY376153.1| | 5762 | g2893 | i0 | 98.065 | 12.7321668909825 | 155 | 3 | 33 | 0 | 301 | 455 | 1161 | 1315 | Naegleria gruberi isolate 7860 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 9460 | 270 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 12617701 | 12617701 | PRJNA591000_P_NODE_6470_length_558_cov_2.827977_g5123_i0 | PRJNA591000 | 6470 | 558 | 2.827977 | 15.78011166 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 634 | 4.29e-177 | NTclustered | gi|2651357780|gb|PP174296.1| | 36333 | g5123 | i0 | 98.873 | 43.3548387096774 | 355 | 4 | 73 | 0 | 1 | 355 | 2493 | 2847 | Naegleria clarki isolate P2881 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 | 24192 | 640 | 0.990625 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria clarki | ||||
| 13318905 | 13318905 | PRJNA591000_P_NODE_4711_length_678_cov_3.112481_g3725_i0 | PRJNA591000 | 4711 | 678 | 3.112481 | 21.10262118 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 128 | 1.09e-24 | NTclustered | gi|2119437446|ref|XM_044694071.1| | 51637 | g3725 | i0 | 84.058 | 0.407079646017699 | 138 | 17 | 40 | 3 | 86 | 219 | 452 | 316 | Naegleria lovaniensis uncharacterized protein (C9374_004432), partial mRNA | blastn | 276 | 128 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 14593770 | 14593770 | PRJNA591000_P_NODE_4932_length_663_cov_84.231861_g3578_i1 | PRJNA591000 | 4932 | 663 | 84.231861 | 558.45723843 | Naegleria jamiesoni | 36335 | Heterolobosea | other_Eukaryota | 797 | 0 | NTclustered | gi|2351573|gb|U80061.1|NJU80061 | 36335 | g3578 | i1 | 94.912 | 87.2533936651584 | 511 | 23 | 89 | 3 | 140 | 648 | 1216 | 707 | Naegleria jamiesoni 18S ribosomal RNA gene, partial sequence | blastn | 57849 | 797 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria jamiesoni | ||||
| 22242054 | 22242054 | PRJNA591000_P_NODE_4518_length_690_cov_80.583964_g3578_i0 | PRJNA591000 | 4518 | 690 | 80.583964 | 556.0293516 | Naegleria jamiesoni | 36335 | Heterolobosea | other_Eukaryota | 797 | 0 | NTclustered | gi|2351573|gb|U80061.1|NJU80061 | 36335 | g3578 | i0 | 94.912 | 77.4985507246377 | 511 | 23 | 81 | 3 | 167 | 675 | 1216 | 707 | Naegleria jamiesoni 18S ribosomal RNA gene, partial sequence | blastn | 53474 | 797 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria jamiesoni | ||||
| 29353487 | 29353487 | PRJNA591000_P_NODE_6169_length_576_cov_1.749543_g4876_i0 | PRJNA591000 | 6169 | 576 | 1.749543 | 10.07736768 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 71.2 | 1.34e-10 | NR | XP_002683406.1 | 5762 | g4876 | i0 | 59.2 | 0.255208333333333 | 49 | 20 | 25.5 | 0 | 147 | 1 | 724 | 772 | XP_002683406.1 jmjC domain-containing protein [Naegleria gruberi] | diamond | 147 | 71.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi |
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);;