contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193616 | 193616 | PRJNA1086823_P_NODE_10241_length_270_cov_1.583756_g10124_i0 | PRJNA1086823 | 10241 | 270 | 1.583756 | 4.2761412 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 383 | 7.73e-102 | NTclustered | gi|291001094|ref|XM_002683068.1| | 5762 | g10124 | i0 | 92.222 | 1.52222222222222 | 270 | 21 | 100 | 0 | 1 | 270 | 616 | 885 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_37149), mRNA | blastn | 411 | 383 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 1468526 | 1468526 | PRJNA1086823_P_NODE_6502_length_320_cov_1.263158_g6385_i0 | PRJNA1086823 | 6502 | 320 | 1.263158 | 4.0421056 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 296 | 1.26e-75 | NTclustered | gi|290989396|ref|XM_002677278.1| | 5762 | g6385 | i0 | 83.591 | 4.809375 | 323 | 45 | 99 | 7 | 1 | 319 | 126 | 444 | Naegleria gruberi translation initiation factor eIF-5A family protein (NAEGRDRAFT_67422), partial mRNA | blastn | 1539 | 296 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 2744457 | 2744457 | PRJNA1086823_P_NODE_1683_length_575_cov_2.850598_g1568_i0 | PRJNA1086823 | 1683 | 575 | 2.850598 | 16.3909385 | Naegleria jamiesoni | 36335 | Heterolobosea | other_Eukaryota | 1044 | 0 | NTclustered | gi|2351573|gb|U80061.1|NJU80061 | 36335 | g1568 | i0 | 99.304 | 97.2660869565217 | 575 | 4 | 100 | 0 | 1 | 575 | 1758 | 1184 | Naegleria jamiesoni 18S ribosomal RNA gene, partial sequence | blastn | 55928 | 1044 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria jamiesoni | ||||
| 4020228 | 4020228 | PRJNA1086823_P_NODE_11544_length_257_cov_1.614130_g11427_i0 | PRJNA1086823 | 11544 | 257 | 1.61413 | 4.1483141 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2124399356|ref|XM_044698631.1| | 51637 | g11427 | i0 | 100 | 0.108949416342412 | 28 | 0 | 11 | 0 | 171 | 198 | 858 | 885 | Naegleria lovaniensis uncharacterized protein (C9374_008543), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 4020403 | 4020403 | PRJNA1086823_P_NODE_19384_length_241_cov_4.589286_g19267_i0 | PRJNA1086823 | 19384 | 241 | 4.589286 | 11.06017926 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 318 | 1.94e-82 | NTclustered | gi|291000659|ref|XM_002682851.1| | 5762 | g19267 | i0 | 91.102 | 3.61410788381743 | 236 | 20 | 98 | 1 | 7 | 241 | 11 | 246 | Naegleria gruberi profilin (NAEGRDRAFT_34873), mRNA | blastn | 871 | 318 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 9945593 | 9945593 | PRJNA1086823_P_NODE_4988_length_356_cov_6.024735_g4871_i0 | PRJNA1086823 | 4988 | 356 | 6.024735 | 21.4480566 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 586 | 7.469999999999998e-163 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g4871 | i0 | 96.348 | 11.1348314606742 | 356 | 13 | 100 | 0 | 1 | 356 | 5440 | 5795 | 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 | 3964 | 586 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 11672417 | 11672417 | PRJNA1086823_P_NODE_16630_length_246_cov_0.901734_g16513_i0 | PRJNA1086823 | 16630 | 246 | 0.901734 | 2.21826564 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 344 | 3.27e-90 | NTclustered | gi|290988943|ref|XM_002677084.1| | 5762 | g16513 | i0 | 92.181 | 20.4471544715447 | 243 | 19 | 99 | 0 | 1 | 243 | 1039 | 1281 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_36687), mRNA | blastn | 5030 | 344 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 12947519 | 12947519 | PRJNA1086823_P_NODE_18531_length_243_cov_0.917647_g18414_i0 | PRJNA1086823 | 18531 | 243 | 0.917647 | 2.22988221 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 294 | 3.3e-75 | NTclustered | gi|290985340|ref|XM_002675338.1| | 5762 | g18414 | i0 | 88.525 | 6.0082304526749 | 244 | 27 | 100 | 1 | 1 | 243 | 489 | 246 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82670), mRNA | blastn | 1460 | 294 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 14222587 | 14222587 | PRJNA1086823_P_NODE_5472_length_343_cov_0.866667_g5355_i0 | PRJNA1086823 | 5472 | 343 | 0.866667 | 2.97266781 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 496 | 1.25e-135 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g5355 | i0 | 92.711 | 15.3644314868805 | 343 | 25 | 100 | 0 | 1 | 343 | 48275 | 48617 | Naegleria gruberi mitochondrion, complete genome | blastn | 5270 | 496 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 15045119 | 15045119 | PRJNA1086823_P_NODE_9612_length_276_cov_1.536946_g9495_i0 | PRJNA1086823 | 9612 | 276 | 1.536946 | 4.24197096 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 392 | 1.32e-104 | NTclustered | gi|290988433|ref|XM_002676880.1| | 5762 | g9495 | i0 | 92.701 | 46.518115942029 | 274 | 16 | 99 | 4 | 1 | 272 | 1088 | 1359 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82621), mRNA | blastn | 12839 | 394 | 0.99492385786802 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 21870531 | 21870531 | PRJNA1086823_P_NODE_14678_length_249_cov_0.886364_g14561_i0 | PRJNA1086823 | 14678 | 249 | 0.886364 | 2.20704636 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 340 | 4.29e-89 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g14561 | i0 | 91.498 | 3.98393574297189 | 247 | 21 | 99 | 0 | 3 | 249 | 2467 | 2221 | 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 | 992 | 340 | 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);;