contig_metadata
15 rows where bioproject = "PRJNA485080" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 449206 | 449206 | PRJNA485080_P_NODE_28621_length_248_cov_0.880000_g28527_i0 | PRJNA485080 | 28621 | 248 | 0.88 | 2.1824 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 435 | 1.91e-117 | NTclustered | gi|256665305|gb|AC237576.1| | 5762 | g28527 | i0 | 98.77 | 20.8427419354839 | 244 | 3 | 98 | 0 | 1 | 244 | 2329 | 2086 | Naegleria gruberi clone JGIBCCN-9M20, complete sequence | blastn | 5169 | 435 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 3000119 | 3000119 | PRJNA485080_P_NODE_41143_length_242_cov_0.911243_g41049_i0 | PRJNA485080 | 41143 | 242 | 0.911243 | 2.20520806 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 436 | 5.1499999999999985e-118 | NTclustered | gi|290988433|ref|XM_002676880.1| | 5762 | g41049 | i0 | 99.174 | 98.7809917355372 | 242 | 2 | 100 | 0 | 1 | 242 | 283 | 42 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82621), mRNA | blastn | 23905 | 436 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 9376809 | 9376809 | PRJNA485080_P_NODE_17008_length_279_cov_1.495146_g16914_i0 | PRJNA485080 | 17008 | 279 | 1.495146 | 4.17145734 | Allovahlkampfia sp. PKD 2011a | 1217110 | Heterolobosea | other_Eukaryota | 516 | 7.58e-142 | NTclustered | gi|399764158|gb|JQ271669.1| | 1217110 | g16914 | i0 | 100 | 39.2007168458781 | 279 | 0 | 100 | 0 | 1 | 279 | 1132 | 854 | Allovahlkampfia sp. PKD 2011a strain PS1073J 18S ribosomal RNA gene, partial sequence | blastn | 10937 | 516 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. PKD 2011a | ||||
| 10652930 | 10652930 | PRJNA485080_P_NODE_34049_length_245_cov_0.895349_g33955_i0 | PRJNA485080 | 34049 | 245 | 0.895349 | 2.19360505 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 364 | 2.5e-96 | NTclustered | gi|291000016|ref|XM_002682530.1| | 5762 | g33955 | i0 | 93.469 | 1 | 245 | 16 | 100 | 0 | 1 | 245 | 264 | 20 | Naegleria gruberi cathepsin C (NAEGRDRAFT_37577), mRNA | blastn | 245 | 364 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 10653008 | 10653008 | PRJNA485080_P_NODE_38789_length_243_cov_0.905882_g38695_i0 | PRJNA485080 | 38789 | 243 | 0.905882 | 2.20129326 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 279 | 9.23e-71 | NTclustered | gi|290990461|ref|XM_002677809.1| | 5762 | g38695 | i0 | 88.136 | 0.97119341563786 | 236 | 26 | 97 | 2 | 9 | 243 | 325 | 91 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_66780), partial mRNA | blastn | 236 | 279 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 15751950 | 15751950 | PRJNA485080_P_NODE_36413_length_244_cov_0.900585_g36319_i0 | PRJNA485080 | 36413 | 244 | 0.900585 | 2.1974274 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 385 | 1.91e-102 | NTclustered | gi|290998620|ref|XM_002681833.1| | 5762 | g36319 | i0 | 95.082 | 3.95081967213115 | 244 | 12 | 100 | 0 | 1 | 244 | 2008 | 2251 | Naegleria gruberi transcriptional repressor TUP1 (NAEGRDRAFT_78346), mRNA | blastn | 964 | 385 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 17026430 | 17026430 | PRJNA485080_P_NODE_27654_length_248_cov_1.691429_g27560_i0 | PRJNA485080 | 27654 | 248 | 1.691429 | 4.19474392 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 359 | 1.18e-94 | NTclustered | gi|290992483|ref|XM_002678818.1| | 5762 | g27560 | i0 | 92.742 | 1 | 248 | 18 | 100 | 0 | 1 | 248 | 334 | 87 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_32649), partial mRNA | blastn | 248 | 359 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 18948902 | 18948902 | PRJNA485080_P_NODE_3775_length_482_cov_1.503667_g3681_i0 | PRJNA485080 | 3775 | 482 | 1.503667 | 7.24767494 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 213 | 2.04e-50 | NTclustered | gi|2031946985|emb|OD958550.1| | 5763 | g3681 | i0 | 82.171 | 26.0145228215768 | 258 | 36 | 54 | 5 | 1 | 258 | 3013 | 3260 | Naegleria fowleri Karachi_NF001 strain | blastn | 12539 | 213 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 20223745 | 20223745 | PRJNA485080_P_NODE_19596_length_262_cov_1.629630_g19502_i0 | PRJNA485080 | 19596 | 262 | 1.62963 | 4.2696306 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 484 | 1.99e-132 | NTclustered | gi|89148135|gb|DQ388520.1| | 373144 | g19502 | i0 | 100 | 89.7404580152672 | 262 | 0 | 100 | 0 | 1 | 262 | 2088 | 1827 | Heterolobosea sp. OSA 16S small subunit ribosomal RNA gene, partial sequence | blastn | 23512 | 484 | 1 | Eukaryota | Discoba | Heterolobosea | Heterolobosea sp. OSA | ||||||
| 23401597 | 23401597 | PRJNA485080_P_NODE_38319_length_243_cov_0.905882_g38225_i0 | PRJNA485080 | 38319 | 243 | 0.905882 | 2.20129326 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 200 | 7.39e-47 | NTclustered | gi|290987290|ref|XM_002676310.1| | 5762 | g38225 | i0 | 84.878 | 0.843621399176955 | 205 | 23 | 83 | 6 | 8 | 208 | 1059 | 859 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_58240), mRNA | blastn | 205 | 200 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 24675022 | 24675022 | PRJNA485080_P_NODE_15680_length_288_cov_1.139535_g15586_i0 | PRJNA485080 | 15680 | 288 | 1.139535 | 3.2818608 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 460 | 3.74e-125 | NTclustered | gi|290997252|ref|XM_002681150.1| | 5762 | g15586 | i0 | 95.789 | 22.5659722222222 | 285 | 12 | 99 | 0 | 4 | 288 | 629 | 345 | Naegleria gruberi HSP70 family protein (NAEGRDRAFT_82977), mRNA | blastn | 6499 | 460 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27897424 | 27897424 | PRJNA485080_P_NODE_36765_length_244_cov_0.900585_g36671_i0 | PRJNA485080 | 36765 | 244 | 0.900585 | 2.1974274 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 108 | 1.43e-25 | NR | XP_002676895.1 | 5762 | g36671 | i0 | 72 | 1.00819672131148 | 82 | 20 | 99.6 | 2 | 243 | 1 | 377 | 456 | XP_002676895.1 uncharacterized protein NAEGRDRAFT_49200 [Naegleria gruberi] | diamond | 246 | 108 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30266162 | 30266162 | PRJNA485080_P_NODE_15792_length_287_cov_1.439252_g15698_i0 | PRJNA485080 | 15792 | 287 | 1.439252 | 4.13065324 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 94.7 | 6.38e-23 | NR | XP_002677819.1 | 5762 | g15698 | i0 | 56.1 | 1.02439024390244 | 98 | 31 | 95.1 | 4 | 5 | 277 | 9 | 101 | XP_002677819.1 uncharacterized protein NAEGRDRAFT_67079 [Naegleria gruberi] | diamond | 294 | 94.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30424274 | 30424274 | PRJNA485080_P_NODE_18093_length_272_cov_1.547739_g17999_i0 | PRJNA485080 | 18093 | 272 | 1.547739 | 4.20985008 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 141 | 7.95e-39 | NR | XP_002675987.1 | 5762 | g17999 | i0 | 73.3 | 0.992647058823529 | 90 | 23 | 99.3 | 1 | 3 | 272 | 50 | 138 | XP_002675987.1 uncharacterized protein NAEGRDRAFT_68955 [Naegleria gruberi] | diamond | 270 | 141 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30613309 | 30613309 | PRJNA485080_P_NODE_41073_length_242_cov_0.911243_g40979_i0 | PRJNA485080 | 41073 | 242 | 0.911243 | 2.20520806 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 91.3 | 3.05e-19 | NR | XP_002671249.1 | 5762 | g40979 | i0 | 66.7 | 1.00413223140496 | 81 | 25 | 99.2 | 2 | 242 | 3 | 166 | 245 | XP_002671249.1 uncharacterized protein NAEGRDRAFT_59502 [Naegleria gruberi] | diamond | 243 | 91.3 | 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);;