contig_metadata
5 rows where bioproject = "PRJEB48218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2265639 | 2265639 | PRJEB48218_S_NODE_28342_length_158_cov_5.341085_g27380_i0 | PRJEB48218 | 28342 | 158 | 5.341085 | 8.4389143 | Peronospora | 70742 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 3.3400000000000003e-63 | NTclustered | gi|2703611740|gb|PP531597.1| | 162098 | g27380 | i0 | 95.57 | 99.8164556962025 | 158 | 7 | 100 | 0 | 1 | 158 | 894 | 1051 | Peronospora myosotidis voucher GLM-F73872 large subunit ribosomal RNA gene, partial sequence | blastn | 15771 | 254 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora myosotidis | ||
| 3540852 | 3540852 | PRJEB48218_S_NODE_21663_length_196_cov_517.616766_g20701_i0 | PRJEB48218 | 21663 | 196 | 517.616766 | 1014.52886136 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 3.25e-84 | NTclustered | gi|1812798919|gb|MT119182.1| | 439317 | g20701 | i0 | 97.368 | 99.9387755102041 | 190 | 5 | 97 | 0 | 1 | 190 | 194 | 5 | Gambierdiscus australes isolate IRTACC194 large subunit ribosomal RNA gene, partial sequence | blastn | 19588 | 324 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Gambierdiscus | Gambierdiscus australes | |||
| 7715071 | 7715071 | PRJEB48218_S_NODE_4567_length_536_cov_6.086785_g3639_i0 | PRJEB48218 | 4567 | 536 | 6.086785 | 32.6251676 | Torodinium robustum | 1641413 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 2.43e-5 | NTclustered | gi|2630987758|gb|OR921549.1| | 1641413 | g3639 | i0 | 100 | 0.0634328358208955 | 34 | 0 | 6 | 0 | 17 | 50 | 1727 | 1694 | Torodinium robustum isolate Tro-QI4 small subunit ribosomal RNA gene, partial sequence | blastn | 34 | 63.9 | 1 | Eukaryota | Sar | Dinophyceae | Torodiniales | Torodiniaceae | Torodinium | Torodinium robustum | |||
| 8643627 | 8643627 | PRJEB48218_S_NODE_8467_length_321_cov_13092.691781_g7505_i0 | PRJEB48218 | 8467 | 321 | 13092.691781 | 42027.54061701 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 7.48e-83 | NTclustered | gi|291495415|gb|GU823042.1| | 152704 | g7505 | i0 | 96.392 | 60.4361370716511 | 194 | 7 | 60 | 0 | 19 | 212 | 786 | 979 | Uncultured stramenopile clone A95F13RM1H08 18S ribosomal RNA gene, partial sequence | blastn | 19400 | 320 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 17914126 | 17914126 | PRJEB48218_S_NODE_26535_length_166_cov_2.905109_g25573_i0 | PRJEB48218 | 26535 | 166 | 2.905109 | 4.82248094 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 4.559999999999999e-67 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g25573 | i0 | 95.783 | 82.2650602409639 | 166 | 6 | 100 | 1 | 1 | 166 | 3674 | 3510 | Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 13656 | 267 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda 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);;