contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA683669" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 664858 | 664858 | PRJNA683669_P_NODE_11021_length_388_cov_4.882540_g10790_i0 | PRJNA683669 | 11021 | 388 | 4.88254 | 18.9442552 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 292 | 2.01e-74 | NTclustered | gi|470442906|ref|XM_004339540.1| | 1257118 | g10790 | i0 | 84.88 | 25.139175257732 | 291 | 42 | 75 | 2 | 43 | 332 | 330 | 41 | Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA | blastn | 9754 | 292 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 1940970 | 1940970 | PRJNA683669_P_NODE_2662_length_806_cov_4.182810_g2467_i0 | PRJNA683669 | 2662 | 806 | 4.18281 | 33.7134486 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 627 | 1.0599999999999999e-174 | NTclustered | gi|2048770422|gb|MW534135.1| | 437603 | g2467 | i0 | 82.289 | 43.227047146402 | 734 | 120 | 90 | 9 | 64 | 792 | 741 | 13 | Paramoeba perurans isolate PPER_00019895 multifunctional chaperone mRNA, complete cds | blastn | 34841 | 627 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans | ||
| 8318030 | 8318030 | PRJNA683669_P_NODE_10707_length_393_cov_2.150000_g10476_i0 | PRJNA683669 | 10707 | 393 | 2.15 | 8.4495 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 355 | 2.56e-93 | NTclustered | gi|2048770422|gb|MW534135.1| | 437603 | g10476 | i0 | 83.684 | 26.972010178117 | 380 | 58 | 96 | 3 | 2 | 379 | 390 | 13 | Paramoeba perurans isolate PPER_00019895 multifunctional chaperone mRNA, complete cds | blastn | 10600 | 355 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans | ||
| 9593558 | 9593558 | PRJNA683669_P_NODE_20188_length_287_cov_1.401869_g19956_i0 | PRJNA683669 | 20188 | 287 | 1.401869 | 4.02336403 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 152 | 2.5399999999999996e-32 | NTclustered | gi|2635491373|gb|OR923386.1| | 437603 | g19956 | i0 | 81.407 | 2.90243902439024 | 199 | 26 | 68 | 9 | 24 | 218 | 914 | 723 | Paramoeba perurans clone PPER_00013037 heat shock 90 mRNA, complete cds | blastn | 833 | 152 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans | ||
| 10868922 | 10868922 | PRJNA683669_P_NODE_19169_length_295_cov_0.891892_g18937_i0 | PRJNA683669 | 19169 | 295 | 0.891892 | 2.6310814 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 65.8 | 3.52e-6 | NTclustered | gi|470372090|ref|XM_004332845.1| | 1257118 | g18937 | i0 | 95.122 | 0.379661016949153 | 41 | 2 | 14 | 0 | 225 | 265 | 4226 | 4186 | Acanthamoeba castellanii str. Neff putative DNA helicase (ACA1_144810), partial mRNA | blastn | 112 | 65.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12144478 | 12144478 | PRJNA683669_P_NODE_710_length_1408_cov_8.776779_g624_i0 | PRJNA683669 | 710 | 1408 | 8.776779 | 123.57704832 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 1251 | 0 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g624 | i0 | 85.465 | 65.4225852272727 | 1204 | 169 | 85 | 6 | 141 | 1341 | 1202 | 2 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 92115 | 1251 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 17242964 | 17242964 | PRJNA683669_P_NODE_34254_length_238_cov_3.593939_g34022_i0 | PRJNA683669 | 34254 | 238 | 3.593939 | 8.55357482 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 270 | 5.42e-68 | NTclustered | gi|575488798|gb|KF772979.1| | 180228 | g34022 | i0 | 88.393 | 92.8025210084034 | 224 | 26 | 94 | 0 | 2 | 225 | 224 | 1 | Paramoeba pemaquidensis strain PA027 beta actin mRNA, partial cds | blastn | 22087 | 270 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 22342223 | 22342223 | PRJNA683669_P_NODE_19618_length_291_cov_1.059633_g19386_i0 | PRJNA683669 | 19618 | 291 | 1.059633 | 3.08353203 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 272 | 1.8999999999999998e-68 | NTclustered | gi|2048770422|gb|MW534135.1| | 437603 | g19386 | i0 | 86.345 | 9.43986254295533 | 249 | 34 | 86 | 0 | 1 | 249 | 493 | 741 | Paramoeba perurans isolate PPER_00019895 multifunctional chaperone mRNA, complete cds | blastn | 2747 | 272 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans |
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);;