contig_metadata
6 rows where bioproject = "PRJNA493632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3016144 | 3016144 | PRJNA493632_P_NODE_51663_length_597_cov_1.788168_g48424_i0 | PRJNA493632 | 51663 | 597 | 1.788168 | 10.67536296 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 872 | 0 | NTclustered | gi|2067465795|gb|MW678893.1| | 2202565 | g48424 | i0 | 93.654 | 1.66834170854271 | 583 | 37 | 98 | 0 | 8 | 590 | 1 | 583 | MAG: Genomoviridae sp. isolate D10_10246, complete genome | blastn | 996 | 872 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 11940097 | 11940097 | PRJNA493632_P_NODE_305890_length_293_cov_3.113636_g302452_i0 | PRJNA493632 | 305890 | 293 | 3.113636 | 9.12295348 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 470 | 6.33e-128 | NTclustered | gi|2067465795|gb|MW678893.1| | 2202565 | g302452 | i0 | 95.563 | 17.6587030716724 | 293 | 13 | 100 | 0 | 1 | 293 | 1328 | 1036 | MAG: Genomoviridae sp. isolate D10_10246, complete genome | blastn | 5174 | 470 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 15771559 | 15771559 | PRJNA493632_P_NODE_728633_length_202_cov_5.209302_g725190_i0 | PRJNA493632 | 728633 | 202 | 5.209302 | 10.52279004 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 267 | 5.77e-67 | NTclustered | gi|2384852566|gb|OM154726.1| | 2748378 | g725190 | i0 | 90.547 | 0.995049504950495 | 201 | 19 | 99 | 0 | 2 | 202 | 167 | 367 | MAG: Cressdnaviricota sp. isolate Miresoil virus 95, complete genome | blastn | 201 | 267 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 24693653 | 24693653 | PRJNA493632_P_NODE_662200_length_241_cov_0.886905_g658759_i0 | PRJNA493632 | 662200 | 241 | 0.886905 | 2.13744105 | Camellia oleifera geminivirus | 2713609 | Viruses | Viruses | 250 | 7.17e-62 | NTclustered | gi|1815417282|gb|MN161582.1| | 2713609 | g658759 | i0 | 86.404 | 1.2448132780083 | 228 | 31 | 95 | 0 | 8 | 235 | 1685 | 1458 | Camellia oleifera geminivirus isolate Pxcs-11 segment DNA-B, complete sequence | blastn | 300 | 250 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Geminiviridae | Camellia oleifera geminivirus | |||
| 26855358 | 26855358 | PRJNA493632_P_NODE_508141_length_251_cov_0.865169_g504702_i0 | PRJNA493632 | 508141 | 251 | 0.865169 | 2.17157419 | Porcine circovirus 2 | 85708 | Viruses | Viruses | 50.8 | 3.83e-5 | NR | AIT52334.1 | 85708 | g504702 | i0 | 42 | 1.9003984063745 | 69 | 23 | 82.5 | 1 | 208 | 2 | 108 | 159 | AIT52334.1 truncated ORF2 [Porcine circovirus 2] | diamond | 477 | 50.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus porcine2 | ||
| 31150434 | 31150434 | PRJNA493632_P_NODE_565035_length_247_cov_0.885057_g561596_i0 | PRJNA493632 | 565035 | 247 | 0.885057 | 2.18609079 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 73.9 | 1.05e-13 | NR | AWW06122.1 | 2748378 | g561596 | i0 | 41.5 | 0.995951417004049 | 82 | 46 | 97.2 | 1 | 8 | 247 | 154 | 235 | AWW06122.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 246 | 73.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota 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);;