contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA376117" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2950464 | 2950464 | PRJNA376117_P_NODE_26843_length_276_cov_1.896552_g26541_i0 | PRJNA376117 | 26843 | 276 | 1.896552 | 5.23448352 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 416 | 7.809999999999998e-112 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g26541 | i0 | 93.841 | 103.101449275362 | 276 | 17 | 100 | 0 | 1 | 276 | 662 | 387 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 28456 | 416 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 4227340 | 4227340 | PRJNA376117_P_NODE_7864_length_478_cov_1.439506_g7563_i0 | PRJNA376117 | 7864 | 478 | 1.439506 | 6.88083868 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 728 | 0 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g7563 | i0 | 94.142 | 98.4832635983264 | 478 | 28 | 100 | 0 | 1 | 478 | 920 | 443 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 47075 | 728 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 4227360 | 4227360 | PRJNA376117_P_NODE_9704_length_432_cov_1.211699_g9402_i0 | PRJNA376117 | 9704 | 432 | 1.211699 | 5.23453968 | Vexillifera bacillipedes | 1105345 | Discosea | other_Eukaryota | 750 | 0 | NTclustered | gi|399764261|gb|JQ271772.1| | 1105345 | g9402 | i0 | 98.152 | 73.8518518518518 | 433 | 3 | 99 | 3 | 2 | 432 | 687 | 258 | Vexillifera bacillipedes strain 6HZM 18S ribosomal RNA gene, partial sequence | blastn | 31904 | 750 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera bacillipedes | ||
| 7451721 | 7451721 | PRJNA376117_P_NODE_38866_length_246_cov_1.427746_g38564_i0 | PRJNA376117 | 38866 | 246 | 1.427746 | 3.51225516 | Vannellidae | 95227 | Discosea | other_Eukaryota | 414 | 2.46e-111 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g38564 | i0 | 97.908 | 96.8211382113821 | 239 | 5 | 97 | 0 | 1 | 239 | 1477 | 1239 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 23818 | 414 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 10603908 | 10603908 | PRJNA376117_P_NODE_5329_length_590_cov_2.220503_g5033_i0 | PRJNA376117 | 5329 | 590 | 2.220503 | 13.1009677 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 791 | 0 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g5033 | i0 | 93.738 | 93.4440677966102 | 527 | 33 | 89 | 0 | 64 | 590 | 1131 | 605 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 55132 | 791 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 11878391 | 11878391 | PRJNA376117_P_NODE_14610_length_358_cov_2.985965_g14308_i0 | PRJNA376117 | 14610 | 358 | 2.985965 | 10.6897547 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 278 | 5.14e-70 | NTclustered | gi|470442906|ref|XM_004339540.1| | 1257118 | g14308 | i0 | 83.168 | 18.4329608938547 | 303 | 51 | 85 | 0 | 11 | 313 | 315 | 13 | Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA | blastn | 6599 | 278 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13153555 | 13153555 | PRJNA376117_P_NODE_22491_length_291_cov_2.825688_g22189_i0 | PRJNA376117 | 22491 | 291 | 2.825688 | 8.22275208 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 366 | 8.48e-97 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g22189 | i0 | 89.347 | 87.6185567010309 | 291 | 31 | 100 | 0 | 1 | 291 | 764 | 474 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 25497 | 366 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 14428922 | 14428922 | PRJNA376117_P_NODE_9632_length_433_cov_1.827778_g9330_i0 | PRJNA376117 | 9632 | 433 | 1.827778 | 7.91427874 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 693 | 0 | NTclustered | gi|1269228437|gb|MF683562.1| | 2047822 | g9330 | i0 | 95.853 | 99.6697459584296 | 434 | 9 | 99 | 7 | 1 | 428 | 1045 | 615 | Ripella decalvata clone 15101 18S ribosomal RNA gene, partial sequence | blastn | 43157 | 693 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 16977367 | 16977367 | PRJNA376117_P_NODE_37434_length_248_cov_0.880000_g37132_i0 | PRJNA376117 | 37434 | 248 | 0.88 | 2.1824 | Dermamoeba algensis | 242549 | Discosea | other_Eukaryota | 263 | 9.519999999999998e-66 | NTclustered | gi|33946360|gb|AY294159.1| | 242549 | g37132 | i0 | 86.555 | 96.1854838709677 | 238 | 32 | 96 | 0 | 4 | 241 | 81 | 318 | Dermamoeba algensis actin mRNA, partial cds | blastn | 23854 | 263 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Dermamoeba | Dermamoeba algensis | ||||
| 16977410 | 16977410 | PRJNA376117_P_NODE_40254_length_245_cov_0.895349_g39952_i0 | PRJNA376117 | 40254 | 245 | 0.895349 | 2.19360505 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 340 | 4.209999999999999e-89 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g39952 | i0 | 91.803 | 84.2571428571429 | 244 | 20 | 99 | 0 | 1 | 244 | 622 | 865 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 20643 | 340 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 18251790 | 18251790 | PRJNA376117_P_NODE_6015_length_550_cov_1.129979_g5715_i0 | PRJNA376117 | 6015 | 550 | 1.129979 | 6.2148845 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 475 | 2.7099999999999994e-129 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g5715 | i0 | 82.482 | 97.28 | 548 | 90 | 99 | 6 | 1 | 545 | 2339 | 1795 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 53504 | 475 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19525623 | 19525623 | PRJNA376117_P_NODE_20816_length_303_cov_1.165217_g20514_i0 | PRJNA376117 | 20816 | 303 | 1.165217 | 3.53060751 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 361 | 4.13e-95 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g20514 | i0 | 95.197 | 81.2937293729373 | 229 | 9 | 75 | 2 | 76 | 303 | 1134 | 907 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 24632 | 361 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 23351929 | 23351929 | PRJNA376117_P_NODE_34639_length_250_cov_1.644068_g34337_i0 | PRJNA376117 | 34639 | 250 | 1.644068 | 4.11017 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 436 | 5.349999999999999e-118 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g34337 | i0 | 98.024 | 61.136 | 253 | 2 | 100 | 1 | 1 | 250 | 2619 | 2871 | 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 | 15284 | 436 | 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);;