contig_metadata
8 rows where bioproject = "PRJNA1047551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6112980 | 6112980 | PRJNA1047551_S_NODE_4185_length_231_cov_3.887755_g4058_i0 | PRJNA1047551 | 4185 | 231 | 3.887755 | 8.98071405 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2194131699|ref|XM_046721879.1| | 36100 | g4058 | i0 | 100 | 8.72727272727273 | 29 | 0 | 13 | 0 | 187 | 215 | 466 | 438 | PREDICTED: Haliotis rubra 60S acidic ribosomal protein P1-like (LOC124285616), mRNA | blastn | 2016 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 6552631 | 6552631 | PRJNA1047551_S_NODE_5826_length_204_cov_3.189349_g5699_i0 | PRJNA1047551 | 5826 | 204 | 3.189349 | 6.50627196 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g5699 | i0 | 96.97 | 0.161764705882353 | 33 | 1 | 16 | 0 | 119 | 151 | 54666226 | 54666258 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12928286 | 12928286 | PRJNA1047551_S_NODE_2471_length_289_cov_5.287402_g2344_i0 | PRJNA1047551 | 2471 | 289 | 5.287402 | 15.28059178 | Pecten maximus | 6579 | Mollusca | Mollusca | 71.3 | 7.38e-8 | NTclustered | gi|1835452351|ref|XM_033891464.1| | 6579 | g2344 | i0 | 89.286 | 0.567474048442907 | 56 | 6 | 19 | 0 | 1 | 56 | 344 | 399 | PREDICTED: Pecten maximus dynein light chain 2, cytoplasmic-like (LOC117332522), mRNA | blastn | 164 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 21411862 | 21411862 | PRJNA1047551_S_NODE_2217_length_303_cov_3.261194_g2090_i0 | PRJNA1047551 | 2217 | 303 | 3.261194 | 9.88141782 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.028 | NTclustered | gi|2502184947|ref|XM_056035088.1| | 6526 | g2090 | i0 | 100 | 0.277227722772277 | 28 | 0 | 9 | 0 | 223 | 250 | 534 | 507 | PREDICTED: Biomphalaria glabrata ctenidin-1-like (LOC106070527), mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 23126920 | 23126920 | PRJNA1047551_S_NODE_4679_length_221_cov_2.860215_g4552_i0 | PRJNA1047551 | 4679 | 221 | 2.860215 | 6.32107515 | Lottia gigantea | 225164 | Mollusca | Mollusca | 113 | 8.860000000000001e-21 | NTclustered | gi|676472385|ref|XM_009061227.1| | 225164 | g4552 | i0 | 84.821 | 35.4841628959276 | 112 | 17 | 51 | 0 | 95 | 206 | 1370 | 1259 | Lottia gigantea hypothetical protein mRNA | blastn | 7842 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 25236147 | 25236147 | PRJNA1047551_S_NODE_1660_length_344_cov_10.695793_g1533_i0 | PRJNA1047551 | 1660 | 344 | 10.695793 | 36.79352792 | Bivalvia | 6544 | Mollusca | Mollusca | 89.8 | 2.48e-13 | NTclustered | gi|2334727284|ref|XM_052249129.1| | 6549 | g1533 | i0 | 87.342 | 3.36046511627907 | 79 | 9 | 23 | 1 | 21 | 98 | 1353 | 1431 | PREDICTED: Mytilus californianus tubulin beta-4B chain-like (LOC127738048), mRNA | blastn | 1156 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 31417614 | 31417614 | PRJNA1047551_S_NODE_9296_length_172_cov_2.379562_g9169_i0 | PRJNA1047551 | 9296 | 172 | 2.379562 | 4.09284664 | Metazoa | 33208 | Mollusca | Mollusca | 79.3 | 2.17e-16 | NR | XP_045192477.2 | 6596 | g9169 | i0 | 75.4 | 17.843023255814 | 57 | 14 | 99.4 | 0 | 172 | 2 | 73 | 129 | XP_045192477.2 60S ribosomal protein L13-like [Mercenaria mercenaria] | diamond | 3069 | 79.7 | 0.994981179422836 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 32335330 | 32335330 | PRJNA1047551_S_NODE_2259_length_301_cov_3.364662_g2132_i0 | PRJNA1047551 | 2259 | 301 | 3.364662 | 10.12763262 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 9.42e-4 | NR | KAJ8314025.1 | 220873 | g2132 | i0 | 39.7 | 3.0797342192691 | 63 | 33 | 57.8 | 3 | 290 | 117 | 929 | 991 | KAJ8314025.1 hypothetical protein KUTeg_008586 [Tegillarca granosa] | diamond | 927 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa |
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);;