contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 976870 | 976870 | PRJNA994052_P_NODE_80941_length_199_cov_190.992063_g79684_i0 | PRJNA994052 | 80941 | 199 | 190.992063 | 380.07420537 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 315 | 1.99e-81 | NTclustered | gi|27461806|gb|AY130826.1| | 56466 | g79684 | i0 | 97.312 | 3.18090452261307 | 186 | 3 | 93 | 1 | 11 | 196 | 391 | 208 | Peranema trichophorum voucher Carolina Biol. Supp. Co. (CBS) CE 13-1838 large subunit ribosomal RNA gene, partial sequence | blastn | 633 | 315 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 2251474 | 2251474 | PRJNA994052_P_NODE_23162_length_300_cov_27.704846_g21933_i0 | PRJNA994052 | 23162 | 300 | 27.704846 | 83.114538 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 143 | 1.61e-29 | NTclustered | gi|110589646|gb|DQ683345.1| | 56466 | g21933 | i0 | 77.273 | 1.13666666666667 | 264 | 47 | 88 | 3 | 1 | 264 | 125 | 375 | Peranema trichophorum Hsp90 gene, partial cds | blastn | 341 | 143 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 6079694 | 6079694 | PRJNA994052_P_NODE_47225_length_245_cov_472.348837_g45974_i0 | PRJNA994052 | 47225 | 245 | 472.348837 | 1157.25465065 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 272 | 1.56e-68 | NTclustered | gi|1803019098|gb|MT007870.1| | 56466 | g45974 | i0 | 89.427 | 7.31020408163265 | 227 | 9 | 93 | 9 | 3 | 229 | 1046 | 1257 | Peranema trichophorum strain PtR small subunit ribosomal RNA gene, partial sequence | blastn | 1791 | 272 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 7354413 | 7354413 | PRJNA994052_P_NODE_65766_length_218_cov_10.158621_g64510_i0 | PRJNA994052 | 65766 | 218 | 10.158621 | 22.14579378 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 87.9 | 5.28e-13 | NTclustered | gi|1624759989|ref|XM_029030923.1| | 67003 | g64510 | i0 | 83 | 0.458715596330275 | 100 | 13 | 45 | 4 | 118 | 215 | 473 | 376 | Trypanosoma theileri putative vacuolar ATP synthase 16 kDa proteolipid subunit (TM35_000591190), partial mRNA | blastn | 100 | 87.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 12455439 | 12455439 | PRJNA994052_P_NODE_26110_length_292_cov_10.894977_g24872_i0 | PRJNA994052 | 26110 | 292 | 10.894977 | 31.81333284 | Trypanosoma cruzi | 5693 | Euglenozoa | other_Eukaryota | 494 | 3.74e-135 | NTclustered | gi|1031970217|gb|CP015651.1| | 5693 | g24872 | i0 | 98.917 | 2.8458904109589 | 277 | 2 | 95 | 1 | 2 | 278 | 1637489 | 1637764 | Trypanosoma cruzi strain Sylvio X10/cl1 chromosome TcI1, partial sequence | blastn | 831 | 494 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 12456071 | 12456071 | PRJNA994052_P_NODE_8530_length_355_cov_41.932624_g7348_i0 | PRJNA994052 | 8530 | 355 | 41.932624 | 148.8608152 | Trypanosoma grayi | 71804 | Euglenozoa | other_Eukaryota | 196 | 1.47e-45 | NTclustered | gi|686648116|ref|XM_009318228.1| | 71804 | g7348 | i0 | 85.714 | 11.4591549295775 | 196 | 16 | 55 | 1 | 3 | 198 | 94 | 277 | Trypanosoma grayi kinetoplastid membrane protein KMP-11 partial mRNA | blastn | 4068 | 196 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma grayi | ||
| 18828129 | 18828129 | PRJNA994052_P_NODE_32735_length_274_cov_385.467662_g31491_i0 | PRJNA994052 | 32735 | 274 | 385.467662 | 1056.18139388 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 324 | 4.83e-84 | NTclustered | gi|27461806|gb|AY130826.1| | 56466 | g31491 | i0 | 88.172 | 1.01824817518248 | 279 | 24 | 100 | 7 | 1 | 274 | 772 | 498 | Peranema trichophorum voucher Carolina Biol. Supp. Co. (CBS) CE 13-1838 large subunit ribosomal RNA gene, partial sequence | blastn | 279 | 324 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 23928986 | 23928986 | PRJNA994052_P_NODE_4239_length_426_cov_314.626062_g3416_i0 | PRJNA994052 | 4239 | 426 | 314.626062 | 1340.30702412 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 505 | 2.62e-138 | NTclustered | gi|27461806|gb|AY130826.1| | 56466 | g3416 | i0 | 88.345 | 1.00704225352113 | 429 | 38 | 99 | 10 | 3 | 426 | 919 | 498 | Peranema trichophorum voucher Carolina Biol. Supp. Co. (CBS) CE 13-1838 large subunit ribosomal RNA gene, partial sequence | blastn | 429 | 505 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum |
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);;