contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA631796" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6981840 | 6981840 | PRJNA631796_P_NODE_1426_length_602_cov_5.144177_g1162_i0 | PRJNA631796 | 1426 | 602 | 5.144177 | 30.96794554 | Apis mellifera associated ourmia-like virus 1 | 3373666 | Viruses | Viruses | 481 | 6.41e-131 | NTclustered | gi|2837369257|gb|PQ408677.1| | 3373666 | g1162 | i0 | 81.24 | 2.97840531561462 | 613 | 99 | 100 | 11 | 1 | 602 | 1172 | 565 | Apis mellifera associated ourmia-like virus 1 isolate Andong RNA-dependent RNA polymerase gene, complete cds | blastn | 1793 | 481 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Apis mellifera associated ourmia-like virus 1 | |||
| 9531932 | 9531932 | PRJNA631796_P_NODE_7968_length_240_cov_2.726257_g7690_i0 | PRJNA631796 | 7968 | 240 | 2.726257 | 6.5430168 | Ripaglys virus | 3130696 | Viruses | Viruses | 171 | 5.71e-38 | NTclustered | gi|2717320496|gb|PP172998.1| | 3130696 | g7690 | i0 | 80.242 | 20.9166666666667 | 248 | 31 | 100 | 15 | 1 | 240 | 2449 | 2212 | MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence | blastn | 5020 | 171 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripaglys virus | |||||
| 10807575 | 10807575 | PRJNA631796_P_NODE_12809_length_202_cov_1.269504_g12531_i0 | PRJNA631796 | 12809 | 202 | 1.269504 | 2.56439808 | Botrytis cinerea mitovirus 4b | 3073434 | Viruses | Viruses | 139 | 1.31e-28 | NTclustered | gi|2573931817|gb|OR161980.1| | 3073434 | g12531 | i0 | 83.117 | 26.7277227722772 | 154 | 24 | 76 | 2 | 6 | 158 | 1618 | 1770 | Botrytis cinerea mitovirus 4b isolate BcMV4b RNA dependent RNA polymerase RdRP gene, complete cds | blastn | 5399 | 139 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Botrytis cinerea mitovirus 4b | ||
| 12082791 | 12082791 | PRJNA631796_P_NODE_10870_length_209_cov_3.378378_g10592_i0 | PRJNA631796 | 10870 | 209 | 3.378378 | 7.06081002 | Ripachij virus | 3130407 | Viruses | Viruses | 344 | 2.7e-90 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g10592 | i0 | 96.618 | 174.866028708134 | 207 | 7 | 99 | 0 | 3 | 209 | 608 | 814 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 36547 | 344 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 12082822 | 12082822 | PRJNA631796_P_NODE_1750_length_538_cov_5.610063_g1476_i0 | PRJNA631796 | 1750 | 538 | 5.610063 | 30.18213894 | Aspergillus flavus magoulivirus 1 | 2871716 | Viruses | Viruses | 152 | 5.069999999999999e-32 | NTclustered | gi|2095891259|gb|MZ600058.1| | 2871716 | g1476 | i0 | 83.234 | 0.310408921933086 | 167 | 26 | 31 | 2 | 221 | 386 | 2520 | 2685 | MAG: Aspergillus flavus magoulivirus 1 isolate UniPR4 genomic sequence, sequence | blastn | 167 | 152 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Aspergillus flavus magoulivirus 1 | ||
| 12082884 | 12082884 | PRJNA631796_S_NODE_133850_length_192_cov_2.099237_g133683_i0 | PRJNA631796 | 133850 | 192 | 2.099237 | 4.03053504 | Chrocagost virus | 3129398 | Viruses | Viruses | 228 | 2.5599999999999995e-55 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g133683 | i0 | 88.021 | 163.71875 | 192 | 23 | 100 | 0 | 1 | 192 | 5855 | 5664 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 31434 | 228 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 18455426 | 18455426 | PRJNA631796_P_NODE_1155_length_677_cov_8.568182_g899_i0 | PRJNA631796 | 1155 | 677 | 8.568182 | 58.00659214 | Chrocagam virus | 3129465 | Viruses | Viruses | 1079 | 0 | NTclustered | gi|2717317643|gb|PP171913.1| | 3129465 | g899 | i0 | 95.815 | 4.85524372230428 | 669 | 26 | 99 | 2 | 10 | 677 | 11 | 678 | MAG: Chrocagam virus isolate CC1B_k141_39011 genomic sequence | blastn | 3287 | 1079 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chrocagam virus | |||
| 19003472 | 19003472 | PRJNA631796_P_NODE_555_length_1002_cov_10.853348_g377_i0 | PRJNA631796 | 555 | 1002 | 10.853348 | 108.75054696 | Viruses | 10239 | Viruses | Viruses | 1469 | 0 | NTclustered | gi|2717317643|gb|PP171913.1| | 3129465 | g377 | i0 | 93.114 | 2 | 1002 | 69 | 100 | 0 | 1 | 1002 | 1638 | 2639 | MAG: Chrocagam virus isolate CC1B_k141_39011 genomic sequence | blastn | 2004 | 1469 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chrocagam virus | |||
| 19729996 | 19729996 | PRJNA631796_P_NODE_1696_length_544_cov_7.606625_g1423_i0 | PRJNA631796 | 1696 | 544 | 7.606625 | 41.38004 | Apis mellifera associated ourmia-like virus 1 | 3373666 | Viruses | Viruses | 540 | 9.36e-149 | NTclustered | gi|2837369257|gb|PQ408677.1| | 3373666 | g1423 | i0 | 85.343 | 4.89522058823529 | 539 | 60 | 97 | 16 | 3 | 530 | 11 | 541 | Apis mellifera associated ourmia-like virus 1 isolate Andong RNA-dependent RNA polymerase gene, complete cds | blastn | 2663 | 540 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Apis mellifera associated ourmia-like virus 1 | |||
| 21005759 | 21005759 | PRJNA631796_P_NODE_11077_length_209_cov_0.864865_g10799_i0 | PRJNA631796 | 11077 | 209 | 0.864865 | 1.80756785 | Erysiphe necator associated ourmia-like virus 58 | 2741838 | Viruses | Viruses | 370 | 4.45e-98 | NTclustered | gi|1848976649|gb|MN611586.1| | 2741838 | g10799 | i0 | 98.565 | 2.97129186602871 | 209 | 3 | 100 | 0 | 1 | 209 | 1275 | 1483 | Erysiphe necator associated ourmia-like virus 58 isolate PMS16_DN270, complete genome | blastn | 621 | 370 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 58 | ||
| 21005811 | 21005811 | PRJNA631796_P_NODE_597_length_975_cov_6.541575_g411_i0 | PRJNA631796 | 597 | 975 | 6.541575 | 63.78035625 | Chrocagam virus | 3129465 | Viruses | Viruses | 1223 | 0 | NTclustered | gi|2717317643|gb|PP171913.1| | 3129465 | g411 | i0 | 89.414 | 3.39282051282051 | 973 | 99 | 99 | 4 | 4 | 974 | 706 | 1676 | MAG: Chrocagam virus isolate CC1B_k141_39011 genomic sequence | blastn | 3308 | 1223 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chrocagam 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);;