contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA950981" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 933887 | 933887 | PRJNA950981_P_NODE_5121_length_429_cov_2.662921_g4945_i0 | PRJNA950981 | 5121 | 429 | 2.662921 | 11.42393109 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 2.9600000000000003e-58 | NTclustered | gi|2794921140|ref|XM_067880775.1| | 164328 | g4945 | i0 | 77.251 | 17.3263403263403 | 422 | 86 | 97 | 8 | 8 | 424 | 444 | 28 | Phytophthora ramorum 60S ribosomal protein L19-2 (KRP23_10338), partial mRNA | blastn | 7433 | 239 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 3484506 | 3484506 | PRJNA950981_P_NODE_17343_length_251_cov_0.876404_g17167_i0 | PRJNA950981 | 17343 | 251 | 0.876404 | 2.19977404 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 2.5399999999999994e-106 | NTclustered | gi|166035484|emb|CU354363.1| | 100861 | g17167 | i0 | 95.219 | 100 | 251 | 12 | 100 | 0 | 1 | 251 | 542 | 792 | Aphanomyces euteiches cDNA | blastn | 25100 | 398 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 3814549 | 3814549 | PRJNA950981_P_NODE_18763_length_248_cov_0.891429_g18587_i0 | PRJNA950981 | 18763 | 248 | 0.891429 | 2.21074392 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 1.89e-122 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g18587 | i0 | 99.595 | 100.725806451613 | 247 | 1 | 99 | 0 | 1 | 247 | 475 | 721 | Aphanomyces stellatus strain GF 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 | 24980 | 453 | 0.995584988962472 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 4762234 | 4762234 | PRJNA950981_P_NODE_1064_length_889_cov_2.412990_g931_i0 | PRJNA950981 | 1064 | 889 | 2.41299 | 21.4514811 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 2.24e-77 | NTclustered | gi|695375284|ref|XM_009517214.1| | 67593 | g931 | i0 | 79.717 | 21.4105736782902 | 424 | 82 | 47 | 4 | 272 | 693 | 422 | 1 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 19034 | 303 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 7311902 | 7311902 | PRJNA950981_P_NODE_6186_length_394_cov_1.461059_g6010_i0 | PRJNA950981 | 6186 | 394 | 1.461059 | 5.75657246 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 1.25e-61 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g6010 | i0 | 80.363 | 78.6421319796954 | 331 | 63 | 84 | 2 | 3 | 332 | 914 | 585 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 30985 | 250 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 9861852 | 9861852 | PRJNA950981_P_NODE_14288_length_273_cov_1.025000_g14112_i0 | PRJNA950981 | 14288 | 273 | 1.025 | 2.79825 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 3.5899999999999996e-110 | NTclustered | gi|166048962|emb|CU355871.1| | 100861 | g14112 | i0 | 93.773 | 71.970695970696 | 273 | 17 | 100 | 0 | 1 | 273 | 405 | 677 | Aphanomyces euteiches cDNA | blastn | 19648 | 411 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9861868 | 9861868 | PRJNA950981_P_NODE_18508_length_249_cov_0.886364_g18332_i0 | PRJNA950981 | 18508 | 249 | 0.886364 | 2.20704636 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.53e-93 | NTclustered | gi|673032447|ref|XM_008871963.1| | 157072 | g18332 | i0 | 92.369 | 6.50200803212851 | 249 | 19 | 100 | 0 | 1 | 249 | 156 | 404 | Aphanomyces invadans hypothetical protein mRNA | blastn | 1619 | 355 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 11466285 | 11466285 | PRJNA950981_P_NODE_2669_length_584_cov_3.459883_g2496_i0 | PRJNA950981 | 2669 | 584 | 3.459883 | 20.20571672 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 1.8e-101 | NTclustered | gi|2795036581|ref|XM_067936511.1| | 4785 | g2496 | i0 | 81.838 | 109.823630136986 | 457 | 81 | 78 | 2 | 107 | 562 | 636 | 181 | Phytophthora cinnamomi Adenosylhomocysteinase (IUM83_11919), partial mRNA | blastn | 64137 | 383 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 13687493 | 13687493 | PRJNA950981_P_NODE_16171_length_255_cov_1.714286_g15995_i0 | PRJNA950981 | 16171 | 255 | 1.714286 | 4.3714293 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.75e-61 | NTclustered | gi|673015481|ref|XM_008863480.1| | 157072 | g15995 | i0 | 92.941 | 53.6705882352941 | 170 | 12 | 67 | 0 | 86 | 255 | 401 | 232 | Aphanomyces invadans 60S ribosomal protein L44 mRNA | blastn | 13686 | 248 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 14961687 | 14961687 | PRJNA950981_P_NODE_8232_length_348_cov_2.654545_g8056_i0 | PRJNA950981 | 8232 | 348 | 2.654545 | 9.2378166 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.85e-49 | NTclustered | gi|675204844|ref|XM_008913059.1| | 761204 | g8056 | i0 | 78.378 | 9.35057471264368 | 333 | 64 | 95 | 8 | 1 | 329 | 441 | 113 | Phytophthora parasitica INRA-310 ribosomal protein S4 mRNA | blastn | 3254 | 209 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 15290418 | 15290418 | PRJNA950981_P_NODE_8692_length_341_cov_1.145522_g8516_i0 | PRJNA950981 | 8692 | 341 | 1.145522 | 3.90623002 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 1.36e-70 | NTclustered | gi|695406619|ref|XM_009525862.1| | 67593 | g8516 | i0 | 81.873 | 31.8357771260997 | 331 | 60 | 97 | 0 | 8 | 338 | 950 | 1280 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 10856 | 279 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 16236696 | 16236696 | PRJNA950981_P_NODE_21813_length_242_cov_0.923077_g21637_i0 | PRJNA950981 | 21813 | 242 | 0.923077 | 2.23384634 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 3.23e-85 | NTclustered | gi|673039862|ref|XM_008875670.1| | 157072 | g21637 | i0 | 91.25 | 24.8512396694215 | 240 | 21 | 99 | 0 | 3 | 242 | 396 | 635 | Aphanomyces invadans guanine nucleotide-binding protein subunit beta-like protein mRNA | blastn | 6014 | 327 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 20060499 | 20060499 | PRJNA950981_P_NODE_17416_length_251_cov_0.876404_g17240_i0 | PRJNA950981 | 17416 | 251 | 0.876404 | 2.19977404 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 2.6100000000000006e-86 | NTclustered | gi|166039189|emb|CU355239.1| | 100861 | g17240 | i0 | 90.476 | 34.4501992031873 | 252 | 22 | 100 | 2 | 1 | 251 | 542 | 292 | Aphanomyces euteiches cDNA | blastn | 8647 | 331 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 23886213 | 23886213 | PRJNA950981_P_NODE_19019_length_248_cov_0.891429_g18843_i0 | PRJNA950981 | 19019 | 248 | 0.891429 | 2.21074392 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 3.35e-80 | NTclustered | gi|673052654|ref|XM_008882066.1| | 157072 | g18843 | i0 | 90.598 | 20.6129032258065 | 234 | 22 | 94 | 0 | 1 | 234 | 264 | 31 | Aphanomyces invadans 40S ribosomal protein S15a, variant mRNA | blastn | 5112 | 311 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 23886219 | 23886219 | PRJNA950981_P_NODE_21139_length_243_cov_0.917647_g20963_i0 | PRJNA950981 | 21139 | 243 | 0.917647 | 2.22988221 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 7.44e-42 | NTclustered | gi|698783094|ref|XM_009826289.1| | 112090 | g20963 | i0 | 94.167 | 43.2880658436214 | 120 | 7 | 49 | 0 | 123 | 242 | 498 | 379 | Aphanomyces astaci 40S ribosomal protein S23 mRNA | blastn | 10519 | 183 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 23886226 | 23886226 | PRJNA950981_P_NODE_5599_length_412_cov_2.616519_g5423_i0 | PRJNA950981 | 5599 | 412 | 2.616519 | 10.78005828 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 4.569999999999999e-81 | NTclustered | gi|2795040529|ref|XM_067944818.1| | 4785 | g5423 | i0 | 81.462 | 56.5509708737864 | 383 | 71 | 93 | 0 | 6 | 388 | 10 | 392 | Phytophthora cinnamomi 60S ribosomal protein L23 (IUM83_19754), partial mRNA | blastn | 23299 | 315 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi |
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);;