contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA698538" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10885384 | 10885384 | PRJNA698538_S_NODE_17909_length_295_cov_1.734234_g17743_i0 | PRJNA698538 | 17909 | 295 | 1.734234 | 5.1159903 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 291 | 5.3299999999999986e-74 | NTclustered | gi|402761757|gb|JX184010.1| | 104786 | g17743 | i0 | 84.407 | 21.2542372881356 | 295 | 46 | 100 | 0 | 1 | 295 | 588 | 294 | Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial | blastn | 6270 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 13435343 | 13435343 | PRJNA698538_S_NODE_31571_length_227_cov_2.461039_g31405_i0 | PRJNA698538 | 31571 | 227 | 2.461039 | 5.58655853 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 331 | 2.32e-86 | NTclustered | gi|197321809|gb|EU853690.1| | 104782 | g31405 | i0 | 92.952 | 212.356828193833 | 227 | 16 | 100 | 0 | 1 | 227 | 223 | 449 | Adineta vaga histone H2A variant H2Abd1 copy 2d (H2Abd1) gene, partial cds | blastn | 48205 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 23634402 | 23634402 | PRJNA698538_S_NODE_27619_length_248_cov_1.320000_g27453_i0 | PRJNA698538 | 27619 | 248 | 1.32 | 3.2736 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 276 | 1.22e-69 | NTclustered | gi|402761789|gb|JX184026.1| | 104786 | g27453 | i0 | 86.694 | 51.9637096774194 | 248 | 33 | 100 | 0 | 1 | 248 | 1028 | 781 | Habrotrocha constricta cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 12887 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta |
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);;