contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA975724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6048547 | 6048547 | PRJNA975724_S_NODE_10205_length_448_cov_7.034667_g10024_i0 | PRJNA975724 | 10205 | 448 | 7.034667 | 31.51530816 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 110 | 2.54e-19 | NTclustered | gi|470414640|ref|XM_004336659.1| | 1257118 | g10024 | i0 | 80.405 | 0.772321428571429 | 148 | 25 | 33 | 4 | 302 | 447 | 1511 | 1366 | Acanthamoeba castellanii str. Neff AcetylCoA carboxylase, carboxyltransferase component, putative (ACA1_022220), partial mRNA | blastn | 346 | 110 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7323371 | 7323371 | PRJNA975724_S_NODE_11866_length_434_cov_10.365651_g11685_i0 | PRJNA975724 | 11866 | 434 | 10.365651 | 44.98692534 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 148 | 5.2e-31 | NTclustered | gi|470423488|ref|XM_004337555.1| | 1257118 | g11685 | i0 | 79.263 | 45.46313364055301 | 217 | 41 | 50 | 4 | 59 | 273 | 367 | 581 | Acanthamoeba castellanii str. Neff ribosomal protein L23, putative (ACA1_164710), partial mRNA | blastn | 19731 | 148 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14973435 | 14973435 | PRJNA975724_S_NODE_1752_length_690_cov_4.753647_g1590_i0 | PRJNA975724 | 1752 | 690 | 4.753647 | 32.8001643 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 970 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g1590 | i0 | 94.662 | 47.5304347826087 | 637 | 15 | 91 | 14 | 62 | 690 | 4 | 629 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 32796 | 970 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 16250124 | 16250124 | PRJNA975724_S_NODE_82153_length_248_cov_1.148571_g81972_i0 | PRJNA975724 | 82153 | 248 | 1.148571 | 2.84845608 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 137 | 6.019999999999999e-28 | NTclustered | gi|470375091|ref|XM_004333111.1| | 1257118 | g81972 | i0 | 82.716 | 45.0685483870968 | 162 | 21 | 65 | 4 | 76 | 235 | 229 | 73 | Acanthamoeba castellanii str. Neff high molecular weight heat shock protein (ACA1_387860), partial mRNA | blastn | 11177 | 137 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 17523502 | 17523502 | PRJNA975724_S_NODE_15754_length_408_cov_5.453731_g15573_i0 | PRJNA975724 | 15754 | 408 | 5.453731 | 22.25122248 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 126 | 2.2799999999999998e-24 | NTclustered | gi|470494240|ref|XM_004346562.1| | 1257118 | g15573 | i0 | 77.778 | 3.60294117647059 | 216 | 40 | 52 | 8 | 163 | 374 | 1110 | 899 | Acanthamoeba castellanii str. Neff S(hydroxymethyl)glutathione dehydrogenase/class III alcohol dehydrogenase (ACA1_230530), partial mRNA | blastn | 1470 | 126 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21349376 | 21349376 | PRJNA975724_S_NODE_8477_length_466_cov_12.050891_g8296_i0 | PRJNA975724 | 8477 | 466 | 12.050891 | 56.15715206 | Vannellidae sp. | 2491907 | Discosea | other_Eukaryota | 224 | 9.069999999999999e-54 | NTclustered | gi|1523769313|gb|MH535955.1| | 2491907 | g8296 | i0 | 80.583 | 35.7124463519313 | 309 | 44 | 66 | 12 | 90 | 395 | 700 | 405 | Vannellidae sp. strain 147SVA_C2 18S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 16642 | 224 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannellidae sp. | ||||
| 23900072 | 23900072 | PRJNA975724_S_NODE_959_length_814_cov_3.840756_g820_i0 | PRJNA975724 | 959 | 814 | 3.840756 | 31.26375384 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 514 | 8.679999999999999e-141 | NTclustered | gi|470375091|ref|XM_004333111.1| | 1257118 | g820 | i0 | 80.689 | 84.3636363636364 | 668 | 123 | 82 | 6 | 9 | 673 | 684 | 20 | Acanthamoeba castellanii str. Neff high molecular weight heat shock protein (ACA1_387860), partial mRNA | blastn | 68672 | 514 | 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);;