contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1046144" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3559983 | 3559983 | PRJNA1046144_P_NODE_53623_length_240_cov_1.204678_g53328_i0 | PRJNA1046144 | 53623 | 240 | 1.204678 | 2.8912272 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 296 | 9.03e-76 | NTclustered | gi|399764159|gb|JQ271670.1| | 1217111 | g53328 | i0 | 88.889 | 67.5083333333333 | 243 | 23 | 100 | 4 | 1 | 240 | 2837 | 3078 | Allovahlkampfia sp. PKD 2011b strain PV66 18S ribosomal RNA gene, partial sequence | blastn | 16202 | 296 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. PKD 2011b | ||||
| 3998483 | 3998483 | PRJNA1046144_P_NODE_23244_length_341_cov_2.117647_g22949_i0 | PRJNA1046144 | 23244 | 341 | 2.117647 | 7.22117627 | Allovahlkampfia sp. strain SO/1P | 500012 | Heterolobosea | other_Eukaryota | 610 | 4.239999999999999e-170 | NTclustered | gi|701726755|gb|KM220721.1| | 500012 | g22949 | i0 | 99.118 | 37.2052785923754 | 340 | 2 | 99 | 1 | 1 | 339 | 19 | 358 | Allovahlkampfia sp. strain SO/1P isolate 164A 18S ribosomal RNA gene, partial sequence | blastn | 12687 | 610 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. strain SO/1P | ||||
| 3999025 | 3999025 | PRJNA1046144_P_NODE_51444_length_244_cov_3.194286_g51149_i0 | PRJNA1046144 | 51444 | 244 | 3.194286 | 7.79405784 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 344 | 3.2399999999999993e-90 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g51149 | i0 | 92.213 | 3.00819672131148 | 244 | 17 | 100 | 2 | 1 | 244 | 3618 | 3859 | 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 | 734 | 344 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 5275261 | 5275261 | PRJNA1046144_P_NODE_46405_length_256_cov_1.187166_g46110_i0 | PRJNA1046144 | 46405 | 256 | 1.187166 | 3.03914496 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 357 | 4.4e-94 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g46110 | i0 | 91.797 | 26.99609375 | 256 | 21 | 100 | 0 | 1 | 256 | 4272 | 4527 | 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 | 6911 | 357 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 7387154 | 7387154 | PRJNA1046144_P_NODE_61406_length_231_cov_1.765432_g61111_i0 | PRJNA1046144 | 61406 | 231 | 1.765432 | 4.07814792 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 198 | 2.51e-46 | NTclustered | gi|2414483|emb|Y00055.1| | 5656 | g61111 | i0 | 98.23 | 70.5800865800866 | 113 | 2 | 49 | 0 | 2 | 114 | 8175 | 8063 | Crithidia fasciculata ribosomal DNA repeat (complete) | blastn | 16304 | 200 | 0.99 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Crithidia | Crithidia fasciculata | ||
| 11212320 | 11212320 | PRJNA1046144_P_NODE_18249_length_380_cov_1.311897_g17954_i0 | PRJNA1046144 | 18249 | 380 | 1.311897 | 4.9852086 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 514 | 3.84e-141 | NTclustered | gi|2026667530|dbj|LC618030.1| | 67003 | g17954 | i0 | 94.595 | 139.921052631579 | 333 | 16 | 87 | 2 | 49 | 380 | 4700 | 4369 | Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence | blastn | 53170 | 514 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 12488332 | 12488332 | PRJNA1046144_P_NODE_65570_length_229_cov_0.900000_g65275_i0 | PRJNA1046144 | 65570 | 229 | 0.9 | 2.061 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 418 | 1.7499999999999995e-112 | NTclustered | gi|399764157|gb|JQ271668.1| | 1217110 | g65275 | i0 | 99.563 | 79.1091703056769 | 229 | 1 | 100 | 0 | 1 | 229 | 1996 | 1768 | Allovahlkampfia sp. PKD 2011a strain 4165 18S ribosomal RNA gene, partial sequence | blastn | 18116 | 418 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. PKD 2011a | ||||
| 12488381 | 12488381 | PRJNA1046144_P_NODE_72150_length_188_cov_4.840336_g71855_i0 | PRJNA1046144 | 72150 | 188 | 4.840336 | 9.09983168 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 252 | 1.48e-62 | NTclustered | gi|2414483|emb|Y00055.1| | 5656 | g71855 | i0 | 90.957 | 121.781914893617 | 188 | 16 | 100 | 1 | 1 | 188 | 6841 | 7027 | Crithidia fasciculata ribosomal DNA repeat (complete) | blastn | 22895 | 254 | 0.992125984251969 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Crithidia | Crithidia fasciculata | ||
| 16311309 | 16311309 | PRJNA1046144_P_NODE_12973_length_444_cov_1.706667_g12678_i0 | PRJNA1046144 | 12973 | 444 | 1.706667 | 7.57760148 | Tetramitus | 5768 | Heterolobosea | other_Eukaryota | 815 | 0 | NTclustered | gi|1707456|emb|X93085.1| | 166960 | g12678 | i0 | 99.775 | 75.4166666666667 | 444 | 1 | 100 | 0 | 1 | 444 | 1961 | 1518 | Tetramitus thorntoni SSU rRNA gene | blastn | 33485 | 821 | 0.992691839220463 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Tetramitus | Tetramitus thorntoni | ||||
| 16311327 | 16311327 | PRJNA1046144_P_NODE_14393_length_423_cov_2.206215_g14098_i0 | PRJNA1046144 | 14393 | 423 | 2.206215 | 9.33228945 | Tetramitus | 5768 | Heterolobosea | other_Eukaryota | 782 | 0 | NTclustered | gi|4469330|emb|AJ224888.1| | 74084 | g14098 | i0 | 100 | 49.3475177304965 | 423 | 0 | 100 | 0 | 1 | 423 | 119 | 541 | Vahlkampfia aberdonica SSU rRNA gene, strain CCAP 1588/4 | blastn | 20874 | 782 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Tetramitus | Tetramitus aberdonicus |
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);;