contig_metadata
11 rows where bioproject = "PRJNA846086" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3383643 | 3383643 | PRJNA846086_P_NODE_2003_length_281_cov_1.480769_g1937_i0 | PRJNA846086 | 2003 | 281 | 1.480769 | 4.16096089 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 520 | 5.909999999999999e-143 | NTclustered | gi|166048041|emb|CU364162.1| | 100861 | g1937 | i0 | 100 | 99.3487544483986 | 281 | 0 | 100 | 0 | 1 | 281 | 525 | 245 | Aphanomyces euteiches cDNA | blastn | 27917 | 520 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 3383703 | 3383703 | PRJNA846086_P_NODE_5603_length_241_cov_0.916667_g5537_i0 | PRJNA846086 | 5603 | 241 | 0.916667 | 2.20916747 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 3.199999999999999e-90 | NTclustered | gi|166035484|emb|CU354363.1| | 100861 | g5537 | i0 | 92.531 | 100 | 241 | 17 | 100 | 1 | 1 | 241 | 788 | 549 | Aphanomyces euteiches cDNA | blastn | 24100 | 344 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 7211001 | 7211001 | PRJNA846086_P_NODE_4246_length_246_cov_0.890173_g4180_i0 | PRJNA846086 | 4246 | 246 | 0.890173 | 2.18982558 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4599999999999996e-118 | NTclustered | gi|166044546|emb|CU367455.1| | 100861 | g4180 | i0 | 98.78 | 49.5569105691057 | 246 | 3 | 100 | 0 | 1 | 246 | 125 | 370 | Aphanomyces euteiches cDNA | blastn | 12191 | 438 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 7211017 | 7211017 | PRJNA846086_P_NODE_5126_length_243_cov_0.905882_g5060_i0 | PRJNA846086 | 5126 | 243 | 0.905882 | 2.20129326 | Cafeteria roenbergensis | 33653 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 1.25e-36 | NR | KAA0157737.1 | 33653 | g5060 | i0 | 75 | 18.7530864197531 | 80 | 20 | 98.8 | 0 | 242 | 3 | 36 | 115 | KAA0157737.1 hypothetical protein FNF29_00311 [Cafeteria roenbergensis] | diamond | 4557 | 133 | 1 | Eukaryota | Sar | Bigyra | Bicosoecida | Cafeteriaceae | Cafeteria | Cafeteria roenbergensis | |||
| 9760881 | 9760881 | PRJNA846086_P_NODE_1588_length_301_cov_1.350877_g1522_i0 | PRJNA846086 | 1588 | 301 | 1.350877 | 4.06613977 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 2.47e-92 | NTclustered | gi|673023095|ref|XM_008867287.1| | 157072 | g1522 | i0 | 92.946 | 8.48837209302326 | 241 | 17 | 80 | 0 | 61 | 301 | 453 | 213 | Aphanomyces invadans 40S ribosomal protein S15 partial mRNA | blastn | 2555 | 351 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 17411055 | 17411055 | PRJNA846086_P_NODE_3534_length_249_cov_0.875000_g3468_i0 | PRJNA846086 | 3534 | 249 | 0.875 | 2.17875 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.18e-120 | NTclustered | gi|166046515|emb|CU367632.1| | 100861 | g3468 | i0 | 98.795 | 100.128514056225 | 249 | 3 | 100 | 0 | 1 | 249 | 324 | 76 | Aphanomyces euteiches cDNA | blastn | 24932 | 444 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27086420 | 27086420 | PRJNA846086_P_NODE_4002_length_247_cov_0.885057_g3936_i0 | PRJNA846086 | 4002 | 247 | 0.885057 | 2.18609079 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.7100000000000002e-36 | NR | KAF0720303.1 | 120398 | g3936 | i0 | 75.6 | 4.97975708502024 | 82 | 20 | 99.6 | 0 | 247 | 2 | 112 | 193 | KAF0720303.1 hypothetical protein As57867_000421 [Aphanomyces stellatus] | diamond | 1230 | 135 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27117730 | 27117730 | PRJNA846086_P_NODE_4522_length_245_cov_0.895349_g4456_i0 | PRJNA846086 | 4522 | 245 | 0.895349 | 2.19360505 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 2.8e-35 | NR | KAJ1414928.1 | 483371 | g4456 | i0 | 80.2 | 0.991836734693878 | 81 | 16 | 99.2 | 0 | 243 | 1 | 165 | 245 | KAJ1414928.1 ribosomal protein L4 domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 243 | 133 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31002690 | 31002690 | PRJNA846086_P_NODE_1714_length_291_cov_1.440367_g1648_i0 | PRJNA846086 | 1714 | 291 | 1.440367 | 4.19146797 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 164 | 2.12e-49 | NR | KAJ1424879.1 | 483371 | g1648 | i0 | 84 | 0.969072164948454 | 94 | 15 | 96.9 | 0 | 8 | 289 | 22 | 115 | KAJ1424879.1 ribosomal L18ae/LX protein domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 282 | 164 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31729777 | 31729777 | PRJNA846086_P_NODE_4537_length_245_cov_0.895349_g4471_i0 | PRJNA846086 | 4537 | 245 | 0.895349 | 2.19360505 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 3.04e-8 | NR | KAG9416249.1 | 112091 | g4471 | i0 | 57.4 | 1.33469387755102 | 54 | 19 | 61.2 | 2 | 95 | 244 | 20 | 73 | KAG9416249.1 hypothetical protein AC1031_000646 [Aphanomyces cochlioides] | diamond | 327 | 57.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 32014571 | 32014571 | PRJNA846086_P_NODE_2858_length_256_cov_1.683060_g2792_i0 | PRJNA846086 | 2858 | 256 | 1.68306 | 4.3086336 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 2.399999999999999e-38 | NR | XP_008862620.1 | 157072 | g2792 | i0 | 82.4 | 1.9921875 | 85 | 15 | 99.6 | 0 | 256 | 2 | 282 | 366 | XP_008862620.1 hypothetical protein H310_01322 [Aphanomyces invadans] | diamond | 510 | 142 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans |
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);;