contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA832865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4650538 | 4650538 | PRJNA832865_S_NODE_108364_length_242_cov_1.366864_g103278_i0 | PRJNA832865 | 108364 | 242 | 1.366864 | 3.30781088 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 108 | 4.59e-19 | NTclustered | gi|213959396|gb|FJ426630.1| | 396692 | g103278 | 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 | |
| 12301563 | 12301563 | PRJNA832865_S_NODE_14670_length_1068_cov_9.867337_g10845_i0 | PRJNA832865 | 14670 | 1068 | 9.867337 | 105.38315916 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 418 | 9.289999999999999e-112 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g10845 | i0 | 81.87 | 36.4588014981273 | 524 | 70 | 48 | 21 | 540 | 1054 | 11280 | 11787 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 38938 | 418 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 19949551 | 19949551 | PRJNA832865_S_NODE_38736_length_430_cov_1.439776_g33651_i0 | PRJNA832865 | 38736 | 430 | 1.439776 | 6.1910368 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 52.8 | 0.041 | NTclustered | gi|2029759104|gb|MW026556.1| | 396692 | g33651 | 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 | |
| 21225938 | 21225938 | PRJNA832865_S_NODE_89617_length_258_cov_0.902703_g84531_i0 | PRJNA832865 | 89617 | 258 | 0.902703 | 2.32897374 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 97.1 | 1.07e-15 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g84531 | 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 | |
| 22906196 | 22906196 | PRJNA832865_S_NODE_46798_length_374_cov_5.083056_g41712_i0 | PRJNA832865 | 46798 | 374 | 5.083056 | 19.01062944 | Brachionus | 10194 | Rotifera | other_Eukaryota | 287 | 8.960000000000001e-73 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g41712 | i0 | 81.402 | 69.3689839572193 | 371 | 51 | 97 | 14 | 1 | 362 | 11269 | 11630 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 25944 | 287 | 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);;