contig_metadata
9 rows where bioproject = "PRJNA1008624", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16731420 | 16731420 | PRJNA1008624_P_NODE_36154_length_162_cov_1.203540_g35966_i0 | PRJNA1008624 | 36154 | 162 | 1.20354 | 1.9497348 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|1692840398|gb|MK234835.1| | 1199090 | g35966 | i0 | 100 | 0.172839506172839 | 28 | 0 | 17 | 0 | 53 | 80 | 1151 | 1178 | Brachionus koreanus bifunctional arginine demethylase and lysyl-hydroxylase JMJD6 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 27002646 | 27002646 | PRJNA1008624_P_NODE_27782_length_169_cov_0.866667_g27594_i0 | PRJNA1008624 | 27782 | 169 | 0.866667 | 1.46466723 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 105 | 1.51e-24 | NR | UJR30336.1 | 104782 | g27594 | i0 | 96.2 | 15.6923076923077 | 52 | 2 | 92.3 | 0 | 5 | 160 | 4448 | 4499 | UJR30336.1 hypothetical protein I4U23_017873 [Adineta vaga] | diamond | 2652 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27753818 | 27753818 | PRJNA1008624_P_NODE_27744_length_169_cov_0.866667_g27556_i0 | PRJNA1008624 | 27744 | 169 | 0.866667 | 1.46466723 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 45.8 | 0.00112 | NR | CAF0879831.1 | 249248 | g27556 | i0 | 88 | 4.2603550295858 | 25 | 3 | 44.4 | 0 | 76 | 2 | 156 | 180 | CAF0879831.1 unnamed protein product [Adineta ricciae] | diamond | 720 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28266043 | 28266043 | PRJNA1008624_P_NODE_30926_length_166_cov_0.888889_g30738_i0 | PRJNA1008624 | 30926 | 166 | 0.888889 | 1.47555574 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 50.8 | 1.77e-5 | NR | CAF1149838.1 | 433720 | g30738 | i0 | 48.1 | 1.95180722891566 | 54 | 27 | 95.8 | 1 | 161 | 3 | 385 | 438 | CAF1149838.1 unnamed protein product [Adineta steineri] | diamond | 324 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28992796 | 28992796 | PRJNA1008624_P_NODE_37068_length_162_cov_0.920354_g36880_i0 | PRJNA1008624 | 37068 | 162 | 0.920354 | 1.49097348 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 65.5 | 1.22e-10 | NR | CAF0765273.1 | 104777 | g36880 | i0 | 59.6 | 0.87037037037037 | 47 | 18 | 87 | 1 | 162 | 22 | 2041 | 2086 | CAF0765273.1 unnamed protein product [Brachionus calyciflorus] | diamond | 141 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29364027 | 29364027 | PRJNA1008624_P_NODE_21209_length_188_cov_1.079137_g21021_i0 | PRJNA1008624 | 21209 | 188 | 1.079137 | 2.02877756 | root | 1 | Root_unresolved | Root_unresolved | 67.4 | 3.6e-11 | NR | CAF0717024.1 | 104777 | g21021 | i0 | 55 | 5.60106382978723 | 60 | 27 | 95.7 | 0 | 1 | 180 | 771 | 830 | CAF0717024.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1053 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31045890 | 31045890 | PRJNA1008624_P_NODE_35075_length_163_cov_0.912281_g34887_i0 | PRJNA1008624 | 35075 | 163 | 0.912281 | 1.48701803 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 80.9 | 4.25e-16 | NR | CAF1235481.1 | 249248 | g34887 | i0 | 71.2 | 0.957055214723926 | 52 | 15 | 95.7 | 0 | 6 | 161 | 443 | 494 | CAF1235481.1 unnamed protein product [Adineta ricciae] | diamond | 156 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31930961 | 31930961 | PRJNA1008624_P_NODE_28657_length_168_cov_0.873950_g28469_i0 | PRJNA1008624 | 28657 | 168 | 0.87395 | 1.468236 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 64.7 | 8.12e-11 | NR | AGH55768.1 | 104777 | g28469 | i0 | 63.3 | 0.875 | 49 | 18 | 87.5 | 0 | 163 | 17 | 130 | 178 | AGH55768.1 SMC6B, partial [Brachionus calyciflorus] | diamond | 147 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32564124 | 32564124 | PRJNA1008624_P_NODE_30239_length_167_cov_0.881356_g30051_i0 | PRJNA1008624 | 30239 | 167 | 0.881356 | 1.47186452 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 72.4 | 4.13e-13 | NR | UJR30098.1 | 104782 | g30051 | i0 | 72.7 | 0.790419161676647 | 44 | 12 | 79 | 0 | 11 | 142 | 217 | 260 | UJR30098.1 hypothetical protein I4U23_017639 [Adineta vaga] | diamond | 132 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;