contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA597223" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1140655 | 1140655 | PRJNA597223_P_NODE_32161_length_262_cov_1.920705_g30315_i0 | PRJNA597223 | 32161 | 262 | 1.920705 | 5.0322471 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2427390617|ref|XM_052917999.1| | 6604 | g30315 | i0 | 100 | 1.6793893129771 | 28 | 0 | 11 | 0 | 177 | 204 | 5153 | 5126 | PREDICTED: Mya arenaria protein mono-ADP-ribosyltransferase PARP14-like (LOC128212513), mRNA | blastn | 440 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 3120389 | 3120389 | PRJNA597223_P_NODE_68803_length_172_cov_4.094891_g66957_i0 | PRJNA597223 | 68803 | 172 | 4.094891 | 7.04321252 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g66957 | i0 | 100 | 0.168604651162791 | 29 | 0 | 17 | 0 | 102 | 130 | 69685356 | 69685384 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6947467 | 6947467 | PRJNA597223_P_NODE_51566_length_194_cov_1.911950_g49720_i0 | PRJNA597223 | 51566 | 194 | 1.91195 | 3.709183 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 52.8 | 0.017 | NTclustered | gi|2364408178|ref|XM_052412926.1| | 45954 | g49720 | i0 | 100 | 0.144329896907216 | 28 | 0 | 14 | 0 | 87 | 114 | 143 | 170 | PREDICTED: Dreissena polymorpha uncharacterized LOC127870294 (LOC127870294), transcript variant X1, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 6947900 | 6947900 | PRJNA597223_S_NODE_2846_length_184_cov_1.551724_g2789_i0 | PRJNA597223 | 2846 | 184 | 1.551724 | 2.85517216 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g2789 | i0 | 100 | 0.157608695652174 | 29 | 0 | 16 | 0 | 1 | 29 | 31 | 59 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 8222020 | 8222020 | PRJNA597223_P_NODE_14587_length_441_cov_5.396552_g12799_i0 | PRJNA597223 | 14587 | 441 | 5.396552 | 23.79879432 | Physella acuta | 109671 | Mollusca | Mollusca | 798 | 0 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g12799 | i0 | 99.32 | 4.34920634920635 | 441 | 3 | 100 | 0 | 1 | 441 | 3767 | 3327 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 1918 | 798 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 8222202 | 8222202 | PRJNA597223_P_NODE_29887_length_276_cov_2.954357_g28041_i0 | PRJNA597223 | 29887 | 276 | 2.954357 | 8.15402532 | Ctena cf. galapagana NHMUK 20210086 | 2892552 | Mollusca | Mollusca | 139 | 1.8899999999999999e-28 | NTclustered | gi|2129023951|gb|OL361786.1| | 2892552 | g28041 | i0 | 92.708 | 6.75 | 96 | 7 | 35 | 0 | 3 | 98 | 4148 | 4053 | Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1863 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lucinida | Lucinidae | Ctena | Ctena cf. galapagana NHMUK 20210086 | |
| 9497811 | 9497811 | PRJNA597223_P_NODE_69348_length_172_cov_1.087591_g67502_i0 | PRJNA597223 | 69348 | 172 | 1.087591 | 1.87065652 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 3.1e-4 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g67502 | i0 | 100 | 0.180232558139535 | 31 | 0 | 18 | 0 | 11 | 41 | 51611393 | 51611363 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10069352 | 10069352 | PRJNA597223_P_NODE_55568_length_189_cov_1.597403_g53722_i0 | PRJNA597223 | 55568 | 189 | 1.597403 | 3.01909167 | Metazoa | 33208 | Mollusca | Mollusca | 348 | 1.85e-91 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g53722 | i0 | 100 | 53.3492063492063 | 188 | 0 | 99 | 0 | 1 | 188 | 1576 | 1763 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 10083 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 10773655 | 10773655 | PRJNA597223_P_NODE_64049_length_181_cov_1.506849_g62203_i0 | PRJNA597223 | 64049 | 181 | 1.506849 | 2.72739669 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g62203 | i0 | 100 | 0.165745856353591 | 30 | 0 | 17 | 0 | 64 | 93 | 24530858 | 24530829 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 13323024 | 13323024 | PRJNA597223_P_NODE_42171_length_219_cov_1.532609_g40325_i0 | PRJNA597223 | 42171 | 219 | 1.532609 | 3.35641371 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2616463935|ref|XM_060695927.1| | 129788 | g40325 | i0 | 100 | 0.136986301369863 | 30 | 0 | 14 | 0 | 13 | 42 | 2709 | 2680 | PREDICTED: Ruditapes philippinarum trichohyalin-like (LOC132713227), transcript variant X27, mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 15168747 | 15168747 | PRJNA597223_P_NODE_12452_length_483_cov_69.502232_g10712_i0 | PRJNA597223 | 12452 | 483 | 69.502232 | 335.69578056 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.1 | 7.82e-5 | NTclustered | gi|2693871861|ref|XR_010104559.1| | 6551 | g10712 | i0 | 95 | 7.69772256728778 | 40 | 1 | 8 | 1 | 442 | 480 | 3324 | 3285 | PREDICTED: Mytilus trossulus large subunit ribosomal RNA (LOC134702777), rRNA | blastn | 3718 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 17147006 | 17147006 | PRJNA597223_P_NODE_62974_length_183_cov_1.506757_g61128_i0 | PRJNA597223 | 62974 | 183 | 1.506757 | 2.75736531 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.016 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g61128 | i0 | 100 | 0.153005464480874 | 28 | 0 | 15 | 0 | 1 | 28 | 5 | 32 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 20267377 | 20267377 | PRJNA597223_S_NODE_3276_length_175_cov_1.963235_g3219_i0 | PRJNA597223 | 3276 | 175 | 1.963235 | 3.43566125 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.015 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g3219 | i0 | 100 | 0.32 | 28 | 0 | 16 | 0 | 1 | 28 | 30 | 57 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 22246103 | 22246103 | PRJNA597223_P_NODE_30818_length_270_cov_2.617021_g28972_i0 | PRJNA597223 | 30818 | 270 | 2.617021 | 7.0659567 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g28972 | i0 | 100 | 0.103703703703704 | 28 | 0 | 10 | 0 | 128 | 155 | 22185803 | 22185830 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
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);;