contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA861969" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1236512 | 1236512 | PRJNA861969_P_NODE_37381_length_245_cov_0.895349_g37150_i0 | PRJNA861969 | 37381 | 245 | 0.895349 | 2.19360505 | root | 1 | Root_unresolved | Root_unresolved | 339 | 1.5199999999999998e-88 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g37150 | i0 | 99.462 | 100.620408163265 | 186 | 1 | 100 | 0 | 1 | 186 | 923 | 1108 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 24652 | 339 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 3788267 | 3788267 | PRJNA861969_P_NODE_21583_length_291_cov_2.472477_g21352_i0 | PRJNA861969 | 21583 | 291 | 2.472477 | 7.19490807 | root | 1 | Root_unresolved | Root_unresolved | 538 | 1.6999999999999994e-148 | NTclustered | gi|2288721861|gb|OP218818.1| | 10535 | g21352 | i0 | 100 | 100 | 291 | 0 | 100 | 0 | 1 | 291 | 2354 | 2644 | Unidentified adenovirus strain CHOP Ad5 | blastn | 29100 | 538 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 5064446 | 5064446 | PRJNA861969_P_NODE_17824_length_318_cov_1.624490_g17593_i0 | PRJNA861969 | 17824 | 318 | 1.62449 | 5.1658782 | root | 1 | Root_unresolved | Root_unresolved | 588 | 1.84e-163 | NTclustered | gi|2288721861|gb|OP218818.1| | 10535 | g17593 | i0 | 100 | 100 | 318 | 0 | 100 | 0 | 1 | 318 | 1716 | 2033 | Unidentified adenovirus strain CHOP Ad5 | blastn | 31800 | 588 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 10164951 | 10164951 | PRJNA861969_P_NODE_24568_length_277_cov_1.887255_g24337_i0 | PRJNA861969 | 24568 | 277 | 1.887255 | 5.22769635 | root | 1 | Root_unresolved | Root_unresolved | 512 | 9.73e-141 | NTclustered | gi|2288721861|gb|OP218818.1| | 10535 | g24337 | i0 | 100 | 100.794223826715 | 277 | 0 | 100 | 0 | 1 | 277 | 2303 | 2027 | Unidentified adenovirus strain CHOP Ad5 | blastn | 27920 | 512 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 19088046 | 19088046 | PRJNA861969_P_NODE_7935_length_457_cov_2.643229_g7704_i0 | PRJNA861969 | 7935 | 457 | 2.643229 | 12.07955653 | root | 1 | Root_unresolved | Root_unresolved | 516 | 1.31e-141 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g7704 | i0 | 100 | 100.35886214442 | 279 | 0 | 100 | 0 | 179 | 457 | 3499 | 3221 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 45864 | 516 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 20362813 | 20362813 | PRJNA861969_P_NODE_28176_length_261_cov_1.638298_g27945_i0 | PRJNA861969 | 28176 | 261 | 1.638298 | 4.27595778 | root | 1 | Root_unresolved | Root_unresolved | 483 | 7.12e-132 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g27945 | i0 | 100 | 100 | 261 | 0 | 100 | 0 | 1 | 261 | 13770 | 13510 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 26100 | 483 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 20362868 | 20362868 | PRJNA861969_P_NODE_35296_length_247_cov_0.885057_g35065_i0 | PRJNA861969 | 35296 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 457 | 4.05e-124 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g35065 | i0 | 100 | 100 | 247 | 0 | 100 | 0 | 1 | 247 | 14712 | 14466 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 24700 | 457 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 24187987 | 24187987 | PRJNA861969_P_NODE_32019_length_250_cov_0.870056_g31788_i0 | PRJNA861969 | 32019 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 462 | 8.83e-126 | NTclustered | gi|2079660852|emb|OU501478.1| | 10515 | g31788 | i0 | 100 | 100 | 250 | 0 | 100 | 0 | 1 | 250 | 17793 | 18042 | Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE | blastn | 25000 | 462 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari |
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);;