contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 853138 | 853138 | PRJNA876641_P_NODE_13681_length_261_cov_1.760638_g13607_i0 | PRJNA876641 | 13681 | 261 | 1.760638 | 4.59526518 | Cochliopodium spiniferum | 313558 | Discosea | other_Eukaryota | 394 | 3.429999999999999e-105 | NTclustered | gi|330902897|gb|JF298273.1| | 313558 | g13607 | i0 | 94.186 | 95.4329501915709 | 258 | 15 | 99 | 0 | 1 | 258 | 276 | 533 | Cochliopodium spiniferum clone 5102 actin gene, partial cds | blastn | 24908 | 394 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium spiniferum | |||
| 3403821 | 3403821 | PRJNA876641_P_NODE_1263_length_590_cov_16.524178_g1190_i0 | PRJNA876641 | 1263 | 590 | 16.524178 | 97.4926502 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 688 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g1190 | i0 | 87.755 | 98.7271186440678 | 588 | 72 | 99 | 0 | 1 | 588 | 484 | 1071 | Platyamoeba placida actin mRNA, partial cds | blastn | 58249 | 688 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 4681571 | 4681571 | PRJNA876641_P_NODE_2004_length_490_cov_5.441247_g1930_i0 | PRJNA876641 | 2004 | 490 | 5.441247 | 26.6621103 | Vannella sp. strain W181G/I | 325084 | Discosea | other_Eukaryota | 682 | 0 | NTclustered | gi|62865938|gb|AY929913.1| | 325084 | g1930 | i0 | 96.618 | 100.687755102041 | 414 | 9 | 99 | 4 | 81 | 490 | 1229 | 1641 | Vannella sp. strain W181G/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 49337 | 682 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain W181G/I | |||
| 8506091 | 8506091 | PRJNA876641_P_NODE_18287_length_248_cov_0.880000_g18213_i0 | PRJNA876641 | 18287 | 248 | 0.88 | 2.1824 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 193 | 1.27e-44 | NTclustered | gi|88601113|gb|DQ390343.1| | 5755 | g18213 | i0 | 84.694 | 0.790322580645161 | 196 | 26 | 78 | 3 | 19 | 211 | 451 | 645 | Acanthamoeba castellanii sterol C-24 reductase-like protein mRNA, partial cds | blastn | 196 | 193 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8506176 | 8506176 | PRJNA876641_P_NODE_23547_length_241_cov_0.916667_g23473_i0 | PRJNA876641 | 23547 | 241 | 0.916667 | 2.20916747 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 265 | 2.5599999999999996e-66 | NTclustered | gi|470412384|ref|XM_004336417.1| | 1257118 | g23473 | i0 | 87.946 | 92.6473029045643 | 224 | 27 | 93 | 0 | 2 | 225 | 971 | 748 | Acanthamoeba castellanii str. Neff phosphoenolpyruvate carboxykinase (GTP), putative (ACA1_191500), partial mRNA | blastn | 22328 | 265 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9781134 | 9781134 | PRJNA876641_P_NODE_2848_length_429_cov_1.941011_g2774_i0 | PRJNA876641 | 2848 | 429 | 1.941011 | 8.32693719 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 237 | 1.06e-57 | NTclustered | gi|470467440|ref|XM_004341747.1| | 1257118 | g2774 | i0 | 77.778 | 2.58974358974359 | 387 | 84 | 90 | 2 | 3 | 388 | 404 | 19 | Acanthamoeba castellanii str. Neff guanine nucleotide-binding protein beta subunit, putative (ACA1_199990), partial mRNA | blastn | 1111 | 237 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12718067 | 12718067 | PRJNA876641_P_NODE_24210_length_212_cov_2.712230_g24136_i0 | PRJNA876641 | 24210 | 212 | 2.71223 | 5.7499276 | Vannellidae | 95227 | Discosea | other_Eukaryota | 195 | 2.9299999999999997e-45 | NTclustered | gi|62865939|gb|AY929914.1| | 325077 | g24136 | i0 | 95.868 | 51.561320754717 | 121 | 3 | 56 | 2 | 47 | 165 | 1227 | 1347 | Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 10931 | 196 | 0.994897959183674 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain CAZ6/I | |||
| 18704683 | 18704683 | PRJNA876641_P_NODE_4075_length_377_cov_1.276316_g4001_i0 | PRJNA876641 | 4075 | 377 | 1.276316 | 4.81171132 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 150 | 1.2399999999999998e-31 | NTclustered | gi|470436786|ref|XM_004338880.1| | 1257118 | g4001 | i0 | 81.538 | 5.44031830238727 | 195 | 25 | 50 | 8 | 79 | 267 | 1414 | 1603 | Acanthamoeba castellanii str. Neff long chain acylcoA synthetase (ACA1_043260), partial mRNA | blastn | 2051 | 150 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 18704725 | 18704725 | PRJNA876641_P_NODE_6395_length_323_cov_1.732000_g6321_i0 | PRJNA876641 | 6395 | 323 | 1.732 | 5.59436 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 213 | 1.31e-50 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g6321 | i0 | 80.727 | 85.3529411764706 | 275 | 52 | 85 | 1 | 48 | 321 | 422 | 148 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 27569 | 213 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 18704747 | 18704747 | PRJNA876641_P_NODE_7635_length_304_cov_0.813853_g7561_i0 | PRJNA876641 | 7635 | 304 | 0.813853 | 2.47411312 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 196 | 1.24e-45 | NTclustered | gi|470486807|ref|XM_004344593.1| | 1257118 | g7561 | i0 | 80.709 | 2.45723684210526 | 254 | 47 | 83 | 2 | 13 | 265 | 66 | 318 | Acanthamoeba castellanii str. Neff MC family transporter: phosphate, putative (ACA1_278610), partial mRNA | blastn | 747 | 196 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 25079138 | 25079138 | PRJNA876641_P_NODE_12020_length_270_cov_2.106599_g11946_i0 | PRJNA876641 | 12020 | 270 | 2.106599 | 5.6878173 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 468 | 2.07e-127 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g11946 | i0 | 97.802 | 69.7851851851852 | 273 | 3 | 100 | 1 | 1 | 270 | 2635 | 2907 | 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 | 18842 | 468 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis |
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);;