contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA688931" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668450 | 668450 | PRJNA688931_P_NODE_20141_length_228_cov_1.413408_g19928_i0 | PRJNA688931 | 20141 | 228 | 1.413408 | 3.22257024 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 176 | 1.16e-39 | NTclustered | gi|470241101|ref|XM_004352074.1| | 261658 | g19928 | i0 | 87.919 | 70.2456140350877 | 149 | 18 | 65 | 0 | 80 | 228 | 2483 | 2335 | Cavenderia fasciculata RNA polymerase II largest subunit (rpb1), partial mRNA | blastn | 16016 | 176 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 7047149 | 7047149 | PRJNA688931_P_NODE_32946_length_175_cov_2.214286_g32733_i0 | PRJNA688931 | 32946 | 175 | 2.214286 | 3.8750005 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 115 | 1.85e-21 | NTclustered | gi|831756695|ref|XM_012893348.1| | 1410327 | g32733 | i0 | 80.667 | 0.857142857142857 | 150 | 27 | 85 | 2 | 3 | 151 | 182 | 34 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 150 | 115 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 8321685 | 8321685 | PRJNA688931_P_NODE_34767_length_170_cov_1.272727_g34554_i0 | PRJNA688931 | 34767 | 170 | 1.272727 | 2.1636359 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 84.2 | 5.04e-12 | NTclustered | gi|831776054|ref|XM_012899232.1| | 1410327 | g34554 | i0 | 82.796 | 0.729411764705882 | 93 | 16 | 55 | 0 | 10 | 102 | 1161 | 1253 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 124 | 84.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 12147734 | 12147734 | PRJNA688931_P_NODE_15890_length_258_cov_1.923445_g15677_i0 | PRJNA688931 | 15890 | 258 | 1.923445 | 4.9624881 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 128 | 3.79e-25 | NTclustered | gi|831792076|ref|XM_012904471.1| | 1410327 | g15677 | i0 | 86.066 | 0.89922480620155 | 122 | 13 | 47 | 2 | 1 | 120 | 1524 | 1643 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 232 | 128 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 15971213 | 15971213 | PRJNA688931_P_NODE_27493_length_194_cov_1.779310_g27280_i0 | PRJNA688931 | 27493 | 194 | 1.77931 | 3.4518614 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1160560456|ref|XM_020578332.1| | 670386 | g27280 | i0 | 96.875 | 0.164948453608247 | 32 | 1 | 16 | 0 | 78 | 109 | 1361 | 1330 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 24894859 | 24894859 | PRJNA688931_P_NODE_6380_length_433_cov_2.067708_g6167_i0 | PRJNA688931 | 6380 | 433 | 2.067708 | 8.95317564 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 54.7 | 0.012 | NTclustered | gi|831783851|ref|XM_012901808.1| | 1410327 | g6167 | i0 | 96.875 | 0.0739030023094688 | 32 | 1 | 7 | 0 | 257 | 288 | 146 | 115 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;