contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1101946" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1485955 | 1485955 | PRJNA1101946_S_NODE_6882_length_282_cov_5.278970_g6783_i0 | PRJNA1101946 | 6882 | 282 | 5.27897 | 14.8866954 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 427 | 3.7e-115 | NTclustered | gi|2813517655|gb|PQ362005.1| | 381707 | g6783 | i0 | 96.863 | 27.6382978723404 | 255 | 8 | 90 | 0 | 1 | 255 | 10053 | 10307 | Bovine viral diarrhea virus 3 isolate HN2247, partial genome | blastn | 7794 | 427 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 2761939 | 2761939 | PRJNA1101946_S_NODE_14643_length_210_cov_6.850932_g14544_i0 | PRJNA1101946 | 14643 | 210 | 6.850932 | 14.3869572 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g14544 | i0 | 100 | 0.671428571428571 | 29 | 0 | 14 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 4038015 | 4038015 | PRJNA1101946_S_NODE_5504_length_303_cov_2.425197_g5405_i0 | PRJNA1101946 | 5504 | 303 | 2.425197 | 7.34834691 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g5405 | i0 | 100 | 0.0924092409240924 | 28 | 0 | 9 | 0 | 1 | 28 | 14 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 4038028 | 4038028 | PRJNA1101946_S_NODE_8064_length_268_cov_4.105023_g7965_i0 | PRJNA1101946 | 8064 | 268 | 4.105023 | 11.00146164 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g7965 | i0 | 100 | 0.529850746268657 | 30 | 0 | 11 | 0 | 1 | 30 | 13 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 6589394 | 6589394 | PRJNA1101946_S_NODE_4086_length_328_cov_6.150538_g3987_i0 | PRJNA1101946 | 4086 | 328 | 6.150538 | 20.17376464 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 573 | 5.329999999999998e-159 | NTclustered | gi|2813517653|gb|PQ362004.1| | 381707 | g3987 | i0 | 98.171 | 30.9298780487805 | 328 | 6 | 100 | 0 | 1 | 328 | 9865 | 9538 | Bovine viral diarrhea virus 3 isolate HN2168, partial genome | blastn | 10145 | 573 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 6589407 | 6589407 | PRJNA1101946_S_NODE_6646_length_285_cov_6.177966_g6547_i0 | PRJNA1101946 | 6646 | 285 | 6.177966 | 17.6072031 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 494 | 3.64e-135 | NTclustered | gi|2813517649|gb|PQ362002.1| | 381707 | g6547 | i0 | 97.895 | 29.9754385964912 | 285 | 6 | 100 | 0 | 1 | 285 | 8166 | 7882 | Bovine viral diarrhea virus 3 isolate HN2009, partial genome | blastn | 8543 | 494 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 7863943 | 7863943 | PRJNA1101946_S_NODE_10667_length_241_cov_3.890625_g10568_i0 | PRJNA1101946 | 10667 | 241 | 3.890625 | 9.37640625 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 409 | 1.12e-109 | NTclustered | gi|1569124192|gb|MH410816.1| | 381707 | g10568 | i0 | 97.49 | 28.6514522821577 | 239 | 6 | 99 | 0 | 1 | 239 | 4337 | 4575 | Bovine viral diarrhea virus 3 isolate LV03/12, complete genome | blastn | 6905 | 409 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 9138875 | 9138875 | PRJNA1101946_S_NODE_18928_length_185_cov_2.867647_g18829_i0 | PRJNA1101946 | 18928 | 185 | 2.867647 | 5.30514695 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g18829 | i0 | 100 | 0.762162162162162 | 29 | 0 | 16 | 0 | 157 | 185 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 15513888 | 15513888 | PRJNA1101946_S_NODE_13153_length_221_cov_3.761628_g13054_i0 | PRJNA1101946 | 13153 | 221 | 3.761628 | 8.31319788 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g13054 | i0 | 100 | 0.638009049773756 | 29 | 0 | 13 | 0 | 193 | 221 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 15513943 | 15513943 | PRJNA1101946_S_NODE_8793_length_260_cov_2.658768_g8694_i0 | PRJNA1101946 | 8793 | 260 | 2.658768 | 6.9127968 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 420 | 5.64e-113 | NTclustered | gi|2813517649|gb|PQ362002.1| | 381707 | g8694 | i0 | 95.769 | 28.9576923076923 | 260 | 11 | 100 | 0 | 1 | 260 | 4925 | 4666 | Bovine viral diarrhea virus 3 isolate HN2009, partial genome | blastn | 7529 | 420 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 15513945 | 15513945 | PRJNA1101946_S_NODE_9133_length_256_cov_3.942029_g9034_i0 | PRJNA1101946 | 9133 | 256 | 3.942029 | 10.09159424 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 435 | 1.98e-117 | NTclustered | gi|2813517649|gb|PQ362002.1| | 381707 | g9034 | i0 | 97.266 | 30.5703125 | 256 | 7 | 100 | 0 | 1 | 256 | 2532 | 2277 | Bovine viral diarrhea virus 3 isolate HN2009, partial genome | blastn | 7826 | 435 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 19337073 | 19337073 | PRJNA1101946_S_NODE_1796_length_408_cov_4.986072_g1697_i0 | PRJNA1101946 | 1796 | 408 | 4.986072 | 20.34317376 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 662 | 0 | NTclustered | gi|2624695972|gb|OR827365.1| | 381707 | g1697 | i0 | 96.278 | 29.9583333333333 | 403 | 15 | 99 | 0 | 1 | 403 | 8935 | 9337 | Bovine viral diarrhea virus 3 isolate CNIM-2201, partial genome | blastn | 12223 | 662 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 20612475 | 20612475 | PRJNA1101946_S_NODE_2877_length_359_cov_5.370968_g2778_i0 | PRJNA1101946 | 2877 | 359 | 5.370968 | 19.28177512 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 608 | 1.609999999999999e-169 | NTclustered | gi|2624695972|gb|OR827365.1| | 381707 | g2778 | i0 | 97.214 | 30.8941504178273 | 359 | 10 | 100 | 0 | 1 | 359 | 9293 | 8935 | Bovine viral diarrhea virus 3 isolate CNIM-2201, partial genome | blastn | 11091 | 608 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 22696845 | 22696845 | PRJNA1101946_S_NODE_20738_length_177_cov_1.335938_g20639_i0 | PRJNA1101946 | 20738 | 177 | 1.335938 | 2.36461026 | Pestivirus | 11095 | Viruses | Viruses | 263 | 6.349999999999999e-66 | NTclustered | gi|56067118|gb|AY735486.1| | 266829 | g20639 | i0 | 98.649 | 74.3276836158192 | 148 | 2 | 84 | 0 | 24 | 171 | 324 | 471 | Pestivirus strain D32/00_HoBi nonstructural protein (Npro) gene, partial cds | blastn | 13156 | 263 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 24437170 | 24437170 | PRJNA1101946_S_NODE_2960_length_357_cov_2.649351_g2861_i0 | PRJNA1101946 | 2960 | 357 | 2.649351 | 9.45818307 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g2861 | i0 | 100 | 0.394957983193277 | 29 | 0 | 8 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi |
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);;