contig_metadata
4 rows where bioproject = "PRJNA727760" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1194778 | 1194778 | PRJNA727760_S_NODE_21_length_1897_cov_6.392544_g20_i0 | PRJNA727760 | 21 | 1897 | 6.392544 | 121.26655968 | root | 1 | Root_unresolved | Root_unresolved | 3439 | 0 | NTclustered | gi|61006|emb|X56131.1| | 12730 | g20 | i0 | 99.576 | 46.6009488666315 | 1886 | 8 | 99 | 0 | 1 | 1886 | 1886 | 1 | Sendai virus HN gene for Haemagglutinin/Neuraminidase | blastn | 88402 | 3472 | 0.990495391705069 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 4541066 | 4541066 | PRJNA727760_S_NODE_24_length_1880_cov_8.637521_g23_i0 | PRJNA727760 | 24 | 1880 | 8.637521 | 162.3853948 | Respirovirus muris | 3052731 | Viruses | Viruses | 3356 | 0 | NTclustered | gi|546225817|dbj|AB855654.1| | 3052731 | g23 | i0 | 99.945 | 73.0893617021277 | 1820 | 1 | 97 | 0 | 61 | 1880 | 4813 | 6632 | Respirovirus muris genomic RNA, complete genome, strain: Cantell, clone: cCdi | blastn | 137408 | 3356 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus muris | ||
| 21596993 | 21596993 | PRJNA727760_S_NODE_117_length_1222_cov_22.433420_g107_i0 | PRJNA727760 | 117 | 1222 | 22.43342 | 274.1363924 | root | 1 | Root_unresolved | Root_unresolved | 2146 | 0 | NTclustered | gi|62017|emb|X53056.1| | 12730 | g107 | i0 | 99.914 | 63.4959083469722 | 1165 | 1 | 95 | 0 | 50 | 1214 | 1165 | 1 | Sendai virus mRNA for matrix protein | blastn | 77592 | 2152 | 0.997211895910781 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 22872313 | 22872313 | PRJNA727760_S_NODE_18_length_1926_cov_11.681597_g17_i0 | PRJNA727760 | 18 | 1926 | 11.681597 | 224.98755822 | Respirovirus | 186938 | Viruses | Viruses | 3450 | 0 | NTclustered | gi|62011|emb|X17008.1| | 12730 | g17 | i0 | 99.629 | 62.48753894081 | 1889 | 7 | 98 | 0 | 28 | 1916 | 1889 | 1 | Sendai virus polymerase (P) gene (strain fushimi) | blastn | 120351 | 3483 | 0.99052540913006 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis |
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);;