contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA728642" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9641549 | 9641549 | PRJNA728642_P_NODE_9248_length_334_cov_2.624521_g8977_i0 | PRJNA728642 | 9248 | 334 | 2.624521 | 8.76590014 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 531 | 3.32e-146 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g8977 | i0 | 95.252 | 101.835329341317 | 337 | 12 | 100 | 3 | 1 | 334 | 12 | 347 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 34013 | 531 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 10917086 | 10917086 | PRJNA728642_P_NODE_9109_length_337_cov_1.166667_g8838_i0 | PRJNA728642 | 9109 | 337 | 1.166667 | 3.93166779 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 75 | 6.79e-9 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g8838 | i0 | 79.279 | 3.29376854599407 | 111 | 20 | 33 | 2 | 1 | 111 | 9694 | 9587 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 1110 | 75 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 24939442 | 24939442 | PRJNA728642_P_NODE_8040_length_360_cov_1.202091_g7769_i0 | PRJNA728642 | 8040 | 360 | 1.202091 | 4.3275276 | Ripella platypodia | 2047821 | Discosea | other_Eukaryota | 542 | 1.66e-149 | NTclustered | gi|1269228348|gb|MF683473.1| | 2047821 | g7769 | i0 | 93.939 | 100.836111111111 | 363 | 15 | 100 | 7 | 1 | 360 | 1175 | 1533 | Ripella platypodia clone 21702 18S ribosomal RNA gene, partial sequence | blastn | 36301 | 542 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia |
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);;