contig_metadata
7 rows where bioproject = "PRJNA725806", tax_phylum = "Preplasmiviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4540149 | 4540149 | PRJNA725806_P_NODE_141104_length_173_cov_1.757353_g140802_i0 | PRJNA725806 | 141104 | 173 | 1.757353 | 3.04022069 | Adintovirus androctonus13035 | 3115887 | Viruses | Viruses | 270 | 3.69e-68 | NTclustered | gi|2710390252|tpg|BK066392.1| | 3115887 | g140802 | i0 | 94.798 | 1 | 173 | 9 | 100 | 0 | 1 | 173 | 2720 | 2892 | MAG TPA_asm: Adintovirus androctonus13035 isolate Adinto13035 genomic sequence | blastn | 173 | 270 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 12191226 | 12191226 | PRJNA725806_P_NODE_34690_length_276_cov_4.079498_g34393_i0 | PRJNA725806 | 34690 | 276 | 4.079498 | 11.25941448 | Adintovirus androctonus13035 | 3115887 | Viruses | Viruses | 182 | 3.1e-41 | NTclustered | gi|2710390252|tpg|BK066392.1| | 3115887 | g34393 | i0 | 88.125 | 0.579710144927536 | 160 | 9 | 58 | 2 | 23 | 182 | 2510 | 2361 | MAG TPA_asm: Adintovirus androctonus13035 isolate Adinto13035 genomic sequence | blastn | 160 | 182 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 28347159 | 28347159 | PRJNA725806_P_NODE_89126_length_205_cov_9.910714_g88824_i0 | PRJNA725806 | 89126 | 205 | 9.910714 | 20.3169637 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 44.3 | 0.00646 | NR | DBA46921.1 | 3115887 | g88824 | i0 | 61.3 | 0.878048780487805 | 31 | 12 | 45.4 | 0 | 5 | 97 | 381 | 411 | DBA46921.1 MAG TPA_asm: Hexon [Adintovirus androctonus13035] | diamond | 180 | 44.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 29578324 | 29578324 | PRJNA725806_P_NODE_8610_length_389_cov_3.838068_g8325_i0 | PRJNA725806 | 8610 | 389 | 3.838068 | 14.93008452 | Adintovirus homo33 | 3115912 | Viruses | Viruses | 65.9 | 1.39e-9 | NR | DBA48451.1 | 3115912 | g8325 | i0 | 52.1 | 0.370179948586118 | 48 | 23 | 37 | 0 | 162 | 19 | 6 | 53 | DBA48451.1 MAG TPA_asm: Hexon [Adintovirus homo3309] | diamond | 144 | 65.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus homo3309 | |||
| 30368693 | 30368693 | PRJNA725806_P_NODE_8712_length_388_cov_2.444444_g8427_i0 | PRJNA725806 | 8712 | 388 | 2.444444 | 9.48444272 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 154 | 2.3299999999999993e-42 | NR | DBA46921.1 | 3115887 | g8427 | i0 | 58.9 | 1.91752577319588 | 124 | 51 | 95.9 | 0 | 1 | 372 | 262 | 385 | DBA46921.1 MAG TPA_asm: Hexon [Adintovirus androctonus13035] | diamond | 744 | 154 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 31980371 | 31980371 | PRJNA725806_P_NODE_111498_length_189_cov_5.940789_g111196_i0 | PRJNA725806 | 111498 | 189 | 5.940789 | 11.22809121 | Megastigmus wasp adintovirus | 2609859 | Viruses | Viruses | 45.1 | 0.00279 | NR | DAC81331.1 | 2609859 | g111196 | i0 | 57.1 | 0.555555555555556 | 35 | 15 | 55.6 | 0 | 182 | 78 | 232 | 266 | DAC81331.1 TPA_asm: PolB [Megastigmus wasp adintovirus] | diamond | 105 | 45.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Megastigmus wasp adintovirus | |||
| 32644286 | 32644286 | PRJNA725806_P_NODE_92120_length_203_cov_3.843373_g91818_i0 | PRJNA725806 | 92120 | 203 | 3.843373 | 7.80204719 | Adintovirus tuber11 | 3115950 | Viruses | Viruses | 61.2 | 6.03e-9 | NR | DBA47561.1 | 3115950 | g91818 | i0 | 52.3 | 1.71428571428571 | 65 | 26 | 91.6 | 2 | 187 | 2 | 285 | 347 | DBA47561.1 MAG TPA_asm: Adintoc3 [Adintovirus tuber11084] | diamond | 348 | 61.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus tuber11084 |
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);;