contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Cressdnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26700785 | 26700785 | PRJNA630162_P_NODE_58541_length_230_cov_4.635359_g57018_i0 | PRJNA630162 | 58541 | 230 | 4.635359 | 10.6613257 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 60.1 | 2.32e-8 | NR | XOF04467.1 | 2809008 | g57018 | i0 | 47.9 | 0.952173913043478 | 73 | 36 | 92.6 | 1 | 217 | 5 | 212 | 284 | XOF04467.1 MAG: hypothetical protein [Cirlivirales sp.] | diamond | 219 | 60.1 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 26795882 | 26795882 | PRJNA630162_P_NODE_134121_length_168_cov_1.941176_g132598_i0 | PRJNA630162 | 134121 | 168 | 1.941176 | 3.26117568 | Bacilladnavirus sp. | 2267680 | Viruses | Viruses | 44.3 | 0.00379 | NR | AXH77450.1 | 2267680 | g132598 | i0 | 38.5 | 0.928571428571429 | 52 | 31 | 92.9 | 1 | 8 | 163 | 298 | 348 | AXH77450.1 MAG: hypothetical protein [Bacilladnavirus sp.] | diamond | 156 | 44.3 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Baphyvirales | Bacilladnaviridae | Bacilladnavirus | Bacilladnavirus sp. | ||
| 27397026 | 27397026 | PRJNA630162_P_NODE_71823_length_212_cov_1.319018_g70300_i0 | PRJNA630162 | 71823 | 212 | 1.319018 | 2.79631816 | Circoviridae 2 LDMD-2 | 1379695 | Viruses | Viruses | 65.9 | 1.73e-10 | NR | YP_009109631.1 | 1379695 | g70300 | i0 | 56.3 | 1.34433962264151 | 48 | 21 | 67.9 | 0 | 8 | 151 | 256 | 303 | YP_009109631.1 putative viral capsid [Circoviridae 2 LDMD-2013] | diamond | 285 | 65.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circoviridae 2 LDMD-2013 | |||
| 27775972 | 27775972 | PRJNA630162_P_NODE_75624_length_207_cov_1.259494_g74101_i0 | PRJNA630162 | 75624 | 207 | 1.259494 | 2.60715258 | Comazfec virus 2 | 3112649 | Viruses | Viruses | 53.9 | 2.64e-6 | NR | WVR22019.1 | 3112649 | g74101 | i0 | 56.3 | 1.52173913043478 | 48 | 21 | 69.6 | 0 | 183 | 40 | 260 | 307 | WVR22019.1 MAG: capsid protein [Comazfec virus 2] | diamond | 315 | 53.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Comazfec virus 2 | ||||||
| 27933630 | 27933630 | PRJNA630162_P_NODE_64605_length_220_cov_1.508772_g63082_i0 | PRJNA630162 | 64605 | 220 | 1.508772 | 3.3192984 | Bacilladnavirus sp. | 2267680 | Viruses | Viruses | 84 | 6.26e-17 | NR | AXH77453.1 | 2267680 | g63082 | i0 | 59.2 | 0.968181818181818 | 71 | 28 | 96.8 | 1 | 2 | 214 | 193 | 262 | AXH77453.1 MAG: putative viral replication protein [Bacilladnavirus sp.] | diamond | 213 | 84 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Baphyvirales | Bacilladnaviridae | Bacilladnavirus | Bacilladnavirus sp. | ||
| 28135798 | 28135798 | PRJNA630162_P_NODE_139325_length_167_cov_0.881356_g137802_i0 | PRJNA630162 | 139325 | 167 | 0.881356 | 1.47186452 | Viruses | 10239 | Viruses | Viruses | 57 | 7.65e-8 | NR | UOF80607.1 | 2748378 | g137802 | i0 | 53.2 | 2.62275449101796 | 47 | 22 | 84.4 | 0 | 14 | 154 | 62 | 108 | UOF80607.1 capsid protein [Cressdnaviricota sp.] | diamond | 438 | 57 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 28407188 | 28407188 | PRJNA630162_P_NODE_141286_length_166_cov_3.367521_g139763_i0 | PRJNA630162 | 141286 | 166 | 3.367521 | 5.59008486 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 53.1 | 2.68e-6 | NR | AYP28859.1 | 2748378 | g139763 | i0 | 51.1 | 1.69879518072289 | 47 | 23 | 84.9 | 0 | 24 | 164 | 102 | 148 | AYP28859.1 MAG: coat protein [Cressdnaviricota sp.] | diamond | 282 | 53.1 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 28501942 | 28501942 | PRJNA630162_P_NODE_160687_length_162_cov_0.920354_g159164_i0 | PRJNA630162 | 160687 | 162 | 0.920354 | 1.49097348 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 51.2 | 1.28e-5 | NR | WAE42831.1 | 2748378 | g159164 | i0 | 50 | 0.962962962962963 | 52 | 24 | 94.4 | 2 | 156 | 4 | 233 | 283 | WAE42831.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 156 | 51.2 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 28609277 | 28609277 | PRJNA630162_P_NODE_10487_length_591_cov_2.673432_g9064_i0 | PRJNA630162 | 10487 | 591 | 2.673432 | 15.79998312 | Viruses | 10239 | Viruses | Viruses | 66.2 | 6.06e-9 | NR | UOF76831.1 | 2748378 | g9064 | i0 | 30.3 | 2.47715736040609 | 165 | 102 | 78.7 | 3 | 576 | 112 | 120 | 281 | UOF76831.1 coat protein [Cressdnaviricota sp.] | diamond | 1464 | 66.2 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29101805 | 29101805 | PRJNA630162_P_NODE_125888_length_171_cov_2.327869_g124365_i0 | PRJNA630162 | 125888 | 171 | 2.327869 | 3.98065599 | Owegonang virus 1 | 3062879 | Viruses | Viruses | 46.2 | 7.9e-4 | NR | WPR18644.1 | 3063439 | g124365 | i0 | 47.8 | 0.807017543859649 | 46 | 24 | 80.7 | 0 | 26 | 163 | 79 | 124 | WPR18644.1 MAG: capsid protein [Owegonang virus 10] | diamond | 138 | 46.2 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Owegonang virus 10 | ||||||
| 29133592 | 29133592 | PRJNA630162_P_NODE_41089_length_277_cov_2.912281_g39566_i0 | PRJNA630162 | 41089 | 277 | 2.912281 | 8.06701837 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 83.6 | 1.59e-16 | NR | UOF78740.1 | 2748378 | g39566 | i0 | 44.4 | 0.974729241877256 | 90 | 50 | 97.5 | 0 | 272 | 3 | 121 | 210 | UOF78740.1 putative capsid protein [Cressdnaviricota sp.] | diamond | 270 | 83.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29165112 | 29165112 | PRJNA630162_P_NODE_124569_length_172_cov_1.544715_g123046_i0 | PRJNA630162 | 124569 | 172 | 1.544715 | 2.6569098 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 47.8 | 1.78e-4 | NR | AWW06056.1 | 2748378 | g123046 | i0 | 43.1 | 1.01162790697674 | 58 | 29 | 94.2 | 1 | 163 | 2 | 63 | 120 | AWW06056.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 174 | 47.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29386209 | 29386209 | PRJNA630162_P_NODE_95389_length_188_cov_2.366906_g93866_i0 | PRJNA630162 | 95389 | 188 | 2.366906 | 4.44978328 | Owegonang virus 27 | 3063501 | Viruses | Viruses | 42.4 | 0.0221 | NR | WPR18773.1 | 3063501 | g93866 | i0 | 48.7 | 0.622340425531915 | 39 | 20 | 62.2 | 0 | 133 | 17 | 156 | 194 | WPR18773.1 MAG: capsid protein [Owegonang virus 27] | diamond | 117 | 42.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Owegonang virus 27 | ||||||
| 29480392 | 29480392 | PRJNA630162_P_NODE_41230_length_277_cov_1.241228_g39707_i0 | PRJNA630162 | 41230 | 277 | 1.241228 | 3.43820156 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 48.5 | 4.75e-4 | NR | UOF82684.1 | 2748378 | g39707 | i0 | 31.3 | 0.866425992779783 | 80 | 53 | 84.5 | 1 | 271 | 38 | 159 | 238 | UOF82684.1 capsid protein [Cressdnaviricota sp.] | diamond | 240 | 48.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29606635 | 29606635 | PRJNA630162_P_NODE_52230_length_244_cov_1.374359_g50707_i0 | PRJNA630162 | 52230 | 244 | 1.374359 | 3.35343596 | Cynopterus sphinx circular DNA virus 6 | 3064089 | Viruses | Viruses | 120 | 4.26e-31 | NR | WOE49735.1 | 3064089 | g50707 | i0 | 67.9 | 0.959016393442623 | 78 | 25 | 95.9 | 0 | 10 | 243 | 101 | 178 | WOE49735.1 MAG: putative replicase protein, partial [Cynopterus sphinx circular DNA virus 6] | diamond | 234 | 120 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 6 | ||||||
| 30491497 | 30491497 | PRJNA630162_P_NODE_141493_length_166_cov_2.666667_g139970_i0 | PRJNA630162 | 141493 | 166 | 2.666667 | 4.42666722 | Mongoose-associated circovirus | 2879287 | Viruses | Viruses | 42.7 | 0.0124 | NR | UBR88863.1 | 2879287 | g139970 | i0 | 47.8 | 0.831325301204819 | 46 | 23 | 81.3 | 1 | 15 | 149 | 65 | 110 | UBR88863.1 putative capsid protein [Mongoose-associated circovirus] | diamond | 138 | 42.7 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Mongoose-associated circovirus | ||
| 31123003 | 31123003 | PRJNA630162_P_NODE_3115_length_1055_cov_11.927435_g2352_i0 | PRJNA630162 | 3115 | 1055 | 11.927435 | 125.83443925 | Circoviridae sp. | 1954248 | Viruses | Viruses | 84 | 1.47e-14 | NR | AXQ66120.1 | 1954248 | g2352 | i0 | 30.5 | 1.29099526066351 | 226 | 130 | 59.7 | 5 | 833 | 204 | 40 | 254 | AXQ66120.1 MAG: putative capsid protein [Circoviridae sp.] | diamond | 1362 | 84 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 31186407 | 31186407 | PRJNA630162_P_NODE_86755_length_194_cov_2.344828_g85232_i0 | PRJNA630162 | 86755 | 194 | 2.344828 | 4.54896632 | Malazfec virus 17 | 3112683 | Viruses | Viruses | 48.5 | 1.74e-4 | NR | WVR22178.1 | 3112683 | g85232 | i0 | 37.1 | 0.958762886597938 | 62 | 38 | 95.9 | 1 | 3 | 188 | 156 | 216 | WVR22178.1 MAG: replication associated protein [Malazfec virus 17] | diamond | 186 | 48.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Malazfec virus 17 | ||||||
| 32167354 | 32167354 | PRJNA630162_P_NODE_26258_length_356_cov_2.449511_g24737_i0 | PRJNA630162 | 26258 | 356 | 2.449511 | 8.72025916 | Circovirus sp. | 1964372 | Viruses | Viruses | 57.4 | 5.93e-7 | NR | AUW34326.1 | 1964372 | g24737 | i0 | 49.2 | 1.01123595505618 | 61 | 27 | 49.7 | 2 | 179 | 3 | 47 | 105 | AUW34326.1 capsid protein [Circovirus sp.] | diamond | 360 | 57.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Circovirus | Circovirus sp. | ||
| 32388572 | 32388572 | PRJNA630162_P_NODE_124459_length_172_cov_1.609756_g122936_i0 | PRJNA630162 | 124459 | 172 | 1.609756 | 2.76878032 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 63.9 | 2.91e-10 | NR | WAE43202.1 | 2748378 | g122936 | i0 | 69.8 | 2.84302325581395 | 43 | 13 | 75 | 0 | 1 | 129 | 224 | 266 | WAE43202.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 489 | 63.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota 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);;