contig_metadata
8 rows where bioproject = "PRJNA326068", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1664120 | 1664120 | PRJNA326068_P_NODE_11602_length_279_cov_4.280000_g10640_i0 | PRJNA326068 | 11602 | 279 | 4.28 | 11.9412 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 499 | 7.63e-137 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g10640 | i0 | 98.925 | 53.4982078853047 | 279 | 3 | 100 | 0 | 1 | 279 | 2868 | 2590 | 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 | 14926 | 499 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 8042716 | 8042716 | PRJNA326068_P_NODE_3167_length_619_cov_4.964407_g2501_i0 | PRJNA326068 | 3167 | 619 | 4.964407 | 30.72967933 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 963 | 0 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g2501 | i0 | 94.959 | 18.3004846526656 | 615 | 30 | 99 | 1 | 1 | 615 | 2463 | 1850 | 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 | 11328 | 963 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 14418256 | 14418256 | PRJNA326068_P_NODE_13412_length_244_cov_1.548837_g12449_i0 | PRJNA326068 | 13412 | 244 | 1.548837 | 3.77916228 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 111 | 3.58e-20 | NTclustered | gi|2119429492|ref|XM_044701888.1| | 5763 | g12449 | i0 | 88.889 | 27.0040983606557 | 90 | 10 | 37 | 0 | 154 | 243 | 95 | 184 | Naegleria fowleri uncharacterized protein (FDP41_011476), partial mRNA | blastn | 6589 | 111 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 16966765 | 16966765 | PRJNA326068_P_NODE_13254_length_247_cov_2.197248_g12291_i0 | PRJNA326068 | 13254 | 247 | 2.197248 | 5.42720256 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 137 | 8.2e-40 | NR | KAL0481688.1 | 1008807 | g12291 | i0 | 86.6 | 0.995951417004049 | 82 | 11 | 99.6 | 0 | 1 | 246 | 24 | 105 | KAL0481688.1 ribosomal protein S25 [Acrasis kona] | diamond | 246 | 137 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 16966770 | 16966770 | PRJNA326068_P_NODE_1514_length_867_cov_5.328162_g567_i1 | PRJNA326068 | 1514 | 867 | 5.328162 | 46.19516454 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 1380 | 0 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g567 | i1 | 96.318 | 68.2156862745098 | 842 | 27 | 97 | 4 | 1 | 839 | 3576 | 2736 | 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 | 59143 | 1380 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 19515307 | 19515307 | PRJNA326068_P_NODE_2376_length_708_cov_3.441826_g1817_i0 | PRJNA326068 | 2376 | 708 | 3.441826 | 24.36812808 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 1170 | 0 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g1817 | i0 | 96.474 | 22.7429378531073 | 709 | 24 | 100 | 1 | 1 | 708 | 4322 | 3614 | 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 | 16102 | 1170 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 22746074 | 22746074 | PRJNA326068_P_NODE_1438_length_884_cov_67.104094_g1045_i0 | PRJNA326068 | 1438 | 884 | 67.104094 | 593.20019096 | root | 1 | Root_unresolved | Root_unresolved | 65.8 | 1.15e-5 | NTclustered | gi|38606345|gb|AY376153.1| | 5762 | g1045 | i0 | 97.368 | 1.95588235294118 | 38 | 1 | 4 | 0 | 631 | 668 | 1048 | 1011 | Naegleria gruberi isolate 7860 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 1729 | 65.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 22746089 | 22746089 | PRJNA326068_P_NODE_4818_length_503_cov_3.487342_g4011_i0 | PRJNA326068 | 4818 | 503 | 3.487342 | 17.54133026 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 902 | 0 | NTclustered | gi|399764157|gb|JQ271668.1| | 1217110 | g4011 | i0 | 99.006 | 82.3677932405567 | 503 | 5 | 100 | 0 | 1 | 503 | 1509 | 2011 | Allovahlkampfia sp. PKD 2011a strain 4165 18S ribosomal RNA gene, partial sequence | blastn | 41431 | 902 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. PKD 2011a |
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);;