contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA774958" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3303793 | 3303793 | PRJNA774958_P_NODE_27583_length_289_cov_1.768519_g27336_i0 | PRJNA774958 | 27583 | 289 | 1.768519 | 5.1110199100000004 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 346 | 1.1e-90 | NTclustered | gi|290991746|ref|XM_002678450.1| | 5762 | g27336 | i0 | 88.176 | 1.0242214532872 | 296 | 28 | 100 | 2 | 1 | 289 | 319 | 24 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_66128), partial mRNA | blastn | 296 | 346 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 3303813 | 3303813 | PRJNA774958_P_NODE_28943_length_280_cov_1.487923_g28696_i0 | PRJNA774958 | 28943 | 280 | 1.487923 | 4.1661844 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 385 | 2.24e-102 | NTclustered | gi|290992577|ref|XM_002678865.1| | 5762 | g28696 | i0 | 92.83 | 0.946428571428571 | 265 | 19 | 95 | 0 | 1 | 265 | 265 | 1 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_83081), partial mRNA | blastn | 265 | 385 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 8405706 | 8405706 | PRJNA774958_P_NODE_21367_length_343_cov_1.137037_g21120_i0 | PRJNA774958 | 21367 | 343 | 1.137037 | 3.90003691 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 579 | 1.1999999999999996e-160 | NTclustered | gi|290995766|ref|XM_002680408.1| | 5762 | g21120 | i0 | 97.085 | 3.97376093294461 | 343 | 10 | 100 | 0 | 1 | 343 | 406 | 64 | Naegleria gruberi 60S ribosomal protein L13 (NAEGRDRAFT_35692), mRNA | blastn | 1363 | 579 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13506419 | 13506419 | PRJNA774958_P_NODE_30831_length_267_cov_1.092784_g30584_i0 | PRJNA774958 | 30831 | 267 | 1.092784 | 2.91773328 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 472 | 1.5799999999999998e-128 | NTclustered | gi|290971318|ref|XM_002668414.1| | 5762 | g30584 | i0 | 98.502 | 100.022471910112 | 267 | 4 | 100 | 0 | 1 | 267 | 10 | 276 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_61055), partial mRNA | blastn | 26706 | 472 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13506467 | 13506467 | PRJNA774958_P_NODE_34971_length_248_cov_0.880000_g34724_i0 | PRJNA774958 | 34971 | 248 | 0.88 | 2.1824 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 315 | 2.59e-81 | NTclustered | gi|291001052|ref|XM_002683047.1| | 5762 | g34724 | i0 | 91.304 | 0.92741935483871 | 230 | 20 | 93 | 0 | 2 | 231 | 2281 | 2510 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_61244), partial mRNA | blastn | 230 | 315 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 17330881 | 17330881 | PRJNA774958_P_NODE_22914_length_328_cov_1.207843_g22667_i0 | PRJNA774958 | 22914 | 328 | 1.207843 | 3.96172504 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 331 | 3.54e-86 | NTclustered | gi|1002458651|ref|XM_015797866.1| | 157538 | g22667 | i0 | 86.601 | 25.8079268292683 | 306 | 33 | 92 | 8 | 19 | 320 | 80 | 381 | Leptomonas pyrrhocoris putative Ribosomal protein l3 mRNA | blastn | 8465 | 331 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 19879609 | 19879609 | PRJNA774958_P_NODE_37316_length_244_cov_0.900585_g37069_i0 | PRJNA774958 | 37316 | 244 | 0.900585 | 2.1974274 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 351 | 1.9399999999999998e-92 | NTclustered | gi|290986269|ref|XM_002675801.1| | 5762 | g37069 | i0 | 92.623 | 1 | 244 | 18 | 100 | 0 | 1 | 244 | 1750 | 1993 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_49917), partial mRNA | blastn | 244 | 351 | 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);;