contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA798511" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4618796 | 4618796 | PRJNA798511_P_NODE_38944_length_430_cov_1.439776_g34682_i0 | PRJNA798511 | 38944 | 430 | 1.439776 | 6.1910368 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 52.8 | 0.041 | NTclustered | gi|2029759104|gb|MW026556.1| | 396692 | g34682 | i0 | 94.286 | 0.0813953488372093 | 35 | 1 | 8 | 1 | 4 | 38 | 4213 | 4180 | Brachionus angularis ATP-binding cassette transporter Abca2 mRNA, complete cds | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 10995138 | 10995138 | PRJNA798511_P_NODE_84449_length_258_cov_0.902703_g80183_i0 | PRJNA798511 | 84449 | 258 | 0.902703 | 2.32897374 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 97.1 | 1.07e-15 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g80183 | i0 | 82.759 | 0.449612403100775 | 116 | 13 | 43 | 5 | 5 | 114 | 10516 | 10402 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 116 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 13543390 | 13543390 | PRJNA798511_P_NODE_15151_length_1061_cov_11.049595_g11767_i0 | PRJNA798511 | 15151 | 1061 | 11.049595 | 117.23620295 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 424 | 1.98e-113 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g11767 | i0 | 81.973 | 36.7954759660697 | 527 | 70 | 49 | 21 | 540 | 1057 | 11280 | 11790 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 39040 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 22466663 | 22466663 | PRJNA798511_P_NODE_100778_length_242_cov_1.366864_g96512_i0 | PRJNA798511 | 100778 | 242 | 1.366864 | 3.30781088 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 108 | 4.59e-19 | NTclustered | gi|213959396|gb|FJ426630.1| | 396692 | g96512 | i0 | 76.991 | 10.4917355371901 | 226 | 29 | 93 | 12 | 18 | 242 | 140 | 343 | Brachionus angularis voucher S. H. Cheng 001 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 2539 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 23743447 | 23743447 | PRJNA798511_P_NODE_55999_length_331_cov_5.775194_g51733_i0 | PRJNA798511 | 55999 | 331 | 5.775194 | 19.11589214 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 244 | 4.79e-60 | NTclustered | gi|213959403|gb|FJ426637.1| | 204736 | g51733 | i0 | 81.672 | 62.1631419939577 | 311 | 41 | 92 | 14 | 29 | 331 | 3 | 305 | Brachionus urceolaris voucher S. H. Cheng 008 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 20576 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris |
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);;