contig_metadata
22 rows where bioproject = "PRJNA1148190" and tax_phylum = "Cressdnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4123956 | 4123956 | PRJNA1148190_P_NODE_536044_length_259_cov_5.758065_g524871_i0 | PRJNA1148190 | 536044 | 259 | 5.758065 | 14.91338835 | Herugrimvirus gladden | 2955985 | Viruses | Viruses | 457 | 4.279999999999999e-124 | NTclustered | gi|1896080254|gb|MT293424.1| | 2766565 | g524871 | i0 | 98.456 | 1 | 259 | 4 | 100 | 0 | 1 | 259 | 241 | 499 | Giardia-associated CRESS DNA virus 1 isolate 84-AMS-04, partial genome | blastn | 259 | 457 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Vilyaviridae | Herugrimvirus | Herugrimvirus gladden | ||
| 9220231 | 9220231 | PRJNA1148190_P_NODE_204368_length_373_cov_1.376667_g193198_i0 | PRJNA1148190 | 204368 | 373 | 1.376667 | 5.13496791 | Herugrimvirus gladden | 2955985 | Viruses | Viruses | 641 | 1.66e-179 | NTclustered | gi|1896080254|gb|MT293424.1| | 2766565 | g193198 | i0 | 97.844 | 0.994638069705094 | 371 | 8 | 99 | 0 | 1 | 371 | 679 | 1049 | Giardia-associated CRESS DNA virus 1 isolate 84-AMS-04, partial genome | blastn | 371 | 641 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Vilyaviridae | Herugrimvirus | Herugrimvirus gladden | ||
| 10500862 | 10500862 | PRJNA1148190_P_NODE_541709_length_258_cov_2.221622_g530536_i0 | PRJNA1148190 | 541709 | 258 | 2.221622 | 5.73178476 | Vingilotevirus gamgee | 2956647 | Viruses | Viruses | 274 | 4.6e-69 | NTclustered | gi|2500381887|ref|NC_076892.1| | 2766566 | g530536 | i0 | 85.878 | 1.01550387596899 | 262 | 32 | 100 | 3 | 1 | 258 | 1784 | 1524 | Giardia-associated CRESS DNA virus 2 isolate 84-AMS-01, complete genome | blastn | 262 | 274 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Vilyaviridae | Vingilotevirus | Vingilotevirus gamgee | ||
| 27039508 | 27039508 | PRJNA1148190_P_NODE_39562_length_1021_cov_194.686709_g29195_i0 | PRJNA1148190 | 39562 | 1021 | 194.686709 | 1987.75129889 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 102 | 1.09e-21 | NR | WAE42931.1 | 2748378 | g29195 | i0 | 37 | 0.484818805093046 | 165 | 102 | 48.2 | 2 | 460 | 951 | 52 | 215 | WAE42931.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 495 | 102 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27070682 | 27070682 | PRJNA1148190_P_NODE_160042_length_416_cov_1.460641_g148875_i0 | PRJNA1148190 | 160042 | 416 | 1.460641 | 6.07626656 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 137 | 8.14e-37 | NR | AYP28862.1 | 2748378 | g148875 | i0 | 48.2 | 2.01923076923077 | 141 | 69 | 99.5 | 3 | 2 | 415 | 13 | 152 | AYP28862.1 MAG: putative viral replication protein [Cressdnaviricota sp.] | diamond | 840 | 137 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27513538 | 27513538 | PRJNA1148190_P_NODE_386583_length_289_cov_1.222222_g375410_i0 | PRJNA1148190 | 386583 | 289 | 1.222222 | 3.53222158 | Owegonang virus 1 | 3062879 | Viruses | Viruses | 48.9 | 3.33e-4 | NR | WPR18645.1 | 3063439 | g375410 | i0 | 55.3 | 0.487889273356401 | 47 | 21 | 48.8 | 0 | 287 | 147 | 189 | 235 | WPR18645.1 MAG: hypothetical protein [Owegonang virus 10] | diamond | 141 | 48.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Owegonang virus 10 | ||||||
| 27987526 | 27987526 | PRJNA1148190_P_NODE_60185_length_740_cov_1.508246_g49194_i0 | PRJNA1148190 | 60185 | 740 | 1.508246 | 11.1610204 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 87.8 | 1.14e-16 | NR | UOF83117.1 | 2748378 | g49194 | i0 | 50.6 | 0.632432432432432 | 79 | 38 | 31.6 | 1 | 737 | 504 | 181 | 259 | UOF83117.1 rep protein [Cressdnaviricota sp.] | diamond | 468 | 87.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 28366000 | 28366000 | PRJNA1148190_P_NODE_500206_length_266_cov_2.383420_g489033_i0 | PRJNA1148190 | 500206 | 266 | 2.38342 | 6.3398972 | Giardia-associated CRESS DNA virus 1 | 2766565 | Viruses | Viruses | 85.9 | 1.4e-17 | NR | QNJ47546.1 | 2766565 | g489033 | i0 | 61.3 | 0.699248120300752 | 62 | 19 | 64.3 | 2 | 96 | 266 | 1 | 62 | QNJ47546.1 replication-associated protein [Giardia-associated CRESS DNA virus 1] | diamond | 186 | 85.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Vilyaviridae | Herugrimvirus | Herugrimvirus gladden | ||
| 28586781 | 28586781 | PRJNA1148190_P_NODE_168967_length_405_cov_26.728916_g157798_i0 | PRJNA1148190 | 168967 | 405 | 26.728916 | 108.2521098 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 50.8 | 2.06e-4 | NR | WAE43266.1 | 2748378 | g157798 | i0 | 34.8 | 0.511111111111111 | 69 | 45 | 51.1 | 0 | 214 | 8 | 45 | 113 | WAE43266.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 207 | 50.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 28681836 | 28681836 | PRJNA1148190_P_NODE_330767_length_307_cov_3.598291_g319594_i0 | PRJNA1148190 | 330767 | 307 | 3.598291 | 11.04675337 | Kummerowia striata CRESS virus | 2740167 | Viruses | Viruses | 121 | 1.9499999999999999e-31 | NR | QKI29027.1 | 2740167 | g319594 | i0 | 63.9 | 0.811074918566775 | 83 | 30 | 81.1 | 0 | 3 | 251 | 179 | 261 | QKI29027.1 Cap [Kummerowia striata CRESS virus] | diamond | 249 | 121 | 1 | Viruses | CRESS viruses | Shotokuvirae | Cressdnaviricota | Kummerowia striata CRESS virus | |||||
| 28903256 | 28903256 | PRJNA1148190_P_NODE_8108_length_3878_cov_6.951380_g3997_i0 | PRJNA1148190 | 8108 | 3878 | 6.95138 | 269.5745164 | Chemarfal virus 2 | 3063483 | Viruses | Viruses | 294 | 1.58e-85 | NR | WPR18641.1 | 3063436 | g3997 | i0 | 48.3 | 0.459515214027849 | 290 | 146 | 22.3 | 3 | 589 | 1452 | 53 | 340 | WPR18641.1 MAG: replication polyprotein [Chemarfal virus 204] | diamond | 1782 | 294 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Chemarfal virus 204 | ||||||
| 29155285 | 29155285 | PRJNA1148190_P_NODE_205029_length_372_cov_2.655518_g193859_i0 | PRJNA1148190 | 205029 | 372 | 2.655518 | 9.87852696 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 110 | 1.21e-26 | NR | AYP28862.1 | 2748378 | g193859 | i0 | 43.8 | 0.903225806451613 | 112 | 62 | 89.5 | 1 | 3 | 335 | 91 | 202 | AYP28862.1 MAG: putative viral replication protein [Cressdnaviricota sp.] | diamond | 336 | 110 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29313671 | 29313671 | PRJNA1148190_P_NODE_658849_length_247_cov_1.252874_g647676_i0 | PRJNA1148190 | 658849 | 247 | 1.252874 | 3.09459878 | Circoviridae sp. | 1954248 | Viruses | Viruses | 53.5 | 5.06e-6 | NR | AYP28888.1 | 1954248 | g647676 | i0 | 45.3 | 1.21457489878543 | 53 | 29 | 64.4 | 0 | 11 | 169 | 214 | 266 | AYP28888.1 MAG: helicase [Circoviridae sp.] | diamond | 300 | 53.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 30007860 | 30007860 | PRJNA1148190_P_NODE_252511_length_342_cov_1.297398_g241341_i0 | PRJNA1148190 | 252511 | 342 | 1.297398 | 4.43710116 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 163 | 6.92e-47 | NR | WAE42405.1 | 2748378 | g241341 | i0 | 68.8 | 0.842105263157895 | 96 | 30 | 84.2 | 0 | 1 | 288 | 223 | 318 | WAE42405.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 288 | 163 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 30103100 | 30103100 | PRJNA1148190_P_NODE_70652_length_662_cov_2.526316_g59567_i0 | PRJNA1148190 | 70652 | 662 | 2.526316 | 16.72421192 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 72.8 | 2.94e-11 | NR | AYP28862.1 | 2748378 | g59567 | i0 | 44.2 | 0.348942598187311 | 77 | 42 | 34.4 | 1 | 228 | 1 | 91 | 167 | AYP28862.1 MAG: putative viral replication protein [Cressdnaviricota sp.] | diamond | 231 | 72.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 30545158 | 30545158 | PRJNA1148190_P_NODE_43413_length_949_cov_2.028539_g32852_i0 | PRJNA1148190 | 43413 | 949 | 2.028539 | 19.25083511 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 204 | 4.27e-60 | NR | AYP28862.1 | 2748378 | g32852 | i0 | 44.8 | 1.536354056902 | 239 | 128 | 75.2 | 4 | 925 | 212 | 27 | 262 | AYP28862.1 MAG: putative viral replication protein [Cressdnaviricota sp.] | diamond | 1458 | 204 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 30861289 | 30861289 | PRJNA1148190_P_NODE_53974_length_801_cov_1.802198_g43088_i0 | PRJNA1148190 | 53974 | 801 | 1.802198 | 14.43560598 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 104 | 4.559999999999999e-23 | NR | WAE42931.1 | 2748378 | g43088 | i0 | 37.3 | 1.27340823970037 | 161 | 98 | 59.6 | 3 | 731 | 255 | 57 | 216 | WAE42931.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 1020 | 104 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 31492909 | 31492909 | PRJNA1148190_P_NODE_127856_length_466_cov_1.585242_g116693_i0 | PRJNA1148190 | 127856 | 466 | 1.585242 | 7.38722772 | Cressvirus molossus2668 | 3116682 | Viruses | Viruses | 81.6 | 7.55e-15 | NR | DBA49913.1 | 3116682 | g116693 | i0 | 37.6 | 0.701716738197425 | 109 | 62 | 70.2 | 2 | 127 | 453 | 76 | 178 | DBA49913.1 MAG TPA_asm: Rep [Cressvirus molossus2668] | diamond | 327 | 81.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressvirus molossus2668 | ||||||
| 32031738 | 32031738 | PRJNA1148190_P_NODE_76858_length_627_cov_3.460289_g65746_i0 | PRJNA1148190 | 76858 | 627 | 3.460289 | 21.69601203 | Cressvirus molossus2668 | 3116682 | Viruses | Viruses | 84 | 5.13e-15 | NR | DBA49913.1 | 3116682 | g65746 | i0 | 29.8 | 0.803827751196172 | 168 | 88 | 73.2 | 4 | 567 | 109 | 101 | 253 | DBA49913.1 MAG TPA_asm: Rep [Cressvirus molossus2668] | diamond | 504 | 84 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressvirus molossus2668 | ||||||
| 32347892 | 32347892 | PRJNA1148190_P_NODE_531159_length_260_cov_2.390374_g519986_i0 | PRJNA1148190 | 531159 | 260 | 2.390374 | 6.2149724 | Cressvirus molossus2668 | 3116682 | Viruses | Viruses | 61.2 | 1.33e-8 | NR | DBA49913.1 | 3116682 | g519986 | i0 | 36.7 | 1.81153846153846 | 79 | 48 | 91.2 | 1 | 241 | 5 | 93 | 169 | DBA49913.1 MAG TPA_asm: Rep [Cressvirus molossus2668] | diamond | 471 | 61.2 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressvirus molossus2668 | ||||||
| 32569280 | 32569280 | PRJNA1148190_P_NODE_465399_length_273_cov_1.550000_g454226_i0 | PRJNA1148190 | 465399 | 273 | 1.55 | 4.2315 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 55.5 | 1.73e-6 | NR | XNT20790.1 | 2748378 | g454226 | i0 | 52.9 | 0.56043956043956 | 51 | 23 | 56 | 1 | 155 | 3 | 353 | 402 | XNT20790.1 MAG: Rep protein [Cressdnaviricota sp.] | diamond | 153 | 55.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 32851916 | 32851916 | PRJNA1148190_P_NODE_220200_length_361_cov_1.916667_g209030_i0 | PRJNA1148190 | 220200 | 361 | 1.916667 | 6.91916787 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 49.3 | 6.3e-4 | NR | WAE43004.1 | 2748378 | g209030 | i0 | 21.8 | 1.96952908587258 | 119 | 64 | 98.9 | 2 | 359 | 3 | 170 | 259 | WAE43004.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 711 | 49.3 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. |
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);;