contig_metadata
16 rows where bioproject = "PRJNA1134759" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1558637 | 1558637 | PRJNA1134759_P_NODE_122_length_2724_cov_3.702754_g110_i0 | PRJNA1134759 | 122 | 2724 | 3.702754 | 100.86301896 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 5003 | 0 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g110 | i0 | 99.816 | 14.9988986784141 | 2724 | 5 | 100 | 0 | 1 | 2724 | 349 | 3072 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 40857 | 5003 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 1558689 | 1558689 | PRJNA1134759_P_NODE_24402_length_333_cov_2.015385_g24226_i0 | PRJNA1134759 | 24402 | 333 | 2.015385 | 6.71123205 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 610 | 4.13e-170 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g24226 | i0 | 99.7 | 5 | 333 | 1 | 100 | 0 | 1 | 333 | 2309 | 1977 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1665 | 610 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 2834791 | 2834791 | PRJNA1134759_P_NODE_30523_length_304_cov_1.939394_g30347_i0 | PRJNA1134759 | 30523 | 304 | 1.939394 | 5.89575776 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 551 | 2.289999999999999e-152 | NTclustered | gi|2209095278|gb|OL472843.1| | 2900459 | g30347 | i0 | 99.342 | 5 | 304 | 2 | 100 | 0 | 1 | 304 | 667 | 970 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 2 hypothetical protein gene, complete cds | blastn | 1520 | 551 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 4111105 | 4111105 | PRJNA1134759_P_NODE_16604_length_392_cov_2.322884_g16428_i0 | PRJNA1134759 | 16604 | 392 | 2.322884 | 9.10570528 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 725 | 0 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g16428 | i0 | 100 | 5 | 392 | 0 | 100 | 0 | 1 | 392 | 4390 | 3999 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1960 | 725 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 5387300 | 5387300 | PRJNA1134759_P_NODE_18985_length_370_cov_1.309764_g18809_i0 | PRJNA1134759 | 18985 | 370 | 1.309764 | 4.8461268 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 662 | 0 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g18809 | i0 | 98.919 | 5 | 370 | 4 | 100 | 0 | 1 | 370 | 6303 | 6672 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1850 | 662 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 5387327 | 5387327 | PRJNA1134759_P_NODE_27945_length_315_cov_3.665289_g27769_i0 | PRJNA1134759 | 27945 | 315 | 3.665289 | 11.54566035 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 577 | 3.9299999999999986e-160 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g27769 | i0 | 99.683 | 15 | 315 | 1 | 100 | 0 | 1 | 315 | 3453 | 3139 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 4725 | 577 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 6662110 | 6662110 | PRJNA1134759_P_NODE_8806_length_523_cov_2.402222_g8630_i0 | PRJNA1134759 | 8806 | 523 | 2.402222 | 12.56362106 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 961 | 0 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g8630 | i0 | 99.809 | 5 | 523 | 1 | 100 | 0 | 1 | 523 | 7156 | 6634 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 2615 | 961 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 13037910 | 13037910 | PRJNA1134759_P_NODE_55771_length_243_cov_0.917647_g55595_i0 | PRJNA1134759 | 55771 | 243 | 0.917647 | 2.22988221 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 444 | 3.09e-120 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g55595 | i0 | 99.588 | 14.9794238683128 | 243 | 1 | 100 | 0 | 1 | 243 | 4051 | 4293 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 3640 | 444 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 14313062 | 14313062 | PRJNA1134759_P_NODE_37152_length_281_cov_1.923077_g36976_i0 | PRJNA1134759 | 37152 | 281 | 1.923077 | 5.40384637 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 514 | 2.75e-141 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g36976 | i0 | 99.644 | 5 | 281 | 1 | 100 | 0 | 1 | 281 | 2997 | 3277 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1405 | 514 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 18135970 | 18135970 | PRJNA1134759_P_NODE_57935_length_232_cov_3.270440_g57759_i0 | PRJNA1134759 | 57935 | 232 | 3.27044 | 7.5874208 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 429 | 8.2e-116 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g57759 | i0 | 100 | 5 | 232 | 0 | 100 | 0 | 1 | 232 | 3799 | 4030 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1160 | 429 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 23236529 | 23236529 | PRJNA1134759_P_NODE_52899_length_247_cov_0.896552_g52723_i0 | PRJNA1134759 | 52899 | 247 | 0.896552 | 2.21448344 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 451 | 1.88e-122 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g52723 | i0 | 99.595 | 15 | 247 | 1 | 100 | 0 | 1 | 247 | 6507 | 6261 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 3705 | 451 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 26690486 | 26690486 | PRJNA1134759_P_NODE_31241_length_301_cov_1.824561_g31065_i0 | PRJNA1134759 | 31241 | 301 | 1.824561 | 5.49192861 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 178 | 4.059999999999999e-52 | NR | UNI74140.1 | 2900384 | g31065 | i0 | 88 | 1.99335548172757 | 100 | 12 | 99.7 | 0 | 1 | 300 | 296 | 395 | UNI74140.1 MAG: hypothetical protein [brine shrimp arlivirus 9] | diamond | 600 | 178 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 27386610 | 27386610 | PRJNA1134759_P_NODE_18483_length_374_cov_1.813953_g18307_i0 | PRJNA1134759 | 18483 | 374 | 1.813953 | 6.78418422 | Fusarium culmorum yue-like virus 1 | 3233859 | Viruses | Viruses | 68.6 | 1.53e-10 | NR | XCO56027.1 | 3233859 | g18307 | i0 | 39.8 | 0.82620320855615 | 103 | 58 | 81 | 2 | 319 | 17 | 452 | 552 | XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] | diamond | 309 | 68.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Fusarium culmorum yue-like virus 1 | |||
| 29217938 | 29217938 | PRJNA1134759_P_NODE_58669_length_227_cov_2.233766_g58493_i0 | PRJNA1134759 | 58669 | 227 | 2.233766 | 5.07064882 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 70.9 | 1.98e-12 | NR | UNI74143.1 | 2900384 | g58493 | i0 | 56 | 0.991189427312775 | 75 | 33 | 99.1 | 0 | 225 | 1 | 194 | 268 | UNI74143.1 MAG: hypothetical protein [brine shrimp arlivirus 9] | diamond | 225 | 70.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 29996402 | 29996402 | PRJNA1134759_P_NODE_51171_length_249_cov_1.329545_g50995_i0 | PRJNA1134759 | 51171 | 249 | 1.329545 | 3.31056705 | Chuvivirus | 2842604 | Viruses | Viruses | 96.3 | 4.47e-21 | NR | WET19887.1 | 2842604 | g50995 | i0 | 61 | 1.97590361445783 | 82 | 32 | 98.8 | 0 | 248 | 3 | 261 | 342 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 492 | 96.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 31587502 | 31587502 | PRJNA1134759_P_NODE_36576_length_283_cov_1.485714_g36400_i0 | PRJNA1134759 | 36576 | 283 | 1.485714 | 4.20457062 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 164 | 2.24e-50 | NR | UNI74142.1 | 2900384 | g36400 | i0 | 84.9 | 0.985865724381625 | 93 | 14 | 98.6 | 0 | 1 | 279 | 23 | 115 | UNI74142.1 MAG: hypothetical protein [brine shrimp arlivirus 9] | diamond | 279 | 164 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 |
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);;