contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA451191" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2990792 | 2990792 | PRJNA451191_P_NODE_23123_length_296_cov_3.472340_g22852_i0 | PRJNA451191 | 23123 | 296 | 3.47234 | 10.2781264 | Brachionus manjavacas | 667381 | Rotifera | other_Eukaryota | 117 | 9.61e-22 | NTclustered | gi|2006240371|gb|MW559986.1| | 667381 | g22852 | i0 | 75.451 | 10.4831081081081 | 277 | 49 | 90 | 17 | 13 | 278 | 6200 | 6468 | Brachionus manjavacas isolate AU chromosome I mitochondrion, complete sequence | blastn | 3103 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus manjavacas | |
| 2991244 | 2991244 | PRJNA451191_P_NODE_36303_length_236_cov_2.011429_g36032_i0 | PRJNA451191 | 36303 | 236 | 2.011429 | 4.74697244 | Keratella cochlearis | 204738 | Rotifera | other_Eukaryota | 267 | 6.94e-67 | NTclustered | gi|2057213512|gb|MZ438188.1| | 204738 | g36032 | i0 | 87.826 | 87.9703389830509 | 230 | 24 | 97 | 4 | 9 | 236 | 759 | 532 | Keratella cochlearis isolate Kcoc_DS cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 20761 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Keratella | Keratella cochlearis | |
| 4267800 | 4267800 | PRJNA451191_P_NODE_41864_length_220_cov_1.635220_g41593_i0 | PRJNA451191 | 41864 | 220 | 1.63522 | 3.597484 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 115 | 2.45e-21 | NTclustered | gi|1066800230|gb|KX364937.1| | 96890 | g41593 | i0 | 78.061 | 1.57727272727273 | 196 | 34 | 87 | 8 | 3 | 194 | 5926 | 6116 | Brachionus rotundiformis chromosome II mitochondrion, complete sequence | blastn | 347 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis |
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);;