contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA642647" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168830 | 3168830 | PRJNA642647_P_NODE_4683_length_168_cov_5.053435_g4633_i0 | PRJNA642647 | 4683 | 168 | 5.053435 | 8.4897708 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 148 | 1.75e-31 | NTclustered | gi|1846450519|gb|MT138244.1| | 1940570 | g4633 | i0 | 95.652 | 0.547619047619048 | 92 | 4 | 55 | 0 | 75 | 166 | 998 | 1089 | MAG: Parvoviridae sp. isolate hbl169par3 genomic sequence, sequence | blastn | 92 | 148 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 4445693 | 4445693 | PRJNA642647_P_NODE_4_length_3343_cov_14.130067_g3_i0 | PRJNA642647 | 4 | 3343 | 14.130067 | 472.36813981 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 5782 | 0 | NTclustered | gi|2496529059|gb|OP577479.1| | 3042447 | g3 | i0 | 99.466 | 2.78462458869279 | 3183 | 16 | 95 | 1 | 1 | 3182 | 116 | 3298 | Psittaciform aveparvovirus strain OBP1/FE1/29/2021, partial genome | blastn | 9309 | 5782 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittaciform aveparvovirus | ||
| 8271266 | 8271266 | PRJNA642647_P_NODE_3067_length_200_cov_2.723926_g3017_i0 | PRJNA642647 | 3067 | 200 | 2.723926 | 5.447852 | Dependoparvovirus anseriform1 | 1511895 | Viruses | Viruses | 364 | 1.96e-96 | NTclustered | gi|2156867651|gb|MW380864.2| | 341673 | g3017 | i0 | 100 | 2.26 | 197 | 0 | 99 | 0 | 4 | 200 | 578 | 382 | Duck parvovirus strain DPV/G018-19C/Australia/2019 nonstructural protein 1 (NS1) and capsid protein genes, partial cds | blastn | 452 | 364 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Dependoparvovirus | Dependoparvovirus anseriform1 | ||
| 8271299 | 8271299 | PRJNA642647_P_NODE_547_length_480_cov_4.988713_g498_i0 | PRJNA642647 | 547 | 480 | 4.988713 | 23.9458224 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 749 | 0 | NTclustered | gi|2496529060|gb|OP577480.1| | 3042447 | g498 | i0 | 94.969 | 0.99375 | 477 | 24 | 99 | 0 | 1 | 477 | 2085 | 1609 | Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome | blastn | 477 | 749 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittaciform aveparvovirus | ||
| 8271303 | 8271303 | PRJNA642647_P_NODE_5747_length_159_cov_1.467213_g5697_i0 | PRJNA642647 | 5747 | 159 | 1.467213 | 2.33286867 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 220 | 3.4099999999999998e-53 | NTclustered | gi|2496529060|gb|OP577480.1| | 3042447 | g5697 | i0 | 99.18 | 1.23270440251572 | 122 | 1 | 77 | 0 | 1 | 122 | 142 | 21 | Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome | blastn | 196 | 220 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittaciform aveparvovirus | ||
| 10087053 | 10087053 | PRJNA642647_P_NODE_1768_length_261_cov_1.303571_g1718_i0 | PRJNA642647 | 1768 | 261 | 1.303571 | 3.40232031 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 470 | 5.539999999999998e-128 | NTclustered | gi|2814138549|gb|PQ313132.1| | 3042447 | g1718 | i0 | 99.611 | 1.96934865900383 | 257 | 1 | 98 | 0 | 2 | 258 | 160 | 416 | Parvoviridae sp. isolate SpinColumn17, partial genome | blastn | 514 | 470 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform aveparvovirus | |||
| 11361959 | 11361959 | PRJNA642647_P_NODE_249_length_705_cov_10.696108_g211_i0 | PRJNA642647 | 249 | 705 | 10.696108 | 75.4075614 | Viruses | 10239 | Viruses | Viruses | 1291 | 0 | NTclustered | gi|2496529063|gb|OP577481.1| | 3042448 | g211 | i0 | 99.858 | 3.47801418439716 | 702 | 1 | 99 | 0 | 1 | 702 | 1749 | 2450 | Psittaciform parvoviridae sp. strain OBP1/FE1/44/2021, partial genome | blastn | 2452 | 1291 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform parvoviridae sp. | |||
| 15920840 | 15920840 | PRJNA642647_P_NODE_2813_length_207_cov_2.694118_g2763_i0 | PRJNA642647 | 2813 | 207 | 2.694118 | 5.57682426 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 281 | 2.12e-71 | NTclustered | gi|2413975758|gb|OP933682.1| | 3003968 | g2763 | i0 | 89.72 | 3.63285024154589 | 214 | 11 | 98 | 1 | 2 | 204 | 1712 | 1499 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | blastn | 752 | 281 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | |||
| 17195913 | 17195913 | PRJNA642647_P_NODE_1194_length_321_cov_1.933099_g1144_i0 | PRJNA642647 | 1194 | 321 | 1.933099 | 6.20524779 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 560 | 4.05e-155 | NTclustered | gi|2814138529|gb|PQ313127.1| | 3367306 | g1144 | i0 | 98.73 | 1.95638629283489 | 315 | 4 | 98 | 0 | 4 | 318 | 1929 | 1615 | Parvo-like hybrid virus isolate SpinColumn12, partial genome | blastn | 628 | 560 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 19010041 | 19010041 | PRJNA642647_P_NODE_1955_length_247_cov_5.447619_g1905_i0 | PRJNA642647 | 1955 | 247 | 5.447619 | 13.45561893 | Viruses | 10239 | Viruses | Viruses | 414 | 2.47e-111 | NTclustered | gi|2819064707|gb|PQ150501.1| | 3042448 | g1905 | i0 | 96.825 | 3.06072874493927 | 252 | 0 | 99 | 1 | 1 | 244 | 1609 | 1358 | MAG: Psittaciform parvoviridae sp. isolate Hebei_059 genomic sequence | blastn | 756 | 414 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform parvoviridae sp. | |||
| 20284942 | 20284942 | PRJNA642647_P_NODE_1136_length_332_cov_1.518644_g1086_i0 | PRJNA642647 | 1136 | 332 | 1.518644 | 5.04189808 | Viruses | 10239 | Viruses | Viruses | 603 | 6.889999999999997e-168 | NTclustered | gi|2819064707|gb|PQ150501.1| | 3042448 | g1086 | i0 | 99.696 | 2.97289156626506 | 329 | 1 | 99 | 0 | 1 | 329 | 2335 | 2007 | MAG: Psittaciform parvoviridae sp. isolate Hebei_059 genomic sequence | blastn | 987 | 603 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform parvoviridae 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);;