contig_metadata
5 rows where bioproject = "PRJNA358009", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6175975 | 6175975 | PRJNA358009_P_NODE_17305_length_157_cov_2.425926_g17236_i0 | PRJNA358009 | 17305 | 157 | 2.425926 | 3.80870382 | Ploima | 84394 | Rotifera | other_Eukaryota | 220 | 3.36e-53 | NTclustered | gi|83285202|gb|DQ297749.1| | 360684 | g17236 | i0 | 94.444 | 78.4522292993631 | 144 | 7 | 91 | 1 | 8 | 150 | 268 | 125 | Notommata cordonella 28S ribosomal RNA gene, partial sequence | blastn | 12317 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Notommata | Notommata cordonella | |
| 6775960 | 6775960 | PRJNA358009_P_NODE_7046_length_289_cov_4.491667_g6979_i0 | PRJNA358009 | 7046 | 289 | 4.491667 | 12.98091763 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 483 | 7.999999999999997e-132 | NTclustered | gi|478683563|gb|KC193096.1| | 104777 | g6979 | i0 | 97.527 | 91.8200692041522 | 283 | 5 | 98 | 2 | 8 | 289 | 1783 | 2064 | Brachionus calyciflorus 28S ribosomal RNA gene, partial sequence | blastn | 26536 | 483 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 10001108 | 10001108 | PRJNA358009_P_NODE_12128_length_170_cov_13.545455_g12059_i0 | PRJNA358009 | 12128 | 170 | 13.545455 | 23.0272735 | Asplanchna | 84396 | Rotifera | other_Eukaryota | 246 | 6.0799999999999994e-61 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g12059 | i0 | 93.865 | 7.17058823529412 | 163 | 10 | 96 | 0 | 1 | 163 | 1692 | 1530 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 1219 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 10602066 | 10602066 | PRJNA358009_P_NODE_5249_length_327_cov_1.823741_g5186_i0 | PRJNA358009 | 5249 | 327 | 1.823741 | 5.96363307 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 158 | 6.33e-34 | NTclustered | gi|83285189|gb|DQ297736.1| | 96446 | g5186 | i0 | 96.809 | 2.56574923547401 | 94 | 3 | 57 | 0 | 7 | 100 | 472 | 565 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 839 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 30264733 | 30264733 | PRJNA358009_P_NODE_17932_length_154_cov_2.723810_g17863_i0 | PRJNA358009 | 17932 | 154 | 2.72381 | 4.1946674 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 72.8 | 2.81e-13 | NR | RNA28271.1 | 10195 | g17863 | i0 | 100 | 0.642857142857143 | 33 | 0 | 64.3 | 0 | 2 | 100 | 550 | 582 | RNA28271.1 hypothetical protein BpHYR1_024686 [Brachionus plicatilis] | diamond | 99 | 72.8 | 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);;