contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA734348" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2472780 | 2472780 | PRJNA734348_P_NODE_6362_length_1022_cov_3.752371_g5861_i0 | PRJNA734348 | 6362 | 1022 | 3.752371 | 38.34923162 | Capillidium | 2878381 | Fungi | Fungi | 941 | 0 | NTclustered | gi|2273784342|ref|NC_064684.1| | 181046 | g5861 | i0 | 83.554 | 15.4902152641879 | 1058 | 121 | 99 | 26 | 12 | 1022 | 2956 | 4007 | Conidiobolus rhysosporus strain ATCC 12588 mitochondrion, complete genome | blastn | 15831 | 950 | 0.990526315789474 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium rhysosporum | |
| 8371203 | 8371203 | PRJNA734348_P_NODE_27487_length_371_cov_3.090604_g26792_i0 | PRJNA734348 | 27487 | 371 | 3.090604 | 11.46614084 | Capillidium rhysosporum | 181046 | Fungi | Fungi | 320 | 8.76e-83 | NTclustered | gi|2273784342|ref|NC_064684.1| | 181046 | g26792 | i0 | 83.379 | 13.633423180593 | 367 | 40 | 96 | 12 | 14 | 369 | 5487 | 5843 | Conidiobolus rhysosporus strain ATCC 12588 mitochondrion, complete genome | blastn | 5058 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium rhysosporum | |
| 10125418 | 10125418 | PRJNA734348_P_NODE_113988_length_245_cov_3.145349_g113290_i0 | PRJNA734348 | 113988 | 245 | 3.145349 | 7.70610505 | Capillidium | 2878381 | Fungi | Fungi | 183 | 7.519999999999998e-42 | NTclustered | gi|2273784342|ref|NC_064684.1| | 181046 | g113290 | i0 | 90.78 | 5.26122448979592 | 141 | 8 | 56 | 2 | 97 | 232 | 4202 | 4062 | Conidiobolus rhysosporus strain ATCC 12588 mitochondrion, complete genome | blastn | 1289 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium rhysosporum | |
| 10923024 | 10923024 | PRJNA734348_P_NODE_8989_length_805_cov_2.259563_g8392_i0 | PRJNA734348 | 8989 | 805 | 2.259563 | 18.18948215 | Neoconidiobolus thromboides | 76012 | Fungi | Fungi | 566 | 2.34e-156 | NTclustered | gi|2032035963|gb|MW795364.1| | 76012 | g8392 | i0 | 80.17 | 23.7714285714286 | 822 | 110 | 98 | 31 | 1 | 792 | 157 | 955 | Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome | blastn | 19136 | 566 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 13472852 | 13472852 | PRJNA734348_P_NODE_84431_length_257_cov_1.255435_g83733_i0 | PRJNA734348 | 84431 | 257 | 1.255435 | 3.22646795 | Entomophthora schizophorae | 76013 | Fungi | Fungi | 93.5 | 1.38e-14 | NTclustered | gi|94983494|gb|DQ481220.1| | 76013 | g83733 | i0 | 91.304 | 1.07392996108949 | 69 | 4 | 26 | 2 | 43 | 110 | 1032 | 1099 | Entomophthora schizophorae isolate ARSEF 6137 5.8S ribosomal RNA gene, partial sequence; and internal transcribed spacer 2, complete sequence | blastn | 276 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora schizophorae | |
| 14746912 | 14746912 | PRJNA734348_P_NODE_30752_length_350_cov_5.758123_g30056_i0 | PRJNA734348 | 30752 | 350 | 5.758123 | 20.1534305 | Neoconidiobolus thromboides | 76012 | Fungi | Fungi | 416 | 1.02e-111 | NTclustered | gi|2032035963|gb|MW795364.1| | 76012 | g30056 | i0 | 90.735 | 57.3628571428571 | 313 | 28 | 89 | 1 | 37 | 348 | 34308 | 34620 | Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome | blastn | 20077 | 416 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 14746989 | 14746989 | PRJNA734348_P_NODE_34132_length_333_cov_3.538462_g33436_i0 | PRJNA734348 | 34132 | 333 | 3.538462 | 11.78307846 | Neoconidiobolus thromboides | 76012 | Fungi | Fungi | 202 | 2.94e-47 | NTclustered | gi|2032035963|gb|MW795364.1| | 76012 | g33436 | i0 | 98.261 | 5.04204204204204 | 115 | 2 | 35 | 0 | 219 | 333 | 34102 | 33988 | Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome | blastn | 1679 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 18568677 | 18568677 | PRJNA734348_P_NODE_10975_length_697_cov_120.126603_g10336_i0 | PRJNA734348 | 10975 | 697 | 120.126603 | 837.28242291 | Entomophthora muscae | 34485 | Fungi | Fungi | 937 | 0 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g10336 | i0 | 90.987 | 70.8479196556671 | 699 | 57 | 100 | 5 | 1 | 697 | 706 | 12 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 49381 | 937 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae |
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);;