contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1123309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4105271 | 4105271 | PRJNA1123309_P_NODE_27024_length_311_cov_1.680672_g26644_i0 | PRJNA1123309 | 27024 | 311 | 1.680672 | 5.22688992 | Naegleria sp. | 37103 | Heterolobosea | other_Eukaryota | 575 | 1.3899999999999995e-159 | NTclustered | gi|2651357798|gb|PP174311.1| | 37103 | g26644 | i0 | 100 | 44.7781350482315 | 311 | 0 | 100 | 0 | 1 | 311 | 3678 | 3988 | Naegleria sp. isolate 33 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 | 13926 | 575 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria sp. | ||||
| 4105580 | 4105580 | PRJNA1123309_P_NODE_54824_length_249_cov_0.875000_g54444_i0 | PRJNA1123309 | 54824 | 249 | 0.875 | 2.17875 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 198 | 2.74e-46 | NTclustered | gi|2124405484|ref|XM_044686830.1| | 51637 | g54444 | i0 | 82.328 | 3.90361445783133 | 232 | 37 | 92 | 4 | 20 | 249 | 794 | 565 | Naegleria lovaniensis uncharacterized protein (C9374_011200), partial mRNA | blastn | 972 | 198 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 14307542 | 14307542 | PRJNA1123309_P_NODE_6712_length_571_cov_3.124498_g6352_i0 | PRJNA1123309 | 6712 | 571 | 3.124498 | 17.84088358 | Naegleria sp. | 37103 | Heterolobosea | other_Eukaryota | 1050 | 0 | NTclustered | gi|2651357798|gb|PP174311.1| | 37103 | g6352 | i0 | 99.825 | 18.800350262697 | 571 | 1 | 100 | 0 | 1 | 571 | 3638 | 3068 | Naegleria sp. isolate 33 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 | 10735 | 1050 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria sp. | ||||
| 18129781 | 18129781 | PRJNA1123309_P_NODE_11255_length_452_cov_2.751979_g10879_i0 | PRJNA1123309 | 11255 | 452 | 2.751979 | 12.43894508 | Acrasis rosea | 43695 | Heterolobosea | other_Eukaryota | 514 | 4.65e-141 | NTclustered | gi|12083876|gb|AF190771.1|AF190771 | 43695 | g10879 | i0 | 87.253 | 96.1902654867257 | 455 | 52 | 100 | 4 | 1 | 452 | 125 | 576 | Acrasis rosea elongation factor 1 alpha (tef1) gene, partial cds | blastn | 43478 | 514 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis rosea | ||||
| 21954790 | 21954790 | PRJNA1123309_P_NODE_11518_length_447_cov_2.970588_g11142_i0 | PRJNA1123309 | 11518 | 447 | 2.970588 | 13.27852836 | Acrasis rosea | 43695 | Heterolobosea | other_Eukaryota | 431 | 4.76e-116 | NTclustered | gi|12083876|gb|AF190771.1|AF190771 | 43695 | g11142 | i0 | 84.27 | 86.8769574944072 | 445 | 66 | 99 | 4 | 3 | 445 | 593 | 1035 | Acrasis rosea elongation factor 1 alpha (tef1) gene, partial cds | blastn | 38834 | 431 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis rosea | ||||
| 23230431 | 23230431 | PRJNA1123309_P_NODE_21039_length_346_cov_2.282051_g20660_i0 | PRJNA1123309 | 21039 | 346 | 2.282051 | 7.89589646 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 427 | 4.66e-115 | NTclustered | gi|2124407020|ref|XM_044688070.1| | 51637 | g20660 | i0 | 88.986 | 96.5664739884393 | 345 | 38 | 99 | 0 | 2 | 346 | 1128 | 784 | Naegleria lovaniensis uncharacterized protein (C9374_012317), partial mRNA | blastn | 33412 | 427 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 23230873 | 23230873 | PRJNA1123309_P_NODE_61659_length_245_cov_0.895349_g61279_i0 | PRJNA1123309 | 61659 | 245 | 0.895349 | 2.19360505 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 180 | 9.72e-41 | NTclustered | gi|290972987|ref|XM_002669186.1| | 5762 | g61279 | i0 | 81.991 | 10.8816326530612 | 211 | 38 | 86 | 0 | 12 | 222 | 245 | 35 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_56405), mRNA | blastn | 2666 | 180 | 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);;