contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB12366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20745 | 20745 | PRJEB12366_P_NODE_1441_length_718_cov_27.983895_g1295_i0 | PRJEB12366 | 1441 | 718 | 27.983895 | 200.9243661 | Nilaparvata lugens C virus | 1577072 | Viruses | Viruses | 99 | 9.09e-16 | NTclustered | gi|726973360|gb|KM270560.1| | 1577072 | g1295 | i0 | 91.781 | 1.79805013927577 | 73 | 2 | 10 | 3 | 627 | 696 | 9048 | 9119 | Nilaparvata lugens C virus, complete genome | blastn | 1291 | 99 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Nilaparvata lugens C virus | ||
| 20825 | 20825 | PRJEB12366_S_NODE_1621_length_192_cov_6.949045_g1613_i0 | PRJEB12366 | 1621 | 192 | 6.949045 | 13.3421664 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2057099742|tpg|BK038287.1| | 2832643 | g1613 | i0 | 100 | 0.348958333333333 | 29 | 0 | 15 | 0 | 164 | 192 | 17627 | 17655 | MAG TPA_asm: Caudoviricetes sp. isolate ctSy120, partial genome | blastn | 67 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2570695 | 2570695 | PRJEB12366_S_NODE_323_length_272_cov_3.924051_g315_i0 | PRJEB12366 | 323 | 272 | 3.924051 | 10.67341872 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2052989461|tpg|BK030804.1| | 2832643 | g315 | i0 | 100 | 0.533088235294118 | 29 | 0 | 11 | 0 | 244 | 272 | 42 | 14 | MAG TPA_asm: Caudoviricetes sp. isolate ctoES23, partial genome | blastn | 145 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5123205 | 5123205 | PRJEB12366_S_NODE_1225_length_205_cov_64.341176_g1217_i0 | PRJEB12366 | 1225 | 205 | 64.341176 | 131.8994108 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.1 | 2.97e-5 | NTclustered | gi|2914779711|gb|OR222261.1| | 2832643 | g1217 | i0 | 100 | 16.8390243902439 | 33 | 0 | 16 | 0 | 173 | 205 | 48 | 16 | MAG: Caudoviricetes sp. isolate MSP0706 genomic sequence | blastn | 3452 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7673015 | 7673015 | PRJEB12366_S_NODE_727_length_225_cov_13.484211_g719_i0 | PRJEB12366 | 727 | 225 | 13.484211 | 30.33947475 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.02 | NTclustered | gi|2914889788|gb|OR222639.1| | 2832643 | g719 | i0 | 100 | 0.124444444444444 | 28 | 0 | 12 | 0 | 198 | 225 | 59725 | 59752 | MAG: Caudoviricetes sp. isolate MSP0290 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10223575 | 10223575 | PRJEB12366_S_NODE_2309_length_175_cov_3.814286_g2301_i0 | PRJEB12366 | 2309 | 175 | 3.814286 | 6.6750005 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|2914801528|gb|OR221207.1| | 2832643 | g2301 | i0 | 100 | 0.16 | 28 | 0 | 16 | 0 | 148 | 175 | 40047 | 40074 | MAG: Caudoviricetes sp. isolate MSP1915 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16597616 | 16597616 | PRJEB12366_S_NODE_634_length_231_cov_11.255102_g626_i0 | PRJEB12366 | 634 | 231 | 11.255102 | 25.99928562 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 58.4 | 4.44e-4 | NTclustered | gi|2914929465|gb|OR221553.1| | 2832643 | g626 | i0 | 100 | 14.4891774891775 | 31 | 0 | 13 | 0 | 1 | 31 | 20 | 50 | MAG: Caudoviricetes sp. isolate MSP1526 genomic sequence | blastn | 3347 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21697531 | 21697531 | PRJEB12366_S_NODE_178_length_334_cov_116.826087_g170_i0 | PRJEB12366 | 178 | 334 | 116.826087 | 390.19913058 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 106 | 2.38e-18 | NTclustered | gi|2914981896|gb|OR222105.1| | 2832643 | g170 | i0 | 96.875 | 19.2395209580838 | 64 | 1 | 19 | 1 | 1 | 64 | 12 | 74 | MAG: Caudoviricetes sp. isolate MSP0005 genomic sequence | blastn | 6426 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21697532 | 21697532 | PRJEB12366_S_NODE_618_length_232_cov_18.873096_g610_i0 | PRJEB12366 | 618 | 232 | 18.873096 | 43.78558272 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.9 | 9.58e-6 | NTclustered | gi|2057153112|tpg|BK058538.1| | 2832643 | g610 | i0 | 91.489 | 14.1163793103448 | 47 | 3 | 20 | 1 | 185 | 231 | 93288 | 93333 | MAG TPA_asm: Caudoviricetes sp. isolate ctoh412, partial genome | blastn | 3275 | 63.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24246608 | 24246608 | PRJEB12366_P_NODE_7900_length_278_cov_39.534979_g7710_i0 | PRJEB12366 | 7900 | 278 | 39.534979 | 109.90724162 | Mitovirus sp. | 2587224 | Viruses | Viruses | 174 | 5.23e-39 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g7710 | i0 | 94.643 | 3.37769784172662 | 112 | 6 | 40 | 0 | 163 | 274 | 112 | 1 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 939 | 174 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. |
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);;