contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA934472" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 911282 | 911282 | PRJNA934472_P_NODE_39741_length_231_cov_3.006329_g39363_i0 | PRJNA934472 | 39741 | 231 | 3.006329 | 6.94461999 | Sopapen virus | 3131614 | Viruses | Viruses | 130 | 9.27e-26 | NTclustered | gi|2717322942|gb|PP173915.1| | 3131614 | g39363 | i0 | 94.118 | 2.17748917748918 | 85 | 5 | 37 | 0 | 1 | 85 | 514 | 430 | MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence | blastn | 503 | 130 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopapen virus | |||||
| 2186522 | 2186522 | PRJNA934472_P_NODE_33842_length_256_cov_1.262295_g33464_i0 | PRJNA934472 | 33842 | 256 | 1.262295 | 3.2314752 | Curvularia homomorpha narnavirus 1 | 3111958 | Viruses | Viruses | 318 | 2.0799999999999998e-82 | NTclustered | gi|2645095085|gb|OQ162166.1| | 3111958 | g33464 | i0 | 89.105 | 1.00390625 | 257 | 26 | 100 | 2 | 1 | 256 | 438 | 693 | Curvularia homomorpha narnavirus 1 strain ChNV1/ZZ13-2, complete genome | blastn | 257 | 318 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Curvularia homomorpha narnavirus 1 | ||
| 16214286 | 16214286 | PRJNA934472_P_NODE_40273_length_217_cov_8.555556_g39895_i0 | PRJNA934472 | 40273 | 217 | 8.555556 | 18.56555652 | Sopapal virus | 3131818 | Viruses | Viruses | 60.2 | 1.15e-4 | NTclustered | gi|2717323464|gb|PP174119.1| | 3131818 | g39895 | i0 | 100 | 0.147465437788018 | 32 | 0 | 15 | 0 | 1 | 32 | 2386 | 2355 | MAG: Sopapal virus isolate SP1C_k141_7609 genomic sequence | blastn | 32 | 60.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sopapal virus | |||
| 18762796 | 18762796 | PRJNA934472_P_NODE_33135_length_258_cov_2.621622_g32757_i0 | PRJNA934472 | 33135 | 258 | 2.621622 | 6.76378476 | Chronacard virus | 3129783 | Viruses | Viruses | 233 | 7.809999999999999e-57 | NTclustered | gi|2717318323|gb|PP172180.1| | 3129783 | g32757 | i0 | 88.66 | 583.720930232558 | 194 | 18 | 74 | 4 | 1 | 192 | 194 | 3 | MAG: Chronacard virus isolate CN1A_k141_43539 genomic sequence | blastn | 150600 | 233 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronacard virus | |||
| 20037973 | 20037973 | PRJNA934472_P_NODE_6516_length_546_cov_3.627907_g6203_i0 | PRJNA934472 | 6516 | 546 | 3.627907 | 19.80837222 | Moss associated narna-like virus 47 | 3067006 | Viruses | Viruses | 91.6 | 1.14e-13 | NTclustered | gi|2626077323|gb|OQ987542.1| | 3067006 | g6203 | i0 | 91.045 | 0.741758241758242 | 67 | 6 | 12 | 0 | 1 | 67 | 438 | 372 | MAG: Moss associated narna-like virus 47 isolate DICBIL genomic sequence | blastn | 405 | 91.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Moss associated narna-like virus 47 |
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);;