contig_metadata
12 rows where bioproject = "PRJNA685607", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1942433 | 1942433 | PRJNA685607_P_NODE_80382_length_246_cov_0.890173_g80023_i0 | PRJNA685607 | 80382 | 246 | 0.890173 | 2.18982558 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g80023 | i0 | 100 | 0.341463414634146 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 84 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 4494387 | 4494387 | PRJNA685607_P_NODE_82844_length_245_cov_0.895349_g82485_i0 | PRJNA685607 | 82844 | 245 | 0.895349 | 2.19360505 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g82485 | i0 | 100 | 0.261224489795918 | 29 | 0 | 12 | 0 | 1 | 29 | 1 | 29 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 64 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 5770102 | 5770102 | PRJNA685607_P_NODE_90925_length_243_cov_0.876471_g90566_i0 | PRJNA685607 | 90925 | 243 | 0.876471 | 2.12982453 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g90566 | i0 | 100 | 0.234567901234568 | 29 | 0 | 12 | 0 | 215 | 243 | 29 | 1 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 7044945 | 7044945 | PRJNA685607_P_NODE_30606_length_328_cov_1.058824_g30247_i0 | PRJNA685607 | 30606 | 328 | 1.058824 | 3.47294272 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g30247 | i0 | 100 | 0.176829268292683 | 30 | 0 | 9 | 0 | 299 | 328 | 30 | 1 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 13420361 | 13420361 | PRJNA685607_P_NODE_74311_length_248_cov_0.880000_g73952_i0 | PRJNA685607 | 74311 | 248 | 0.88 | 2.1824 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 58.4 | 4.82e-4 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g73952 | i0 | 100 | 0.237903225806452 | 31 | 0 | 13 | 0 | 1 | 31 | 1 | 31 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 59 | 58.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 14695296 | 14695296 | PRJNA685607_P_NODE_49572_length_279_cov_1.286408_g49213_i0 | PRJNA685607 | 49572 | 279 | 1.286408 | 3.58907832 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 63.9 | 1.19e-5 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g49213 | i0 | 100 | 0.222222222222222 | 34 | 0 | 12 | 0 | 1 | 34 | 1 | 34 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 62 | 63.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 14695370 | 14695370 | PRJNA685607_P_NODE_73632_length_248_cov_0.880000_g73273_i0 | PRJNA685607 | 73632 | 248 | 0.88 | 2.1824 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g73273 | i0 | 100 | 0.225806451612903 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 56 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 14695426 | 14695426 | PRJNA685607_P_NODE_83412_length_245_cov_0.895349_g83053_i0 | PRJNA685607 | 83412 | 245 | 0.895349 | 2.19360505 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2672713159|gb|OR645555.1| | 881914 | g83053 | i0 | 100 | 0.23265306122449 | 29 | 0 | 12 | 0 | 1 | 29 | 1972 | 1944 | MAG: Tribec virus isolate Romania segment 3, complete sequence | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 19793437 | 19793437 | PRJNA685607_P_NODE_92776_length_242_cov_0.911243_g92417_i0 | PRJNA685607 | 92776 | 242 | 0.911243 | 2.20520806 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713155|gb|OR645553.1| | 881914 | g92417 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 215 | 242 | 28 | 1 | MAG: Tribec virus isolate Romania segment 1, complete sequence | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 21068888 | 21068888 | PRJNA685607_P_NODE_83997_length_245_cov_0.895349_g83638_i0 | PRJNA685607 | 83997 | 245 | 0.895349 | 2.19360505 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g83638 | i0 | 100 | 0.228571428571429 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 56 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 22343732 | 22343732 | PRJNA685607_P_NODE_78138_length_247_cov_0.885057_g77779_i0 | PRJNA685607 | 78138 | 247 | 0.885057 | 2.18609079 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g77779 | i0 | 100 | 0.226720647773279 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 56 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 24892495 | 24892495 | PRJNA685607_P_NODE_69320_length_250_cov_0.870056_g68961_i0 | PRJNA685607 | 69320 | 250 | 0.870056 | 2.17514 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|2672713155|gb|OR645553.1| | 881914 | g68961 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 1, complete sequence | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae |
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);;