contig_metadata
8 rows where bioproject = "PRJNA922890", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1252040 | 1252040 | PRJNA922890_P_NODE_77841_length_231_cov_0.888889_g77431_i0 | PRJNA922890 | 77841 | 231 | 0.888889 | 2.05333359 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 78.2 | 9.87e-15 | NR | KAL0484321.1 | 1008807 | g77431 | i0 | 59.4 | 2.71428571428571 | 69 | 24 | 84.4 | 1 | 17 | 211 | 1 | 69 | KAL0484321.1 seryl tRS [Acrasis kona] | diamond | 627 | 78.2 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 12376610 | 12376610 | PRJNA922890_P_NODE_12910_length_532_cov_2.710583_g12503_i0 | PRJNA922890 | 12910 | 532 | 2.710583 | 14.42030156 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 196 | 2.889999999999999e-55 | NR | XP_044541595.1 | 51637 | g12503 | i0 | 50.3 | 3.06203007518797 | 181 | 85 | 99.8 | 2 | 532 | 2 | 135 | 314 | XP_044541595.1 uncharacterized protein C9374_014273, partial [Naegleria lovaniensis] | diamond | 1629 | 196 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 13652274 | 13652274 | PRJNA922890_P_NODE_72891_length_233_cov_0.890244_g72481_i0 | PRJNA922890 | 72891 | 233 | 0.890244 | 2.07426852 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 381 | 2.3399999999999995e-101 | NTclustered | gi|290981899|ref|XM_002673623.1| | 5762 | g72481 | i0 | 96.137 | 1 | 233 | 9 | 100 | 0 | 1 | 233 | 447 | 679 | Naegleria gruberi arginine methyltransferase (NAEGRDRAFT_80851), partial mRNA | blastn | 233 | 381 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28137566 | 28137566 | PRJNA922890_P_NODE_84345_length_226_cov_2.222930_g83935_i0 | PRJNA922890 | 84345 | 226 | 2.22293 | 5.0238218 | root | 1 | Root_unresolved | Root_unresolved | 108 | 1.15e-25 | NR | XP_044563775.1 | 5763 | g83935 | i0 | 63 | 3.87610619469027 | 73 | 27 | 96.9 | 0 | 221 | 3 | 233 | 305 | XP_044563775.1 Catalase, putative [Naegleria fowleri] | diamond | 876 | 108 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28548102 | 28548102 | PRJNA922890_P_NODE_76247_length_232_cov_0.883436_g75837_i0 | PRJNA922890 | 76247 | 232 | 0.883436 | 2.04957152 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.9 | 1.23e-15 | NR | XP_002676815.1 | 5762 | g75837 | i0 | 42.9 | 9.85344827586207 | 77 | 44 | 99.6 | 0 | 1 | 231 | 1021 | 1097 | XP_002676815.1 FH2 domain-containing protein [Naegleria gruberi] | diamond | 2286 | 81.6 | 0.991421568627451 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29961473 | 29961473 | PRJNA922890_P_NODE_55231_length_263_cov_1.231959_g54821_i0 | PRJNA922890 | 55231 | 263 | 1.231959 | 3.24005217 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 62.8 | 4.23e-9 | NR | KAL0478177.1 | 1008807 | g54821 | i0 | 36.9 | 0.958174904942966 | 84 | 53 | 95.8 | 0 | 1 | 252 | 407 | 490 | KAL0478177.1 RNAi component PIWI/Argonaut [Acrasis kona] | diamond | 252 | 62.8 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31169154 | 31169154 | PRJNA922890_P_NODE_77215_length_231_cov_0.901235_g76805_i0 | PRJNA922890 | 77215 | 231 | 0.901235 | 2.08185285 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.8 | 4.88e-11 | NR | KAL0489675.1 | 1008807 | g76805 | i0 | 52.4 | 1.71428571428571 | 63 | 29 | 80.5 | 1 | 10 | 195 | 424 | 486 | KAL0489675.1 hypothetical protein AKO1_009120 [Acrasis kona] | diamond | 396 | 68.2 | 0.994134897360704 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32371597 | 32371597 | PRJNA922890_P_NODE_77859_length_231_cov_0.888889_g77449_i0 | PRJNA922890 | 77859 | 231 | 0.888889 | 2.05333359 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 123 | 1.15e-30 | NR | XP_002681804.1 | 5762 | g77449 | i0 | 76.3 | 27.5844155844156 | 76 | 18 | 98.7 | 0 | 2 | 229 | 465 | 540 | XP_002681804.1 eukaryotic elongation factor 1 alpha family protein [Naegleria gruberi] | diamond | 6372 | 123 | 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);;