contig_metadata
4 rows where bioproject = "PRJNA1240805", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8002743 | 8002743 | PRJNA1240805_P_NODE_3587_length_244_cov_2.825641_g3538_i0 | PRJNA1240805 | 3587 | 244 | 2.825641 | 6.89456404 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 307 | 4.25e-79 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g3538 | i0 | 90.213 | 82.266393442623 | 235 | 23 | 96 | 0 | 10 | 244 | 2171 | 2405 | Vannella septentrionalis 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 | 20073 | 307 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 13803912 | 13803912 | PRJNA1240805_P_NODE_4371_length_219_cov_4.970588_g4322_i0 | PRJNA1240805 | 4371 | 219 | 4.970588 | 10.88558772 | Cochliopodium | 313557 | Discosea | other_Eukaryota | 152 | 1.8599999999999998e-32 | NTclustered | gi|861554067|gb|KP719191.1| | 1678068 | g4322 | i0 | 96.703 | 39.310502283105 | 91 | 3 | 42 | 0 | 26 | 116 | 366 | 456 | Cochliopodium sp. JvW-2015 strain A1HEB clone 1 small subunit ribosomal RNA gene, partial sequence | blastn | 8609 | 152 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium sp. JvW-2015 | |||
| 24575800 | 24575800 | PRJNA1240805_P_NODE_6940_length_174_cov_3.720000_g6891_i0 | PRJNA1240805 | 6940 | 174 | 3.72 | 6.4728 | Cochliopodium actinophorum | 703021 | Discosea | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|330902844|gb|JF298248.1| | 703021 | g6891 | i0 | 88.889 | 1.20114942528736 | 45 | 4 | 25 | 1 | 128 | 171 | 251 | 295 | Cochliopodium actinophorum clone 1206 18S ribosomal RNA gene, partial sequence | blastn | 209 | 54.7 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium actinophorum | |||
| 29694193 | 29694193 | PRJNA1240805_P_NODE_4270_length_222_cov_2.086705_g4221_i0 | PRJNA1240805 | 4270 | 222 | 2.086705 | 4.6324851 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 85.5 | 7.34e-18 | NR | XP_004344643.1 | 1257118 | g4221 | i0 | 72.5 | 0.689189189189189 | 51 | 14 | 68.9 | 0 | 200 | 48 | 252 | 302 | XP_004344643.1 MC family transporter: phosphate, putative [Acanthamoeba castellanii str. Neff] | diamond | 153 | 85.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;