contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA983848" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1271595 | 1271595 | PRJNA983848_P_NODE_150081_length_247_cov_0.896552_g144198_i0 | PRJNA983848 | 150081 | 247 | 0.896552 | 2.21448344 | Viruses | 10239 | Viruses | Viruses | 248 | 2.65e-61 | NTclustered | gi|1817928471|gb|MN988496.1| | 2509575 | g144198 | i0 | 87.736 | 2.78542510121457 | 212 | 26 | 86 | 0 | 36 | 247 | 45134 | 44923 | Rhizobium phage RHph_TM3_3_14B, complete genome | blastn | 688 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage RHph_TM3_3_14B | |||||
| 2245710 | 2245710 | PRJNA983848_P_NODE_72862_length_368_cov_1.515254_g66979_i0 | PRJNA983848 | 72862 | 368 | 1.515254 | 5.57613472 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.035 | NTclustered | gi|2057905075|tpg|BK051223.1| | 2832643 | g66979 | i0 | 100 | 0.152173913043478 | 28 | 0 | 8 | 0 | 23 | 50 | 18602 | 18575 | MAG TPA_asm: Caudoviricetes sp. isolate ctHTF4, partial genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11171078 | 11171078 | PRJNA983848_P_NODE_143989_length_250_cov_0.881356_g138106_i0 | PRJNA983848 | 143989 | 250 | 0.881356 | 2.20339 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.91e-122 | NTclustered | gi|2915024281|gb|OR222600.1| | 2832643 | g138106 | i0 | 99.595 | 99.14 | 247 | 1 | 99 | 0 | 1 | 247 | 27305 | 27551 | MAG: Caudoviricetes sp. isolate MSP0334 genomic sequence | blastn | 24785 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13722936 | 13722936 | PRJNA983848_P_NODE_42031_length_574_cov_2.808383_g36182_i0 | PRJNA983848 | 42031 | 574 | 2.808383 | 16.12011842 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.016 | NTclustered | gi|2057056863|tpg|BK037435.1| | 2832643 | g36182 | i0 | 100 | 0.0505226480836237 | 29 | 0 | 5 | 0 | 180 | 208 | 13449 | 13421 | MAG TPA_asm: Caudoviricetes sp. isolate ctKbT3, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14994470 | 14994470 | PRJNA983848_P_NODE_110832_length_286_cov_0.741784_g104949_i0 | PRJNA983848 | 110832 | 286 | 0.741784 | 2.12150224 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 126 | 1.5399999999999999e-24 | NTclustered | gi|2059608416|tpg|BK037250.1| | 2832643 | g104949 | i0 | 82.313 | 0.513986013986014 | 147 | 24 | 51 | 2 | 16 | 161 | 17633 | 17778 | MAG TPA_asm: Caudoviricetes sp. isolate ctmNp13, partial genome | blastn | 147 | 126 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16270946 | 16270946 | PRJNA983848_P_NODE_155933_length_244_cov_0.912281_g150050_i0 | PRJNA983848 | 155933 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 388 | 1.48e-103 | NTclustered | gi|2914754492|gb|OR221467.1| | 2832643 | g150050 | i0 | 96.97 | 1.90983606557377 | 231 | 7 | 95 | 0 | 1 | 231 | 31141 | 30911 | MAG: Caudoviricetes sp. isolate MSP1619 genomic sequence | blastn | 466 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17545754 | 17545754 | PRJNA983848_P_NODE_150134_length_247_cov_0.896552_g144251_i0 | PRJNA983848 | 150134 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2915019340|gb|OR222551.1| | 2832643 | g144251 | i0 | 100 | 9.93117408906883 | 247 | 0 | 100 | 0 | 1 | 247 | 39676 | 39430 | MAG: Caudoviricetes sp. isolate MSP0382 genomic sequence | blastn | 2453 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;