contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA599026" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12050900 | 12050900 | PRJNA599026_S_NODE_41750_length_179_cov_1.176923_g41294_i0 | PRJNA599026 | 41750 | 179 | 1.176923 | 2.10669217 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 154 | 4.04e-33 | NTclustered | gi|2105975276|gb|MZ706949.1| | 104777 | g41294 | i0 | 82.941 | 87.1173184357542 | 170 | 29 | 95 | 0 | 10 | 179 | 27007 | 26838 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 15594 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 18423695 | 18423695 | PRJNA599026_S_NODE_41015_length_180_cov_1.427481_g40559_i0 | PRJNA599026 | 41015 | 180 | 1.427481 | 2.5694658 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 237 | 3.9300000000000005e-58 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g40559 | i0 | 91.329 | 5.03333333333333 | 173 | 15 | 96 | 0 | 8 | 180 | 2227 | 2399 | Rotaria rotatoria mitochondrion, complete genome | blastn | 906 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 20973719 | 20973719 | PRJNA599026_S_NODE_1897_length_685_cov_6.954403_g1519_i0 | PRJNA599026 | 1897 | 685 | 6.954403 | 47.63766055 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 388 | 4.59e-103 | NTclustered | gi|2778092479|gb|PP988071.1| | 3231738 | g1519 | i0 | 78.539 | 22.4905109489051 | 657 | 93 | 92 | 40 | 45 | 677 | 1774 | 2406 | Asplanchna sp. chromosome I mitochondrion, complete sequence | blastn | 15406 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 22248676 | 22248676 | PRJNA599026_S_NODE_27718_length_207_cov_1.613924_g27262_i0 | PRJNA599026 | 27718 | 207 | 1.613924 | 3.34082268 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 128 | 2.93e-25 | NTclustered | gi|218117251|emb|AM980954.1| | 10195 | g27262 | i0 | 86.842 | 1.65700483091787 | 114 | 15 | 55 | 0 | 2 | 115 | 114 | 1 | Brachionus plicatilis partial mRNA for 60S ribosomal protein L37a, (RPL37a gene) | blastn | 343 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis |
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);;