contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJDB3785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1282996 | 1282996 | PRJDB3785_S_NODE_14722_length_202_cov_1.607843_g14569_i0 | PRJDB3785 | 14722 | 202 | 1.607843 | 3.24784286 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.018 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g14569 | i0 | 91.892 | 0.183168316831683 | 37 | 3 | 18 | 0 | 149 | 185 | 10553795 | 10553759 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 37 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 1283066 | 1283066 | PRJDB3785_S_NODE_20342_length_176_cov_2.000000_g20189_i0 | PRJDB3785 | 20342 | 176 | 2 | 3.52 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 65.8 | 1.91e-6 | NTclustered | gi|2364289613|ref|XM_052389720.1| | 45954 | g20189 | i0 | 88.679 | 0.301136363636364 | 53 | 6 | 30 | 0 | 89 | 141 | 159 | 211 | PREDICTED: Dreissena polymorpha 14-3-3 protein epsilon-like (LOC127854654), mRNA | blastn | 53 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 5111223 | 5111223 | PRJDB3785_S_NODE_20265_length_177_cov_0.828125_g20112_i0 | PRJDB3785 | 20265 | 177 | 0.828125 | 1.46578125 | Corbicula fluminea | 45949 | Mollusca | Mollusca | 135 | 1.44e-27 | NTclustered | gi|619498806|gb|KJ461738.1| | 45949 | g20112 | i0 | 83.448 | 64.7683615819209 | 145 | 24 | 82 | 0 | 13 | 157 | 696 | 840 | Corbicula fluminea clone 01024008 heat shock protein 70 (HSP70) mRNA, complete cds | blastn | 11464 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 8935674 | 8935674 | PRJDB3785_S_NODE_11308_length_226_cov_1.700565_g11155_i0 | PRJDB3785 | 11308 | 226 | 1.700565 | 3.8432769 | Patella vulgata | 6465 | Mollusca | Mollusca | 206 | 1.4599999999999998e-48 | NTclustered | gi|2296443958|ref|XM_050562767.1| | 6465 | g11155 | i0 | 83.111 | 71.5 | 225 | 38 | 99 | 0 | 2 | 226 | 314 | 90 | PREDICTED: Patella vulgata tubulin beta chain-like (LOC126832082), mRNA | blastn | 16159 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 10211601 | 10211601 | PRJDB3785_S_NODE_14509_length_203_cov_2.292208_g14356_i0 | PRJDB3785 | 14509 | 203 | 2.292208 | 4.65318224 | Haliphron sp. ARL-2004 | 283040 | Mollusca | Mollusca | 187 | 4.65e-43 | NTclustered | gi|50346986|gb|AY557410.1| | 283040 | g14356 | i0 | 83.582 | 98.9458128078818 | 201 | 31 | 99 | 2 | 3 | 202 | 323 | 124 | Haliphron sp. ARL-2004 histone H3 pseudogene, partial sequence | blastn | 20086 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Alloposidae | Haliphron | Haliphron sp. ARL-2004 | |
| 11486671 | 11486671 | PRJDB3785_S_NODE_15630_length_197_cov_1.371622_g15477_i0 | PRJDB3785 | 15630 | 197 | 1.371622 | 2.70209534 | Perna viridis | 73031 | Mollusca | Mollusca | 122 | 1.2799999999999999e-23 | NTclustered | gi|1205912005|gb|KY568778.1| | 73031 | g15477 | i0 | 83.721 | 5.03553299492386 | 129 | 21 | 65 | 0 | 28 | 156 | 103 | 231 | Perna viridis voucher SS26 histone H3 (H3) gene, partial cds | blastn | 992 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Perna | Perna viridis | |
| 11486781 | 11486781 | PRJDB3785_S_NODE_24450_length_165_cov_0.879310_g24297_i0 | PRJDB3785 | 24450 | 165 | 0.87931 | 1.4508615 | Patella vulgata | 6465 | Mollusca | Mollusca | 134 | 4.7900000000000005e-27 | NTclustered | gi|2506319584|ref|XM_050540791.2| | 6465 | g24297 | i0 | 82.166 | 4.36363636363636 | 157 | 26 | 95 | 2 | 1 | 156 | 428 | 583 | PREDICTED: Patella vulgata transmembrane emp24 domain-containing protein eca (LOC126815232), transcript variant X2, mRNA | blastn | 720 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 14036859 | 14036859 | PRJDB3785_S_NODE_20492_length_176_cov_1.181102_g20339_i0 | PRJDB3785 | 20492 | 176 | 1.181102 | 2.07873952 | Haliotis rubra | 36100 | Mollusca | Mollusca | 78.7 | 2.45e-10 | NTclustered | gi|2194101406|ref|XM_046706881.1| | 36100 | g20339 | i0 | 89.231 | 0.75 | 65 | 3 | 38 | 4 | 73 | 135 | 173 | 111 | PREDICTED: Haliotis rubra transcription initiation factor TFIID subunit 11-like (LOC124271720), partial mRNA | blastn | 132 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 17860570 | 17860570 | PRJDB3785_S_NODE_14915_length_201_cov_1.322368_g14762_i0 | PRJDB3785 | 14915 | 201 | 1.322368 | 2.65795968 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 202 | 1.6399999999999998e-47 | NTclustered | gi|2868694932|ref|XM_070338369.1| | 31220 | g14762 | i0 | 85.204 | 12.1890547263682 | 196 | 29 | 98 | 0 | 6 | 201 | 3035 | 2840 | PREDICTED: Littorina saxatilis cilia- and flagella-associated protein 57-like (LOC138966228), mRNA | blastn | 2450 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 19134342 | 19134342 | PRJDB3785_S_NODE_20676_length_175_cov_1.365079_g20523_i0 | PRJDB3785 | 20676 | 175 | 1.365079 | 2.38888825 | Antalis entalis | 211836 | Mollusca | Mollusca | 172 | 1.08e-38 | NTclustered | gi|82622142|gb|DQ280000.1| | 211836 | g20523 | i0 | 84.706 | 19.4685714285714 | 170 | 26 | 97 | 0 | 1 | 170 | 2 | 171 | Antalis entalis histone H3 gene, partial cds | blastn | 3407 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Scaphopoda | Dentaliida | Dentaliidae | Antalis | Antalis entalis | |
| 20409340 | 20409340 | PRJDB3785_S_NODE_14077_length_206_cov_1.280255_g13924_i0 | PRJDB3785 | 14077 | 206 | 1.280255 | 2.6373253 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 3.87e-4 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g13924 | i0 | 100 | 0.587378640776699 | 31 | 0 | 15 | 0 | 99 | 129 | 35875858 | 35875888 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 121 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20409445 | 20409445 | PRJDB3785_S_NODE_22197_length_170_cov_1.148760_g22044_i0 | PRJDB3785 | 22197 | 170 | 1.14876 | 1.952892 | Mya arenaria | 6604 | Mollusca | Mollusca | 99 | 1.8e-16 | NTclustered | gi|2427446032|ref|XM_052918054.1| | 6604 | g22044 | i0 | 87.209 | 34.1352941176471 | 86 | 11 | 51 | 0 | 77 | 162 | 303 | 388 | PREDICTED: Mya arenaria myosin heavy chain, striated muscle-like (LOC128212555), transcript variant X3, mRNA | blastn | 5803 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 25207282 | 25207282 | PRJDB3785_S_NODE_9560_length_244_cov_5.666667_g9407_i0 | PRJDB3785 | 9560 | 244 | 5.666667 | 13.82666748 | Gastropoda | 6448 | Mollusca | Mollusca | 115 | 2.77e-21 | NTclustered | gi|1897914721|ref|XM_013091444.2| | 6500 | g9407 | i0 | 85.345 | 10.4959016393443 | 116 | 11 | 48 | 3 | 129 | 244 | 1484 | 1375 | PREDICTED: Aplysia californica tubulin alpha-1A chain (LOC101845985), mRNA | blastn | 2561 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica |
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);;