contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA715461" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 705122 | 705122 | PRJNA715461_S_NODE_401_length_432_cov_130.674095_g327_i0 | PRJNA715461 | 401 | 432 | 130.674095 | 564.5120904 | Procryptobia sp. | 2060762 | Euglenozoa | other_Eukaryota | 518 | 3.42e-142 | NTclustered | gi|1384591689|gb|MG679919.1| | 2060762 | g327 | i0 | 97.377 | 72.4513888888889 | 305 | 7 | 70 | 1 | 126 | 429 | 1318 | 1014 | Procryptobia sp. isolate HT261113 18S ribosomal RNA gene, partial sequence | blastn | 31299 | 518 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Procryptobia | Procryptobia sp. | |||
| 3743924 | 3743924 | PRJNA715461_S_NODE_443_length_410_cov_7.860534_g369_i0 | PRJNA715461 | 443 | 410 | 7.860534 | 32.2281894 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 399 | 1.2199999999999999e-106 | NTclustered | gi|2026667530|dbj|LC618030.1| | 67003 | g369 | i0 | 85.472 | 124.056097560976 | 413 | 26 | 93 | 20 | 4 | 386 | 4413 | 4821 | Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence | blastn | 50863 | 399 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 5020477 | 5020477 | PRJNA715461_S_NODE_104_length_825_cov_193.957447_g66_i0 | PRJNA715461 | 104 | 825 | 193.957447 | 1600.14893775 | Procryptobia | 266822 | Euglenozoa | other_Eukaryota | 1170 | 0 | NTclustered | gi|11037210|gb|AF208888.1|AF208888 | 351715 | g66 | i0 | 96.25 | 80.4763636363636 | 720 | 16 | 87 | 11 | 4 | 717 | 370 | 1084 | Bodo sorokini small subunit ribosomal RNA gene, complete sequence | blastn | 66393 | 1175 | 0.995744680851064 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Procryptobia | Procryptobia sorokini | |||
| 8358461 | 8358461 | PRJNA715461_S_NODE_427_length_415_cov_647.643275_g353_i0 | PRJNA715461 | 427 | 415 | 647.643275 | 2687.71959125 | Procryptobia sp. | 2060762 | Euglenozoa | other_Eukaryota | 516 | 1.18e-141 | NTclustered | gi|1384591689|gb|MG679919.1| | 2060762 | g353 | i0 | 97.368 | 75.1855421686747 | 304 | 7 | 73 | 1 | 4 | 306 | 1014 | 1317 | Procryptobia sp. isolate HT261113 18S ribosomal RNA gene, partial sequence | blastn | 31202 | 516 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Procryptobia | Procryptobia sp. | |||
| 10909221 | 10909221 | PRJNA715461_S_NODE_429_length_414_cov_12.478006_g355_i0 | PRJNA715461 | 429 | 414 | 12.478006 | 51.65894484 | Bodo sp. ATCC 50149 | 155205 | Euglenozoa | other_Eukaryota | 263 | 1.69e-65 | NTclustered | gi|20331091|gb|AY028449.1| | 155205 | g355 | i0 | 93.785 | 44.8212560386473 | 177 | 7 | 42 | 4 | 4 | 178 | 2311 | 2485 | Bodo sp. ATCC 50149 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 | 18556 | 263 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo sp. ATCC 50149 | ||
| 12184458 | 12184458 | PRJNA715461_S_NODE_390_length_437_cov_6814.868132_g316_i0 | PRJNA715461 | 390 | 437 | 6814.868132 | 29780.97373684 | Trypanoplasma borreli | 5710 | Euglenozoa | other_Eukaryota | 538 | 2.659999999999999e-148 | NTclustered | gi|20331096|gb|AY028454.1| | 5710 | g316 | i0 | 94.302 | 118.421052631579 | 351 | 20 | 80 | 0 | 82 | 432 | 1023 | 673 | Trypanoplasma borreli 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 | 51750 | 538 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Trypanoplasma | Trypanoplasma borreli | |||
| 13946066 | 13946066 | PRJNA715461_S_NODE_411_length_426_cov_6.294618_g337_i0 | PRJNA715461 | 411 | 426 | 6.294618 | 26.81507268 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 652 | 0 | NTclustered | gi|165968557|gb|EU377597.1| | 36333 | g337 | i0 | 100 | 82.8661971830986 | 353 | 0 | 83 | 0 | 71 | 423 | 548 | 196 | Naegleria clarki strain CRIB43 18S ribosomal RNA gene, partial sequence | blastn | 35301 | 652 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria clarki | ||||
| 13946073 | 13946073 | PRJNA715461_S_NODE_871_length_269_cov_16.372449_g797_i0 | PRJNA715461 | 871 | 269 | 16.372449 | 44.04188781 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 316 | 7.909999999999998e-82 | NTclustered | gi|46091659|dbj|AB175623.1| | 169531 | g797 | i0 | 93.868 | 102.561338289963 | 212 | 10 | 78 | 3 | 4 | 212 | 5446 | 5657 | Trypanosoma grosi genes for IGS, 18S rRNA, 5.8S rRNA, 28S rRNA and ITS1-7, isolate: HANTO | blastn | 27589 | 316 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma grosi | ||
| 15220738 | 15220738 | PRJNA715461_S_NODE_172_length_631_cov_9.163082_g123_i0 | PRJNA715461 | 172 | 631 | 9.163082 | 57.81904742 | Kinetoplastea | 5653 | Euglenozoa | other_Eukaryota | 1002 | 0 | NTclustered | gi|28076820|gb|AF530519.1| | 212100 | g123 | i0 | 99.102 | 88.3882725832013 | 557 | 5 | 88 | 0 | 72 | 628 | 1967 | 1411 | Uncultured bodonid clone AT1-3 18S ribosomal RNA gene, partial sequence | blastn | 55773 | 1007 | 0.995034756703079 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | uncultured bodonid | |||
| 16007721 | 16007721 | PRJNA715461_S_NODE_213_length_590_cov_4711.497099_g162_i0 | PRJNA715461 | 213 | 590 | 4711.497099 | 27797.8328841 | Procryptobia sorokini | 351715 | Euglenozoa | other_Eukaryota | 761 | 0 | NTclustered | gi|225216797|gb|FJ176712.1| | 351715 | g162 | i0 | 98.387 | 126.101694915254 | 434 | 6 | 74 | 1 | 84 | 517 | 433 | 1 | Procryptobia sorokini HFCC16 28S ribosomal RNA gene, partial sequence | blastn | 74400 | 761 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Procryptobia | Procryptobia sorokini | |||
| 17283209 | 17283209 | PRJNA715461_S_NODE_494_length_387_cov_7548.414013_g420_i0 | PRJNA715461 | 494 | 387 | 7548.414013 | 29212.36223031 | Procryptobia sp. | 2060762 | Euglenozoa | other_Eukaryota | 516 | 1.09e-141 | NTclustered | gi|1384591689|gb|MG679919.1| | 2060762 | g420 | i0 | 97.368 | 80.625322997416 | 304 | 7 | 78 | 1 | 4 | 306 | 1014 | 1317 | Procryptobia sp. isolate HT261113 18S ribosomal RNA gene, partial sequence | blastn | 31202 | 516 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Procryptobia | Procryptobia sp. | |||
| 21107574 | 21107574 | PRJNA715461_S_NODE_477_length_393_cov_7302.209375_g403_i0 | PRJNA715461 | 477 | 393 | 7302.209375 | 28697.68284375 | Procryptobia sp. | 2060762 | Euglenozoa | other_Eukaryota | 529 | 1.4199999999999994e-145 | NTclustered | gi|1384591689|gb|MG679919.1| | 2060762 | g403 | i0 | 97.134 | 81.8625954198473 | 314 | 8 | 80 | 1 | 78 | 390 | 1327 | 1014 | Procryptobia sp. isolate HT261113 18S ribosomal RNA gene, partial sequence | blastn | 32172 | 529 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Procryptobia | Procryptobia sp. | |||
| 23658186 | 23658186 | PRJNA715461_S_NODE_139_length_704_cov_4.586371_g95_i0 | PRJNA715461 | 139 | 704 | 4.586371 | 32.28805184 | Procryptobia sorokini | 351715 | Euglenozoa | other_Eukaryota | 1205 | 0 | NTclustered | gi|225216797|gb|FJ176712.1| | 351715 | g95 | i0 | 97.589 | 151.103693181818 | 705 | 13 | 99 | 3 | 2 | 704 | 536 | 1238 | Procryptobia sorokini HFCC16 28S ribosomal RNA gene, partial sequence | blastn | 106377 | 1205 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Procryptobia | Procryptobia sorokini |
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);;