contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA543299" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 509802 | 509802 | PRJNA543299_P_NODE_7501_length_270_cov_1.384615_g7344_i0 | PRJNA543299 | 7501 | 270 | 1.384615 | 3.7384605 | clidnopec virus 109 | 3367856 | Viruses | Viruses | 433 | 7.56e-117 | NTclustered | gi|2836328516|gb|PQ161936.1| | 3367856 | g7344 | i0 | 95.556 | 1 | 270 | 12 | 100 | 0 | 1 | 270 | 566 | 835 | MAG: Clidnopec virus 109 isolate CS04 rolling circle replication-like protein and capsid protein genes, complete cds | blastn | 270 | 433 | 1 | Viruses | clidnopec virus 109 | ||||||||
| 2394106 | 2394106 | PRJNA543299_P_NODE_17962_length_177_cov_1.984375_g17805_i0 | PRJNA543299 | 17962 | 177 | 1.984375 | 3.51234375 | root | 1 | Root_unresolved | Root_unresolved | 320 | 3.71e-83 | NTclustered | gi|2083028918|gb|MZ375242.1| | 10760 | g17805 | i0 | 100 | 88.593220338983 | 173 | 0 | 98 | 0 | 5 | 177 | 10645 | 10473 | Mutant Escherichia phage T7 clone T7_50S, complete genome | blastn | 15681 | 320 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Teseptimavirus | Teseptimavirus T7 | ||
| 4946801 | 4946801 | PRJNA543299_P_NODE_1704_length_527_cov_1.196653_g1562_i0 | PRJNA543299 | 1704 | 527 | 1.196653 | 6.30636131 | root | 1 | Root_unresolved | Root_unresolved | 974 | 0 | NTclustered | gi|2083029198|gb|MZ375249.1| | 10760 | g1562 | i0 | 100 | 100 | 527 | 0 | 100 | 0 | 1 | 527 | 9963 | 10489 | Mutant Escherichia phage T7 clone T7_90L, complete genome | blastn | 52700 | 974 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Teseptimavirus | Teseptimavirus T7 | ||
| 5613535 | 5613535 | PRJNA543299_P_NODE_3805_length_371_cov_1.357143_g3651_i0 | PRJNA543299 | 3805 | 371 | 1.357143 | 5.03500053 | clidnopec virus 109 | 3367856 | Viruses | Viruses | 586 | 7.819999999999997e-163 | NTclustered | gi|2836328516|gb|PQ161936.1| | 3367856 | g3651 | i0 | 95.148 | 1 | 371 | 18 | 100 | 0 | 1 | 371 | 190 | 560 | MAG: Clidnopec virus 109 isolate CS04 rolling circle replication-like protein and capsid protein genes, complete cds | blastn | 371 | 586 | 1 | Viruses | clidnopec virus 109 | ||||||||
| 6222259 | 6222259 | PRJNA543299_P_NODE_24205_length_163_cov_0.894737_g24048_i0 | PRJNA543299 | 24205 | 163 | 0.894737 | 1.45842131 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 257 | 2.68e-64 | NTclustered | gi|530787446|ref|NC_022089.1| | 3003968 | g24048 | i0 | 95.122 | 14.3251533742331 | 164 | 6 | 100 | 2 | 1 | 163 | 3180 | 3342 | Parvovirus NIH-CQV putative 15-kDa protein, putative replication associated protein (rep), and putative capsid protein (cap) genes, complete cds | blastn | 2335 | 257 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 6887231 | 6887231 | PRJNA543299_P_NODE_20406_length_167_cov_0.864407_g20249_i0 | PRJNA543299 | 20406 | 167 | 0.864407 | 1.44355969 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 226 | 7.799999999999999e-55 | NTclustered | gi|2915004039|gb|OR222348.1| | 2832643 | g20249 | i0 | 92.903 | 3.78443113772455 | 155 | 11 | 93 | 0 | 1 | 155 | 23224 | 23378 | MAG: Caudoviricetes sp. isolate MSP1050 genomic sequence | blastn | 632 | 226 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8162363 | 8162363 | PRJNA543299_P_NODE_1927_length_501_cov_2.088496_g1784_i0 | PRJNA543299 | 1927 | 501 | 2.088496 | 10.46336496 | clidnopec virus 109 | 3367856 | Viruses | Viruses | 800 | 0 | NTclustered | gi|2836328516|gb|PQ161936.1| | 3367856 | g1784 | i0 | 95.6 | 0.998003992015968 | 500 | 21 | 99 | 1 | 1 | 499 | 869 | 1368 | MAG: Clidnopec virus 109 isolate CS04 rolling circle replication-like protein and capsid protein genes, complete cds | blastn | 500 | 800 | 1 | Viruses | clidnopec virus 109 | ||||||||
| 8162472 | 8162472 | PRJNA543299_P_NODE_2567_length_444_cov_1.731646_g2418_i0 | PRJNA543299 | 2567 | 444 | 1.731646 | 7.68850824 | clidnopec virus 109 | 3367856 | Viruses | Viruses | 324 | 8.25e-84 | NTclustered | gi|2836328516|gb|PQ161936.1| | 3367856 | g2418 | i0 | 83.853 | 0.795045045045045 | 353 | 44 | 77 | 12 | 103 | 444 | 2278 | 1928 | MAG: Clidnopec virus 109 isolate CS04 rolling circle replication-like protein and capsid protein genes, complete cds | blastn | 353 | 324 | 1 | Viruses | clidnopec virus 109 | ||||||||
| 9437760 | 9437760 | PRJNA543299_P_NODE_14668_length_196_cov_1.040816_g14511_i0 | PRJNA543299 | 14668 | 196 | 1.040816 | 2.03999936 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 289 | 1.1899999999999998e-73 | NTclustered | gi|541138038|gb|KF214644.1| | 3003968 | g14511 | i0 | 93.367 | 15.3979591836735 | 196 | 12 | 100 | 1 | 1 | 196 | 738 | 544 | Parvo-like hybrid virus UC5, partial genome | blastn | 3018 | 289 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 11988362 | 11988362 | PRJNA543299_P_NODE_20410_length_167_cov_0.864407_g20253_i0 | PRJNA543299 | 20410 | 167 | 0.864407 | 1.44355969 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 209 | 7.85e-50 | NTclustered | gi|1839173810|emb|LR796687.1| | 2100421 | g20253 | i0 | 89.222 | 1 | 167 | 18 | 100 | 0 | 1 | 167 | 937 | 771 | uncultured Caudovirales phage genome assembly | blastn | 167 | 209 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 19635680 | 19635680 | PRJNA543299_P_NODE_17996_length_177_cov_1.593750_g17839_i0 | PRJNA543299 | 17996 | 177 | 1.59375 | 2.8209375 | Wigfec virus K19_94 | 2985971 | Viruses | Viruses | 139 | 1.1199999999999999e-28 | NTclustered | gi|2316504403|gb|OP549801.1| | 2985971 | g17839 | i0 | 83.007 | 1.7909604519774 | 153 | 26 | 86 | 0 | 6 | 158 | 1632 | 1480 | MAG: Wigfec virus K19_94, complete genome | blastn | 317 | 139 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Wigfec virus K19_94 | |||
| 22186545 | 22186545 | PRJNA543299_P_NODE_5998_length_299_cov_3.296000_g5842_i0 | PRJNA543299 | 5998 | 299 | 3.296 | 9.85504 | clidnopec virus 109 | 3367856 | Viruses | Viruses | 416 | 8.56e-112 | NTclustered | gi|2836328516|gb|PQ161936.1| | 3367856 | g5842 | i0 | 91.722 | 1.01003344481605 | 302 | 22 | 100 | 1 | 1 | 299 | 1923 | 1622 | MAG: Clidnopec virus 109 isolate CS04 rolling circle replication-like protein and capsid protein genes, complete cds | blastn | 302 | 416 | 1 | Viruses | clidnopec virus 109 | ||||||||
| 24735620 | 24735620 | PRJNA543299_P_NODE_23240_length_164_cov_0.886957_g23083_i0 | PRJNA543299 | 23240 | 164 | 0.886957 | 1.45460948 | HP38B virus | 2502797 | Viruses | Viruses | 228 | 2.1199999999999996e-55 | NTclustered | gi|1554598392|gb|MH933800.1| | 2502797 | g23083 | i0 | 92.949 | 0.951219512195122 | 156 | 11 | 95 | 0 | 1 | 156 | 765 | 920 | HP38B virus isolate HP38B_Sewage-associated-like 2 replication-associated protein gene, partial cds | blastn | 156 | 228 | 1 | Viruses | HP38B virus |
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);;