contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax_phylum = "Cossaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27370465 | 27370465 | PRJNA800053_P_NODE_2643_length_533_cov_2.676087_g2484_i0 | PRJNA800053 | 2643 | 533 | 2.676087 | 14.26354371 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 166 | 5.709999999999999e-46 | NR | XNT20749.1 | 1940570 | g2484 | i0 | 44.9 | 0.9906191369606 | 176 | 96 | 99.1 | 1 | 4 | 531 | 204 | 378 | XNT20749.1 MAG: replication protein [Parvoviridae sp.] | diamond | 528 | 166 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 28285588 | 28285588 | PRJNA800053_P_NODE_1186_length_735_cov_10.009063_g1047_i0 | PRJNA800053 | 1186 | 735 | 10.009063 | 73.56661305 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 182 | 7.63e-51 | NR | XNT20749.1 | 1940570 | g1047 | i0 | 40.4 | 1.04081632653061 | 255 | 136 | 98 | 7 | 15 | 734 | 29 | 282 | XNT20749.1 MAG: replication protein [Parvoviridae sp.] | diamond | 765 | 182 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 28348921 | 28348921 | PRJNA800053_P_NODE_14866_length_266_cov_1.585492_g14702_i0 | PRJNA800053 | 14866 | 266 | 1.585492 | 4.21740872 | Phoenicopterus roseus parvo-like hybrid virus | 2794530 | Viruses | Viruses | 68.2 | 5.02e-11 | NR | QTE03705.1 | 2794530 | g14702 | i0 | 39.5 | 0.969924812030075 | 86 | 52 | 97 | 0 | 5 | 262 | 273 | 358 | QTE03705.1 MAG: capsid protein, partial [Phoenicopterus roseus parvo-like hybrid virus] | diamond | 258 | 68.2 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Phoenicopterus roseus parvo-like hybrid virus | |||
| 28412182 | 28412182 | PRJNA800053_P_NODE_5726_length_384_cov_2.231511_g5563_i0 | PRJNA800053 | 5726 | 384 | 2.231511 | 8.56900224 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 102 | 1.14e-22 | NR | XNT20757.1 | 1940570 | g5563 | i0 | 45.7 | 0.90625 | 116 | 62 | 90.6 | 1 | 374 | 27 | 288 | 402 | XNT20757.1 MAG: replication protein [Parvoviridae sp.] | diamond | 348 | 102 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 28696459 | 28696459 | PRJNA800053_P_NODE_2747_length_523_cov_5.580000_g2587_i0 | PRJNA800053 | 2747 | 523 | 5.58 | 29.1834 | Accipiter gentilis parvo-like hybrid virus | 2794564 | Viruses | Viruses | 58.2 | 2.34e-6 | NR | QTE04017.1 | 2794564 | g2587 | i0 | 31.3 | 1.02676864244742 | 179 | 67 | 94.6 | 9 | 9 | 503 | 41 | 177 | QTE04017.1 MAG: putative capsid protein [Accipiter gentilis parvo-like hybrid virus] | diamond | 537 | 58.2 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Accipiter gentilis parvo-like hybrid virus | |||
| 29233172 | 29233172 | PRJNA800053_P_NODE_2929_length_508_cov_4.011494_g2769_i0 | PRJNA800053 | 2929 | 508 | 4.011494 | 20.37838952 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 49.3 | 0.00231 | NR | WCR62122.1 | 1940570 | g2769 | i0 | 39.7 | 0.34251968503937 | 58 | 34 | 33.7 | 1 | 475 | 305 | 360 | 417 | WCR62122.1 MAG: capsid protein [Parvoviridae sp.] | diamond | 174 | 49.3 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 30085568 | 30085568 | PRJNA800053_P_NODE_2392_length_558_cov_3.494845_g2234_i0 | PRJNA800053 | 2392 | 558 | 3.494845 | 19.5012351 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 51.6 | 5.09e-4 | NR | WAQ80602.1 | 1940570 | g2234 | i0 | 48.9 | 0.736559139784946 | 47 | 24 | 25.3 | 0 | 414 | 554 | 42 | 88 | WAQ80602.1 MAG: replication protein [Parvoviridae sp.] | diamond | 411 | 51.6 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 31919034 | 31919034 | PRJNA800053_P_NODE_3717_length_461_cov_1.425258_g3554_i0 | PRJNA800053 | 3717 | 461 | 1.425258 | 6.57043938 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 87.4 | 5.96e-17 | NR | QTE03751.1 | 2794556 | g3554 | i0 | 39.3 | 2.33622559652928 | 122 | 58 | 77.4 | 3 | 103 | 459 | 16 | 124 | QTE03751.1 MAG: replication protein [Psittacidae aveparvovirus] | diamond | 1077 | 87.4 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | ||
| 32552097 | 32552097 | PRJNA800053_P_NODE_8939_length_321_cov_5.044355_g8775_i0 | PRJNA800053 | 8939 | 321 | 5.044355 | 16.19237955 | Flumine parvovirus 2 | 2940902 | Viruses | Viruses | 172 | 3.56e-52 | NR | UQB76441.1 | 2940902 | g8775 | i0 | 72.9 | 1 | 107 | 29 | 100 | 0 | 321 | 1 | 98 | 204 | UQB76441.1 nonstructural protein [Flumine parvovirus 2] | diamond | 321 | 172 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Flumine parvovirus 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);;