contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA986547" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2547952 | 2547952 | PRJNA986547_P_NODE_16042_length_208_cov_57.496296_g15960_i0 | PRJNA986547 | 16042 | 208 | 57.496296 | 119.59229568 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 7.359999999999998e-101 | NTclustered | gi|291495599|gb|GU823226.1| | 152704 | g15960 | i0 | 99.519 | 100 | 208 | 1 | 100 | 0 | 1 | 208 | 899 | 692 | Uncultured stramenopile clone BCA5F13RJ3F09 18S ribosomal RNA gene, partial sequence | blastn | 20800 | 379 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 6077496 | 6077496 | PRJNA986547_P_NODE_8085_length_253_cov_6.050000_g8003_i0 | PRJNA986547 | 8085 | 253 | 6.05 | 15.3065 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 1.94e-122 | NTclustered | gi|759083562|gb|KM222179.1| | 1607889 | g8003 | i0 | 99.2 | 90.7430830039526 | 250 | 2 | 99 | 0 | 1 | 250 | 183 | 432 | Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence | blastn | 22958 | 451 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 9902248 | 9902248 | PRJNA986547_P_NODE_10888_length_244_cov_1.783626_g10806_i0 | PRJNA986547 | 10888 | 244 | 1.783626 | 4.35204744 | Rimostrombidium veniliae | 702563 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 9.139999999999999e-81 | NTclustered | gi|759083337|gb|KM221993.1| | 702563 | g10806 | i0 | 90.041 | 99.2868852459016 | 241 | 24 | 99 | 0 | 1 | 241 | 321 | 561 | Rimostrombidium veniliae voucher LWW2007042901 alpha-tubulin gene, partial cds | blastn | 24226 | 313 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Choreotrichida | Strobilidiidae | Rimostrombidium | Rimostrombidium veniliae | ||
| 16574770 | 16574770 | PRJNA986547_P_NODE_11993_length_241_cov_1.750000_g11911_i0 | PRJNA986547 | 11993 | 241 | 1.75 | 4.2175 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 3.959999999999999e-119 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g11911 | i0 | 99.585 | 99.8755186721992 | 241 | 1 | 100 | 0 | 1 | 241 | 1131 | 891 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 24070 | 440 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 18826039 | 18826039 | PRJNA986547_P_NODE_8295_length_252_cov_2.262570_g8213_i0 | PRJNA986547 | 8295 | 252 | 2.26257 | 5.7016764 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.1899999999999997e-104 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g8213 | i0 | 94.841 | 14.1349206349206 | 252 | 12 | 100 | 1 | 1 | 252 | 157190 | 156940 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 3562 | 392 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23926596 | 23926596 | PRJNA986547_P_NODE_10259_length_246_cov_1.260116_g10177_i0 | PRJNA986547 | 10259 | 246 | 1.260116 | 3.09988536 | Leptoamphisiella vermis | 692523 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 5.56e-78 | NTclustered | gi|399146156|gb|JQ736707.1| | 692523 | g10177 | i0 | 88.98 | 102.056910569106 | 245 | 27 | 99 | 0 | 2 | 246 | 493 | 249 | Leptoamphisiella vermis isolate 061224 alpha-tubulin gene, partial cds; macronuclear | blastn | 25106 | 303 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Pseudoamphisiellida | Leptoamphisiella | Leptoamphisiella vermis | |||
| 25200377 | 25200377 | PRJNA986547_P_NODE_17380_length_197_cov_6.362903_g17298_i0 | PRJNA986547 | 17380 | 197 | 6.362903 | 12.53491891 | Sticholonche zanclea | 1054997 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 7.499999999999998e-41 | NTclustered | gi|1133508237|emb|LT673688.1| | 1054997 | g17298 | i0 | 83.77 | 56.5532994923858 | 191 | 29 | 96 | 2 | 7 | 196 | 249 | 438 | Sticholonche zanclea partial mRNA for Ribosomal Protein S6 (rps6 gene), isolate AKK-51 2016 | blastn | 11141 | 180 | 1 | Eukaryota | Sar | Sticholonchida | Sticholonchidae | Sticholonche | Sticholonche zanclea |
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);;