contig_metadata
13 rows where bioproject = "PRJNA613025", tax_clade = "Discoba" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1867716 | 1867716 | PRJNA613025_S_NODE_21722_length_207_cov_1.917722_g21568_i0 | PRJNA613025 | 21722 | 207 | 1.917722 | 3.96968454 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 377 | 2.63e-100 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g21568 | i0 | 99.517 | 3.16908212560386 | 207 | 1 | 100 | 0 | 1 | 207 | 3450 | 3244 | 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 | 656 | 377 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 2423962 | 2423962 | PRJNA613025_S_NODE_14702_length_284_cov_1.804255_g14548_i0 | PRJNA613025 | 14702 | 284 | 1.804255 | 5.1240842 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 508 | 1.29e-139 | NTclustered | gi|399764158|gb|JQ271669.1| | 1217110 | g14548 | i0 | 98.947 | 86.4577464788732 | 285 | 2 | 100 | 1 | 1 | 284 | 1301 | 1017 | Allovahlkampfia sp. PKD 2011a strain PS1073J 18S ribosomal RNA gene, partial sequence | blastn | 24554 | 508 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. PKD 2011a | ||||
| 8244727 | 8244727 | PRJNA613025_S_NODE_17567_length_244_cov_0.984615_g17413_i0 | PRJNA613025 | 17567 | 244 | 0.984615 | 2.4024606 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 80.5 | 7.7e-17 | NR | XP_002681637.1 | 5762 | g17413 | i0 | 50.6 | 0.94672131147541 | 77 | 36 | 94.7 | 1 | 242 | 12 | 84 | 158 | XP_002681637.1 ubiquitin-conjugating enzyme E2C [Naegleria gruberi] | diamond | 231 | 80.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 8245017 | 8245017 | PRJNA613025_S_NODE_29847_length_168_cov_0.781513_g29693_i0 | PRJNA613025 | 29847 | 168 | 0.781513 | 1.31294184 | Neovahlkampfia damariscottae | 166956 | Heterolobosea | other_Eukaryota | 261 | 2.15e-65 | NTclustered | gi|2874368068|gb|PQ819792.1| | 166956 | g29693 | i0 | 94.643 | 100.232142857143 | 168 | 9 | 100 | 0 | 1 | 168 | 1322 | 1155 | Neovahlkampfia damariscottae strain CCAP:1588/7 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 16839 | 261 | 1 | Eukaryota | Discoba | Heterolobosea | Neovahlkampfiidae | Neovahlkampfia | Neovahlkampfia damariscottae | ||||
| 10795714 | 10795714 | PRJNA613025_S_NODE_11369_length_354_cov_2.177049_g11215_i0 | PRJNA613025 | 11369 | 354 | 2.177049 | 7.70675346 | Allovahlkampfia sp. PKD 2011a | 1217110 | Heterolobosea | other_Eukaryota | 654 | 0 | NTclustered | gi|399764158|gb|JQ271669.1| | 1217110 | g11215 | i0 | 100 | 52.7824858757062 | 354 | 0 | 100 | 0 | 1 | 354 | 691 | 1044 | Allovahlkampfia sp. PKD 2011a strain PS1073J 18S ribosomal RNA gene, partial sequence | blastn | 18685 | 654 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. PKD 2011a | ||||
| 10796246 | 10796246 | PRJNA613025_S_NODE_33069_length_162_cov_1.088496_g32915_i0 | PRJNA613025 | 33069 | 162 | 1.088496 | 1.76336352 | Vahlkampfia sp. | 1874882 | Heterolobosea | other_Eukaryota | 111 | 2.19e-20 | NTclustered | gi|2651357786|gb|PP174301.1| | 1874882 | g32915 | i0 | 92.308 | 15.9691358024691 | 78 | 6 | 48 | 0 | 1 | 78 | 3929 | 3852 | Vahlkampfia sp. isolate 24M 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 | 2587 | 111 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Vahlkampfia | Vahlkampfia sp. | ||||
| 13345740 | 13345740 | PRJNA613025_S_NODE_17331_length_246_cov_2.375635_g17177_i0 | PRJNA613025 | 17331 | 246 | 2.375635 | 5.8440621 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 444 | 3.14e-120 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g17177 | i0 | 99.187 | 48.8252032520325 | 246 | 2 | 100 | 0 | 1 | 246 | 3864 | 4109 | 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 | 12011 | 444 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 19000232 | 19000232 | PRJNA613025_S_NODE_23595_length_196_cov_1.115646_g23441_i0 | PRJNA613025 | 23595 | 196 | 1.115646 | 2.18666616 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 363 | 6.899999999999998e-96 | NTclustered | gi|399764158|gb|JQ271669.1| | 1217110 | g23441 | i0 | 100 | 25.3622448979592 | 196 | 0 | 100 | 0 | 1 | 196 | 306 | 501 | Allovahlkampfia sp. PKD 2011a strain PS1073J 18S ribosomal RNA gene, partial sequence | blastn | 4971 | 363 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. PKD 2011a | ||||
| 20994109 | 20994109 | PRJNA613025_S_NODE_25697_length_185_cov_1.301471_g25543_i0 | PRJNA613025 | 25697 | 185 | 1.301471 | 2.40772135 | Vahlkampfia sp. | 1874882 | Heterolobosea | other_Eukaryota | 163 | 6.99e-36 | NTclustered | gi|2651357786|gb|PP174301.1| | 1874882 | g25543 | i0 | 91.597 | 63.4432432432432 | 119 | 8 | 64 | 2 | 31 | 148 | 3856 | 3973 | Vahlkampfia sp. isolate 24M 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 | 11737 | 163 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Vahlkampfia | Vahlkampfia sp. | ||||
| 22268787 | 22268787 | PRJNA613025_S_NODE_16678_length_254_cov_2.200000_g16524_i0 | PRJNA613025 | 16678 | 254 | 2.2 | 5.588 | Neovahlkampfia damariscottae | 166956 | Heterolobosea | other_Eukaryota | 115 | 2.9e-21 | NTclustered | gi|2874368068|gb|PQ819792.1| | 166956 | g16524 | i0 | 88.66 | 1.84251968503937 | 97 | 7 | 37 | 3 | 160 | 254 | 394 | 488 | Neovahlkampfia damariscottae strain CCAP:1588/7 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 468 | 115 | 1 | Eukaryota | Discoba | Heterolobosea | Neovahlkampfiidae | Neovahlkampfia | Neovahlkampfia damariscottae | ||||
| 23544477 | 23544477 | PRJNA613025_S_NODE_34359_length_156_cov_2.794393_g34205_i0 | PRJNA613025 | 34359 | 156 | 2.794393 | 4.35925308 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 248 | 1.5299999999999998e-61 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g34205 | i0 | 95.484 | 4.51923076923077 | 155 | 7 | 99 | 0 | 2 | 156 | 4336 | 4182 | 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 | 705 | 248 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 24100570 | 24100570 | PRJNA613025_S_NODE_16099_length_262_cov_1.643192_g15945_i0 | PRJNA613025 | 16099 | 262 | 1.643192 | 4.30516304 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 484 | 1.99e-132 | NTclustered | gi|399764158|gb|JQ271669.1| | 1217110 | g15945 | i0 | 100 | 28.381679389313 | 262 | 0 | 100 | 0 | 1 | 262 | 334 | 73 | Allovahlkampfia sp. PKD 2011a strain PS1073J 18S ribosomal RNA gene, partial sequence | blastn | 7436 | 484 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. PKD 2011a | ||||
| 30838580 | 30838580 | PRJNA613025_S_NODE_28214_length_174_cov_1.224000_g28060_i0 | PRJNA613025 | 28214 | 174 | 1.224 | 2.12976 | Stachyamoeba lipophora | 463046 | Heterolobosea | other_Eukaryota | 64.3 | 2.36e-10 | NR | YP_009118142.1 | 463046 | g28060 | i0 | 49.1 | 0.948275862068966 | 55 | 28 | 94.8 | 0 | 1 | 165 | 92 | 146 | YP_009118142.1 cytochrome c oxidase subunit 3 [Stachyamoeba lipophora] | diamond | 165 | 64.3 | 1 | Eukaryota | Discoba | Heterolobosea | Gruberellidae | Stachyamoeba | Stachyamoeba lipophora |
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);;