contig_metadata
5 rows where bioproject = "PRJNA1046144", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14201117 | 14201117 | PRJNA1046144_P_NODE_46492_length_255_cov_3.290323_g46197_i0 | PRJNA1046144 | 46492 | 255 | 3.290323 | 8.39032365 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 113 | 1.05e-20 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g46197 | i0 | 86.111 | 40.0509803921569 | 108 | 11 | 42 | 2 | 1 | 108 | 4470 | 4367 | 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 | 10213 | 113 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 19297605 | 19297605 | PRJNA1046144_P_NODE_13676_length_433_cov_5.887363_g13381_i0 | PRJNA1046144 | 13676 | 433 | 5.887363 | 25.49228179 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 717 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g13381 | i0 | 96.552 | 41.554272517321 | 435 | 11 | 100 | 4 | 1 | 433 | 7098 | 6666 | 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 | 17993 | 717 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20135552 | 20135552 | PRJNA1046144_P_NODE_3676_length_808_cov_4.235453_g3433_i0 | PRJNA1046144 | 3676 | 808 | 4.235453 | 34.22246024 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1332 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g3433 | i0 | 96.411 | 49.8898514851485 | 808 | 29 | 100 | 0 | 1 | 808 | 5784 | 4977 | 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 | 40311 | 1338 | 0.995515695067265 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22685870 | 22685870 | PRJNA1046144_P_NODE_25618_length_327_cov_2.782946_g25323_i0 | PRJNA1046144 | 25618 | 327 | 2.782946 | 9.10023342 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 566 | 8.879999999999998e-157 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g25323 | i0 | 97.859 | 41.1009174311927 | 327 | 7 | 100 | 0 | 1 | 327 | 1228 | 902 | 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 | 13440 | 566 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23124417 | 23124417 | PRJNA1046144_P_NODE_31919_length_298_cov_4.777293_g31624_i0 | PRJNA1046144 | 31919 | 298 | 4.777293 | 14.23633314 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 484 | 2.3e-132 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g31624 | i0 | 95.973 | 23.6879194630872 | 298 | 12 | 100 | 0 | 1 | 298 | 1240 | 1537 | 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 | 7059 | 484 | 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);;