RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA724011" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA724011 · 6 ✖

analysis 1

  • blastn · 6 ✖

tax_kingdom 0

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
3261754 3261754 PRJNA724011_P_NODE_1723_length_2115_cov_6.803624_g1473_i0 PRJNA724011 1723 2115 6.803624 143.8966476 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 1166 0   NTclustered gi|223997787|ref|XM_002288531.1| 296543 g1473 i0 78.738 53.3947990543735 1806 338 84 37 127 1909 64 1846 Thalassiosira pseudonana CCMP1335 heat shock protein/chaperone (hsp70_4), mRNA blastn 112930 1166 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
4539039 4539039 PRJNA724011_P_NODE_44564_length_393_cov_1.721875_g43541_i0 PRJNA724011 44564 393 1.721875 6.76696875 Proschkinia sp. SZCZR1824 2588390 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.72e-10   NTclustered gi|1681061561|gb|MH800316.1| 2588390 g43541 i0 76.433 1.76844783715013 157 31 39 6 82 236 4414 4566 Proschkinia sp. SZCZR1824 mitochondrion, complete genome blastn 695 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Proschkiniaceae Proschkinia Proschkinia sp. SZCZR1824
7089195 7089195 PRJNA724011_P_NODE_12026_length_895_cov_56.622871_g11145_i0 PRJNA724011 12026 895 56.622871 506.77469545 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 411 1.29e-109   NTclustered gi|657012367|gb|KF302531.1| 2850 g11145 i0 87.088 60.1184357541899 364 45 41 2 253 615 23 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 53806 411 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
10914686 10914686 PRJNA724011_P_NODE_45329_length_389_cov_1.462025_g44306_i0 PRJNA724011 45329 389 1.462025 5.68727725 Nitzschia traheaformis 1881117 SAR_Eukaryotes SAR_Eukaryotes 87.9 1.02e-12   NTclustered gi|2073953246|gb|MW849269.1| 1881117 g44306 i0 77.326 1.70694087403599 172 23 44 7 166 335 46645 46488 Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome blastn 664 87.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia traheaformis
12189897 12189897 PRJNA724011_P_NODE_35870_length_452_cov_2.079156_g34848_i0 PRJNA724011 35870 452 2.079156 9.39778512 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 255 3.11e-63   NTclustered gi|657012367|gb|KF302531.1| 2850 g34848 i0 89.268 64.3606194690265 205 20 45 2 15 218 213 10 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 29091 255 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
24937393 24937393 PRJNA724011_P_NODE_81360_length_274_cov_2.223881_g80337_i0 PRJNA724011 81360 274 2.223881 6.09343394 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 196 1.1e-45   NTclustered gi|657012367|gb|KF302531.1| 2850 g80337 i0 88.415 1.98905109489051 164 17 59 2 1 163 231 393 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 545 196 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;