contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA533623" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3057066 | 3057066 | PRJNA533623_P_NODE_24183_length_470_cov_4.449878_g22423_i0 | PRJNA533623 | 24183 | 470 | 4.449878 | 20.9144266 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 856 | 0 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g22423 | i0 | 99.574 | 1 | 470 | 1 | 100 | 1 | 1 | 470 | 21286 | 20818 | Naegleria gruberi mitochondrion, complete genome | blastn | 470 | 856 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 5610680 | 5610680 | PRJNA533623_P_NODE_57845_length_262_cov_2.407960_g56065_i0 | PRJNA533623 | 57845 | 262 | 2.40796 | 6.3088552 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 484 | 1.99e-132 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g56065 | i0 | 100 | 3.83969465648855 | 262 | 0 | 100 | 0 | 1 | 262 | 17656 | 17917 | Naegleria gruberi mitochondrion, complete genome | blastn | 1006 | 484 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 10710658 | 10710658 | PRJNA533623_P_NODE_44529_length_320_cov_8.671815_g42755_i0 | PRJNA533623 | 44529 | 320 | 8.671815 | 27.749808 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 580 | 3.099999999999999e-161 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g42755 | i0 | 99.375 | 1.19375 | 320 | 2 | 100 | 0 | 1 | 320 | 22944 | 23263 | Naegleria gruberi mitochondrion, complete genome | blastn | 382 | 580 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13260001 | 13260001 | PRJNA533623_P_NODE_26531_length_446_cov_3.301299_g24762_i0 | PRJNA533623 | 26531 | 446 | 3.301299 | 14.72379354 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 54.7 | 0.012 | NTclustered | gi|2119424383|ref|XM_044700532.1| | 5763 | g24762 | i0 | 92.105 | 0.0852017937219731 | 38 | 3 | 9 | 0 | 275 | 312 | 486 | 449 | Naegleria fowleri uncharacterized protein (FDP41_010254), partial mRNA | blastn | 38 | 54.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 14535889 | 14535889 | PRJNA533623_P_NODE_65572_length_234_cov_5.092486_g63791_i0 | PRJNA533623 | 65572 | 234 | 5.092486 | 11.91641724 | Naegleria pringsheimi | 234921 | Heterolobosea | other_Eukaryota | 315 | 2.42e-81 | NTclustered | gi|2515557648|gb|OR045415.1| | 234921 | g63791 | i0 | 92.07 | 11.1068376068376 | 227 | 13 | 96 | 5 | 1 | 225 | 5781 | 6004 | Naegleria pringsheimi strain Singh(s) rDNA-containing extrachromosomal element genomic sequence; 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; and non-ribosomal sequence | blastn | 2599 | 315 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria pringsheimi | ||||
| 17083898 | 17083898 | PRJNA533623_P_NODE_38814_length_352_cov_2.649485_g37040_i0 | PRJNA533623 | 38814 | 352 | 2.649485 | 9.3261872 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 503 | 7.64e-138 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g37040 | i0 | 96.178 | 0.892045454545455 | 314 | 0 | 89 | 2 | 1 | 314 | 28700 | 28399 | Naegleria gruberi mitochondrion, complete genome | blastn | 314 | 503 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 17695781 | 17695781 | PRJNA533623_P_NODE_33214_length_388_cov_15.039755_g31443_i0 | PRJNA533623 | 33214 | 388 | 15.039755 | 58.3542494 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 143 | 2.14e-29 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g31443 | i0 | 87.805 | 34.8144329896907 | 123 | 14 | 53 | 1 | 266 | 388 | 5057 | 5178 | 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 | 13508 | 143 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 20244282 | 20244282 | PRJNA533623_P_NODE_29816_length_416_cov_1.588732_g28046_i0 | PRJNA533623 | 29816 | 416 | 1.588732 | 6.60912512 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|2031944067|emb|OD958338.1| | 5763 | g28046 | i0 | 86.792 | 3.62980769230769 | 53 | 2 | 12 | 3 | 369 | 416 | 12135 | 12187 | Naegleria fowleri Karachi_NF001 strain | blastn | 1510 | 54.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 20909250 | 20909250 | PRJNA533623_P_NODE_74857_length_207_cov_1.356164_g73076_i0 | PRJNA533623 | 74857 | 207 | 1.356164 | 2.80725948 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 383 | 5.65e-102 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g73076 | i0 | 100 | 8.15942028985507 | 207 | 0 | 100 | 0 | 1 | 207 | 34067 | 33861 | Naegleria gruberi mitochondrion, complete genome | blastn | 1689 | 383 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 22184122 | 22184122 | PRJNA533623_P_NODE_79918_length_186_cov_7.304000_g78137_i0 | PRJNA533623 | 79918 | 186 | 7.304 | 13.58544 | Neovahlkampfia damariscottae | 166956 | Heterolobosea | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2874368068|gb|PQ819792.1| | 166956 | g78137 | i0 | 100 | 0.155913978494624 | 29 | 0 | 16 | 0 | 137 | 165 | 684 | 656 | Neovahlkampfia damariscottae strain CCAP:1588/7 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Discoba | Heterolobosea | Neovahlkampfiidae | Neovahlkampfia | Neovahlkampfia damariscottae | ||||
| 23458551 | 23458551 | PRJNA533623_P_NODE_3339_length_1196_cov_8.277533_g2364_i0 | PRJNA533623 | 3339 | 1196 | 8.277533 | 98.99929468 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 2189 | 0 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g2364 | i0 | 99.666 | 6.19147157190635 | 1198 | 2 | 100 | 1 | 1 | 1196 | 7638 | 8835 | Naegleria gruberi mitochondrion, complete genome | blastn | 7405 | 2189 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 24731947 | 24731947 | PRJNA533623_P_NODE_19780_length_526_cov_3.139785_g18036_i0 | PRJNA533623 | 19780 | 526 | 3.139785 | 16.5152691 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 924 | 0 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g18036 | i0 | 99.801 | 36.8479087452471 | 503 | 1 | 96 | 0 | 24 | 526 | 3510 | 3008 | Naegleria gruberi mitochondrion, complete genome | blastn | 19382 | 924 | 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);;