contig_metadata
5 rows where bioproject = "PRJNA720429" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1986022 | 1986022 | PRJNA720429_P_NODE_2822_length_264_cov_1.612565_g2765_i0 | PRJNA720429 | 2822 | 264 | 1.612565 | 4.2571716 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 387 | 5.82e-103 | NTclustered | gi|2056729093|tpg|BK044853.1| | 2832643 | g2765 | i0 | 93.156 | 38.4204545454545 | 263 | 18 | 99 | 0 | 1 | 263 | 17887 | 17625 | MAG TPA_asm: Caudoviricetes sp. isolate ctikR16, partial genome | blastn | 10143 | 387 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17288015 | 17288015 | PRJNA720429_P_NODE_2834_length_264_cov_1.235602_g2777_i0 | PRJNA720429 | 2834 | 264 | 1.235602 | 3.26198928 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 488 | 1.5499999999999999e-133 | NTclustered | gi|2059647249|tpg|BK028718.1| | 2832643 | g2777 | i0 | 100 | 2 | 264 | 0 | 100 | 0 | 1 | 264 | 16581 | 16844 | MAG TPA_asm: Caudoviricetes sp. isolate ctQcn1, partial genome | blastn | 528 | 488 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22387426 | 22387426 | PRJNA720429_P_NODE_3818_length_248_cov_0.880000_g3761_i0 | PRJNA720429 | 3818 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 398 | 2.5e-106 | NTclustered | gi|2915038928|gb|OR222715.1| | 2832643 | g3761 | i0 | 95.918 | 12.8790322580645 | 245 | 10 | 99 | 0 | 4 | 248 | 4634 | 4390 | MAG: Caudoviricetes sp. isolate MSP0653 genomic sequence | blastn | 3194 | 398 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24936571 | 24936571 | PRJNA720429_P_NODE_4860_length_242_cov_0.911243_g4803_i0 | PRJNA720429 | 4860 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 318 | 1.95e-82 | NTclustered | gi|2914918920|gb|OR221343.1| | 2832643 | g4803 | i0 | 90.795 | 5.51652892561984 | 239 | 20 | 98 | 2 | 5 | 242 | 31425 | 31662 | MAG: Caudoviricetes sp. isolate MSP1767 genomic sequence | blastn | 1335 | 318 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31769200 | 31769200 | PRJNA720429_P_NODE_2557_length_274_cov_1.532338_g2500_i0 | PRJNA720429 | 2557 | 274 | 1.532338 | 4.19860612 | Chuvivirus | 2842604 | Viruses | Viruses | 123 | 1.08e-30 | NR | UVF58769.1 | 2842604 | g2500 | i0 | 60 | 4.85036496350365 | 90 | 36 | 98.5 | 0 | 3 | 272 | 327 | 416 | UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus] | diamond | 1329 | 124 | 0.991935483870968 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Chuvivirus |
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);;