contig_metadata
9 rows where bioproject = "PRJNA706190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1191158 | 1191158 | PRJNA706190_P_NODE_14161_length_221_cov_2.081395_g14025_i0 | PRJNA706190 | 14161 | 221 | 2.081395 | 4.59988295 | root | 1 | Root_unresolved | Root_unresolved | 398 | 2.1799999999999995e-106 | NTclustered | gi|345541658|gb|JN547815.1| | 5911 | g14025 | i0 | 99.095 | 83.9954751131222 | 221 | 2 | 100 | 0 | 1 | 221 | 3547 | 3767 | Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 18563 | 398 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 2466414 | 2466414 | PRJNA706190_P_NODE_28342_length_192_cov_5.272727_g28206_i0 | PRJNA706190 | 28342 | 192 | 5.272727 | 10.12363584 | root | 1 | Root_unresolved | Root_unresolved | 350 | 5.24e-92 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g28206 | i0 | 99.479 | 91.8541666666667 | 192 | 1 | 100 | 0 | 1 | 192 | 8314 | 8123 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 17636 | 350 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8844102 | 8844102 | PRJNA706190_P_NODE_8947_length_242_cov_1.792746_g8811_i0 | PRJNA706190 | 8947 | 242 | 1.792746 | 4.33844532 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.1099999999999995e-119 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g8811 | i0 | 99.587 | 91.1818181818182 | 242 | 1 | 100 | 0 | 1 | 242 | 2702 | 2943 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 22066 | 442 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 10906715 | 10906715 | PRJNA706190_P_NODE_23489_length_200_cov_2.112583_g23353_i0 | PRJNA706190 | 23489 | 200 | 2.112583 | 4.225166 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 1.99e-86 | NTclustered | gi|256009645|gb|GQ374534.1| | 112090 | g23353 | i0 | 96.5 | 83.395 | 200 | 7 | 100 | 0 | 1 | 200 | 185 | 384 | Aphanomyces astaci strain Gb04 28S ribosomal RNA gene, partial sequence | blastn | 16679 | 331 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 12670710 | 12670710 | PRJNA706190_P_NODE_93950_length_152_cov_2.669903_g93814_i0 | PRJNA706190 | 93950 | 152 | 2.669903 | 4.05825256 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.46e-71 | NTclustered | gi|1233819925|gb|KX516617.1| | 440145 | g93814 | i0 | 100 | 90.0065789473684 | 152 | 0 | 100 | 0 | 1 | 152 | 159 | 8 | Euplotes encysticus isolate B555 large subunit ribosomal RNA gene, partial sequence | blastn | 13681 | 281 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes encysticus | ||
| 16005297 | 16005297 | PRJNA706190_P_NODE_24033_length_199_cov_3.386667_g23897_i0 | PRJNA706190 | 24033 | 199 | 3.386667 | 6.73946733 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 3.2899999999999996e-89 | NTclustered | gi|1241841574|gb|KY273139.1| | 5908 | g23897 | i0 | 97.487 | 21.6231155778894 | 199 | 5 | 100 | 0 | 1 | 199 | 206 | 8 | Tetrahymena pyriformis isolate 1098-1 large subunit ribosomal RNA gene, partial sequence; macronuclear | blastn | 4303 | 340 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 22380257 | 22380257 | PRJNA706190_P_NODE_6358_length_261_cov_2.018868_g6222_i0 | PRJNA706190 | 6358 | 261 | 2.018868 | 5.26924548 | Poteriospumella sp. | 2003111 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.12e-132 | NTclustered | gi|1209404931|gb|KX442736.1| | 2003111 | g6222 | i0 | 100 | 95.8122605363985 | 261 | 0 | 100 | 0 | 1 | 261 | 1412 | 1152 | Poteriospumella sp. strain JBAS36 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 | 25007 | 483 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella sp. | |||
| 24142745 | 24142745 | PRJNA706190_P_NODE_93819_length_156_cov_2.467290_g93683_i0 | PRJNA706190 | 93819 | 156 | 2.46729 | 3.8489724 | root | 1 | Root_unresolved | Root_unresolved | 283 | 4.1899999999999994e-72 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g93683 | i0 | 99.359 | 82.9294871794872 | 156 | 1 | 100 | 0 | 1 | 156 | 1755 | 1910 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 12937 | 283 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 32106613 | 32106613 | PRJNA706190_P_NODE_32358_length_187_cov_1.137681_g32222_i0 | PRJNA706190 | 32358 | 187 | 1.137681 | 2.12746347 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0102 | NR | OWZ04601.1 | 4795 | g32222 | i0 | 37.9 | 1.82887700534759 | 58 | 29 | 93 | 2 | 14 | 187 | 17 | 67 | OWZ04601.1 hypothetical protein PHMEG_00023469 [Phytophthora megakarya] | diamond | 342 | 42.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya |
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);;