contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA939369" and tax_clade = "Metamonada"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11118097 | 11118097 | PRJNA939369_S_NODE_5349_length_529_cov_9.256579_g4933_i0 | PRJNA939369 | 5349 | 529 | 9.256579 | 48.96730291 | Tritrichomonas sp. | 2185286 | Parabasalia | other_Eukaryota | 856 | 0 | NTclustered | gi|1696259911|gb|MN120899.1| | 2185286 | g4933 | i0 | 96.038 | 100.812854442344 | 530 | 14 | 100 | 5 | 1 | 529 | 890 | 1413 | Tritrichomonas sp. strain LL5 small subunit ribosomal RNA gene, partial sequence | blastn | 53330 | 856 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas sp. | |||
| 12393458 | 12393458 | PRJNA939369_S_NODE_270_length_2031_cov_29.136874_g133_i0 | PRJNA939369 | 270 | 2031 | 29.136874 | 591.76991094 | Tritrichomonas augusta | 5725 | Parabasalia | other_Eukaryota | 3193 | 0 | NTclustered | gi|2274983416|gb|OP038912.1| | 5725 | g133 | i0 | 95.205 | 24.1161989167898 | 2023 | 92 | 99 | 4 | 1 | 2022 | 298 | 2316 | Tritrichomonas augusta isolate T1 large subunit ribosomal RNA gene, partial sequence | blastn | 48980 | 3193 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas augusta | |||
| 16558540 | 16558540 | PRJNA939369_S_NODE_1193_length_964_cov_21.754209_g877_i0 | PRJNA939369 | 1193 | 964 | 21.754209 | 209.71057476 | Tritrichomonas | 5723 | Parabasalia | other_Eukaryota | 1515 | 0 | NTclustered | gi|62466089|gb|AY886846.1| | 5726 | g877 | i0 | 95.507 | 99.3827800829876 | 957 | 28 | 99 | 10 | 1 | 951 | 948 | 1 | Tritrichomonas muris clone 1-6 16S-like ribosomal RNA gene, partial sequence | blastn | 95805 | 1515 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas muris | |||
| 23866626 | 23866626 | PRJNA939369_S_NODE_20239_length_336_cov_18.406844_g19822_i0 | PRJNA939369 | 20239 | 336 | 18.406844 | 61.84699584 | Tritrichomonas augusta | 5725 | Parabasalia | other_Eukaryota | 425 | 1.62e-114 | NTclustered | gi|2274983416|gb|OP038912.1| | 5725 | g19822 | i0 | 89.614 | 35.7113095238095 | 337 | 31 | 99 | 4 | 1 | 335 | 24 | 358 | Tritrichomonas augusta isolate T1 large subunit ribosomal RNA gene, partial sequence | blastn | 11999 | 425 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas augusta | |||
| 25140472 | 25140472 | PRJNA939369_S_NODE_36760_length_283_cov_12.819048_g36343_i0 | PRJNA939369 | 36760 | 283 | 12.819048 | 36.27790584 | Tritrichomonas augusta | 5725 | Parabasalia | other_Eukaryota | 372 | 1.76e-98 | NTclustered | gi|2274983416|gb|OP038912.1| | 5725 | g36343 | i0 | 91.007 | 4.81978798586572 | 278 | 21 | 98 | 4 | 6 | 283 | 2675 | 2402 | Tritrichomonas augusta isolate T1 large subunit ribosomal RNA gene, partial sequence | blastn | 1364 | 372 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas augusta |
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);;