contig_metadata
3 rows where bioproject = "PRJNA1067443", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6116761 | 6116761 | PRJNA1067443_P_NODE_945_length_581_cov_7.732283_g927_i0 | PRJNA1067443 | 945 | 581 | 7.732283 | 44.92456423 | Pestivirus | 11095 | Viruses | Viruses | 946 | 0 | NTclustered | gi|2905035932|gb|PQ782225.1| | 11099 | g927 | i0 | 96.041 | 90.6230636833047 | 581 | 23 | 100 | 0 | 1 | 581 | 7214 | 6634 | Bovine viral diarrhea virus 1 isolate BVDV-1m-IM-2018, complete genome | blastn | 52652 | 952 | 0.993697478991597 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 10384592 | 10384592 | PRJNA1067443_P_NODE_1069_length_564_cov_41.763747_g1051_i0 | PRJNA1067443 | 1069 | 564 | 41.763747 | 235.54753308 | Pestivirus bovis | 3052619 | Viruses | Viruses | 896 | 0 | NTclustered | gi|800924328|gb|KP941589.1| | 11099 | g1051 | i0 | 96.66 | 95.5656028368794 | 539 | 18 | 96 | 0 | 1 | 539 | 10709 | 10171 | Bovine viral diarrhea virus 1 strain USMARC-55923 polyprotein gene, complete cds | blastn | 53899 | 896 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 11660366 | 11660366 | PRJNA1067443_P_NODE_890_length_589_cov_14.143411_g872_i0 | PRJNA1067443 | 890 | 589 | 14.143411 | 83.30469079 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.016 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g872 | i0 | 100 | 0.0492359932088285 | 29 | 0 | 5 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 |
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);;