contig_metadata
6 rows where bioproject = "PRJEB30004", tax_clade = "Sar" and tax_phylum = "Oomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48970 | 48970 | PRJEB30004_P_NODE_573341_length_172_cov_3.962406_g557714_i0 | PRJEB30004 | 573341 | 172 | 3.962406 | 6.81533832 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 6.25e-51 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g557714 | i0 | 89.474 | 35.703488372093 | 171 | 14 | 98 | 4 | 4 | 172 | 1665 | 1497 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 6141 | 213 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 12467600 | 12467600 | PRJEB30004_P_NODE_219010_length_354_cov_8.155556_g203383_i0 | PRJEB30004 | 219010 | 354 | 8.155556 | 28.87066824 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 649 | 0 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g203383 | i0 | 99.718 | 99.861581920904 | 354 | 1 | 100 | 0 | 1 | 354 | 721 | 368 | Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 35351 | 654 | 0.992354740061162 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 16608919 | 16608919 | PRJEB30004_P_NODE_219034_length_354_cov_5.444444_g203407_i0 | PRJEB30004 | 219034 | 354 | 5.444444 | 19.27333176 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 638 | 2.02e-178 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g203407 | i0 | 99.153 | 101.635593220339 | 354 | 3 | 100 | 0 | 1 | 354 | 2508 | 2155 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 35979 | 638 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21390654 | 21390654 | PRJEB30004_P_NODE_244337_length_327_cov_2.479167_g228710_i0 | PRJEB30004 | 244337 | 327 | 2.479167 | 8.10687609 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 8.08e-43 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g228710 | i0 | 89.726 | 44.3547400611621 | 146 | 15 | 45 | 0 | 180 | 325 | 3464 | 3319 | P.megasperma gene for 28S ribosomal RNA | blastn | 14504 | 187 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 22997789 | 22997789 | PRJEB30004_P_NODE_508019_length_189_cov_1.846667_g492392_i0 | PRJEB30004 | 508019 | 189 | 1.846667 | 3.49020063 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 3.11e-84 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g492392 | i0 | 98.895 | 98.5132275132275 | 181 | 2 | 96 | 0 | 1 | 181 | 252 | 72 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 18619 | 324 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 30475742 | 30475742 | PRJEB30004_P_NODE_656433_length_156_cov_1.051282_g640806_i0 | PRJEB30004 | 656433 | 156 | 1.051282 | 1.63999992 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 7.48e-5 | NR | KAF0724015.1 | 100861 | g640806 | i0 | 57.6 | 4.55769230769231 | 33 | 14 | 63.5 | 0 | 101 | 3 | 993 | 1025 | KAF0724015.1 hypothetical protein Ae201684_017215 [Aphanomyces euteiches] | diamond | 711 | 49.3 | 0.991886409736308 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;