contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJEB25583" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2572855 | 2572855 | PRJEB25583_P_NODE_1643_length_333_cov_11.557432_g1466_i0 | PRJEB25583 | 1643 | 333 | 11.557432 | 38.48624856 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 281 | 3.68e-71 | NTclustered | gi|2836327433|gb|PQ161556.1| | 1955165 | g1466 | i0 | 82.857 | 7.04204204204204 | 315 | 52 | 94 | 2 | 20 | 333 | 1301 | 1614 | MAG: Luteoviridae sp. isolate CS06 RNA-dependent RNA polymerase, coat protein VP1, and capsid protein genes, complete cds | blastn | 2345 | 281 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 2572874 | 2572874 | PRJEB25583_P_NODE_4383_length_195_cov_1.740506_g4206_i0 | PRJEB25583 | 4383 | 195 | 1.740506 | 3.3939867 | Tolivirales sp. gcode 6 | 3108923 | Viruses | Viruses | 285 | 1.5300000000000001e-72 | NTclustered | gi|2647550025|gb|OR843800.1| | 3108923 | g4206 | i0 | 97.041 | 0.866666666666667 | 169 | 5 | 87 | 0 | 13 | 181 | 1414 | 1246 | Tolivirales sp. gcode 6 strain MR233-17E/7345 hypothetical protein gene, partial cds; RNA-dependent RNA polymerase gene, complete cds; and structural protein gene, partial cds | blastn | 169 | 285 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. gcode 6 | ||||
| 14051128 | 14051128 | PRJEB25583_P_NODE_4952_length_184_cov_3.238095_g4775_i0 | PRJEB25583 | 4952 | 184 | 3.238095 | 5.9580948 | Tolivirales sp. gcode 6 | 3108923 | Viruses | Viruses | 261 | 2.39e-65 | NTclustered | gi|2647550025|gb|OR843800.1| | 3108923 | g4775 | i0 | 94.706 | 0.923913043478261 | 170 | 6 | 91 | 1 | 18 | 184 | 1765 | 1934 | Tolivirales sp. gcode 6 strain MR233-17E/7345 hypothetical protein gene, partial cds; RNA-dependent RNA polymerase gene, complete cds; and structural protein gene, partial cds | blastn | 170 | 261 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. gcode 6 | ||||
| 17874607 | 17874607 | PRJEB25583_P_NODE_6515_length_164_cov_1.858268_g6338_i0 | PRJEB25583 | 6515 | 164 | 1.858268 | 3.04755952 | Lolavirus latenslolii | 3430466 | Viruses | Viruses | 213 | 5.94e-51 | NTclustered | gi|169803200|ref|NC_010434.1| | 365150 | g6338 | i0 | 93.662 | 1.73170731707317 | 142 | 9 | 87 | 0 | 3 | 144 | 7642 | 7501 | Lolium latent virus, complete genome | blastn | 284 | 213 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Lolavirus | Lolavirus latenslolii | ||
| 24248812 | 24248812 | PRJEB25583_P_NODE_3020_length_233_cov_5.505102_g2843_i0 | PRJEB25583 | 3020 | 233 | 5.505102 | 12.82688766 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 213 | 9.04e-51 | NTclustered | gi|2171145475|gb|MZ218407.1| | 1955165 | g2843 | i0 | 84.834 | 2.05579399141631 | 211 | 32 | 91 | 0 | 21 | 231 | 3446 | 3656 | MAG: Luteoviridae sp. isolate s48-k141_1520260 genomic sequence | blastn | 479 | 213 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. |
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);;