contig_metadata
10 rows where bioproject = "PRJEB41113", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2265104 | 2265104 | PRJEB41113_S_NODE_1322_length_247_cov_7.128571_g1313_i0 | PRJEB41113 | 1322 | 247 | 7.128571 | 17.60757037 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.1 | 3.71e-5 | NTclustered | gi|2441988952|ref|XM_045315626.2| | 6596 | g1313 | i0 | 86.667 | 3.07287449392713 | 60 | 3 | 24 | 4 | 89 | 147 | 434 | 489 | PREDICTED: Mercenaria mercenaria 60S acidic ribosomal protein P2-like (LOC123533772), mRNA | blastn | 759 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 11537392 | 11537392 | PRJEB41113_S_NODE_9250_length_162_cov_12.736000_g9241_i0 | PRJEB41113 | 9250 | 162 | 12.736 | 20.63232 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g9241 | i0 | 100 | 0.179012345679012 | 29 | 0 | 18 | 0 | 15 | 43 | 13186269 | 13186241 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12468961 | 12468961 | PRJEB41113_S_NODE_9210_length_163_cov_1.206349_g9201_i0 | PRJEB41113 | 9210 | 163 | 1.206349 | 1.96634887 | Mytilus | 6548 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2912420598|ref|XM_071323436.1| | 6550 | g9201 | i0 | 100 | 0.858895705521472 | 28 | 0 | 17 | 0 | 103 | 130 | 1205 | 1232 | PREDICTED: Mytilus edulis myb-binding protein 1A-like (LOC139527771), transcript variant X1, mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 13743341 | 13743341 | PRJEB41113_S_NODE_5731_length_182_cov_17.813793_g5722_i0 | PRJEB41113 | 5731 | 182 | 17.813793 | 32.42110326 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g5722 | i0 | 96.774 | 0.324175824175824 | 31 | 1 | 17 | 0 | 56 | 86 | 56217388 | 56217418 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 59 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16635985 | 16635985 | PRJEB41113_S_NODE_8614_length_165_cov_4.062500_g8605_i0 | PRJEB41113 | 8614 | 165 | 4.0625 | 6.703125 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g8605 | i0 | 100 | 0.175757575757576 | 29 | 0 | 18 | 0 | 120 | 148 | 38110803 | 38110775 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17910723 | 17910723 | PRJEB41113_S_NODE_7455_length_171_cov_8.798507_g7446_i0 | PRJEB41113 | 7455 | 171 | 8.798507 | 15.04544697 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g7446 | i0 | 92.308 | 0.228070175438596 | 39 | 1 | 22 | 2 | 78 | 114 | 41054756 | 41054718 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 39 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24284983 | 24284983 | PRJEB41113_S_NODE_8320_length_167_cov_1.415385_g8311_i0 | PRJEB41113 | 8320 | 167 | 1.415385 | 2.36369295 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 180 | 6.16e-41 | NTclustered | gi|2364291770|ref|XR_008040134.1| | 45954 | g8311 | i0 | 88.312 | 36.311377245509 | 154 | 12 | 92 | 2 | 1 | 153 | 1436 | 1288 | PREDICTED: Dreissena polymorpha uncharacterized LOC127861211 (LOC127861211), transcript variant X2, ncRNA | blastn | 6064 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 29780734 | 29780734 | PRJEB41113_S_NODE_6871_length_175_cov_2.927536_g6862_i0 | PRJEB41113 | 6871 | 175 | 2.927536 | 5.123188 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 41.6 | 0.0356 | NR | KAK7098458.1 | 31220 | g6862 | i0 | 65.5 | 8.21142857142857 | 29 | 7 | 44.6 | 1 | 98 | 21 | 187 | 215 | KAK7098458.1 hypothetical protein V1264_002746 [Littorina saxatilis] | diamond | 1437 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 31733354 | 31733354 | PRJEB41113_S_NODE_14557_length_151_cov_2.964912_g14548_i0 | PRJEB41113 | 14557 | 151 | 2.964912 | 4.47701712 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.9 | 0.00228 | NR | XP_050407805.1 | 6465 | g14548 | i0 | 79.2 | 5.20529801324503 | 24 | 5 | 47.7 | 0 | 150 | 79 | 130 | 153 | XP_050407805.1 putative peptidyl-prolyl cis-trans isomerase dodo [Patella vulgata] | diamond | 786 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32783050 | 32783050 | PRJEB41113_S_NODE_11700_length_155_cov_4.084746_g11691_i0 | PRJEB41113 | 11700 | 155 | 4.084746 | 6.3313563 | Mya arenaria | 6604 | Mollusca | Mollusca | 53.5 | 1.73e-6 | NR | WAQ95240.1 | 6604 | g11691 | i0 | 73.3 | 1.74193548387097 | 30 | 8 | 58.1 | 0 | 14 | 103 | 311 | 340 | WAQ95240.1 hypothetical protein MAR_027930 [Mya arenaria] | diamond | 270 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;