contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA942359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 922899 | 922899 | PRJNA942359_P_NODE_15081_length_250_cov_0.881356_g14966_i0 | PRJNA942359 | 15081 | 250 | 0.881356 | 2.20339 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 370 | 5.499999999999999e-98 | NTclustered | gi|2914883601|gb|OR222234.1| | 2832643 | g14966 | i0 | 97.248 | 12.512 | 218 | 6 | 87 | 0 | 1 | 218 | 652 | 435 | MAG: Caudoviricetes sp. isolate MSP0734 genomic sequence | blastn | 3128 | 370 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 922919 | 922919 | PRJNA942359_P_NODE_16241_length_248_cov_0.891429_g16126_i0 | PRJNA942359 | 16241 | 248 | 0.891429 | 2.21074392 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 100 | 7.9e-17 | NTclustered | gi|2914804707|gb|OR221415.1| | 2832643 | g16126 | i0 | 88.235 | 1.08870967741935 | 85 | 8 | 34 | 2 | 153 | 236 | 38319 | 38402 | MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence | blastn | 270 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 922927 | 922927 | PRJNA942359_P_NODE_16761_length_247_cov_0.896552_g16646_i0 | PRJNA942359 | 16761 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 440 | 4.079999999999999e-119 | NTclustered | gi|2059836051|tpg|BK040247.1| | 2832643 | g16646 | i0 | 98.785 | 48.9028340080972 | 247 | 3 | 100 | 0 | 1 | 247 | 25305 | 25551 | MAG TPA_asm: Caudoviricetes sp. isolate ctNrV9, partial genome | blastn | 12079 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2198243 | 2198243 | PRJNA942359_P_NODE_14922_length_250_cov_0.881356_g14807_i0 | PRJNA942359 | 14922 | 250 | 0.881356 | 2.20339 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 278 | 3.43e-70 | NTclustered | gi|2914947149|gb|OR221844.1| | 2832643 | g14807 | i0 | 99.346 | 57.428 | 153 | 1 | 61 | 0 | 1 | 153 | 48874 | 49026 | MAG: Caudoviricetes sp. isolate MSP1172 genomic sequence | blastn | 14357 | 278 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6026322 | 6026322 | PRJNA942359_P_NODE_8865_length_292_cov_1.383562_g8750_i0 | PRJNA942359 | 8865 | 292 | 1.383562 | 4.04000104 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 479 | 1.0499999999999996e-130 | NTclustered | gi|2058019699|tpg|BK041912.1| | 2832643 | g8750 | i0 | 96.233 | 7 | 292 | 11 | 100 | 0 | 1 | 292 | 6462 | 6753 | MAG TPA_asm: Caudoviricetes sp. isolate ctVtw3, partial genome | blastn | 2044 | 479 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7301057 | 7301057 | PRJNA942359_P_NODE_16806_length_247_cov_0.896552_g16691_i0 | PRJNA942359 | 16806 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g16691 | i0 | 100 | 1 | 247 | 0 | 100 | 0 | 1 | 247 | 39099 | 39345 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 247 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16225877 | 16225877 | PRJNA942359_P_NODE_16053_length_248_cov_0.891429_g15938_i0 | PRJNA942359 | 16053 | 248 | 0.891429 | 2.21074392 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.1399999999999995e-119 | NTclustered | gi|2914992519|gb|OR222200.1| | 2832643 | g15938 | i0 | 98.79 | 1.99596774193548 | 248 | 3 | 100 | 0 | 1 | 248 | 43874 | 43627 | MAG: Caudoviricetes sp. isolate MSP0775 genomic sequence | blastn | 495 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17836231 | 17836231 | PRJNA942359_P_NODE_17034_length_247_cov_0.896552_g16919_i0 | PRJNA942359 | 17034 | 247 | 0.896552 | 2.21448344 | root | 1 | Root_unresolved | Root_unresolved | 457 | 4.05e-124 | NTclustered | gi|2914842066|gb|OR222894.1| | 2832643 | g16919 | i0 | 100 | 66.2672064777328 | 247 | 0 | 100 | 0 | 1 | 247 | 44729 | 44975 | MAG: Caudoviricetes sp. isolate MSP0452 genomic sequence | blastn | 16368 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18774666 | 18774666 | PRJNA942359_P_NODE_14755_length_250_cov_0.881356_g14640_i0 | PRJNA942359 | 14755 | 250 | 0.881356 | 2.20339 | Phage 68_12 | 2718481 | Viruses | Viruses | 174 | 4.63e-39 | NTclustered | gi|1919260693|gb|MN304817.1| | 2718481 | g14640 | i0 | 88.276 | 4.776 | 145 | 17 | 60 | 0 | 5 | 149 | 24847 | 24991 | MAG: Phage 68_12, complete genome | blastn | 1194 | 174 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phage 68_12 |
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);;