contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4372274 | 4372274 | PRJNA560932_P_NODE_57804_length_247_cov_0.885057_g57448_i0 | PRJNA560932 | 57804 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.88e-122 | NTclustered | gi|2914928861|gb|OR221539.1| | 2832643 | g57448 | i0 | 99.595 | 99.7125506072875 | 247 | 1 | 100 | 0 | 1 | 247 | 14024 | 13778 | MAG: Caudoviricetes sp. isolate MSP1537 genomic sequence | blastn | 24629 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6922692 | 6922692 | PRJNA560932_P_NODE_41606_length_283_cov_1.195238_g41250_i0 | PRJNA560932 | 41606 | 283 | 1.195238 | 3.38252354 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.3 | 4.28e-15 | NTclustered | gi|2914981896|gb|OR222105.1| | 2832643 | g41250 | i0 | 98.148 | 25.7526501766784 | 54 | 1 | 19 | 0 | 225 | 278 | 4 | 57 | MAG: Caudoviricetes sp. isolate MSP0005 genomic sequence | blastn | 7288 | 95.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20257102 | 20257102 | PRJNA560932_P_NODE_5436_length_735_cov_1.993958_g5105_i0 | PRJNA560932 | 5436 | 735 | 1.993958 | 14.6555913 | Tequatrovirus | 10663 | Viruses | Viruses | 1079 | 0 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g5105 | i0 | 100 | 79.4557823129252 | 584 | 0 | 79 | 0 | 152 | 735 | 38777 | 38194 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 58400 | 1079 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 |
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);;