contig_metadata
6 rows where bioproject = "PRJNA964500", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6045093 | 6045093 | PRJNA964500_S_NODE_905_length_457_cov_12.439252_g817_i0 | PRJNA964500 | 905 | 457 | 12.439252 | 56.84738164 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 627 | 5.789999999999998e-175 | NTclustered | gi|659103923|gb|KJ569725.1| | 1512276 | g817 | i0 | 91.416 | 44.7549234135667 | 466 | 26 | 100 | 11 | 1 | 457 | 1044 | 584 | Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence | blastn | 20453 | 627 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 13695478 | 13695478 | PRJNA964500_S_NODE_2751_length_310_cov_9.793594_g2659_i0 | PRJNA964500 | 2751 | 310 | 9.793594 | 30.3601414 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 460 | 4.06e-125 | NTclustered | gi|659103927|gb|KJ569727.1| | 1512276 | g2659 | i0 | 94.649 | 27.1064516129032 | 299 | 12 | 95 | 3 | 12 | 306 | 1432 | 1730 | Cochliopodium kieliense clone 9611 18S ribosomal RNA gene, partial sequence | blastn | 8403 | 460 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 17519862 | 17519862 | PRJNA964500_S_NODE_16534_length_153_cov_16.564516_g16442_i0 | PRJNA964500 | 16534 | 153 | 16.564516 | 25.34370948 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 233 | 4.17e-57 | NTclustered | gi|659103923|gb|KJ569725.1| | 1512276 | g16442 | i0 | 94.156 | 46.0457516339869 | 154 | 7 | 100 | 2 | 1 | 153 | 422 | 574 | Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence | blastn | 7045 | 233 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 17519866 | 17519866 | PRJNA964500_S_NODE_1694_length_367_cov_57730.526627_g1602_i0 | PRJNA964500 | 1694 | 367 | 57730.526627 | 211871.03272109 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 377 | 5.06e-100 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g1602 | i0 | 92.251 | 244.065395095368 | 271 | 14 | 72 | 4 | 57 | 320 | 1720 | 1990 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 89572 | 377 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 22943236 | 22943236 | PRJNA964500_S_NODE_8138_length_203_cov_14.890805_g8046_i0 | PRJNA964500 | 8138 | 203 | 14.890805 | 30.22833415 | Cochliopodium | 313557 | Discosea | other_Eukaryota | 246 | 7.56e-61 | NTclustered | gi|59876024|gb|AY785057.1| | 313998 | g8046 | i0 | 97.902 | 46.8275862068966 | 143 | 2 | 70 | 1 | 27 | 169 | 452 | 593 | Cochliopodium sp. strain Kiel 18S ribosomal RNA gene, partial sequence | blastn | 9506 | 246 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium sp. strain Kiel | |||
| 25167994 | 25167994 | PRJNA964500_S_NODE_640_length_509_cov_19993.822917_g566_i0 | PRJNA964500 | 640 | 509 | 19993.822917 | 101768.55864753 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 669 | 0 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g566 | i0 | 96.135 | 112.194499017682 | 414 | 9 | 80 | 7 | 10 | 417 | 416 | 4 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 57107 | 669 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense |
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);;