contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA942359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8576078 | 8576078 | PRJNA942359_P_NODE_7_length_3912_cov_70.755145_g4_i0 | PRJNA942359 | 7 | 3912 | 70.755145 | 2767.9412724 | Leviviridae sp. | 2027243 | Viruses | Viruses | 1074 | 0 | NTclustered | gi|2245486811|gb|ON162519.1| | 2027243 | g4 | i0 | 84.573 | 0.601226993865031 | 1089 | 161 | 28 | 6 | 636 | 1722 | 1084 | 1 | MAG: Leviviridae sp. isolate s42-k141_44103 RNA dependent RNA polymerase gene, partial cds | blastn | 2352 | 1074 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 14950839 | 14950839 | PRJNA942359_P_NODE_12_length_3462_cov_19.731779_g9_i0 | PRJNA942359 | 12 | 3462 | 19.731779 | 683.11418898 | Sholavirus sp. 'caenicola' | 2846211 | Viruses | Viruses | 1507 | 0 | NTclustered | gi|2497514791|ref|NC_074095.1| | 2786397 | g9 | i0 | 76.053 | 2.40843443096476 | 3086 | 634 | 88 | 91 | 1 | 3031 | 3486 | 451 | SsRNA phage SRR5466364_3 genomic sequence | blastn | 8338 | 1507 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Sholavirus | Sholavirus sp. 'caenicola' | ||
| 14951056 | 14951056 | PRJNA942359_P_NODE_592_length_966_cov_3.968645_g514_i0 | PRJNA942359 | 592 | 966 | 3.968645 | 38.3371107 | Leviviridae sp. | 2027243 | Viruses | Viruses | 405 | 6.52e-108 | NTclustered | gi|2245488938|gb|ON163587.1| | 2027243 | g514 | i0 | 80.791 | 0.819875776397516 | 531 | 90 | 54 | 11 | 10 | 534 | 765 | 1289 | MAG: Leviviridae sp. isolate 83-k141_204414 RNA dependent RNA polymerase gene, partial cds | blastn | 792 | 405 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae 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);;