contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJEB6054" and tax_phylum = "Phixviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25615595 | 25615595 | PRJEB6054_S_NODE_473_length_471_cov_29157.288991_g401_i0 | PRJEB6054 | 473 | 471 | 29157.288991 | 137330.83114761 | Viruses | 10239 | Viruses | Viruses | 78.7 | 7.56e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g401 | i0 | 100 | 9.47346072186837 | 42 | 0 | 9 | 0 | 4 | 45 | 2845 | 2804 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4462 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 25751820 | 25751820 | PRJEB6054_S_NODE_162_length_626_cov_21542.463621_g137_i0 | PRJEB6054 | 162 | 626 | 21542.463621 | 134855.82226746 | Viruses | 10239 | Viruses | Viruses | 80.5 | 2.85e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g137 | i0 | 100 | 7.25399361022364 | 43 | 0 | 7 | 0 | 4 | 46 | 2845 | 2803 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4541 | 80.5 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 25887589 | 25887589 | PRJEB6054_S_NODE_1731_length_319_cov_44805.517606_g1642_i0 | PRJEB6054 | 1731 | 319 | 44805.517606 | 142929.60116314 | Viruses | 10239 | Viruses | Viruses | 78.7 | 4.93e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g1642 | i0 | 95.918 | 14.1724137931034 | 49 | 0 | 15 | 2 | 268 | 316 | 2799 | 2845 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4521 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 25887663 | 25887663 | PRJEB6054_S_NODE_6763_length_200_cov_77043.369697_g6674_i0 | PRJEB6054 | 6763 | 200 | 77043.369697 | 154086.739394 | Viruses | 10239 | Viruses | Viruses | 78.7 | 2.87e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g6674 | i0 | 100 | 22.43 | 42 | 0 | 21 | 0 | 156 | 197 | 2804 | 2845 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4486 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26023947 | 26023947 | PRJEB6054_S_NODE_7068_length_197_cov_78581.450617_g6979_i0 | PRJEB6054 | 7068 | 197 | 78581.450617 | 154805.45771549 | Viruses | 10239 | Viruses | Viruses | 78.7 | 2.81e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g6979 | i0 | 100 | 22.5989847715736 | 42 | 0 | 21 | 0 | 4 | 45 | 2845 | 2804 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4452 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26160033 | 26160033 | PRJEB6054_S_NODE_1237_length_354_cov_39940.457680_g1148_i0 | PRJEB6054 | 1237 | 354 | 39940.45768 | 141389.2201872 | Viruses | 10239 | Viruses | Viruses | 80.5 | 1.54e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g1148 | i0 | 100 | 12.7005649717514 | 43 | 0 | 12 | 0 | 309 | 351 | 2803 | 2845 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4496 | 80.5 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26160060 | 26160060 | PRJEB6054_S_NODE_2533_length_281_cov_51677.508130_g2444_i0 | PRJEB6054 | 2533 | 281 | 51677.50813 | 145213.7978453 | Viruses | 10239 | Viruses | Viruses | 78.7 | 4.27e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g2444 | i0 | 100 | 15.8754448398577 | 42 | 0 | 15 | 0 | 4 | 45 | 2845 | 2804 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4461 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26160140 | 26160140 | PRJEB6054_S_NODE_7309_length_195_cov_79467.137500_g7220_i0 | PRJEB6054 | 7309 | 195 | 79467.1375 | 154960.918125 | Viruses | 10239 | Viruses | Viruses | 78.7 | 2.78e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g7220 | i0 | 100 | 22.7846153846154 | 42 | 0 | 22 | 0 | 4 | 45 | 2845 | 2804 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4443 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26295831 | 26295831 | PRJEB6054_S_NODE_3438_length_252_cov_58626.142857_g3349_i0 | PRJEB6054 | 3438 | 252 | 58626.142857 | 147737.87999964 | Viruses | 10239 | Viruses | Viruses | 80.5 | 1.05e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g3349 | i0 | 100 | 17.7738095238095 | 43 | 0 | 17 | 0 | 4 | 46 | 2845 | 2803 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4479 | 80.5 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26295868 | 26295868 | PRJEB6054_S_NODE_4630_length_230_cov_65151.671795_g4541_i0 | PRJEB6054 | 4630 | 230 | 65151.671795 | 149848.8451285 | Viruses | 10239 | Viruses | Viruses | 78.7 | 3.39e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g4541 | i0 | 100 | 19.4478260869565 | 42 | 0 | 18 | 0 | 4 | 45 | 2845 | 2804 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4473 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26431745 | 26431745 | PRJEB6054_S_NODE_15_length_1003_cov_13283.054752_g14_i0 | PRJEB6054 | 15 | 1003 | 13283.054752 | 133229.03916256 | Viruses | 10239 | Viruses | Viruses | 78.7 | 1.68e-9 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g14 | i0 | 100 | 4.45363908275174 | 42 | 0 | 4 | 0 | 4 | 45 | 2845 | 2804 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4467 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26431746 | 26431746 | PRJEB6054_S_NODE_1631_length_325_cov_43856.324138_g1542_i0 | PRJEB6054 | 1631 | 325 | 43856.324138 | 142533.0534485 | Viruses | 10239 | Viruses | Viruses | 78.7 | 5.04e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g1542 | i0 | 100 | 13.8061538461538 | 42 | 0 | 13 | 0 | 281 | 322 | 2804 | 2845 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4487 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26431812 | 26431812 | PRJEB6054_S_NODE_5759_length_213_cov_71449.410112_g5670_i0 | PRJEB6054 | 5759 | 213 | 71449.410112 | 152187.24353856 | Viruses | 10239 | Viruses | Viruses | 78.7 | 3.09e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g5670 | i0 | 100 | 21.018779342723 | 42 | 0 | 20 | 0 | 169 | 210 | 2804 | 2845 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4477 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26431816 | 26431816 | PRJEB6054_S_NODE_6047_length_209_cov_73114.275862_g5958_i0 | PRJEB6054 | 6047 | 209 | 73114.275862 | 152808.83655158 | Viruses | 10239 | Viruses | Viruses | 80.5 | 8.41e-11 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g5958 | i0 | 100 | 21.4688995215311 | 43 | 0 | 21 | 0 | 4 | 46 | 2845 | 2803 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4487 | 80.5 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26431827 | 26431827 | PRJEB6054_S_NODE_7071_length_197_cov_78475.197531_g6982_i0 | PRJEB6054 | 7071 | 197 | 78475.197531 | 154596.13913607 | Viruses | 10239 | Viruses | Viruses | 78.7 | 2.81e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g6982 | i0 | 100 | 22.5888324873096 | 42 | 0 | 21 | 0 | 4 | 45 | 2845 | 2804 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4450 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26567793 | 26567793 | PRJEB6054_S_NODE_1488_length_334_cov_42524.545151_g1399_i0 | PRJEB6054 | 1488 | 334 | 42524.545151 | 142031.98080434 | Viruses | 10239 | Viruses | Viruses | 78.7 | 5.19e-10 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g1399 | i0 | 100 | 13.4431137724551 | 42 | 0 | 13 | 0 | 290 | 331 | 2804 | 2845 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4490 | 78.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 26567874 | 26567874 | PRJEB6054_S_NODE_5472_length_217_cov_69889.796703_g5383_i0 | PRJEB6054 | 5472 | 217 | 69889.796703 | 151660.85884551 | Viruses | 10239 | Viruses | Viruses | 80.5 | 8.79e-11 | NTclustered | gi|2056975379|tpg|BK023205.1| | 2202644 | g5383 | i0 | 100 | 20.8755760368664 | 43 | 0 | 20 | 0 | 4 | 46 | 2845 | 2803 | MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome | blastn | 4530 | 80.5 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. |
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);;