contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA315399" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 383873 | 383873 | PRJNA315399_P_NODE_68261_length_219_cov_5.620879_g67813_i0 | PRJNA315399 | 68261 | 219 | 5.620879 | 12.30972501 | Spiretrovirus homo8524 | 3117321 | Viruses | Viruses | 363 | 7.88e-96 | NTclustered | gi|2710393193|tpg|BK066703.1| | 3117321 | g67813 | i0 | 100 | 0.894977168949772 | 196 | 0 | 89 | 0 | 16 | 211 | 1451 | 1646 | MAG TPA_asm: Spiretrovirus homo8524 isolate Spiretro8524 genomic sequence | blastn | 196 | 363 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus homo8524 | ||||
| 4209189 | 4209189 | PRJNA315399_P_NODE_21824_length_290_cov_6.407115_g21381_i0 | PRJNA315399 | 21824 | 290 | 6.407115 | 18.5806335 | Spiretrovirus homo8524 | 3117321 | Viruses | Viruses | 322 | 1.85e-83 | NTclustered | gi|2710393193|tpg|BK066703.1| | 3117321 | g21381 | i0 | 99.435 | 1.69310344827586 | 177 | 1 | 83 | 0 | 96 | 272 | 7920 | 8096 | MAG TPA_asm: Spiretrovirus homo8524 isolate Spiretro8524 genomic sequence | blastn | 491 | 322 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus homo8524 | ||||
| 4893848 | 4893848 | PRJNA315399_P_NODE_380224_length_164_cov_2.866142_g379776_i0 | PRJNA315399 | 380224 | 164 | 2.866142 | 4.70047288 | root | 1 | Root_unresolved | Root_unresolved | 167 | 4.689999999999999e-37 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g379776 | i0 | 98.925 | 55.4939024390244 | 93 | 1 | 57 | 0 | 1 | 93 | 2688 | 2596 | Moloney murine leukemia virus, complete genome | blastn | 9101 | 167 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 10586079 | 10586079 | PRJNA315399_P_NODE_274789_length_180_cov_3.608392_g274341_i0 | PRJNA315399 | 274789 | 180 | 3.608392 | 6.4951056 | Spiretrovirus homo8524 | 3117321 | Viruses | Viruses | 139 | 1.14e-28 | NTclustered | gi|2710393193|tpg|BK066703.1| | 3117321 | g274341 | i0 | 100 | 0.794444444444444 | 75 | 0 | 79 | 0 | 93 | 167 | 2551 | 2625 | MAG TPA_asm: Spiretrovirus homo8524 isolate Spiretro8524 genomic sequence | blastn | 143 | 139 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus homo8524 | ||||
| 12544178 | 12544178 | PRJNA315399_P_NODE_236010_length_182_cov_10.648276_g235562_i0 | PRJNA315399 | 236010 | 182 | 10.648276 | 19.37986232 | root | 1 | Root_unresolved | Root_unresolved | 287 | 3.9e-73 | NTclustered | gi|2787679944|gb|PQ144805.1| | 11676 | g235562 | i0 | 100 | 85.1648351648352 | 155 | 0 | 85 | 0 | 11 | 165 | 1345 | 1191 | HIV-1 isolate Hu_NL_LA_M3171 from USA gag protein (gag) and pol protein (pol) genes, partial cds | blastn | 15500 | 287 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 13136770 | 13136770 | PRJNA315399_P_NODE_399751_length_161_cov_8.838710_g399303_i0 | PRJNA315399 | 399751 | 161 | 8.83871 | 14.2303231 | Spiretrovirus homo8524 | 3117321 | Viruses | Viruses | 231 | 1.5999999999999997e-56 | NTclustered | gi|2710393193|tpg|BK066703.1| | 3117321 | g399303 | i0 | 98.473 | 0.813664596273292 | 131 | 2 | 81 | 0 | 21 | 151 | 4595 | 4725 | MAG TPA_asm: Spiretrovirus homo8524 isolate Spiretro8524 genomic sequence | blastn | 131 | 231 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus homo8524 | ||||
| 14410377 | 14410377 | PRJNA315399_P_NODE_148972_length_189_cov_3.296053_g148524_i0 | PRJNA315399 | 148972 | 189 | 3.296053 | 6.22954017 | Spiretrovirus homo8524 | 3117321 | Viruses | Viruses | 315 | 1.8699999999999998e-81 | NTclustered | gi|2710393193|tpg|BK066703.1| | 3117321 | g148524 | i0 | 99.422 | 1.71428571428571 | 173 | 1 | 92 | 0 | 7 | 179 | 46 | 218 | MAG TPA_asm: Spiretrovirus homo8524 isolate Spiretro8524 genomic sequence | blastn | 324 | 315 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus homo8524 | ||||
| 14412820 | 14412820 | PRJNA315399_P_NODE_69472_length_218_cov_5.928177_g69024_i0 | PRJNA315399 | 69472 | 218 | 5.928177 | 12.92342586 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|2599476811|gb|OR521394.1| | 11676 | g69024 | i0 | 100 | 0.128440366972477 | 28 | 0 | 13 | 0 | 132 | 159 | 441 | 414 | HIV-1 clone 2021NB034 from China pol protein (pol) gene, partial cds | blastn | 28 | 52.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 17644626 | 17644626 | PRJNA315399_S_NODE_60154_length_204_cov_4.251497_g59953_i0 | PRJNA315399 | 60154 | 204 | 4.251497 | 8.67305388 | root | 1 | Root_unresolved | Root_unresolved | 346 | 7.29e-91 | NTclustered | gi|2787679944|gb|PQ144805.1| | 11676 | g59953 | i0 | 100 | 91.6666666666667 | 187 | 0 | 92 | 0 | 16 | 202 | 1370 | 1184 | HIV-1 isolate Hu_NL_LA_M3171 from USA gag protein (gag) and pol protein (pol) genes, partial cds | blastn | 18700 | 346 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 25293031 | 25293031 | PRJNA315399_S_NODE_25560_length_260_cov_3.856502_g25359_i0 | PRJNA315399 | 25560 | 260 | 3.856502 | 10.0269052 | root | 1 | Root_unresolved | Root_unresolved | 473 | 4.27e-129 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g25359 | i0 | 99.615 | 100 | 260 | 0 | 100 | 1 | 1 | 260 | 2958 | 2700 | Moloney murine leukemia virus, complete genome | blastn | 26000 | 473 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu |
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);;