contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4020557 | 4020557 | PRJNA1086823_P_NODE_8924_length_283_cov_1.485714_g8807_i0 | PRJNA1086823 | 8924 | 283 | 1.485714 | 4.20457062 | Rhynchobodo sp. Hamilton Lake | 266815 | Euglenozoa | other_Eukaryota | 424 | 4.8e-114 | NTclustered | gi|45739055|gb|AY490213.1| | 266815 | g8807 | i0 | 93.684 | 83.0530035335689 | 285 | 14 | 99 | 4 | 1 | 282 | 29 | 312 | Rhynchobodo sp. Hamilton Lake 18S ribosomal RNA gene, partial sequence | blastn | 23504 | 424 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchobodo | Rhynchobodo sp. Hamilton Lake | |||
| 5296478 | 5296478 | PRJNA1086823_P_NODE_1465_length_616_cov_2.071823_g1351_i0 | PRJNA1086823 | 1465 | 616 | 2.071823 | 12.76242968 | Rhynchobodo sp. Hamilton Lake | 266815 | Euglenozoa | other_Eukaryota | 893 | 0 | NTclustered | gi|45739055|gb|AY490213.1| | 266815 | g1351 | i0 | 92.777 | 83.4204545454545 | 623 | 36 | 100 | 8 | 1 | 616 | 1267 | 647 | Rhynchobodo sp. Hamilton Lake 18S ribosomal RNA gene, partial sequence | blastn | 51387 | 893 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchobodo | Rhynchobodo sp. Hamilton Lake | |||
| 15496425 | 15496425 | PRJNA1086823_P_NODE_1713_length_568_cov_2.092929_g1598_i0 | PRJNA1086823 | 1713 | 568 | 2.092929 | 11.88783672 | Decastava edaphica | 1732396 | Euglenozoa | other_Eukaryota | 1009 | 0 | NTclustered | gi|1182637171|gb|KY963138.1| | 1732396 | g1598 | i0 | 98.768 | 40.5492957746479 | 568 | 6 | 100 | 1 | 1 | 568 | 13 | 579 | Decastava edaphica strain CCAP 1265/2 small subunit ribosomal RNA gene, partial sequence | blastn | 23032 | 1009 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Decastava | Decastava edaphica | ||||
| 15496488 | 15496488 | PRJNA1086823_P_NODE_3253_length_426_cov_3.079320_g3136_i0 | PRJNA1086823 | 3253 | 426 | 3.07932 | 13.1179032 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 532 | 1.1999999999999999e-146 | NTclustered | gi|2026667531|dbj|LC618031.1| | 67003 | g3136 | i0 | 92.147 | 141.24882629108 | 382 | 23 | 89 | 5 | 1 | 381 | 4333 | 4708 | Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence | blastn | 60172 | 532 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 18045371 | 18045371 | PRJNA1086823_P_NODE_11515_length_257_cov_1.853261_g11398_i0 | PRJNA1086823 | 11515 | 257 | 1.853261 | 4.76288077 | Rhynchobodo sp. Hamilton Lake | 266815 | Euglenozoa | other_Eukaryota | 329 | 9.64e-86 | NTclustered | gi|45739055|gb|AY490213.1| | 266815 | g11398 | i0 | 90.272 | 83.8832684824903 | 257 | 18 | 99 | 7 | 1 | 255 | 1684 | 1935 | Rhynchobodo sp. Hamilton Lake 18S ribosomal RNA gene, partial sequence | blastn | 21558 | 329 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchobodo | Rhynchobodo sp. Hamilton Lake | |||
| 19319468 | 19319468 | PRJNA1086823_P_NODE_1576_length_593_cov_1.909615_g1461_i0 | PRJNA1086823 | 1576 | 593 | 1.909615 | 11.32401695 | Decastava sp. | 3023511 | Euglenozoa | other_Eukaryota | 922 | 0 | NTclustered | gi|2431695564|gb|OQ331009.1| | 3023511 | g1461 | i0 | 94.667 | 20.7976391231029 | 600 | 22 | 100 | 10 | 1 | 593 | 630 | 1226 | Decastava sp. isolate SPO2 small subunit ribosomal RNA gene, partial sequence | blastn | 12333 | 922 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Decastava | Decastava sp. | ||||
| 20143768 | 20143768 | PRJNA1086823_P_NODE_19736_length_199_cov_6.309524_g19619_i0 | PRJNA1086823 | 19736 | 199 | 6.309524 | 12.55595276 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 228 | 2.6699999999999992e-55 | NTclustered | gi|162233|gb|M63699.1|TRBRGS1 | 5693 | g19619 | i0 | 87.5 | 123.572864321608 | 200 | 22 | 100 | 3 | 1 | 199 | 64 | 261 | T.cruzi S3 ribosomal RNA gene | blastn | 24591 | 228 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 23146026 | 23146026 | PRJNA1086823_P_NODE_3039_length_438_cov_1.950685_g2922_i0 | PRJNA1086823 | 3039 | 438 | 1.950685 | 8.5440003 | Decastava edaphica | 1732396 | Euglenozoa | other_Eukaryota | 780 | 0 | NTclustered | gi|937541987|gb|KP306753.1| | 1732396 | g2922 | i0 | 98.858 | 70.0388127853881 | 438 | 3 | 100 | 2 | 1 | 438 | 1980 | 1545 | Decastava edaphica strain CCAP 1265/2 18S ribosomal RNA gene, partial sequence | blastn | 30677 | 780 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Decastava | Decastava edaphica | ||||
| 25243772 | 25243772 | PRJNA1086823_P_NODE_9900_length_273_cov_2.330000_g9783_i0 | PRJNA1086823 | 9900 | 273 | 2.33 | 6.3609 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 270 | 6.359999999999999e-68 | NTclustered | gi|226347430|gb|FJ807255.1| | 5718 | g9783 | i0 | 84.758 | 99.5164835164835 | 269 | 41 | 99 | 0 | 1 | 269 | 201 | 469 | Herpetomonas muscarum strain ATCC 30260 elongation factor 1 alpha gene, partial cds | blastn | 27168 | 272 | 0.992647058823529 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Herpetomonas | Herpetomonas muscarum |
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);;