contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA602115" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8795693 | 8795693 | PRJNA602115_P_NODE_1607_length_469_cov_4.144608_g1582_i0 | PRJNA602115 | 1607 | 469 | 4.144608 | 19.43821152 | Ploima | 84394 | Rotifera | other_Eukaryota | 291 | 8.88e-74 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g1582 | i0 | 78.696 | 10.2430703624733 | 460 | 81 | 96 | 16 | 1 | 452 | 12070 | 12520 | Proales similis mitochondrion, complete genome | blastn | 4804 | 292 | 0.996575342465753 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 16445586 | 16445586 | PRJNA602115_P_NODE_3193_length_340_cov_1.129032_g3168_i0 | PRJNA602115 | 3193 | 340 | 1.129032 | 3.8387088 | Ploima | 84394 | Rotifera | other_Eukaryota | 303 | 8.03e-78 | NTclustered | gi|401880285|gb|JX216710.1| | 1225247 | g3168 | i0 | 83.434 | 94.9205882352941 | 332 | 49 | 97 | 5 | 11 | 339 | 660 | 332 | Lecane ohioensis voucher ECOCHZ-AG0714 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 32273 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane ohioensis | |
| 25369195 | 25369195 | PRJNA602115_P_NODE_1280_length_522_cov_2.221258_g1255_i0 | PRJNA602115 | 1280 | 522 | 2.221258 | 11.59496676 | Brachionus | 10194 | Rotifera | other_Eukaryota | 405 | 3.41e-108 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g1255 | i0 | 82.093 | 72.9827586206897 | 497 | 67 | 93 | 18 | 30 | 517 | 11343 | 11826 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 38097 | 407 | 0.995085995085995 | 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);;