contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA492406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8105749 | 8105749 | PRJNA492406_P_NODE_28587_length_247_cov_1.356322_g28288_i0 | PRJNA492406 | 28587 | 247 | 1.356322 | 3.35011534 | Argopecten irradians | 31199 | Mollusca | Mollusca | 457 | 4.05e-124 | NTclustered | gi|2835323525|ref|XM_069253663.1| | 31199 | g28288 | i0 | 100 | 2 | 247 | 0 | 100 | 0 | 1 | 247 | 262 | 508 | PREDICTED: Argopecten irradians arginine kinase-like (LOC138312962), mRNA | blastn | 494 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 9380426 | 9380426 | PRJNA492406_P_NODE_26768_length_251_cov_0.865169_g26469_i0 | PRJNA492406 | 26768 | 251 | 0.865169 | 2.17157419 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 154 | 6.06e-33 | NTclustered | gi|2034304185|ref|XM_041493351.1| | 1735272 | g26469 | i0 | 81.347 | 79.7848605577689 | 193 | 33 | 76 | 3 | 60 | 251 | 3413 | 3223 | PREDICTED: Gigantopelta aegis pre-mRNA-processing-splicing factor 8 (LOC121368612), mRNA | blastn | 20026 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 11931254 | 11931254 | PRJNA492406_P_NODE_30450_length_244_cov_0.900585_g30151_i0 | PRJNA492406 | 30450 | 244 | 0.900585 | 2.1974274 | Argopecten irradians | 31199 | Mollusca | Mollusca | 451 | 1.86e-122 | NTclustered | gi|2835403944|ref|XM_069277307.1| | 31199 | g30151 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 5481 | 5238 | PREDICTED: Argopecten irradians AP-2 complex subunit alpha-2-like (LOC138329989), mRNA | blastn | 244 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 15755046 | 15755046 | PRJNA492406_P_NODE_20073_length_283_cov_1.385714_g19774_i0 | PRJNA492406 | 20073 | 283 | 1.385714 | 3.92157062 | Argopecten irradians | 31199 | Mollusca | Mollusca | 523 | 4.5999999999999983e-144 | NTclustered | gi|2835382781|ref|XM_069266006.1| | 31199 | g19774 | i0 | 100 | 24.6183745583039 | 283 | 0 | 100 | 0 | 1 | 283 | 391 | 109 | PREDICTED: Argopecten irradians small ribosomal subunit protein uS13 (LOC138321958), mRNA | blastn | 6967 | 523 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 17029702 | 17029702 | PRJNA492406_P_NODE_19714_length_285_cov_1.132075_g19415_i0 | PRJNA492406 | 19714 | 285 | 1.132075 | 3.22641375 | Argopecten irradians | 31199 | Mollusca | Mollusca | 527 | 3.59e-145 | NTclustered | gi|2835381844|ref|XM_069265495.1| | 31199 | g19415 | i0 | 100 | 1 | 285 | 0 | 100 | 0 | 1 | 285 | 1880 | 2164 | PREDICTED: Argopecten irradians fibril-forming collagen alpha chain-like (LOC138321663), mRNA | blastn | 285 | 527 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 25325407 | 25325407 | PRJNA492406_P_NODE_18620_length_289_cov_3.962963_g18321_i0 | PRJNA492406 | 18620 | 289 | 3.962963 | 11.45296307 | Argopecten | 31198 | Mollusca | Mollusca | 534 | 2.18e-147 | NTclustered | gi|2835321405|ref|XR_011206645.1| | 31199 | g18321 | i0 | 100 | 100.242214532872 | 289 | 0 | 100 | 0 | 1 | 289 | 739 | 451 | PREDICTED: Argopecten irradians large subunit ribosomal RNA (LOC138311412), rRNA | blastn | 28970 | 534 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians |
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);;