contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA404067" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10618459 | 10618459 | PRJNA404067_P_NODE_22269_length_230_cov_1.360947_g21882_i0 | PRJNA404067 | 22269 | 230 | 1.360947 | 3.1301781 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 159 | 1.18e-34 | NTclustered | gi|1675877000|gb|MK032720.1| | 2748378 | g21882 | i0 | 80.976 | 0.891304347826087 | 205 | 35 | 88 | 4 | 6 | 208 | 2164 | 2366 | MAG: Cressdnaviricota sp. isolate ctcb355, complete genome | blastn | 205 | 159 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 15717478 | 15717478 | PRJNA404067_P_NODE_3673_length_909_cov_10.586085_g3357_i0 | PRJNA404067 | 3673 | 909 | 10.586085 | 96.22751265 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 1639 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g3357 | i0 | 99.23 | 1 | 909 | 6 | 100 | 1 | 1 | 909 | 4536 | 3629 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 909 | 1639 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 16992392 | 16992392 | PRJNA404067_P_NODE_42814_length_183_cov_5.024590_g42427_i0 | PRJNA404067 | 42814 | 183 | 5.02459 | 9.1949997 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 226 | 8.679999999999998e-55 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g42427 | i0 | 100 | 1 | 122 | 0 | 100 | 0 | 1 | 122 | 4614 | 4493 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 183 | 226 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 19540400 | 19540400 | PRJNA404067_P_NODE_2756_length_1242_cov_17.993226_g2504_i0 | PRJNA404067 | 2756 | 1242 | 17.993226 | 223.47586692 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 2289 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g2504 | i0 | 99.919 | 1 | 1242 | 1 | 100 | 0 | 1 | 1242 | 1378 | 137 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 1242 | 2289 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 19540574 | 19540574 | PRJNA404067_P_NODE_3656_length_914_cov_8.643611_g3341_i0 | PRJNA404067 | 3656 | 914 | 8.643611 | 79.00260454 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 1666 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g3341 | i0 | 99.562 | 1 | 914 | 4 | 100 | 0 | 1 | 914 | 2824 | 3737 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 914 | 1666 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 22090987 | 22090987 | PRJNA404067_P_NODE_22178_length_230_cov_2.355030_g21791_i0 | PRJNA404067 | 22178 | 230 | 2.35503 | 5.416569 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 268 | 1.87e-67 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g21791 | i0 | 95.266 | 0.991304347826087 | 169 | 8 | 96 | 0 | 1 | 169 | 4307 | 4139 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 228 | 268 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 23366586 | 23366586 | PRJNA404067_P_NODE_2319_length_1504_cov_17.146916_g2100_i0 | PRJNA404067 | 2319 | 1504 | 17.146916 | 257.88961664 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 2732 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g2100 | i0 | 99.533 | 0.997340425531915 | 1500 | 7 | 99 | 0 | 3 | 1502 | 1393 | 2892 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 1500 | 2732 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 23366962 | 23366962 | PRJNA404067_P_NODE_4539_length_714_cov_7.563553_g4194_i0 | PRJNA404067 | 4539 | 714 | 7.563553 | 54.00376842 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 1206 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g4194 | i0 | 99.398 | 0.995798319327731 | 665 | 4 | 99 | 0 | 1 | 665 | 4554 | 5218 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 711 | 1206 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 24640791 | 24640791 | PRJNA404067_P_NODE_11260_length_318_cov_0.953307_g10875_i0 | PRJNA404067 | 11260 | 318 | 0.953307 | 3.03151626 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 416 | 9.169999999999998e-112 | NTclustered | gi|2302005281|gb|MT200828.1| | 1954248 | g10875 | i0 | 90.252 | 1.91509433962264 | 318 | 31 | 100 | 0 | 1 | 318 | 1263 | 1580 | MAG: Circoviridae sp. isolate CN13_L12_1, complete genome | blastn | 609 | 416 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard |
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);;