contig_metadata
18 rows where bioproject = "PRJNA1123686" and tax_phylum = "Preplasmiviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1030078 | 1030078 | PRJNA1123686_S_NODE_21_length_962_cov_24.359057_g17_i0 | PRJNA1123686 | 21 | 962 | 24.359057 | 234.33412834 | root | 1 | Root_unresolved | Root_unresolved | 1768 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g17 | i0 | 100 | 99.4802494802495 | 957 | 0 | 99 | 0 | 6 | 962 | 15223 | 14267 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 95700 | 1768 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 1030084 | 1030084 | PRJNA1123686_S_NODE_4361_length_237_cov_18.197115_g4329_i0 | PRJNA1123686 | 4361 | 237 | 18.197115 | 43.12716255 | root | 1 | Root_unresolved | Root_unresolved | 416 | 6.5499999999999985e-112 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g4329 | i0 | 98.312 | 100 | 237 | 4 | 100 | 0 | 1 | 237 | 13665 | 13429 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 23700 | 416 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 2305371 | 2305371 | PRJNA1123686_S_NODE_22_length_962_cov_16.849946_g17_i1 | PRJNA1123686 | 22 | 962 | 16.849946 | 162.09648052 | root | 1 | Root_unresolved | Root_unresolved | 1724 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g17 | i1 | 99.164 | 99.4802494802495 | 957 | 8 | 99 | 0 | 6 | 962 | 15223 | 14267 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 95700 | 1724 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 3580669 | 3580669 | PRJNA1123686_S_NODE_17723_length_160_cov_2.366412_g17691_i0 | PRJNA1123686 | 17723 | 160 | 2.366412 | 3.7862592 | root | 1 | Root_unresolved | Root_unresolved | 279 | 5.59e-71 | NTclustered | gi|2079660852|emb|OU501478.1| | 10515 | g17691 | i0 | 98.125 | 100 | 160 | 3 | 100 | 0 | 1 | 160 | 17862 | 18021 | Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE | blastn | 16000 | 279 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 4858086 | 4858086 | PRJNA1123686_S_NODE_3084_length_258_cov_6.550218_g3052_i0 | PRJNA1123686 | 3084 | 258 | 6.550218 | 16.89956244 | root | 1 | Root_unresolved | Root_unresolved | 455 | 1.53e-123 | NTclustered | gi|2079660852|emb|OU501478.1| | 10515 | g3052 | i0 | 98.462 | 100.77519379845 | 260 | 0 | 100 | 3 | 1 | 258 | 12785 | 12528 | Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE | blastn | 26000 | 455 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 6132960 | 6132960 | PRJNA1123686_S_NODE_25_length_940_cov_34.566411_g19_i0 | PRJNA1123686 | 25 | 940 | 34.566411 | 324.9242634 | root | 1 | Root_unresolved | Root_unresolved | 1548 | 0 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g19 | i0 | 100 | 93.9936170212766 | 838 | 0 | 93 | 0 | 103 | 940 | 11507 | 12344 | Human adenovirus 2, complete genome | blastn | 88354 | 1548 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 6132965 | 6132965 | PRJNA1123686_S_NODE_7485_length_205_cov_14.909091_g7453_i0 | PRJNA1123686 | 7485 | 205 | 14.909091 | 30.56363655 | root | 1 | Root_unresolved | Root_unresolved | 333 | 5.709999999999999e-87 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g7453 | i0 | 99.454 | 86.5560975609756 | 183 | 1 | 89 | 0 | 1 | 183 | 14239 | 14057 | Human adenovirus 2, complete genome | blastn | 17744 | 333 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 8683243 | 8683243 | PRJNA1123686_S_NODE_2987_length_260_cov_10.246753_g2955_i0 | PRJNA1123686 | 2987 | 260 | 10.246753 | 26.6415578 | root | 1 | Root_unresolved | Root_unresolved | 481 | 2.55e-131 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g2955 | i0 | 100 | 100 | 260 | 0 | 100 | 0 | 1 | 260 | 18340 | 18599 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 26000 | 481 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 9958196 | 9958196 | PRJNA1123686_S_NODE_2228_length_278_cov_7.610442_g2196_i0 | PRJNA1123686 | 2228 | 278 | 7.610442 | 21.15702876 | root | 1 | Root_unresolved | Root_unresolved | 505 | 1.63e-138 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g2196 | i0 | 100 | 98.2014388489209 | 273 | 0 | 98 | 0 | 1 | 273 | 13212 | 13484 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 27300 | 505 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 11233471 | 11233471 | PRJNA1123686_S_NODE_169_length_501_cov_20.044492_g144_i0 | PRJNA1123686 | 169 | 501 | 20.044492 | 100.42290492 | root | 1 | Root_unresolved | Root_unresolved | 926 | 0 | NTclustered | gi|2079660852|emb|OU501478.1| | 10515 | g144 | i0 | 100 | 100.001996007984 | 501 | 0 | 100 | 0 | 1 | 501 | 15891 | 15391 | Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE | blastn | 50101 | 926 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 12508826 | 12508826 | PRJNA1123686_S_NODE_5690_length_222_cov_6.797927_g5658_i0 | PRJNA1123686 | 5690 | 222 | 6.797927 | 15.09139794 | root | 1 | Root_unresolved | Root_unresolved | 411 | 2.8199999999999996e-110 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g5658 | i0 | 100 | 100 | 222 | 0 | 100 | 0 | 1 | 222 | 12971 | 13192 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 22200 | 411 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15057750 | 15057750 | PRJNA1123686_S_NODE_152_length_514_cov_42.593814_g129_i0 | PRJNA1123686 | 152 | 514 | 42.593814 | 218.93220396 | Mastadenovirus | 10509 | Viruses | Viruses | 933 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g129 | i0 | 99.416 | 100.046692607004 | 514 | 3 | 100 | 0 | 1 | 514 | 16940 | 16427 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 51424 | 933 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 16332488 | 16332488 | PRJNA1123686_S_NODE_1273_length_316_cov_47.268293_g1241_i0 | PRJNA1123686 | 1273 | 316 | 47.268293 | 149.36780588 | root | 1 | Root_unresolved | Root_unresolved | 584 | 2.359999999999999e-162 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g1241 | i0 | 100 | 99.9905063291139 | 316 | 0 | 100 | 0 | 1 | 316 | 18051 | 18366 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 31597 | 584 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 16332495 | 16332495 | PRJNA1123686_S_NODE_20013_length_154_cov_5.328000_g19981_i0 | PRJNA1123686 | 20013 | 154 | 5.328 | 8.20512 | root | 1 | Root_unresolved | Root_unresolved | 285 | 1.14e-72 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g19981 | i0 | 100 | 100 | 154 | 0 | 100 | 0 | 1 | 154 | 12998 | 12845 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 15400 | 285 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 16332505 | 16332505 | PRJNA1123686_S_NODE_8173_length_200_cov_7.356725_g8141_i0 | PRJNA1123686 | 8173 | 200 | 7.356725 | 14.71345 | root | 1 | Root_unresolved | Root_unresolved | 348 | 1.98e-91 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g8141 | i0 | 100 | 94 | 188 | 0 | 94 | 0 | 13 | 200 | 12581 | 12394 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 18800 | 348 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 17607784 | 17607784 | PRJNA1123686_S_NODE_154_length_510_cov_29.056133_g131_i0 | PRJNA1123686 | 154 | 510 | 29.056133 | 148.1862783 | root | 1 | Root_unresolved | Root_unresolved | 942 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g131 | i0 | 100 | 100 | 510 | 0 | 100 | 0 | 1 | 510 | 17020 | 17529 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 51000 | 942 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 23982328 | 23982328 | PRJNA1123686_S_NODE_1219_length_320_cov_18.185567_g1187_i0 | PRJNA1123686 | 1219 | 320 | 18.185567 | 58.1938144 | root | 1 | Root_unresolved | Root_unresolved | 568 | 2.4099999999999993e-157 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g1187 | i0 | 99.677 | 96.871875 | 310 | 1 | 97 | 0 | 11 | 320 | 14064 | 13755 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 30999 | 568 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 25256413 | 25256413 | PRJNA1123686_S_NODE_3180_length_256_cov_15.766520_g3148_i0 | PRJNA1123686 | 3180 | 256 | 15.76652 | 40.3622912 | root | 1 | Root_unresolved | Root_unresolved | 420 | 5.54e-113 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g3148 | i0 | 100 | 88.66015625 | 227 | 0 | 89 | 0 | 30 | 256 | 15205 | 15431 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 22697 | 420 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari |
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);;