contig_metadata
7 rows where bioproject = "PRJNA352850" and tax_phylum = "Bacillariophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8049795 | 8049795 | PRJNA352850_P_NODE_71107_length_266_cov_1.820276_g68274_i0 | PRJNA352850 | 71107 | 266 | 1.820276 | 4.84193416 | Craticula sp. RGastineau-2025a | 3393937 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 3.08e-16 | NTclustered | gi|2906190882|gb|PV031684.1| | 3393937 | g68274 | i0 | 83.636 | 69.1390977443609 | 110 | 13 | 41 | 5 | 55 | 162 | 55120 | 55014 | Craticula sp. RGastineau-2025a strain SZCZEY2171 mitochondrion, complete genome | blastn | 18391 | 99 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Stauroneidaceae | Craticula | Craticula sp. RGastineau-2025a | ||
| 18247899 | 18247899 | PRJNA352850_P_NODE_61255_length_295_cov_2.439024_g58422_i0 | PRJNA352850 | 61255 | 295 | 2.439024 | 7.1951208 | Eunotia naegelii | 1458866 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 7.4e-23 | NTclustered | gi|1418586621|ref|NC_037987.1| | 1458866 | g58422 | i0 | 78.191 | 4.45084745762712 | 188 | 41 | 64 | 0 | 19 | 206 | 5727 | 5914 | Eunotia naegelii strain UTEX FD354 mitochondrion, complete genome | blastn | 1313 | 121 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Eunotiales | Eunotiaceae | Eunotia | Eunotia naegelii | ||
| 20796527 | 20796527 | PRJNA352850_P_NODE_24677_length_559_cov_9.488235_g21861_i0 | PRJNA352850 | 24677 | 559 | 9.488235 | 53.03923365 | Entomoneis sp. | 186043 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 3.13e-39 | NTclustered | gi|1372147530|gb|MF997419.1| | 186043 | g21861 | i0 | 74.444 | 14.6100178890877 | 450 | 95 | 79 | 18 | 66 | 508 | 21256 | 21692 | Entomoneis sp. mitochondrion, complete genome | blastn | 8167 | 176 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Entomoneidaceae | Entomoneis | Entomoneis sp. | |||
| 28306548 | 28306548 | PRJNA352850_P_NODE_10886_length_1016_cov_4.389866_g8531_i0 | PRJNA352850 | 10886 | 1016 | 4.389866 | 44.60103856 | Skeletonema marinoi | 267567 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 1.4e-5 | NR | KAK1739246.1 | 267567 | g8531 | i0 | 32.3 | 0.56988188976378 | 96 | 63 | 28.1 | 2 | 380 | 96 | 450 | 544 | KAK1739246.1 DnaJ domain-containing protein [Skeletonema marinoi] | diamond | 579 | 59.3 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Skeletonemataceae | Skeletonema | Skeletonema marinoi | ||
| 28748549 | 28748549 | PRJNA352850_P_NODE_62707_length_290_cov_2.489627_g59874_i0 | PRJNA352850 | 62707 | 290 | 2.489627 | 7.2199183 | Thalassiosira oceanica | 159749 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 3.81e-20 | NR | EJK48333.1 | 159749 | g59874 | i0 | 66.7 | 3.17586206896552 | 69 | 23 | 71.4 | 0 | 5 | 211 | 72 | 140 | EJK48333.1 hypothetical protein THAOC_32880, partial [Thalassiosira oceanica] | diamond | 921 | 89.4 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Thalassiosiraceae | Thalassiosira | Thalassiosira oceanica | ||
| 31988492 | 31988492 | PRJNA352850_P_NODE_24558_length_561_cov_4.990234_g21743_i0 | PRJNA352850 | 24558 | 561 | 4.990234 | 27.99521274 | Phaeodactylum | 2849 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.92e-93 | NR | ACS35537.1 | 2850 | g21743 | i0 | 79 | 1.98930481283422 | 186 | 38 | 99.5 | 1 | 3 | 560 | 108 | 292 | ACS35537.1 myosin A [Phaeodactylum tricornutum] | diamond | 1116 | 303 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 32494990 | 32494990 | PRJNA352850_P_NODE_64439_length_285_cov_1.533898_g61606_i0 | PRJNA352850 | 64439 | 285 | 1.533898 | 4.3716093 | Bacillariophyceae | 33849 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.2e-29 | NR | GAX21982.1 | 1519565 | g61606 | i0 | 62 | 1.94736842105263 | 92 | 35 | 96.8 | 0 | 281 | 6 | 45 | 136 | GAX21982.1 large subunit ribosomal protein L7e [Fistulifera solaris] | diamond | 555 | 115 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Fistulifera | Fistulifera solaris |
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);;