contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA789095" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3322000 | 3322000 | PRJNA789095_P_NODE_45163_length_299_cov_1.305310_g43829_i0 | PRJNA789095 | 45163 | 299 | 1.30531 | 3.9028769 | Spumella sp. OF-40 | 1432661 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 1.48e-84 | NTclustered | gi|677286268|gb|KF997856.1| | 1432661 | g43829 | i0 | 86.288 | 85.6822742474916 | 299 | 41 | 100 | 0 | 1 | 299 | 1166 | 868 | Spumella sp. OF-40 translation elongation factor 1-alpha (EF1A) mRNA, complete cds | blastn | 25619 | 326 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sp. OF-40 | |||
| 5874912 | 5874912 | PRJNA789095_P_NODE_66825_length_250_cov_1.175141_g65491_i0 | PRJNA789095 | 66825 | 250 | 1.175141 | 2.9378525 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 4.1399999999999976e-119 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g65491 | i0 | 98.4 | 99.632 | 250 | 4 | 100 | 0 | 1 | 250 | 1080 | 1329 | Vorticella sp. 4 JG-2011 clone 2 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 | 24908 | 440 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 7149261 | 7149261 | PRJNA789095_P_NODE_46226_length_296_cov_1.035874_g44892_i0 | PRJNA789095 | 46226 | 296 | 1.035874 | 3.06618704 | Actinosphaerium nucleofilum | 238767 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 1.1699999999999999e-60 | NTclustered | gi|33089895|gb|AY283757.1| | 238767 | g44892 | i0 | 81.879 | 98.9966216216216 | 298 | 48 | 99 | 4 | 2 | 296 | 405 | 699 | Actinosphaerium nucleofilum isolate Anu4_3 actin gene, partial cds | blastn | 29303 | 246 | 1 | Eukaryota | Sar | Actinophryidae | Actinosphaerium | Actinosphaerium nucleofilum | |||||
| 8424465 | 8424465 | PRJNA789095_P_NODE_64807_length_253_cov_1.322222_g63473_i0 | PRJNA789095 | 64807 | 253 | 1.322222 | 3.34522166 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 2.02e-92 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g63473 | i0 | 92 | 20.3833992094862 | 250 | 20 | 99 | 0 | 4 | 253 | 620 | 371 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 5157 | 351 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 9699658 | 9699658 | PRJNA789095_P_NODE_65788_length_251_cov_1.376404_g64454_i0 | PRJNA789095 | 65788 | 251 | 1.376404 | 3.45477404 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|820700576|tpe|LN714500.1| | 432359 | g64454 | i0 | 100 | 0.239043824701195 | 30 | 0 | 12 | 0 | 123 | 152 | 3700816 | 3700787 | TPA_asm: Toxoplasma gondii VEG, chromosome chrX, complete genome | blastn | 60 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 10975100 | 10975100 | PRJNA789095_P_NODE_57909_length_268_cov_1.579487_g56575_i0 | PRJNA789095 | 57909 | 268 | 1.579487 | 4.23302516 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 7.66e-102 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g56575 | i0 | 92.593 | 9.64179104477612 | 270 | 14 | 100 | 5 | 1 | 268 | 296 | 31 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 2584 | 383 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. |
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);;