contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA784979" and tax_phylum = "Cressdnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3316819 | 3316819 | PRJNA784979_S_NODE_343_length_2132_cov_56.326932_g339_i0 | PRJNA784979 | 343 | 2132 | 56.326932 | 1200.89019024 | Reagent-associated CRESS-like virus 2 | 2875810 | Viruses | Viruses | 3408 | 0 | NTclustered | gi|2094552987|gb|MZ824236.1| | 2875810 | g339 | i0 | 100 | 6.38696060037523 | 1845 | 0 | 100 | 0 | 288 | 2132 | 2377 | 533 | Reagent-associated CRESS-like virus 2 isolate 8 replicase-like gene, partial sequence | blastn | 13617 | 3408 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 2 | ||||||
| 7144043 | 7144043 | PRJNA784979_S_NODE_6566_length_195_cov_1.363014_g6524_i0 | PRJNA784979 | 6566 | 195 | 1.363014 | 2.6578773 | Cynopterus sphinx circular DNA virus 10 | 3064083 | Viruses | Viruses | 246 | 7.2e-61 | NTclustered | gi|2593361801|gb|OQ351951.1| | 3064083 | g6524 | i0 | 90.761 | 0.943589743589744 | 184 | 17 | 94 | 0 | 5 | 188 | 1489 | 1672 | MAG: Cynopterus sphinx circular DNA virus 10 isolate B468G10 genomic sequence | blastn | 184 | 246 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 10 | ||||||
| 8418678 | 8418678 | PRJNA784979_S_NODE_4627_length_221_cov_2.412791_g4585_i0 | PRJNA784979 | 4627 | 221 | 2.412791 | 5.33226811 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 86.1 | 1.93e-12 | NTclustered | gi|2302011143|gb|MT202679.1| | 1954248 | g4585 | i0 | 87.838 | 0.334841628959276 | 74 | 8 | 33 | 1 | 143 | 216 | 1885 | 1957 | MAG: Circoviridae sp. isolate CN23_L15_3196, complete genome | blastn | 74 | 86.1 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 12245111 | 12245111 | PRJNA784979_S_NODE_12770_length_162_cov_0.938053_g12728_i0 | PRJNA784979 | 12770 | 162 | 0.938053 | 1.51964586 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 296 | 5.64e-76 | NTclustered | gi|1436211682|gb|MH617353.1| | 2748378 | g12728 | i0 | 100 | 1.61728395061728 | 160 | 0 | 99 | 0 | 3 | 162 | 5541 | 5700 | MAG: Cressdnaviricota sp. isolate ctce741, complete genome | blastn | 262 | 296 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 13519337 | 13519337 | PRJNA784979_S_NODE_2171_length_315_cov_2.172932_g2129_i0 | PRJNA784979 | 2171 | 315 | 2.172932 | 6.8447358 | Cynopterus sphinx circular DNA virus 10 | 3064083 | Viruses | Viruses | 259 | 1.6200000000000003e-64 | NTclustered | gi|2593361801|gb|OQ351951.1| | 3064083 | g2129 | i0 | 82.075 | 1.00952380952381 | 318 | 44 | 97 | 6 | 9 | 315 | 828 | 1143 | MAG: Cynopterus sphinx circular DNA virus 10 isolate B468G10 genomic sequence | blastn | 318 | 259 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 10 | ||||||
| 13519353 | 13519353 | PRJNA784979_S_NODE_6251_length_199_cov_0.866667_g6209_i0 | PRJNA784979 | 6251 | 199 | 0.866667 | 1.72466733 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 63.9 | 7.98e-6 | NTclustered | gi|2906154851|gb|PQ646830.1| | 2809008 | g6209 | i0 | 100 | 0.517587939698492 | 34 | 0 | 17 | 0 | 12 | 45 | 2537 | 2570 | MAG: Cirlivirales sp. isolate k127_3981985 genomic sequence | blastn | 103 | 63.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 18617143 | 18617143 | PRJNA784979_S_NODE_9795_length_169_cov_1.808333_g9753_i0 | PRJNA784979 | 9795 | 169 | 1.808333 | 3.05608277 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 69.4 | 1.4e-7 | NTclustered | gi|2906154851|gb|PQ646830.1| | 2809008 | g9753 | i0 | 86.154 | 1.02366863905325 | 65 | 8 | 38 | 1 | 79 | 142 | 2542 | 2606 | MAG: Cirlivirales sp. isolate k127_3981985 genomic sequence | blastn | 173 | 69.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales 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);;