contig_metadata
5 rows where bioproject = "PRJEB28062", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6401857 | 6401857 | PRJEB28062_P_NODE_116406_length_269_cov_3.341837_g114043_i0 | PRJEB28062 | 116406 | 269 | 3.341837 | 8.98954153 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 84.2 | 8.74e-12 | NTclustered | gi|470374499|ref|XM_004333054.1| | 1257118 | g114043 | i0 | 79.508 | 0.453531598513011 | 122 | 22 | 45 | 3 | 77 | 196 | 234 | 354 | Acanthamoeba castellanii str. Neff ribosomal protein L32, putative (ACA1_334790), partial mRNA | blastn | 122 | 84.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12778220 | 12778220 | PRJEB28062_P_NODE_37411_length_597_cov_30.477099_g35084_i0 | PRJEB28062 | 37411 | 597 | 30.477099 | 181.94828103 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 966 | 0 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g35084 | i0 | 97.857 | 45.1591289782245 | 560 | 10 | 93 | 1 | 40 | 597 | 2598 | 3157 | Vannella septentrionalis 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 | 26960 | 966 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 20425494 | 20425494 | PRJEB28062_P_NODE_43397_length_548_cov_8.498947_g41059_i0 | PRJEB28062 | 43397 | 548 | 8.498947 | 46.57422956 | Acanthamoeba polyphaga | 5757 | Discosea | other_Eukaryota | 758 | 0 | NTclustered | gi|932090235|gb|KP054475.2| | 5757 | g41059 | i0 | 93.398 | 13.4051094890511 | 515 | 28 | 93 | 6 | 15 | 526 | 747 | 236 | Acanthamoeba polyphaga strain Linc Ap-1 mitochondrion, complete genome | blastn | 7346 | 758 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba polyphaga | |||
| 22977095 | 22977095 | PRJEB28062_P_NODE_56839_length_467_cov_2.870558_g54485_i0 | PRJEB28062 | 56839 | 467 | 2.870558 | 13.40550586 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 599 | 1.2899999999999995e-166 | NTclustered | gi|470402197|ref|XM_004335593.1| | 1257118 | g54485 | i0 | 99.694 | 1.24197002141328 | 327 | 1 | 70 | 0 | 20 | 346 | 327 | 1 | Acanthamoeba castellanii str. Neff ribosomal protein L35Ae, putative (ACA1_038130), partial mRNA | blastn | 580 | 599 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 23939455 | 23939455 | PRJEB28062_P_NODE_133859_length_229_cov_9.160256_g131495_i0 | PRJEB28062 | 133859 | 229 | 9.160256 | 20.97698624 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 350 | 6.47e-92 | NTclustered | gi|909719694|gb|KT185628.1| | 5755 | g131495 | i0 | 97.115 | 90.646288209607 | 208 | 5 | 90 | 1 | 23 | 229 | 2278 | 2485 | Acanthamoeba castellanii isolate BCP-EM3VF21-1 mitochondrion, complete genome | blastn | 20758 | 350 | 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);;