contig_metadata
6 rows where bioproject = "PRJNA658591", tax_clade = "Sar" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12104863 | 12104863 | PRJNA658591_S_NODE_8110_length_174_cov_1.248000_g8047_i0 | PRJNA658591 | 8110 | 174 | 1.248 | 2.17152 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 3.93e-28 | NTclustered | gi|829175019|ref|XM_001017812.3| | 312017 | g8047 | i0 | 87.402 | 0.729885057471264 | 127 | 6 | 72 | 4 | 24 | 149 | 267 | 150 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 127 | 137 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 19012944 | 19012944 | PRJNA658591_S_NODE_4155_length_222_cov_3.225434_g4092_i0 | PRJNA658591 | 4155 | 222 | 3.225434 | 7.16046348 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.2e-20 | NTclustered | gi|3366652|gb|AF031320.1|AF031320 | 5911 | g4092 | i0 | 89.655 | 0.783783783783784 | 87 | 9 | 39 | 0 | 133 | 219 | 1105 | 1019 | Tetrahymena thermophila granule lattice protein 4 precursor (GRL4) mRNA, complete cds | blastn | 174 | 111 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28376151 | 28376151 | PRJNA658591_S_NODE_3846_length_229_cov_1.155556_g3783_i0 | PRJNA658591 | 3846 | 229 | 1.155556 | 2.64622324 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 4.24e-5 | NR | XP_001022599.2 | 312017 | g3783 | i0 | 80 | 0.393013100436681 | 30 | 6 | 39.3 | 0 | 107 | 196 | 348 | 377 | XP_001022599.2 granule lattice protein [Tetrahymena thermophila SB210] | diamond | 90 | 50.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31357666 | 31357666 | PRJNA658591_S_NODE_8976_length_168_cov_1.394958_g8913_i0 | PRJNA658591 | 8976 | 168 | 1.394958 | 2.34352944 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 4.6e-18 | NR | KAL4480407.1 | 5901 | g8913 | i0 | 73.2 | 3 | 56 | 15 | 100 | 0 | 168 | 1 | 156 | 211 | KAL4480407.1 hypothetical protein ABPG74_020923 [Tetrahymena malaccensis] | diamond | 504 | 86.7 | 0.990772779700115 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 31472027 | 31472027 | PRJNA658591_S_NODE_9876_length_164_cov_0.904348_g9813_i0 | PRJNA658591 | 9876 | 164 | 0.904348 | 1.48313072 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 7.97e-18 | NR | XP_001011873.1 | 312017 | g9813 | i0 | 60.7 | 1.11585365853659 | 61 | 17 | 98.8 | 2 | 162 | 1 | 675 | 735 | XP_001011873.1 hypothetical protein TTHERM_00392970 [Tetrahymena thermophila SB210] | diamond | 183 | 85.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31768681 | 31768681 | PRJNA658591_S_NODE_6237_length_191_cov_1.345070_g6174_i0 | PRJNA658591 | 6237 | 191 | 1.34507 | 2.5690837 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0098 | NR | KAL4464683.1 | 5901 | g6174 | i0 | 78.3 | 0.706806282722513 | 23 | 5 | 36.1 | 0 | 115 | 183 | 304 | 326 | KAL4464683.1 hypothetical protein ABPG74_011244 [Tetrahymena malaccensis] | diamond | 135 | 43.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis |
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);;