contig_metadata
7 rows where bioproject = "PRJEB39643" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 989399 | 989399 | PRJEB39643_P_NODE_159981_length_199_cov_29.912698_g159787_i0 | PRJEB39643 | 159981 | 199 | 29.912698 | 59.52626902 | root | 1 | Root_unresolved | Root_unresolved | 265 | 2.04e-66 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g159787 | i0 | 99.32 | 73.8693467336683 | 147 | 0 | 73 | 1 | 1 | 146 | 11549 | 11403 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 14700 | 265 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 3884073 | 3884073 | PRJEB39643_P_NODE_34684_length_316_cov_2.074074_g34491_i0 | PRJEB39643 | 34684 | 316 | 2.074074 | 6.55407384 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1174573444|gb|KY684111.1| | 1977640 | g34491 | i0 | 96.875 | 0.10126582278481 | 32 | 1 | 10 | 0 | 123 | 154 | 98626 | 98595 | Klosneuvirus KNV1 isolate KNV1 clone Klosneuvirus_4, sequence | blastn | 32 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 6092524 | 6092524 | PRJEB39643_P_NODE_159525_length_204_cov_7.358779_g159331_i0 | PRJEB39643 | 159525 | 204 | 7.358779 | 15.01190916 | root | 1 | Root_unresolved | Root_unresolved | 368 | 1.56e-97 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g159331 | i0 | 100 | 97.5490196078431 | 199 | 0 | 98 | 0 | 1 | 199 | 15025 | 15223 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 19900 | 368 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 21391605 | 21391605 | PRJEB39643_P_NODE_45897_length_288_cov_1.572093_g45704_i0 | PRJEB39643 | 45897 | 288 | 1.572093 | 4.52762784 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 5.73e-4 | NTclustered | gi|2327912943|gb|OL897270.1| | 1907210 | g45704 | i0 | 100 | 4.82638888888889 | 31 | 0 | 11 | 0 | 41 | 71 | 101 | 131 | Human adenovirus sp. strain HAdV/S183/Huzhou/2020/CHN hexon gene, partial cds | blastn | 1390 | 58.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Human adenovirus sp. | ||
| 22666476 | 22666476 | PRJEB39643_P_NODE_91858_length_265_cov_1.604167_g91665_i0 | PRJEB39643 | 91858 | 265 | 1.604167 | 4.25104255 | root | 1 | Root_unresolved | Root_unresolved | 484 | 2.0199999999999998e-132 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g91665 | i0 | 99.623 | 99.7849056603774 | 265 | 1 | 100 | 0 | 1 | 265 | 14225 | 14489 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 26443 | 484 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 28517788 | 28517788 | PRJEB39643_P_NODE_113827_length_255_cov_1.692308_g113634_i0 | PRJEB39643 | 113827 | 255 | 1.692308 | 4.3153854 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 69.7 | 1.36e-11 | NR | AYV84623.1 | 2487770 | g113634 | i0 | 53.6 | 0.658823529411765 | 56 | 26 | 65.9 | 0 | 241 | 74 | 153 | 208 | AYV84623.1 MAG: putative helicase/exonuclease [Hyperionvirus sp.] | diamond | 168 | 69.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 28801748 | 28801748 | PRJEB39643_P_NODE_72408_length_274_cov_1.532338_g72215_i0 | PRJEB39643 | 72408 | 274 | 1.532338 | 4.19860612 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 68.6 | 3.25e-11 | NR | YP_010781083.1 | 2126984 | g72215 | i0 | 41.6 | 1.94890510948905 | 89 | 49 | 95.3 | 2 | 265 | 5 | 193 | 280 | YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] | diamond | 534 | 68.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense |
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);;