contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2274402 | 2274402 | PRJNA1000943_P_NODE_9162_length_275_cov_1.440594_g9024_i0 | PRJNA1000943 | 9162 | 275 | 1.440594 | 3.9616335 | Gastropoda | 6448 | Mollusca | Mollusca | 63.9 | 1.17e-5 | NTclustered | gi|2868606537|ref|XM_070329319.1| | 31220 | g9024 | i0 | 100 | 0.938181818181818 | 34 | 0 | 12 | 0 | 172 | 205 | 719 | 752 | PREDICTED: Littorina saxatilis mucin-3A-like (LOC138958216), mRNA | blastn | 258 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 3971463 | 3971463 | PRJNA1000943_P_NODE_504_length_998_cov_3.148108_g420_i0 | PRJNA1000943 | 504 | 998 | 3.148108 | 31.41811784 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 80.5 | 4.64e-10 | NTclustered | gi|2669106401|ref|XM_062732311.1| | 36930 | g420 | i0 | 73.913 | 0.230460921843687 | 230 | 46 | 22 | 13 | 496 | 718 | 546 | 324 | PREDICTED: Saccostrea cucullata large ribosomal subunit protein uL1-like (LOC134249968), mRNA | blastn | 230 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 3971506 | 3971506 | PRJNA1000943_P_NODE_8704_length_281_cov_1.490385_g8566_i0 | PRJNA1000943 | 8704 | 281 | 1.490385 | 4.18798185 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 176 | 1.47e-39 | NTclustered | gi|2502097227|ref|XM_013231627.2| | 6526 | g8566 | i0 | 82.743 | 33.135231316726 | 226 | 12 | 72 | 16 | 26 | 227 | 2613 | 2391 | PREDICTED: Biomphalaria glabrata mucin-2-like (LOC106071503), mRNA | blastn | 9311 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 5247976 | 5247976 | PRJNA1000943_P_NODE_6105_length_327_cov_1.228346_g5967_i0 | PRJNA1000943 | 6105 | 327 | 1.228346 | 4.01669142 | Liolophura japonica | 13599 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2724234133|ref|XM_064742165.1| | 13599 | g5967 | i0 | 100 | 0.0856269113149847 | 28 | 0 | 9 | 0 | 281 | 308 | 844 | 871 | PREDICTED: Liolophura japonica lupus La protein homolog (LOC135464675), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 10348346 | 10348346 | PRJNA1000943_P_NODE_8949_length_278_cov_1.521951_g8811_i0 | PRJNA1000943 | 8949 | 278 | 1.521951 | 4.23102378 | Ctena cf. galapagana NHMUK 20210086 | 2892552 | Mollusca | Mollusca | 134 | 8.88e-27 | NTclustered | gi|2129023951|gb|OL361786.1| | 2892552 | g8811 | i0 | 91.667 | 6.61870503597122 | 96 | 8 | 35 | 0 | 180 | 275 | 4053 | 4148 | 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 | 1840 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lucinida | Lucinidae | Ctena | Ctena cf. galapagana NHMUK 20210086 | |
| 11623691 | 11623691 | PRJNA1000943_P_NODE_13690_length_246_cov_0.901734_g13552_i0 | PRJNA1000943 | 13690 | 246 | 0.901734 | 2.21826564 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.33e-4 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g13552 | i0 | 94.737 | 0.154471544715447 | 38 | 2 | 15 | 0 | 117 | 154 | 80678925 | 80678888 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 38 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11623712 | 11623712 | PRJNA1000943_P_NODE_15630_length_241_cov_2.107143_g15492_i0 | PRJNA1000943 | 15630 | 241 | 2.107143 | 5.07821463 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 93.5 | 1.28e-14 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g15492 | i0 | 77.005 | 27.8174273858921 | 187 | 27 | 76 | 12 | 55 | 237 | 62549568 | 62549394 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 6704 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20546370 | 20546370 | PRJNA1000943_P_NODE_9537_length_270_cov_1.578680_g9399_i0 | PRJNA1000943 | 9537 | 270 | 1.57868 | 4.262436 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.48e-4 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g9399 | i0 | 94.737 | 1.4 | 38 | 2 | 14 | 0 | 197 | 234 | 19185291 | 19185254 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 378 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21821930 | 21821930 | PRJNA1000943_P_NODE_11638_length_251_cov_3.286517_g11500_i0 | PRJNA1000943 | 11638 | 251 | 3.286517 | 8.24915767 | Aplysia californica | 6500 | Mollusca | Mollusca | 171 | 6.02e-38 | NTclustered | gi|325297119|ref|NM_001204640.1| | 6500 | g11500 | i0 | 88.112 | 56.7848605577689 | 143 | 17 | 57 | 0 | 1 | 143 | 1061 | 1203 | Aplysia californica actin (LOC100533345), mRNA | blastn | 14253 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 21821949 | 21821949 | PRJNA1000943_P_NODE_1298_length_663_cov_2.350847_g1167_i0 | PRJNA1000943 | 1298 | 663 | 2.350847 | 15.58611561 | Mytilus californianus | 6549 | Mollusca | Mollusca | 56.5 | 0.005 | NTclustered | gi|2334761577|ref|XM_052209329.1| | 6549 | g1167 | i0 | 100 | 0.499245852187029 | 30 | 0 | 5 | 0 | 114 | 143 | 1009 | 980 | PREDICTED: Mytilus californianus uncharacterized LOC127705057 (LOC127705057), transcript variant X3, mRNA | blastn | 331 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus |
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);;