contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA599026" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2416716 | 2416716 | PRJNA599026_S_NODE_69782_length_161_cov_0.910714_g69326_i0 | PRJNA599026 | 69782 | 161 | 0.910714 | 1.46624954 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 87.9 | 3.67e-13 | NTclustered | gi|150026606|gb|EF457295.1| | 449968 | g69326 | i0 | 88 | 38.2049689440994 | 75 | 7 | 47 | 2 | 1 | 75 | 196 | 124 | Trypanosoma sp. 364 18S ribosomal RNA gene, partial sequence | blastn | 6151 | 87.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma sp. 364 | ||
| 5675132 | 5675132 | PRJNA599026_S_NODE_10305_length_305_cov_1.593750_g9849_i0 | PRJNA599026 | 10305 | 305 | 1.59375 | 4.8609375 | Trypanosoma cruzi | 5693 | Euglenozoa | other_Eukaryota | 479 | 1.1e-130 | NTclustered | gi|1031970241|gb|CP015675.1| | 85057 | g9849 | i0 | 95.098 | 117.881967213115 | 306 | 12 | 99 | 3 | 2 | 305 | 437683 | 437379 | Trypanosoma cruzi cruzi strain Sylvio X10/cl1 chromosome TcI25, partial sequence | blastn | 35954 | 479 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 5675861 | 5675861 | PRJNA599026_S_NODE_9025_length_323_cov_1.649635_g8569_i0 | PRJNA599026 | 9025 | 323 | 1.649635 | 5.32832105 | Leishmania major | 5664 | Euglenozoa | other_Eukaryota | 117 | 1.06e-21 | NTclustered | gi|2728023139|pdb|8OVJ|5 | 347515 | g8569 | i0 | 95.833 | 22.4365325077399 | 72 | 3 | 22 | 0 | 252 | 323 | 3 | 74 | Chain 5, SR4_chain_5 | blastn | 7247 | 117 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania major | ||
| 11344661 | 11344661 | PRJNA599026_S_NODE_5929_length_392_cov_2.411079_g5473_i0 | PRJNA599026 | 5929 | 392 | 2.411079 | 9.45142968 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.1 | 6.23e-5 | NTclustered | gi|1673144688|ref|XM_029375141.1| | 83891 | g5473 | i0 | 97.222 | 0.454081632653061 | 36 | 1 | 9 | 0 | 286 | 321 | 144 | 109 | Trypanosoma conorhini centrin (Tco025E_08287), partial mRNA | blastn | 178 | 62.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma conorhini | ||
| 12051089 | 12051089 | PRJNA599026_S_NODE_57630_length_165_cov_0.879310_g57174_i0 | PRJNA599026 | 57630 | 165 | 0.87931 | 1.4508615 | Leishmania martiniquensis | 1580590 | Euglenozoa | other_Eukaryota | 86.1 | 1.36e-12 | NTclustered | gi|2787685306|ref|XM_067319584.1| | 1580590 | g57174 | i0 | 83.333 | 0.581818181818182 | 96 | 12 | 57 | 4 | 70 | 163 | 1616 | 1523 | Leishmania martiniquensis uncharacterized protein (LSCM1_01989), partial mRNA | blastn | 96 | 86.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania martiniquensis | ||
| 13325900 | 13325900 | PRJNA599026_S_NODE_60471_length_164_cov_0.886957_g60015_i0 | PRJNA599026 | 60471 | 164 | 0.886957 | 1.45460948 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|290979697|ref|XM_002672524.1| | 5762 | g60015 | i0 | 100 | 0.182926829268293 | 30 | 0 | 18 | 0 | 135 | 164 | 996 | 967 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_59159), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 18423816 | 18423816 | PRJNA599026_S_NODE_52555_length_167_cov_0.864407_g52099_i0 | PRJNA599026 | 52555 | 167 | 0.864407 | 1.44355969 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 137 | 3.76e-28 | NTclustered | gi|290979815|ref|XM_002672583.1| | 5762 | g52099 | i0 | 82.036 | 1 | 167 | 24 | 100 | 3 | 1 | 167 | 320 | 480 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_59183), mRNA | blastn | 167 | 137 | 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);;