contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904369 | 1904369 | PRJNA662254_P_NODE_25062_length_330_cov_1.116732_g24411_i0 | PRJNA662254 | 25062 | 330 | 1.116732 | 3.6852156 | Dimastigella trypaniformis | 35226 | Euglenozoa | other_Eukaryota | 263 | 1.32e-65 | NTclustered | gi|25986820|gb|AY122624.1| | 35226 | g24411 | i0 | 81.595 | 90.9909090909091 | 326 | 53 | 98 | 6 | 3 | 326 | 1042 | 722 | Dimastigella trypaniformis strain Ulm heat shock protein 90 (HSP-90) gene, partial cds | blastn | 30027 | 263 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchomonadidae | Dimastigella | Dimastigella trypaniformis | ||
| 1904409 | 1904409 | PRJNA662254_P_NODE_40342_length_264_cov_1.596859_g39691_i0 | PRJNA662254 | 40342 | 264 | 1.596859 | 4.21570776 | Crithidia dedva | 1134496 | Euglenozoa | other_Eukaryota | 296 | 1.01e-75 | NTclustered | gi|1002342152|gb|KT944302.1| | 1134496 | g39691 | i0 | 92.718 | 119.420454545455 | 206 | 14 | 78 | 1 | 1 | 205 | 1465 | 1670 | Crithidia dedva strain D2 28S ribosomal RNA gene, partial sequence | blastn | 31527 | 296 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Crithidia | Crithidia dedva | ||
| 2437114 | 2437114 | PRJNA662254_P_NODE_30362_length_301_cov_1.350877_g29711_i0 | PRJNA662254 | 30362 | 301 | 1.350877 | 4.06613977 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 189 | 2.05e-43 | NTclustered | gi|577832|gb|U16999.1|LMU16999 | 5664 | g29711 | i0 | 84 | 24.6744186046512 | 200 | 28 | 66 | 4 | 104 | 301 | 468 | 271 | Leishmania major ribosomal protein (L-11) gene, complete cds | blastn | 7427 | 189 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania major | ||
| 2437166 | 2437166 | PRJNA662254_P_NODE_7402_length_623_cov_2.285455_g6776_i0 | PRJNA662254 | 7402 | 623 | 2.285455 | 14.23838465 | Entosiphon | 101492 | Euglenozoa | other_Eukaryota | 710 | 0 | NTclustered | gi|41400272|gb|AY425008.1| | 259048 | g6776 | i0 | 87.48 | 27.3515248796148 | 623 | 69 | 99 | 9 | 3 | 619 | 642 | 23 | Entosiphon sp. TCS-2003 18S ribosomal RNA gene, partial sequence | blastn | 17040 | 710 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Entosiphon | Entosiphon sp. TCS 2003 | ||
| 16464735 | 16464735 | PRJNA662254_P_NODE_16913_length_398_cov_2.544615_g16262_i0 | PRJNA662254 | 16913 | 398 | 2.544615 | 10.1275677 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 152 | 3.6499999999999997e-32 | NTclustered | gi|2414483|emb|Y00055.1| | 5656 | g16262 | i0 | 87.692 | 45.5502512562814 | 130 | 16 | 33 | 0 | 228 | 357 | 8075 | 8204 | Crithidia fasciculata ribosomal DNA repeat (complete) | blastn | 18129 | 152 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Crithidia | Crithidia fasciculata | ||
| 17206468 | 17206468 | PRJNA662254_P_NODE_8734_length_569_cov_1.129032_g8094_i0 | PRJNA662254 | 8734 | 569 | 1.129032 | 6.42419208 | Cryptobia helicis | 62686 | Euglenozoa | other_Eukaryota | 346 | 2.3e-90 | NTclustered | gi|55824403|gb|AY651255.1| | 62686 | g8094 | i0 | 80.303 | 85.7170474516696 | 462 | 87 | 81 | 4 | 110 | 569 | 1416 | 957 | Cryptobia helicis heat shock protein 70 cytosolic isoform gene, partial cds | blastn | 48773 | 346 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Cryptobia | Cryptobia helicis | |||
| 19013520 | 19013520 | PRJNA662254_P_NODE_48215_length_250_cov_0.870056_g47564_i0 | PRJNA662254 | 48215 | 250 | 0.870056 | 2.17514 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 305 | 1.57e-78 | NTclustered | gi|2593250474|emb|OY748421.1| | 5660 | g47564 | i0 | 94.089 | 127.396 | 203 | 9 | 80 | 3 | 1 | 201 | 989823 | 990024 | Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27 | blastn | 31849 | 307 | 0.993485342019544 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis | ||
| 21030811 | 21030811 | PRJNA662254_P_NODE_36957_length_276_cov_1.137931_g36306_i0 | PRJNA662254 | 36957 | 276 | 1.137931 | 3.14068956 | Trypanosoma congolense | 5692 | Euglenozoa | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|342181295|emb|HE575319.1| | 1068625 | g36306 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 80 | 107 | 1222033 | 1222060 | Trypanosoma congolense IL3000 annotated genomic contig, chromosome 6 | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma congolense | ||
| 22305619 | 22305619 | PRJNA662254_P_NODE_50258_length_249_cov_0.875000_g49607_i0 | PRJNA662254 | 50258 | 249 | 0.875 | 2.17875 | Neobodo saliens | 351712 | Euglenozoa | other_Eukaryota | 215 | 2.72e-51 | NTclustered | gi|226347454|gb|FJ807267.1| | 351712 | g49607 | i0 | 82.661 | 10.5301204819277 | 248 | 38 | 98 | 5 | 6 | 249 | 433 | 187 | Neobodo saliens strain ATCC 50358 elongation factor 1 alpha-like protein gene, partial cds | blastn | 2622 | 215 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo saliens | |||
| 24854564 | 24854564 | PRJNA662254_P_NODE_42860_length_256_cov_1.459016_g42209_i0 | PRJNA662254 | 42860 | 256 | 1.459016 | 3.73508096 | Petalomonas cantuscygni | 56452 | Euglenozoa | other_Eukaryota | 180 | 1.02e-40 | NTclustered | gi|110589648|gb|DQ683346.1| | 56452 | g42209 | i0 | 80.4 | 1.67578125 | 250 | 37 | 95 | 8 | 13 | 256 | 1901 | 1658 | Petalomonas cantuscygni Hsp90 gene, partial cds | blastn | 429 | 180 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Petalomonadida | Scytomonadidae | Petalomonas | Petalomonas cantuscygni |
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);;