contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA782235" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9691587 | 9691587 | PRJNA782235_P_NODE_10408_length_287_cov_1.079439_g10219_i0 | PRJNA782235 | 10408 | 287 | 1.079439 | 3.09798993 | Amoebozoa sp. | 1892891 | Root_unresolved | Root_unresolved | 486 | 6.139999999999999e-133 | NTclustered | gi|2651357789|gb|PP174304.1| | 1892891 | g10219 | i0 | 97.213 | 8.52613240418119 | 287 | 8 | 100 | 0 | 1 | 287 | 3734 | 4020 | Amoebozoa sp. isolate 114_WLI 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 | 2447 | 486 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. | |||||||
| 22440790 | 22440790 | PRJNA782235_P_NODE_3578_length_473_cov_1.885000_g3390_i0 | PRJNA782235 | 3578 | 473 | 1.885 | 8.91605 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 658 | 0 | NTclustered | gi|221185864|gb|FJ577811.1| | 590481 | g3390 | i0 | 95.012 | 74.0211416490486 | 421 | 17 | 89 | 4 | 36 | 454 | 164 | 582 | Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence | blastn | 35012 | 658 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 22890033 | 22890033 | PRJNA782235_P_NODE_3998_length_442_cov_1.094851_g3809_i0 | PRJNA782235 | 3998 | 442 | 1.094851 | 4.83924142 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 800 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g3809 | i0 | 99.321 | 34.8574660633484 | 442 | 3 | 100 | 0 | 1 | 442 | 2903 | 2462 | Hartmannella vermiformis 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 | 15407 | 800 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;