contig_metadata
17 rows where bioproject = "PRJNA600413", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1141984 | 1141984 | PRJNA600413_P_NODE_16181_length_359_cov_1.648387_g15480_i0 | PRJNA600413 | 16181 | 359 | 1.648387 | 5.91770933 | Coguvirus | 2560118 | Viruses | Viruses | 664 | 0 | NTclustered | gi|2019278450|gb|MW334941.1| | 2024604 | g15480 | i0 | 100 | 24.6740947075209 | 359 | 0 | 100 | 0 | 1 | 359 | 3460 | 3102 | Citrus concave gum-associated virus isolate CCGAV/FT159 RNA-dependent RNA polymerase gene, complete cds | blastn | 8858 | 664 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 1142176 | 1142176 | PRJNA600413_P_NODE_33401_length_247_cov_1.287879_g32700_i0 | PRJNA600413 | 33401 | 247 | 1.287879 | 3.18106113 | Coguvirus | 2560118 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2125202293|gb|OK495690.1| | 2024604 | g32700 | i0 | 100 | 25.8056680161943 | 247 | 0 | 100 | 0 | 1 | 247 | 291 | 537 | Citrus concave gum-associated virus isolate CE-c3 segment RNA1, complete sequence | blastn | 6374 | 457 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 7519673 | 7519673 | PRJNA600413_P_NODE_1346_length_1208_cov_5.570319_g1026_i0 | PRJNA600413 | 1346 | 1208 | 5.570319 | 67.28945352 | Coguvirus | 2560118 | Viruses | Viruses | 2226 | 0 | NTclustered | gi|2594666308|gb|OR640154.1| | 2024604 | g1026 | i0 | 99.917 | 45.3948675496689 | 1208 | 1 | 100 | 0 | 1 | 1208 | 1494 | 2701 | Citrus concave gum-associated virus isolate CCGaV_RNA2_T segment RNA2, complete sequence | blastn | 54837 | 2226 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 7520558 | 7520558 | PRJNA600413_P_NODE_90446_length_173_cov_1.645161_g89745_i0 | PRJNA600413 | 90446 | 173 | 1.645161 | 2.84612853 | Coguvirus | 2560118 | Viruses | Viruses | 320 | 3.61e-83 | NTclustered | gi|2125202293|gb|OK495690.1| | 2024604 | g89745 | i0 | 100 | 26.5722543352601 | 173 | 0 | 100 | 0 | 1 | 173 | 1454 | 1282 | Citrus concave gum-associated virus isolate CE-c3 segment RNA1, complete sequence | blastn | 4597 | 320 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 12053260 | 12053260 | PRJNA600413_P_NODE_33950_length_245_cov_1.561224_g33249_i0 | PRJNA600413 | 33950 | 245 | 1.561224 | 3.8249988 | Coguvirus citri | 3052136 | Viruses | Viruses | 448 | 2.41e-121 | NTclustered | gi|2019278450|gb|MW334941.1| | 2024604 | g33249 | i0 | 99.592 | 20.9428571428571 | 245 | 1 | 100 | 0 | 1 | 245 | 1219 | 975 | Citrus concave gum-associated virus isolate CCGAV/FT159 RNA-dependent RNA polymerase gene, complete cds | blastn | 5131 | 448 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 13895693 | 13895693 | PRJNA600413_P_NODE_1071_length_1313_cov_6.392405_g795_i0 | PRJNA600413 | 1071 | 1313 | 6.392405 | 83.93227765 | Coguvirus | 2560118 | Viruses | Viruses | 2392 | 0 | NTclustered | gi|2594666308|gb|OR640154.1| | 2024604 | g795 | i0 | 99.543 | 24.9352627570449 | 1313 | 6 | 100 | 0 | 1 | 1313 | 1325 | 13 | Citrus concave gum-associated virus isolate CCGaV_RNA2_T segment RNA2, complete sequence | blastn | 32740 | 2392 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 13895886 | 13895886 | PRJNA600413_P_NODE_137951_length_162_cov_1.353982_g137250_i0 | PRJNA600413 | 137951 | 162 | 1.353982 | 2.19345084 | Coguvirus | 2560118 | Viruses | Viruses | 298 | 1.57e-76 | NTclustered | gi|2758934013|gb|OR537855.1| | 2024604 | g137250 | i0 | 100 | 22.8518518518519 | 161 | 0 | 99 | 0 | 2 | 162 | 2656 | 2816 | Citrus concave gum-associated virus isolate Semnan-A10 segment RNA-1, complete sequence | blastn | 3702 | 298 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 16445111 | 16445111 | PRJNA600413_P_NODE_54193_length_202_cov_2.653595_g53492_i0 | PRJNA600413 | 54193 | 202 | 2.653595 | 5.3602619 | Coguvirus | 2560118 | Viruses | Viruses | 374 | 3.3e-99 | NTclustered | gi|2758934013|gb|OR537855.1| | 2024604 | g53492 | i0 | 100 | 22.4257425742574 | 202 | 0 | 100 | 0 | 1 | 202 | 4708 | 4507 | Citrus concave gum-associated virus isolate Semnan-A10 segment RNA-1, complete sequence | blastn | 4530 | 374 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 20269027 | 20269027 | PRJNA600413_P_NODE_72776_length_184_cov_2.266667_g72075_i0 | PRJNA600413 | 72776 | 184 | 2.266667 | 4.17066728 | Coguvirus | 2560118 | Viruses | Viruses | 340 | 2.99e-89 | NTclustered | gi|2125202293|gb|OK495690.1| | 2024604 | g72075 | i0 | 100 | 21 | 184 | 0 | 100 | 0 | 1 | 184 | 5908 | 5725 | Citrus concave gum-associated virus isolate CE-c3 segment RNA1, complete sequence | blastn | 3864 | 340 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 22250885 | 22250885 | PRJNA600413_P_NODE_22578_length_299_cov_12.836000_g21877_i0 | PRJNA600413 | 22578 | 299 | 12.836 | 38.37964 | Rubodvirus prosserense | 2734485 | Viruses | Viruses | 388 | 1.87e-103 | NTclustered | gi|1381624487|gb|MF062135.1| | 2164103 | g21877 | i0 | 90.667 | 40.7926421404682 | 300 | 16 | 99 | 5 | 2 | 299 | 1459 | 1170 | Apple rubbery wood virus 2 isolate 355-1 segment Sa capsid protein (CP) gene, complete cds | blastn | 12197 | 388 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Rubodvirus | Rubodvirus prosserense | ||
| 22819279 | 22819279 | PRJNA600413_P_NODE_21778_length_305_cov_1.914062_g21077_i0 | PRJNA600413 | 21778 | 305 | 1.914062 | 5.8378891 | Coguvirus | 2560118 | Viruses | Viruses | 564 | 2.95e-156 | NTclustered | gi|2125202293|gb|OK495690.1| | 2024604 | g21077 | i0 | 100 | 21 | 305 | 0 | 100 | 0 | 1 | 305 | 6473 | 6169 | Citrus concave gum-associated virus isolate CE-c3 segment RNA1, complete sequence | blastn | 6405 | 564 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 23526830 | 23526830 | PRJNA600413_P_NODE_48739_length_211_cov_1.259259_g48038_i0 | PRJNA600413 | 48739 | 211 | 1.259259 | 2.65703649 | Rubodvirus prosserense | 2734485 | Viruses | Viruses | 385 | 1.61e-102 | NTclustered | gi|1381622473|gb|MF062128.1| | 2164103 | g48038 | i0 | 99.526 | 14.9241706161137 | 211 | 1 | 100 | 0 | 1 | 211 | 5578 | 5368 | Apple rubbery wood virus 2 isolate 982-11 segment L RNA-dependent RNA polymerase (RdRp) gene, complete cds | blastn | 3149 | 385 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Rubodvirus | Rubodvirus prosserense | ||
| 24094172 | 24094172 | PRJNA600413_P_NODE_38379_length_232_cov_1.901639_g37678_i0 | PRJNA600413 | 38379 | 232 | 1.901639 | 4.41180248 | Coguvirus | 2560118 | Viruses | Viruses | 424 | 3.82e-114 | NTclustered | gi|2125202293|gb|OK495690.1| | 2024604 | g37678 | i0 | 99.569 | 21 | 232 | 1 | 100 | 0 | 1 | 232 | 5943 | 6174 | Citrus concave gum-associated virus isolate CE-c3 segment RNA1, complete sequence | blastn | 4872 | 424 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 25367995 | 25367995 | PRJNA600413_P_NODE_10560_length_455_cov_1.963054_g9861_i0 | PRJNA600413 | 10560 | 455 | 1.963054 | 8.9318957 | Coguvirus | 2560118 | Viruses | Viruses | 819 | 0 | NTclustered | gi|2019278450|gb|MW334941.1| | 2024604 | g9861 | i0 | 99.121 | 23 | 455 | 4 | 100 | 0 | 1 | 455 | 4746 | 4292 | Citrus concave gum-associated virus isolate CCGAV/FT159 RNA-dependent RNA polymerase gene, complete cds | blastn | 10465 | 819 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 25368339 | 25368339 | PRJNA600413_P_NODE_18360_length_334_cov_2.638596_g17659_i0 | PRJNA600413 | 18360 | 334 | 2.638596 | 8.81291064 | Coguvirus | 2560118 | Viruses | Viruses | 617 | 2.48e-172 | NTclustered | gi|2019278450|gb|MW334941.1| | 2024604 | g17659 | i0 | 100 | 22 | 334 | 0 | 100 | 0 | 1 | 334 | 1901 | 1568 | Citrus concave gum-associated virus isolate CCGAV/FT159 RNA-dependent RNA polymerase gene, complete cds | blastn | 7348 | 617 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Coguvirus | Coguvirus citri | ||
| 29114372 | 29114372 | PRJNA600413_P_NODE_58808_length_196_cov_1.387755_g58107_i0 | PRJNA600413 | 58808 | 196 | 1.387755 | 2.7199998 | Chuvivirus | 2842604 | Viruses | Viruses | 83.2 | 1.07e-16 | NR | UVF58769.1 | 2842604 | g58107 | i0 | 60.9 | 2.93877551020408 | 64 | 25 | 98 | 0 | 194 | 3 | 288 | 351 | UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus] | diamond | 576 | 83.6 | 0.995215311004785 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Chuvivirus | ||
| 30427916 | 30427916 | PRJNA600413_P_NODE_54673_length_202_cov_1.000000_g53972_i0 | PRJNA600413 | 54673 | 202 | 1 | 2.02 | Chuvivirus | 2842604 | Viruses | Viruses | 50.4 | 3.98e-5 | NR | WET19891.1 | 2842604 | g53972 | i0 | 52.5 | 0.594059405940594 | 40 | 19 | 59.4 | 0 | 200 | 81 | 458 | 497 | WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] | diamond | 120 | 50.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus |
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);;