contig_metadata
9 rows where bioproject = "PRJNA217180" and tax_phylum = "Mollusca"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 367131 | 367131 | PRJNA217180_P_NODE_8761_length_198_cov_2.355705_g8661_i0 | PRJNA217180 | 8761 | 198 | 2.355705 | 4.6642959 | Conus litteratus | 89445 | Mollusca | Mollusca | 355 | 1.17e-93 | NTclustered | gi|85375954|gb|DQ345363.1| | 89445 | g8661 | i0 | 98.99 | 21.8333333333333 | 198 | 2 | 100 | 0 | 1 | 198 | 498 | 301 | Conus litteratus T-superfamily conotoxin lt5j precursor, mRNA, complete cds | blastn | 4323 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Conidae | Conus | Conus litteratus | |
| 2331329 | 2331329 | PRJNA217180_P_NODE_2762_length_341_cov_5.821918_g2662_i0 | PRJNA217180 | 2762 | 341 | 5.821918 | 19.85274038 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.032 | NTclustered | gi|2427390617|ref|XM_052917999.1| | 6604 | g2662 | i0 | 100 | 1.5366568914956 | 28 | 0 | 8 | 0 | 70 | 97 | 5126 | 5153 | PREDICTED: Mya arenaria protein mono-ADP-ribosyltransferase PARP14-like (LOC128212513), mRNA | blastn | 524 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 9295167 | 9295167 | PRJNA217180_P_NODE_14268_length_163_cov_1.342105_g14168_i0 | PRJNA217180 | 14268 | 163 | 1.342105 | 2.18763115 | Conus consors | 101297 | Mollusca | Mollusca | 158 | 2.8e-34 | NTclustered | gi|528524674|emb|HE856374.1| | 101297 | g14168 | i0 | 87.77 | 0.852760736196319 | 139 | 11 | 82 | 4 | 26 | 158 | 872 | 734 | Conus consors mRNA for linear conopeptide Cn1 precursor, biomaterial CH070619AA-AC | blastn | 139 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Conidae | Conus | Conus consors | |
| 9295221 | 9295221 | PRJNA217180_P_NODE_9348_length_191_cov_1.788732_g9248_i0 | PRJNA217180 | 9348 | 191 | 1.788732 | 3.41647812 | Conus episcopatus | 88764 | Mollusca | Mollusca | 91.6 | 3.48e-14 | NTclustered | gi|920151338|dbj|AK444211.1| | 88764 | g9248 | i0 | 93.443 | 0.801047120418848 | 61 | 4 | 32 | 0 | 125 | 185 | 265 | 205 | Conus episcopatus mRNA, sequence id; Ep1542 | blastn | 153 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Conidae | Conus | Conus episcopatus | |
| 10571138 | 10571138 | PRJNA217180_P_NODE_10069_length_186_cov_1.284672_g9969_i0 | PRJNA217180 | 10069 | 186 | 1.284672 | 2.38948992 | Conus litteratus | 89445 | Mollusca | Mollusca | 339 | 1.0899999999999998e-88 | NTclustered | gi|85717914|gb|DQ345373.1| | 89445 | g9969 | i0 | 99.462 | 53.6236559139785 | 186 | 1 | 100 | 0 | 1 | 186 | 202 | 17 | Conus litteratus clone 07C04 O superfamily conotoxin lt7a precursor, mRNA, complete cds | blastn | 9974 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Conidae | Conus | Conus litteratus | |
| 15669918 | 15669918 | PRJNA217180_P_NODE_5033_length_258_cov_1.626794_g4933_i0 | PRJNA217180 | 5033 | 258 | 1.626794 | 4.19712852 | Conus leopardus | 101306 | Mollusca | Mollusca | 477 | 3.2699999999999985e-130 | NTclustered | gi|46810502|gb|AY591770.1| | 101306 | g4933 | i0 | 100 | 13.7558139534884 | 258 | 0 | 100 | 0 | 1 | 258 | 606 | 349 | Conus leopardus tau conotoxin 5.2 mRNA, complete cds | blastn | 3549 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Conidae | Conus | Conus leopardus | |
| 23319152 | 23319152 | PRJNA217180_P_NODE_10939_length_179_cov_1.392308_g10839_i0 | PRJNA217180 | 10939 | 179 | 1.392308 | 2.49223132 | Conus leopardus | 101306 | Mollusca | Mollusca | 326 | 8.09e-85 | NTclustered | gi|46810500|gb|AY591769.1| | 101306 | g10839 | i0 | 99.441 | 12 | 179 | 1 | 100 | 0 | 1 | 179 | 577 | 399 | Conus leopardus tau conotoxin 5.1 mRNA, complete cds | blastn | 2148 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Conidae | Conus | Conus leopardus | |
| 29505390 | 29505390 | PRJNA217180_P_NODE_14370_length_163_cov_0.894737_g14270_i0 | PRJNA217180 | 14370 | 163 | 0.894737 | 1.45842131 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 48.5 | 1.16e-4 | NR | XP_061194638.1 | 191078 | g14270 | i0 | 42.3 | 3.69938650306748 | 52 | 26 | 95.7 | 1 | 160 | 5 | 47 | 94 | XP_061194638.1 uncharacterized protein LOC133202773 [Saccostrea echinata] | diamond | 603 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 30313451 | 30313451 | PRJNA217180_P_NODE_13952_length_164_cov_0.886957_g13852_i0 | PRJNA217180 | 13952 | 164 | 0.886957 | 1.45460948 | Plakobranchidae | 71492 | Mollusca | Mollusca | 110 | 1.59e-26 | NR | RUS76774.1 | 188477 | g13852 | i0 | 98.1 | 5.90853658536585 | 53 | 1 | 97 | 0 | 163 | 5 | 540 | 592 | RUS76774.1 hypothetical protein EGW08_015451 [Elysia chlorotica] | diamond | 969 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica |
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);;