contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1103784" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 212130 | 212130 | PRJNA1103784_P_NODE_1801_length_388_cov_1.222222_g1746_i0 | PRJNA1103784 | 1801 | 388 | 1.222222 | 4.74222136 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 383 | 1.1599999999999998e-101 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g1746 | i0 | 90.847 | 28.6701030927835 | 295 | 13 | 73 | 9 | 104 | 388 | 1756 | 1466 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 11124 | 383 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 1486803 | 1486803 | PRJNA1103784_P_NODE_3582_length_292_cov_1.406393_g3527_i0 | PRJNA1103784 | 3582 | 292 | 1.406393 | 4.10666756 | Cribraria violacea | 1334538 | Evosea | other_Eukaryota | 265 | 3.19e-66 | NTclustered | gi|501417113|gb|JX481322.1| | 1334538 | g3527 | i0 | 84.815 | 79.208904109589 | 270 | 33 | 91 | 7 | 26 | 291 | 763 | 498 | Cribraria violacea voucher AMFD172 elongation factor 1A (EF1A) gene, partial cds | blastn | 23129 | 265 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Liceales | Cribrariaceae | Cribraria | Cribraria violacea | ||
| 2762789 | 2762789 | PRJNA1103784_P_NODE_1383_length_431_cov_1.407821_g1328_i0 | PRJNA1103784 | 1383 | 431 | 1.407821 | 6.06770851 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 326 | 2.22e-84 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g1328 | i0 | 87.671 | 8.67285382830626 | 292 | 21 | 67 | 12 | 1 | 288 | 284 | 4 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 3738 | 326 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 4038942 | 4038942 | PRJNA1103784_P_NODE_6984_length_245_cov_0.895349_g6929_i0 | PRJNA1103784 | 6984 | 245 | 0.895349 | 2.19360505 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 405 | 1.47e-108 | NTclustered | gi|330902895|gb|JF298272.1| | 313997 | g6929 | i0 | 96.708 | 63.0040816326531 | 243 | 8 | 99 | 0 | 3 | 245 | 774 | 532 | Cochliopodium minus clone 5207 actin gene, partial cds | blastn | 15436 | 405 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 7864813 | 7864813 | PRJNA1103784_P_NODE_2247_length_356_cov_11.038869_g2192_i0 | PRJNA1103784 | 2247 | 356 | 11.038869 | 39.29837364 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 556 | 5.86e-154 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g2192 | i0 | 95.506 | 100.120786516854 | 356 | 2 | 100 | 6 | 1 | 356 | 901 | 560 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 35643 | 556 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 11690895 | 11690895 | PRJNA1103784_P_NODE_90_length_1429_cov_3.897493_g64_i0 | PRJNA1103784 | 90 | 1429 | 3.897493 | 55.69517497 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 261 | 2.24e-64 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g64 | i0 | 76.493 | 21.4373687893632 | 536 | 92 | 37 | 27 | 145 | 671 | 1785 | 2295 | 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 | 30634 | 261 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 16789227 | 16789227 | PRJNA1103784_P_NODE_1974_length_373_cov_1.746667_g1919_i0 | PRJNA1103784 | 1974 | 373 | 1.746667 | 6.51506791 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 558 | 1.72e-154 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g1919 | i0 | 93.473 | 59.5120643431635 | 383 | 12 | 99 | 6 | 1 | 372 | 242 | 622 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 22198 | 558 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 16789341 | 16789341 | PRJNA1103784_P_NODE_914_length_515_cov_8.877828_g859_i0 | PRJNA1103784 | 914 | 515 | 8.877828 | 45.7208142 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 798 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g859 | i0 | 95.117 | 99.1980582524272 | 512 | 16 | 99 | 9 | 8 | 515 | 1 | 507 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 51087 | 798 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 |
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);;