contig_metadata
18 rows where bioproject = "PRJEB7799" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25528232 | 25528232 | PRJEB7799m_S_NODE_753_length_217_cov_1.241758_g748_i0 | PRJEB7799 | 753 | 217 | 1.241758 | 2.69461486 | Hainan alphaflexivirus 2 | 2824425 | Viruses | Viruses | 315 | 2.21e-81 | NTclustered | gi|2075444288|gb|MW897284.1| | 2824425 | g748 | i0 | 95.431 | 61.6774193548387 | 197 | 9 | 91 | 0 | 21 | 217 | 4636 | 4440 | MAG: Hainan alphaflexivirus 2 isolate R87-k141_314575 replicase gene, partial cds; and NTP-binding helicase and hypothetical protein genes, complete cds | blastn | 13384 | 315 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Hainan alphaflexivirus 2 | |||
| 25529078 | 25529078 | PRJEB7799p_S_NODE_2737_length_288_cov_3.861660_g2714_i0 | PRJEB7799 | 2737 | 288 | 3.86166 | 11.1215808 | Mitovirus sp. | 2587224 | Viruses | Viruses | 174 | 5.45e-39 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g2714 | i0 | 94.643 | 3.26041666666667 | 112 | 6 | 39 | 0 | 172 | 283 | 112 | 1 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 939 | 174 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 25662250 | 25662250 | PRJEB7799a_S_NODE_5674_length_215_cov_31.927778_g5639_i0 | PRJEB7799 | 5674 | 215 | 31.927778 | 68.6447227 | Chrocagost virus | 3129398 | Viruses | Viruses | 248 | 2.25e-61 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g5639 | i0 | 88.67 | 132.083720930233 | 203 | 23 | 94 | 0 | 1 | 203 | 5660 | 5862 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 28398 | 248 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 25662453 | 25662453 | PRJEB7799b_S_NODE_2586_length_172_cov_5.430657_g2585_i0 | PRJEB7799 | 2586 | 172 | 5.430657 | 9.34073004 | Nilaparvata lugens C virus | 1577072 | Viruses | Viruses | 115 | 1.81e-21 | NTclustered | gi|726973360|gb|KM270560.1| | 1577072 | g2585 | i0 | 85.714 | 9.90697674418605 | 112 | 13 | 63 | 2 | 33 | 141 | 9159 | 9048 | Nilaparvata lugens C virus, complete genome | blastn | 1704 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Nilaparvata lugens C virus | ||
| 25662507 | 25662507 | PRJEB7799c_S_NODE_1658_length_277_cov_3.061983_g1635_i0 | PRJEB7799 | 1658 | 277 | 3.061983 | 8.48169291 | Nilaparvata lugens C virus | 1577072 | Viruses | Viruses | 117 | 8.91e-22 | NTclustered | gi|726973360|gb|KM270560.1| | 1577072 | g1635 | i0 | 85.841 | 6.13357400722022 | 113 | 12 | 39 | 3 | 14 | 122 | 9160 | 9048 | Nilaparvata lugens C virus, complete genome | blastn | 1699 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Nilaparvata lugens C virus | ||
| 25663990 | 25663990 | PRJEB7799l_S_NODE_5418_length_209_cov_199.218391_g5389_i0 | PRJEB7799 | 5418 | 209 | 199.218391 | 416.36643719 | Severe acute respiratory syndrome coronavirus 2 | 2697049 | Viruses | Viruses | 71.3 | 5.06e-8 | NTclustered | gi|2557633336|emb|OY694998.1| | 2697049 | g5389 | i0 | 100 | 19.4832535885167 | 38 | 0 | 18 | 0 | 1 | 38 | 19687 | 19650 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4072 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 25799187 | 25799187 | PRJEB7799f_S_NODE_187_length_447_cov_13.997573_g173_i0 | PRJEB7799 | 187 | 447 | 13.997573 | 62.56915131 | Nilaparvata lugens C virus | 1577072 | Viruses | Viruses | 117 | 1.51e-21 | NTclustered | gi|726973360|gb|KM270560.1| | 1577072 | g173 | i0 | 85.841 | 3.80089485458613 | 113 | 12 | 24 | 3 | 305 | 413 | 9048 | 9160 | Nilaparvata lugens C virus, complete genome | blastn | 1699 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Nilaparvata lugens C virus | ||
| 25799703 | 25799703 | PRJEB7799j_S_NODE_419_length_225_cov_72.084211_g414_i0 | PRJEB7799 | 419 | 225 | 72.084211 | 162.18947475 | Severe acute respiratory syndrome coronavirus 2 | 2697049 | Viruses | Viruses | 60.2 | 1.2e-4 | NTclustered | gi|2560518070|emb|OY703170.1| | 2697049 | g414 | i0 | 97.143 | 13.3333333333333 | 35 | 1 | 16 | 0 | 1 | 35 | 18468 | 18434 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3000 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 25799747 | 25799747 | PRJEB7799l_S_NODE_1059_length_377_cov_584.058480_g1030_i0 | PRJEB7799 | 1059 | 377 | 584.05848 | 2201.9004696 | Nilaparvata lugens C virus | 1577072 | Viruses | Viruses | 115 | 4.51e-21 | NTclustered | gi|726973360|gb|KM270560.1| | 1577072 | g1030 | i0 | 85.714 | 4.49867374005305 | 112 | 12 | 29 | 3 | 13 | 120 | 9159 | 9048 | Nilaparvata lugens C virus, complete genome | blastn | 1696 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Nilaparvata lugens C virus | ||
| 25800949 | 25800949 | PRJEB7799p_S_NODE_1523_length_349_cov_13.079618_g1500_i0 | PRJEB7799 | 1523 | 349 | 13.079618 | 45.64786682 | Nilaparvata lugens C virus | 1577072 | Viruses | Viruses | 119 | 3.2000000000000003e-22 | NTclustered | gi|726973360|gb|KM270560.1| | 1577072 | g1500 | i0 | 86.486 | 4.85100286532951 | 111 | 12 | 31 | 2 | 226 | 333 | 9048 | 9158 | Nilaparvata lugens C virus, complete genome | blastn | 1693 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Nilaparvata lugens C virus | ||
| 25937119 | 25937119 | PRJEB7799p_S_NODE_1388_length_358_cov_1660.938080_g1365_i0 | PRJEB7799 | 1388 | 358 | 1660.93808 | 5946.1583264 | Severe acute respiratory syndrome coronavirus 2 | 2697049 | Viruses | Viruses | 73.1 | 2.6e-8 | NTclustered | gi|2565357930|emb|OY628901.1| | 2697049 | g1365 | i0 | 100 | 11.0139664804469 | 39 | 0 | 11 | 0 | 306 | 344 | 9639 | 9677 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3943 | 73.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 25937192 | 25937192 | PRJEB7799p_S_NODE_1716_length_336_cov_1781.395349_g1693_i0 | PRJEB7799 | 1716 | 336 | 1781.395349 | 5985.48837264 | Severe acute respiratory syndrome coronavirus 2 | 2697049 | Viruses | Viruses | 73.1 | 2.43e-8 | NTclustered | gi|2565357930|emb|OY628901.1| | 2697049 | g1693 | i0 | 100 | 11.735119047619 | 39 | 0 | 12 | 0 | 284 | 322 | 9639 | 9677 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3943 | 73.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 25937491 | 25937491 | PRJEB7799p_S_NODE_3412_length_267_cov_2007.400862_g3389_i0 | PRJEB7799 | 3412 | 267 | 2007.400862 | 5359.76030154 | Severe acute respiratory syndrome coronavirus 2 | 2697049 | Viruses | Viruses | 73.1 | 1.88e-8 | NTclustered | gi|2565357930|emb|OY628901.1| | 2697049 | g3389 | i0 | 100 | 14.7153558052434 | 39 | 0 | 15 | 0 | 15 | 53 | 9677 | 9639 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3929 | 73.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 26024828 | 26024828 | PRJEB7799a_S_NODE_3804_length_244_cov_846.114833_g3769_i0 | PRJEB7799 | 3804 | 244 | 846.114833 | 2064.52019252 | Viruses | 10239 | Viruses | Viruses | 71.3 | 6.08e-8 | NTclustered | gi|2165832904|emb|OV195202.1| | 2697049 | g3769 | i0 | 100 | 16.3975409836066 | 38 | 0 | 16 | 0 | 207 | 244 | 30028 | 30065 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 4001 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 26071465 | 26071465 | PRJEB7799g_S_NODE_405_length_400_cov_239.235616_g189_i0 | PRJEB7799 | 405 | 400 | 239.235616 | 956.942464 | Severe acute respiratory syndrome coronavirus 2 | 2697049 | Viruses | Viruses | 71.3 | 1.06e-7 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g189 | i0 | 92 | 9.055 | 50 | 4 | 13 | 0 | 349 | 398 | 29915 | 29964 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3622 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 26207400 | 26207400 | PRJEB7799d_S_NODE_270_length_410_cov_12.010667_g260_i0 | PRJEB7799 | 270 | 410 | 12.010667 | 49.2437347 | Nilaparvata lugens C virus | 1577072 | Viruses | Viruses | 115 | 4.95e-21 | NTclustered | gi|726973360|gb|KM270560.1| | 1577072 | g260 | i0 | 85.714 | 4.13658536585366 | 112 | 12 | 26 | 3 | 22 | 129 | 9159 | 9048 | Nilaparvata lugens C virus, complete genome | blastn | 1696 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Nilaparvata lugens C virus | ||
| 26207782 | 26207782 | PRJEB7799g_S_NODE_1854_length_213_cov_9.994382_g1638_i0 | PRJEB7799 | 1854 | 213 | 9.994382 | 21.28803366 | Nilaparvata lugens C virus | 1577072 | Viruses | Viruses | 113 | 8.480000000000001e-21 | NTclustered | gi|726973360|gb|KM270560.1| | 1577072 | g1638 | i0 | 85.586 | 7.94835680751174 | 111 | 12 | 50 | 3 | 87 | 193 | 9048 | 9158 | Nilaparvata lugens C virus, complete genome | blastn | 1693 | 113 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Nilaparvata lugens C virus | ||
| 26208447 | 26208447 | PRJEB7799l_S_NODE_2510_length_276_cov_302.323651_g2481_i0 | PRJEB7799 | 2510 | 276 | 302.323651 | 834.41327676 | Brassica yellows virus | 1046403 | Viruses | Viruses | 113 | 1.15e-20 | NTclustered | gi|2461860523|dbj|LC726803.1| | 1046403 | g2481 | i0 | 97.015 | 24.5036231884058 | 67 | 2 | 24 | 0 | 1 | 67 | 1134 | 1068 | Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein | blastn | 6763 | 113 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Polerovirus | Polerovirus TUYV |
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);;