contig_metadata
9 rows where bioproject = "PRJNA384462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405364 | 405364 | PRJNA384462_S_NODE_8161_length_198_cov_1.885906_g8045_i0 | PRJNA384462 | 8161 | 198 | 1.885906 | 3.73409388 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 366 | 5.4e-97 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g8045 | i0 | 100 | 83.530303030303 | 198 | 0 | 100 | 0 | 1 | 198 | 4673 | 4870 | 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 | 16539 | 366 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6178807 | 6178807 | PRJNA384462_S_NODE_11485_length_174_cov_2.480000_g11369_i0 | PRJNA384462 | 11485 | 174 | 2.48 | 4.3152 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 320 | 3.63e-83 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g11369 | i0 | 100 | 5.28735632183908 | 173 | 0 | 99 | 0 | 2 | 174 | 1620 | 1448 | 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 | 920 | 320 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7453862 | 7453862 | PRJNA384462_S_NODE_6806_length_212_cov_3.349693_g6690_i0 | PRJNA384462 | 6806 | 212 | 3.349693 | 7.10134916 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 370 | 4.53e-98 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g6690 | i0 | 98.113 | 92.5754716981132 | 212 | 4 | 100 | 0 | 1 | 212 | 4899 | 5110 | 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 | 19626 | 370 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 15103683 | 15103683 | PRJNA384462_S_NODE_8132_length_198_cov_3.711409_g8016_i0 | PRJNA384462 | 8132 | 198 | 3.711409 | 7.34858982 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 350 | 5.44e-92 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g8016 | i0 | 98.485 | 3 | 198 | 3 | 100 | 0 | 1 | 198 | 5137 | 5334 | 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 | 594 | 350 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 15708032 | 15708032 | PRJNA384462_S_NODE_10133_length_182_cov_8.676692_g10017_i0 | PRJNA384462 | 10133 | 182 | 8.676692 | 15.79157944 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 115 | 1.95e-21 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g10017 | i0 | 92.5 | 41.8296703296703 | 80 | 6 | 62 | 0 | 99 | 178 | 1498 | 1419 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 7613 | 115 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 17653457 | 17653457 | PRJNA384462_S_NODE_7474_length_205_cov_1.814103_g7358_i0 | PRJNA384462 | 7474 | 205 | 1.814103 | 3.71891115 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 374 | 3.3599999999999997e-99 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g7358 | i0 | 99.512 | 44.1219512195122 | 205 | 1 | 100 | 0 | 1 | 205 | 2700 | 2904 | 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 | 9045 | 374 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20202010 | 20202010 | PRJNA384462_S_NODE_4576_length_249_cov_2.445000_g4460_i0 | PRJNA384462 | 4576 | 249 | 2.445 | 6.08805 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 449 | 6.840000000000001e-122 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g4460 | i0 | 99.197 | 40.2168674698795 | 249 | 2 | 100 | 0 | 1 | 249 | 3619 | 3867 | 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 | 10014 | 449 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22081785 | 22081785 | PRJNA384462_S_NODE_6738_length_213_cov_1.890244_g6622_i0 | PRJNA384462 | 6738 | 213 | 1.890244 | 4.02621972 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 388 | 1.26e-103 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g6622 | i0 | 99.531 | 2 | 213 | 1 | 100 | 0 | 1 | 213 | 3438 | 3650 | 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 | 426 | 388 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23357383 | 23357383 | PRJNA384462_S_NODE_3479_length_280_cov_2.809524_g3363_i0 | PRJNA384462 | 3479 | 280 | 2.809524 | 7.8666672 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 481 | 2.78e-131 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g3363 | i0 | 97.842 | 1.79642857142857 | 278 | 6 | 99 | 0 | 2 | 279 | 7097 | 6820 | 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 | 503 | 481 | 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);;