contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA909412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 890689 | 890689 | PRJNA909412_P_NODE_6781_length_202_cov_2.226994_g6640_i0 | PRJNA909412 | 6781 | 202 | 2.226994 | 4.49852788 | Petalomonas cantuscygni | 56452 | Euglenozoa | other_Eukaryota | 257 | 3.47e-64 | NTclustered | gi|1803019099|gb|MT007871.1| | 56452 | g6640 | i0 | 97.973 | 38.5940594059406 | 148 | 3 | 73 | 0 | 1 | 148 | 1168 | 1021 | Petalomonas cantuscygni strain CCAP 1259/1 small subunit ribosomal RNA gene, partial sequence | blastn | 7796 | 257 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Petalomonadida | Scytomonadidae | Petalomonas | Petalomonas cantuscygni | ||
| 2165960 | 2165960 | PRJNA909412_P_NODE_10502_length_172_cov_2.879699_g10361_i0 | PRJNA909412 | 10502 | 172 | 2.879699 | 4.95308228 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 95.3 | 2.36e-15 | NTclustered | gi|2119416825|ref|XM_044686971.1| | 51637 | g10361 | i0 | 87.654 | 9.09883720930233 | 81 | 10 | 47 | 0 | 1 | 81 | 579 | 659 | Naegleria lovaniensis uncharacterized protein (C9374_011328), partial mRNA | blastn | 1565 | 95.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 9818600 | 9818600 | PRJNA909412_P_NODE_8908_length_179_cov_1.742857_g8767_i0 | PRJNA909412 | 8908 | 179 | 1.742857 | 3.11971403 | Euglena agilis | 96764 | Euglenozoa | other_Eukaryota | 300 | 4.9e-77 | NTclustered | gi|388269618|gb|JQ398653.1| | 96764 | g8767 | i0 | 97.175 | 55.4078212290503 | 177 | 5 | 99 | 0 | 3 | 179 | 193 | 369 | Euglena agilis strain ACOI 1232 large subunit ribosomal RNA gene, partial sequence | blastn | 9918 | 300 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena agilis | ||
| 11452926 | 11452926 | PRJNA909412_P_NODE_16749_length_151_cov_2.616071_g16608_i0 | PRJNA909412 | 16749 | 151 | 2.616071 | 3.95026721 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 254 | 3.15e-63 | NTclustered | gi|60687330|gb|AY821957.1| | 315795 | g16608 | i0 | 100 | 49.6622516556291 | 137 | 0 | 91 | 0 | 15 | 151 | 961 | 1097 | Uncultured Sphenomonadales clone CH1_S2_16 small subunit ribosomal RNA gene, partial sequence | blastn | 7499 | 254 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Petalomonadida | uncultured Sphenomonadales | ||||
| 14918700 | 14918700 | PRJNA909412_P_NODE_7272_length_196_cov_1.541401_g7131_i0 | PRJNA909412 | 7272 | 196 | 1.541401 | 3.02114596 | Neobodo sp. | 2815825 | Euglenozoa | other_Eukaryota | 239 | 1.21e-58 | NTclustered | gi|1996609214|gb|MW694333.1| | 2815825 | g7131 | i0 | 88.776 | 2.85204081632653 | 196 | 20 | 99 | 1 | 1 | 194 | 880 | 685 | Neobodo sp. isolate G08 small subunit ribosomal RNA gene, partial sequence | blastn | 559 | 239 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo sp. | |||
| 17468907 | 17468907 | PRJNA909412_P_NODE_11974_length_165_cov_1.309524_g11833_i0 | PRJNA909412 | 11974 | 165 | 1.309524 | 2.1607146 | Naegleria australiensis | 51634 | Heterolobosea | other_Eukaryota | 300 | 4.46e-77 | NTclustered | gi|2476253407|gb|OQ627480.1| | 51634 | g11833 | i0 | 99.394 | 27.7212121212121 | 165 | 1 | 100 | 0 | 1 | 165 | 2676 | 2512 | Naegleria australiensis strain PP397 rDNA-containing extrachromosomal element genomic sequence; small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and non-ribosomal sequence | blastn | 4574 | 300 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria australiensis | ||||
| 17468935 | 17468935 | PRJNA909412_P_NODE_15934_length_153_cov_1.342105_g15793_i0 | PRJNA909412 | 15934 | 153 | 1.342105 | 2.05342065 | Andalucia godoyi | 505711 | Root_unresolved | Root_unresolved | 65.8 | 1.61e-6 | NTclustered | gi|484759855|ref|NC_021124.1| | 505711 | g15793 | i0 | 82.051 | 0.509803921568627 | 78 | 13 | 51 | 1 | 76 | 153 | 402 | 478 | Andalucia godoyi strain ATCC PRA-185 mitochondrion, complete genome | blastn | 78 | 65.8 | 1 | Eukaryota | Discoba | Jakobida | Andaluciidae | Andalucia | Andalucia godoyi | ||||
| 17468941 | 17468941 | PRJNA909412_P_NODE_16454_length_152_cov_1.486726_g16313_i0 | PRJNA909412 | 16454 | 152 | 1.486726 | 2.25982352 | Trachelomonas sp. Bidduk050909G | 1685802 | Euglenozoa | other_Eukaryota | 178 | 1.9699999999999993e-40 | NTclustered | gi|944274410|gb|KT305094.1| | 1685802 | g16313 | i0 | 88.435 | 93.8881578947368 | 147 | 17 | 97 | 0 | 1 | 147 | 318 | 172 | Trachelomonas sp. Bidduk050909G small subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 14271 | 178 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Trachelomonas | Trachelomonas sp. Bidduk050909G | ||
| 21651413 | 21651413 | PRJNA909412_P_NODE_5417_length_224_cov_1.383784_g5276_i0 | PRJNA909412 | 5417 | 224 | 1.383784 | 3.09967616 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 239 | 1.42e-58 | NTclustered | gi|2593250474|emb|OY748421.1| | 5660 | g5276 | i0 | 85.903 | 113.732142857143 | 227 | 29 | 100 | 3 | 1 | 224 | 989893 | 990119 | Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27 | blastn | 25476 | 239 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis | ||
| 22567831 | 22567831 | PRJNA909412_P_NODE_5278_length_227_cov_2.106383_g5137_i0 | PRJNA909412 | 5278 | 227 | 2.106383 | 4.78148941 | Parafumarolamoeba stagnalis | 2872509 | Heterolobosea | other_Eukaryota | 267 | 6.63e-67 | NTclustered | gi|2086087549|gb|MZ919148.1| | 2872509 | g5137 | i0 | 87.826 | 3.04845814977974 | 230 | 25 | 100 | 3 | 1 | 227 | 805 | 576 | Parafumarolamoeba stagnalis small subunit ribosomal RNA gene, partial sequence | blastn | 692 | 267 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Parafumarolamoeba | Parafumarolamoeba stagnalis | ||||
| 23842941 | 23842941 | PRJNA909412_P_NODE_3259_length_291_cov_3.218254_g3118_i0 | PRJNA909412 | 3259 | 291 | 3.218254 | 9.36511914 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 132 | 3.37e-26 | NTclustered | gi|290996811|ref|XM_002680930.1| | 5762 | g3118 | i0 | 83.803 | 3.6254295532646 | 142 | 19 | 48 | 4 | 128 | 267 | 1611 | 1472 | Naegleria gruberi aldehyde dehydrogenase (NAEGRDRAFT_35633), mRNA | blastn | 1055 | 132 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 25116755 | 25116755 | PRJNA909412_P_NODE_5580_length_221_cov_1.730769_g5439_i0 | PRJNA909412 | 5580 | 221 | 1.730769 | 3.82499949 | Naegleria pringsheimi | 234921 | Heterolobosea | other_Eukaryota | 409 | 1.0100000000000001e-109 | NTclustered | gi|2515557648|gb|OR045415.1| | 234921 | g5439 | i0 | 100 | 50.4932126696833 | 221 | 0 | 100 | 0 | 1 | 221 | 4003 | 4223 | 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 | 11159 | 409 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria pringsheimi |
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);;