contig_metadata
11 rows where bioproject = "PRJNA385073", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1681332 | 1681332 | PRJNA385073_P_NODE_61862_length_230_cov_2.821656_g61700_i0 | PRJNA385073 | 61862 | 230 | 2.821656 | 6.4898088 | Tolivirales sp. | 2809914 | Viruses | Viruses | 279 | 8.65e-71 | NTclustered | gi|2647550049|gb|OR843807.1| | 2809914 | g61700 | i0 | 95.93 | 1.52173913043478 | 172 | 7 | 75 | 0 | 1 | 172 | 1985 | 2156 | Tolivirales sp. strain MR233-17E/8198 RNA-dependent RNA polymerase and hypothetical protein genes, partial cds | blastn | 350 | 279 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 2957358 | 2957358 | PRJNA385073_P_NODE_9923_length_408_cov_2.202985_g9762_i0 | PRJNA385073 | 9923 | 408 | 2.202985 | 8.9881788 | Beijing sediment noda-like virus 3 | 2824385 | Viruses | Viruses | 137 | 1.05e-27 | NTclustered | gi|2075443876|gb|MW897069.1| | 2824385 | g9762 | i0 | 85.606 | 0.323529411764706 | 132 | 17 | 32 | 2 | 220 | 349 | 3476 | 3345 | MAG: Beijing sediment noda-like virus 3 isolate 165-k141_17508 hypothetical protein gene, complete cds | blastn | 132 | 137 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Beijing sediment noda-like virus 3 | |||
| 4232905 | 4232905 | PRJNA385073_P_NODE_27644_length_286_cov_0.981221_g27482_i0 | PRJNA385073 | 27644 | 286 | 0.981221 | 2.80629206 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 512 | 1.01e-140 | NTclustered | gi|388240233|emb|HE818437.1| | 12242 | g27482 | i0 | 98.951 | 99.9965034965035 | 286 | 3 | 100 | 0 | 1 | 286 | 3494 | 3209 | Tobacco mosaic virus isolate Mangshi-2, complete genome | blastn | 28599 | 512 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 8059596 | 8059596 | PRJNA385073_P_NODE_53347_length_244_cov_0.900585_g53185_i0 | PRJNA385073 | 53347 | 244 | 0.900585 | 2.1974274 | Gammacarmovirus melonis | 3048200 | Viruses | Viruses | 429 | 8.699999999999998e-116 | NTclustered | gi|1695685772|gb|MK604924.1| | 11987 | g53185 | i0 | 98.361 | 36.7786885245902 | 244 | 4 | 100 | 0 | 1 | 244 | 1824 | 2067 | Melon necrotic spot virus isolate 3948, complete genome | blastn | 8974 | 429 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Gammacarmovirus | Gammacarmovirus melonis | ||
| 11279229 | 11279229 | PRJNA385073_P_NODE_19149_length_324_cov_0.920319_g18987_i0 | PRJNA385073 | 19149 | 324 | 0.920319 | 2.98183356 | Tobamovirus | 12234 | Viruses | Viruses | 584 | 2.429999999999999e-162 | NTclustered | gi|20177424|ref|NC_003630.1| | 12239 | g18987 | i0 | 99.381 | 94.4320987654321 | 323 | 1 | 99 | 1 | 2 | 324 | 4056 | 3735 | Pepper mild mottle virus, complete genome | blastn | 30596 | 584 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 16983040 | 16983040 | PRJNA385073_P_NODE_22114_length_309_cov_1.305085_g21952_i0 | PRJNA385073 | 22114 | 309 | 1.305085 | 4.03271265 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 571 | 1.7899999999999995e-158 | NTclustered | gi|388240233|emb|HE818437.1| | 12242 | g21952 | i0 | 100 | 100 | 309 | 0 | 100 | 0 | 1 | 309 | 3916 | 4224 | Tobacco mosaic virus isolate Mangshi-2, complete genome | blastn | 30900 | 571 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 16983503 | 16983503 | PRJNA385073_P_NODE_4254_length_570_cov_1.068410_g4098_i0 | PRJNA385073 | 4254 | 570 | 1.06841 | 6.089937 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 1053 | 0 | NTclustered | gi|348605458|gb|JF920727.1| | 12242 | g4098 | i0 | 100 | 99.978947368421 | 570 | 0 | 100 | 0 | 1 | 570 | 5193 | 5762 | Tobacco mosaic virus isolate Shanxi, complete genome | blastn | 56988 | 1053 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 18257756 | 18257756 | PRJNA385073_P_NODE_49055_length_247_cov_0.885057_g48893_i0 | PRJNA385073 | 49055 | 247 | 0.885057 | 2.18609079 | Lentinula edodes deltaflexivirus 2 | 2778980 | Viruses | Viruses | 329 | 9.21e-86 | NTclustered | gi|1928162793|gb|MN744724.1| | 2778980 | g48893 | i0 | 90.688 | 1 | 247 | 23 | 100 | 0 | 1 | 247 | 4653 | 4407 | Lentinula edodes deltaflexivirus 2 isolate Le10WIL RNA-dependent RNA polymerase gene, partial cds; and hypothetical protein gene, complete cds | blastn | 247 | 329 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Lentinula edodes deltaflexivirus 2 | |||
| 18927627 | 18927627 | PRJNA385073_P_NODE_27155_length_287_cov_1.439252_g26993_i0 | PRJNA385073 | 27155 | 287 | 1.439252 | 4.13065324 | Tobamovirus | 12234 | Viruses | Viruses | 531 | 2.799999999999999e-146 | NTclustered | gi|2327914667|gb|OM366242.1| | 12242 | g26993 | i0 | 100 | 99.9581881533101 | 287 | 0 | 100 | 0 | 1 | 287 | 114 | 400 | Tobacco mosaic virus isolate Yunnanwenshan replicase protein gene, complete cds | blastn | 28688 | 531 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 20807430 | 20807430 | PRJNA385073_P_NODE_31277_length_275_cov_2.029703_g31115_i0 | PRJNA385073 | 31277 | 275 | 2.029703 | 5.58168325 | Divavirus alphadiuris | 3428303 | Viruses | Viruses | 65.8 | 3.25e-6 | NTclustered | gi|410428375|ref|NC_019029.1| | 1247115 | g31115 | i0 | 91.489 | 0.341818181818182 | 47 | 4 | 17 | 0 | 229 | 275 | 6769 | 6815 | Diuris virus A isolate SW3.3, complete genome | blastn | 94 | 65.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Divavirus | Divavirus alphadiuris | ||
| 30043537 | 30043537 | PRJNA385073_P_NODE_64111_length_211_cov_4.572464_g63949_i0 | PRJNA385073 | 64111 | 211 | 4.572464 | 9.64789904 | Lentinula edodes deltaflexivirus 2 | 2778980 | Viruses | Viruses | 131 | 1.72e-33 | NR | QOX06049.1 | 2778980 | g63949 | i0 | 95.7 | 0.981042654028436 | 69 | 3 | 98.1 | 0 | 209 | 3 | 1023 | 1091 | QOX06049.1 RNA-dependent RNA polymerase, partial [Lentinula edodes deltaflexivirus 2] | diamond | 207 | 131 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Lentinula edodes deltaflexivirus 2 |
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);;