contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA193544" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 365853 | 365853 | PRJNA193544_S_NODE_1221_length_231_cov_19899.222772_g1206_i0 | PRJNA193544 | 1221 | 231 | 19899.222772 | 45967.20460332 | Chemarfal virus 181 | 3063102 | Viruses | Viruses | 228 | 3.1999999999999998e-55 | NTclustered | gi|2626079679|gb|OR270419.1| | 3063102 | g1206 | i0 | 87.692 | 0.844155844155844 | 195 | 24 | 84 | 0 | 35 | 229 | 2517 | 2323 | MAG: Chemarfal virus 181 isolate ML187 genomic sequence | blastn | 195 | 228 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Chemarfal virus 181 | ||||
| 365858 | 365858 | PRJNA193544_S_NODE_1381_length_220_cov_5.738220_g1366_i0 | PRJNA193544 | 1381 | 220 | 5.73822 | 12.624084 | Tolivirales sp. | 2809914 | Viruses | Viruses | 390 | 3.629999999999999e-104 | NTclustered | gi|2647549365|gb|OR843627.1| | 2809914 | g1366 | i0 | 98.636 | 1 | 220 | 3 | 100 | 0 | 1 | 220 | 1814 | 1595 | Tolivirales sp. strain MR233-17E/3079 polyprotein gene, complete cds; and structural protein gene, partial cds | blastn | 220 | 390 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 365870 | 365870 | PRJNA193544_S_NODE_1681_length_204_cov_287.834286_g1666_i0 | PRJNA193544 | 1681 | 204 | 287.834286 | 587.18194344 | Tolivirales sp. | 2809914 | Viruses | Viruses | 305 | 1.24e-78 | NTclustered | gi|2647549365|gb|OR843627.1| | 2809914 | g1666 | i0 | 97.74 | 0.867647058823529 | 177 | 4 | 87 | 0 | 28 | 204 | 3461 | 3285 | Tolivirales sp. strain MR233-17E/3079 polyprotein gene, complete cds; and structural protein gene, partial cds | blastn | 177 | 305 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 365873 | 365873 | PRJNA193544_S_NODE_1941_length_194_cov_7.327273_g1926_i0 | PRJNA193544 | 1941 | 194 | 7.327273 | 14.21490962 | Tolivirales sp. gcode 6 | 3108923 | Viruses | Viruses | 320 | 4.16e-83 | NTclustered | gi|2647550025|gb|OR843800.1| | 3108923 | g1926 | i0 | 96.875 | 0.989690721649485 | 192 | 5 | 98 | 1 | 1 | 191 | 1770 | 1961 | Tolivirales sp. gcode 6 strain MR233-17E/7345 hypothetical protein gene, partial cds; RNA-dependent RNA polymerase gene, complete cds; and structural protein gene, partial cds | blastn | 192 | 320 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. gcode 6 | ||||
| 4192967 | 4192967 | PRJNA193544_S_NODE_1564_length_210_cov_12.392265_g1549_i0 | PRJNA193544 | 1564 | 210 | 12.392265 | 26.0237565 | Tolivirales sp. gcode 6 | 3108923 | Viruses | Viruses | 331 | 2.11e-86 | NTclustered | gi|2647550025|gb|OR843800.1| | 3108923 | g1549 | i0 | 96.5 | 1.83333333333333 | 200 | 7 | 95 | 0 | 11 | 210 | 1738 | 1539 | Tolivirales sp. gcode 6 strain MR233-17E/7345 hypothetical protein gene, partial cds; RNA-dependent RNA polymerase gene, complete cds; and structural protein gene, partial cds | blastn | 385 | 331 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. gcode 6 | ||||
| 5469222 | 5469222 | PRJNA193544_S_NODE_205_length_395_cov_1938.024590_g190_i0 | PRJNA193544 | 205 | 395 | 1938.02459 | 7655.1971305 | Tolivirales sp. | 2809914 | Viruses | Viruses | 564 | 3.9299999999999997e-156 | NTclustered | gi|2647549365|gb|OR843627.1| | 2809914 | g190 | i0 | 99.675 | 0.855696202531646 | 308 | 1 | 78 | 0 | 88 | 395 | 2657 | 2350 | Tolivirales sp. strain MR233-17E/3079 polyprotein gene, complete cds; and structural protein gene, partial cds | blastn | 338 | 564 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 6743566 | 6743566 | PRJNA193544_S_NODE_2446_length_176_cov_7.061224_g2431_i0 | PRJNA193544 | 2446 | 176 | 7.061224 | 12.42775424 | Tolivirales sp. gcode 6 | 3108923 | Viruses | Viruses | 278 | 2.25e-70 | NTclustered | gi|2647550025|gb|OR843800.1| | 3108923 | g2431 | i0 | 95.402 | 0.988636363636364 | 174 | 8 | 99 | 0 | 3 | 176 | 89 | 262 | Tolivirales sp. gcode 6 strain MR233-17E/7345 hypothetical protein gene, partial cds; RNA-dependent RNA polymerase gene, complete cds; and structural protein gene, partial cds | blastn | 174 | 278 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. gcode 6 | ||||
| 6743570 | 6743570 | PRJNA193544_S_NODE_2606_length_171_cov_6.204225_g2591_i0 | PRJNA193544 | 2606 | 171 | 6.204225 | 10.60922475 | Nodamuvirales sp. | 2809606 | Viruses | Viruses | 172 | 1.0499999999999999e-38 | NTclustered | gi|2846847713|gb|PQ521787.1| | 2809606 | g2591 | i0 | 84.795 | 1 | 171 | 26 | 100 | 0 | 1 | 171 | 1023 | 853 | MAG: Nodamuvirales sp. isolate Teltow Canal noda-like virus 103 MR233-17E/4950 genomic sequence | blastn | 171 | 172 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodamuvirales sp. | ||||
| 6743574 | 6743574 | PRJNA193544_S_NODE_286_length_363_cov_4.308383_g271_i0 | PRJNA193544 | 286 | 363 | 4.308383 | 15.63943029 | Tolivirales sp. | 2809914 | Viruses | Viruses | 632 | 9.67e-177 | NTclustered | gi|2647549365|gb|OR843627.1| | 2809914 | g271 | i0 | 99.71 | 0.950413223140496 | 345 | 1 | 95 | 0 | 19 | 363 | 511 | 855 | Tolivirales sp. strain MR233-17E/3079 polyprotein gene, complete cds; and structural protein gene, partial cds | blastn | 345 | 632 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 10569998 | 10569998 | PRJNA193544_S_NODE_989_length_252_cov_4.650224_g974_i0 | PRJNA193544 | 989 | 252 | 4.650224 | 11.71856448 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 433 | 6.98e-117 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g974 | i0 | 97.619 | 3.44047619047619 | 252 | 6 | 100 | 0 | 1 | 252 | 3326 | 3577 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 867 | 433 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 11844461 | 11844461 | PRJNA193544_S_NODE_2510_length_174_cov_5.924138_g2495_i0 | PRJNA193544 | 2510 | 174 | 5.924138 | 10.30800012 | Tolivirales sp. | 2809914 | Viruses | Viruses | 311 | 2.19e-80 | NTclustered | gi|2647549365|gb|OR843627.1| | 2809914 | g2495 | i0 | 98.857 | 1.00574712643678 | 175 | 1 | 100 | 1 | 1 | 174 | 2955 | 3129 | Tolivirales sp. strain MR233-17E/3079 polyprotein gene, complete cds; and structural protein gene, partial cds | blastn | 175 | 311 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 14394947 | 14394947 | PRJNA193544_S_NODE_1112_length_242_cov_5.474178_g1097_i0 | PRJNA193544 | 1112 | 242 | 5.474178 | 13.24751076 | Tolivirales sp. gcode 6 | 3108923 | Viruses | Viruses | 411 | 3.1199999999999996e-110 | NTclustered | gi|2647550025|gb|OR843800.1| | 3108923 | g1097 | i0 | 99.123 | 2.02479338842975 | 228 | 2 | 94 | 0 | 15 | 242 | 1329 | 1102 | Tolivirales sp. gcode 6 strain MR233-17E/7345 hypothetical protein gene, partial cds; RNA-dependent RNA polymerase gene, complete cds; and structural protein gene, partial cds | blastn | 490 | 411 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. gcode 6 | ||||
| 16943166 | 16943166 | PRJNA193544_S_NODE_2514_length_174_cov_4.020690_g2499_i0 | PRJNA193544 | 2514 | 174 | 4.02069 | 6.9960006 | Nodamuvirales sp. | 2809606 | Viruses | Viruses | 222 | 1.05e-53 | NTclustered | gi|2846847713|gb|PQ521787.1| | 2809606 | g2499 | i0 | 90.058 | 0.982758620689655 | 171 | 17 | 98 | 0 | 4 | 174 | 2500 | 2670 | MAG: Nodamuvirales sp. isolate Teltow Canal noda-like virus 103 MR233-17E/4950 genomic sequence | blastn | 171 | 222 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodamuvirales sp. | ||||
| 16943168 | 16943168 | PRJNA193544_S_NODE_2674_length_169_cov_4.285714_g2659_i0 | PRJNA193544 | 2674 | 169 | 4.285714 | 7.24285666 | Tolivirales sp. | 2809914 | Viruses | Viruses | 292 | 7.64e-75 | NTclustered | gi|2647549365|gb|OR843627.1| | 2809914 | g2659 | i0 | 100 | 0.93491124260355 | 158 | 0 | 93 | 0 | 6 | 163 | 158 | 1 | Tolivirales sp. strain MR233-17E/3079 polyprotein gene, complete cds; and structural protein gene, partial cds | blastn | 158 | 292 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 19491852 | 19491852 | PRJNA193544_S_NODE_1176_length_236_cov_7.193237_g1161_i0 | PRJNA193544 | 1176 | 236 | 7.193237 | 16.97603932 | Tolivirales sp. | 2809914 | Viruses | Viruses | 424 | 3.89e-114 | NTclustered | gi|2647549365|gb|OR843627.1| | 2809914 | g1161 | i0 | 99.149 | 0.995762711864407 | 235 | 2 | 99 | 0 | 2 | 236 | 2178 | 1944 | Tolivirales sp. strain MR233-17E/3079 polyprotein gene, complete cds; and structural protein gene, partial cds | blastn | 235 | 424 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 19491903 | 19491903 | PRJNA193544_S_NODE_516_length_315_cov_6.087413_g501_i0 | PRJNA193544 | 516 | 315 | 6.087413 | 19.17535095 | Nodamuvirales sp. | 2809606 | Viruses | Viruses | 294 | 4.44e-75 | NTclustered | gi|2846847713|gb|PQ521787.1| | 2809606 | g501 | i0 | 83.544 | 2.01269841269841 | 316 | 50 | 100 | 2 | 1 | 315 | 1835 | 1521 | MAG: Nodamuvirales sp. isolate Teltow Canal noda-like virus 103 MR233-17E/4950 genomic sequence | blastn | 634 | 294 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodamuvirales sp. | ||||
| 20767432 | 20767432 | PRJNA193544_S_NODE_3197_length_156_cov_3.047244_g3182_i0 | PRJNA193544 | 3197 | 156 | 3.047244 | 4.75370064 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 283 | 4.1899999999999994e-72 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g3182 | i0 | 99.359 | 3.97435897435897 | 156 | 1 | 100 | 0 | 1 | 156 | 1727 | 1572 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 620 | 283 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 22042539 | 22042539 | PRJNA193544_S_NODE_38_length_610_cov_13.179002_g30_i0 | PRJNA193544 | 38 | 610 | 13.179002 | 80.3919122 | Tolivirales sp. gcode 6 | 3108923 | Viruses | Viruses | 1005 | 0 | NTclustered | gi|2647550025|gb|OR843800.1| | 3108923 | g30 | i0 | 96.393 | 2.94098360655738 | 610 | 22 | 100 | 0 | 1 | 610 | 312 | 921 | Tolivirales sp. gcode 6 strain MR233-17E/7345 hypothetical protein gene, partial cds; RNA-dependent RNA polymerase gene, complete cds; and structural protein gene, partial cds | blastn | 1794 | 1005 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. gcode 6 | ||||
| 23318008 | 23318008 | PRJNA193544_S_NODE_2839_length_164_cov_10.437037_g2824_i0 | PRJNA193544 | 2839 | 164 | 10.437037 | 17.11674068 | Nodamuvirales sp. | 2809606 | Viruses | Viruses | 243 | 7.57e-60 | NTclustered | gi|2846847713|gb|PQ521787.1| | 2809606 | g2824 | i0 | 93.827 | 1.96341463414634 | 162 | 8 | 98 | 2 | 4 | 164 | 2307 | 2147 | MAG: Nodamuvirales sp. isolate Teltow Canal noda-like virus 103 MR233-17E/4950 genomic sequence | blastn | 322 | 243 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodamuvirales sp. | ||||
| 23318009 | 23318009 | PRJNA193544_S_NODE_2879_length_163_cov_5.037313_g2864_i0 | PRJNA193544 | 2879 | 163 | 5.037313 | 8.21082019 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 272 | 9.58e-69 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g2864 | i0 | 100 | 2.07975460122699 | 147 | 0 | 90 | 0 | 17 | 163 | 4228 | 4082 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 339 | 272 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 |
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);;