contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3961054 | 3961054 | PRJEB673_P_NODE_7244_length_321_cov_1.527972_g6895_i0 | PRJEB673 | 7244 | 321 | 1.527972 | 4.90479012 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2427419089|ref|XM_052927617.1| | 6604 | g6895 | i0 | 96.875 | 0.0996884735202492 | 32 | 1 | 10 | 0 | 186 | 217 | 8333 | 8364 | PREDICTED: Mya arenaria uncharacterized LOC128219697 (LOC128219697), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 6512965 | 6512965 | PRJEB673_P_NODE_10106_length_180_cov_2.593103_g9757_i0 | PRJEB673 | 10106 | 180 | 2.593103 | 4.6675854 | Sthenoteuthis oualaniensis | 34553 | Mollusca | Mollusca | 171 | 4.0399999999999996e-38 | NTclustered | gi|186920083|ref|NC_010636.1| | 34553 | g9757 | i0 | 84.659 | 89.6111111111111 | 176 | 22 | 96 | 5 | 1 | 173 | 2362 | 2189 | Sthenoteuthis oualaniensis mitochondrion, complete genome | blastn | 16130 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Oegopsida | Ommastrephidae | Sthenoteuthis | Sthenoteuthis oualaniensis | |
| 10337972 | 10337972 | PRJEB673_P_NODE_4709_length_427_cov_2.380102_g4361_i0 | PRJEB673 | 4709 | 427 | 2.380102 | 10.16303554 | Amphioctopus fangsiao | 515817 | Mollusca | Mollusca | 137 | 1.1e-27 | NTclustered | gi|2186270437|gb|MT180322.1| | 515817 | g4361 | i0 | 86.885 | 28.3044496487119 | 122 | 16 | 29 | 0 | 125 | 246 | 9712 | 9591 | Amphioctopus fangsiao mitochondrion, complete genome | blastn | 12086 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Amphioctopus | Amphioctopus fangsiao | |
| 19260540 | 19260540 | PRJEB673_P_NODE_6956_length_328_cov_2.313993_g6607_i0 | PRJEB673 | 6956 | 328 | 2.313993 | 7.58989704 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 187 | 8.11e-43 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g6607 | i0 | 87.273 | 4.41158536585366 | 165 | 20 | 50 | 1 | 1 | 164 | 55579203 | 55579367 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 1447 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19260568 | 19260568 | PRJEB673_P_NODE_9956_length_183_cov_2.432432_g9607_i0 | PRJEB673 | 9956 | 183 | 2.432432 | 4.45135056 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 143 | 8.989999999999998e-30 | NTclustered | gi|1914622278|ref|XM_029795136.2| | 2607531 | g9607 | i0 | 88.235 | 22.4590163934426 | 119 | 14 | 65 | 0 | 1 | 119 | 1487 | 1605 | PREDICTED: Octopus sinensis tubulin alpha-1B chain (LOC115224301), mRNA | blastn | 4110 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 20121789 | 20121789 | PRJEB673_P_NODE_6216_length_350_cov_7.400000_g5867_i0 | PRJEB673 | 6216 | 350 | 7.4 | 25.9 | Cephalaspidea | 69554 | Mollusca | Mollusca | 159 | 1.8899999999999998e-34 | NTclustered | gi|1704728144|gb|MK473569.1| | 413673 | g5867 | i0 | 76.512 | 54.1628571428571 | 281 | 56 | 79 | 9 | 4 | 280 | 326 | 52 | Lamprohaminoea ovalis isolate TH74 histone 3 (H3) gene, partial cds | blastn | 18957 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Cephalaspidea | Haminoeidae | Lamprohaminoea | Lamprohaminoea ovalis | |
| 20535872 | 20535872 | PRJEB673_P_NODE_8877_length_229_cov_0.948454_g8528_i0 | PRJEB673 | 8877 | 229 | 0.948454 | 2.17195966 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2442010133|ref|XM_045346008.2| | 6596 | g8528 | i0 | 96.97 | 2.52401746724891 | 33 | 1 | 14 | 0 | 35 | 67 | 1028 | 996 | PREDICTED: Mercenaria mercenaria uncharacterized LOC123555358 (LOC123555358), transcript variant X1, mRNA | blastn | 578 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria |
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);;