contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJEB43370" and tax_phylum = "Heterolobosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5162478 | 5162478 | PRJEB43370_P_NODE_10505_length_163_cov_0.912281_g10462_i0 | PRJEB43370 | 10505 | 163 | 0.912281 | 1.48701803 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 296 | 5.68e-76 | NTclustered | gi|290971318|ref|XM_002668414.1| | 5762 | g10462 | i0 | 99.387 | 42.9325153374233 | 163 | 1 | 100 | 0 | 1 | 163 | 581 | 419 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_61055), partial mRNA | blastn | 6998 | 296 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 6438399 | 6438399 | PRJEB43370_P_NODE_9666_length_164_cov_1.539130_g9623_i0 | PRJEB43370 | 9666 | 164 | 1.53913 | 2.5241732 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 226 | 7.619999999999998e-55 | NTclustered | gi|290986441|ref|XM_002675887.1| | 5762 | g9623 | i0 | 91.463 | 1 | 164 | 14 | 100 | 0 | 1 | 164 | 771 | 934 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_58349), partial mRNA | blastn | 164 | 226 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 11538414 | 11538414 | PRJEB43370_P_NODE_4950_length_203_cov_1.350649_g4907_i0 | PRJEB43370 | 4950 | 203 | 1.350649 | 2.74181747 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 305 | 1.23e-78 | NTclustered | gi|290990585|ref|XM_002677871.1| | 5762 | g4907 | i0 | 95.312 | 3.6551724137931 | 192 | 9 | 95 | 0 | 1 | 192 | 297 | 106 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_33131), partial mRNA | blastn | 742 | 305 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 20461018 | 20461018 | PRJEB43370_P_NODE_1957_length_311_cov_2.343511_g1914_i0 | PRJEB43370 | 1957 | 311 | 2.343511 | 7.28831921 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 165 | 3.58e-36 | NTclustered | gi|290976481|ref|XM_002670923.1| | 5762 | g1914 | i0 | 78.113 | 44.8553054662379 | 265 | 55 | 85 | 3 | 45 | 307 | 691 | 954 | Naegleria gruberi aconitase (NAEGRDRAFT_59586), mRNA | blastn | 13950 | 165 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 20461082 | 20461082 | PRJEB43370_P_NODE_9697_length_164_cov_1.356522_g9654_i0 | PRJEB43370 | 9697 | 164 | 1.356522 | 2.22469608 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 183 | 4.65e-42 | NTclustered | gi|2119417997|ref|XM_044688418.1| | 51637 | g9654 | i0 | 89.116 | 0.896341463414634 | 147 | 16 | 90 | 0 | 1 | 147 | 147 | 1 | Naegleria lovaniensis uncharacterized protein (C9374_012630), partial mRNA | blastn | 147 | 183 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis |
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);;