contig_metadata
7 rows where bioproject = "PRJNA1120060", tax_phylum = "Cressdnaviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1542355 | 1542355 | PRJNA1120060_P_NODE_552982_length_356_cov_4.424028_g535304_i0 | PRJNA1120060 | 552982 | 356 | 4.424028 | 15.74953968 | Grapevine geminivirus A defective DNA | 1928761 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1898523535|gb|MT344724.1| | 1928761 | g535304 | i0 | 100 | 0.168539325842697 | 30 | 0 | 8 | 0 | 90 | 119 | 1307 | 1278 | Grapevine geminivirus A defective DNA isolate def2019YM4, complete genome | blastn | 60 | 56.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Geminiviridae | Grapevine geminivirus A defective DNA | |||
| 5360578 | 5360578 | PRJNA1120060_P_NODE_2936965_length_243_cov_0.905882_g2918872_i0 | PRJNA1120060 | 2936965 | 243 | 0.905882 | 2.20129326 | Ficedula mugimaki CRESS-DNA-virus sp. | 2815035 | Viruses | Viruses | 58.4 | 4.71e-4 | NTclustered | gi|2015371934|gb|MW182753.1| | 2815035 | g2918872 | i0 | 94.737 | 0.156378600823045 | 38 | 1 | 16 | 1 | 25 | 62 | 2140 | 2104 | MAG: Ficedula mugimaki CRESS-DNA-virus sp. isolate muf159cir1 genomic sequence | blastn | 38 | 58.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Ficedula mugimaki CRESS-DNA-virus sp. | ||||||
| 10449520 | 10449520 | PRJNA1120060_P_NODE_2024269_length_272_cov_1.020101_g2006236_i0 | PRJNA1120060 | 2024269 | 272 | 1.020101 | 2.77467472 | Grapevine geminivirus A defective DNA | 1928761 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1898523535|gb|MT344724.1| | 1928761 | g2006236 | i0 | 100 | 0.220588235294118 | 30 | 0 | 11 | 0 | 165 | 194 | 1278 | 1307 | Grapevine geminivirus A defective DNA isolate def2019YM4, complete genome | blastn | 60 | 56.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Geminiviridae | Grapevine geminivirus A defective DNA | |||
| 23183659 | 23183659 | PRJNA1120060_P_NODE_1013599_length_312_cov_2.372385_g995670_i0 | PRJNA1120060 | 1013599 | 312 | 2.372385 | 7.4018412 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 52.8 | 0.029 | NTclustered | gi|2302020959|gb|MT208456.1| | 1954248 | g995670 | i0 | 94.286 | 0.112179487179487 | 35 | 1 | 11 | 1 | 38 | 71 | 3520 | 3486 | MAG: Circoviridae sp. isolate CN13_L19_588, complete genome | blastn | 35 | 52.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 23205309 | 23205309 | PRJNA1120060_P_NODE_2542159_length_252_cov_3.525140_g2524084_i0 | PRJNA1120060 | 2542159 | 252 | 3.52514 | 8.8833528 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2302017528|gb|MT205156.1| | 1954248 | g2524084 | i0 | 90.476 | 0.166666666666667 | 42 | 2 | 16 | 2 | 45 | 85 | 1856 | 1816 | MAG: Circoviridae sp. isolate CN3_L16_2910, complete genome | blastn | 42 | 54.7 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 23220708 | 23220708 | PRJNA1120060_P_NODE_586599_length_351_cov_1.179856_g568888_i0 | PRJNA1120060 | 586599 | 351 | 1.179856 | 4.14129456 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 52.8 | 0.033 | NTclustered | gi|2302008998|gb|MT202264.1| | 1954248 | g568888 | i0 | 100 | 0.0797720797720798 | 28 | 0 | 8 | 0 | 134 | 161 | 1191 | 1218 | MAG: Circoviridae sp. isolate CN3_L15_2942, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 29122586 | 29122586 | PRJNA1120060_P_NODE_3484949_length_208_cov_5.022222_g3466823_i0 | PRJNA1120060 | 3484949 | 208 | 5.022222 | 10.44622176 | Zebra finch circovirus | 1642515 | Viruses | Viruses | 42.4 | 0.0163 | NR | YP_009134742.1 | 1642515 | g3466823 | i0 | 37.1 | 0.894230769230769 | 62 | 35 | 83.7 | 2 | 2 | 175 | 4 | 65 | YP_009134742.1 ORFC2 [Zebra finch circovirus] | diamond | 186 | 42.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus zebrafinch |
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);;