contig_metadata
17 rows where bioproject = "PRJNA1241156", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11828745 | 11828745 | PRJNA1241156_S_NODE_49530_length_277_cov_3.141026_g49070_i0 | PRJNA1241156 | 49530 | 277 | 3.141026 | 8.70064202 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 60.2 | 1.52e-4 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g49070 | i0 | 94.872 | 0.75812274368231 | 39 | 0 | 14 | 2 | 239 | 277 | 44 | 8 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 210 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 13103507 | 13103507 | PRJNA1241156_S_NODE_19071_length_369_cov_4.082822_g18611_i0 | PRJNA1241156 | 19071 | 369 | 4.082822 | 15.06561318 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g18611 | i0 | 96.97 | 0.544715447154472 | 33 | 1 | 9 | 0 | 1 | 33 | 8 | 40 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 201 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 14378848 | 14378848 | PRJNA1241156_S_NODE_28312_length_335_cov_25.352740_g27852_i0 | PRJNA1241156 | 28312 | 335 | 25.35274 | 84.931679 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 6.79e-4 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g27852 | i0 | 97.059 | 0.185074626865672 | 34 | 1 | 10 | 0 | 240 | 273 | 10542505 | 10542472 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15652548 | 15652548 | PRJNA1241156_S_NODE_14833_length_390_cov_2.610951_g14373_i0 | PRJNA1241156 | 14833 | 390 | 2.610951 | 10.1827089 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 52.8 | 0.037 | NTclustered | gi|2628414026|ref|XM_061316425.1| | 191078 | g14373 | i0 | 100 | 0.358974358974359 | 28 | 0 | 7 | 0 | 333 | 360 | 6338 | 6311 | PREDICTED: Saccostrea echinata ras-specific guanine nucleotide-releasing factor 2-like (LOC133181811), transcript variant X2, mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 16927571 | 16927571 | PRJNA1241156_S_NODE_65914_length_241_cov_8.237374_g65454_i0 | PRJNA1241156 | 65914 | 241 | 8.237374 | 19.85207134 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g65454 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 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 | |
| 17628438 | 17628438 | PRJNA1241156_S_NODE_40954_length_300_cov_1.249027_g40494_i0 | PRJNA1241156 | 40954 | 300 | 1.249027 | 3.747081 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.008 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g40494 | i0 | 100 | 0.38 | 29 | 0 | 10 | 0 | 1 | 29 | 29 | 57 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 114 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 19475679 | 19475679 | PRJNA1241156_S_NODE_18896_length_370_cov_2.250765_g18436_i0 | PRJNA1241156 | 18896 | 370 | 2.250765 | 8.3278305 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g18436 | i0 | 89.362 | 0.432432432432432 | 47 | 1 | 13 | 3 | 1 | 47 | 29 | 71 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 160 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 20751915 | 20751915 | PRJNA1241156_S_NODE_76177_length_202_cov_5.484277_g75717_i0 | PRJNA1241156 | 76177 | 202 | 5.484277 | 11.07823954 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 8.12e-6 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g75717 | i0 | 95 | 0.346534653465347 | 40 | 2 | 20 | 0 | 163 | 202 | 46451744 | 46451783 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 70 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20751922 | 20751922 | PRJNA1241156_S_NODE_77117_length_199_cov_4.711538_g76657_i0 | PRJNA1241156 | 77117 | 199 | 4.711538 | 9.37596062 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.017 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g76657 | i0 | 100 | 0.14070351758794 | 28 | 0 | 14 | 0 | 116 | 143 | 2981416 | 2981443 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23302073 | 23302073 | PRJNA1241156_S_NODE_18879_length_370_cov_3.330275_g18419_i0 | PRJNA1241156 | 18879 | 370 | 3.330275 | 12.3220175 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g18419 | i0 | 94.595 | 0.32972972972973 | 37 | 1 | 10 | 1 | 334 | 370 | 64 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 122 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 23302477 | 23302477 | PRJNA1241156_S_NODE_48459_length_280_cov_1.578059_g47999_i0 | PRJNA1241156 | 48459 | 280 | 1.578059 | 4.4185652 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 5.55e-4 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g47999 | i0 | 100 | 1.64285714285714 | 31 | 0 | 11 | 0 | 236 | 266 | 47349027 | 47349057 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 460 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24576210 | 24576210 | PRJNA1241156_S_NODE_36080_length_313_cov_3.025926_g35620_i0 | PRJNA1241156 | 36080 | 313 | 3.025926 | 9.47114838 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g35620 | i0 | 100 | 0.185303514376997 | 30 | 0 | 10 | 0 | 284 | 313 | 39 | 10 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 58 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 27484364 | 27484364 | PRJNA1241156_S_NODE_33223_length_321_cov_2.089928_g32763_i0 | PRJNA1241156 | 33223 | 321 | 2.089928 | 6.70866888 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 48.1 | 0.00122 | NR | KAK3092048.1 | 66713 | g32763 | i0 | 46.6 | 1.08411214953271 | 58 | 27 | 54.2 | 2 | 256 | 83 | 66 | 119 | KAK3092048.1 hypothetical protein FSP39_024717 [Pinctada imbricata] | diamond | 348 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 28021286 | 28021286 | PRJNA1241156_S_NODE_58585_length_256_cov_8.436620_g58125_i0 | PRJNA1241156 | 58585 | 256 | 8.43662 | 21.5977472 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 42.7 | 0.043 | NR | CAC5403229.1 | 42192 | g58125 | i0 | 41.9 | 0.50390625 | 43 | 25 | 50.4 | 0 | 235 | 107 | 163 | 205 | CAC5403229.1 CASP8 [Mytilus coruscus] | diamond | 129 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 28873554 | 28873554 | PRJNA1241156_S_NODE_45028_length_289_cov_1.540650_g44568_i0 | PRJNA1241156 | 45028 | 289 | 1.54065 | 4.4524785 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 70.1 | 1.58e-11 | NR | CAC5382819.1 | 42192 | g44568 | i0 | 55.9 | 2.44982698961938 | 59 | 26 | 61.2 | 0 | 10 | 186 | 84 | 142 | CAC5382819.1 unnamed protein product [Mytilus coruscus] | diamond | 708 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 29270423 | 29270423 | PRJNA1241156_S_NODE_57609_length_258_cov_10.906977_g57149_i0 | PRJNA1241156 | 57609 | 258 | 10.906977 | 28.14000066 | root | 1 | Root_unresolved | Root_unresolved | 45.8 | 0.00304 | NR | XP_009051212.1 | 225164 | g57149 | i0 | 52.9 | 1.30232558139535 | 34 | 16 | 39.5 | 0 | 166 | 65 | 10 | 43 | XP_009051212.1 hypothetical protein LOTGIDRAFT_143124 [Lottia gigantea] | diamond | 336 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 32760220 | 32760220 | PRJNA1241156_S_NODE_31440_length_326_cov_3.197880_g30980_i0 | PRJNA1241156 | 31440 | 326 | 3.19788 | 10.4250888 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 45.4 | 0.00512 | NR | XP_029651769.1 | 2607531 | g30980 | i0 | 50 | 0.276073619631902 | 30 | 15 | 27.6 | 0 | 257 | 168 | 117 | 146 | XP_029651769.1 piggyBac transposable element-derived protein 4-like [Octopus sinensis] | diamond | 90 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis |
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);;