contig_metadata
13 rows where analysis = "blastn" and tax_clade = "named eukaryotic clones"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 170984 | 170984 | PRJNA1041773_P_NODE_87861_length_246_cov_4.023121_g87528_i0 | PRJNA1041773 | 87861 | 246 | 4.023121 | 9.89687766 | uncultured eukaryote HF0200_37F04 | 542502 | Root_unresolved | Root_unresolved | 396 | 8.909999999999996e-106 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g87528 | i0 | 95.902 | 100.069105691057 | 244 | 10 | 99 | 0 | 3 | 246 | 3247 | 3004 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 24617 | 396 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 988815 | 988815 | PRJEB3181_P_NODE_16241_length_207_cov_19.767045_g15977_i0 | PRJEB3181 | 16241 | 207 | 19.767045 | 40.91778315 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.7 | 2.99e-10 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g15977 | i0 | 97.778 | 13.3333333333333 | 45 | 1 | 22 | 0 | 1 | 45 | 3041 | 3085 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 2760 | 78.7 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 1151348 | 1151348 | PRJNA630162_P_NODE_20821_length_404_cov_164.228169_g19304_i0 | PRJNA630162 | 20821 | 404 | 164.228169 | 663.48180276 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 529 | 1.4699999999999996e-145 | NTclustered | gi|14579477|gb|AF363207.1| | 162600 | g19304 | i0 | 90.418 | 100.113861386139 | 407 | 32 | 99 | 5 | 1 | 402 | 598 | 1002 | Eukaryote marine clone ME1-24 clone ME1-24 18S ribosomal RNA gene, partial sequence | blastn | 40446 | 529 | 1 | Eukaryota | named eukaryotic clones | eukaryote marine clone ME1-24 | |||||||
| 3702786 | 3702786 | PRJNA630162_P_NODE_119523_length_174_cov_4.280000_g118000_i0 | PRJNA630162 | 119523 | 174 | 4.28 | 7.4472 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 187 | 3.85e-43 | NTclustered | gi|14579475|gb|AF363205.1| | 162566 | g118000 | i0 | 94.355 | 73.8850574712644 | 124 | 4 | 70 | 3 | 2 | 122 | 479 | 356 | Eukaryote marine clone ANT37-13 clone ANT37-13 18S ribosomal RNA gene, partial sequence | blastn | 12856 | 187 | 1 | Eukaryota | named eukaryotic clones | eukaryote marine clone ANT37-13 | |||||||
| 3953276 | 3953276 | PRJEB64798_P_NODE_155084_length_186_cov_1.503650_g153318_i0 | PRJEB64798 | 155084 | 186 | 1.50365 | 2.796789 | uncultured eukaryote HF0200_37F04 | 542502 | Root_unresolved | Root_unresolved | 80.5 | 7.29e-11 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g153318 | i0 | 89.231 | 42.3010752688172 | 65 | 5 | 35 | 2 | 91 | 155 | 3455 | 3517 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 7868 | 80.5 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 3997600 | 3997600 | PRJNA1041773_P_NODE_99604_length_242_cov_0.804734_g99271_i0 | PRJNA1041773 | 99604 | 242 | 0.804734 | 1.94745628 | uncultured eukaryote HF0200_37F04 | 542502 | Root_unresolved | Root_unresolved | 346 | 8.930000000000001e-91 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g99271 | i0 | 95.023 | 101.392561983471 | 221 | 9 | 91 | 2 | 23 | 242 | 3925 | 3706 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 24537 | 346 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 5087845 | 5087845 | PRJNA944406_P_NODE_72324_length_249_cov_0.875000_g71365_i0 | PRJNA944406 | 72324 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 69.4 | 2.24e-7 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g71365 | i0 | 100 | 7.18473895582329 | 37 | 0 | 15 | 0 | 3 | 39 | 3049 | 3085 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 1789 | 69.4 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 5272670 | 5272670 | PRJNA1041773_P_NODE_103185_length_235_cov_4.740741_g102852_i0 | PRJNA1041773 | 103185 | 235 | 4.740741 | 11.14074135 | uncultured eukaryote HF0200_37F04 | 542502 | Root_unresolved | Root_unresolved | 106 | 1.59e-18 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g102852 | i0 | 95.522 | 1.62127659574468 | 67 | 1 | 28 | 2 | 1 | 66 | 4648 | 4583 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 381 | 106 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 10079794 | 10079794 | PRJNA630162_P_NODE_18268_length_435_cov_6.601036_g16758_i0 | PRJNA630162 | 18268 | 435 | 6.601036 | 28.7145066 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.042 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g16758 | i0 | 100 | 0.257471264367816 | 28 | 0 | 6 | 0 | 85 | 112 | 3303 | 3330 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 112 | 52.8 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 13668287 | 13668287 | PRJNA939370_S_NODE_211_length_581_cov_18.877820_g164_i0 | PRJNA939370 | 211 | 581 | 18.87782 | 109.6801342 | uncultured eukaryote HF0200_37F04 | 542502 | Root_unresolved | Root_unresolved | 174 | 1.17e-38 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g164 | i0 | 74.336 | 6.95697074010327 | 452 | 97 | 76 | 15 | 140 | 581 | 4106 | 3664 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 4042 | 174 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 17012716 | 17012716 | PRJNA438687_S_NODE_8034_length_152_cov_1.957265_g7944_i0 | PRJNA438687 | 8034 | 152 | 1.957265 | 2.9750428 | uncultured eukaryote HF0200_37F04 | 542502 | Root_unresolved | Root_unresolved | 80.5 | 5.7e-11 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g7944 | i0 | 89.231 | 50.3881578947368 | 65 | 5 | 43 | 2 | 83 | 147 | 3517 | 3455 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 7659 | 80.5 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 23861462 | 23861462 | PRJNA929952_P_NODE_20759_length_198_cov_2.307692_g19465_i0 | PRJNA929952 | 20759 | 198 | 2.307692 | 4.56923016 | uncultured eukaryote HF0200_37F04 | 542502 | Root_unresolved | Root_unresolved | 128 | 2.77e-25 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g19465 | i0 | 79.082 | 46.6363636363636 | 196 | 33 | 98 | 6 | 5 | 198 | 3457 | 3646 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 9234 | 128 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 | |||||||
| 25337207 | 25337207 | PRJNA509429_P_NODE_47020_length_161_cov_1.000000_g46192_i0 | PRJNA509429 | 47020 | 161 | 1 | 1.61 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|193084614|gb|EU795185.1| | 542502 | g46192 | i0 | 100 | 0.695652173913043 | 28 | 0 | 17 | 0 | 56 | 83 | 3330 | 3303 | Uncultured eukaryote HF0200_37F04 genomic sequence | blastn | 112 | 52.8 | 1 | Eukaryota | named eukaryotic clones | uncultured eukaryote HF0200_37F04 |
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);;