contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA879314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4686235 | 4686235 | PRJNA879314_P_NODE_2564_length_302_cov_1.126638_g2514_i0 | PRJNA879314 | 2564 | 302 | 1.126638 | 3.40244676 | uncultured phage | 278008 | Viruses | Viruses | 178 | 4.45e-40 | NTclustered | gi|1804151430|emb|LR756507.1| | 278008 | g2514 | i0 | 81.333 | 0.745033112582781 | 225 | 36 | 74 | 6 | 73 | 294 | 169854 | 169633 | uncultured phage genome assembly, chromosome: 1 | blastn | 225 | 178 | 1 | Viruses | uncultured phage | ||||||||
| 5961092 | 5961092 | PRJNA879314_P_NODE_4065_length_259_cov_1.505376_g4015_i0 | PRJNA879314 | 4065 | 259 | 1.505376 | 3.89892384 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 241 | 4.690000000000001e-59 | NTclustered | gi|2060091403|tpg|BK027333.1| | 2832643 | g4015 | i0 | 83.525 | 2.89189189189189 | 261 | 39 | 100 | 4 | 1 | 259 | 3812 | 3554 | MAG TPA_asm: Caudoviricetes sp. isolate ct80B11, partial genome | blastn | 749 | 241 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8510803 | 8510803 | PRJNA879314_P_NODE_4907_length_252_cov_0.871508_g4857_i0 | PRJNA879314 | 4907 | 252 | 0.871508 | 2.19620016 | Bacteriophage sp. | 38018 | Viruses | Viruses | 244 | 3.51e-60 | NTclustered | gi|2295340044|gb|OP075383.1| | 38018 | g4857 | i0 | 84.127 | 17.400793650793702 | 252 | 40 | 100 | 0 | 1 | 252 | 3833 | 4084 | MAG: Bacteriophage sp. isolate 3315_47217, complete genome | blastn | 4385 | 244 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 9785711 | 9785711 | PRJNA879314_P_NODE_5088_length_252_cov_0.871508_g5038_i0 | PRJNA879314 | 5088 | 252 | 0.871508 | 2.19620016 | phage Lak_Megaphage_Sonny | 3109229 | Viruses | Viruses | 99 | 2.89e-16 | NTclustered | gi|2637653278|gb|OR769223.1| | 3109229 | g5038 | i0 | 80.451 | 0.694444444444444 | 133 | 22 | 52 | 4 | 4 | 134 | 580316 | 580186 | MAG: Phage Lak_Megaphage_Sonny, complete sequence | blastn | 175 | 99 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_Sonny | ||||
| 11061521 | 11061521 | PRJNA879314_P_NODE_5469_length_251_cov_1.235955_g5419_i0 | PRJNA879314 | 5469 | 251 | 1.235955 | 3.10224705 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 102 | 2.23e-17 | NTclustered | gi|2054474609|tpg|BK031808.1| | 2832643 | g5419 | i0 | 92 | 5.54183266932271 | 75 | 2 | 29 | 4 | 1 | 73 | 16440 | 16512 | MAG TPA_asm: Caudoviricetes sp. isolate cthmj3, partial genome | blastn | 1391 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14885850 | 14885850 | PRJNA879314_P_NODE_2672_length_298_cov_1.008889_g2622_i0 | PRJNA879314 | 2672 | 298 | 1.008889 | 3.00648922 | uncultured phage | 278008 | Viruses | Viruses | 209 | 1.55e-49 | NTclustered | gi|1804151430|emb|LR756507.1| | 278008 | g2622 | i0 | 83.556 | 0.75503355704698 | 225 | 36 | 76 | 1 | 41 | 265 | 63286 | 63063 | uncultured phage genome assembly, chromosome: 1 | blastn | 225 | 209 | 1 | Viruses | uncultured phage | ||||||||
| 17436003 | 17436003 | PRJNA879314_P_NODE_11234_length_242_cov_0.923077_g11184_i0 | PRJNA879314 | 11234 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 278 | 3.3e-70 | NTclustered | gi|2059644605|tpg|BK028679.1| | 2832643 | g11184 | i0 | 88.362 | 93.9628099173554 | 232 | 25 | 95 | 2 | 12 | 242 | 319022 | 319252 | MAG TPA_asm: Caudoviricetes sp. isolate cteU61, partial genome | blastn | 22739 | 278 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25083940 | 25083940 | PRJNA879314_P_NODE_3400_length_276_cov_1.448276_g3350_i0 | PRJNA879314 | 3400 | 276 | 1.448276 | 3.99724176 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 300 | 8.21e-77 | NTclustered | gi|2054777584|tpg|BK049678.1| | 2832643 | g3350 | i0 | 86.545 | 3.96739130434783 | 275 | 33 | 99 | 4 | 1 | 273 | 8801 | 9073 | MAG TPA_asm: Caudoviricetes sp. isolate ctnQq13, partial genome | blastn | 1095 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25084004 | 25084004 | PRJNA879314_P_NODE_7960_length_247_cov_0.896552_g7910_i0 | PRJNA879314 | 7960 | 247 | 0.896552 | 2.21448344 | Bacteriophage sp. | 38018 | Viruses | Viruses | 158 | 4.6e-34 | NTclustered | gi|2295208815|gb|OP074216.1| | 38018 | g7910 | i0 | 83.832 | 2.72874493927126 | 167 | 25 | 67 | 2 | 41 | 206 | 26521 | 26356 | MAG: Bacteriophage sp. isolate 1788_57933, partial genome | blastn | 674 | 158 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 25084009 | 25084009 | PRJNA879314_P_NODE_8480_length_246_cov_1.624277_g8430_i0 | PRJNA879314 | 8480 | 246 | 1.624277 | 3.99572142 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 228 | 3.4399999999999986e-55 | NTclustered | gi|2057085973|tpg|BK038019.1| | 2832643 | g8430 | i0 | 85.202 | 91.9430894308943 | 223 | 31 | 90 | 2 | 20 | 241 | 3678 | 3899 | MAG TPA_asm: Caudoviricetes sp. isolate ctal42, partial genome | blastn | 22618 | 228 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;