contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA596870" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 568364 | 568364 | PRJNA596870_P_NODE_25001_length_271_cov_1.944444_g24868_i0 | PRJNA596870 | 25001 | 271 | 1.944444 | 5.26944324 | Seculamonas ecuadoriensis | 221724 | Root_unresolved | Root_unresolved | 176 | 1.41e-39 | NTclustered | gi|2443276641|gb|OP760405.1| | 221724 | g24868 | i0 | 78.947 | 18.2619926199262 | 266 | 50 | 97 | 6 | 3 | 265 | 401 | 139 | Seculamonas ecuadoriensis 40S ribosomal protein SA mRNA, complete cds | blastn | 4949 | 176 | 1 | Eukaryota | Discoba | Jakobida | Seculamonas | Seculamonas ecuadoriensis | |||||
| 6946841 | 6946841 | PRJNA596870_P_NODE_36806_length_244_cov_0.900585_g36673_i0 | PRJNA596870 | 36806 | 244 | 0.900585 | 2.1974274 | Trypanosoma vivax | 5699 | Euglenozoa | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|340058162|emb|HE573027.1| | 1055687 | g36673 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 212 | 239 | 771392 | 771419 | Trypanosoma vivax Y486 annotated genomic contig, chromosome 11 | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 14597425 | 14597425 | PRJNA596870_P_NODE_34332_length_246_cov_1.335260_g34199_i0 | PRJNA596870 | 34332 | 246 | 1.33526 | 3.2847396 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 444 | 3.14e-120 | NTclustered | gi|427188201|dbj|AB757706.1| | 56466 | g34199 | i0 | 99.187 | 1 | 246 | 2 | 100 | 0 | 1 | 246 | 883 | 638 | Peranema trichophorum rpl3 mRNA for 60S ribosomal protein L3, partial cds, strain: K-01 | blastn | 246 | 444 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 20970523 | 20970523 | PRJNA596870_P_NODE_21897_length_287_cov_1.411215_g21764_i0 | PRJNA596870 | 21897 | 287 | 1.411215 | 4.05018705 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 324 | 5.09e-84 | NTclustered | gi|110589646|gb|DQ683345.1| | 56466 | g21764 | i0 | 96.891 | 5.31358885017422 | 193 | 6 | 100 | 0 | 1 | 193 | 1478 | 1286 | Peranema trichophorum Hsp90 gene, partial cds | blastn | 1525 | 324 | 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);;