contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3389227 | 3389227 | PRJNA849822_P_NODE_14903_length_377_cov_1.282895_g14729_i0 | PRJNA849822 | 14903 | 377 | 1.282895 | 4.83651415 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 697 | 0 | NTclustered | gi|2560551729|gb|OR418642.1| | 2697049 | g14729 | i0 | 100 | 100 | 377 | 0 | 100 | 0 | 1 | 377 | 6182 | 6558 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CA-LACPHL-AY00896/2022 ORF1ab polyprotein (ORF1ab), ORF1a polyprotein (ORF1ab), surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), ORF7b (ORF7b), ORF8 protein (ORF8), nucleocapsid phosphoprotein (N), and ORF10 protein (ORF10) genes, complete cds | blastn | 37700 | 697 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 4666936 | 4666936 | PRJNA849822_P_NODE_10604_length_457_cov_1.510417_g10431_i0 | PRJNA849822 | 10604 | 457 | 1.510417 | 6.90260569 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 845 | 0 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g10431 | i0 | 100 | 100 | 457 | 0 | 100 | 0 | 1 | 457 | 18123 | 18579 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 45700 | 845 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 7216723 | 7216723 | PRJNA849822_P_NODE_24826_length_291_cov_1.362385_g24652_i0 | PRJNA849822 | 24826 | 291 | 1.362385 | 3.96454035 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 538 | 1.6999999999999994e-148 | NTclustered | gi|2105696498|gb|OK358740.1| | 2697049 | g24652 | i0 | 100 | 100 | 291 | 0 | 100 | 0 | 1 | 291 | 9591 | 9881 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/TX-DSHS-9158/2021 ORF1ab polyprotein (ORF1ab), ORF1a polyprotein (ORF1ab), surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), and ORF6 protein (ORF6) genes, complete cds; ORF7a protein (ORF7a) and ORF7b (ORF7b) genes, partial cds; ORF8 gene, complete sequence; and nucleocapsid phosphoprotein (N) and ORF10 protein (ORF10) genes, complete cds | blastn | 29100 | 538 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 7216741 | 7216741 | PRJNA849822_P_NODE_26_length_4288_cov_2.997628_g24_i0 | PRJNA849822 | 26 | 4288 | 2.997628 | 128.53828864 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 5304 | 0 | NTclustered | gi|2273760991|gb|OL472250.1| | 12188 | g24 | i0 | 88.995 | 22.9221082089552 | 4289 | 470 | 100 | 2 | 1 | 4288 | 3 | 4290 | MAG: White clover mosaic virus isolate TUR20SW polyprotein, 25 kDa triple gene block protein 1, 12 kDa triple gene block protein 2, and 7 kDa triple gene block protein 3 genes, complete cds; and coat protein gene, partial cds | blastn | 98290 | 5304 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 7216770 | 7216770 | PRJNA849822_P_NODE_31446_length_261_cov_1.015957_g31272_i0 | PRJNA849822 | 31446 | 261 | 1.015957 | 2.65164777 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 483 | 7.12e-132 | NTclustered | gi|2316342856|gb|OP624554.1| | 2697049 | g31272 | i0 | 100 | 100 | 261 | 0 | 100 | 0 | 1 | 261 | 24393 | 24133 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome | blastn | 26100 | 483 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9766700 | 9766700 | PRJNA849822_P_NODE_29428_length_269_cov_1.591837_g29254_i0 | PRJNA849822 | 29428 | 269 | 1.591837 | 4.28204153 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 497 | 2.63e-136 | NTclustered | gi|2316342856|gb|OP624554.1| | 2697049 | g29254 | i0 | 100 | 100 | 269 | 0 | 100 | 0 | 1 | 269 | 13003 | 12735 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome | blastn | 26900 | 497 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11042194 | 11042194 | PRJNA849822_P_NODE_17869_length_343_cov_0.811111_g17695_i0 | PRJNA849822 | 17869 | 343 | 0.811111 | 2.78211073 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 634 | 2.5299999999999996e-177 | NTclustered | gi|2316342856|gb|OP624554.1| | 2697049 | g17695 | i0 | 100 | 100 | 343 | 0 | 100 | 0 | 1 | 343 | 22201 | 21859 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome | blastn | 34300 | 634 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11042214 | 11042214 | PRJNA849822_P_NODE_19709_length_326_cov_1.296443_g19535_i0 | PRJNA849822 | 19709 | 326 | 1.296443 | 4.22640418 | Phlebovirus sp. | 206378 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|1997312915|gb|MW370443.1| | 206378 | g19535 | i0 | 92.105 | 0.116564417177914 | 38 | 3 | 12 | 0 | 34 | 71 | 2324 | 2361 | Phlebovirus sp. isolate SXWX1916-4 segment M membrane glycoprotein gene, complete cds | blastn | 38 | 54.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Phlebovirus | Phlebovirus sp. | ||
| 14866617 | 14866617 | PRJNA849822_P_NODE_28272_length_274_cov_3.104478_g28098_i0 | PRJNA849822 | 28272 | 274 | 3.104478 | 8.50626972 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 507 | 4.47e-139 | NTclustered | gi|2028980905|gb|MZ002360.1| | 2697049 | g28098 | i0 | 100 | 100 | 274 | 0 | 100 | 0 | 1 | 274 | 3609 | 3336 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome | blastn | 27400 | 507 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18689946 | 18689946 | PRJNA849822_P_NODE_27855_length_276_cov_2.044335_g27681_i0 | PRJNA849822 | 27855 | 276 | 2.044335 | 5.6423646 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 427 | 3.61e-115 | NTclustered | gi|1078555000|dbj|LC190455.1| | 12188 | g27681 | i0 | 94.565 | 35.231884057971 | 276 | 15 | 100 | 0 | 1 | 276 | 155 | 430 | White clover mosaic virus CP gene for coat protein, complete cds, isolate: Namwon | blastn | 9724 | 427 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 18689962 | 18689962 | PRJNA849822_P_NODE_30775_length_263_cov_4.800000_g30601_i0 | PRJNA849822 | 30775 | 263 | 4.8 | 12.624 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 486 | 5.5499999999999986e-133 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g30601 | i0 | 100 | 100 | 263 | 0 | 100 | 0 | 1 | 263 | 7405 | 7143 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 26300 | 486 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 19085066 | 19085066 | PRJNA849822_P_NODE_41375_length_244_cov_0.912281_g41201_i0 | PRJNA849822 | 41375 | 244 | 0.912281 | 2.22596564 | Potyvirus | 12195 | Viruses | Viruses | 401 | 1.8999999999999998e-107 | NTclustered | gi|1735126414|gb|MK292120.1| | 12198 | g41201 | i0 | 96.311 | 22.4754098360656 | 244 | 9 | 100 | 0 | 1 | 244 | 644 | 887 | Clover yellow vein virus isolate IA-2016, complete genome | blastn | 5484 | 401 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus trifolii | ||
| 19964979 | 19964979 | PRJNA849822_P_NODE_17456_length_347_cov_1.492701_g17282_i0 | PRJNA849822 | 17456 | 347 | 1.492701 | 5.17967247 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 641 | 1.5299999999999996e-179 | NTclustered | gi|2316342856|gb|OP624554.1| | 2697049 | g17282 | i0 | 100 | 100 | 347 | 0 | 100 | 0 | 1 | 347 | 23899 | 23553 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome | blastn | 34700 | 641 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 19965086 | 19965086 | PRJNA849822_P_NODE_30676_length_264_cov_1.345550_g30502_i0 | PRJNA849822 | 30676 | 264 | 1.34555 | 3.552252 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 483 | 7.219999999999998e-132 | NTclustered | gi|2316342856|gb|OP624554.1| | 2697049 | g30502 | i0 | 99.621 | 100 | 264 | 1 | 100 | 0 | 1 | 264 | 20196 | 19933 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome | blastn | 26400 | 483 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 19965089 | 19965089 | PRJNA849822_P_NODE_31056_length_262_cov_1.603175_g30882_i0 | PRJNA849822 | 31056 | 262 | 1.603175 | 4.2003185 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 484 | 1.99e-132 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g30882 | i0 | 100 | 100 | 262 | 0 | 100 | 0 | 1 | 262 | 25691 | 25952 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 26200 | 484 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 21240696 | 21240696 | PRJNA849822_P_NODE_31177_length_262_cov_1.121693_g31003_i0 | PRJNA849822 | 31177 | 262 | 1.121693 | 2.93883566 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 479 | 9.249999999999999e-131 | NTclustered | gi|2529113455|emb|OY166144.1| | 2697049 | g31003 | i0 | 99.618 | 99.9923664122137 | 262 | 1 | 100 | 0 | 1 | 262 | 17793 | 18054 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 26198 | 479 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 22911143 | 22911143 | PRJNA849822_P_NODE_36038_length_250_cov_0.881356_g35864_i0 | PRJNA849822 | 36038 | 250 | 0.881356 | 2.20339 | Cucumovirus | 12304 | Viruses | Viruses | 359 | 1.19e-94 | NTclustered | gi|124294729|gb|EF202595.1| | 12305 | g35864 | i0 | 92.742 | 99.2 | 248 | 18 | 99 | 0 | 3 | 250 | 354 | 107 | Cucumber mosaic virus isolate Tsh segment RNA1, complete sequence | blastn | 24800 | 359 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus CMV | ||
| 23790719 | 23790719 | PRJNA849822_P_NODE_10219_length_467_cov_2.274112_g10046_i0 | PRJNA849822 | 10219 | 467 | 2.274112 | 10.62010304 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 863 | 0 | NTclustered | gi|2316342856|gb|OP624554.1| | 2697049 | g10046 | i0 | 100 | 100 | 467 | 0 | 100 | 0 | 1 | 467 | 23448 | 22982 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome | blastn | 46700 | 863 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23790827 | 23790827 | PRJNA849822_P_NODE_22379_length_306_cov_2.004292_g22205_i0 | PRJNA849822 | 22379 | 306 | 2.004292 | 6.13313352 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 566 | 8.239999999999998e-157 | NTclustered | gi|2028980905|gb|MZ002360.1| | 2697049 | g22205 | i0 | 100 | 100 | 306 | 0 | 100 | 0 | 1 | 306 | 8847 | 8542 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome | blastn | 30600 | 566 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23790889 | 23790889 | PRJNA849822_P_NODE_29899_length_267_cov_1.608247_g29725_i0 | PRJNA849822 | 29899 | 267 | 1.608247 | 4.29401949 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 494 | 3.38e-135 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g29725 | i0 | 100 | 100 | 267 | 0 | 100 | 0 | 1 | 267 | 1897 | 2163 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 26700 | 494 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 25064761 | 25064761 | PRJNA849822_P_NODE_2380_length_1067_cov_2.573441_g2254_i0 | PRJNA849822 | 2380 | 1067 | 2.573441 | 27.45861547 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 1352 | 0 | NTclustered | gi|1843793423|gb|MN399742.1| | 12188 | g2254 | i0 | 89.493 | 24.0552952202437 | 1066 | 108 | 99 | 4 | 1 | 1064 | 4225 | 5288 | White clover mosaic virus isolate Kreis Stormarn_18 RNA replication protein, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds | blastn | 25667 | 1352 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii |
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);;