contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA453567" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2368789 | 2368789 | PRJNA453567_P_NODE_17342_length_214_cov_7.621469_g17105_i0 | PRJNA453567 | 17342 | 214 | 7.621469 | 16.30994366 | Vannella | 95228 | Root_unresolved | Root_unresolved | 396 | 7.559999999999996e-106 | NTclustered | gi|507138087|gb|KC583131.1| | 590481 | g17105 | i0 | 100 | 100.630841121495 | 214 | 0 | 100 | 0 | 1 | 214 | 1025 | 1238 | Uncultured Amoebozoa clone RS.01f.10m.23 18S ribosomal RNA gene, partial sequence | blastn | 21535 | 396 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 5545649 | 5545649 | PRJNA453567_P_NODE_8905_length_321_cov_2.028169_g8668_i0 | PRJNA453567 | 8905 | 321 | 2.028169 | 6.51042249 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 63.9 | 1.39e-5 | NTclustered | gi|831768278|ref|XM_012896900.1| | 1410327 | g8668 | i0 | 97.297 | 5.26168224299065 | 37 | 1 | 12 | 0 | 73 | 109 | 243 | 279 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 1689 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 6819470 | 6819470 | PRJNA453567_P_NODE_16426_length_221_cov_1.945652_g16189_i0 | PRJNA453567 | 16426 | 221 | 1.945652 | 4.29989092 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 276 | 1.07e-69 | NTclustered | gi|470484649|ref|XM_004344039.1| | 1257118 | g16189 | i0 | 89.767 | 33.2443438914027 | 215 | 22 | 97 | 0 | 6 | 220 | 5563 | 5777 | Acanthamoeba castellanii str. Neff PremRNA processing splicing factor 8, putative (ACA1_054320), partial mRNA | blastn | 7347 | 276 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6819573 | 6819573 | PRJNA453567_P_NODE_32726_length_153_cov_1.663793_g32489_i0 | PRJNA453567 | 32726 | 153 | 1.663793 | 2.54560329 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 178 | 1.98e-40 | NTclustered | gi|1160553732|ref|XM_020572691.1| | 670386 | g32489 | i0 | 88.966 | 96.2091503267974 | 145 | 14 | 94 | 2 | 6 | 149 | 715 | 858 | Polysphondylium pallidum PN500 elongation factor 1 alpha (efaAI), partial mRNA | blastn | 14720 | 178 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 7471377 | 7471377 | PRJNA453567_P_NODE_3946_length_536_cov_84.513026_g3715_i0 | PRJNA453567 | 3946 | 536 | 84.513026 | 452.98981936 | Vannellidae | 95227 | Discosea | other_Eukaryota | 813 | 0 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g3715 | i0 | 94.413 | 99.9533582089552 | 537 | 17 | 100 | 11 | 1 | 536 | 1682 | 1158 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 53575 | 813 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 8094925 | 8094925 | PRJNA453567_P_NODE_18527_length_206_cov_2.502959_g18290_i0 | PRJNA453567 | 18527 | 206 | 2.502959 | 5.15609554 | Vexillifera multispinosa | 1105342 | Discosea | other_Eukaryota | 292 | 9.75e-75 | NTclustered | gi|354720322|gb|HQ687481.1| | 1105342 | g18290 | i0 | 92.271 | 75.747572815534 | 207 | 14 | 100 | 2 | 1 | 206 | 452 | 247 | Vexillifera multispinosa strain P124 small subunit ribosomal RNA gene, partial sequence | blastn | 15604 | 292 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera multispinosa | ||
| 9369729 | 9369729 | PRJNA453567_P_NODE_2988_length_636_cov_2.268781_g2784_i0 | PRJNA453567 | 2988 | 636 | 2.268781 | 14.42944716 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 544 | 8.549999999999998e-150 | NTclustered | gi|470484649|ref|XM_004344039.1| | 1257118 | g2784 | i0 | 82.188 | 79.6981132075472 | 640 | 106 | 100 | 7 | 1 | 636 | 6408 | 5773 | Acanthamoeba castellanii str. Neff PremRNA processing splicing factor 8, putative (ACA1_054320), partial mRNA | blastn | 50688 | 544 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10645608 | 10645608 | PRJNA453567_P_NODE_12449_length_262_cov_1.124444_g12212_i0 | PRJNA453567 | 12449 | 262 | 1.124444 | 2.94604328 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 267 | 7.84e-67 | NTclustered | gi|1914009695|gb|MT975597.1| | 313997 | g12212 | i0 | 85.171 | 95.3015267175573 | 263 | 35 | 99 | 4 | 1 | 261 | 84 | 344 | Cochliopodium minus clone 2 actin gene, partial cds | blastn | 24969 | 267 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 13195547 | 13195547 | PRJNA453567_P_NODE_9011_length_319_cov_1.624113_g8774_i0 | PRJNA453567 | 9011 | 319 | 1.624113 | 5.18092047 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 412 | 1.1899999999999997e-110 | NTclustered | gi|66821270|ref|XM_639040.1| | 352472 | g8774 | i0 | 89.969 | 96.9717868338558 | 319 | 32 | 100 | 0 | 1 | 319 | 115 | 433 | Dictyostelium discoideum AX4 hypothetical protein (act14) mRNA, complete cds | blastn | 30934 | 412 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 18293401 | 18293401 | PRJNA453567_P_NODE_13775_length_246_cov_1.861244_g13538_i0 | PRJNA453567 | 13775 | 246 | 1.861244 | 4.57866024 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 95.3 | 3.64e-15 | NTclustered | gi|831761070|ref|XM_012894692.1| | 1410327 | g13538 | i0 | 87.654 | 3.71951219512195 | 81 | 10 | 33 | 0 | 16 | 96 | 399 | 319 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 915 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 19567741 | 19567741 | PRJNA453567_P_NODE_876_length_1243_cov_2.412935_g801_i0 | PRJNA453567 | 876 | 1243 | 2.412935 | 29.99278205 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 226 | 7.069999999999998e-54 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g801 | i0 | 76.586 | 21.875301689461 | 457 | 79 | 36 | 23 | 794 | 1243 | 2295 | 1860 | 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 | 27191 | 226 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 20219657 | 20219657 | PRJNA453567_P_NODE_7336_length_362_cov_66.729231_g7099_i0 | PRJNA453567 | 7336 | 362 | 66.729231 | 241.55981622 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 532 | 1.01e-146 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g7099 | i0 | 93.048 | 101.563535911602 | 374 | 10 | 100 | 11 | 1 | 362 | 1302 | 1671 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 36766 | 532 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans |
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);;