contig_metadata
10 rows where bioproject = "PRJNA745553", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724015 | 724015 | PRJNA745553_S_NODE_12561_length_346_cov_6.582418_g12366_i0 | PRJNA745553 | 12561 | 346 | 6.582418 | 22.77516628 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 224 | 6.56e-54 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g12366 | i0 | 81.69 | 6.35838150289017 | 284 | 38 | 80 | 13 | 1 | 278 | 276 | 1 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 2200 | 224 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 2000165 | 2000165 | PRJNA745553_S_NODE_17642_length_294_cov_1.393665_g17447_i0 | PRJNA745553 | 17642 | 294 | 1.393665 | 4.0973751 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 488 | 1.7499999999999996e-133 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g17447 | i0 | 96.599 | 5.5578231292517 | 294 | 10 | 100 | 0 | 1 | 294 | 1616 | 1323 | 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 | 1634 | 488 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 2473977 | 2473977 | PRJNA745553_S_NODE_11522_length_360_cov_7.247387_g11327_i0 | PRJNA745553 | 11522 | 360 | 7.247387 | 26.0905932 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 569 | 7.62e-158 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g11327 | i0 | 98.75 | 68.2555555555556 | 320 | 4 | 89 | 0 | 19 | 338 | 1223 | 904 | 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 | 24572 | 569 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3275644 | 3275644 | PRJNA745553_S_NODE_29743_length_214_cov_4.134752_g29548_i0 | PRJNA745553 | 29743 | 214 | 4.134752 | 8.84836928 | Phryganella paradoxa | 2217853 | Tubulinea | other_Eukaryota | 257 | 3.72e-64 | NTclustered | gi|1397644527|gb|MF497378.1| | 2217853 | g29548 | i0 | 90.769 | 0.911214953271028 | 195 | 15 | 90 | 3 | 1 | 193 | 834 | 641 | Phryganella paradoxa isolate KD1032 18S ribosomal RNA gene, partial sequence | blastn | 195 | 257 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Phryganellidae | Phryganella | Phryganella paradoxa | ||
| 7103153 | 7103153 | PRJNA745553_S_NODE_9006_length_402_cov_2.896657_g8811_i0 | PRJNA745553 | 9006 | 402 | 2.896657 | 11.64456114 | Phryganella paradoxa | 2217853 | Tubulinea | other_Eukaryota | 569 | 8.6e-158 | NTclustered | gi|1397644527|gb|MF497378.1| | 2217853 | g8811 | i0 | 93.766 | 68.5298507462687 | 385 | 15 | 94 | 4 | 27 | 402 | 1062 | 678 | Phryganella paradoxa isolate KD1032 18S ribosomal RNA gene, partial sequence | blastn | 27549 | 569 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Phryganellidae | Phryganella | Phryganella paradoxa | ||
| 9652623 | 9652623 | PRJNA745553_S_NODE_20348_length_274_cov_2.800995_g20153_i0 | PRJNA745553 | 20348 | 274 | 2.800995 | 7.6747263 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 185 | 2.3799999999999993e-42 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g20153 | i0 | 79.554 | 54.4525547445255 | 269 | 48 | 96 | 7 | 2 | 265 | 2579 | 2313 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 14920 | 185 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 10928153 | 10928153 | PRJNA745553_S_NODE_19829_length_277_cov_8.970588_g19634_i0 | PRJNA745553 | 19829 | 277 | 8.970588 | 24.84852876 | Phryganella paradoxa | 2217853 | Tubulinea | other_Eukaryota | 344 | 3.75e-90 | NTclustered | gi|1397644527|gb|MF497378.1| | 2217853 | g19634 | i0 | 94.273 | 46.2563176895307 | 227 | 9 | 81 | 4 | 23 | 245 | 1702 | 1928 | Phryganella paradoxa isolate KD1032 18S ribosomal RNA gene, partial sequence | blastn | 12813 | 344 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Phryganellidae | Phryganella | Phryganella paradoxa | ||
| 13478064 | 13478064 | PRJNA745553_S_NODE_25411_length_246_cov_4.843931_g25216_i0 | PRJNA745553 | 25411 | 246 | 4.843931 | 11.91607026 | Phryganella paradoxa | 2217853 | Tubulinea | other_Eukaryota | 307 | 4.2900000000000005e-79 | NTclustered | gi|1397644527|gb|MF497378.1| | 2217853 | g25216 | i0 | 91.964 | 36.369918699187 | 224 | 10 | 88 | 4 | 23 | 238 | 1705 | 1928 | Phryganella paradoxa isolate KD1032 18S ribosomal RNA gene, partial sequence | blastn | 8947 | 307 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Phryganellidae | Phryganella | Phryganella paradoxa | ||
| 18575732 | 18575732 | PRJNA745553_S_NODE_1295_length_726_cov_11.637060_g1169_i0 | PRJNA745553 | 1295 | 726 | 11.63706 | 84.4850556 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1303 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g1169 | i0 | 99.036 | 54.896694214876 | 726 | 7 | 100 | 0 | 1 | 726 | 5792 | 5067 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 39855 | 1303 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22401488 | 22401488 | PRJNA745553_S_NODE_12618_length_346_cov_1.904762_g12423_i0 | PRJNA745553 | 12618 | 346 | 1.904762 | 6.59047652 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 169 | 3.12e-37 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g12423 | i0 | 78.927 | 3.07803468208092 | 261 | 46 | 74 | 6 | 48 | 302 | 2095 | 1838 | Rhizamoeba saxonica 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 | 1065 | 169 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica |
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);;