contig_metadata
17 rows where bioproject = "PRJNA407368", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 414948 | 414948 | PRJNA407368_S_NODE_1081_length_606_cov_4.305026_g1004_i0 | PRJNA407368 | 1081 | 606 | 4.305026 | 26.08845756 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 3.03e-124 | NTclustered | gi|166047342|emb|CU360000.1| | 100861 | g1004 | i0 | 88.8 | 23.7227722772277 | 375 | 40 | 96 | 2 | 1 | 373 | 432 | 58 | Aphanomyces euteiches cDNA | blastn | 14376 | 459 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 1690007 | 1690007 | PRJNA407368_S_NODE_8002_length_181_cov_3.072368_g7900_i0 | PRJNA407368 | 8002 | 181 | 3.072368 | 5.56098608 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 7e-16 | NTclustered | gi|166039189|emb|CU355239.1| | 100861 | g7900 | i0 | 90.411 | 8.67403314917127 | 73 | 7 | 40 | 0 | 70 | 142 | 744 | 672 | Aphanomyces euteiches cDNA | blastn | 1570 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 7459688 | 7459688 | PRJNA407368_S_NODE_9746_length_159_cov_2.700000_g9644_i0 | PRJNA407368 | 9746 | 159 | 2.7 | 4.293 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 3.39e-58 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g9644 | i0 | 94.231 | 103.578616352201 | 156 | 8 | 97 | 1 | 1 | 155 | 2364 | 2209 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 16469 | 237 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8068430 | 8068430 | PRJNA407368_S_NODE_6007_length_219_cov_187.831579_g5905_i0 | PRJNA407368 | 6007 | 219 | 187.831579 | 411.35115801 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 6.09e-97 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g5905 | i0 | 96.804 | 80.3196347031963 | 219 | 7 | 100 | 0 | 1 | 219 | 2055 | 2273 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 17590 | 366 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8734553 | 8734553 | PRJNA407368_S_NODE_6987_length_198_cov_22.899408_g6885_i0 | PRJNA407368 | 6987 | 198 | 22.899408 | 45.34082784 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 2.53e-90 | NTclustered | gi|166048041|emb|CU364162.1| | 100861 | g6885 | i0 | 100 | 93 | 186 | 0 | 94 | 0 | 1 | 186 | 273 | 458 | Aphanomyces euteiches cDNA | blastn | 18414 | 344 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9343307 | 9343307 | PRJNA407368_S_NODE_6808_length_202_cov_4.248555_g6706_i0 | PRJNA407368 | 6808 | 202 | 4.248555 | 8.5820811 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 7.31e-81 | NTclustered | gi|166038792|emb|CU355022.1| | 100861 | g6706 | i0 | 94.554 | 24.3069306930693 | 202 | 11 | 100 | 0 | 1 | 202 | 210 | 411 | Aphanomyces euteiches cDNA | blastn | 4910 | 313 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 11894012 | 11894012 | PRJNA407368_S_NODE_8810_length_170_cov_16.695035_g8708_i0 | PRJNA407368 | 8810 | 170 | 16.695035 | 28.3815595 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 9.999999999999999e-69 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g8708 | i0 | 95.833 | 81.5647058823529 | 168 | 7 | 99 | 0 | 1 | 168 | 1918 | 2085 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 13866 | 272 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13168802 | 13168802 | PRJNA407368_S_NODE_2291_length_405_cov_75.486702_g2190_i0 | PRJNA407368 | 2291 | 405 | 75.486702 | 305.7211431 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 9.44e-98 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g2190 | i0 | 95.652 | 57.7283950617284 | 230 | 10 | 57 | 0 | 19 | 248 | 329 | 100 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 23380 | 370 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 13168841 | 13168841 | PRJNA407368_S_NODE_4071_length_286_cov_123.443580_g3969_i0 | PRJNA407368 | 4071 | 286 | 123.44358 | 353.0486388 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.73e-120 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g3969 | i0 | 96.992 | 93.2552447552448 | 266 | 5 | 100 | 1 | 24 | 286 | 561 | 826 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 26671 | 444 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 14443997 | 14443997 | PRJNA407368_S_NODE_3352_length_322_cov_3.208191_g3250_i0 | PRJNA407368 | 3352 | 322 | 3.208191 | 10.33037502 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.47e-149 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g3250 | i0 | 96.914 | 104.350931677019 | 324 | 8 | 100 | 2 | 1 | 322 | 2682 | 2359 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 33601 | 542 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 14444026 | 14444026 | PRJNA407368_S_NODE_5072_length_246_cov_13.405530_g4970_i0 | PRJNA407368 | 5072 | 246 | 13.40553 | 32.9776038 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 5.599999999999999e-73 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g4970 | i0 | 90.135 | 68.9552845528455 | 223 | 18 | 90 | 4 | 19 | 239 | 1448 | 1668 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 16963 | 287 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 18266662 | 18266662 | PRJNA407368_S_NODE_3175_length_331_cov_105.761589_g3073_i0 | PRJNA407368 | 3175 | 331 | 105.761589 | 350.07085959 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 7.58e-98 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g3073 | i0 | 95.652 | 70.6344410876133 | 230 | 10 | 69 | 0 | 84 | 313 | 100 | 329 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 23380 | 370 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 19540825 | 19540825 | PRJNA407368_S_NODE_3176_length_331_cov_105.112583_g3074_i0 | PRJNA407368 | 3176 | 331 | 105.112583 | 347.92264973 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 7.58e-98 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g3074 | i0 | 95.652 | 70.6344410876133 | 230 | 10 | 69 | 0 | 84 | 313 | 100 | 329 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 23380 | 370 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 19540847 | 19540847 | PRJNA407368_S_NODE_4056_length_287_cov_57.399225_g3954_i0 | PRJNA407368 | 4056 | 287 | 57.399225 | 164.73577575 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 1.13e-65 | NTclustered | gi|166038860|emb|CU355090.1| | 100861 | g3954 | i0 | 88.393 | 1855.27177700348 | 224 | 19 | 78 | 4 | 1 | 224 | 425 | 209 | Aphanomyces euteiches cDNA | blastn | 532463 | 263 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22758663 | 22758663 | PRJNA407368_S_NODE_6638_length_205_cov_11.522727_g6536_i0 | PRJNA407368 | 6638 | 205 | 11.522727 | 23.62159035 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 7.279999999999998e-96 | NTclustered | gi|166051677|emb|CU353805.1| | 100861 | g6536 | i0 | 98.537 | 98.0439024390244 | 205 | 3 | 100 | 0 | 1 | 205 | 85 | 289 | Aphanomyces euteiches cDNA | blastn | 20099 | 363 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 23367221 | 23367221 | PRJNA407368_S_NODE_7279_length_193_cov_19.597561_g7177_i0 | PRJNA407368 | 7279 | 193 | 19.597561 | 37.82329273 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.46e-92 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g7177 | i0 | 99.485 | 100.243523316062 | 194 | 0 | 100 | 1 | 1 | 193 | 1854 | 1661 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 19347 | 351 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31212456 | 31212456 | PRJNA407368_S_NODE_2035_length_434_cov_3.797531_g1935_i0 | PRJNA407368 | 2035 | 434 | 3.797531 | 16.48128454 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 5.9e-4 | NR | GLD98057.1 | 114742 | g1935 | i0 | 42.3 | 1.6036866359447 | 52 | 30 | 35.9 | 0 | 246 | 91 | 1 | 52 | GLD98057.1 hypothetical protein PINS_up006754 [Pythium insidiosum] | diamond | 696 | 47.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum |
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);;