contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA495391" and tax_phylum = "Oomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 476965 | 476965 | PRJNA495391_S_NODE_56861_length_165_cov_1.530769_g55809_i0 | PRJNA495391 | 56861 | 165 | 1.530769 | 2.52576885 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 2.82e-39 | NTclustered | gi|301098172|ref|XM_002898134.1| | 403677 | g55809 | i0 | 100 | 0.56969696969697 | 94 | 0 | 57 | 0 | 72 | 165 | 14271 | 14178 | Phytophthora infestans T30-4 dynein heavy chain, outer arm (PITG_15967), partial mRNA | blastn | 94 | 174 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 1751167 | 1751167 | PRJNA495391_S_NODE_31042_length_218_cov_1.327869_g29990_i0 | PRJNA495391 | 31042 | 218 | 1.327869 | 2.89475442 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1e-104 | NTclustered | gi|325195136|emb|FR825930.1| | 890382 | g29990 | i0 | 99.083 | 16.4128440366972 | 218 | 2 | 100 | 0 | 1 | 218 | 228 | 11 | Albugo laibachii Nc14, genomic contig CONTIG_2990_NC14_v4_499_54 | blastn | 3578 | 392 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 4935572 | 4935572 | PRJNA495391_S_NODE_41204_length_191_cov_1.961538_g40152_i0 | PRJNA495391 | 41204 | 191 | 1.961538 | 3.74653758 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.04e-31 | NTclustered | gi|325180604|emb|FR824053.1| | 890382 | g40152 | i0 | 88.525 | 1.27748691099476 | 122 | 14 | 64 | 0 | 1 | 122 | 118982 | 118861 | Albugo laibachii Nc14, genomic contig CONTIG_8_NC14_v4_238846_215 | blastn | 244 | 148 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7485150 | 7485150 | PRJNA495391_S_NODE_18706_length_277_cov_2.061983_g17654_i0 | PRJNA495391 | 18706 | 277 | 2.061983 | 5.71169291 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 6.560000000000001e-58 | NTclustered | gi|325186025|emb|FR824142.1| | 890382 | g17654 | i0 | 82.31 | 4 | 277 | 46 | 99 | 3 | 1 | 276 | 75792 | 75518 | Albugo laibachii Nc14, genomic contig CONTIG_97_NC14_v4_80307_117 | blastn | 1108 | 237 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 11310228 | 11310228 | PRJNA495391_S_NODE_18189_length_281_cov_1.764228_g17137_i0 | PRJNA495391 | 18189 | 281 | 1.764228 | 4.95748068 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.4e-74 | NTclustered | gi|325180604|emb|FR824053.1| | 890382 | g17137 | i0 | 86.245 | 2.12099644128114 | 269 | 37 | 96 | 0 | 1 | 269 | 118410 | 118678 | Albugo laibachii Nc14, genomic contig CONTIG_8_NC14_v4_238846_215 | blastn | 596 | 292 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 15135422 | 15135422 | PRJNA495391_S_NODE_38412_length_197_cov_2.438272_g37360_i0 | PRJNA495391 | 38412 | 197 | 2.438272 | 4.80339584 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 2.0099999999999997e-66 | NTclustered | gi|325180604|emb|FR824053.1| | 890382 | g37360 | i0 | 90.863 | 2.24873096446701 | 197 | 18 | 100 | 0 | 1 | 197 | 117987 | 117791 | Albugo laibachii Nc14, genomic contig CONTIG_8_NC14_v4_238846_215 | blastn | 443 | 265 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 15778622 | 15778622 | PRJNA495391_S_NODE_22373_length_254_cov_1.771689_g21321_i0 | PRJNA495391 | 22373 | 254 | 1.771689 | 4.50009006 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 7.669999999999999e-57 | NTclustered | gi|325194646|emb|FR825458.1| | 890382 | g21321 | i0 | 86.73 | 2.29527559055118 | 211 | 26 | 83 | 2 | 1 | 210 | 262 | 53 | Albugo laibachii Nc14, genomic contig CONTIG_2303_NC14_v4_894_25 | blastn | 583 | 233 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 17054285 | 17054285 | PRJNA495391_S_NODE_59114_length_162_cov_1.921260_g58062_i0 | PRJNA495391 | 59114 | 162 | 1.92126 | 3.1124412 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 4.45e-62 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g58062 | i0 | 94.479 | 83.4814814814815 | 163 | 8 | 100 | 1 | 1 | 162 | 275 | 113 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 13524 | 250 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 18327564 | 18327564 | PRJNA495391_S_NODE_19195_length_273_cov_10.508403_g18143_i0 | PRJNA495391 | 19195 | 273 | 10.508403 | 28.68794019 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 503 | 5.76e-138 | NTclustered | gi|380865879|gb|JQ277732.1| | 65357 | g18143 | i0 | 100 | 96.9267399267399 | 272 | 0 | 99 | 0 | 2 | 273 | 1315 | 1044 | Albugo candida strain TT1958 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 26461 | 503 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida |
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);;