contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA688736" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8830817 | 8830817 | PRJNA688736_P_NODE_49467_length_243_cov_0.917647_g49182_i0 | PRJNA688736 | 49467 | 243 | 0.917647 | 2.22988221 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.0599999999999998e-31 | NR | XP_004029989.1 | 5932 | g49182 | i0 | 71.3 | 1.97530864197531 | 80 | 23 | 98.8 | 0 | 2 | 241 | 375 | 454 | XP_004029989.1 hypothetical protein IMG5_169500 [Ichthyophthirius multifiliis] | diamond | 480 | 127 | 0.992125984251969 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 9596722 | 9596722 | PRJNA688736_P_NODE_47928_length_245_cov_0.906977_g47643_i0 | PRJNA688736 | 47928 | 245 | 0.906977 | 2.22209365 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 9.79e-28 | NR | QBH22568.1 | 282688 | g47643 | i0 | 72.8 | 0.991836734693878 | 81 | 22 | 99.2 | 0 | 245 | 3 | 767 | 847 | QBH22568.1 V-type proton ATPase subunit a [Philasterides dicentrarchi] | diamond | 243 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 29335926 | 29335926 | PRJNA688736_P_NODE_43809_length_249_cov_0.886364_g43524_i0 | PRJNA688736 | 43809 | 249 | 0.886364 | 2.20704636 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 4.74e-9 | NR | XP_001444384.1 | 5888 | g43524 | i0 | 40.5 | 4.74698795180723 | 79 | 42 | 95.2 | 1 | 248 | 12 | 101 | 174 | XP_001444384.1 uncharacterized protein GSPATT00012511001 [Paramecium tetraurelia] | diamond | 1182 | 62.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 29967518 | 29967518 | PRJNA688736_P_NODE_47031_length_246_cov_0.901734_g46746_i0 | PRJNA688736 | 47031 | 246 | 0.901734 | 2.21826564 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 1.9499999999999999e-31 | NR | XP_012653439.1 | 312017 | g46746 | i0 | 69.1 | 2.96341463414634 | 81 | 25 | 98.8 | 0 | 245 | 3 | 23 | 103 | XP_012653439.1 60S ribosomal protein L17 [Tetrahymena thermophila SB210] | diamond | 729 | 119 | 0.991596638655462 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30967082 | 30967082 | PRJNA688736_P_NODE_45854_length_247_cov_0.896552_g45569_i0 | PRJNA688736 | 45854 | 247 | 0.896552 | 2.21448344 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.51e-24 | NR | OMJ78935.1 | 5963 | g45569 | i0 | 59.3 | 0.983805668016194 | 81 | 32 | 98.4 | 1 | 245 | 3 | 333 | 412 | OMJ78935.1 hypothetical protein SteCoe_21156 [Stentor coeruleus] | diamond | 243 | 105 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 31883856 | 31883856 | PRJNA688736_P_NODE_45757_length_247_cov_0.896552_g45472_i0 | PRJNA688736 | 45757 | 247 | 0.896552 | 2.21448344 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 4.26e-16 | NR | XP_001426365.1 | 5888 | g45472 | i0 | 44.9 | 0.947368421052632 | 78 | 43 | 94.7 | 0 | 2 | 235 | 151 | 228 | XP_001426365.1 uncharacterized protein GSPATT00029597001 [Paramecium tetraurelia] | diamond | 234 | 82.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 32200400 | 32200400 | PRJNA688736_P_NODE_9958_length_473_cov_3.570000_g9674_i0 | PRJNA688736 | 9958 | 473 | 3.57 | 16.8861 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 3.27e-5 | NR | CAG9310987.1 | 1481888 | g9674 | i0 | 35.1 | 0.596194503171247 | 94 | 56 | 59 | 2 | 401 | 123 | 231 | 320 | CAG9310987.1 unnamed protein product [Blepharisma stoltei] | diamond | 282 | 54.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 32232260 | 32232260 | PRJNA688736_P_NODE_48618_length_244_cov_0.912281_g48333_i0 | PRJNA688736 | 48618 | 244 | 0.912281 | 2.22596564 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.44e-5 | NR | KRX06315.1 | 266149 | g48333 | i0 | 37.9 | 1.45081967213115 | 58 | 36 | 71.3 | 0 | 241 | 68 | 265 | 322 | KRX06315.1 Protein kinase-like domain [Pseudocohnilembus persalinus] | diamond | 354 | 52.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus |
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);;