contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25756456 | 25756456 | PRJNA1233465b_S_NODE_260362_length_186_cov_1328.233577_g258677_i0 | PRJNA1233465 | 260362 | 186 | 1328.233577 | 2470.51445322 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.004 | NTclustered | gi|2717470344|gb|PP272778.1| | 28875 | g258677 | i0 | 100 | 0.311827956989247 | 29 | 0 | 16 | 0 | 104 | 132 | 3315 | 3287 | MAG: Rotavirus A isolate sedore_2 structural protein VP1 gene, complete cds | blastn | 58 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 25758876 | 25758876 | PRJNA1233465e_S_NODE_68394_length_225_cov_3188.829545_g67084_i0 | PRJNA1233465 | 68394 | 225 | 3188.829545 | 7174.86647625 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 4.3e-4 | NTclustered | gi|2717470344|gb|PP272778.1| | 28875 | g67084 | i0 | 100 | 0.275555555555556 | 31 | 0 | 14 | 0 | 172 | 202 | 3315 | 3285 | MAG: Rotavirus A isolate sedore_2 structural protein VP1 gene, complete cds | blastn | 62 | 58.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 26302541 | 26302541 | PRJNA1233465e_S_NODE_41094_length_279_cov_10653.439130_g39784_i0 | PRJNA1233465 | 41094 | 279 | 10653.43913 | 29723.0951727 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 5.52e-4 | NTclustered | gi|2717470344|gb|PP272778.1| | 28875 | g39784 | i0 | 100 | 0.222222222222222 | 31 | 0 | 11 | 0 | 24 | 54 | 3285 | 3315 | MAG: Rotavirus A isolate sedore_2 structural protein VP1 gene, complete cds | blastn | 62 | 58.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 26438986 | 26438986 | PRJNA1233465e_S_NODE_84255_length_207_cov_0.898734_g82945_i0 | PRJNA1233465 | 84255 | 207 | 0.898734 | 1.86037938 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 3.89e-4 | NTclustered | gi|2717470344|gb|PP272778.1| | 28875 | g82945 | i0 | 100 | 0.314009661835749 | 31 | 0 | 15 | 0 | 175 | 205 | 3285 | 3315 | MAG: Rotavirus A isolate sedore_2 structural protein VP1 gene, complete cds | blastn | 65 | 58.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 26440352 | 26440352 | PRJNA1233465f_S_NODE_68911_length_279_cov_42.056522_g66631_i0 | PRJNA1233465 | 68911 | 279 | 42.056522 | 117.33769638 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.007 | NTclustered | gi|2717470344|gb|PP272778.1| | 28875 | g66631 | i0 | 96.875 | 0.218637992831541 | 32 | 1 | 11 | 0 | 248 | 279 | 3283 | 3314 | MAG: Rotavirus A isolate sedore_2 structural protein VP1 gene, complete cds | blastn | 61 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 26487577 | 26487577 | PRJNA1233465a_S_NODE_53832_length_287_cov_2.008403_g52558_i0 | PRJNA1233465 | 53832 | 287 | 2.008403 | 5.76411661 | Colorado tick fever virus | 46839 | Viruses | Viruses | 276 | 1.45e-69 | NTclustered | gi|2758887253|gb|PP473574.1| | 46839 | g52558 | i0 | 95.93 | 1.91289198606272 | 172 | 3 | 59 | 3 | 119 | 287 | 4490 | 4660 | MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence | blastn | 549 | 276 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Coltivirus | Coltivirus dermacentoris | ||
| 26570758 | 26570758 | PRJNA1233465a_S_NODE_204504_length_172_cov_0.747967_g203230_i0 | PRJNA1233465 | 204504 | 172 | 0.747967 | 1.28650324 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.001 | NTclustered | gi|2717470344|gb|PP272778.1| | 28875 | g203230 | i0 | 97.059 | 0.372093023255814 | 34 | 0 | 19 | 1 | 9 | 41 | 3315 | 3282 | MAG: Rotavirus A isolate sedore_2 structural protein VP1 gene, complete cds | blastn | 64 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis |
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);;