contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 525381 | 525381 | PRJNA556992_P_NODE_204521_length_324_cov_17.725100_g202333_i0 | PRJNA556992 | 204521 | 324 | 17.7251 | 57.429324 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 573 | 5.249999999999999e-159 | NTclustered | gi|2756421318|gb|PP744651.1| | 2202565 | g202333 | i0 | 98.758 | 60.7561728395062 | 322 | 4 | 99 | 0 | 2 | 323 | 1937 | 1616 | MAG: Genomoviridae sp. isolate 171_3642 genomic sequence | blastn | 19685 | 573 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 3073391 | 3073391 | PRJNA556992_P_NODE_1056883_length_223_cov_4.746667_g1054693_i0 | PRJNA556992 | 1056883 | 223 | 4.746667 | 10.58506741 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 52.8 | 0.02 | NTclustered | gi|2896101054|gb|PQ792386.1| | 2748378 | g1054693 | i0 | 100 | 0.125560538116592 | 28 | 0 | 13 | 0 | 43 | 70 | 1198 | 1171 | MAG: Cressdnaviricota sp. isolate Splant072_cress9 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 3074088 | 3074088 | PRJNA556992_P_NODE_1113083_length_209_cov_11.522059_g1110892_i0 | PRJNA556992 | 1113083 | 209 | 11.522059 | 24.08110331 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 387 | 4.42e-103 | NTclustered | gi|2756421318|gb|PP744651.1| | 2202565 | g1110892 | i0 | 100 | 3.97607655502392 | 209 | 0 | 100 | 0 | 1 | 209 | 1266 | 1058 | MAG: Genomoviridae sp. isolate 171_3642 genomic sequence | blastn | 831 | 387 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 8177518 | 8177518 | PRJNA556992_P_NODE_159927_length_351_cov_2.766187_g157739_i0 | PRJNA556992 | 159927 | 351 | 2.766187 | 9.70931637 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 599 | 9.45e-167 | NTclustered | gi|2756421315|gb|PP744650.1| | 2202565 | g157739 | i0 | 97.199 | 3557.74358974359 | 357 | 4 | 100 | 1 | 1 | 351 | 1374 | 1730 | MAG: Genomoviridae sp. isolate 171_106887 genomic sequence | blastn | 1248768 | 599 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 10739652 | 10739652 | PRJNA556992_P_NODE_988529_length_231_cov_7.462025_g986339_i0 | PRJNA556992 | 988529 | 231 | 7.462025 | 17.23727775 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 427 | 2.9399999999999998e-115 | NTclustered | gi|2756421460|gb|PP744699.1| | 2202565 | g986339 | i0 | 100 | 54.6969696969697 | 231 | 0 | 100 | 0 | 1 | 231 | 1774 | 2004 | MAG: Genomoviridae sp. isolate 321_31078 genomic sequence | blastn | 12635 | 427 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 13276522 | 13276522 | PRJNA556992_P_NODE_10551_length_1023_cov_21.089474_g9067_i0 | PRJNA556992 | 10551 | 1023 | 21.089474 | 215.74531902 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 1410 | 0 | NTclustered | gi|2756421285|gb|PP744640.1| | 2202565 | g9067 | i0 | 100 | 49.6080156402737 | 763 | 0 | 100 | 0 | 261 | 1023 | 2200 | 1438 | MAG: Genomoviridae sp. isolate 128_116004 genomic sequence | blastn | 50749 | 1410 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 13281126 | 13281126 | PRJNA556992_P_NODE_315051_length_286_cov_8.319249_g312862_i0 | PRJNA556992 | 315051 | 286 | 8.319249 | 23.79305214 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 501 | 2.18e-137 | NTclustered | gi|2742830632|gb|PP793069.1| | 2202565 | g312862 | i0 | 98.252 | 2 | 286 | 5 | 100 | 0 | 1 | 286 | 409 | 124 | MAG: Genomoviridae sp. isolate 028_4104, partial genome | blastn | 572 | 501 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 13879512 | 13879512 | PRJNA556992_P_NODE_24511_length_689_cov_4.285714_g22495_i0 | PRJNA556992 | 24511 | 689 | 4.285714 | 29.52856946 | Genomoviridae | 1910928 | Viruses | Viruses | 1251 | 0 | NTclustered | gi|2080100107|gb|MZ244272.1| | 1983771 | g22495 | i0 | 99.419 | 31.088534107402 | 689 | 4 | 100 | 0 | 1 | 689 | 1732 | 1044 | MAG: Gemycircularvirus sp. isolate 336genomoc1, complete genome | blastn | 21420 | 1256 | 0.996019108280255 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Gemycircularvirus | Gemycircularvirus sp. | ||
| 14554620 | 14554620 | PRJNA556992_P_NODE_215952_length_318_cov_25.983673_g213764_i0 | PRJNA556992 | 215952 | 318 | 25.983673 | 82.62808014 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 579 | 1.1099999999999996e-160 | NTclustered | gi|2756421318|gb|PP744651.1| | 2202565 | g213764 | i0 | 99.684 | 3.90880503144654 | 316 | 1 | 99 | 0 | 1 | 316 | 690 | 1005 | MAG: Genomoviridae sp. isolate 171_3642 genomic sequence | blastn | 1243 | 579 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 16429980 | 16429980 | PRJNA556992_P_NODE_71033_length_451_cov_20.973545_g68858_i0 | PRJNA556992 | 71033 | 451 | 20.973545 | 94.59068795 | Gemykibivirus | 1941236 | Viruses | Viruses | 811 | 0 | NTclustered | gi|745699253|gb|KP133078.1| | 1588761 | g68858 | i0 | 99.113 | 31.9866962305987 | 451 | 4 | 100 | 0 | 1 | 451 | 1076 | 1526 | Gemycircularvirus BZ1, complete genome | blastn | 14426 | 811 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Gemykibivirus | Gemykibivirus humas2 | ||
| 17100823 | 17100823 | PRJNA556992_P_NODE_1115214_length_209_cov_5.375000_g1113023_i0 | PRJNA556992 | 1115214 | 209 | 5.375 | 11.23375 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 237 | 4.71e-58 | NTclustered | gi|2756421318|gb|PP744651.1| | 2202565 | g1113023 | i0 | 96.503 | 2.22488038277512 | 143 | 5 | 100 | 0 | 1 | 143 | 143 | 1 | MAG: Genomoviridae sp. isolate 171_3642 genomic sequence | blastn | 465 | 237 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 17108764 | 17108764 | PRJNA556992_P_NODE_627454_length_256_cov_5.693989_g625265_i0 | PRJNA556992 | 627454 | 256 | 5.693989 | 14.57661184 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 468 | 1.95e-127 | NTclustered | gi|2756421460|gb|PP744699.1| | 2202565 | g625265 | i0 | 99.609 | 7.80859375 | 256 | 1 | 100 | 0 | 1 | 256 | 1347 | 1092 | MAG: Genomoviridae sp. isolate 321_31078 genomic sequence | blastn | 1999 | 468 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 20251234 | 20251234 | PRJNA556992_P_NODE_1135396_length_204_cov_14.389313_g1133205_i0 | PRJNA556992 | 1135396 | 204 | 14.389313 | 29.35419852 | Arfiviricetes | 2732423 | Viruses | Viruses | 377 | 2.59e-100 | NTclustered | gi|2626080284|gb|OR270688.1| | 1954248 | g1133205 | i0 | 100 | 6 | 204 | 0 | 100 | 0 | 1 | 204 | 1029 | 826 | MAG: Circoviridae sp. isolate GL83, complete genome | blastn | 1224 | 377 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 22803839 | 22803839 | PRJNA556992_P_NODE_552918_length_262_cov_23.047619_g550729_i0 | PRJNA556992 | 552918 | 262 | 23.047619 | 60.38476178 | Gemykibivirus | 1941236 | Viruses | Viruses | 483 | 7.149999999999997e-132 | NTclustered | gi|745699259|gb|KP133080.1| | 1588763 | g550729 | i0 | 100 | 31.706106870229 | 261 | 0 | 99 | 0 | 1 | 261 | 118 | 378 | Gemycircularvirus NP, complete genome | blastn | 8307 | 483 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Gemykibivirus | Gemykibivirus humas2 | ||
| 24761283 | 24761283 | PRJNA556992_P_NODE_949240_length_235_cov_11.969136_g947050_i0 | PRJNA556992 | 949240 | 235 | 11.969136 | 28.1274696 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 435 | 1.79e-117 | NTclustered | gi|2756421460|gb|PP744699.1| | 2202565 | g947050 | i0 | 100 | 37.1446808510638 | 235 | 0 | 100 | 0 | 1 | 235 | 1547 | 1781 | MAG: Genomoviridae sp. isolate 321_31078 genomic sequence | blastn | 8729 | 435 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae 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);;