contig_metadata
18 rows where bioproject = "PRJEB7799", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25664406 | 25664406 | PRJEB7799n_S_NODE_3602_length_238_cov_3.719212_g3565_i0 | PRJEB7799 | 3602 | 238 | 3.719212 | 8.85172456 | Cryptodifflugia oviformis | 1165352 | Tubulinea | other_Eukaryota | 416 | 6.579999999999998e-112 | NTclustered | gi|2517949720|gb|OR125025.1| | 1165352 | g3565 | i0 | 98.319 | 95.1848739495798 | 238 | 3 | 100 | 1 | 1 | 238 | 797 | 1033 | Cryptodifflugia oviformis isolate strain_9 small subunit ribosomal RNA gene, partial sequence | blastn | 22654 | 416 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia oviformis | ||
| 25753248 | 25753248 | PRJEB7799j_S_NODE_194_length_279_cov_11.897541_g189_i0 | PRJEB7799 | 194 | 279 | 11.897541 | 33.19413939 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 490 | 4.59e-134 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g189 | i0 | 98.556 | 37.4802867383513 | 277 | 4 | 99 | 0 | 3 | 279 | 946 | 1222 | 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 | 10457 | 490 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25753503 | 25753503 | PRJEB7799n_S_NODE_6818_length_186_cov_3.894040_g6781_i0 | PRJEB7799 | 6818 | 186 | 3.89404 | 7.2429144 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 344 | 2.34e-90 | NTclustered | gi|2675812010|gb|PP339676.1| | 5778 | g6781 | i0 | 100 | 100 | 186 | 0 | 100 | 0 | 1 | 186 | 107 | 292 | Vermamoeba vermiformis isolate TFEW12 small subunit ribosomal RNA gene, partial sequence | blastn | 18600 | 344 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25797945 | 25797945 | PRJEB7799a_S_NODE_1411_length_339_cov_8.101974_g1376_i0 | PRJEB7799 | 1411 | 339 | 8.101974 | 27.46569186 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 431 | 3.519999999999999e-116 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g1376 | i0 | 90.12 | 84.976401179941 | 334 | 30 | 98 | 3 | 8 | 339 | 3904 | 3572 | 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 | 28807 | 431 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25798357 | 25798357 | PRJEB7799a_S_NODE_5163_length_222_cov_7.780749_g5128_i0 | PRJEB7799 | 5163 | 222 | 7.780749 | 17.27326278 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 372 | 1.33e-98 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g5128 | i0 | 96.847 | 37.1396396396396 | 222 | 7 | 100 | 0 | 1 | 222 | 4399 | 4178 | 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 | 8245 | 372 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25799709 | 25799709 | PRJEB7799k_S_NODE_1963_length_201_cov_3.692771_g1957_i0 | PRJEB7799 | 1963 | 201 | 3.692771 | 7.42246971 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 76.8 | 1.04e-9 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g1957 | i0 | 77.863 | 0.651741293532338 | 131 | 23 | 64 | 5 | 73 | 201 | 4312 | 4186 | 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 | 131 | 76.8 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 25800662 | 25800662 | PRJEB7799n_S_NODE_7395_length_181_cov_1.869863_g7358_i0 | PRJEB7799 | 7395 | 181 | 1.869863 | 3.38445203 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 329 | 6.340000000000001e-86 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g7358 | i0 | 100 | 3.38121546961326 | 178 | 0 | 98 | 0 | 1 | 178 | 3493 | 3670 | 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 | 612 | 329 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25800820 | 25800820 | PRJEB7799o_S_NODE_4835_length_152_cov_5.974359_g4827_i0 | PRJEB7799 | 4835 | 152 | 5.974359 | 9.08102568 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 86.1 | 1.23e-12 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g4827 | i0 | 93.22 | 57.6842105263158 | 59 | 3 | 39 | 1 | 92 | 150 | 4366 | 4423 | 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 | 8768 | 86.1 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25934375 | 25934375 | PRJEB7799a_S_NODE_2044_length_301_cov_15.266917_g2009_i0 | PRJEB7799 | 2044 | 301 | 15.266917 | 45.95342017 | Cryptodifflugia oviformis | 1165352 | Tubulinea | other_Eukaryota | 523 | 4.939999999999998e-144 | NTclustered | gi|2517949732|gb|OR125031.1| | 1165352 | g2009 | i0 | 98.007 | 78.0033222591362 | 301 | 6 | 100 | 0 | 1 | 301 | 735 | 1035 | Cryptodifflugia oviformis isolate strain_6 small subunit ribosomal RNA gene, partial sequence | blastn | 23479 | 523 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia oviformis | ||
| 25934695 | 25934695 | PRJEB7799a_S_NODE_788_length_402_cov_16.711172_g753_i0 | PRJEB7799 | 788 | 402 | 16.711172 | 67.17891144 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 632 | 1.0799999999999996e-176 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g753 | i0 | 96.825 | 63.5024875621891 | 378 | 12 | 94 | 0 | 25 | 402 | 2659 | 2282 | 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 | 25528 | 632 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25935070 | 25935070 | PRJEB7799d_S_NODE_1228_length_255_cov_5.668182_g1218_i0 | PRJEB7799 | 1228 | 255 | 5.668182 | 14.4538641 | Cryptodifflugia oviformis | 1165352 | Tubulinea | other_Eukaryota | 444 | 3.27e-120 | NTclustered | gi|2517949720|gb|OR125025.1| | 1165352 | g1218 | i0 | 98.419 | 60.956862745098 | 253 | 3 | 99 | 1 | 3 | 255 | 720 | 971 | Cryptodifflugia oviformis isolate strain_9 small subunit ribosomal RNA gene, partial sequence | blastn | 15544 | 444 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia oviformis | ||
| 26025134 | 26025134 | PRJEB7799h_S_NODE_4284_length_165_cov_5.869231_g4281_i0 | PRJEB7799 | 4284 | 165 | 5.869231 | 9.68423115 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 300 | 4.46e-77 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g4281 | i0 | 99.394 | 57.6242424242424 | 165 | 1 | 100 | 0 | 1 | 165 | 1221 | 1057 | 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 | 9508 | 300 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26070431 | 26070431 | PRJEB7799a_S_NODE_3229_length_258_cov_3.049327_g3194_i0 | PRJEB7799 | 3229 | 258 | 3.049327 | 7.86726366 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 318 | 2.1e-82 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g3194 | i0 | 89.189 | 4.12403100775194 | 259 | 22 | 100 | 5 | 1 | 258 | 3925 | 4178 | 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 | 1064 | 318 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 26072524 | 26072524 | PRJEB7799n_S_NODE_10013_length_163_cov_1.781250_g9976_i0 | PRJEB7799 | 10013 | 163 | 1.78125 | 2.9034375 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 268 | 1.24e-67 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g9976 | i0 | 96.319 | 2 | 163 | 6 | 100 | 0 | 1 | 163 | 6862 | 7024 | 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 | 326 | 268 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26209912 | 26209912 | PRJEB7799p_S_NODE_7566_length_206_cov_4.134503_g7543_i0 | PRJEB7799 | 7566 | 206 | 4.134503 | 8.51707618 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 381 | 2.0199999999999994e-101 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g7543 | i0 | 100 | 87.8300970873786 | 206 | 0 | 100 | 0 | 1 | 206 | 345 | 140 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 18093 | 381 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 26297401 | 26297401 | PRJEB7799n_S_NODE_1822_length_314_cov_18.311828_g1785_i0 | PRJEB7799 | 1822 | 314 | 18.311828 | 57.49913992 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 501 | 2.43e-137 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g1785 | i0 | 100 | 32.1305732484076 | 271 | 0 | 86 | 0 | 24 | 294 | 950 | 1220 | 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 | 10089 | 501 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26432825 | 26432825 | PRJEB7799a_S_NODE_4983_length_225_cov_2.942105_g4948_i0 | PRJEB7799 | 4983 | 225 | 2.942105 | 6.61973625 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 342 | 1.0599999999999999e-89 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g4948 | i0 | 100 | 5.29333333333333 | 185 | 0 | 82 | 0 | 24 | 208 | 1190 | 1006 | 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 | 1191 | 342 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26568877 | 26568877 | PRJEB7799c_S_NODE_11576_length_172_cov_6.306569_g11553_i0 | PRJEB7799 | 11576 | 172 | 6.306569 | 10.84729868 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 307 | 2.79e-79 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g11553 | i0 | 98.837 | 9.74418604651163 | 172 | 2 | 100 | 0 | 1 | 172 | 1043 | 1214 | 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 | 1676 | 307 | 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);;