contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1005695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1428133 | 1428133 | PRJNA1005695_P_NODE_11042_length_467_cov_2.162437_g10190_i0 | PRJNA1005695 | 11042 | 467 | 2.162437 | 10.09858079 | Neritina pulligera | 537799 | Mollusca | Mollusca | 817 | 0 | NTclustered | gi|1566846051|dbj|LC215361.1| | 537799 | g10190 | i0 | 99.119 | 76.5160599571735 | 454 | 4 | 97 | 0 | 14 | 467 | 1 | 454 | Neritina pulligera mitochondrial gene for 12S ribosomal RNA, partial sequence, isolate: YK145 | blastn | 35733 | 817 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Cycloneritida | Neritidae | Neritina | Neritina pulligera | |
| 4829187 | 4829187 | PRJNA1005695_P_NODE_41804_length_227_cov_3.551948_g40952_i0 | PRJNA1005695 | 41804 | 227 | 3.551948 | 8.06292196 | Metazoa | 33208 | Mollusca | Mollusca | 370 | 4.91e-98 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g40952 | i0 | 96.053 | 96.942731277533 | 228 | 8 | 100 | 1 | 1 | 227 | 867 | 1094 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 22006 | 372 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 10356739 | 10356739 | PRJNA1005695_P_NODE_36029_length_250_cov_0.881356_g35177_i0 | PRJNA1005695 | 36029 | 250 | 0.881356 | 2.20339 | Neritina iris | 590962 | Mollusca | Mollusca | 424 | 4.16e-114 | NTclustered | gi|2228964459|ref|NC_062612.1| | 590962 | g35177 | i0 | 97.211 | 38.136 | 251 | 6 | 100 | 1 | 1 | 250 | 14322 | 14572 | Neritina iris mitochondrion, complete genome | blastn | 9534 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Cycloneritida | Neritidae | Neritina | Neritina iris | |
| 13754558 | 13754558 | PRJNA1005695_P_NODE_35771_length_250_cov_4.570621_g34919_i0 | PRJNA1005695 | 35771 | 250 | 4.570621 | 11.4265525 | Neritidae | 52926 | Mollusca | Mollusca | 440 | 4.1399999999999976e-119 | NTclustered | gi|2087356235|dbj|LC648578.1| | 2870699 | g34919 | i0 | 98.406 | 54.572 | 251 | 3 | 100 | 1 | 1 | 250 | 167 | 417 | Neripteron cornucopia IDEA_Shell155 gene for 28S rRNA, partial sequence | blastn | 13643 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Cycloneritida | Neritidae | Neripteron | Neripteron cornucopia | |
| 14182284 | 14182284 | PRJNA1005695_P_NODE_35972_length_250_cov_1.322034_g35120_i0 | PRJNA1005695 | 35972 | 250 | 1.322034 | 3.305085 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g35120 | i0 | 92.105 | 0.152 | 38 | 2 | 15 | 1 | 16 | 52 | 43806942 | 43806979 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 38 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15456231 | 15456231 | PRJNA1005695_P_NODE_36313_length_249_cov_2.630682_g35461_i0 | PRJNA1005695 | 36313 | 249 | 2.630682 | 6.55039818 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.35e-4 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g35461 | i0 | 94.872 | 0.156626506024096 | 39 | 0 | 15 | 2 | 1 | 37 | 49143570 | 49143608 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 39 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16730344 | 16730344 | PRJNA1005695_P_NODE_17654_length_359_cov_27.199301_g16802_i0 | PRJNA1005695 | 17654 | 359 | 27.199301 | 97.64549059 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 104 | 9.26e-18 | NTclustered | gi|2034271035|ref|XR_005960499.1| | 1735272 | g16802 | i0 | 78.488 | 7.42061281337047 | 172 | 27 | 47 | 8 | 190 | 358 | 3686 | 3522 | PREDICTED: Gigantopelta aegis large subunit ribosomal RNA (LOC121392465), rRNA | blastn | 2664 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 18005348 | 18005348 | PRJNA1005695_P_NODE_36335_length_249_cov_2.369318_g35483_i0 | PRJNA1005695 | 36335 | 249 | 2.369318 | 5.89960182 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2427467042|ref|XM_052939866.1| | 6604 | g35483 | i0 | 100 | 0.232931726907631 | 29 | 0 | 12 | 0 | 132 | 160 | 966 | 938 | PREDICTED: Mya arenaria cell division control protein 42 homolog (LOC128228518), transcript variant X1, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 24379733 | 24379733 | PRJNA1005695_P_NODE_9960_length_492_cov_3.073986_g9109_i0 | PRJNA1005695 | 9960 | 492 | 3.073986 | 15.12401112 | Mya arenaria | 6604 | Mollusca | Mollusca | 193 | 2.71e-44 | NTclustered | gi|2427451705|ref|XM_052935167.1| | 6604 | g9109 | i0 | 79.422 | 5.83333333333333 | 277 | 53 | 56 | 4 | 217 | 491 | 157 | 431 | PREDICTED: Mya arenaria 40S ribosomal protein S2 (LOC128225132), mRNA | blastn | 2870 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;