contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA669701" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 635913 | 635913 | PRJNA669701_P_NODE_41561_length_368_cov_1.427119_g41166_i0 | PRJNA669701 | 41561 | 368 | 1.427119 | 5.25179792 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 641 | 1.63e-179 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g41166 | i0 | 98.098 | 3.0054347826087 | 368 | 7 | 100 | 0 | 1 | 368 | 3624 | 3991 | 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 | 1106 | 641 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 3715512 | 3715512 | PRJNA669701_P_NODE_121003_length_247_cov_0.885057_g120608_i0 | PRJNA669701 | 121003 | 247 | 0.885057 | 2.18609079 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 287 | 5.62e-73 | NTclustered | gi|686641248|ref|XM_009314795.1| | 71804 | g120608 | i0 | 92.5 | 80.5991902834008 | 200 | 15 | 81 | 0 | 46 | 245 | 1355 | 1156 | Trypanosoma grayi putative alpha tubulin partial mRNA | blastn | 19908 | 287 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma grayi | ||
| 7014696 | 7014696 | PRJNA669701_P_NODE_69426_length_296_cov_4.134529_g69031_i0 | PRJNA669701 | 69426 | 296 | 4.134529 | 12.23820584 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 180 | 1.2099999999999999e-40 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g69031 | i0 | 89.041 | 42.0236486486486 | 146 | 15 | 49 | 1 | 151 | 296 | 2901 | 3045 | 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 | 12439 | 180 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 10093170 | 10093170 | PRJNA669701_P_NODE_67608_length_300_cov_1.920705_g67213_i0 | PRJNA669701 | 67608 | 300 | 1.920705 | 5.762115 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 62.1 | 4.64e-5 | NTclustered | gi|2031946985|emb|OD958550.1| | 5763 | g67213 | i0 | 100 | 10.5933333333333 | 33 | 0 | 11 | 0 | 54 | 86 | 4357 | 4325 | Naegleria fowleri Karachi_NF001 strain | blastn | 3178 | 62.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 10839007 | 10839007 | PRJNA669701_P_NODE_102289_length_256_cov_2.240437_g101894_i0 | PRJNA669701 | 102289 | 256 | 2.240437 | 5.73551872 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 412 | 9.27e-111 | NTclustered | gi|290972517|ref|XM_002668953.1| | 5762 | g101894 | i0 | 95.703 | 1 | 256 | 11 | 100 | 0 | 1 | 256 | 1032 | 777 | Naegleria gruberi citrate synthase family member (NAEGRDRAFT_82269), mRNA | blastn | 256 | 412 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 10839409 | 10839409 | PRJNA669701_P_NODE_132049_length_244_cov_0.900585_g131654_i0 | PRJNA669701 | 132049 | 244 | 0.900585 | 2.1974274 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 396 | 8.829999999999997e-106 | NTclustered | gi|290974780|ref|XM_002670077.1| | 5762 | g131654 | i0 | 95.902 | 1 | 244 | 10 | 100 | 0 | 1 | 244 | 724 | 481 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_81952), mRNA | blastn | 244 | 396 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13388927 | 13388927 | PRJNA669701_P_NODE_104171_length_254_cov_2.116022_g103776_i0 | PRJNA669701 | 104171 | 254 | 2.116022 | 5.37469588 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 425 | 1.18e-114 | NTclustered | gi|290971770|ref|XM_002668606.1| | 5762 | g103776 | i0 | 96.85 | 1 | 254 | 8 | 100 | 0 | 1 | 254 | 936 | 683 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_60075), partial mRNA | blastn | 254 | 425 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13390015 | 13390015 | PRJNA669701_P_NODE_58931_length_317_cov_1.909836_g58536_i0 | PRJNA669701 | 58931 | 317 | 1.909836 | 6.05418012 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 128 | 4.8e-25 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g58536 | i0 | 84.848 | 21.1514195583596 | 132 | 15 | 51 | 5 | 129 | 256 | 3188 | 3058 | 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 | 6705 | 128 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 17214123 | 17214123 | PRJNA669701_P_NODE_70014_length_295_cov_3.923423_g69619_i0 | PRJNA669701 | 70014 | 295 | 3.923423 | 11.57409785 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 494 | 3.78e-135 | NTclustered | gi|290992886|ref|XM_002679019.1| | 5762 | g69619 | i0 | 96.949 | 4.44067796610169 | 295 | 8 | 100 | 1 | 1 | 295 | 4 | 297 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_36106), mRNA | blastn | 1310 | 494 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 18488393 | 18488393 | PRJNA669701_P_NODE_62135_length_310_cov_3.624473_g61740_i0 | PRJNA669701 | 62135 | 310 | 3.624473 | 11.2358663 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 261 | 4.42e-65 | NTclustered | gi|290980060|ref|XM_002672705.1| | 5762 | g61740 | i0 | 98 | 1.94838709677419 | 150 | 3 | 97 | 0 | 1 | 150 | 374 | 225 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_81126), partial mRNA | blastn | 604 | 261 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 19762106 | 19762106 | PRJNA669701_P_NODE_126596_length_245_cov_1.843023_g126201_i0 | PRJNA669701 | 126596 | 245 | 1.843023 | 4.51540635 | Paravahlkampfia sp. LA | 373134 | Heterolobosea | other_Eukaryota | 385 | 1.92e-102 | NTclustered | gi|89148136|gb|DQ388521.1| | 373134 | g126201 | i0 | 95.122 | 47.5714285714286 | 246 | 9 | 100 | 2 | 1 | 245 | 1539 | 1296 | Paravahlkampfia sp. LA 16S small subunit ribosomal RNA gene, partial sequence | blastn | 11655 | 385 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Paravahlkampfia | Paravahlkampfia sp. LA | ||||
| 22312987 | 22312987 | PRJNA669701_P_NODE_29178_length_434_cov_4.678670_g28783_i0 | PRJNA669701 | 29178 | 434 | 4.67867 | 20.3054278 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 797 | 0 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g28783 | i0 | 99.77 | 24.5207373271889 | 434 | 1 | 100 | 0 | 1 | 434 | 1866 | 2299 | 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 | 10642 | 797 | 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);;