contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA401346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4241372 | 4241372 | PRJNA401346_P_NODE_6244_length_209_cov_0.864865_g6223_i0 | PRJNA401346 | 6244 | 209 | 0.864865 | 1.80756785 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 124 | 1.04e-31 | NR | KAL0488048.1 | 1008807 | g6223 | i0 | 88.4 | 1.98086124401914 | 69 | 8 | 99 | 0 | 209 | 3 | 343 | 411 | KAL0488048.1 isocitrate dehydrogenase, mitochondrial [Acrasis kona] | diamond | 414 | 124 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 10618087 | 10618087 | PRJNA401346_P_NODE_2029_length_348_cov_1.114983_g2008_i0 | PRJNA401346 | 2029 | 348 | 1.114983 | 3.88014084 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 167 | 3.35e-50 | NR | KAL0478911.1 | 1008807 | g2008 | i0 | 65.2 | 0.991379310344828 | 115 | 40 | 99.1 | 0 | 346 | 2 | 36 | 150 | KAL0478911.1 ribosomal protein L9 [Acrasis kona] | diamond | 345 | 167 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 10618161 | 10618161 | PRJNA401346_P_NODE_4449_length_252_cov_1.460733_g4428_i0 | PRJNA401346 | 4449 | 252 | 1.460733 | 3.68104716 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99.4 | 1.97e-24 | NR | XP_044563356.1 | 5763 | g4428 | i0 | 68.8 | 1.89285714285714 | 80 | 24 | 94 | 1 | 238 | 2 | 1 | 80 | XP_044563356.1 uncharacterized protein FDP41_002463 [Naegleria fowleri] | diamond | 477 | 100 | 0.994 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 19539963 | 19539963 | PRJNA401346_P_NODE_2656_length_311_cov_1.004000_g2635_i0 | PRJNA401346 | 2656 | 311 | 1.004 | 3.12244 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 187 | 2.71e-59 | NR | KAL0486015.1 | 1008807 | g2635 | i0 | 93.9 | 0.945337620578778 | 98 | 6 | 94.5 | 0 | 295 | 2 | 1 | 98 | KAL0486015.1 ribosomal protein S26 [Acrasis kona] | diamond | 294 | 187 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 19540052 | 19540052 | PRJNA401346_P_NODE_5856_length_217_cov_2.044872_g5835_i0 | PRJNA401346 | 5856 | 217 | 2.044872 | 4.43737224 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 103 | 1.6e-26 | NR | KAL0487562.1 | 1008807 | g5835 | i0 | 78.1 | 0.884792626728111 | 64 | 14 | 88.5 | 0 | 193 | 2 | 1 | 64 | KAL0487562.1 profilin [Acrasis kona] | diamond | 192 | 103 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 22090754 | 22090754 | PRJNA401346_P_NODE_6378_length_209_cov_0.864865_g6357_i0 | PRJNA401346 | 6378 | 209 | 0.864865 | 1.80756785 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 124 | 2.08e-34 | NR | KAL0479838.1 | 1008807 | g6357 | i0 | 92.6 | 0.976076555023923 | 68 | 5 | 97.6 | 0 | 208 | 5 | 89 | 156 | KAL0479838.1 ribosomal protein S18 [Acrasis kona] | diamond | 204 | 124 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27597836 | 27597836 | PRJNA401346_P_NODE_3344_length_284_cov_1.390135_g3323_i0 | PRJNA401346 | 3344 | 284 | 1.390135 | 3.9479834 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 6.05e-25 | NR | XP_044562399.1 | 5763 | g3323 | i0 | 57.5 | 5.61971830985915 | 87 | 37 | 91.9 | 0 | 24 | 284 | 6 | 92 | XP_044562399.1 uncharacterized protein FDP41_003008 [Naegleria fowleri] | diamond | 1596 | 103 | 0.990291262135922 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28370242 | 28370242 | PRJNA401346_P_NODE_3266_length_287_cov_1.128319_g3245_i0 | PRJNA401346 | 3266 | 287 | 1.128319 | 3.23827553 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 102 | 1.2499999999999999e-23 | NR | XP_002677623.1 | 5762 | g3245 | i0 | 48.5 | 1.05574912891986 | 101 | 45 | 98.3 | 1 | 282 | 1 | 159 | 259 | XP_002677623.1 cathepsin B [Naegleria gruberi] | diamond | 303 | 102 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28970235 | 28970235 | PRJNA401346_P_NODE_7288_length_206_cov_0.882759_g7267_i0 | PRJNA401346 | 7288 | 206 | 0.882759 | 1.81848354 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 113 | 2.6900000000000003e-27 | NR | XP_002675074.1 | 5762 | g7267 | i0 | 73.5 | 0.990291262135922 | 68 | 18 | 99 | 0 | 3 | 206 | 917 | 984 | XP_002675074.1 uncharacterized protein NAEGRDRAFT_50569 [Naegleria gruberi] | diamond | 204 | 113 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31624006 | 31624006 | PRJNA401346_P_NODE_8856_length_201_cov_0.914286_g8835_i0 | PRJNA401346 | 8856 | 201 | 0.914286 | 1.83771486 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 109 | 6.84e-26 | NR | XP_002678635.1 | 5762 | g8835 | i0 | 73.1 | 2 | 67 | 18 | 100 | 0 | 1 | 201 | 459 | 525 | XP_002678635.1 asparaginyl-tRNA synthetase [Naegleria gruberi] | diamond | 402 | 109 | 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);;