contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA1136505" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7937563 | 7937563 | PRJNA1136505_P_NODE_67387_length_361_cov_2.079861_g60527_i0 | PRJNA1136505 | 67387 | 361 | 2.079861 | 7.50829821 | Seculamonas ecuadoriensis | 221724 | Root_unresolved | Root_unresolved | 226 | 1.91e-54 | NTclustered | gi|2443276671|gb|OP760420.1| | 221724 | g60527 | i0 | 80.128 | 17.6454293628809 | 312 | 54 | 85 | 7 | 47 | 354 | 1184 | 877 | Seculamonas ecuadoriensis H/ACA ribonucleoprotein complex subunit mRNA, partial cds | blastn | 6370 | 226 | 1 | Eukaryota | Discoba | Jakobida | Seculamonas | Seculamonas ecuadoriensis | |||||
| 12510730 | 12510730 | PRJNA1136505_P_NODE_63370_length_376_cov_1.145215_g56510_i0 | PRJNA1136505 | 63370 | 376 | 1.145215 | 4.3060084 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 239 | 2.5600000000000003e-58 | NTclustered | gi|290977743|ref|XM_002671551.1| | 5762 | g56510 | i0 | 81.293 | 31.2101063829787 | 294 | 55 | 78 | 0 | 1 | 294 | 1058 | 1351 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_59416), mRNA | blastn | 11735 | 239 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13785363 | 13785363 | PRJNA1136505_P_NODE_70691_length_351_cov_1.107914_g63831_i0 | PRJNA1136505 | 70691 | 351 | 1.107914 | 3.88877814 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 375 | 1.7299999999999998e-99 | NTclustered | gi|290989871|ref|XM_002677515.1| | 5762 | g63831 | i0 | 86.416 | 100.022792022792 | 346 | 43 | 98 | 4 | 8 | 351 | 486 | 143 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_56150), mRNA | blastn | 35108 | 377 | 0.994694960212202 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi |
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);;