contig_metadata
10 rows where bioproject = "PRJNA784979" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5869018 | 5869018 | PRJNA784979_S_NODE_10265_length_167_cov_1.016949_g10223_i0 | PRJNA784979 | 10265 | 167 | 1.016949 | 1.69830483 | Neometanema larsenii | 2704089 | Euglenozoa | other_Eukaryota | 174 | 2.87e-39 | NTclustered | gi|1803019511|gb|MT007897.1| | 2704089 | g10223 | i0 | 90.909 | 2.67664670658683 | 132 | 9 | 78 | 3 | 3 | 133 | 1804 | 1675 | Neometanema larsenii isolate SDB8 small subunit ribosomal RNA gene, partial sequence | blastn | 447 | 174 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Neometanema | Neometanema larsenii | ||||
| 8418708 | 8418708 | PRJNA784979_S_NODE_9787_length_169_cov_1.950000_g9745_i0 | PRJNA784979 | 9787 | 169 | 1.95 | 3.2955 | Entosiphon sp. | 1921133 | Euglenozoa | other_Eukaryota | 255 | 1e-63 | NTclustered | gi|1547024950|gb|MK213406.1| | 1921133 | g9745 | i0 | 95.092 | 33.0414201183432 | 163 | 7 | 96 | 1 | 7 | 169 | 631 | 470 | Entosiphon sp. strain ESC small subunit ribosomal RNA, partial sequence | blastn | 5584 | 255 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Entosiphon | Entosiphon sp. | ||
| 12245138 | 12245138 | PRJNA784979_S_NODE_4470_length_224_cov_1.491429_g4428_i0 | PRJNA784979 | 4470 | 224 | 1.491429 | 3.34080096 | Sphenomonas teres | 2704098 | Euglenozoa | other_Eukaryota | 313 | 8.27e-81 | NTclustered | gi|1803019522|gb|MT007908.1| | 2704098 | g4428 | i0 | 97.79 | 14.2321428571429 | 181 | 4 | 81 | 0 | 44 | 224 | 1137 | 1317 | Sphenomonas teres isolate UJL10 small subunit ribosomal RNA gene, partial sequence | blastn | 3188 | 313 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Petalomonadida | Sphenomonadidae | Sphenomonas | Sphenomonas teres | ||
| 16068074 | 16068074 | PRJNA784979_S_NODE_5353_length_210_cov_0.819876_g5311_i0 | PRJNA784979 | 5353 | 210 | 0.819876 | 1.7217396 | Keelungia nitschei | 2529305 | Euglenozoa | other_Eukaryota | 124 | 3.85e-24 | NTclustered | gi|1581142783|gb|MK567808.1| | 2529305 | g5311 | i0 | 85.246 | 54.9285714285714 | 122 | 17 | 58 | 1 | 83 | 203 | 1477 | 1598 | Keelungia nitschei strain HFCC166 large subunit ribosomal RNA gene, partial sequence | blastn | 11535 | 124 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Heteronematidae | Keelungia | Keelungia nitschei | ||
| 19892397 | 19892397 | PRJNA784979_S_NODE_7496_length_186_cov_1.430657_g7454_i0 | PRJNA784979 | 7496 | 186 | 1.430657 | 2.66102202 | Sphenomonas teres | 2704098 | Euglenozoa | other_Eukaryota | 281 | 1.86e-71 | NTclustered | gi|1803019522|gb|MT007908.1| | 2704098 | g7454 | i0 | 93.75 | 4.02688172043011 | 192 | 5 | 99 | 2 | 1 | 185 | 822 | 1013 | Sphenomonas teres isolate UJL10 small subunit ribosomal RNA gene, partial sequence | blastn | 749 | 281 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Petalomonadida | Sphenomonadidae | Sphenomonas | Sphenomonas teres | ||
| 21168103 | 21168103 | PRJNA784979_S_NODE_8657_length_177_cov_0.898438_g8615_i0 | PRJNA784979 | 8657 | 177 | 0.898438 | 1.59023526 | Neometanema larsenii | 2704089 | Euglenozoa | other_Eukaryota | 191 | 3.04e-44 | NTclustered | gi|1803019511|gb|MT007897.1| | 2704089 | g8615 | i0 | 87.5 | 6.58757062146893 | 168 | 17 | 94 | 4 | 8 | 174 | 611 | 447 | Neometanema larsenii isolate SDB8 small subunit ribosomal RNA gene, partial sequence | blastn | 1166 | 191 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Neometanema | Neometanema larsenii | ||||
| 21615600 | 21615600 | PRJNA784979_S_NODE_5157_length_212_cov_2.828221_g5115_i0 | PRJNA784979 | 5157 | 212 | 2.828221 | 5.99582852 | Entosiphon | 101492 | Euglenozoa | other_Eukaryota | 263 | 7.909999999999999e-66 | NTclustered | gi|37542663|gb|AY061999.1| | 101493 | g5115 | i0 | 89.524 | 4.38679245283019 | 210 | 18 | 98 | 4 | 3 | 210 | 2096 | 1889 | Entosiphon sulcatum small subunit ribosomal RNA gene, partial sequence | blastn | 930 | 263 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Entosiphon | Entosiphon sulcatum | ||
| 22442889 | 22442889 | PRJNA784979_S_NODE_7138_length_189_cov_2.635714_g7096_i0 | PRJNA784979 | 7138 | 189 | 2.635714 | 4.98149946 | Entosiphon sp. | 1921133 | Euglenozoa | other_Eukaryota | 206 | 1.1799999999999999e-48 | NTclustered | gi|1547024950|gb|MK213406.1| | 1921133 | g7096 | i0 | 88 | 5.52910052910053 | 175 | 19 | 92 | 2 | 10 | 183 | 1330 | 1157 | Entosiphon sp. strain ESC small subunit ribosomal RNA, partial sequence | blastn | 1045 | 206 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Entosiphon | Entosiphon sp. | ||
| 22891048 | 22891048 | PRJNA784979_S_NODE_4838_length_218_cov_0.650888_g4796_i0 | PRJNA784979 | 4838 | 218 | 0.650888 | 1.41893584 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 350 | 6.1e-92 | NTclustered | gi|2421781508|ref|XR_008254837.1| | 5693 | g4796 | i0 | 97.115 | 102.628440366972 | 208 | 5 | 95 | 1 | 9 | 215 | 312 | 105 | Trypanosoma cruzi ribosomal RNA large subunit beta, 5' partial (Tc00.1047053473001.10), partial rRNA | blastn | 22373 | 350 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 24165050 | 24165050 | PRJNA784979_S_NODE_9399_length_172_cov_0.967480_g9357_i0 | PRJNA784979 | 9399 | 172 | 0.96748 | 1.6640656 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 281 | 1.69e-71 | NTclustered | gi|225216789|gb|FJ176704.1| | 75058 | g9357 | i0 | 99.355 | 132.313953488372 | 155 | 1 | 90 | 0 | 12 | 166 | 213 | 367 | Bodo saltans HFCC12 28S ribosomal RNA gene, partial sequence | blastn | 22758 | 281 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans |
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);;