contig_metadata
11 rows where bioproject = "PRJNA849172", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8488338 | 8488338 | PRJNA849172_P_NODE_16407_length_514_cov_3.247166_g16048_i0 | PRJNA849172 | 16407 | 514 | 3.247166 | 16.69043324 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 922 | 0 | NTclustered | gi|1940198121|gb|MT757492.1| | 2789378 | g16048 | i0 | 99.029 | 3.20622568093385 | 515 | 4 | 100 | 1 | 1 | 514 | 8901 | 8387 | Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds | blastn | 1648 | 922 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 14862913 | 14862913 | PRJNA849172_P_NODE_132452_length_217_cov_6.944444_g132092_i0 | PRJNA849172 | 132452 | 217 | 6.944444 | 15.06944348 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 390 | 3.579999999999999e-104 | NTclustered | gi|2756423573|gb|PP745577.1| | 1955144 | g132092 | i0 | 99.078 | 4.20276497695852 | 217 | 2 | 100 | 0 | 1 | 217 | 1566 | 1350 | MAG: Dicistroviridae sp. isolate 268_6903 genomic sequence | blastn | 912 | 390 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 14865594 | 14865594 | PRJNA849172_P_NODE_8632_length_739_cov_42.429429_g8290_i0 | PRJNA849172 | 8632 | 739 | 42.429429 | 313.55348031 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 1000 | 0 | NTclustered | gi|1940197836|gb|MT721845.1| | 2789378 | g8290 | i0 | 96.529 | 3.07171853856563 | 605 | 20 | 82 | 1 | 135 | 739 | 9270 | 8667 | Shenzhen dicistro-like virus polyprotein gene, complete cds | blastn | 2270 | 1000 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 19961920 | 19961920 | PRJNA849172_P_NODE_15176_length_537_cov_3.424569_g14817_i0 | PRJNA849172 | 15176 | 537 | 3.424569 | 18.38993553 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 920 | 0 | NTclustered | gi|1940198121|gb|MT757492.1| | 2789378 | g14817 | i0 | 97.579 | 2 | 537 | 13 | 100 | 0 | 1 | 537 | 7867 | 8403 | Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds | blastn | 1074 | 920 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 21238009 | 21238009 | PRJNA849172_P_NODE_30797_length_369_cov_15.395270_g30438_i0 | PRJNA849172 | 30797 | 369 | 15.39527 | 56.8085463 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 377 | 5.090000000000001e-100 | NTclustered | gi|2754691651|gb|PP872615.1| | 3003959 | g30438 | i0 | 89.632 | 0.81029810298103 | 299 | 27 | 80 | 4 | 1 | 297 | 9266 | 8970 | MAG: Picornavirales sp. isolate TC-PLV-59 MR233-17E/322 genomic sequence | blastn | 299 | 377 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 25061468 | 25061468 | PRJNA849172_P_NODE_142880_length_204_cov_5.770992_g142520_i0 | PRJNA849172 | 142880 | 204 | 5.770992 | 11.77282368 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 322 | 1.23e-83 | NTclustered | gi|1935607033|gb|MT747992.1| | 2789443 | g142520 | i0 | 95.098 | 1.75490196078431 | 204 | 10 | 100 | 0 | 1 | 204 | 8469 | 8672 | Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds | blastn | 358 | 322 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 28381328 | 28381328 | PRJNA849172_P_NODE_7646_length_789_cov_49.005587_g4163_i1 | PRJNA849172 | 7646 | 789 | 49.005587 | 386.65408143 | Aspergillus flavus partitivirus 1 | 2590841 | Viruses | Viruses | 180 | 7.679999999999999e-52 | NR | BED98280.1 | 2590841 | g4163 | i1 | 36.8 | 1.0532319391635 | 277 | 90 | 73 | 2 | 114 | 689 | 2 | 278 | BED98280.1 MAG: hypothetical protein [Aspergillus flavus partitivirus 1] | diamond | 831 | 180 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Aspergillus flavus partitivirus 1 | |||
| 29265182 | 29265182 | PRJNA849172_P_NODE_4429_length_1053_cov_39.780612_g4163_i0 | PRJNA849172 | 4429 | 1053 | 39.780612 | 418.88984436 | Aspergillus flavus partitivirus 1 | 2590841 | Viruses | Viruses | 239 | 1.91e-73 | NR | BED98280.1 | 2590841 | g4163 | i0 | 45.5 | 0.814814814814815 | 286 | 141 | 79.8 | 6 | 114 | 953 | 2 | 278 | BED98280.1 MAG: hypothetical protein [Aspergillus flavus partitivirus 1] | diamond | 858 | 239 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Aspergillus flavus partitivirus 1 | |||
| 30411076 | 30411076 | PRJNA849172_P_NODE_143513_length_203_cov_11.607692_g143153_i0 | PRJNA849172 | 143513 | 203 | 11.607692 | 23.56361476 | Viruses | 10239 | Viruses | Viruses | 91.3 | 8.24e-20 | NR | BDF97659.1 | 2918173 | g143153 | i0 | 55.2 | 1.98029556650246 | 67 | 30 | 99 | 0 | 2 | 202 | 5 | 71 | BDF97659.1 capsid protein [Aspergillus niger partitivirus 1] | diamond | 402 | 91.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Aspergillus niger partitivirus 1 | |||
| 31698335 | 31698335 | PRJNA849172_P_NODE_16897_length_505_cov_34.437500_g16538_i0 | PRJNA849172 | 16897 | 505 | 34.4375 | 173.909375 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 104 | 1.5100000000000001e-22 | NR | XCM68390.1 | 3003959 | g16538 | i0 | 42.4 | 0.938613861386139 | 158 | 82 | 89.7 | 4 | 465 | 13 | 609 | 764 | XCM68390.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 474 | 104 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31729888 | 31729888 | PRJNA849172_P_NODE_5537_length_936_cov_23.808806_g5247_i0 | PRJNA849172 | 5537 | 936 | 23.808806 | 222.85042416 | Aspergillus flavus partitivirus 1 | 2590841 | Viruses | Viruses | 151 | 7.07e-40 | NR | BED98299.1 | 2590841 | g5247 | i0 | 34.2 | 0.871794871794872 | 272 | 171 | 84.6 | 3 | 72 | 863 | 4 | 275 | BED98299.1 MAG: hypothetical protein [Aspergillus flavus partitivirus 1] | diamond | 816 | 151 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Aspergillus flavus partitivirus 1 |
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);;