contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA358009" and tax_phylum = "Euglenozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2948938 | 2948938 | PRJNA358009_P_NODE_7243_length_262_cov_5.492958_g7175_i0 | PRJNA358009 | 7243 | 262 | 5.492958 | 14.39154996 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 446 | 9.379999999999998e-121 | NTclustered | gi|197723537|gb|EF681922.2| | 312471 | g7175 | i0 | 98.054 | 156.408396946565 | 257 | 4 | 98 | 1 | 4 | 260 | 1218 | 963 | Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence | blastn | 40979 | 446 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 5501952 | 5501952 | PRJNA358009_P_NODE_6805_length_323_cov_10.645985_g6742_i0 | PRJNA358009 | 6805 | 323 | 10.645985 | 34.38653155 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 520 | 6.919999999999998e-143 | NTclustered | gi|77994645|gb|DQ207583.1| | 312471 | g6742 | i0 | 95.692 | 102.092879256966 | 325 | 10 | 100 | 3 | 1 | 323 | 1402 | 1080 | Neobodo designis strain HFCC306 18S ribosomal RNA gene, partial sequence | blastn | 32976 | 520 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 5501969 | 5501969 | PRJNA358009_P_NODE_8025_length_210_cov_8.385093_g7956_i0 | PRJNA358009 | 8025 | 210 | 8.385093 | 17.6086953 | Bodo celer | 266813 | Euglenozoa | other_Eukaryota | 305 | 1.28e-78 | NTclustered | gi|45739063|gb|AY490221.1| | 266813 | g7956 | i0 | 92.925 | 100.814285714286 | 212 | 12 | 99 | 3 | 1 | 209 | 1045 | 834 | Bodo celer 18S ribosomal RNA gene, partial sequence | blastn | 21171 | 305 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo celer | ||
| 10601914 | 10601914 | PRJNA358009_P_NODE_12629_length_168_cov_4.142857_g12560_i0 | PRJNA358009 | 12629 | 168 | 4.142857 | 6.95999976 | Petalomonas cantuscygni | 56452 | Euglenozoa | other_Eukaryota | 126 | 8.2e-25 | NTclustered | gi|2228698|gb|U84731.1|PCU84731 | 56452 | g12560 | i0 | 92.222 | 12.6428571428571 | 90 | 6 | 53 | 1 | 74 | 162 | 981 | 892 | Petalomonas cantuscygni small subunit ribosomal RNA gene, complete sequence | blastn | 2124 | 126 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Petalomonadida | Scytomonadidae | Petalomonas | Petalomonas cantuscygni | ||
| 18924510 | 18924510 | PRJNA358009_P_NODE_7035_length_291_cov_4.057851_g6968_i0 | PRJNA358009 | 7035 | 291 | 4.057851 | 11.80834641 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 281 | 3.16e-71 | NTclustered | gi|2414483|emb|Y00055.1| | 5656 | g6968 | i0 | 90.323 | 86.0378006872852 | 217 | 18 | 74 | 2 | 70 | 284 | 7051 | 6836 | Crithidia fasciculata ribosomal DNA repeat (complete) | blastn | 25037 | 281 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Crithidia | Crithidia fasciculata | ||
| 22074841 | 22074841 | PRJNA358009_P_NODE_2258_length_327_cov_5.737410_g2195_i0 | PRJNA358009 | 2258 | 327 | 5.73741 | 18.7613307 | Trypanosomatidae sp. | 1737640 | Euglenozoa | other_Eukaryota | 193 | 1.74e-44 | NTclustered | gi|2022380703|gb|MW874580.1| | 1737640 | g2195 | i0 | 97.345 | 75.6177370030581 | 113 | 3 | 63 | 0 | 214 | 326 | 688 | 800 | Trypanosomatidae sp. isolate DN404 large subunit ribosomal RNA gene, partial sequence | blastn | 24727 | 193 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosomatidae sp. | |||
| 22074928 | 22074928 | PRJNA358009_P_NODE_9398_length_186_cov_3.912409_g9329_i0 | PRJNA358009 | 9398 | 186 | 3.912409 | 7.27708074 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 289 | 1.11e-73 | NTclustered | gi|59891960|gb|AY753620.1| | 312471 | g9329 | i0 | 96.067 | 95.6666666666667 | 178 | 6 | 96 | 1 | 3 | 180 | 1769 | 1593 | Neobodo designis isolate TeToto3 18S ribosomal RNA gene, partial sequence | blastn | 17794 | 289 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis |
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);;