contig_metadata
19 rows where bioproject = "PRJDB3785", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1282956 | 1282956 | PRJDB3785_S_NODE_11582_length_224_cov_1.217143_g11429_i0 | PRJDB3785 | 11582 | 224 | 1.217143 | 2.72640032 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 370 | 4.84e-98 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g11429 | i0 | 96.429 | 1 | 224 | 8 | 100 | 0 | 1 | 224 | 3385 | 3608 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 224 | 370 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 1283026 | 1283026 | PRJDB3785_S_NODE_17362_length_189_cov_0.864286_g17209_i0 | PRJDB3785 | 17362 | 189 | 0.864286 | 1.63350054 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 303 | 4.06e-78 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g17209 | i0 | 96.216 | 0.978835978835979 | 185 | 7 | 98 | 0 | 1 | 185 | 465 | 649 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 185 | 303 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 1283138 | 1283138 | PRJDB3785_S_NODE_3302_length_426_cov_1.371353_g3149_i0 | PRJDB3785 | 3302 | 426 | 1.371353 | 5.84196378 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 682 | 0 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g3149 | i0 | 95.54 | 1 | 426 | 19 | 100 | 0 | 1 | 426 | 4488 | 4063 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 426 | 682 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 1283189 | 1283189 | PRJDB3785_S_NODE_5822_length_312_cov_3.570342_g5669_i0 | PRJDB3785 | 5822 | 312 | 3.570342 | 11.13946704 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 521 | 1.8499999999999998e-143 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g5669 | i0 | 96.795 | 1.23717948717949 | 312 | 10 | 100 | 0 | 1 | 312 | 4476 | 4787 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 386 | 521 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 2558530 | 2558530 | PRJDB3785_S_NODE_10323_length_236_cov_0.871658_g10170_i0 | PRJDB3785 | 10323 | 236 | 0.871658 | 2.05711288 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 305 | 1.47e-78 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g10170 | i0 | 90.171 | 0.991525423728814 | 234 | 23 | 99 | 0 | 1 | 234 | 4206 | 3973 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 234 | 305 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 2558537 | 2558537 | PRJDB3785_S_NODE_10783_length_231_cov_0.835165_g10630_i0 | PRJDB3785 | 10783 | 231 | 0.835165 | 1.92923115 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 394 | 2.98e-105 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g10630 | i0 | 97.403 | 1 | 231 | 6 | 100 | 0 | 1 | 231 | 3547 | 3777 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 231 | 394 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 2558675 | 2558675 | PRJDB3785_S_NODE_22223_length_170_cov_0.867769_g22070_i0 | PRJDB3785 | 22223 | 170 | 0.867769 | 1.4752073 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 248 | 1.69e-61 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g22070 | i0 | 92.941 | 1.91764705882353 | 170 | 12 | 100 | 0 | 1 | 170 | 4831 | 4662 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 326 | 248 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 5111097 | 5111097 | PRJDB3785_S_NODE_11025_length_229_cov_0.855556_g10872_i0 | PRJDB3785 | 11025 | 229 | 0.855556 | 1.95922324 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 379 | 8.249999999999999e-101 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g10872 | i0 | 96.507 | 1 | 229 | 8 | 100 | 0 | 1 | 229 | 2204 | 2432 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 229 | 379 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 6387110 | 6387110 | PRJDB3785_S_NODE_23746_length_166_cov_1.179487_g23593_i0 | PRJDB3785 | 23746 | 166 | 1.179487 | 1.95794842 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 285 | 1.26e-72 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g23593 | i0 | 97.59 | 1 | 166 | 4 | 100 | 0 | 1 | 166 | 2719 | 2554 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 166 | 285 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 6387244 | 6387244 | PRJDB3785_S_NODE_8646_length_256_cov_2.048309_g8493_i0 | PRJDB3785 | 8646 | 256 | 2.048309 | 5.24367104 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 435 | 1.98e-117 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g8493 | i0 | 97.628 | 0.98828125 | 253 | 6 | 99 | 0 | 4 | 256 | 4060 | 3808 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 253 | 435 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 12762324 | 12762324 | PRJDB3785_S_NODE_17291_length_189_cov_1.242857_g17138_i0 | PRJDB3785 | 17291 | 189 | 1.242857 | 2.34899973 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 327 | 2.41e-85 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g17138 | i0 | 97.884 | 1 | 189 | 4 | 100 | 0 | 1 | 189 | 930 | 1118 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 189 | 327 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 15310887 | 15310887 | PRJDB3785_S_NODE_20233_length_177_cov_1.109375_g20080_i0 | PRJDB3785 | 20233 | 177 | 1.109375 | 1.96359375 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 300 | 4.84e-77 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g20080 | i0 | 97.175 | 1 | 177 | 5 | 100 | 0 | 1 | 177 | 2450 | 2626 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 177 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 15310901 | 15310901 | PRJDB3785_S_NODE_213_length_1610_cov_8.560538_g192_i0 | PRJDB3785 | 213 | 1610 | 8.560538 | 137.8246618 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 2769 | 0 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g192 | i0 | 97.763 | 2.7832298136646 | 1609 | 33 | 99 | 3 | 3 | 1610 | 6330 | 4724 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 4481 | 2769 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 17860658 | 17860658 | PRJDB3785_S_NODE_215_length_1603_cov_7.880952_g192_i1 | PRJDB3785 | 215 | 1603 | 7.880952 | 126.33166056 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 2704 | 0 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g192 | i1 | 97.075 | 2.77666874610106 | 1607 | 43 | 100 | 2 | 1 | 1603 | 4724 | 6330 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 4451 | 2704 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 19134310 | 19134310 | PRJDB3785_S_NODE_18156_length_185_cov_1.316176_g18003_i0 | PRJDB3785 | 18156 | 185 | 1.316176 | 2.4349256 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 298 | 1.84e-76 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g18003 | i0 | 95.676 | 1 | 185 | 8 | 100 | 0 | 1 | 185 | 2253 | 2069 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 185 | 298 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 20409481 | 20409481 | PRJDB3785_S_NODE_26017_length_163_cov_0.868421_g25864_i0 | PRJDB3785 | 26017 | 163 | 0.868421 | 1.41552623 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 274 | 2.66e-69 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g25864 | i0 | 96.933 | 1 | 163 | 5 | 100 | 0 | 1 | 163 | 3145 | 3307 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 163 | 274 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 24234661 | 24234661 | PRJDB3785_S_NODE_19960_length_178_cov_1.116279_g19807_i0 | PRJDB3785 | 19960 | 178 | 1.116279 | 1.98697662 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 300 | 4.87e-77 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g19807 | i0 | 97.175 | 0.99438202247191 | 177 | 5 | 99 | 0 | 1 | 177 | 3209 | 3385 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 177 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 27790713 | 27790713 | PRJDB3785_S_NODE_19124_length_181_cov_1.234848_g18971_i0 | PRJDB3785 | 19124 | 181 | 1.234848 | 2.23507488 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 118 | 4.57e-29 | NR | UNI73998.1 | 2900478 | g18971 | i0 | 96.7 | 0.994475138121547 | 60 | 2 | 99.4 | 0 | 181 | 2 | 1176 | 1235 | UNI73998.1 MAG: RNA-dependent RNA polymerase [brine shrimp tymo-like virus 1] | diamond | 180 | 118 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 32813661 | 32813661 | PRJDB3785_S_NODE_15700_length_197_cov_0.979730_g15547_i0 | PRJDB3785 | 15700 | 197 | 0.97973 | 1.9300681 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 134 | 1.21e-34 | NR | UNI73998.1 | 2900478 | g15547 | i0 | 100 | 0.989847715736041 | 65 | 0 | 99 | 0 | 196 | 2 | 244 | 308 | UNI73998.1 MAG: RNA-dependent RNA polymerase [brine shrimp tymo-like virus 1] | diamond | 195 | 134 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-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);;