contig_metadata
11 rows where bioproject = "PRJNA492280", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1726596 | 1726596 | PRJNA492280_P_NODE_11002_length_165_cov_4.390625_g10895_i0 | PRJNA492280 | 11002 | 165 | 4.390625 | 7.24453125 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 6.2e-26 | NTclustered | gi|1378159297|ref|XM_024728901.1| | 4781 | g10895 | i0 | 97.368 | 5.17575757575758 | 76 | 2 | 46 | 0 | 1 | 76 | 148 | 73 | Plasmopara halstedii uncharacterized protein (PHALS_13197), partial mRNA | blastn | 854 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 1726619 | 1726619 | PRJNA492280_P_NODE_1302_length_387_cov_4.665714_g1202_i0 | PRJNA492280 | 1302 | 387 | 4.665714 | 18.05631318 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.7799999999999996e-23 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g1202 | i0 | 89.691 | 21.71834625323 | 97 | 9 | 25 | 1 | 165 | 260 | 41766 | 41670 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 8405 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 1726916 | 1726916 | PRJNA492280_P_NODE_962_length_448_cov_4.328467_g865_i0 | PRJNA492280 | 962 | 448 | 4.328467 | 19.39153216 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 8.499999999999998e-69 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g865 | i0 | 93.085 | 1.10267857142857 | 188 | 11 | 87 | 2 | 259 | 446 | 935 | 1120 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 494 | 274 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 8105100 | 8105100 | PRJNA492280_P_NODE_24207_length_164_cov_2.700787_g24100_i0 | PRJNA492280 | 24207 | 164 | 2.700787 | 4.42929068 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.32e-27 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g24100 | i0 | 100 | 83.9024390243902 | 73 | 0 | 88 | 0 | 4 | 76 | 828 | 756 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 13760 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 11302056 | 11302056 | PRJNA492280_P_NODE_18749_length_164_cov_3.543307_g18642_i0 | PRJNA492280 | 18749 | 164 | 3.543307 | 5.81102348 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 2.84e-29 | NTclustered | gi|33520229|gb|AY273974.1| | 162125 | g18642 | i0 | 100 | 87.969512195122 | 76 | 0 | 89 | 0 | 89 | 164 | 129 | 204 | Hyaloperonospora brassicae large subunit ribosomal RNA gene, partial sequence | blastn | 14427 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 14480467 | 14480467 | PRJNA492280_P_NODE_10092_length_169_cov_5.227273_g9985_i0 | PRJNA492280 | 10092 | 169 | 5.227273 | 8.83409137 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 9.95e-69 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g9985 | i0 | 96.914 | 1.55029585798817 | 162 | 5 | 96 | 0 | 5 | 166 | 1368 | 1207 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 262 | 272 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 14480558 | 14480558 | PRJNA492280_P_NODE_21692_length_164_cov_3.023622_g21585_i0 | PRJNA492280 | 21692 | 164 | 3.023622 | 4.95874008 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1e-43 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g21585 | i0 | 84.884 | 1.04878048780488 | 172 | 16 | 100 | 3 | 1 | 164 | 344 | 513 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 172 | 189 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 27487192 | 27487192 | PRJNA492280_P_NODE_17063_length_164_cov_3.937008_g16956_i0 | PRJNA492280 | 17063 | 164 | 3.937008 | 6.45669312 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0115 | NR | OWZ01316.1 | 4795 | g16956 | i0 | 33.3 | 1.09756097560976 | 60 | 33 | 97 | 1 | 4 | 162 | 101 | 160 | OWZ01316.1 hypothetical protein PHMEG_00027324 [Phytophthora megakarya] | diamond | 180 | 42.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 29366125 | 29366125 | PRJNA492280_P_NODE_7029_length_197_cov_3.075000_g6922_i0 | PRJNA492280 | 7029 | 197 | 3.075 | 6.05775 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 5.42e-24 | NR | KAG1694345.1 | 4784 | g6922 | i0 | 70.4 | 3.24365482233503 | 71 | 15 | 99 | 1 | 195 | 1 | 64 | 134 | KAG1694345.1 40S ribosomal protein S4 [Phytophthora capsici] | diamond | 639 | 99.8 | 0.991983967935872 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 30487216 | 30487216 | PRJNA492280_P_NODE_10793_length_165_cov_7.125000_g10686_i0 | PRJNA492280 | 10793 | 165 | 7.125 | 11.75625 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 4.38e-20 | NR | XP_012196500.1 | 695850 | g10686 | i0 | 77.4 | 6.72727272727273 | 53 | 12 | 96.4 | 0 | 161 | 3 | 40 | 92 | XP_012196500.1 60S ribosomal protein L31 [Saprolegnia parasitica CBS 223.65] | diamond | 1110 | 86.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 32747501 | 32747501 | PRJNA492280_P_NODE_22760_length_164_cov_2.897638_g22653_i0 | PRJNA492280 | 22760 | 164 | 2.897638 | 4.75212632 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 6.35e-8 | NR | XP_024582876.1 | 4781 | g22653 | i0 | 50 | 21.1463414634146 | 68 | 20 | 98.8 | 1 | 163 | 2 | 677 | 744 | XP_024582876.1 cellulose synthase 3 [Plasmopara halstedii] | diamond | 3468 | 57.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii |
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);;