contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153543 | 153543 | PRJNA1005695_P_NODE_28861_length_278_cov_1.629268_g28009_i0 | PRJNA1005695 | 28861 | 278 | 1.629268 | 4.52936504 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 453 | 5.999999999999999e-123 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g28009 | i0 | 96.39 | 22.0143884892086 | 277 | 6 | 99 | 2 | 2 | 278 | 5462 | 5734 | Acanthamoeba castellanii 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 | 6120 | 453 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5256583 | 5256583 | PRJNA1005695_P_NODE_5325_length_687_cov_41.035831_g4516_i0 | PRJNA1005695 | 5325 | 687 | 41.035831 | 281.91615897 | Vannella croatica | 1778588 | Discosea | other_Eukaryota | 1221 | 0 | NTclustered | gi|973761167|gb|KT345693.1| | 1778588 | g4516 | i0 | 98.834 | 82.4425036390102 | 686 | 6 | 99 | 2 | 2 | 686 | 523 | 1207 | Vannella croatica isolate KRKA 29.9.7.6.1 small subunit ribosomal RNA gene, partial sequence | blastn | 56638 | 1221 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella croatica | |||
| 8654222 | 8654222 | PRJNA1005695_P_NODE_22567_length_316_cov_1.683128_g21715_i0 | PRJNA1005695 | 22567 | 316 | 1.683128 | 5.31868448 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 228 | 4.579999999999999e-55 | NTclustered | gi|1914009752|gb|MT975626.1| | 1017091 | g21715 | i0 | 79.874 | 91.0284810126582 | 318 | 58 | 99 | 3 | 5 | 316 | 449 | 132 | Cochliopodium larifeili cytochrome C oxidase subunit 1 gene, partial cds; mitochondrial | blastn | 28765 | 228 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 14182272 | 14182272 | PRJNA1005695_P_NODE_35172_length_252_cov_0.871508_g34320_i0 | PRJNA1005695 | 35172 | 252 | 0.871508 | 2.19620016 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 466 | 6.89e-127 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g34320 | i0 | 100 | 101.071428571429 | 252 | 0 | 100 | 0 | 1 | 252 | 2699 | 2448 | Paravannella minima mitochondrion, complete genome | blastn | 25470 | 466 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 20127586 | 20127586 | PRJNA1005695_P_NODE_3256_length_887_cov_2.630221_g2631_i0 | PRJNA1005695 | 3256 | 887 | 2.630221 | 23.33006027 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 394 | 1.2899999999999997e-104 | NTclustered | gi|881634|gb|U29610.1|ACU29610 | 5755 | g2631 | i0 | 77.075 | 17.5896279594138 | 711 | 145 | 79 | 16 | 1 | 702 | 610 | 1311 | Acanthaoeba castellanii actin-related protein 3 Arp3 mRNA, complete cds | blastn | 15602 | 394 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;