contig_metadata
7 rows where bioproject = "PRJNA451191", tax_clade = "Opisthokonta" 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 | |
| 26727475 | 26727475 | PRJNA451191_P_NODE_54161_length_203_cov_0.915493_g53890_i0 | PRJNA451191 | 54161 | 203 | 0.915493 | 1.85845079 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 72.4 | 7.75e-13 | NR | CAF0712708.1 | 104777 | g53890 | i0 | 49.3 | 0.990147783251232 | 67 | 34 | 99 | 0 | 202 | 2 | 1454 | 1520 | CAF0712708.1 unnamed protein product [Brachionus calyciflorus] | diamond | 201 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27423974 | 27423974 | PRJNA451191_P_NODE_50663_length_206_cov_0.896552_g50392_i0 | PRJNA451191 | 50663 | 206 | 0.896552 | 1.84689712 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 99 | 3.71e-22 | NR | CAF0767900.1 | 104777 | g50392 | i0 | 76.3 | 0.859223300970874 | 59 | 14 | 85.9 | 0 | 204 | 28 | 1629 | 1687 | CAF0767900.1 unnamed protein product [Brachionus calyciflorus] | diamond | 177 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29034262 | 29034262 | PRJNA451191_P_NODE_36768_length_235_cov_1.408046_g36497_i0 | PRJNA451191 | 36768 | 235 | 1.408046 | 3.3089081 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 43.9 | 0.0132 | NR | CAF0773055.1 | 104777 | g36497 | i0 | 61.5 | 0.663829787234043 | 26 | 10 | 33.2 | 0 | 123 | 46 | 12 | 37 | CAF0773055.1 unnamed protein product [Brachionus calyciflorus] | diamond | 156 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30802770 | 30802770 | PRJNA451191_P_NODE_52374_length_204_cov_1.650350_g52103_i0 | PRJNA451191 | 52374 | 204 | 1.65035 | 3.366714 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 105 | 7.71e-25 | NR | CAF0717269.1 | 104777 | g52103 | i0 | 81.7 | 0.882352941176471 | 60 | 11 | 88.2 | 0 | 202 | 23 | 367 | 426 | CAF0717269.1 unnamed protein product [Brachionus calyciflorus] | diamond | 180 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus |
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);;