contig_metadata
4 rows where bioproject = "PRJNA797475", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10985303 | 10985303 | PRJNA797475_P_NODE_14989_length_283_cov_6.666667_g14890_i0 | PRJNA797475 | 14989 | 283 | 6.666667 | 18.86666761 | Vermamoeba sp. | 1972851 | Tubulinea | other_Eukaryota | 438 | 1.7199999999999995e-118 | NTclustered | gi|2651357782|gb|PP174298.1| | 1972851 | g14890 | i0 | 94.681 | 37.8904593639576 | 282 | 15 | 99 | 0 | 1 | 282 | 3931 | 4212 | Vermamoeba sp. isolate 22 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 | 10723 | 438 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba sp. | ||||
| 10985426 | 10985426 | PRJNA797475_P_NODE_2549_length_611_cov_1.500000_g2451_i0 | PRJNA797475 | 2549 | 611 | 1.5 | 9.165 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1074 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g2451 | i0 | 98.363 | 45.8837970540098 | 611 | 10 | 100 | 0 | 1 | 611 | 2873 | 2263 | 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 | 28035 | 1074 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21183825 | 21183825 | PRJNA797475_P_NODE_20777_length_253_cov_2.438889_g20678_i0 | PRJNA797475 | 20777 | 253 | 2.438889 | 6.17038917 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 388 | 1.5399999999999998e-103 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g20678 | i0 | 94.488 | 1.78260869565217 | 254 | 10 | 99 | 4 | 2 | 253 | 7099 | 6848 | 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 | 451 | 388 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22458518 | 22458518 | PRJNA797475_P_NODE_21478_length_251_cov_0.865169_g21379_i0 | PRJNA797475 | 21478 | 251 | 0.865169 | 2.17157419 | Lesquereusia modesta | 1260108 | Tubulinea | other_Eukaryota | 136 | 1.0599999999999998e-37 | NR | AFX73094.1 | 1260108 | g21379 | i0 | 74.4 | 3.93227091633466 | 82 | 21 | 98 | 0 | 251 | 6 | 21 | 102 | AFX73094.1 elongation factor 2 alpha, partial [Lesquereusia modesta] | diamond | 987 | 136 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Lesquereusiidae | Lesquereusia | Lesquereusia modesta |
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);;