contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1115053" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1500522 | 1500522 | PRJNA1115053_S_NODE_241922_length_178_cov_1.777778_g240105_i0 | PRJNA1115053 | 241922 | 178 | 1.777778 | 3.16444484 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g240105 | i0 | 100 | 1.30337078651685 | 29 | 0 | 16 | 0 | 3 | 31 | 1 | 29 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 232 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 12982637 | 12982637 | PRJNA1115053_S_NODE_5231_length_755_cov_24.248596_g4034_i0 | PRJNA1115053 | 5231 | 755 | 24.248596 | 183.0768998 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 1262 | 0 | NTclustered | gi|2277478564|gb|MZ502233.1| | 172297 | g4034 | i0 | 96.941 | 9.53907284768212 | 752 | 23 | 99 | 0 | 4 | 755 | 2464 | 1713 | Bovine parvovirus 3 isolate BCS1/USA nonstructural protein and structural protein genes, complete cds | blastn | 7202 | 1262 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 15532134 | 15532134 | PRJNA1115053_S_NODE_80993_length_281_cov_3.542017_g79176_i0 | PRJNA1115053 | 80993 | 281 | 3.542017 | 9.95306777 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 455 | 1.69e-123 | NTclustered | gi|2277478564|gb|MZ502233.1| | 172297 | g79176 | i0 | 96.057 | 5.95729537366548 | 279 | 11 | 99 | 0 | 1 | 279 | 167 | 445 | Bovine parvovirus 3 isolate BCS1/USA nonstructural protein and structural protein genes, complete cds | blastn | 1674 | 455 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 18080428 | 18080428 | PRJNA1115053_S_NODE_5275_length_753_cov_4.414085_g4073_i0 | PRJNA1115053 | 5275 | 753 | 4.414085 | 33.23806005 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 1258 | 0 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g4073 | i0 | 96.813 | 9.97211155378486 | 753 | 24 | 100 | 0 | 1 | 753 | 947 | 1699 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 7509 | 1258 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 19348382 | 19348382 | PRJNA1115053_S_NODE_1036_length_1646_cov_5.839052_g611_i0 | PRJNA1115053 | 1036 | 1646 | 5.839052 | 96.11079592 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 2800 | 0 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g611 | i0 | 97.386 | 8.82624544349939 | 1645 | 43 | 99 | 0 | 2 | 1646 | 4528 | 2884 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 14528 | 2800 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 24450093 | 24450093 | PRJNA1115053_S_NODE_163620_length_211_cov_2.547619_g161803_i0 | PRJNA1115053 | 163620 | 211 | 2.547619 | 5.37547609 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 231 | 2.22e-56 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g161803 | i0 | 91.176 | 4.98104265402844 | 170 | 15 | 100 | 0 | 42 | 211 | 118 | 287 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 1051 | 231 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 24450228 | 24450228 | PRJNA1115053_S_NODE_168780_length_209_cov_0.716867_g166963_i0 | PRJNA1115053 | 168780 | 209 | 0.716867 | 1.49825203 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g166963 | i0 | 100 | 0.138755980861244 | 29 | 0 | 14 | 0 | 1 | 29 | 3116 | 3088 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 24452796 | 24452796 | PRJNA1115053_S_NODE_27880_length_411_cov_3.437500_g26069_i0 | PRJNA1115053 | 27880 | 411 | 3.4375 | 14.128125 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 571 | 2.4499999999999996e-158 | NTclustered | gi|1333742271|gb|MG026728.1| | 172297 | g26069 | i0 | 98.758 | 6.48418491484185 | 322 | 2 | 78 | 2 | 90 | 411 | 5333 | 5014 | Bovine parvovirus 3 isolate ujs497 nonstructural protein and structural protein genes, complete cds | blastn | 2665 | 571 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 |
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);;