contig_metadata
7 rows where bioproject = "PRJNA800053", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16098755 | 16098755 | PRJNA800053_P_NODE_20833_length_245_cov_4.895349_g20669_i0 | PRJNA800053 | 20833 | 245 | 4.895349 | 11.99360505 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 67.6 | 7.9e-7 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g20669 | i0 | 100 | 36.2408163265306 | 36 | 0 | 18 | 0 | 5 | 40 | 62039081 | 62039046 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 8879 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17374563 | 17374563 | PRJNA800053_P_NODE_11434_length_292_cov_1.264840_g11270_i0 | PRJNA800053 | 11434 | 292 | 1.26484 | 3.6933328 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g11270 | i0 | 100 | 0.0993150684931507 | 29 | 0 | 10 | 0 | 1 | 29 | 16828781 | 16828809 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21198607 | 21198607 | PRJNA800053_P_NODE_17137_length_252_cov_1.296089_g16973_i0 | PRJNA800053 | 17137 | 252 | 1.296089 | 3.26614428 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 427 | 3.2499999999999993e-115 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g16973 | i0 | 97.59 | 150.134920634921 | 249 | 6 | 99 | 0 | 1 | 249 | 1218 | 1466 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 37834 | 427 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 29106841 | 29106841 | PRJNA800053_P_NODE_18788_length_249_cov_0.875000_g18624_i0 | PRJNA800053 | 18788 | 249 | 0.875 | 2.17875 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 53.1 | 8.63e-6 | NR | RUS68674.1 | 188477 | g18624 | i0 | 39 | 12.6385542168675 | 59 | 36 | 71.1 | 0 | 3 | 179 | 338 | 396 | RUS68674.1 hypothetical protein EGW08_023562 [Elysia chlorotica] | diamond | 3147 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 29327653 | 29327653 | PRJNA800053_P_NODE_18689_length_249_cov_0.875000_g18525_i0 | PRJNA800053 | 18689 | 249 | 0.875 | 2.17875 | Patella caerulea | 87958 | Mollusca | Mollusca | 51.2 | 4.12e-5 | NR | KAK6187283.1 | 87958 | g18525 | i0 | 52.3 | 1.06024096385542 | 44 | 21 | 53 | 0 | 136 | 5 | 762 | 805 | KAK6187283.1 hypothetical protein SNE40_005346 [Patella caerulea] | diamond | 264 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 30243775 | 30243775 | PRJNA800053_P_NODE_25112_length_213_cov_5.328571_g24948_i0 | PRJNA800053 | 25112 | 213 | 5.328571 | 11.34985623 | Argopecten irradians | 31199 | Mollusca | Mollusca | 51.2 | 8.81e-6 | NR | XP_069109172.1 | 31199 | g24948 | i0 | 45.9 | 0.859154929577465 | 61 | 23 | 85.9 | 2 | 1 | 183 | 103 | 153 | XP_069109172.1 uncharacterized protein [Argopecten irradians] | diamond | 183 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 31033836 | 31033836 | PRJNA800053_P_NODE_12855_length_280_cov_7.367150_g12691_i0 | PRJNA800053 | 12855 | 280 | 7.36715 | 20.62802 | Bulinus truncatus | 55810 | Mollusca | Mollusca | 64.7 | 1.09e-9 | NR | KAH9498634.1 | 55810 | g12691 | i0 | 57.4 | 3.20357142857143 | 54 | 22 | 57.9 | 1 | 247 | 86 | 494 | 546 | KAH9498634.1 hypothetical protein Btru_007871 [Bulinus truncatus] | diamond | 897 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus |
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);;