contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA309466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1651666 | 1651666 | PRJNA309466_P_NODE_7822_length_217_cov_7.440476_g7765_i0 | PRJNA309466 | 7822 | 217 | 7.440476 | 16.14583292 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 363 | 7.8e-96 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g7765 | i0 | 98.077 | 94.2718894009217 | 208 | 4 | 96 | 0 | 6 | 213 | 20177 | 20384 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 20457 | 363 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3613771 | 3613771 | PRJNA309466_P_NODE_7223_length_223_cov_3.948276_g7166_i0 | PRJNA309466 | 7223 | 223 | 3.948276 | 8.80465548 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 339 | 1.36e-88 | NTclustered | gi|2675812010|gb|PP339676.1| | 5778 | g7166 | i0 | 100 | 102.242152466368 | 183 | 0 | 99 | 0 | 40 | 222 | 324 | 142 | Vermamoeba vermiformis isolate TFEW12 small subunit ribosomal RNA gene, partial sequence | blastn | 22800 | 339 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5480336 | 5480336 | PRJNA309466_P_NODE_6945_length_226_cov_3.457627_g6888_i0 | PRJNA309466 | 6945 | 226 | 3.457627 | 7.81423702 | Echinosteliopsis oligospora | 1908696 | Evosea | other_Eukaryota | 383 | 6.28e-102 | NTclustered | gi|1465309723|gb|MH809394.1| | 1908696 | g6888 | i0 | 98.174 | 96.4513274336283 | 219 | 4 | 97 | 0 | 2 | 220 | 1167 | 1385 | Echinosteliopsis oligospora isolate HH14-A2-1A small subunit ribosomal RNA gene, partial sequence | blastn | 21798 | 383 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliopsidaceae | Echinosteliopsis | Echinosteliopsis oligospora | |||
| 6165824 | 6165824 | PRJNA309466_P_NODE_17125_length_164_cov_2.582609_g17068_i0 | PRJNA309466 | 17125 | 164 | 2.582609 | 4.23547876 | Physaraceae | 1115744 | Evosea | other_Eukaryota | 135 | 1.32e-27 | NTclustered | gi|117165490|dbj|AB259503.1| | 385460 | g17068 | i0 | 83.333 | 91.8231707317073 | 150 | 22 | 91 | 3 | 16 | 164 | 388 | 241 | Physarum crateriforme gene for small subunit ribosomal RNA, partial sequence, specimen_voucher: TNS-M-Y-17855 (TNS) | blastn | 15059 | 135 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum crateriforme | ||
| 6754422 | 6754422 | PRJNA309466_P_NODE_12686_length_182_cov_11.541353_g12629_i0 | PRJNA309466 | 12686 | 182 | 11.541353 | 21.00526246 | Tubulinea group 04 sp. CAL5 | 1215995 | Tubulinea | other_Eukaryota | 313 | 6.43e-81 | NTclustered | gi|399764275|gb|JQ271786.1| | 1215995 | g12629 | i0 | 98.315 | 77.3736263736264 | 178 | 3 | 98 | 0 | 1 | 178 | 1504 | 1681 | Tubulinea group 04 sp. CAL5 18S ribosomal RNA gene, partial sequence | blastn | 14082 | 313 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. CAL5 | ||||||
| 13130592 | 13130592 | PRJNA309466_P_NODE_15011_length_171_cov_1.622951_g14954_i0 | PRJNA309466 | 15011 | 171 | 1.622951 | 2.77524621 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 305 | 9.96e-79 | NTclustered | gi|507138087|gb|KC583131.1| | 590481 | g14954 | i0 | 98.83 | 101.210526315789 | 171 | 2 | 100 | 0 | 1 | 171 | 553 | 723 | Uncultured Amoebozoa clone RS.01f.10m.23 18S ribosomal RNA gene, partial sequence | blastn | 17307 | 305 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 13130651 | 13130651 | PRJNA309466_P_NODE_3691_length_306_cov_10.431907_g3635_i0 | PRJNA309466 | 3691 | 306 | 10.431907 | 31.92163542 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 296 | 1.19e-75 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g3635 | i0 | 84.466 | 18.9411764705882 | 309 | 39 | 100 | 9 | 1 | 306 | 56 | 358 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 5796 | 296 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 15090863 | 15090863 | PRJNA309466_P_NODE_5992_length_239_cov_4.947368_g5935_i0 | PRJNA309466 | 5992 | 239 | 4.947368 | 11.82420952 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 436 | 5.0799999999999985e-118 | NTclustered | gi|399764275|gb|JQ271786.1| | 1215995 | g5935 | i0 | 100 | 71.397489539749 | 236 | 0 | 99 | 0 | 2 | 237 | 1139 | 904 | Tubulinea group 04 sp. CAL5 18S ribosomal RNA gene, partial sequence | blastn | 17064 | 436 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. CAL5 | ||||||
| 15679632 | 15679632 | PRJNA309466_P_NODE_6113_length_237_cov_1.930851_g6056_i0 | PRJNA309466 | 6113 | 237 | 1.930851 | 4.57611687 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 353 | 5.209999999999998e-93 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g6056 | i0 | 99.485 | 55.704641350211 | 194 | 1 | 97 | 0 | 4 | 197 | 2348 | 2541 | Hartmannella vermiformis 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 | 13202 | 353 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 15679648 | 15679648 | PRJNA309466_P_NODE_7733_length_218_cov_4.408284_g7676_i0 | PRJNA309466 | 7733 | 218 | 4.408284 | 9.61005912 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 224 | 3.859999999999999e-54 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g7676 | i0 | 85.52 | 1.01376146788991 | 221 | 25 | 100 | 7 | 1 | 218 | 26006 | 25790 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 221 | 224 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20778283 | 20778283 | PRJNA309466_P_NODE_10877_length_193_cov_25.798611_g10820_i0 | PRJNA309466 | 10877 | 193 | 25.798611 | 49.79131923 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 335 | 1.48e-87 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g10820 | i0 | 98.421 | 98.9481865284974 | 190 | 3 | 98 | 0 | 3 | 192 | 3849 | 3660 | Hartmannella vermiformis 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 | 19097 | 335 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22053262 | 22053262 | PRJNA309466_P_NODE_10298_length_197_cov_3.020270_g10241_i0 | PRJNA309466 | 10298 | 197 | 3.02027 | 5.9499319 | Tubulinea group 04 sp. CAL5 | 1215995 | Tubulinea | other_Eukaryota | 363 | 6.939999999999998e-96 | NTclustered | gi|399764275|gb|JQ271786.1| | 1215995 | g10241 | i0 | 100 | 14.0710659898477 | 196 | 0 | 99 | 0 | 2 | 197 | 218 | 413 | Tubulinea group 04 sp. CAL5 18S ribosomal RNA gene, partial sequence | blastn | 2772 | 363 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. CAL5 | ||||||
| 24014788 | 24014788 | PRJNA309466_P_NODE_11179_length_191_cov_4.845070_g11122_i0 | PRJNA309466 | 11179 | 191 | 4.84507 | 9.2540837 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 339 | 1.13e-88 | NTclustered | gi|441475833|emb|FN562425.4| | 688089 | g11122 | i0 | 100 | 50.848167539267 | 183 | 0 | 96 | 0 | 2 | 184 | 422 | 604 | Amoebozoa sp. SZA36 18S rRNA gene, isolate SZA36 | blastn | 9712 | 339 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. SZA36 | |||||||
| 25289127 | 25289127 | PRJNA309466_P_NODE_14340_length_174_cov_1.744000_g14283_i0 | PRJNA309466 | 14340 | 174 | 1.744 | 3.03456 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 311 | 2.19e-80 | NTclustered | gi|89243398|gb|DQ407529.1| | 5778 | g14283 | i0 | 99.415 | 98.3218390804598 | 171 | 1 | 98 | 0 | 4 | 174 | 440 | 270 | Hartmannella vermiformis isolate WWS1.5 18S ribosomal RNA gene gene, partial sequence | blastn | 17108 | 311 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;