contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1301086 | 1301086 | PRJEB29441_P_NODE_47422_length_161_cov_0.910714_g46981_i0 | PRJEB29441 | 47422 | 161 | 0.910714 | 1.46624954 | Potexvirus pepini | 3433856 | Viruses | Viruses | 298 | 1.56e-76 | NTclustered | gi|1421680372|gb|MH550178.1| | 112229 | g46981 | i0 | 100 | 100 | 161 | 0 | 100 | 0 | 1 | 161 | 84 | 244 | Pepino mosaic virus isolate AG17-12b TGBp1, TGBp2, TGBp3, and CP genes, complete cds | blastn | 16100 | 298 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 3852868 | 3852868 | PRJEB29441_P_NODE_39924_length_166_cov_1.452991_g39483_i0 | PRJEB29441 | 39924 | 166 | 1.452991 | 2.41196506 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 302 | 1.2500000000000001e-77 | NTclustered | gi|1594663021|gb|MH937416.1| | 12169 | g39483 | i0 | 99.398 | 86.7409638554217 | 166 | 1 | 100 | 0 | 1 | 166 | 1325 | 1490 | Potato virus S isolate PvS-W13-136, complete genome | blastn | 14399 | 302 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 5129033 | 5129033 | PRJEB29441_P_NODE_36005_length_174_cov_1.240000_g35564_i0 | PRJEB29441 | 36005 | 174 | 1.24 | 2.1576 | Tolivirales sp. | 2809914 | Viruses | Viruses | 300 | 4.73e-77 | NTclustered | gi|2647550279|gb|OR843880.1| | 2809914 | g35564 | i0 | 97.701 | 1 | 174 | 4 | 100 | 0 | 1 | 174 | 618 | 445 | Tolivirales sp. strain MR233-17E/17828 RNA-dependent RNA polymerase and hypothetical protein genes, partial cds | blastn | 174 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 12780033 | 12780033 | PRJEB29441_P_NODE_27111_length_201_cov_4.210526_g26670_i0 | PRJEB29441 | 27111 | 201 | 4.210526 | 8.46315726 | Hubei sediment luteo-like virus 2 | 2933247 | Viruses | Viruses | 180 | 7.69e-41 | NTclustered | gi|2171145464|gb|MZ218404.1| | 2933247 | g26670 | i0 | 82.915 | 1.98009950248756 | 199 | 34 | 99 | 0 | 3 | 201 | 1290 | 1488 | MAG: Hubei sediment luteo-like virus 2 isolate 84-k141_114889 hypothetical protein 1 and hypothetical protein 2 genes, complete cds; and hypothetical protein 3 gene, partial cds | blastn | 398 | 180 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Hubei sediment luteo-like virus 2 | ||||
| 14054750 | 14054750 | PRJEB29441_P_NODE_32312_length_184_cov_1.511111_g31871_i0 | PRJEB29441 | 32312 | 184 | 1.511111 | 2.78044424 | Tolivirales sp. | 2809914 | Viruses | Viruses | 302 | 1.41e-77 | NTclustered | gi|2647550279|gb|OR843880.1| | 2809914 | g31871 | i0 | 96.196 | 1.6304347826087 | 184 | 7 | 100 | 0 | 1 | 184 | 471 | 288 | Tolivirales sp. strain MR233-17E/17828 RNA-dependent RNA polymerase and hypothetical protein genes, partial cds | blastn | 300 | 302 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 16603694 | 16603694 | PRJEB29441_P_NODE_7674_length_418_cov_3.498645_g7235_i0 | PRJEB29441 | 7674 | 418 | 3.498645 | 14.6243361 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 222 | 2.9e-53 | NTclustered | gi|2171145498|gb|MZ218414.1| | 1955165 | g7235 | i0 | 77.573 | 4.48086124401914 | 379 | 77 | 90 | 8 | 44 | 418 | 1941 | 2315 | MAG: Luteoviridae sp. isolate 248-k141_241782 genomic sequence | blastn | 1873 | 222 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 19151987 | 19151987 | PRJEB29441_P_NODE_26016_length_206_cov_1.547771_g25575_i0 | PRJEB29441 | 26016 | 206 | 1.547771 | 3.18840826 | Reagent-associated tombus-like virus 3 | 2875820 | Viruses | Viruses | 368 | 1.57e-97 | NTclustered | gi|2094552978|gb|MZ824227.1| | 2875820 | g25575 | i0 | 99.029 | 1 | 206 | 1 | 100 | 1 | 1 | 206 | 630 | 834 | Reagent-associated tombus-like virus 3 isolate 5 replicase-like gene, partial sequence | blastn | 206 | 368 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 3 |
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);;