contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1150539" and tax_kingdom = "Pararnavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7414566 | 7414566 | PRJNA1150539_S_NODE_38486_length_333_cov_1.873077_g37890_i0 | PRJNA1150539 | 38486 | 333 | 1.873077 | 6.23734641 | root | 1 | Root_unresolved | Root_unresolved | 588 | 1.93e-163 | NTclustered | gi|2269803171|gb|ON421495.1| | 11676 | g37890 | i0 | 100 | 99.1951951951952 | 318 | 0 | 95 | 0 | 16 | 333 | 6481 | 6164 | HIV-1 isolate M-2B5 from France gag protein (gag) gene, complete cds; pol protein (pol) gene, partial cds; vif protein (vif) gene, complete cds; nonfunctional vpr protein (vpr) gene, complete sequence; tat protein (tat) and rev protein (rev) genes, complete cds; nonfunctional vpu protein (vpu) gene, complete sequence; envelope glycoprotein (env) gene, complete cds; and nef protein (nef) gene, partial cds | blastn | 33032 | 592 | 0.993243243243243 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 12515416 | 12515416 | PRJNA1150539_S_NODE_3530_length_646_cov_8.036649_g2966_i0 | PRJNA1150539 | 3530 | 646 | 8.036649 | 51.91675254 | root | 1 | Root_unresolved | Root_unresolved | 1188 | 0 | NTclustered | gi|288187940|gb|GU345424.1| | 11676 | g2966 | i0 | 99.845 | 100 | 646 | 1 | 100 | 0 | 1 | 646 | 1870 | 1225 | HIV-1 isolate SQ4-319 from China pol protein (pol) gene, partial cds | blastn | 64600 | 1188 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 17614525 | 17614525 | PRJNA1150539_S_NODE_53074_length_306_cov_1.390558_g52478_i0 | PRJNA1150539 | 53074 | 306 | 1.390558 | 4.25510748 | root | 1 | Root_unresolved | Root_unresolved | 566 | 8.239999999999998e-157 | NTclustered | gi|717462921|gb|KM390026.1| | 11676 | g52478 | i0 | 100 | 99.6993464052288 | 306 | 0 | 100 | 0 | 1 | 306 | 5387 | 5082 | HIV-1 clone NL43I151V from USA, complete genome | blastn | 30508 | 566 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 20702717 | 20702717 | PRJNA1150539_S_NODE_43777_length_322_cov_3.855422_g43181_i0 | PRJNA1150539 | 43777 | 322 | 3.855422 | 12.41445884 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 52.8 | 0.03 | NTclustered | gi|2724777194|gb|PP677446.1| | 11676 | g43181 | i0 | 94.286 | 0.108695652173913 | 35 | 0 | 11 | 2 | 231 | 265 | 781 | 813 | HIV-1 isolate 2020LL1026 from China pol protein (pol) and gag protein (gag) genes, partial cds | blastn | 35 | 52.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 21438727 | 21438727 | PRJNA1150539_S_NODE_7377_length_477_cov_6.383663_g6783_i0 | PRJNA1150539 | 7377 | 477 | 6.383663 | 30.45007251 | root | 1 | Root_unresolved | Root_unresolved | 881 | 0 | NTclustered | gi|717462921|gb|KM390026.1| | 11676 | g6783 | i0 | 100 | 99.8658280922432 | 477 | 0 | 100 | 0 | 1 | 477 | 6637 | 6161 | HIV-1 clone NL43I151V from USA, complete genome | blastn | 47636 | 881 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 |
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);;