contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 290263 | 290263 | PRJNA1146029_P_NODE_8241_length_315_cov_1.557851_g7960_i0 | PRJNA1146029 | 8241 | 315 | 1.557851 | 4.90723065 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 399 | 9.139999999999997e-107 | NTclustered | gi|83285134|gb|DQ297775.1| | 96446 | g7960 | i0 | 89.524 | 99.9269841269841 | 315 | 33 | 100 | 0 | 1 | 315 | 457 | 143 | Lecane bulla cytochrome c oxidase subunit I gene, partial cds; mitochondrial | blastn | 31477 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 4117224 | 4117224 | PRJNA1146029_P_NODE_6424_length_349_cov_1.394928_g6146_i0 | PRJNA1146029 | 6424 | 349 | 1.394928 | 4.86829872 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 324 | 6.33e-84 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g6146 | i0 | 83.807 | 69.1661891117479 | 352 | 46 | 99 | 4 | 2 | 349 | 784 | 1128 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 24139 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 9218199 | 9218199 | PRJNA1146029_P_NODE_3228_length_476_cov_1.389578_g2951_i0 | PRJNA1146029 | 3228 | 476 | 1.389578 | 6.61439128 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 305 | 3.22e-78 | NTclustered | gi|1143271481|gb|KX822781.1| | 104777 | g2951 | i0 | 79.717 | 51.2457983193277 | 424 | 84 | 89 | 2 | 1 | 423 | 18500 | 18922 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 24393 | 305 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 16867370 | 16867370 | PRJNA1146029_P_NODE_7414_length_329_cov_1.777344_g7135_i0 | PRJNA1146029 | 7414 | 329 | 1.777344 | 5.84746176 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 76.8 | 1.84e-9 | NTclustered | gi|1252327087|gb|KY828435.1| | 1199090 | g7135 | i0 | 81.188 | 0.407294832826748 | 101 | 13 | 31 | 6 | 229 | 329 | 887 | 793 | Brachionus koreanus elongation factor 1 alpha mRNA, partial cds | blastn | 134 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 21967059 | 21967059 | PRJNA1146029_P_NODE_5838_length_363_cov_1.820690_g5560_i0 | PRJNA1146029 | 5838 | 363 | 1.82069 | 6.6091047 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 318 | 3.07e-82 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g5560 | i0 | 82.692 | 62.7933884297521 | 364 | 58 | 99 | 5 | 1 | 362 | 100 | 460 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 22794 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 23242573 | 23242573 | PRJNA1146029_P_NODE_4579_length_404_cov_1.395770_g4301_i0 | PRJNA1146029 | 4579 | 404 | 1.39577 | 5.6389108 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 261 | 5.910000000000001e-65 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g4301 | i0 | 86.555 | 41.4653465346535 | 238 | 30 | 59 | 2 | 154 | 390 | 875 | 639 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 16752 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens |
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);;