contig_metadata
16 rows where bioproject = "PRJEB55122", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3946767 | 3946767 | PRJEB55122_P_NODE_20924_length_241_cov_1.302083_g20527_i0 | PRJEB55122 | 20924 | 241 | 1.302083 | 3.13802003 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 283 | 7.07e-72 | NTclustered | gi|2209095198|gb|OL472417.1| | 2900384 | g20527 | i0 | 87.917 | 0.995850622406639 | 240 | 29 | 99 | 0 | 2 | 241 | 10569 | 10330 | MAG: Brine shrimp arlivirus 9 isolate ARG/02 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 240 | 283 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 5222900 | 5222900 | PRJEB55122_P_NODE_14225_length_315_cov_1.496241_g13828_i0 | PRJEB55122 | 14225 | 315 | 1.496241 | 4.71315915 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 571 | 1.8299999999999996e-158 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g13828 | i0 | 99.365 | 5 | 315 | 2 | 100 | 0 | 1 | 315 | 181 | 495 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1575 | 571 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 6499820 | 6499820 | PRJEB55122_P_NODE_9606_length_418_cov_2.392954_g9212_i0 | PRJEB55122 | 9606 | 418 | 2.392954 | 10.00254772 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 773 | 0 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g9212 | i0 | 100 | 5 | 418 | 0 | 100 | 0 | 1 | 418 | 3518 | 3101 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 2090 | 773 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 7773083 | 7773083 | PRJEB55122_P_NODE_20407_length_245_cov_1.061224_g20010_i0 | PRJEB55122 | 20407 | 245 | 1.061224 | 2.5999988 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g20010 | i0 | 100 | 5 | 245 | 0 | 100 | 0 | 1 | 245 | 5246 | 5002 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1225 | 453 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 15423040 | 15423040 | PRJEB55122_P_NODE_20413_length_245_cov_0.994898_g20016_i0 | PRJEB55122 | 20413 | 245 | 0.994898 | 2.4375001 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 442 | 1.1199999999999994e-119 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g20016 | i0 | 99.184 | 5 | 245 | 2 | 100 | 0 | 1 | 245 | 4777 | 4533 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1225 | 442 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 15423401 | 15423401 | PRJEB55122_P_NODE_30893_length_188_cov_1.892086_g30496_i0 | PRJEB55122 | 30893 | 188 | 1.892086 | 3.55712168 | Artemvirus bsasecalis | 3426461 | Viruses | Viruses | 220 | 4.17e-53 | NTclustered | gi|2209095120|gb|OL472404.1| | 2900377 | g30496 | i0 | 87.766 | 1 | 188 | 23 | 100 | 0 | 1 | 188 | 7062 | 7249 | MAG: Brine shrimp arlivirus 2 isolate PC hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 188 | 220 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsasecalis | ||
| 16697335 | 16697335 | PRJEB55122_P_NODE_20514_length_244_cov_1.323077_g20117_i0 | PRJEB55122 | 20514 | 244 | 1.323077 | 3.22830788 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 219 | 2.05e-52 | NTclustered | gi|2209095198|gb|OL472417.1| | 2900384 | g20117 | i0 | 83.264 | 0.979508196721312 | 239 | 38 | 97 | 2 | 3 | 239 | 11050 | 11288 | MAG: Brine shrimp arlivirus 9 isolate ARG/02 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 239 | 219 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 17972000 | 17972000 | PRJEB55122_P_NODE_12755_length_340_cov_2.323024_g12358_i0 | PRJEB55122 | 12755 | 340 | 2.323024 | 7.8982816 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 628 | 1.1699999999999999e-175 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g12358 | i0 | 100 | 5 | 340 | 0 | 100 | 0 | 1 | 340 | 5616 | 5277 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1700 | 628 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 19246366 | 19246366 | PRJEB55122_P_NODE_24376_length_218_cov_1.846154_g23979_i0 | PRJEB55122 | 24376 | 218 | 1.846154 | 4.02461572 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 403 | 4.62e-108 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g23979 | i0 | 100 | 5 | 218 | 0 | 100 | 0 | 1 | 218 | 6470 | 6687 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1090 | 403 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 20522115 | 20522115 | PRJEB55122_P_NODE_37297_length_168_cov_1.747899_g36900_i0 | PRJEB55122 | 37297 | 168 | 1.747899 | 2.93647032 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 311 | 2.11e-80 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g36900 | i0 | 100 | 5 | 168 | 0 | 100 | 0 | 1 | 168 | 5871 | 6038 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 840 | 311 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 21797457 | 21797457 | PRJEB55122_P_NODE_23158_length_225_cov_1.772727_g22761_i0 | PRJEB55122 | 23158 | 225 | 1.772727 | 3.98863575 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 416 | 6.159999999999998e-112 | NTclustered | gi|2209095278|gb|OL472843.1| | 2900459 | g22761 | i0 | 100 | 5.13333333333333 | 225 | 0 | 100 | 0 | 1 | 225 | 133 | 357 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 2 hypothetical protein gene, complete cds | blastn | 1155 | 416 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 23073046 | 23073046 | PRJEB55122_P_NODE_31019_length_188_cov_1.215827_g30622_i0 | PRJEB55122 | 31019 | 188 | 1.215827 | 2.28575476 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 342 | 8.539999999999999e-90 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g30622 | i0 | 99.468 | 5 | 188 | 1 | 100 | 0 | 1 | 188 | 2588 | 2775 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 940 | 342 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 24346929 | 24346929 | PRJEB55122_P_NODE_31740_length_185_cov_1.529412_g31343_i0 | PRJEB55122 | 31740 | 185 | 1.529412 | 2.8294122 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 193 | 8.919999999999999e-45 | NTclustered | gi|2209095198|gb|OL472417.1| | 2900384 | g31343 | i0 | 85.405 | 1 | 185 | 27 | 100 | 0 | 1 | 185 | 7909 | 8093 | MAG: Brine shrimp arlivirus 9 isolate ARG/02 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 185 | 193 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 26843866 | 26843866 | PRJEB55122_P_NODE_27061_length_204_cov_2.012903_g26664_i0 | PRJEB55122 | 27061 | 204 | 2.012903 | 4.10632212 | Fusarium culmorum yue-like virus 1 | 3233859 | Viruses | Viruses | 55.8 | 5.28e-7 | NR | XCO56027.1 | 3233859 | g26664 | i0 | 43.3 | 1.97058823529412 | 67 | 36 | 98.5 | 1 | 3 | 203 | 471 | 535 | XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] | diamond | 402 | 55.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Fusarium culmorum yue-like virus 1 | |||
| 27096729 | 27096729 | PRJEB55122_P_NODE_11122_length_376_cov_0.914373_g10725_i0 | PRJEB55122 | 11122 | 376 | 0.914373 | 3.43804248 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 246 | 9.28e-73 | NR | UNI74144.1 | 2900384 | g10725 | i0 | 89.6 | 0.997340425531915 | 125 | 13 | 99.7 | 0 | 2 | 376 | 92 | 216 | UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] | diamond | 375 | 246 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 28738955 | 28738955 | PRJEB55122_P_NODE_16547_length_282_cov_1.223176_g16150_i0 | PRJEB55122 | 16547 | 282 | 1.223176 | 3.44935632 | Fusarium culmorum yue-like virus 1 | 3233859 | Viruses | Viruses | 48.9 | 4.19e-4 | NR | XCO56027.1 | 3233859 | g16150 | i0 | 35.6 | 0.925531914893617 | 87 | 56 | 92.6 | 0 | 1 | 261 | 595 | 681 | XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] | diamond | 261 | 48.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Fusarium culmorum yue-like virus 1 |
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);;