contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1087264" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4020672 | 4020672 | PRJNA1087264_P_NODE_4084_length_322_cov_1.681319_g4002_i0 | PRJNA1087264 | 4084 | 322 | 1.681319 | 5.41384718 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 2.26e-28 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g4002 | i0 | 85.401 | 41.8074534161491 | 137 | 16 | 42 | 4 | 67 | 201 | 41659 | 41793 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 13462 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 5296834 | 5296834 | PRJNA1087264_P_NODE_2185_length_455_cov_2.522167_g2104_i0 | PRJNA1087264 | 2185 | 455 | 2.522167 | 11.47585985 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 2.3999999999999996e-69 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g2104 | i0 | 80.267 | 74.3472527472528 | 375 | 66 | 81 | 6 | 11 | 378 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 276 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 5296857 | 5296857 | PRJNA1087264_P_NODE_4265_length_315_cov_1.853383_g4183_i0 | PRJNA1087264 | 4265 | 315 | 1.853383 | 5.83815645 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 2.65e-77 | NTclustered | gi|1219685856|gb|KY965925.1| | 1440116 | g4183 | i0 | 85.616 | 84.968253968254 | 292 | 36 | 92 | 6 | 25 | 313 | 737 | 449 | Lagenidium giganteum f. caninum isolate UF15-01 heat shock protein 90 (hsp90) gene, partial cds | blastn | 26765 | 302 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 9121630 | 9121630 | PRJNA1087264_P_NODE_1408_length_564_cov_1.598058_g1332_i0 | PRJNA1087264 | 1408 | 564 | 1.598058 | 9.01304712 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 726 | 0 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g1332 | i0 | 99.012 | 72.5372340425532 | 405 | 4 | 72 | 0 | 1 | 405 | 532 | 936 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 40911 | 726 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 16771023 | 16771023 | PRJNA1087264_P_NODE_3194_length_369_cov_2.146875_g3113_i0 | PRJNA1087264 | 3194 | 369 | 2.146875 | 7.92196875 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 612 | 1.2799999999999999e-170 | NTclustered | gi|325194684|emb|FR825494.1| | 890382 | g3113 | i0 | 95.664 | 78.10027100271 | 369 | 16 | 100 | 0 | 1 | 369 | 376 | 8 | Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331 | blastn | 28819 | 612 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 16771048 | 16771048 | PRJNA1087264_P_NODE_5754_length_266_cov_1.663594_g5672_i0 | PRJNA1087264 | 5754 | 266 | 1.663594 | 4.42516004 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 5.629999999999999e-133 | NTclustered | gi|345019155|gb|JF504671.1| | 65357 | g5672 | i0 | 99.624 | 100.172932330827 | 266 | 1 | 100 | 0 | 1 | 266 | 532 | 797 | Albugo candida isolate ALC_1 small subunit ribosomal RNA gene, partial sequence | blastn | 26646 | 486 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 18869067 | 18869067 | PRJNA1087264_P_NODE_14515_length_167_cov_0.864407_g14433_i0 | PRJNA1087264 | 14515 | 167 | 0.864407 | 1.44355969 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 4.86e-27 | NTclustered | gi|325189941|emb|FR824284.1| | 890382 | g14433 | i0 | 88.288 | 7.1437125748503 | 111 | 13 | 66 | 0 | 1 | 111 | 21135 | 21025 | Albugo laibachii Nc14, genomic contig CONTIG_239_NC14_v4_40788_246 | blastn | 1193 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 21419469 | 21419469 | PRJNA1087264_P_NODE_6257_length_254_cov_3.512195_g6175_i0 | PRJNA1087264 | 6257 | 254 | 3.512195 | 8.9209753 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 464 | 2.4999999999999994e-126 | NTclustered | gi|575498660|gb|KF853245.1| | 65357 | g6175 | i0 | 99.606 | 99.6181102362205 | 254 | 1 | 100 | 0 | 1 | 254 | 398 | 145 | Albugo candida strain ACCS 18S ribosomal RNA gene, partial sequence | blastn | 25303 | 464 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 23146202 | 23146202 | PRJNA1087264_P_NODE_13719_length_170_cov_0.958678_g13637_i0 | PRJNA1087264 | 13719 | 170 | 0.958678 | 1.6297526 | Globisporangium paroecandrum | 2125995 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 1.74e-41 | NTclustered | gi|299777539|gb|GU071882.1| | 2125995 | g13637 | i0 | 86.228 | 27.4058823529412 | 167 | 23 | 98 | 0 | 4 | 170 | 197 | 31 | Pythium paroecandrum strain PPRI8611 beta-tubulin gene, partial cds | blastn | 4659 | 182 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium paroecandrum | ||
| 24419885 | 24419885 | PRJNA1087264_P_NODE_2640_length_410_cov_1.204986_g2559_i0 | PRJNA1087264 | 2640 | 410 | 1.204986 | 4.9404426 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 9.5e-103 | NTclustered | gi|166038052|emb|CU349720.1| | 100861 | g2559 | i0 | 84.518 | 90.7170731707317 | 394 | 57 | 96 | 4 | 15 | 406 | 461 | 70 | Aphanomyces euteiches cDNA | blastn | 37194 | 387 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 24419920 | 24419920 | PRJNA1087264_P_NODE_6440_length_250_cov_1.880597_g6358_i0 | PRJNA1087264 | 6440 | 250 | 1.880597 | 4.7014925 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 462 | 8.83e-126 | NTclustered | gi|67090790|gb|DQ007482.1| | 65357 | g6358 | i0 | 100 | 99.82 | 250 | 0 | 100 | 0 | 1 | 250 | 23 | 272 | Albugo candida isolate AR283 large subunit ribosomal RNA gene, partial sequence | blastn | 24955 | 462 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 24419935 | 24419935 | PRJNA1087264_P_NODE_7800_length_225_cov_1.698864_g7718_i0 | PRJNA1087264 | 7800 | 225 | 1.698864 | 3.822444 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|675193056|ref|XM_008907165.1| | 761204 | g7718 | i0 | 100 | 0.133333333333333 | 30 | 0 | 13 | 0 | 54 | 83 | 353 | 382 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae |
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);;