contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA781196" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 759227 | 759227 | PRJNA781196_P_NODE_35761_length_297_cov_1.174107_g35384_i0 | PRJNA781196 | 35761 | 297 | 1.174107 | 3.48709779 | Vannella sp. strain W181G/I | 325084 | Discosea | other_Eukaryota | 532 | 8.08e-147 | NTclustered | gi|62865938|gb|AY929913.1| | 325084 | g35384 | i0 | 98.99 | 101.026936026936 | 297 | 3 | 100 | 0 | 1 | 297 | 742 | 1038 | Vannella sp. strain W181G/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 30005 | 532 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain W181G/I | |||
| 7137942 | 7137942 | PRJNA781196_P_NODE_38706_length_287_cov_1.364486_g38329_i0 | PRJNA781196 | 38706 | 287 | 1.364486 | 3.91607482 | Vannella sp. | 1973054 | Discosea | other_Eukaryota | 473 | 4.78e-129 | NTclustered | gi|2806326588|gb|PQ345838.1| | 1973054 | g38329 | i0 | 96.516 | 95.9337979094077 | 287 | 9 | 100 | 1 | 1 | 287 | 443 | 158 | Vannella sp. isolate 346_1c small subunit ribosomal RNA gene, partial sequence | blastn | 27533 | 473 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. | |||
| 7138171 | 7138171 | PRJNA781196_P_NODE_52406_length_252_cov_0.871508_g52029_i0 | PRJNA781196 | 52406 | 252 | 0.871508 | 2.19620016 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 152 | 2.19e-32 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g52029 | i0 | 92.453 | 39.7976190476191 | 106 | 8 | 42 | 0 | 147 | 252 | 306 | 201 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 10029 | 152 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 8864473 | 8864473 | PRJNA781196_P_NODE_5247_length_672_cov_3.205342_g4884_i0 | PRJNA781196 | 5247 | 672 | 3.205342 | 21.53989824 | Vannella | 95228 | Discosea | other_Eukaryota | 1138 | 0 | NTclustered | gi|861554667|gb|KP719197.1| | 197532 | g4884 | i0 | 97.024 | 80.2083333333333 | 672 | 20 | 100 | 0 | 1 | 672 | 632 | 1303 | Vannella simplex strain A17WVB small subunit ribosomal RNA gene, partial sequence | blastn | 53900 | 1140 | 0.998245614035088 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella simplex | |||
| 12238715 | 12238715 | PRJNA781196_P_NODE_22310_length_361_cov_1.500000_g21933_i0 | PRJNA781196 | 22310 | 361 | 1.5 | 5.415 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 630 | 3.459999999999999e-176 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g21933 | i0 | 98.082 | 74.398891966759 | 365 | 2 | 100 | 3 | 1 | 361 | 806 | 1169 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 26858 | 630 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 14788026 | 14788026 | PRJNA781196_P_NODE_48492_length_256_cov_3.836066_g48115_i0 | PRJNA781196 | 48492 | 256 | 3.836066 | 9.82032896 | Vannella ebro | 207334 | Discosea | other_Eukaryota | 361 | 3.4e-95 | NTclustered | gi|33946344|gb|AY294151.1| | 207334 | g48115 | i0 | 92.157 | 95.6171875 | 255 | 20 | 99 | 0 | 2 | 256 | 13 | 267 | Vannella ebro actin mRNA, complete cds | blastn | 24478 | 361 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella ebro | |||
| 14788365 | 14788365 | PRJNA781196_P_NODE_68332_length_205_cov_4.196970_g67955_i0 | PRJNA781196 | 68332 | 205 | 4.19697 | 8.6037885 | Vannella simplex | 197532 | Discosea | other_Eukaryota | 379 | 7.229999999999999e-101 | NTclustered | gi|284192609|gb|GQ265407.1| | 197532 | g67955 | i0 | 100 | 100.190243902439 | 205 | 0 | 100 | 0 | 1 | 205 | 472 | 676 | Vannella simplex strain L4A Cl 4/1/2 clone A147.4 18S ribosomal RNA gene, partial sequence | blastn | 20539 | 379 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella simplex | |||
| 14788399 | 14788399 | PRJNA781196_P_NODE_992_length_1355_cov_7.443058_g841_i0 | PRJNA781196 | 992 | 1355 | 7.443058 | 100.8534359 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 809 | 0 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g841 | i0 | 78.886 | 69.5372693726937 | 1203 | 246 | 88 | 7 | 45 | 1243 | 2 | 1200 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 94223 | 809 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 21161726 | 21161726 | PRJNA781196_P_NODE_25757_length_340_cov_2.842697_g25380_i0 | PRJNA781196 | 25757 | 340 | 2.842697 | 9.6651698 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 466 | 9.68e-127 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g25380 | i0 | 91.892 | 96.4470588235294 | 333 | 27 | 98 | 0 | 1 | 333 | 698 | 1030 | Platyamoeba placida actin mRNA, partial cds | blastn | 32792 | 466 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 23712626 | 23712626 | PRJNA781196_P_NODE_8259_length_549_cov_1.363445_g7884_i0 | PRJNA781196 | 8259 | 549 | 1.363445 | 7.48531305 | Vannella sp. strain CAZ6/I | 325077 | Discosea | other_Eukaryota | 856 | 0 | NTclustered | gi|62865939|gb|AY929914.1| | 325077 | g7884 | i0 | 94.746 | 102.326047358834 | 552 | 25 | 100 | 4 | 1 | 549 | 12 | 562 | Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 56177 | 856 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain CAZ6/I | |||
| 25437971 | 25437971 | PRJNA781196_P_NODE_25800_length_340_cov_1.745318_g25423_i0 | PRJNA781196 | 25800 | 340 | 1.745318 | 5.9340812 | Vannella | 95228 | Discosea | other_Eukaryota | 606 | 5.469999999999998e-169 | NTclustered | gi|399764213|gb|JQ271724.1| | 1215628 | g25423 | i0 | 98.824 | 89.2941176470588 | 340 | 4 | 100 | 0 | 1 | 340 | 1894 | 1555 | Vannella sp. ACN1 18S ribosomal RNA gene, partial sequence | blastn | 30360 | 608 | 0.996710526315789 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. ACN1 |
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);;