contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA874604" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2513262 | 2513262 | PRJNA874604_P_NODE_16002_length_441_cov_9.701087_g15650_i0 | PRJNA874604 | 16002 | 441 | 9.701087 | 42.78179367 | Ripella | 1217112 | Discosea | other_Eukaryota | 693 | 0 | NTclustered | gi|1269228437|gb|MF683562.1| | 2047822 | g15650 | i0 | 95.034 | 100.433106575964 | 443 | 18 | 100 | 4 | 1 | 441 | 1044 | 604 | Ripella decalvata clone 15101 18S ribosomal RNA gene, partial sequence | blastn | 44291 | 695 | 0.997122302158273 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 4679829 | 4679829 | PRJNA874604_P_NODE_1784_length_1117_cov_3.204981_g1576_i0 | PRJNA874604 | 1784 | 1117 | 3.204981 | 35.79963777 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 1144 | 0 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g1576 | i0 | 87.238 | 67.2202327663384 | 1003 | 126 | 90 | 2 | 116 | 1117 | 1202 | 201 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 75085 | 1144 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 7230186 | 7230186 | PRJNA874604_P_NODE_49466_length_285_cov_1.433962_g49114_i0 | PRJNA874604 | 49466 | 285 | 1.433962 | 4.0867917 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 172 | 1.94e-38 | NTclustered | gi|145386784|gb|EF216909.1| | 437603 | g49114 | i0 | 77.855 | 27.8315789473684 | 289 | 57 | 100 | 7 | 1 | 285 | 45 | 330 | Neoparamoeba perurans strain GD-HAC/1 28S large subunit ribosomal RNA gene, partial sequence | blastn | 7932 | 172 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans | ||
| 9779187 | 9779187 | PRJNA874604_P_NODE_11008_length_517_cov_7.601351_g10657_i0 | PRJNA874604 | 11008 | 517 | 7.601351 | 39.29898467 | Vannella sp. KDN1 | 2081467 | Discosea | other_Eukaryota | 813 | 0 | NTclustered | gi|1770511914|dbj|LC368142.1| | 2081467 | g10657 | i0 | 95.038 | 101.075435203095 | 524 | 14 | 100 | 10 | 1 | 517 | 1153 | 1671 | Vannella sp. KDN1 gene for 18S ribosomal RNA, partial sequence | blastn | 52256 | 813 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. KDN1 | |||
| 17431150 | 17431150 | PRJNA874604_P_NODE_96874_length_242_cov_0.911243_g96522_i0 | PRJNA874604 | 96874 | 242 | 0.911243 | 2.20520806 | Vannella ebro | 207334 | Discosea | other_Eukaryota | 283 | 7.1e-72 | NTclustered | gi|33946344|gb|AY294151.1| | 207334 | g96522 | i0 | 90.278 | 83.8636363636364 | 216 | 21 | 89 | 0 | 27 | 242 | 16 | 231 | Vannella ebro actin mRNA, complete cds | blastn | 20295 | 283 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella ebro | |||
| 21254087 | 21254087 | PRJNA874604_P_NODE_50117_length_284_cov_1.170616_g49765_i0 | PRJNA874604 | 50117 | 284 | 1.170616 | 3.32454944 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 444 | 3.6999999999999986e-120 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g49765 | i0 | 94.81 | 43.0774647887324 | 289 | 8 | 100 | 7 | 1 | 284 | 102 | 388 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 12234 | 444 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 25078906 | 25078906 | PRJNA874604_P_NODE_8980_length_563_cov_11.808163_g8633_i0 | PRJNA874604 | 8980 | 563 | 11.808163 | 66.47995769 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 881 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g8633 | i0 | 95.512 | 99.0941385435169 | 557 | 16 | 98 | 9 | 11 | 563 | 1 | 552 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 55790 | 881 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 |
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);;