contig_metadata
5 rows where bioproject = "PRJNA1067443" and tax_kingdom = "Orthornavirae"
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 | |||
| 15484458 | 15484458 | PRJNA1067443_P_NODE_9333_length_289_cov_6.555556_g9315_i0 | PRJNA1067443 | 9333 | 289 | 6.555556 | 18.94555684 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 52.8 | 0.027 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g9315 | i0 | 100 | 0.0968858131487889 | 28 | 0 | 10 | 0 | 262 | 289 | 41 | 14 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 23133880 | 23133880 | PRJNA1067443_P_NODE_23939_length_227_cov_2.487013_g23921_i0 | PRJNA1067443 | 23939 | 227 | 2.487013 | 5.64551951 | Sopidub virus | 3131684 | Viruses | Viruses | 115 | 2.54e-21 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g23921 | i0 | 93.506 | 15.4273127753304 | 77 | 5 | 34 | 0 | 1 | 77 | 2202 | 2126 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 3502 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus |
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);;