contig_metadata
11 rows where bioproject = "PRJNA680334", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 649478 | 649478 | PRJNA680334_S_NODE_31901_length_220_cov_7.235294_g31415_i0 | PRJNA680334 | 31901 | 220 | 7.235294 | 15.9176468 | Cochlicopa lubrica | 82567 | Mollusca | Mollusca | 363 | 7.92e-96 | NTclustered | gi|308191338|gb|GU331954.1| | 82567 | g31415 | i0 | 99.5 | 55.4772727272727 | 200 | 0 | 90 | 1 | 22 | 220 | 439 | 240 | Cochlicopa lubrica 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 12205 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Cochlicopidae | Cochlicopa | Cochlicopa lubrica | |
| 650247 | 650247 | PRJNA680334_S_NODE_74121_length_169_cov_2.757353_g73635_i0 | PRJNA680334 | 74121 | 169 | 2.757353 | 4.65992657 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g73635 | i0 | 100 | 0.165680473372781 | 28 | 0 | 17 | 0 | 136 | 163 | 34198753 | 34198726 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 3721146 | 3721146 | PRJNA680334_S_NODE_83063_length_163_cov_2.361538_g82577_i0 | PRJNA680334 | 83063 | 163 | 2.361538 | 3.84930694 | Stylommatophora | 6527 | Mollusca | Mollusca | 296 | 5.68e-76 | NTclustered | gi|45360329|gb|AY546382.1| | 42349 | g82577 | i0 | 99.387 | 151.705521472393 | 163 | 1 | 100 | 0 | 1 | 163 | 201 | 363 | Albinaria caerulea 18S ribosomal RNA gene, partial sequence | blastn | 24728 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Clausiliidae | Albinaria | Albinaria caerulea | |
| 5753562 | 5753562 | PRJNA680334_S_NODE_53125_length_188_cov_3.819355_g52639_i0 | PRJNA680334 | 53125 | 188 | 3.819355 | 7.1803874 | Cochlicopa lubrica | 82567 | Mollusca | Mollusca | 335 | 1.4299999999999995e-87 | NTclustered | gi|308191338|gb|GU331954.1| | 82567 | g52639 | i0 | 98.93 | 95.6489361702128 | 187 | 1 | 99 | 1 | 2 | 188 | 51 | 236 | Cochlicopa lubrica 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 17982 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Cochlicopidae | Cochlicopa | Cochlicopa lubrica | |
| 7028620 | 7028620 | PRJNA680334_S_NODE_5346_length_379_cov_4.765896_g4861_i0 | PRJNA680334 | 5346 | 379 | 4.765896 | 18.06274584 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.036 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g4861 | i0 | 100 | 0.0738786279683377 | 28 | 0 | 7 | 0 | 1 | 28 | 14847667 | 14847640 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7029150 | 7029150 | PRJNA680334_S_NODE_8386_length_330_cov_34.313131_g7900_i0 | PRJNA680334 | 8386 | 330 | 34.313131 | 113.2333323 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g7900 | i0 | 100 | 0.0848484848484849 | 28 | 0 | 8 | 0 | 235 | 262 | 8953149 | 8953122 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9578990 | 9578990 | PRJNA680334_S_NODE_79828_length_165_cov_2.840909_g79342_i0 | PRJNA680334 | 79828 | 165 | 2.840909 | 4.68749985 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g79342 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 73 | 100 | 52145647 | 52145674 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10853671 | 10853671 | PRJNA680334_S_NODE_32609_length_219_cov_2.956989_g32123_i0 | PRJNA680334 | 32609 | 219 | 2.956989 | 6.47580591 | Monacha cartusiana | 225461 | Mollusca | Mollusca | 359 | 1.0199999999999999e-94 | NTclustered | gi|2459364560|ref|NC_072058.1| | 225461 | g32123 | i0 | 96.774 | 84.1004566210046 | 217 | 4 | 99 | 1 | 1 | 217 | 1743 | 1530 | Monacha cartusiana mitochondrion, complete genome | blastn | 18418 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Hygromiidae | Monacha | Monacha cartusiana | |
| 19776257 | 19776257 | PRJNA680334_S_NODE_21656_length_248_cov_5.441860_g21170_i0 | PRJNA680334 | 21656 | 248 | 5.44186 | 13.4958128 | Arion hortensis | 145125 | Mollusca | Mollusca | 433 | 6.86e-117 | NTclustered | gi|1336447707|gb|MG856339.1| | 145125 | g21170 | i0 | 100 | 66.6451612903226 | 234 | 0 | 94 | 0 | 1 | 234 | 211 | 444 | Arion hortensis isolate Asp16UCLA01 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 16528 | 433 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Arionidae | Arion | Arion hortensis | |
| 22846573 | 22846573 | PRJNA680334_S_NODE_106018_length_150_cov_51.521368_g105532_i0 | PRJNA680334 | 106018 | 150 | 51.521368 | 77.282052 | Metazoa | 33208 | Mollusca | Mollusca | 60.2 | 7.3e-5 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g105532 | i0 | 80.22 | 11.1266666666667 | 91 | 9 | 59 | 9 | 62 | 150 | 1588459 | 1588542 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 1669 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 31199140 | 31199140 | PRJNA680334_S_NODE_66815_length_175_cov_2.084507_g66329_i0 | PRJNA680334 | 66815 | 175 | 2.084507 | 3.64788725 | Metazoa | 33208 | Mollusca | Mollusca | 103 | 1.62e-25 | NR | CAG2192087.1 | 6550 | g66329 | i0 | 86.4 | 25.1828571428571 | 59 | 7 | 99.4 | 1 | 1 | 174 | 167 | 225 | CAG2192087.1 RP-S14e [Mytilus edulis] | diamond | 4407 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
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);;