contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA283169" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5475233 | 5475233 | PRJNA283169_S_NODE_245_length_508_cov_1.906318_g232_i0 | PRJNA283169 | 245 | 508 | 1.906318 | 9.68409544 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 704 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g232 | i0 | 99.483 | 26.2972440944882 | 387 | 2 | 76 | 0 | 122 | 508 | 1238 | 852 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 13359 | 704 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 6749519 | 6749519 | PRJNA283169_S_NODE_586_length_332_cov_1.904594_g572_i0 | PRJNA283169 | 586 | 332 | 1.904594 | 6.32325208 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 2.04e-123 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g572 | i0 | 98.084 | 85.9849397590361 | 261 | 5 | 79 | 0 | 72 | 332 | 5 | 265 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 28547 | 455 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 8025069 | 8025069 | PRJNA283169_P_NODE_6007_length_175_cov_1.174603_g5944_i0 | PRJNA283169 | 6007 | 175 | 1.174603 | 2.05555525 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 1.89e-6 | NTclustered | gi|915125186|ref|XM_013478403.1| | 5804 | g5944 | i0 | 90 | 1.94285714285714 | 50 | 5 | 29 | 0 | 89 | 138 | 1059 | 1108 | Eimeria maxima phosphatidylinositol 3-and 4-kinase domain-containing protein, putative partial mRNA | blastn | 340 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 8711672 | 8711672 | PRJNA283169_S_NODE_1847_length_206_cov_0.267516_g1833_i0 | PRJNA283169 | 1847 | 206 | 0.267516 | 0.55108296 | Ulnaria | 426668 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 3.429999999999999e-89 | NTclustered | gi|187957792|emb|AM497727.1| | 426669 | g1833 | i0 | 100 | 89.3203883495146 | 184 | 0 | 89 | 0 | 12 | 195 | 1613 | 1430 | Synedra ulna 18S rRNA gene, strain AtFULN1 | blastn | 18400 | 340 | 1 | Eukaryota | Sar | Bacillariophyta | Fragilariophyceae | Licmophorales | Ulnariaceae | Ulnaria | Ulnaria ulna | ||
| 8711675 | 8711675 | PRJNA283169_S_NODE_3267_length_164_cov_0.191304_g3253_i0 | PRJNA283169 | 3267 | 164 | 0.191304 | 0.31373856 | Naviculales | 38748 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 2.72e-59 | NTclustered | gi|146762526|gb|EF553458.1| | 2850 | g3253 | i0 | 94.268 | 94.8963414634146 | 157 | 9 | 96 | 0 | 1 | 157 | 3912 | 4068 | Phaeodactylum tricornutum strain CCAP 1055/1 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 | 15563 | 241 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 10575774 | 10575774 | PRJNA283169_S_NODE_1249_length_242_cov_1.808290_g1235_i0 | PRJNA283169 | 1249 | 242 | 1.80829 | 4.3760618 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 5.1499999999999985e-118 | NTclustered | gi|53829589|gb|AY582847.1| | 289359 | g1235 | i0 | 99.174 | 89.6611570247934 | 242 | 2 | 100 | 0 | 1 | 242 | 395 | 636 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds | blastn | 21698 | 436 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 14400744 | 14400744 | PRJNA283169_P_NODE_2512_length_260_cov_2.862559_g2450_i0 | PRJNA283169 | 2512 | 260 | 2.862559 | 7.4426534 | Lembadion sp. FG-2015 | 1607877 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 2.7e-91 | NTclustered | gi|759083556|gb|KM222173.1| | 1607877 | g2450 | i0 | 98.969 | 73.0153846153846 | 194 | 2 | 75 | 0 | 45 | 238 | 370 | 177 | Lembadion sp. FG-2015 voucher FYB2013031305 large subunit ribosomal RNA gene, partial sequence | blastn | 18984 | 348 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Lembadionidae | Lembadion | Lembadion sp. FG-2015 | ||
| 14400755 | 14400755 | PRJNA283169_P_NODE_3132_length_234_cov_1.891892_g3069_i0 | PRJNA283169 | 3132 | 234 | 1.891892 | 4.42702728 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|156101218|ref|XM_001616253.1| | 5855 | g3069 | i0 | 100 | 0.11965811965812 | 28 | 0 | 12 | 0 | 69 | 96 | 1305 | 1332 | Plasmodium vivax transmembrane amino acid transporter protein, putative (PVX_114575), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 15086600 | 15086600 | PRJNA283169_P_NODE_3812_length_214_cov_0.878788_g3749_i0 | PRJNA283169 | 3812 | 214 | 0.878788 | 1.88060632 | Lembadion | 54107 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 7.83e-81 | NTclustered | gi|7839503|gb|AF255358.1| | 54108 | g3749 | i0 | 98.857 | 83.3271028037383 | 175 | 2 | 100 | 0 | 1 | 175 | 373 | 199 | Lembadion bullinum small subunit ribosomal RNA gene, partial sequence | blastn | 17832 | 313 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Lembadionidae | Lembadion | Lembadion bullinum | ||
| 18223505 | 18223505 | PRJNA283169_S_NODE_2295_length_188_cov_1.050360_g2281_i0 | PRJNA283169 | 2295 | 188 | 1.05036 | 1.9746768 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 8.780000000000001e-70 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g2281 | i0 | 93.085 | 2.91489361702128 | 188 | 13 | 100 | 0 | 1 | 188 | 67 | 254 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 548 | 276 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 18910431 | 18910431 | PRJNA283169_P_NODE_7055_length_166_cov_0.880342_g6992_i0 | PRJNA283169 | 7055 | 166 | 0.880342 | 1.46136772 | Bacillariophyta | 2836 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.27e-67 | NTclustered | gi|946969524|gb|KP400274.1| | 2850 | g6992 | i0 | 98.065 | 93.3734939759036 | 155 | 2 | 93 | 1 | 12 | 166 | 260 | 413 | Phaeodactylum tricornutum strain ROS_KABB1 18S ribosomal RNA gene, partial sequence | blastn | 15500 | 268 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 20773315 | 20773315 | PRJNA283169_S_NODE_1377_length_232_cov_0.147541_g1363_i0 | PRJNA283169 | 1377 | 232 | 0.147541 | 0.34229512 | Ulnaria ulna | 426669 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 6.389999999999998e-112 | NTclustered | gi|2579686273|ref|NC_082433.1| | 426669 | g1363 | i0 | 99.563 | 195.711206896552 | 229 | 0 | 98 | 1 | 5 | 232 | 66974 | 67202 | Ulnaria ulna chloroplast, complete genome | blastn | 45405 | 416 | 1 | Eukaryota | Sar | Bacillariophyta | Fragilariophyceae | Licmophorales | Ulnariaceae | Ulnaria | Ulnaria ulna | ||
| 20773319 | 20773319 | PRJNA283169_S_NODE_477_length_363_cov_3.156051_g463_i0 | PRJNA283169 | 477 | 363 | 3.156051 | 11.45646513 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 665 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g463 | i0 | 99.725 | 49.4325068870523 | 363 | 1 | 100 | 0 | 1 | 363 | 844 | 482 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 17944 | 665 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 22048310 | 22048310 | PRJNA283169_S_NODE_558_length_338_cov_1.328720_g544_i0 | PRJNA283169 | 558 | 338 | 1.32872 | 4.4910736 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.33e-43 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g544 | i0 | 80.913 | 12.7751479289941 | 241 | 44 | 71 | 2 | 19 | 258 | 366 | 127 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 4318 | 189 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 22735824 | 22735824 | PRJNA283169_S_NODE_1198_length_247_cov_0.095960_g1184_i0 | PRJNA283169 | 1198 | 247 | 0.09596 | 0.2370212 | Ulnaria | 426668 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 1.88e-122 | NTclustered | gi|2579686273|ref|NC_082433.1| | 426669 | g1184 | i0 | 99.595 | 199.939271255061 | 247 | 1 | 100 | 0 | 1 | 247 | 65626 | 65872 | Ulnaria ulna chloroplast, complete genome | blastn | 49385 | 451 | 1 | Eukaryota | Sar | Bacillariophyta | Fragilariophyceae | Licmophorales | Ulnariaceae | Ulnaria | Ulnaria ulna |
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);;