contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA756891" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4560448 | 4560448 | PRJNA756891_P_NODE_5624_length_358_cov_1.080702_g5555_i0 | PRJNA756891 | 5624 | 358 | 1.080702 | 3.86891316 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.034 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g5555 | i0 | 100 | 0.0782122905027933 | 28 | 0 | 8 | 0 | 163 | 190 | 13161087 | 13161114 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4560450 | 4560450 | PRJNA756891_P_NODE_604_length_998_cov_3.001081_g559_i0 | PRJNA756891 | 604 | 998 | 3.001081 | 29.95078838 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 0.002 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g559 | i0 | 100 | 0.031062124248497 | 31 | 0 | 3 | 0 | 240 | 270 | 64398506 | 64398476 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4560462 | 4560462 | PRJNA756891_P_NODE_8324_length_301_cov_1.280702_g8255_i0 | PRJNA756891 | 8324 | 301 | 1.280702 | 3.85491302 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2245617100|ref|XM_046470437.2| | 6454 | g8255 | i0 | 100 | 0.18936877076412 | 29 | 0 | 10 | 0 | 54 | 82 | 5448 | 5476 | PREDICTED: Haliotis rufescens uncharacterized LOC124110943 (LOC124110943), mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 5835553 | 5835553 | PRJNA756891_P_NODE_16685_length_240_cov_2.137725_g16616_i0 | PRJNA756891 | 16685 | 240 | 2.137725 | 5.13054 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g16616 | i0 | 100 | 0.35 | 28 | 0 | 12 | 0 | 37 | 64 | 50606372 | 50606345 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5835564 | 5835564 | PRJNA756891_P_NODE_3305_length_459_cov_5.121762_g3237_i0 | PRJNA756891 | 3305 | 459 | 5.121762 | 23.50888758 | Lottia peitaihoensis | 2576405 | Mollusca | Mollusca | 318 | 3.9799999999999996e-82 | NTclustered | gi|2734986515|gb|PP813871.1| | 2576405 | g3237 | i0 | 80.825 | 42.6492374727669 | 412 | 73 | 89 | 5 | 29 | 437 | 51 | 459 | Lottia peitaihoensis Rac1 mRNA, complete cds | blastn | 19576 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia peitaihoensis | ||
| 6306299 | 6306299 | PRJNA756891_P_NODE_1425_length_681_cov_1.532895_g1361_i0 | PRJNA756891 | 1425 | 681 | 1.532895 | 10.43901495 | Metazoa | 33208 | Mollusca | Mollusca | 60.2 | 4.06e-4 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g1361 | i0 | 100 | 0.751835535976505 | 32 | 0 | 5 | 0 | 358 | 389 | 66471540 | 66471509 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 512 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7580199 | 7580199 | PRJNA756891_P_NODE_12266_length_251_cov_0.865169_g12197_i0 | PRJNA756891 | 12266 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g12197 | i0 | 96.97 | 1.49003984063745 | 33 | 1 | 13 | 0 | 134 | 166 | 14733548 | 14733580 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 374 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8385286 | 8385286 | PRJNA756891_P_NODE_15007_length_244_cov_1.333333_g14938_i0 | PRJNA756891 | 15007 | 244 | 1.333333 | 3.25333252 | Perna viridis | 73031 | Mollusca | Mollusca | 237 | 5.6600000000000005e-58 | NTclustered | gi|56967588|gb|AY850128.1| | 73031 | g14938 | i0 | 94.771 | 0.627049180327869 | 153 | 4 | 61 | 3 | 1 | 149 | 233 | 81 | Perna viridis clone GM8 microsatellite sequence | blastn | 153 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Perna | Perna viridis | |
| 8855239 | 8855239 | PRJNA756891_P_NODE_13487_length_248_cov_0.880000_g13418_i0 | PRJNA756891 | 13487 | 248 | 0.88 | 2.1824 | Haliotis | 6452 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2245651111|ref|XM_046507706.2| | 6454 | g13418 | i0 | 96.875 | 0.903225806451613 | 32 | 1 | 13 | 0 | 81 | 112 | 3705 | 3736 | PREDICTED: Haliotis rufescens kinase suppressor of Ras 2-like (LOC124140250), transcript variant X3, mRNA | blastn | 224 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 9660526 | 9660526 | PRJNA756891_P_NODE_8588_length_296_cov_1.421525_g8519_i0 | PRJNA756891 | 8588 | 296 | 1.421525 | 4.207714 | Mytilus edulis | 6550 | Mollusca | Mollusca | 67.6 | 9.82e-7 | NTclustered | gi|2912441224|ref|XM_071271682.1| | 6550 | g8519 | i0 | 100 | 10.8513513513514 | 36 | 0 | 12 | 0 | 238 | 273 | 795 | 830 | PREDICTED: Mytilus edulis protein FAM114A2-like (LOC139486749), mRNA | blastn | 3212 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 10936123 | 10936123 | PRJNA756891_P_NODE_909_length_839_cov_1.121410_g853_i0 | PRJNA756891 | 909 | 839 | 1.12141 | 9.4086299 | Mya arenaria | 6604 | Mollusca | Mollusca | 56.5 | 0.007 | NTclustered | gi|2427389031|ref|XM_052917346.1| | 6604 | g853 | i0 | 100 | 0.0703218116805721 | 30 | 0 | 4 | 0 | 692 | 721 | 2432 | 2461 | PREDICTED: Mya arenaria prominin-1-A-like (LOC128212088), mRNA | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 12211578 | 12211578 | PRJNA756891_P_NODE_9530_length_282_cov_1.478469_g9461_i0 | PRJNA756891 | 9530 | 282 | 1.478469 | 4.16928258 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 58.4 | 5.59e-4 | NTclustered | gi|1207945343|ref|XM_021506811.1| | 6573 | g9461 | i0 | 100 | 0.109929078014184 | 31 | 0 | 11 | 0 | 180 | 210 | 275 | 245 | PREDICTED: Mizuhopecten yessoensis protein lifeguard 3-like (LOC110456216), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 17310103 | 17310103 | PRJNA756891_P_NODE_13634_length_247_cov_1.534483_g13565_i0 | PRJNA756891 | 13634 | 247 | 1.534483 | 3.79017301 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g13565 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 1 | 28 | 5589762 | 5589789 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17310119 | 17310119 | PRJNA756891_P_NODE_1634_length_642_cov_1.520211_g1568_i0 | PRJNA756891 | 1634 | 642 | 1.520211 | 9.75975462 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 0.001 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g1568 | i0 | 100 | 0.0934579439252336 | 31 | 0 | 5 | 0 | 286 | 316 | 57423431 | 57423461 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 60 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19859009 | 19859009 | PRJNA756891_P_NODE_12316_length_251_cov_0.865169_g12247_i0 | PRJNA756891 | 12316 | 251 | 0.865169 | 2.17157419 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|1914658283|ref|XM_036502966.1| | 2607531 | g12247 | i0 | 96.774 | 0.370517928286853 | 31 | 1 | 12 | 0 | 139 | 169 | 167 | 197 | PREDICTED: Octopus sinensis rho GDP-dissociation inhibitor 1 (LOC115211966), transcript variant X3, mRNA | blastn | 93 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 21134555 | 21134555 | PRJNA756891_P_NODE_15217_length_244_cov_0.900585_g15148_i0 | PRJNA756891 | 15217 | 244 | 0.900585 | 2.1974274 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 58.4 | 4.73e-4 | NTclustered | gi|1914657770|ref|XM_036502771.1| | 2607531 | g15148 | i0 | 97.059 | 6.4344262295082 | 34 | 1 | 14 | 0 | 170 | 203 | 737 | 770 | PREDICTED: Octopus sinensis probable serine/threonine-protein kinase clkA (LOC118763352), partial mRNA | blastn | 1570 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 21134559 | 21134559 | PRJNA756891_P_NODE_15597_length_243_cov_0.905882_g15528_i0 | PRJNA756891 | 15597 | 243 | 0.905882 | 2.20129326 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g15528 | i0 | 89.13 | 3.28395061728395 | 46 | 3 | 19 | 2 | 1 | 45 | 56995036 | 56994992 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 798 | 56.5 | 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);;