contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA980839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8610671 | 8610671 | PRJNA980839_P_NODE_167247_length_272_cov_2.452261_g163463_i0 | PRJNA980839 | 167247 | 272 | 2.452261 | 6.67014992 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 492 | 1.24e-134 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g163463 | i0 | 99.265 | 99.1985294117647 | 272 | 2 | 100 | 0 | 1 | 272 | 1790 | 2061 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 26982 | 492 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 8613191 | 8613191 | PRJNA980839_P_NODE_76987_length_433_cov_2.700000_g73203_i0 | PRJNA980839 | 76987 | 433 | 2.7 | 11.691 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 745 | 0 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g73203 | i0 | 97.691 | 2.40184757505774 | 433 | 10 | 100 | 0 | 1 | 433 | 3281 | 3713 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 1040 | 745 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 11159842 | 11159842 | PRJNA980839_P_NODE_101229_length_359_cov_3.062937_g97445_i0 | PRJNA980839 | 101229 | 359 | 3.062937 | 10.99594383 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 619 | 7.429999999999999e-173 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g97445 | i0 | 97.772 | 99.9637883008357 | 359 | 8 | 100 | 0 | 1 | 359 | 1386 | 1744 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 35887 | 619 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 18812264 | 18812264 | PRJNA980839_P_NODE_87935_length_394_cov_2.267913_g84151_i0 | PRJNA980839 | 87935 | 394 | 2.267913 | 8.93557722 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 667 | 0 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g84151 | i0 | 97.208 | 97.4720812182741 | 394 | 11 | 100 | 0 | 1 | 394 | 2847 | 2454 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 38404 | 667 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 20084185 | 20084185 | PRJNA980839_P_NODE_162636_length_276_cov_1.733990_g158852_i0 | PRJNA980839 | 162636 | 276 | 1.73399 | 4.7858124 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 488 | 1.6299999999999995e-133 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g158852 | i0 | 98.551 | 105.836956521739 | 276 | 4 | 100 | 0 | 1 | 276 | 409 | 684 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 29211 | 488 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum |
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);;