contig_metadata
24 rows where bioproject = "PRJNA946307" and tax_kingdom = "Pararnavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3477818 | 3477818 | PRJNA946307_P_NODE_31483_length_232_cov_6.453552_g30609_i0 | PRJNA946307 | 31483 | 232 | 6.453552 | 14.97224064 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 158 | 4.27e-34 | NTclustered | gi|1421686372|gb|MH551473.1| | 2267679 | g30609 | i0 | 94.175 | 2.625 | 103 | 6 | 88 | 0 | 116 | 218 | 3831 | 3729 | Pinus nigra virus 1 isolate S1, complete genome | blastn | 609 | 158 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 4754810 | 4754810 | PRJNA946307_P_NODE_151804_length_164_cov_2.260870_g150930_i0 | PRJNA946307 | 151804 | 164 | 2.26087 | 3.7078268 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 174 | 2.8e-39 | NTclustered | gi|1421686372|gb|MH551473.1| | 2267679 | g150930 | i0 | 87.582 | 2.79878048780488 | 153 | 16 | 91 | 2 | 15 | 164 | 137 | 289 | Pinus nigra virus 1 isolate S1, complete genome | blastn | 459 | 174 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 8912597 | 8912597 | PRJNA946307_P_NODE_111887_length_179_cov_1.307692_g111013_i0 | PRJNA946307 | 111887 | 179 | 1.307692 | 2.34076868 | Gammaretrovirus | 153135 | Viruses | Viruses | 268 | 1.3799999999999999e-67 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g111013 | i0 | 98.675 | 2.53072625698324 | 151 | 2 | 84 | 0 | 15 | 165 | 4593 | 4443 | Moloney murine leukemia virus, complete genome | blastn | 453 | 268 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 12405327 | 12405327 | PRJNA946307_P_NODE_139230_length_167_cov_2.432203_g138356_i0 | PRJNA946307 | 139230 | 167 | 2.432203 | 4.06177901 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 158 | 2.89e-34 | NTclustered | gi|1421686372|gb|MH551473.1| | 2267679 | g138356 | i0 | 88.976 | 2.2814371257485 | 127 | 14 | 76 | 0 | 37 | 163 | 830 | 956 | Pinus nigra virus 1 isolate S1, complete genome | blastn | 381 | 158 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 20054182 | 20054182 | PRJNA946307_P_NODE_57316_length_210_cov_2.720497_g56442_i0 | PRJNA946307 | 57316 | 210 | 2.720497 | 5.7130437 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 67.6 | 6.58e-7 | NTclustered | gi|1421686372|gb|MH551473.1| | 2267679 | g56442 | i0 | 97.436 | 0.557142857142857 | 39 | 1 | 19 | 0 | 172 | 210 | 6880 | 6918 | Pinus nigra virus 1 isolate S1, complete genome | blastn | 117 | 67.6 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 21328628 | 21328628 | PRJNA946307_P_NODE_159977_length_162_cov_2.530973_g159103_i0 | PRJNA946307 | 159977 | 162 | 2.530973 | 4.10017626 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 207 | 2.72e-49 | NTclustered | gi|1571847622|ref|NC_040841.1| | 2267679 | g159103 | i0 | 91.892 | 2.7283950617284 | 148 | 12 | 91 | 0 | 15 | 162 | 577 | 724 | Pinus nigra virus 1 isolate B2, complete genome | blastn | 442 | 207 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 22603391 | 22603391 | PRJNA946307_P_NODE_145958_length_166_cov_0.871795_g145084_i0 | PRJNA946307 | 145958 | 166 | 0.871795 | 1.4471797 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 187 | 3.65e-43 | NTclustered | gi|1421686370|gb|MH551472.1| | 2267679 | g145084 | i0 | 89.404 | 2.70481927710843 | 151 | 12 | 90 | 3 | 4 | 152 | 6060 | 5912 | Pinus nigra virus 1 isolate BM, complete genome | blastn | 449 | 187 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 23880411 | 23880411 | PRJNA946307_P_NODE_77059_length_196_cov_3.217687_g76185_i0 | PRJNA946307 | 77059 | 196 | 3.217687 | 6.30666652 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 121 | 4.579999999999999e-23 | NTclustered | gi|1421686372|gb|MH551473.1| | 2267679 | g76185 | i0 | 88.119 | 1.54591836734694 | 101 | 12 | 52 | 0 | 96 | 196 | 2320 | 2420 | Pinus nigra virus 1 isolate S1, complete genome | blastn | 303 | 121 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 25153242 | 25153242 | PRJNA946307_P_NODE_33800_length_225_cov_8.727273_g32926_i0 | PRJNA946307 | 33800 | 225 | 8.727273 | 19.63636425 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 222 | 1.44e-53 | NTclustered | gi|1571847622|ref|NC_040841.1| | 2267679 | g32926 | i0 | 91.358 | 2.16 | 162 | 14 | 72 | 0 | 19 | 180 | 6530 | 6369 | Pinus nigra virus 1 isolate B2, complete genome | blastn | 486 | 222 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 26676959 | 26676959 | PRJNA946307_P_NODE_72321_length_198_cov_5.402685_g71447_i0 | PRJNA946307 | 72321 | 198 | 5.402685 | 10.6973163 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 63.5 | 9.4e-10 | NR | AXB54821.1 | 2267679 | g71447 | i0 | 90.6 | 0.484848484848485 | 32 | 3 | 48.5 | 0 | 9 | 104 | 193 | 224 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 96 | 63.5 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 26835709 | 26835709 | PRJNA946307_P_NODE_50001_length_210_cov_3.478261_g49127_i0 | PRJNA946307 | 50001 | 210 | 3.478261 | 7.3043481 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 67 | 6.69e-11 | NR | AXB54821.1 | 2267679 | g49127 | i0 | 90.9 | 0.471428571428571 | 33 | 3 | 47.1 | 0 | 100 | 2 | 1184 | 1216 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 99 | 67 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 27120013 | 27120013 | PRJNA946307_P_NODE_83962_length_191_cov_3.809859_g83088_i0 | PRJNA946307 | 83962 | 191 | 3.809859 | 7.27683069 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 55.1 | 8.42e-7 | NR | AXB54821.1 | 2267679 | g83088 | i0 | 59.6 | 0.738219895287958 | 47 | 17 | 70.7 | 1 | 2 | 136 | 1084 | 1130 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 141 | 55.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 28193894 | 28193894 | PRJNA946307_P_NODE_95606_length_186_cov_1.992701_g94732_i0 | PRJNA946307 | 95606 | 186 | 1.992701 | 3.70642386 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 106 | 5.3999999999999985e-25 | NR | AXB54821.1 | 2267679 | g94732 | i0 | 86.7 | 0.967741935483871 | 60 | 8 | 96.8 | 0 | 5 | 184 | 1138 | 1197 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 180 | 106 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 28288663 | 28288663 | PRJNA946307_P_NODE_88766_length_189_cov_2.042857_g87892_i0 | PRJNA946307 | 88766 | 189 | 2.042857 | 3.86099973 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 50.8 | 2.53e-5 | NR | AXB54821.1 | 2267679 | g87892 | i0 | 53.5 | 0.682539682539683 | 43 | 20 | 68.3 | 0 | 130 | 2 | 657 | 699 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 129 | 50.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 28952128 | 28952128 | PRJNA946307_P_NODE_96248_length_186_cov_1.408759_g95374_i0 | PRJNA946307 | 96248 | 186 | 1.408759 | 2.62029174 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 68.6 | 1.42e-11 | NR | AXB54821.1 | 2267679 | g95374 | i0 | 56.9 | 0.935483870967742 | 58 | 24 | 91.9 | 1 | 16 | 186 | 754 | 811 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 174 | 68.6 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 29015287 | 29015287 | PRJNA946307_P_NODE_29828_length_238_cov_2.000000_g28954_i0 | PRJNA946307 | 29828 | 238 | 2 | 4.76 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 86.3 | 1.72e-17 | NR | AXB54821.1 | 2267679 | g28954 | i0 | 85.7 | 0.617647058823529 | 49 | 7 | 61.8 | 0 | 91 | 237 | 935 | 983 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 147 | 86.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 29046649 | 29046649 | PRJNA946307_P_NODE_17488_length_307_cov_5.988372_g16617_i0 | PRJNA946307 | 17488 | 307 | 5.988372 | 18.38430204 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 74.3 | 6.73e-13 | NR | AXB54821.1 | 2267679 | g16617 | i0 | 51.1 | 0.859934853420195 | 88 | 8 | 85 | 3 | 265 | 5 | 792 | 845 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 264 | 74.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 29204570 | 29204570 | PRJNA946307_P_NODE_152129_length_164_cov_1.695652_g151255_i0 | PRJNA946307 | 152129 | 164 | 1.695652 | 2.78086928 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 85.9 | 7.99e-18 | NR | AXB54821.1 | 2267679 | g151255 | i0 | 79.2 | 0.878048780487805 | 48 | 10 | 87.8 | 0 | 149 | 6 | 363 | 410 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 144 | 85.9 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 29204640 | 29204640 | PRJNA946307_P_NODE_70589_length_199_cov_3.113333_g69715_i0 | PRJNA946307 | 70589 | 199 | 3.113333 | 6.19553267 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 113 | 3.2400000000000006e-27 | NR | AXB54821.1 | 2267679 | g69715 | i0 | 80.9 | 1.0251256281407 | 68 | 6 | 92 | 1 | 12 | 194 | 1550 | 1617 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 204 | 113 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 29835869 | 29835869 | PRJNA946307_P_NODE_46471_length_210_cov_4.503106_g45597_i0 | PRJNA946307 | 46471 | 210 | 4.503106 | 9.4565226 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 57.4 | 1.66e-7 | NR | AXB54821.1 | 2267679 | g45597 | i0 | 75 | 0.457142857142857 | 32 | 8 | 45.7 | 0 | 208 | 113 | 387 | 418 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 96 | 57.4 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 30562271 | 30562271 | PRJNA946307_P_NODE_156033_length_163_cov_2.236842_g155159_i0 | PRJNA946307 | 156033 | 163 | 2.236842 | 3.64605246 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 92 | 5.46e-20 | NR | AXB54821.1 | 2267679 | g155159 | i0 | 87.8 | 0.901840490797546 | 49 | 6 | 90.2 | 0 | 147 | 1 | 1413 | 1461 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 147 | 92 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 30941861 | 30941861 | PRJNA946307_P_NODE_151474_length_164_cov_2.495652_g150600_i0 | PRJNA946307 | 151474 | 164 | 2.495652 | 4.09286928 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 92.8 | 2.93e-20 | NR | AXB54821.1 | 2267679 | g150600 | i0 | 89.8 | 0.896341463414634 | 49 | 5 | 89.6 | 0 | 12 | 158 | 690 | 738 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 147 | 92.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 30941901 | 30941901 | PRJNA946307_P_NODE_40054_length_212_cov_7.638037_g39180_i0 | PRJNA946307 | 40054 | 212 | 7.638037 | 16.19263844 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 54.3 | 2.11e-6 | NR | AXB54821.1 | 2267679 | g39180 | i0 | 73.3 | 0.424528301886792 | 30 | 8 | 42.5 | 0 | 206 | 117 | 542 | 571 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 90 | 54.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra virus 1 | |||
| 32460009 | 32460009 | PRJNA946307_P_NODE_46419_length_210_cov_4.521739_g45545_i0 | PRJNA946307 | 46419 | 210 | 4.521739 | 9.4956519 | Pinus nigra virus 1 | 2267679 | Viruses | Viruses | 57.4 | 1.66e-7 | NR | AXB54821.1 | 2267679 | g45545 | i0 | 43.9 | 0.942857142857143 | 66 | 33 | 94.3 | 1 | 209 | 12 | 754 | 815 | AXB54821.1 polyprotein [Pinus nigra virus 1] | diamond | 198 | 57.4 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Pinus nigra 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);;