contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJEB28589" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25925 | 25925 | PRJEB28589_S_NODE_17501_length_166_cov_1.218487_g17393_i0 | PRJEB28589 | 17501 | 166 | 1.218487 | 2.02268842 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g17393 | i0 | 100 | 0.36144578313253 | 29 | 0 | 17 | 0 | 120 | 148 | 61123950 | 61123922 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 60 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5128372 | 5128372 | PRJEB28589_S_NODE_4205_length_341_cov_4.500000_g4097_i0 | PRJEB28589 | 4205 | 341 | 4.5 | 15.345 | Haliotis cracherodii | 6455 | Mollusca | Mollusca | 93.5 | 1.9e-14 | NTclustered | gi|2911871899|ref|XM_071259882.1| | 6455 | g4097 | i0 | 93.548 | 15.9912023460411 | 62 | 4 | 18 | 0 | 1 | 62 | 1013 | 952 | PREDICTED: Haliotis cracherodii platelet binding protein GspB-like (LOC139477330), mRNA | blastn | 5453 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 7365640 | 7365640 | PRJEB28589_S_NODE_3346_length_360_cov_1.600639_g3238_i0 | PRJEB28589 | 3346 | 360 | 1.600639 | 5.7623004 | Metazoa | 33208 | Mollusca | Mollusca | 58.4 | 7.33e-4 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g3238 | i0 | 100 | 10.7888888888889 | 31 | 0 | 9 | 0 | 1 | 31 | 17306546 | 17306576 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 3884 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7678239 | 7678239 | PRJEB28589_S_NODE_647_length_608_cov_4.901961_g553_i0 | PRJEB28589 | 647 | 608 | 4.901961 | 29.80392288 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 167 | 2.06e-36 | NTclustered | gi|2441969956|ref|XM_053549719.1| | 6596 | g553 | i0 | 83.889 | 3.23848684210526 | 180 | 23 | 29 | 5 | 1 | 176 | 795 | 972 | PREDICTED: Mercenaria mercenaria serine/threonine-protein phosphatase PP1-beta catalytic subunit (LOC123535544), transcript variant X2, mRNA | blastn | 1969 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 8953014 | 8953014 | PRJEB28589_S_NODE_6868_length_295_cov_1.149194_g6760_i0 | PRJEB28589 | 6868 | 295 | 1.149194 | 3.3901223 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g6760 | i0 | 94.595 | 0.511864406779661 | 37 | 0 | 12 | 2 | 258 | 293 | 40 | 5 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 151 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 11504040 | 11504040 | PRJEB28589_S_NODE_19610_length_152_cov_3.771429_g19502_i0 | PRJEB28589 | 19610 | 152 | 3.771429 | 5.73257208 | Mytilus edulis | 6550 | Mollusca | Mollusca | 65.8 | 1.6e-6 | NTclustered | gi|2912339766|ref|XM_071283030.1| | 6550 | g19502 | i0 | 100 | 0.230263157894737 | 35 | 0 | 23 | 0 | 6 | 40 | 446 | 412 | PREDICTED: Mytilus edulis cysteinyl leukotriene receptor 2-like (LOC139494884), mRNA | blastn | 35 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 11504053 | 11504053 | PRJEB28589_S_NODE_4070_length_344_cov_1.750842_g3962_i0 | PRJEB28589 | 4070 | 344 | 1.750842 | 6.02289648 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 58.4 | 6.99e-4 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g3962 | i0 | 100 | 0.421511627906977 | 31 | 0 | 9 | 0 | 312 | 342 | 35 | 5 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 145 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 12467113 | 12467113 | PRJEB28589_S_NODE_12210_length_218_cov_2.157895_g12102_i0 | PRJEB28589 | 12210 | 218 | 2.157895 | 4.7042111 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.005 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g12102 | i0 | 100 | 0.522935779816514 | 29 | 0 | 13 | 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 | |
| 12779498 | 12779498 | PRJEB28589_S_NODE_14671_length_191_cov_0.972222_g14563_i0 | PRJEB28589 | 14671 | 191 | 0.972222 | 1.85694402 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 58.4 | 3.53e-4 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g14563 | i0 | 97.059 | 0.62303664921466 | 34 | 1 | 18 | 0 | 158 | 191 | 62 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 119 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 14054172 | 14054172 | PRJEB28589_S_NODE_5732_length_312_cov_4.188679_g5624_i0 | PRJEB28589 | 5732 | 312 | 4.188679 | 13.06867848 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 82.4 | 3.72e-11 | NTclustered | gi|2245719637|ref|XM_048388712.1| | 6454 | g5624 | i0 | 97.872 | 1.21474358974359 | 47 | 1 | 15 | 0 | 60 | 106 | 431 | 477 | PREDICTED: Haliotis rufescens glycine-rich protein 23-like (LOC124123263), mRNA | blastn | 379 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 15328131 | 15328131 | PRJEB28589_S_NODE_3653_length_352_cov_4.022951_g3545_i0 | PRJEB28589 | 3653 | 352 | 4.022951 | 14.16078752 | Magallana gigas | 29159 | Mollusca | Mollusca | 163 | 1.4699999999999998e-35 | NTclustered | gi|2751265028|ref|XM_011440704.4| | 29159 | g3545 | i0 | 82.353 | 4.51988636363636 | 187 | 33 | 53 | 0 | 4 | 190 | 442 | 628 | PREDICTED: Magallana gigas ADP-ribosylation factor-like protein 8A (LOC105336396), mRNA | blastn | 1591 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 16602814 | 16602814 | PRJEB28589_S_NODE_674_length_601_cov_11.384477_g579_i0 | PRJEB28589 | 674 | 601 | 11.384477 | 68.42070677 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.005 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g579 | i0 | 92.5 | 0.0665557404326123 | 40 | 2 | 6 | 1 | 427 | 465 | 51621365 | 51621404 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 40 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19151477 | 19151477 | PRJEB28589_S_NODE_14136_length_196_cov_1.523490_g14028_i0 | PRJEB28589 | 14136 | 196 | 1.52349 | 2.9860404 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g14028 | i0 | 100 | 0.586734693877551 | 30 | 0 | 15 | 0 | 1 | 30 | 29 | 58 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 115 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 19151496 | 19151496 | PRJEB28589_S_NODE_1816_length_426_cov_4.920844_g1708_i0 | PRJEB28589 | 1816 | 426 | 4.920844 | 20.96279544 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g1708 | i0 | 100 | 0.269953051643192 | 30 | 0 | 7 | 0 | 397 | 426 | 58 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 115 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 22664912 | 22664912 | PRJEB28589_S_NODE_5558_length_315_cov_2.541045_g5450_i0 | PRJEB28589 | 5558 | 315 | 2.541045 | 8.00429175 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.008 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g5450 | i0 | 100 | 0.361904761904762 | 29 | 0 | 9 | 0 | 287 | 315 | 57 | 29 | 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 | |
| 22977946 | 22977946 | PRJEB28589_S_NODE_1959_length_415_cov_6.755435_g1851_i0 | PRJEB28589 | 1959 | 415 | 6.755435 | 28.03505525 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g1851 | i0 | 100 | 0.27710843373494 | 30 | 0 | 7 | 0 | 386 | 415 | 58 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 115 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 24251807 | 24251807 | PRJEB28589_S_NODE_5620_length_314_cov_1.685393_g5512_i0 | PRJEB28589 | 5620 | 314 | 1.685393 | 5.29213402 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 60.2 | 1.76e-4 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g5512 | i0 | 100 | 0.372611464968153 | 32 | 0 | 10 | 0 | 283 | 314 | 60 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 117 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 25214073 | 25214073 | PRJEB28589_S_NODE_10360_length_243_cov_3.035714_g10252_i0 | PRJEB28589 | 10360 | 243 | 3.035714 | 7.37678502 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.006 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g10252 | i0 | 100 | 0.469135802469136 | 29 | 0 | 12 | 0 | 215 | 243 | 57 | 29 | 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 | |
| 25214099 | 25214099 | PRJEB28589_S_NODE_5940_length_309_cov_2.213740_g5832_i0 | PRJEB28589 | 5940 | 309 | 2.21374 | 6.8404566000000004 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.008 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g5832 | i0 | 100 | 0.368932038834951 | 29 | 0 | 9 | 0 | 281 | 309 | 57 | 29 | 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 |
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);;