contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA506002" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1759086 | 1759086 | PRJNA506002_S_NODE_34942_length_294_cov_1.669683_g34696_i0 | PRJNA506002 | 34942 | 294 | 1.669683 | 4.90886802 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 516 | 8.05e-142 | NTclustered | gi|2059696309|tpg|BK029525.1| | 2832643 | g34696 | i0 | 98.299 | 6.09523809523809 | 294 | 5 | 100 | 0 | 1 | 294 | 32490 | 32783 | MAG TPA_asm: Caudoviricetes sp. isolate ctjAr5, partial genome | blastn | 1792 | 516 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4310966 | 4310966 | PRJNA506002_S_NODE_48944_length_263_cov_2.015789_g48698_i0 | PRJNA506002 | 48944 | 263 | 2.015789 | 5.30152507 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|2054449737|tpg|BK031291.1| | 2832643 | g48698 | i0 | 100 | 0.106463878326996 | 28 | 0 | 11 | 0 | 25 | 52 | 120252 | 120225 | MAG TPA_asm: Caudoviricetes sp. isolate ct3F98, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10687676 | 10687676 | PRJNA506002_S_NODE_34369_length_296_cov_1.035874_g34123_i0 | PRJNA506002 | 34369 | 296 | 1.035874 | 3.06618704 | Streptococcus phage Javan202 | 2548045 | Viruses | Viruses | 313 | 1.14e-80 | NTclustered | gi|1608079841|gb|MK448873.1| | 2548045 | g34123 | i0 | 92.991 | 0.722972972972973 | 214 | 15 | 72 | 0 | 83 | 296 | 18597 | 18810 | Streptococcus phage Javan202, complete genome | blastn | 214 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Streptococcus phage Javan202 | |||||
| 14512772 | 14512772 | PRJNA506002_S_NODE_27792_length_315_cov_1.268595_g27546_i0 | PRJNA506002 | 27792 | 315 | 1.268595 | 3.99607425 | Bacteriophage sp. | 38018 | Viruses | Viruses | 366 | 9.27e-97 | NTclustered | gi|2052234324|tpg|BK056786.1| | 38018 | g27546 | i0 | 87.619 | 5 | 315 | 39 | 100 | 0 | 1 | 315 | 59923 | 59609 | MAG TPA_asm: Bacteriophage sp. isolate ctb0J3, partial genome | blastn | 1575 | 366 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 14512985 | 14512985 | PRJNA506002_S_NODE_51252_length_259_cov_1.295699_g51006_i0 | PRJNA506002 | 51252 | 259 | 1.295699 | 3.35586041 | Betatorquevirus homini2 | 3048400 | Viruses | Viruses | 381 | 2.6499999999999995e-101 | NTclustered | gi|2872905738|gb|PQ581002.1| | 3048400 | g51006 | i0 | 93.385 | 17.5135135135135 | 257 | 17 | 99 | 0 | 3 | 259 | 2283 | 2539 | MAG: Betatorquevirus homini2 isolate DZY13_k141_19017 genomic sequence | blastn | 4536 | 381 | 1 | Viruses | Shotokuvirae | Commensaviricota | Cardeaviricetes | Sanitavirales | Anelloviridae | Betatorquevirus | Betatorquevirus homini2 | ||
| 15786828 | 15786828 | PRJNA506002_S_NODE_61213_length_246_cov_0.890173_g60967_i0 | PRJNA506002 | 61213 | 246 | 0.890173 | 2.18982558 | Pithovirus LCDPAC02 | 2506601 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1588058287|gb|MK500301.1| | 2506601 | g60967 | i0 | 94.595 | 0.150406504065041 | 37 | 1 | 15 | 1 | 73 | 108 | 55583 | 55547 | MAG: Pithovirus LCDPAC02 genomic sequence | blastn | 37 | 56.5 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC02 | |||||||
| 21512498 | 21512498 | PRJNA506002_S_NODE_40157_length_282_cov_1.014354_g39911_i0 | PRJNA506002 | 40157 | 282 | 1.014354 | 2.86047828 | Mimiviridae | 549779 | Viruses | Viruses | 52.8 | 0.026 | NTclustered | gi|363539767|ref|NC_016072.1| | 1094892 | g39911 | i0 | 100 | 1.09219858156028 | 28 | 0 | 10 | 0 | 80 | 107 | 161445 | 161418 | Megavirus chiliensis, complete genome | blastn | 308 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Megavirus chilense | ||
| 25336956 | 25336956 | PRJNA506002_S_NODE_51360_length_259_cov_1.236559_g51114_i0 | PRJNA506002 | 51360 | 259 | 1.236559 | 3.20268781 | Tetraparvovirus | 1511911 | Viruses | Viruses | 473 | 4.25e-129 | NTclustered | gi|2277478573|gb|MZ502236.1| | 1096141 | g51114 | i0 | 99.614 | 18 | 259 | 1 | 100 | 0 | 1 | 259 | 5050 | 4792 | Bovine hokovirus 2 isolate BCS1/USA nonstructural protein, minor structural protein, and major structural protein genes, complete cds | blastn | 4662 | 473 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Tetraparvovirus | Tetraparvovirus ungulate1 |
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);;