contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA922890" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6001764 | 6001764 | PRJNA922890_P_NODE_74165_length_233_cov_0.878049_g73755_i0 | PRJNA922890 | 74165 | 233 | 0.878049 | 2.04585417 | Pyrocystis lunula | 2972 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.5299999999999998e-46 | NTclustered | gi|27450756|gb|AF508262.1| | 2972 | g73755 | i0 | 82.456 | 0.978540772532189 | 228 | 39 | 98 | 1 | 6 | 233 | 470 | 244 | Pyrocystis lunula cytoplasmic ribosomal protein S13 mRNA, complete cds | blastn | 228 | 198 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 7276636 | 7276636 | PRJNA922890_P_NODE_66946_length_237_cov_0.869048_g66536_i0 | PRJNA922890 | 66946 | 237 | 0.869048 | 2.05964376 | Theileria equi | 5872 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 2.51e-66 | NTclustered | gi|510899845|ref|XM_004828608.1| | 1537102 | g66536 | i0 | 87.124 | 0.983122362869198 | 233 | 30 | 98 | 0 | 1 | 233 | 1939 | 2171 | Theileria equi strain WA hypothetical protein (BEWA_018440), partial mRNA | blastn | 233 | 265 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 9825825 | 9825825 | PRJNA922890_P_NODE_42688_length_297_cov_2.039474_g42278_i0 | PRJNA922890 | 42688 | 297 | 2.039474 | 6.05723778 | Isotricha intestinalis | 47897 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 3.119999999999999e-96 | NTclustered | gi|92790153|emb|AJ965262.1| | 47897 | g42278 | i0 | 88.889 | 125.659932659933 | 297 | 31 | 99 | 2 | 2 | 297 | 461 | 166 | Isotricha intestinalis partial mRNA for Polyubiqutin 2 (polyubiqutin 2 gene) | blastn | 37321 | 364 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha intestinalis | ||
| 12377151 | 12377151 | PRJNA922890_P_NODE_42490_length_298_cov_1.262009_g42080_i0 | PRJNA922890 | 42490 | 298 | 1.262009 | 3.76078682 | Dinophysis acuta | 150597 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.2899999999999993e-137 | NTclustered | gi|908373617|gb|KP826902.1| | 150597 | g42080 | i0 | 99.281 | 90.3859060402685 | 278 | 1 | 93 | 1 | 22 | 298 | 391 | 114 | Dinophysis acuta isolate 147 23S ribosomal RNA gene, partial sequence; plastid | blastn | 26935 | 501 | 1 | Eukaryota | Sar | Dinophyceae | Dinophysales | Dinophysaceae | Dinophysis | Dinophysis acuta | |||
| 12377234 | 12377234 | PRJNA922890_P_NODE_46730_length_285_cov_1.342593_g46320_i0 | PRJNA922890 | 46730 | 285 | 1.342593 | 3.82639005 | Spathidium sp. | 35110 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 9.08e-32 | NTclustered | gi|4107502|gb|AF056105.1|AF056105 | 35110 | g46320 | i0 | 77.068 | 4.67017543859649 | 266 | 58 | 93 | 3 | 14 | 278 | 640 | 903 | Spathidium sp. translation elongation factor 1-alpha (TEF2) gene, partial cds | blastn | 1331 | 150 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Spathidiidae | Spathidium | Spathidium sp. | ||
| 13651765 | 13651765 | PRJNA922890_P_NODE_46951_length_284_cov_2.218605_g46541_i0 | PRJNA922890 | 46951 | 284 | 2.218605 | 6.3008382 | Spathidium sp. | 35110 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 6.37e-98 | NTclustered | gi|861141|emb|Z49848.1| | 35110 | g46541 | i0 | 90.714 | 97.6549295774648 | 280 | 22 | 98 | 4 | 5 | 282 | 1109 | 832 | Spathidium sp. gene for alpha-tubulin (partial) | blastn | 27734 | 370 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Spathidiidae | Spathidium | Spathidium sp. | ||
| 16554444 | 16554444 | PRJNA922890_P_NODE_56293_length_260_cov_3.649215_g55883_i0 | PRJNA922890 | 56293 | 260 | 3.649215 | 9.487959 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 2.2199999999999996e-47 | NTclustered | gi|698794251|ref|XM_009831853.1| | 112090 | g55883 | i0 | 82.328 | 2.16538461538462 | 232 | 41 | 89 | 0 | 5 | 236 | 451 | 220 | Aphanomyces astaci archaeal ribosomal protein S17P mRNA | blastn | 563 | 202 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21299777 | 21299777 | PRJNA922890_P_NODE_29417_length_352_cov_0.816254_g29007_i0 | PRJNA922890 | 29417 | 352 | 0.816254 | 2.87321408 | Actinosphaerium nucleofilum | 238767 | SAR_Eukaryotes | SAR_Eukaryotes | 545 | 1.25e-150 | NTclustered | gi|33089895|gb|AY283757.1| | 238767 | g29007 | i0 | 94.602 | 96.0284090909091 | 352 | 19 | 100 | 0 | 1 | 352 | 744 | 393 | Actinosphaerium nucleofilum isolate Anu4_3 actin gene, partial cds | blastn | 33802 | 545 | 1 | Eukaryota | Sar | Actinophryidae | Actinosphaerium | Actinosphaerium nucleofilum | |||||
| 21654159 | 21654159 | PRJNA922890_P_NODE_50037_length_276_cov_1.043478_g49627_i0 | PRJNA922890 | 50037 | 276 | 1.043478 | 2.87999928 | Polycystinea | 65582 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 9.75e-136 | NTclustered | gi|1133508283|emb|LT673711.1| | 1054399 | g49627 | i0 | 99.27 | 25.8405797101449 | 274 | 2 | 99 | 0 | 3 | 276 | 505 | 232 | Lithomelissa setosa partial mRNA for Ribosomal Protein L15 (rpl15 gene), isolate AKK-54 2016 | blastn | 7132 | 501 | 0.99001996007984 | Eukaryota | Sar | Polycystinea | Nassellaria | Plagiacanthidae | Lithomelissa | Lithomelissa setosa | |||
| 22575299 | 22575299 | PRJNA922890_P_NODE_55238_length_263_cov_1.211340_g54828_i0 | PRJNA922890 | 55238 | 263 | 1.21134 | 3.1858242 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 5.71e-113 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g54828 | i0 | 95.437 | 9.35361216730038 | 263 | 12 | 100 | 0 | 1 | 263 | 52 | 314 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2460 | 420 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 23850687 | 23850687 | PRJNA922890_P_NODE_64359_length_242_cov_1.410405_g63949_i0 | PRJNA922890 | 64359 | 242 | 1.410405 | 3.4131801 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.1099999999999995e-119 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g63949 | i0 | 99.587 | 48.9917355371901 | 242 | 1 | 100 | 0 | 1 | 242 | 385 | 144 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 11856 | 442 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 25124113 | 25124113 | PRJNA922890_P_NODE_43080_length_296_cov_1.295154_g42670_i0 | PRJNA922890 | 43080 | 296 | 1.295154 | 3.83365584 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 547 | 2.8799999999999986e-151 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g42670 | i0 | 100 | 80.6689189189189 | 296 | 0 | 100 | 0 | 1 | 296 | 620 | 915 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 23878 | 547 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 25124543 | 25124543 | PRJNA922890_P_NODE_67860_length_236_cov_0.874251_g67450_i0 | PRJNA922890 | 67860 | 236 | 0.874251 | 2.06323236 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.33e-39 | NTclustered | gi|829188477|ref|XM_001023087.3| | 312017 | g67450 | i0 | 81.776 | 2.21186440677966 | 214 | 33 | 89 | 6 | 1 | 211 | 1045 | 835 | Tetrahymena thermophila SB210 S-adenosyl-L-homocysteine hydrolase partial mRNA | blastn | 522 | 174 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila |
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);;