contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJEB55122" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1395930 | 1395930 | PRJEB55122_P_NODE_782_length_1683_cov_3.285802_g679_i0 | PRJEB55122 | 782 | 1683 | 3.285802 | 55.30004766 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 3068 | 0 | NTclustered | gi|2209094744|gb|OL472444.1| | 2900464 | g679 | i0 | 99.584 | 10.9881164587047 | 1682 | 7 | 99 | 0 | 1 | 1682 | 7539 | 9220 | MAG: Brine shrimp iflavirus 3 isolate RUS/14-15 RNA-dependent RNA polymerase gene, complete cds | blastn | 18493 | 3068 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 2671313 | 2671313 | PRJEB55122_P_NODE_37983_length_168_cov_0.873950_g37586_i0 | PRJEB55122 | 37983 | 168 | 0.87395 | 1.468236 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 305 | 9.81e-79 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g37586 | i0 | 99.405 | 11 | 168 | 1 | 100 | 0 | 1 | 168 | 1464 | 1631 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 1848 | 305 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 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 | |||
| 5222971 | 5222971 | PRJEB55122_P_NODE_16345_length_284_cov_1.765957_g15948_i0 | PRJEB55122 | 16345 | 284 | 1.765957 | 5.01531788 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 520 | 5.98e-143 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g15948 | i0 | 99.648 | 11.2112676056338 | 284 | 1 | 100 | 0 | 1 | 284 | 3345 | 3628 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 3184 | 520 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 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 | |||
| 19246338 | 19246338 | PRJEB55122_P_NODE_23676_length_222_cov_2.156069_g23279_i0 | PRJEB55122 | 23676 | 222 | 2.156069 | 4.78647318 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 399 | 6.099999999999999e-107 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g23279 | i0 | 99.099 | 11 | 222 | 2 | 100 | 0 | 1 | 222 | 7275 | 7496 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 2442 | 399 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 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 |
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);;