contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2279678 | 2279678 | PRJNA1028258_P_NODE_123062_length_242_cov_1.144509_g122499_i0 | PRJNA1028258 | 123062 | 242 | 1.144509 | 2.76971178 | root | 1 | Root_unresolved | Root_unresolved | 448 | 2.3799999999999995e-121 | NTclustered | gi|2079660859|emb|OU501483.1| | 10515 | g122499 | i0 | 100 | 99.9917355371901 | 242 | 0 | 100 | 0 | 1 | 242 | 607 | 848 | Human adenovirus 2 isolate ADVJA-78-BE genome assembly, chromosome: ADVJA-78-BE | blastn | 24198 | 448 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 2281597 | 2281597 | PRJNA1028258_P_NODE_89102_length_273_cov_1.387255_g88539_i0 | PRJNA1028258 | 89102 | 273 | 1.387255 | 3.78720615 | root | 1 | Root_unresolved | Root_unresolved | 505 | 1.6e-138 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g88539 | i0 | 100 | 99.978021978022 | 273 | 0 | 100 | 0 | 1 | 273 | 13914 | 13642 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 27294 | 505 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 3555510 | 3555510 | PRJNA1028258_P_NODE_169323_length_226_cov_769.980892_g168760_i0 | PRJNA1028258 | 169323 | 226 | 769.980892 | 1740.15681592 | root | 1 | Root_unresolved | Root_unresolved | 418 | 1.7199999999999998e-112 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g168760 | i0 | 100 | 100 | 226 | 0 | 100 | 0 | 1 | 226 | 15218 | 14993 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 22600 | 418 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 7384192 | 7384192 | PRJNA1028258_P_NODE_93446_length_267_cov_2.676768_g92883_i0 | PRJNA1028258 | 93446 | 267 | 2.676768 | 7.14697056 | root | 1 | Root_unresolved | Root_unresolved | 494 | 3.38e-135 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g92883 | i0 | 100 | 99.7677902621723 | 267 | 0 | 100 | 0 | 1 | 267 | 17096 | 17362 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 26638 | 494 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 8659433 | 8659433 | PRJNA1028258_P_NODE_82027_length_284_cov_91.353488_g81464_i0 | PRJNA1028258 | 82027 | 284 | 91.353488 | 259.44390592 | root | 1 | Root_unresolved | Root_unresolved | 525 | 1.2899999999999994e-144 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g81464 | i0 | 100 | 100 | 284 | 0 | 100 | 0 | 1 | 284 | 14732 | 15015 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 28400 | 525 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 9934098 | 9934098 | PRJNA1028258_P_NODE_64648_length_318_cov_1.353414_g64085_i0 | PRJNA1028258 | 64648 | 318 | 1.353414 | 4.30385652 | root | 1 | Root_unresolved | Root_unresolved | 577 | 3.9799999999999996e-160 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g64085 | i0 | 99.371 | 100 | 318 | 2 | 100 | 0 | 1 | 318 | 1736 | 2053 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 31800 | 582 | 0.991408934707904 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 9934497 | 9934497 | PRJNA1028258_P_NODE_87068_length_276_cov_1.966184_g86505_i0 | PRJNA1028258 | 87068 | 276 | 1.966184 | 5.42666784 | root | 1 | Root_unresolved | Root_unresolved | 510 | 3.48e-140 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g86505 | i0 | 100 | 100 | 276 | 0 | 100 | 0 | 1 | 276 | 18259 | 17984 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 27600 | 510 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 13759433 | 13759433 | PRJNA1028258_P_NODE_68691_length_309_cov_2.366667_g68128_i0 | PRJNA1028258 | 68691 | 309 | 2.366667 | 7.31300103 | root | 1 | Root_unresolved | Root_unresolved | 571 | 1.7899999999999995e-158 | NTclustered | gi|2079660852|emb|OU501478.1| | 10515 | g68128 | i0 | 100 | 100 | 309 | 0 | 100 | 0 | 1 | 309 | 11836 | 11528 | Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE | blastn | 30900 | 571 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15033186 | 15033186 | PRJNA1028258_P_NODE_41912_length_390_cov_153.096573_g41349_i0 | PRJNA1028258 | 41912 | 390 | 153.096573 | 597.0766347 | root | 1 | Root_unresolved | Root_unresolved | 704 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g41349 | i0 | 99.485 | 99.4871794871795 | 388 | 1 | 99 | 1 | 4 | 390 | 11154 | 11541 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 38800 | 710 | 0.991549295774648 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15033510 | 15033510 | PRJNA1028258_P_NODE_5912_length_994_cov_5.703784_g5578_i0 | PRJNA1028258 | 5912 | 994 | 5.703784 | 56.69561296 | root | 1 | Root_unresolved | Root_unresolved | 1814 | 0 | NTclustered | gi|2079660852|emb|OU501478.1| | 10515 | g5578 | i0 | 99.598 | 100.199195171026 | 996 | 0 | 100 | 3 | 1 | 994 | 12525 | 13518 | Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE | blastn | 99598 | 1814 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15034053 | 15034053 | PRJNA1028258_P_NODE_90232_length_271_cov_1.782178_g89669_i0 | PRJNA1028258 | 90232 | 271 | 1.782178 | 4.82970238 | root | 1 | Root_unresolved | Root_unresolved | 501 | 2.05e-137 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g89669 | i0 | 100 | 100 | 271 | 0 | 100 | 0 | 1 | 271 | 14441 | 14171 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 27100 | 501 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 16308878 | 16308878 | PRJNA1028258_P_NODE_93413_length_267_cov_5.020202_g92850_i0 | PRJNA1028258 | 93413 | 267 | 5.020202 | 13.40393934 | root | 1 | Root_unresolved | Root_unresolved | 494 | 3.38e-135 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g92850 | i0 | 100 | 100 | 267 | 0 | 100 | 0 | 1 | 267 | 12573 | 12307 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 26700 | 494 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 17582404 | 17582404 | PRJNA1028258_P_NODE_132274_length_235_cov_0.855422_g131711_i0 | PRJNA1028258 | 132274 | 235 | 0.855422 | 2.0102417 | root | 1 | Root_unresolved | Root_unresolved | 435 | 1.79e-117 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g131711 | i0 | 100 | 100 | 235 | 0 | 100 | 0 | 1 | 235 | 11104 | 10870 | Human adenovirus 2, complete genome | blastn | 23500 | 435 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 20130765 | 20130765 | PRJNA1028258_P_NODE_114656_length_248_cov_2.379888_g114093_i0 | PRJNA1028258 | 114656 | 248 | 2.379888 | 5.90212224 | Mastadenovirus | 10509 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g114093 | i0 | 100 | 100 | 248 | 0 | 100 | 0 | 1 | 248 | 16599 | 16846 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 24800 | 459 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 20131542 | 20131542 | PRJNA1028258_P_NODE_23036_length_530_cov_2.637744_g22479_i0 | PRJNA1028258 | 23036 | 530 | 2.637744 | 13.9800432 | root | 1 | Root_unresolved | Root_unresolved | 784 | 0 | NTclustered | gi|2616465679|gb|OR735196.1| | 10515 | g22479 | i0 | 99.766 | 93.777358490566 | 428 | 0 | 100 | 1 | 1 | 427 | 4014 | 3587 | Human adenovirus 2 isolate HAdV-C2/USA/11A6/2013, complete genome | blastn | 49702 | 784 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 20132640 | 20132640 | PRJNA1028258_P_NODE_79376_length_289_cov_2.231818_g78813_i0 | PRJNA1028258 | 79376 | 289 | 2.231818 | 6.44995402 | root | 1 | Root_unresolved | Root_unresolved | 534 | 2.18e-147 | NTclustered | gi|56160492|ref|AC_000007.1| | 10515 | g78813 | i0 | 100 | 100 | 289 | 0 | 100 | 0 | 1 | 289 | 11902 | 12190 | Human adenovirus 2, complete genome | blastn | 28900 | 534 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22681999 | 22681999 | PRJNA1028258_P_NODE_26838_length_490_cov_5.574822_g26278_i0 | PRJNA1028258 | 26838 | 490 | 5.574822 | 27.3166278 | root | 1 | Root_unresolved | Root_unresolved | 883 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g26278 | i0 | 99.184 | 99.9979591836735 | 490 | 4 | 100 | 0 | 1 | 490 | 16082 | 16571 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 48999 | 883 | 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);;