contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA849172" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3387062 | 3387062 | PRJNA849172_P_NODE_4383_length_1060_cov_78.398176_g4119_i0 | PRJNA849172 | 4383 | 1060 | 78.398176 | 831.0206656 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 1413 | 0 | NTclustered | gi|2130544298|dbj|LC648936.1| | 2875494 | g4119 | i0 | 90.951 | 1.01132075471698 | 1072 | 65 | 99 | 24 | 8 | 1060 | 1073 | 15 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 4, complete sequence | blastn | 1072 | 1413 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 4663217 | 4663217 | PRJNA849172_P_NODE_124624_length_228_cov_3.412903_g124264_i0 | PRJNA849172 | 124624 | 228 | 3.412903 | 7.78141884 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 355 | 1.38e-93 | NTclustered | gi|2396039473|gb|ON812832.1| | 2808997 | g124264 | i0 | 95.111 | 0.986842105263158 | 225 | 11 | 99 | 0 | 1 | 225 | 1460 | 1684 | MAG: Botourmiaviridae sp. isolate TIGMIC_1, complete genome | blastn | 225 | 355 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 4663546 | 4663546 | PRJNA849172_P_NODE_136764_length_211_cov_11.775362_g136404_i0 | PRJNA849172 | 136764 | 211 | 11.775362 | 24.84601382 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 372 | 1.25e-98 | NTclustered | gi|2396039473|gb|ON812832.1| | 2808997 | g136404 | i0 | 98.571 | 0.995260663507109 | 210 | 3 | 99 | 0 | 1 | 210 | 2503 | 2294 | MAG: Botourmiaviridae sp. isolate TIGMIC_1, complete genome | blastn | 210 | 372 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 8488370 | 8488370 | PRJNA849172_P_NODE_1727_length_1649_cov_20.180838_g1594_i0 | PRJNA849172 | 1727 | 1649 | 20.180838 | 332.78201862 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 2320 | 0 | NTclustered | gi|2130544296|dbj|LC648935.1| | 2875494 | g1594 | i0 | 92.266 | 1.63856882959369 | 1642 | 117 | 99 | 9 | 12 | 1649 | 1653 | 18 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 3, complete sequence | blastn | 2702 | 2320 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 18685451 | 18685451 | PRJNA849172_P_NODE_10315_length_668_cov_4.347899_g9963_i0 | PRJNA849172 | 10315 | 668 | 4.347899 | 29.04396532 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 802 | 0 | NTclustered | gi|2130544291|dbj|LC648933.1| | 2875494 | g9963 | i0 | 88.358 | 1.00299401197605 | 670 | 74 | 100 | 4 | 1 | 668 | 111 | 778 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 1, complete sequence | blastn | 670 | 802 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 19961455 | 19961455 | PRJNA849172_P_NODE_1336_length_1818_cov_44.459599_g1230_i0 | PRJNA849172 | 1336 | 1818 | 44.459599 | 808.27550982 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 1070 | 0 | NTclustered | gi|2130544293|dbj|LC648934.1| | 2875494 | g1230 | i0 | 79.2 | 1.12101210121012 | 1601 | 287 | 87 | 39 | 16 | 1599 | 84 | 1655 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 2, complete sequence | blastn | 2038 | 1070 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 21237866 | 21237866 | PRJNA849172_P_NODE_26437_length_399_cov_16.036810_g26078_i0 | PRJNA849172 | 26437 | 399 | 16.03681 | 63.9868719 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 593 | 5.059999999999998e-165 | NTclustered | gi|2130544291|dbj|LC648933.1| | 2875494 | g26078 | i0 | 93.924 | 0.989974937343358 | 395 | 21 | 98 | 2 | 7 | 398 | 3381 | 2987 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 1, complete sequence | blastn | 395 | 593 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 25062923 | 25062923 | PRJNA849172_P_NODE_560_length_2444_cov_16.794601_g505_i0 | PRJNA849172 | 560 | 2444 | 16.794601 | 410.46004844 | Hulunbuir Botou tick virus 2 | 2972054 | Viruses | Viruses | 4348 | 0 | NTclustered | gi|2820295211|gb|PQ180957.1| | 2972054 | g505 | i0 | 98.773 | 12.7385433715221 | 2444 | 30 | 100 | 0 | 1 | 2444 | 68 | 2511 | MAG: Hulunbuir Botou tick virus 2 isolate Hebei_107 genomic sequence | blastn | 31133 | 4348 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Hulunbuir Botou tick virus 2 |
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);;