contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA309466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 376838 | 376838 | PRJNA309466_P_NODE_5821_length_242_cov_8.119171_g5764_i0 | PRJNA309466 | 5821 | 242 | 8.119171 | 19.64839382 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 316 | 7e-82 | NTclustered | gi|2026667531|dbj|LC618031.1| | 67003 | g5764 | i0 | 92.76 | 110.03305785124 | 221 | 12 | 90 | 4 | 3 | 220 | 5773 | 5992 | Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence | blastn | 26628 | 316 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 4203936 | 4203936 | PRJNA309466_P_NODE_12704_length_182_cov_5.090226_g12647_i0 | PRJNA309466 | 12704 | 182 | 5.090226 | 9.26421132 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 285 | 1.4e-72 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g12647 | i0 | 96 | 1.93956043956044 | 175 | 7 | 96 | 0 | 5 | 179 | 2172 | 1998 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 353 | 285 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 7440861 | 7440861 | PRJNA309466_P_NODE_10366_length_197_cov_1.371622_g10309_i0 | PRJNA309466 | 10366 | 197 | 1.371622 | 2.70209534 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 355 | 1.16e-93 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g10309 | i0 | 100 | 9.97969543147208 | 192 | 0 | 97 | 0 | 6 | 197 | 5719 | 5528 | Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 1966 | 355 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 8030060 | 8030060 | PRJNA309466_P_NODE_19227_length_155_cov_5.622642_g19170_i0 | PRJNA309466 | 19227 | 155 | 5.622642 | 8.7150951 | Monomorphina pseudonordstedti | 298287 | Euglenozoa | other_Eukaryota | 265 | 1.5e-66 | NTclustered | gi|397789470|gb|JN603976.1| | 298287 | g19170 | i0 | 98.667 | 96.6516129032258 | 150 | 1 | 96 | 1 | 4 | 152 | 1267 | 1416 | Monomorphina pseudonordstedti strain Doomo042007H 23S large subunit ribosomal RNA gene, partial sequence; plastid | blastn | 14981 | 265 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Monomorphina | Monomorphina pseudonordstedti | ||
| 8030068 | 8030068 | PRJNA309466_P_NODE_2767_length_384_cov_10.910448_g2711_i0 | PRJNA309466 | 2767 | 384 | 10.910448 | 41.89612032 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 612 | 1.34e-170 | NTclustered | gi|2026667531|dbj|LC618031.1| | 67003 | g2711 | i0 | 95.373 | 149.393229166667 | 389 | 11 | 99 | 6 | 2 | 383 | 4783 | 4395 | Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence | blastn | 57367 | 612 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 9991267 | 9991267 | PRJNA309466_P_NODE_19868_length_151_cov_10.245098_g19811_i0 | PRJNA309466 | 19868 | 151 | 10.245098 | 15.47009798 | Bodo | 5712 | Euglenozoa | other_Eukaryota | 279 | 5.19e-71 | NTclustered | gi|1509798611|gb|MH614643.1| | 75058 | g19811 | i0 | 100 | 99.158940397351 | 151 | 0 | 100 | 0 | 1 | 151 | 1884 | 2034 | Bodo saltans small subunit ribosomal RNA gene, partial sequence | blastn | 14973 | 279 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 10580786 | 10580786 | PRJNA309466_P_NODE_18929_length_157_cov_4.759259_g18872_i0 | PRJNA309466 | 18929 | 157 | 4.759259 | 7.47203663 | Bodo edax | 155204 | Euglenozoa | other_Eukaryota | 274 | 2.54e-69 | NTclustered | gi|20331093|gb|AY028451.1| | 155204 | g18872 | i0 | 98.701 | 98.2356687898089 | 154 | 2 | 98 | 0 | 1 | 154 | 2328 | 2481 | Bodo edax 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 15423 | 274 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo edax | ||
| 15090790 | 15090790 | PRJNA309466_P_NODE_3252_length_337_cov_10.583333_g3196_i0 | PRJNA309466 | 3252 | 337 | 10.583333 | 35.66583221 | Bodo | 5712 | Euglenozoa | other_Eukaryota | 619 | 6.95e-173 | NTclustered | gi|45739069|gb|AY490227.1| | 75058 | g3196 | i0 | 100 | 97.7655786350148 | 335 | 0 | 99 | 0 | 2 | 336 | 1044 | 1378 | Bodo saltans JC02 18S ribosomal RNA gene, partial sequence | blastn | 32947 | 619 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 15090924 | 15090924 | PRJNA309466_P_NODE_8572_length_210_cov_9.459627_g8515_i0 | PRJNA309466 | 8572 | 210 | 9.459627 | 19.8652167 | Bodo | 5712 | Euglenozoa | other_Eukaryota | 385 | 1.5999999999999995e-102 | NTclustered | gi|45739069|gb|AY490227.1| | 75058 | g8515 | i0 | 100 | 96.2761904761905 | 208 | 0 | 99 | 0 | 1 | 208 | 632 | 425 | Bodo saltans JC02 18S ribosomal RNA gene, partial sequence | blastn | 20218 | 385 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 17640747 | 17640747 | PRJNA309466_P_NODE_3034_length_358_cov_4.294498_g2978_i0 | PRJNA309466 | 3034 | 358 | 4.294498 | 15.37430284 | Bodo | 5712 | Euglenozoa | other_Eukaryota | 592 | 1.6199999999999999e-164 | NTclustered | gi|45739068|gb|AY490226.1| | 75058 | g2978 | i0 | 99.689 | 88.6703910614525 | 322 | 1 | 90 | 0 | 37 | 358 | 1514 | 1835 | Bodo saltans 18S ribosomal RNA gene, partial sequence | blastn | 31744 | 592 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 24602912 | 24602912 | PRJNA309466_P_NODE_3700_length_306_cov_2.797665_g3644_i0 | PRJNA309466 | 3700 | 306 | 2.797665 | 8.5608549 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 527 | 3.8899999999999985e-145 | NTclustered | gi|68271530|gb|DQ086711.1| | 75058 | g3644 | i0 | 97.712 | 161.359477124183 | 306 | 7 | 100 | 0 | 1 | 306 | 637 | 332 | Bodo saltans isolate BODOSALT large subunit ribosomal RNA gene, partial sequence | blastn | 49376 | 527 | 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);;