contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA800090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 797505 | 797505 | PRJNA800090_P_NODE_153001_length_253_cov_1.586957_g150816_i0 | PRJNA800090 | 153001 | 253 | 1.586957 | 4.01500121 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 307 | 4.44e-79 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g150816 | i0 | 89.069 | 98.3083003952569 | 247 | 27 | 98 | 0 | 4 | 250 | 579 | 333 | Platyamoeba placida actin mRNA, partial cds | blastn | 24872 | 307 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 3347991 | 3347991 | PRJNA800090_P_NODE_130123_length_277_cov_3.687500_g127938_i0 | PRJNA800090 | 130123 | 277 | 3.6875 | 10.214375 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 403 | 6.11e-108 | NTclustered | gi|1269228469|gb|MF683594.1| | 2047823 | g127938 | i0 | 95.312 | 81.115523465704 | 256 | 9 | 92 | 3 | 1 | 254 | 928 | 674 | Ripella tribonemae clone 22.1.12 18S ribosomal RNA gene, partial sequence | blastn | 22469 | 403 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 7176725 | 7176725 | PRJNA800090_P_NODE_192686_length_228_cov_0.918239_g190501_i0 | PRJNA800090 | 192686 | 228 | 0.918239 | 2.09358492 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 326 | 1.08e-84 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g190501 | i0 | 92.544 | 79.5219298245614 | 228 | 15 | 100 | 2 | 1 | 228 | 11 | 236 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 18131 | 326 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 7177547 | 7177547 | PRJNA800090_P_NODE_50806_length_501_cov_2.796296_g48624_i0 | PRJNA800090 | 50806 | 501 | 2.796296 | 14.00944296 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 344 | 7.209999999999998e-90 | NTclustered | gi|470380222|ref|XM_004333620.1| | 1257118 | g48624 | i0 | 80.866 | 74.6646706586826 | 439 | 82 | 87 | 2 | 2 | 439 | 449 | 12 | Acanthamoeba castellanii str. Neff ran, putative (ACA1_260190), partial mRNA | blastn | 37407 | 344 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8450947 | 8450947 | PRJNA800090_P_NODE_169787_length_238_cov_1.189349_g167602_i0 | PRJNA800090 | 169787 | 238 | 1.189349 | 2.83065062 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 337 | 5.27e-88 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g167602 | i0 | 92.469 | 13.1344537815126 | 239 | 13 | 100 | 4 | 1 | 238 | 385 | 151 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 3126 | 337 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 8452781 | 8452781 | PRJNA800090_P_NODE_76227_length_386_cov_1.381703_g74042_i0 | PRJNA800090 | 76227 | 386 | 1.381703 | 5.33337358 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 292 | 1.99e-74 | NTclustered | gi|470442906|ref|XM_004339540.1| | 1257118 | g74042 | i0 | 84.459 | 20.9974093264249 | 296 | 46 | 77 | 0 | 27 | 322 | 315 | 20 | Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA | blastn | 8105 | 292 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10149534 | 10149534 | PRJNA800090_P_NODE_56748_length_466_cov_3.879093_g54564_i0 | PRJNA800090 | 56748 | 466 | 3.879093 | 18.07657338 | Vannellidae | 95227 | Discosea | other_Eukaryota | 647 | 0 | NTclustered | gi|327391632|gb|HM363630.1| | 1002217 | g54564 | i0 | 94.55 | 100.510729613734 | 422 | 18 | 90 | 3 | 1 | 418 | 56 | 476 | Vannella sp. GERL14 small subunit ribosomal RNA gene, partial sequence | blastn | 46838 | 647 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. GERL14 | |||
| 11003532 | 11003532 | PRJNA800090_P_NODE_70809_length_405_cov_1.437500_g68624_i0 | PRJNA800090 | 70809 | 405 | 1.4375 | 5.821875 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 311 | 5.81e-80 | NTclustered | gi|470418521|ref|XM_004337050.1| | 1257118 | g68624 | i0 | 82.825 | 74.1802469135802 | 361 | 49 | 89 | 7 | 11 | 369 | 359 | 10 | Acanthamoeba castellanii str. Neff cyclophylin, putative (ACA1_215460), partial mRNA | blastn | 30043 | 311 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16100045 | 16100045 | PRJNA800090_P_NODE_153253_length_253_cov_1.554348_g151068_i0 | PRJNA800090 | 153253 | 253 | 1.554348 | 3.93250044 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 374 | 4.31e-99 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g151068 | i0 | 93.103 | 73.3715415019763 | 261 | 9 | 100 | 4 | 1 | 253 | 2112 | 1853 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 18563 | 374 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 25025647 | 25025647 | PRJNA800090_P_NODE_45480_length_538_cov_1.663113_g43308_i0 | PRJNA800090 | 45480 | 538 | 1.663113 | 8.94754794 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 433 | 1.6199999999999995e-116 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g43308 | i0 | 81.262 | 64.407063197026 | 539 | 97 | 99 | 4 | 1 | 537 | 629 | 93 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 34651 | 433 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 25447734 | 25447734 | PRJNA800090_P_NODE_61360_length_443_cov_3.358289_g59176_i0 | PRJNA800090 | 61360 | 443 | 3.358289 | 14.87722027 | Ripella | 1217112 | Discosea | other_Eukaryota | 647 | 0 | NTclustered | gi|1269228431|gb|MF683556.1| | 2047822 | g59176 | i0 | 94.976 | 94.4243792325056 | 418 | 12 | 94 | 6 | 27 | 443 | 1234 | 1643 | Ripella decalvata clone 26.2.11 18S ribosomal RNA gene, partial sequence | blastn | 41830 | 647 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata |
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);;