contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJEB75017" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8648713 | 8648713 | PRJEB75017_P_NODE_17787_length_243_cov_1.800000_g17658_i0 | PRJEB75017 | 17787 | 243 | 1.8 | 4.374 | root | 1 | Root_unresolved | Root_unresolved | 449 | 6.65e-122 | NTclustered | gi|27447413|gb|AY102920.1| | 11276 | g17658 | i0 | 100 | 100 | 243 | 0 | 100 | 0 | 1 | 243 | 1542 | 1300 | Vesicular stomatitis virus serotype Indiana panhandle-type defective interfering particle Ind-ST | blastn | 24300 | 449 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 11198881 | 11198881 | PRJEB75017_P_NODE_4329_length_421_cov_1.117816_g4200_i0 | PRJEB75017 | 4329 | 421 | 1.117816 | 4.70600536 | root | 1 | Root_unresolved | Root_unresolved | 778 | 0 | NTclustered | gi|2649349941|gb|OR995580.1| | 11276 | g4200 | i0 | 100 | 99.9857482185273 | 421 | 0 | 100 | 0 | 1 | 421 | 2566 | 2986 | Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome | blastn | 42094 | 778 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 11198890 | 11198890 | PRJEB75017_P_NODE_9309_length_297_cov_1.392857_g9180_i0 | PRJEB75017 | 9309 | 297 | 1.392857 | 4.13678529 | root | 1 | Root_unresolved | Root_unresolved | 549 | 8.029999999999997e-152 | NTclustered | gi|2649349941|gb|OR995580.1| | 11276 | g9180 | i0 | 100 | 100 | 297 | 0 | 100 | 0 | 1 | 297 | 8098 | 8394 | Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome | blastn | 29700 | 549 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 15023483 | 15023483 | PRJEB75017_P_NODE_18072_length_243_cov_0.917647_g17943_i0 | PRJEB75017 | 18072 | 243 | 0.917647 | 2.22988221 | root | 1 | Root_unresolved | Root_unresolved | 449 | 6.65e-122 | NTclustered | gi|2649349941|gb|OR995580.1| | 11276 | g17943 | i0 | 100 | 100 | 243 | 0 | 100 | 0 | 1 | 243 | 724 | 482 | Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome | blastn | 24300 | 449 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 18847296 | 18847296 | PRJEB75017_P_NODE_9575_length_293_cov_1.854545_g9446_i0 | PRJEB75017 | 9575 | 293 | 1.854545 | 5.43381685 | root | 1 | Root_unresolved | Root_unresolved | 536 | 6.149999999999998e-148 | NTclustered | gi|2649349941|gb|OR995580.1| | 11276 | g9446 | i0 | 99.659 | 100 | 293 | 1 | 100 | 0 | 1 | 293 | 6685 | 6977 | Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome | blastn | 29300 | 536 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 20122073 | 20122073 | PRJEB75017_P_NODE_11496_length_274_cov_1.631841_g11367_i0 | PRJEB75017 | 11496 | 274 | 1.631841 | 4.47124434 | root | 1 | Root_unresolved | Root_unresolved | 501 | 2.08e-137 | NTclustered | gi|27447413|gb|AY102920.1| | 11276 | g11367 | i0 | 99.635 | 100 | 274 | 1 | 100 | 0 | 1 | 274 | 161 | 434 | Vesicular stomatitis virus serotype Indiana panhandle-type defective interfering particle Ind-ST | blastn | 27400 | 501 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus |
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);;