contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA745923" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724946 | 724946 | PRJNA745923_S_NODE_40021_length_150_cov_2.242991_g39689_i0 | PRJNA745923 | 40021 | 150 | 2.242991 | 3.3644865 | Pestivirus tauri | 3052626 | Viruses | Viruses | 267 | 4.009999999999999e-67 | NTclustered | gi|1540352871|gb|MH231127.1| | 54315 | g39689 | i0 | 98.667 | 99.7066666666667 | 150 | 2 | 100 | 0 | 1 | 150 | 2231 | 2380 | Bovine viral diarrhea virus 2 isolate 53637c polyprotein gene, complete cds | blastn | 14956 | 267 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus tauri | ||
| 4553228 | 4553228 | PRJNA745923_S_NODE_23284_length_201_cov_1.518987_g22952_i0 | PRJNA745923 | 23284 | 201 | 1.518987 | 3.05316387 | Pestivirus bovis | 3052619 | Viruses | Viruses | 342 | 9.259999999999999e-90 | NTclustered | gi|2625903273|gb|ON676187.1| | 11099 | g22952 | i0 | 97.5 | 99.4427860696517 | 200 | 5 | 99 | 0 | 1 | 200 | 3707 | 3508 | Bovine viral diarrhea virus 1 strain Chilgok, complete genome | blastn | 19988 | 342 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 4553235 | 4553235 | PRJNA745923_S_NODE_23664_length_199_cov_2.378205_g23332_i0 | PRJNA745923 | 23664 | 199 | 2.378205 | 4.73262795 | Pestivirus bovis | 3052619 | Viruses | Viruses | 296 | 7.23e-76 | NTclustered | gi|49614511|dbj|AB105677.1| | 11099 | g23332 | i0 | 93.467 | 61.2361809045226 | 199 | 13 | 100 | 0 | 1 | 199 | 149 | 347 | Bovine viral diarrhea virus 1 gene for structural glycoprotein E2, partial cds, isolate: AK Higashiyuri NCP/96 | blastn | 12186 | 296 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 10928923 | 10928923 | PRJNA745923_S_NODE_4789_length_515_cov_2.682203_g4466_i0 | PRJNA745923 | 4789 | 515 | 2.682203 | 13.81334545 | Pestivirus bovis | 3052619 | Viruses | Viruses | 863 | 0 | NTclustered | gi|2858850717|gb|PQ613792.1| | 11099 | g4466 | i0 | 96.893 | 97.7941747572816 | 515 | 16 | 100 | 0 | 1 | 515 | 43 | 557 | Bovine viral diarrhea virus 1 isolate USMARC/PI-91-21/MDBK polyprotein gene, complete cds | blastn | 50364 | 863 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 16027474 | 16027474 | PRJNA745923_S_NODE_32553_length_166_cov_2.203252_g32221_i0 | PRJNA745923 | 32553 | 166 | 2.203252 | 3.65739832 | Pestivirus bovis | 3052619 | Viruses | Viruses | 291 | 2.7099999999999998e-74 | NTclustered | gi|1129880259|gb|KX170497.1| | 11099 | g32221 | i0 | 98.193 | 99.8192771084337 | 166 | 3 | 100 | 0 | 1 | 166 | 178 | 13 | Bovine viral diarrhea virus 1 isolate V045 NS4A gene, partial cds | blastn | 16570 | 291 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 17302966 | 17302966 | PRJNA745923_S_NODE_35594_length_158_cov_1.669565_g35262_i0 | PRJNA745923 | 35594 | 158 | 1.669565 | 2.6379127000000002 | Pestivirus bovis | 3052619 | Viruses | Viruses | 276 | 7.120000000000001e-70 | NTclustered | gi|800924328|gb|KP941589.1| | 11099 | g35262 | i0 | 98.101 | 99.8607594936709 | 158 | 3 | 100 | 0 | 1 | 158 | 10350 | 10193 | Bovine viral diarrhea virus 1 strain USMARC-55923 polyprotein gene, complete cds | blastn | 15778 | 276 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 19050574 | 19050574 | PRJNA745923_S_NODE_14175_length_268_cov_4.271111_g13843_i0 | PRJNA745923 | 14175 | 268 | 4.271111 | 11.44657748 | Pestivirus | 11095 | Viruses | Viruses | 440 | 4.479999999999998e-119 | NTclustered | gi|2625903273|gb|ON676187.1| | 11099 | g13843 | i0 | 96.269 | 99.9813432835821 | 268 | 10 | 100 | 0 | 1 | 268 | 9431 | 9698 | Bovine viral diarrhea virus 1 strain Chilgok, complete genome | blastn | 26795 | 440 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 19050665 | 19050665 | PRJNA745923_S_NODE_27435_length_183_cov_1.642857_g27103_i0 | PRJNA745923 | 27435 | 183 | 1.642857 | 3.00642831 | Pestivirus | 11095 | Viruses | Viruses | 300 | 5.040000000000001e-77 | NTclustered | gi|2625903273|gb|ON676187.1| | 11099 | g27103 | i0 | 96.175 | 99.1584699453552 | 183 | 7 | 100 | 0 | 1 | 183 | 4720 | 4902 | Bovine viral diarrhea virus 1 strain Chilgok, complete genome | blastn | 18146 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 20325364 | 20325364 | PRJNA745923_S_NODE_28996_length_177_cov_2.149254_g28664_i0 | PRJNA745923 | 28996 | 177 | 2.149254 | 3.80417958 | Pestivirus | 11095 | Viruses | Viruses | 305 | 1.04e-78 | NTclustered | gi|2731951075|gb|PP770551.1| | 11099 | g28664 | i0 | 97.74 | 99.774011299435 | 177 | 4 | 100 | 0 | 1 | 177 | 9897 | 10073 | Bovine viral diarrhea virus 1 isolate YN2-11/2023, complete genome | blastn | 17660 | 305 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 23677778 | 23677778 | PRJNA745923_S_NODE_26939_length_185_cov_1.352113_g26607_i0 | PRJNA745923 | 26939 | 185 | 1.352113 | 2.50140905 | Pestivirus bovis | 3052619 | Viruses | Viruses | 298 | 1.84e-76 | NTclustered | gi|1129880365|gb|KX170550.1| | 11099 | g26607 | i0 | 95.676 | 99.972972972973 | 185 | 8 | 100 | 0 | 1 | 185 | 574 | 390 | Bovine viral diarrhea virus 1 isolate V048 NS4B gene, partial cds | blastn | 18495 | 298 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis |
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);;