contig_metadata
7 rows where bioproject = "PRJNA1255065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5463581 | 5463581 | PRJNA1255065_P_NODE_21765_length_585_cov_14.580224_g19631_i0 | PRJNA1255065 | 21765 | 585 | 14.580224 | 85.2943104 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 244 | 8.89e-60 | NTclustered | gi|15705935|gb|AF416237.1|AF416237 | 1891767 | g19631 | i0 | 87.324 | 0.364102564102564 | 213 | 27 | 36 | 0 | 204 | 416 | 222 | 10 | Simian virus 40 clone G14M12 non-archetypal regulatory sequence | blastn | 213 | 244 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 10564366 | 10564366 | PRJNA1255065_P_NODE_21649_length_587_cov_15.864312_g19517_i0 | PRJNA1255065 | 21649 | 587 | 15.864312 | 93.12351144 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 244 | 8.92e-60 | NTclustered | gi|15705935|gb|AF416237.1|AF416237 | 1891767 | g19517 | i0 | 87.324 | 0.362862010221465 | 213 | 27 | 36 | 0 | 170 | 382 | 10 | 222 | Simian virus 40 clone G14M12 non-archetypal regulatory sequence | blastn | 213 | 244 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 27231825 | 27231825 | PRJNA1255065_P_NODE_62103_length_240_cov_1.429319_g59875_i0 | PRJNA1255065 | 62103 | 240 | 1.429319 | 3.4303656 | Avon-Heathcote Estuary associated circular virus 13 | 1618236 | Viruses | Viruses | 137 | 6.2199999999999994e-37 | NR | YP_009126904.1 | 1618236 | g59875 | i0 | 77.5 | 1 | 80 | 18 | 100 | 0 | 240 | 1 | 245 | 324 | YP_009126904.1 putative capsid protein [Avon-Heathcote Estuary associated circular virus 13] | diamond | 240 | 137 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Avon-Heathcote Estuary associated circular virus 13 | |||
| 27263557 | 27263557 | PRJNA1255065_P_NODE_50923_length_285_cov_1.203390_g48697_i0 | PRJNA1255065 | 50923 | 285 | 1.20339 | 3.4296615 | Avon-Heathcote Estuary associated circular virus 13 | 1618236 | Viruses | Viruses | 120 | 9.289999999999998e-31 | NR | YP_009126905.1 | 1618236 | g48697 | i0 | 80 | 0.736842105263158 | 70 | 12 | 73.7 | 1 | 283 | 74 | 231 | 298 | YP_009126905.1 replication-associated protein [Avon-Heathcote Estuary associated circular virus 13] | diamond | 210 | 120 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Avon-Heathcote Estuary associated circular virus 13 | |||
| 27769029 | 27769029 | PRJNA1255065_P_NODE_51064_length_284_cov_1.676596_g48838_i0 | PRJNA1255065 | 51064 | 284 | 1.676596 | 4.76153264 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 69.3 | 8.66e-12 | NR | WCB70604.1 | 2748378 | g48838 | i0 | 52.9 | 0.73943661971831 | 70 | 33 | 73.9 | 0 | 75 | 284 | 1 | 70 | WCB70604.1 Cap [Cressdnaviricota sp.] | diamond | 210 | 69.3 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 28544654 | 28544654 | PRJNA1255065_P_NODE_79267_length_202_cov_1.019608_g77039_i0 | PRJNA1255065 | 79267 | 202 | 1.019608 | 2.05960816 | root | 1 | Root_unresolved | Root_unresolved | 88.6 | 1.17e-19 | NR | AXH77361.1 | 1954248 | g77039 | i0 | 59.7 | 5.65841584158416 | 62 | 25 | 92.1 | 0 | 201 | 16 | 98 | 159 | AXH77361.1 MAG: putative capsid protein [Circoviridae sp.] | diamond | 1143 | 88.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 30610811 | 30610811 | PRJNA1255065_P_NODE_55233_length_265_cov_1.162037_g53005_i0 | PRJNA1255065 | 55233 | 265 | 1.162037 | 3.07939805 | Circoviridae sp. | 1954248 | Viruses | Viruses | 144 | 2.07e-40 | NR | AXH74306.1 | 1954248 | g53005 | i0 | 72.7 | 0.99622641509434 | 88 | 22 | 99.6 | 1 | 264 | 1 | 189 | 274 | AXH74306.1 MAG: putative viral replication protein [Circoviridae sp.] | diamond | 264 | 144 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard |
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);;