contig_metadata
7 rows where bioproject = "PRJNA683902", tax_clade = "Opisthokonta" and tax_phylum = "Microsporidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3216099 | 3216099 | PRJNA683902_S_NODE_20003_length_238_cov_2.666667_g19559_i0 | PRJNA683902 | 20003 | 238 | 2.666667 | 6.34666746 | Liebermannia sp. | 2486767 | Fungi | Fungi | 346 | 8.76e-91 | NTclustered | gi|1510577646|gb|MH396491.1| | 2486767 | g19559 | i0 | 92.917 | 74.1134453781513 | 240 | 14 | 100 | 3 | 1 | 238 | 559 | 321 | Liebermannia sp. isolate Lros1 small subunit ribosomal RNA gene, partial sequence | blastn | 17639 | 346 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Liebermannia | Liebermannia sp. | ||||
| 9593880 | 9593880 | PRJNA683902_S_NODE_21368_length_226_cov_2.460317_g20924_i0 | PRJNA683902 | 21368 | 226 | 2.460317 | 5.56031642 | Liebermannia covasacrae | 1169135 | Fungi | Fungi | 327 | 2.98e-85 | NTclustered | gi|189409558|gb|EU709818.1| | 1169135 | g20924 | i0 | 93.243 | 41.4247787610619 | 222 | 15 | 98 | 0 | 1 | 222 | 1186 | 965 | Liebermannia covasacrae isolate Laprida small subunit ribosomal RNA gene, partial sequence | blastn | 9362 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Liebermannia | Liebermannia covasacrae | ||||
| 10869381 | 10869381 | PRJNA683902_S_NODE_39589_length_151_cov_1.368421_g39145_i0 | PRJNA683902 | 39589 | 151 | 1.368421 | 2.06631571 | Liebermannia covasacrae | 1169135 | Fungi | Fungi | 196 | 5.38e-46 | NTclustered | gi|189409558|gb|EU709818.1| | 1169135 | g39145 | i0 | 90.196 | 2.02649006622517 | 153 | 12 | 100 | 3 | 1 | 151 | 829 | 980 | Liebermannia covasacrae isolate Laprida small subunit ribosomal RNA gene, partial sequence | blastn | 306 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Liebermannia | Liebermannia covasacrae | ||||
| 12144767 | 12144767 | PRJNA683902_S_NODE_39010_length_152_cov_2.008696_g38566_i0 | PRJNA683902 | 39010 | 152 | 2.008696 | 3.05321792 | Alternosema sp. | 2914448 | Fungi | Fungi | 135 | 1.2e-27 | NTclustered | gi|2187826742|gb|OM501730.1| | 2914448 | g38566 | i0 | 83.007 | 29.5065789473684 | 153 | 23 | 100 | 2 | 1 | 152 | 317 | 167 | Alternosema sp. isolate virilis_WI47a small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 4485 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Alternosema | Alternosema sp. | ||||
| 13419245 | 13419245 | PRJNA683902_S_NODE_24751_length_204_cov_3.245509_g24307_i0 | PRJNA683902 | 24751 | 204 | 3.245509 | 6.62083836 | Liebermannia covasacrae | 1169135 | Fungi | Fungi | 337 | 4.39e-88 | NTclustered | gi|189409558|gb|EU709818.1| | 1169135 | g24307 | i0 | 97 | 97.7696078431373 | 200 | 6 | 98 | 0 | 5 | 204 | 598 | 797 | Liebermannia covasacrae isolate Laprida small subunit ribosomal RNA gene, partial sequence | blastn | 19945 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Liebermannia | Liebermannia covasacrae | ||||
| 28408668 | 28408668 | PRJNA683902_S_NODE_24106_length_208_cov_2.087719_g23662_i0 | PRJNA683902 | 24106 | 208 | 2.087719 | 4.34245552 | Nematocida major | 1912982 | Fungi | Fungi | 48.5 | 1.97e-4 | NR | XP_047771004.1 | 1912982 | g23662 | i0 | 37.7 | 0.995192307692308 | 69 | 40 | 99.5 | 1 | 207 | 1 | 14 | 79 | XP_047771004.1 large subunit ribosomal protein LP0 [Nematocida major] | diamond | 207 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida major | ||||
| 31694034 | 31694034 | PRJNA683902_S_NODE_24957_length_203_cov_2.102410_g24513_i0 | PRJNA683902 | 24957 | 203 | 2.10241 | 4.2678923 | Nematocida parisii | 586133 | Fungi | Fungi | 62.4 | 2.38e-9 | NR | KAI5159699.1 | 586133 | g24513 | i0 | 58.7 | 0.931034482758621 | 63 | 26 | 93.1 | 0 | 9 | 197 | 216 | 278 | KAI5159699.1 hypothetical protein NEPAR05_2515, partial [Nematocida parisii] | diamond | 189 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida parisii |
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);;