contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128032 | 128032 | PRJEB64798_P_NODE_216541_length_163_cov_1.763158_g214775_i0 | PRJEB64798 | 216541 | 163 | 1.763158 | 2.87394754 | Mimivirus U306 | 1932880 | Viruses | Viruses | 69.4 | 1.35e-7 | NTclustered | gi|1572561086|emb|LT717347.1| | 1932880 | g214775 | i0 | 89.091 | 1.4601226993865 | 55 | 6 | 34 | 0 | 102 | 156 | 87322 | 87376 | Mimivirus U306 genome assembly, complete genome: monopartite | blastn | 238 | 69.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus U306 | ||
| 6505019 | 6505019 | PRJEB64798_P_NODE_128386_length_199_cov_3.406667_g126620_i0 | PRJEB64798 | 128386 | 199 | 3.406667 | 6.77926733 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 171 | 4.57e-38 | NTclustered | gi|1174571674|gb|KY684104.1| | 1977638 | g126620 | i0 | 82.812 | 32.6733668341709 | 192 | 31 | 96 | 2 | 3 | 193 | 161980 | 161790 | Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence | blastn | 6502 | 171 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 8646614 | 8646614 | PRJEB64798_P_NODE_49407_length_279_cov_3.804348_g47642_i0 | PRJEB64798 | 49407 | 279 | 3.804348 | 10.61413092 | Viruses | 10239 | Viruses | Viruses | 63.9 | 1.19e-5 | NTclustered | gi|1572561086|emb|LT717347.1| | 1932880 | g47642 | i0 | 95 | 1.35125448028674 | 40 | 2 | 14 | 0 | 191 | 230 | 884265 | 884226 | Mimivirus U306 genome assembly, complete genome: monopartite | blastn | 377 | 63.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus U306 | ||
| 11196111 | 11196111 | PRJEB64798_P_NODE_133489_length_196_cov_19.333333_g131723_i0 | PRJEB64798 | 133489 | 196 | 19.333333 | 37.89333268 | Chlorovirus | 181083 | Viruses | Viruses | 86.1 | 1.67e-12 | NTclustered | gi|448931565|gb|JX997173.1| | 240263 | g131723 | i0 | 94.545 | 2.58163265306122 | 55 | 3 | 28 | 0 | 84 | 138 | 159146 | 159092 | Paramecium bursaria Chlorella virus MA-1E, partial genome | blastn | 506 | 86.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Chlorovirus | Paramecium bursaria Chlorella virus MA1E | ||
| 13746735 | 13746735 | PRJEB64798_P_NODE_236511_length_156_cov_6.018692_g234745_i0 | PRJEB64798 | 236511 | 156 | 6.018692 | 9.38915952 | Chlorovirus | 181083 | Viruses | Viruses | 65.8 | 1.65e-6 | NTclustered | gi|448925430|gb|JX997155.1| | 1278268 | g234745 | i0 | 91.837 | 4.69871794871795 | 49 | 0 | 30 | 4 | 2 | 48 | 264308 | 264262 | Acanthocystis turfacea Chlorella virus Br0604L, partial genome | blastn | 733 | 65.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Chlorovirus | Acanthocystis turfacea Chlorella virus Br0604L | ||
| 17978048 | 17978048 | PRJEB64798_P_NODE_111715_length_210_cov_3.422360_g109949_i0 | PRJEB64798 | 111715 | 210 | 3.42236 | 7.186956 | Paramecium bursaria Chlorella virus CZ-2 | 1278251 | Viruses | Viruses | 139 | 1.38e-28 | NTclustered | gi|448929138|gb|JX997166.1| | 1278251 | g109949 | i0 | 93.617 | 0.895238095238095 | 94 | 5 | 45 | 1 | 115 | 208 | 270554 | 270646 | Paramecium bursaria Chlorella virus CZ-2, partial genome | blastn | 188 | 139 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Chlorovirus | Paramecium bursaria Chlorella virus CZ-2 | ||
| 19252133 | 19252133 | PRJEB64798_P_NODE_117976_length_207_cov_8.367089_g116210_i0 | PRJEB64798 | 117976 | 207 | 8.367089 | 17.31987423 | Theiavirus salishense | 3060737 | Viruses | Viruses | 230 | 7.7999999999999985e-56 | NTclustered | gi|2500354595|ref|NC_075036.1| | 2024608 | g116210 | i0 | 88.77 | 1.79710144927536 | 187 | 21 | 90 | 0 | 12 | 198 | 505999 | 505813 | Bodo saltans virus strain NG1, complete genome | blastn | 372 | 230 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 19252193 | 19252193 | PRJEB64798_P_NODE_121316_length_205_cov_13.256410_g119550_i0 | PRJEB64798 | 121316 | 205 | 13.25641 | 27.1756405 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 113 | 8.1e-21 | NTclustered | gi|1174573917|gb|KY684119.1| | 1977640 | g119550 | i0 | 76.098 | 1 | 205 | 35 | 94 | 5 | 6 | 197 | 6115 | 6318 | Klosneuvirus KNV1 Klosneuvirus_12 genomic sequence, sequence | blastn | 205 | 113 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 19255043 | 19255043 | PRJEB64798_P_NODE_69936_length_231_cov_6.461538_g68171_i0 | PRJEB64798 | 69936 | 231 | 6.461538 | 14.92615278 | Chlorella virus XW01 | 2922419 | Viruses | Viruses | 217 | 6.919999999999999e-52 | NTclustered | gi|2200493011|gb|OL828820.1| | 2922419 | g68171 | i0 | 84.071 | 0.978354978354978 | 226 | 26 | 97 | 4 | 8 | 231 | 190247 | 190030 | Chlorella virus XW01, complete genome | blastn | 226 | 217 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Chlorella virus XW01 | |||
| 20529218 | 20529218 | PRJEB64798_P_NODE_228057_length_159_cov_6.909091_g226291_i0 | PRJEB64798 | 228057 | 159 | 6.909091 | 10.98545469 | Micromonas commoda virus | 3057169 | Viruses | Viruses | 58.4 | 2.83e-4 | NTclustered | gi|2747347731|gb|PP911589.1| | 3057169 | g226291 | i0 | 97.059 | 0.213836477987421 | 34 | 1 | 21 | 0 | 3 | 36 | 9922 | 9889 | Micromonas commoda virus isolate McV-KB2 genomic sequence | blastn | 34 | 58.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Micromonas commoda virus |
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);;